Skip to content

simonw/sqlite-utils-plugins

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 

Repository files navigation

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.

About

A plugin directory for sqlite-utils

Resources

Stars

Watchers

Forks

Sponsor this project