Import SQLite databases into Arctype and browse them visually
Choose SQLite as the Connection and import a .db file
Chose a .db or other SQLite file
Choose SQLite as a new connection option in Arctype. Then name your connection and select Choose SQLite File to open a file browser to your machine. Locate a
.dbfile or other sqlite file and import it into Arctype. Note that this does not change its location on your machine, only tells Arctype where to read it.
Hit Save and start querying SQLite!
Create a new SQLite database directly in Arctype
You can also create brand new SQLite databases directly within Arctype. Choose +Create New and select the directory where your sqlite database should be located. Then give it a name which will be the name of the database file. In the image above, the filename will be
new-awesome-app.db. Hit Save and you can start creating tables and inserting rows right away!
One great workflow for quick data analysis is to create a new SQLite database and import a CSV of data into it. This enables you to go from spreadsheets to writing SQL in just a few clicks!
Right now syncing SQLite databases across workspaces is not supported. The connection, queries, and dashboards will still be synced but the
.dbfile must be sent separately. In the future this limitation will be removed and you can chat with us about it in the Arctype Discord.
SQLite is used extremely heavily in all types of software. Check out our blog post on how SQLite is used in Apple's iMessage.
SQLite is also found in MergeStat and this post describes interesting ways to track open source software projects.