Display SQL columns type in autocompletion dropdown

1

Hello,

I enabled SQL tables & columns autocompletion using this code snippet from StackOverflow, but how can I display columns type as shown in codemirror/CodeMirror#6331 ?

Thanks

2

That’s not something the core library provides. I assume that screenshot is from a setup that adds custom render methods to the completion options.

3

Thank you for answering,

Is there a tutorial explaining how to do that, or a code snippet that was used in the app shown in the screenshot ?

Additionally, would it be possible to :

  • automatically autocomplete when typing (e.g. following FROM, INTO, ALTER TABLE, AFTER)
  • directly autocompleting with column names after SELECT
    • if FROM (and JOIN) specified, using only column names from specified table(s)
    • if not, using all column names
  • autocomplete after FROM (and JOIN) using only table names containing specified columns between SELECT and FROM

Thanks

4

Hello ?​​​

5

Note that there’s no guarantee for getting free support here. Someone might take the time to help you, but you can’t always count on that.