Working with SQLite files

Why SQLite?

  • asynchronous support

  • file locking

  • on-the-fly sorting and retrieval

Working natively with SQLite files

$ sqlite3 globalAveAtmos.db
sqlite> .tables
area       long_name  t_ref      units
sqlite> select * from t_ref;
1850|286.584833368
1851|286.550367097
1852|286.545788813
...
2012|287.859330748
2013|287.992293218
2014|287.970241172