How to build a online SQL editor in Anvil?

Anvil Q&A
1

What I’m trying to do:
Build an online interface for SQL query to different databases with auto-completion, something like https://franchise.cloud/ but much simpler.

What I’ve tried and what’s not working:
I have tried to use React with monaco-editor, but has to spend too much time to learn. I like the online IDE on Anvil, does it also use monaco-editor?
Do you have any suggestion to add line number or auto completion in a TextArea as an online editor?

2

Hi, I have figured out how to use CodeMirror from Anvil Docs | Using JavaScript. And I am also trying to use Monaco Editor, but I don’t know the correct name to import from anvil.js.window. Is there a way to list all properties in anvil.js.window object?

3

Find the way to get attributes from anvil.js.window, but cannot load Monaco Editor
for att in dir(anvil.js.window):
print (att, getattr(anvil.js.window, att))

4

The ability to work with JavaScript using anvil.js.window may be limited by the documentation available for that JavaScript library.

If it helps here is an example of a minimal monaco editor that you might be able to adapt