GitHub - rogerbinns/apsw: Another Python SQLite wrapper

Posts and writings by Roger Binns

PyPI Download Stats

John Sullivan's personal website and blog.

I came across Better output from sqlite3 command line. His .sqliterc file did not work for me, but the simpler .mode "column" .headers on did work nicely. I also found out that brew install sqlite3 does not install the sqlite3 binary to $PATH, which stinks. The sqlite3 environment is still much less pleasant than the mysql cli. A few things on my wishlist: tab completion of tables, fields, keywords, and functions. nicer .schema output – I’ve just gotten really used to reading them in mysql output It sounds like maybe apsw can be something useful? Or maybe Navicat? (but that’s expensive)

Posts and writings by Roger Binns

I’ve started using the term HTML tools to refer to HTML applications that I’ve been building which combine HTML, JavaScript, and CSS in a single file and use them to …