Thu Sep 25 11:24:23 CEST 2014

Database workstation

Starting to like using sqlite to quickly whip up a database to do
certain simple queries.  One problem is microcontroller pin assignment
tracking.  Put all data in *.csv files, make one schema.sql file that has:

CREATE TABLE conn { ... }
.separator ","
.import conn.csv conn

Then create some reports:


And run it as:
sqlite3 --init schema.sql :memory:

No .sqlite file required.