Lite Queen goes Open-Source
Lite Queen is now fully open-sourced on Github.
Lite Queen is an open-source SQLite database management software that runs on your server.
What's new?
Lite Queen is now fully open-sourced on Github.
Setup is now simpler on the servers—We have some guides how to setup with Systemd, Docker and on Coolify with Docker Compose.
Revamped search experience.
We now have a side window pane with schema and index information of a table.
Refreshed homescreen.
You can now open the record row directly when viewing a linked record inside a foreign data hover card.
You now get more useful sql errors when doing any database operation.
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