Getting started with SQLite — Pros, cons, and tips

What is SQLite?

Pros of SQLite

SQLite version 3.8.10.2 2015-05-20 18:17:19
Enter “.help” for usage hints.
Connected to a transient in-memory database.
Use “.open FILENAME” to reopen on a persistent database.
sqlite> .separator ‘,’
sqlite> .import SQLite_Testdata.csv test
sqlite> select country, count(user_id) n from test group by country limit 5;
AU,2
FR,2
ID,2
IN,3
Sqlite>

Enabling clarity through business and technology solutions.