Table column information
- Added popover with information about the column definition and foreign key.
Lite Queen aspires to be the all-in-one app for your SQLite needs. Simply download the executable, run it, open the url on the browser and you're ready to go!
What's new?
Added a simple search. You can also access it opening God Mode or by pressing "s" when in table records page.
When editing a field with large contents, you can now use an adjustable text dialog for more space.
Added shortcut("n") to quickly open the window to add a new record.
You can navigate anywhere using a command menu when in god mode Cmd + K Quickly navigate to tables in your current database, other databases and more.
Added quick menu for updating the connection settings of a database.
When seeing the table records, the foreign key record popover triggers on click/touch instead of hover.
— Vik 💿 (@kivSegrob) February 26, 2024
We now have a God Mode(Cmd + K)! You can query your Sqlite databases with SQL and chat with it using plain English. It knows your database schema, indexes, triggers and other metadata in order to give you the most accurate and relevant answers.
It uses OpenAI ChatGPT so you can just bring your own API Key to get started—your API key and other info won't leave your computer/server as it's saved locally.
In the latest version of pic.twitter.com/UELg0xZThJ
— Vik 💿 (@kivSegrob) January 26, 2024
We can now execute sql code by hitting Cmd + K or clicking the button on the upper right corner. The query results are returned in Json.
Sql mode that returns results in json pic.twitter.com/fJLdHOFZXL
— Vik 💿 (@kivSegrob) December 24, 2023
Now when you hover a foreign key it loads the record in a popover as json
— Vik 💿 (@kivSegrob) December 23, 2023