SQLite Tool-set

This entry is part 5 of 5 in the series SQLite

Random list of very interesting projects (will be updated, guys).

I will add my own ideas/impression as soon as possible.

From simpler to more complex stuff:

  1. sqlite-utils is a rather useful tool for managing SQLite databases, importing structured data and manipulating them from the command line
  2. Litestream
    Litestream is a standalone streaming replication tool for SQLite. It runs as a background process and safely replicates changes incrementally to another file or S3. Litestream only communicates with SQLite through the SQLite API so it will not corrupt your database.
  3. Dqlite (distributed SQLite) extends SQLite across a cluster of machines, with automatic failover and high-availability to keep your application running. It uses C-Raft, an optimised Raft implementation in C, to gain high-performance transactional consensus and fault tolerance while preserving SQlite’s outstanding efficiency and tiny footprint.
  4. Xlite: Query Excel and Open Document spreadsheets as SQLite virtual tables
    A lot of tools, from plugin like Xlite to command line export tools.

Extra feature you can find useful:

  1. STRICT TABLES
    SQLite uses duck-typing and it is very “elastic” on typing. Anyway in the more recent versions you can enable a “STRICT” typing, which does not work on date types, but can help to avoid mixing integer, real and strings in the same column…. see https://www.sqlite.org/stricttables.html
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.