Autocomplete in SQL Editor?

[GalacticSun]

Hi there, I greatly appreciate SqliteStudio, thank you for creating it!

I have an idea for the SQL Editor. I'm curious if you would consider adding this functionality:
When writing some SQL in the SQL Editor, have autocomplete of what you're typing based on the tables and columns in the database you're working in.
For example, if you typed "select user_id from users where first_name = ..." etc, there would be a little dropdown or something that you could press Tab (or up/down key to select the desired option, then Tab), for autocompleting "user_id", "users", "first_name", etc.

Anyway, just an idea. Thanks again!

[pawelsalawa]

There is already an autocomplete - just as you described it. Use Ctrl+Space.

[GalacticSun]

Oh ok. Is there a way to remap those hotkeys or perhaps make it automatic (no hotkey needed, like in an IDE)? I have Ctrl-Space mapped to Ulauncher system-wide (I'm on Linux).

[pawelsalawa]

Yes, you can change this hotkey in the Configuration -> Keyboard shortcuts -> here look for "Request code assist"

It will also automatically pop up when you pause after typing a dot after table or database name, for example:

SELECT * FROM database_name.

or

SELECT table_name.

[GalacticSun]

Ah, very nice! Thanks again, Pawel.