simonw / sqlite-utils-plugins

A plugin directory for sqlite-utils

sqlite-utils plugins

A directory of plugins for sqlite-utils.

Here's how to build a sqlite-utils plugin. You can use this cookiecutter template to get started.

• sqlite-migrate is an experimental migrations system for managing database changes, built on top of sqlite-utils and applied using the sqlite-utils migrate command.
• sqlite-utils-dateutil adds date utility SQL functions, such as select dateutil_parse('3rd november').
• sqlite-utils-jq adds a jq(document, expression) SQL function for running jq programs against JSON documents directly in SQLite.
• sqlite-utils-litecli adds an interactive SQLite shell, started using sqlite-utils litecli data.db. This provides syntax highlighted SQL and auto-completion against keywords, table and column names plus other features provided by the litecli project.
• sqlite-utils-shell adds a more basic interactive SQLite shell, started using sqlite-utils shell for an in-memory database or sqlite-utils shell data.db to run against a database file.
• sqlite-utils-ml by Romain Clement adds a family of functions for training machine learning models and running predictions directly in SQLite.
• Alex Garcia released the following plugins for his family of SQLite extensions:
  • sqlite-utils-sqlite-regex
  • sqlite-utils-sqlite-path
  • sqlite-utils-sqlite-url
  • sqlite-utils-sqlite-ulid
  • sqlite-utils-sqlite-lines
  • sqlite-utils-sqlite-jsonschema
  • sqlite-utils-sqlite-tg - support for geospatial functions powered by TG
• sqlite-utils-fast-fks brings back the fast db.add_foreign_keys() method that directly manipulates the sqlite_master table and was removed in sqlite-utils 3.35, plus adds a sqlite-utils fast-fks command for executing that from the command-line.
• sqlite-utils-move-tables adds a sqlite-utils move-tables origin.db destination.db table1 table2 table3 command to sqlite-utils, for moving tables between databases.