SQLite

Choose SQLite as the Connection and import a .db file
Import Existing SQLite database
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 .db file 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
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!
How Sharing works with SQLite
Right now syncing SQLite databases across workspaces is not supported. The connection, queries, and dashboards will still be synced but the .db file 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 Examples
SQLite is used extremely heavily in all types of software. Check out our blog post on how SQLite is used in Apple's iMessage.
Analyzing iMessage with SQL
Arctype Blog
SQLite is also found in MergeStat and this post describes interesting ways to track open source software projects.
Querying Pull Request Data from Github
Arctype Blog

Connections - Previous

PostgreSQL

Next - Connections

MySQL

Last modified 2mo ago

Copy link

Contents

Import Existing SQLite database

Create a new SQLite database

How Sharing works with SQLite

SQLite Examples