SQLite is the most widely used database in the world. For many use cases, it may be the only database you will ever need. It’s not a toy database. Based on feedback from dozens of developers, you can now use SQLite with Arctype!
To use SQLite in Arctype, choose an existing SQLite file from your local filesystem and hit Save. You can then sort and filter data, write queries, and create charts - just like you can with Postgres, MySQL, and our other integrations. SQLite in Arctype is local only (we’ll add the ability to sync SQLite databases to the cloud in a future release).
You can also create new SQLite databases within Arctype. Click Create New on the Connection page and you can save a new SQLite file directly to your disk. Other SQLite features include editing schemas, inserting rows, or importing CSVs directly. Ready to get started with SQLite? Check out this article from Daniel Lifflander on the Arctype blog to see how you can use it to analyze your own iMessage history.
As always, please do not hesitate to give us feedback and submit feature requests on our Discord!
Version 0.9.52 Release Notes:
Improvements:
- Added SQLite support
- MySQL and PlanetScale tables get backticks in generated SQL
- Postgres and Yugabyte tables get double quotes in generated SQL
- Added database logos to connection lists
- Improved focusing behavior for query name modal
Bugfixes:
- Fixed a bug where SSH keys with passwords could interfere with other SSH connections
- Fixed a bug that caused the SQL review modal to appear incorrectly
- Fixed bugs related to component rendering, including dropdown padding and margin on some menus
- Fixed coloring issue with check constraint modal close button
- Fixed an issue related to new integrations being undefined
- Fixed a bug that caused errors when fetching table/view statements
