Lite queen

Lite QueenManage SQLite databases on your server with easeLite Queen is an open-source SQLite database management software that runs on your server.kivS/lite-queenSponsorDemoGuides/FAQ/Support/ Ruby on Rails versionGuidesWhat's new? Lite Queen is now included inside Coolify You can now host Lite Queen on Coolify with one click. Check the guide to get started. Added simple database backup functionality. Access it using ⌘ + K and writing "backup". Fixes Fixed issue with search filter losing focus on interaction Lite Queen goes Open-Source Lite Queen is now fully open-sourced on Github. Refreshed search experience, better errors and simpler setup Improvements 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. Others God mode is now renamed to Go Table column information Added popover with information about the column definition and foreign key. Simple search and data entry improvements Improvements 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. Fixes Fixed issue with updating database records where field names contain whitescapes Improved relationship viewer & mobile screens Improvements Table relationships viewer will now group the tables that are related close together. Improve fidelity of the UI in different screen types like phones and tablets . Use a more user-friendly count of table rows. eg: instead of "156432 rows" we now display "16k rows"(on hover you can still see the absolute count). Go anywhere and database connection settings Improvements 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. Fixes fixed issue with relative time ago datetime string not assuming UTC inside of the hovercard. Table relationship visualizer, selection for foreign key items, date utility & settings Improvements You can now visualize the relationships between the tables in your database; You can now have a select for foreign key fields with their corresponding data when adding or editing a record; You now have a button to quickly give your the formatted UTC date on datetime fields; Added settings page for OpenAI api keys and application label. — Vik 💿 (@kivSegrob) February 26, 2024 God Mode 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 Auto table ordering, manual app reload & feedback Improvements Lite-queen will now infer which table field is likely to be the datetime and sort the table in descending order; Added a footer menu with a way to navigate to the main screen, a way to send feedback by email and a way to hard refresh the app in case of issues. Improved caching on the demo instance. It's faster now. Demo mode, relative time in date fields & sticky headers Improvements Added a hosted demo version of lite-queen. Table field names are now sticky so context is not lost when scrolling large tables Added relative time difference on date-time fields. On hover they show up in a tooltip Sql query mode with json results 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 Load record from foreign key Now when you hover a foreign key it loads the record in a popover as json pic.twitter.com/y0VQ6jjqOG— Vik 💿 (@kivSegrob) December 23, 2023 Lift off! 🐣 pic.twitter.com/bBMIWlco5s— Vik 💿 (@kivSegrob) December 23, 2023 --- How to use Lite Queen on your server with Coolify: One-click installNov 11, 2024How to manage SQLite databases on a Linux server with Coolify and Lite QueenSep 25, 2024How to manage SQLite databases on a Linux Ubuntu server with Lite Queen and SystemdSep 25, 2024How to manage SQLite databases on a Linux Ubuntu server with Lite Queen and DockerSep 25, 2024 --- FAQWhat about my data, what do you do with it?Nothing! All the data is kept on your servers and nothing is sent outside nor used.You still have questions? Let's us know. --- All the postsHow to use Lite Queen on your server with Coolify: One-click installPublished on Nov 11, 2024As of Coolify v4.0.0-beta.361, Lite Queen is included as a service and be installed with one click. We can start by creating a new Resource and search for Litequeen: After that, we need to press on Edit Docker Compose and let Lite Queen know where your SQLite projects are located in your server filesystem For example, in my server I keep my project's files in /home/hellouser/www so let's map that into /www inside the Coolify container: - type: bind source: /home/hellouser/www target: /www is_directory: true This way if I have a SQLite database in /home/hellouser/www/project1/storage/production.sqlite3, in the Lite Queen application we can add the database by using /www/project1/storage/production.sqlite3. That's all you need, go ahead and deploy Lite Queen!