sqlite-utils-jq

Plugin adding a jq() SQL function to sqlite-utils (by simonw)
Review Suggest topics
Source Code
sqlite-utils-jq Reviews
Suggest alternative
Edit details
Save 47% on cloud hosting with autoscaling that just works
Judoscale integrates with Django, FastAPI, Celery, and RQ to make autoscaling easy and reliable. Save big, and say goodbye to request timeouts and backed-up task queues.
judoscale.com
featured

Sqlite-utils-jq Alternatives

Similar projects and alternatives to sqlite-utils-jq

simonw
sqlite-utils-jq

  1. txtai

    385 sqlite-utils-jq VS txtai

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

  2. Judoscale

    Save 47% on cloud hosting with autoscaling that just works. Judoscale integrates with Django, FastAPI, Celery, and RQ to make autoscaling easy and reliable. Save big, and say goodbye to request timeouts and backed-up task queues.

    Judoscale logo

  3. datasette

    196 sqlite-utils-jq VS datasette

    An open source multi-tool for exploring and publishing data

  4. cloudquery

    102 sqlite-utils-jq VS cloudquery

    The developer first cloud governance platform

  5. grist-core

    62 sqlite-utils-jq VS grist-core

    Grist is the evolution of spreadsheets.

  6. sqlite-utils

    37 sqlite-utils-jq VS sqlite-utils

    Python CLI utility and library for manipulating SQLite databases

  7. datasette-app

    12 sqlite-utils-jq VS datasette-app

    The Datasette macOS application

  8. pyjq

    1 sqlite-utils-jq VS pyjq

    A Python binding for ./jq

  9. InfluxDB

    InfluxDB high-performance time series database. Collect, organize, and act on massive volumes of high-resolution data to power real-time intelligent systems.

    InfluxDB logo

  10. oxide

    9 sqlite-utils-jq VS oxide

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

  11. sqlitebson

    2 sqlite-utils-jq VS sqlitebson

    BSON extension for sqlite

  12. sqlite-utils-litecli

    1 sqlite-utils-jq VS sqlite-utils-litecli

    Interactive shell for sqlite-utils using litecli

  13. litecli

    5 sqlite-utils-jq VS litecli

    CLI for SQLite Databases with auto-completion and syntax highlighting

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better sqlite-utils-jq alternative or higher similarity.
Suggest an alternative to sqlite-utils-jq

sqlite-utils-jq discussion

Log in or Post with

sqlite-utils-jq reviews and mentions

Posts with mentions or reviews of sqlite-utils-jq. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-08-20.
  • Welcome to Datasette Cloud
    6 projects | news.ycombinator.com | 20 Aug 2023
    There are a few things you can do here.

    SQLite is great at JSON - so I often dump JSON structures in a TEXT column and query them using https://www.sqlite.org/json1.html

    I also have plugins for running jq() functions directly in SQL queries - https://datasette.io/plugins/datasette-jq and https://github.com/simonw/sqlite-utils-jq

    I've been trying to drive the cost of turning semi-structured data into structured SQL queries down as much as possible with https://sqlite-utils.datasette.io - see this tutorial for more: https://datasette.io/tutorials/clean-data

    This is also an area that I'm starting to explore with LLMs. I love the idea that you could take a bunch of messy data, tell Datasette Cloud "I want this imported into a table with this schema"... and it does that.

    I have a prototype of this working now, I hope to turn it into an open source plugin (and Datasette Cloud feature) pretty soon. It's using this trick: https://til.simonwillison.net/gpt3/openai-python-functions-d...

  • SQLite Functions for Working with JSON
    10 projects | news.ycombinator.com | 10 Aug 2023
    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" \

Stats

Basic sqlite-utils-jq repo stats
2
8
3.7
over 1 year ago

The primary programming language of sqlite-utils-jq is Python.

Popular Comparisons

  1. sqlite-utils-jq VS pyjq
  2. sqlite-utils-jq VS sqlite-utils-litecli
  3. sqlite-utils-jq VS sqlitebson
  4. sqlite-utils-jq VS grist-core
  5. sqlite-utils-jq VS cloudquery
  6. sqlite-utils-jq VS txtai
  7. sqlite-utils-jq VS litecli
  8. sqlite-utils-jq VS sqlite-utils
  9. sqlite-utils-jq VS datasette
  10. sqlite-utils-jq VS oxide

Sponsored
Save 47% on cloud hosting with autoscaling that just works
Judoscale integrates with Django, FastAPI, Celery, and RQ to make autoscaling easy and reliable. Save big, and say goodbye to request timeouts and backed-up task queues.
judoscale.com
Loading...