SQLite Functions for Working with JSON

1. oxide

   1 9 278 0.0 Rust

   :floppy_disk: Teach your PostgreSQL database how to speak MongoDB Wire Protocol

   I started working in a MongoDB wire protocol adapter layer to a PostgreSQL backend and it relies heavily on the use of JSON functions I was really wanting to also allow for SQLite as a backend but not sure if we can do everything that can be done in Postgres. If anyone want to take a look and colaborate on that, here’s a link to the project:

   https://oxidedb.com

   And a quick ui for a quick try:

   https://demo.oxidedb.com

2. CodeRabbit

   coderabbit.ai featured

   CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

   

3. txtai

   2 385 10,565 9.6 Python

   💡 All-in-one open-source embeddings database for semantic search, LLM orchestration and language model workflows

   

   The built-in JSON functionality is very powerful. txtai (https://github.com/neuml/txtai) takes full advantage of it and stores all relational data as JSON in SQLite.

   The ability to build indexes on these JSON function is important. Found this article to be a good reference: https://www.delphitools.info/2021/06/17/sqlite-as-a-no-sql-d...

4. sqlite-utils-jq

   3 2 8 3.7 Python

   Plugin adding a jq() SQL function to sqlite-utils

   

   Since SQLite supports custom SQL functions, you can add JQ support to it pretty easily.

   I just threw together a plugin for my sqlite-utils CLI tool that adds a jq() function here:

   https://github.com/simonw/sqlite-utils-jq

   Use it like this:

       sqlite-utils memory "select jq(:doc, :expr) as result" \

5. sqlite-utils-litecli

   4 1 12 5.0 Python

   Interactive shell for sqlite-utils using litecli

   

6. litecli

   5 5 2,940 9.0 Python

   CLI for SQLite Databases with auto-completion and syntax highlighting

   

   GitHub: https://github.com/dbcli/litecli

7. sqlite-utils

   6 37 1,779 7.1 Python

   Python CLI utility and library for manipulating SQLite databases

   

   I've baked a ton of different SQLite tricks - including things like full-text indexing support and advanced alter table methods - into my sqlite-utils CLI tool and Python library: https://sqlite-utils.datasette.io

   My Datasette project provides tools for exploring, analyzing and publishing SQLite databases, plus ways to expose them via a JSON API: https://datasette.io

   I've also written a ton of stuff about SQLite on my two blogs:

   - https://simonwillison.net/tags/sqlite/

   - https://til.simonwillison.net/sqlite

8. datasette

   7 194 9,866 8.7 Python

   An open source multi-tool for exploring and publishing data

   

   I've baked a ton of different SQLite tricks - including things like full-text indexing support and advanced alter table methods - into my sqlite-utils CLI tool and Python library: https://sqlite-utils.datasette.io

   My Datasette project provides tools for exploring, analyzing and publishing SQLite databases, plus ways to expose them via a JSON API: https://datasette.io

   I've also written a ton of stuff about SQLite on my two blogs:

   - https://simonwillison.net/tags/sqlite/

   - https://til.simonwillison.net/sqlite

9. SaaSHub

   www.saashub.com featured

   SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

   

10. pyjq

    8 1 197 0.0 Python

    A Python binding for ./jq

    

    It uses the libjq C library directly, integrating with it using Cython https://github.com/doloopwhile/pyjq/blob/master/_pyjq.pyx

11. sqlitebson

    9 2 11 3.5 C

    BSON extension for sqlite

    

Suggest a related project