sqlite-utils-jq VS litecli

Compare sqlite-utils-jq vs litecli and see what are their differences.

sqlite-utils-jq

Plugin adding a jq() SQL function to sqlite-utils (by simonw)
Suggest topics
Source Code
Suggest alternative
Edit details

litecli

CLI for SQLite Databases with auto-completion and syntax highlighting (by dbcli)
Command-line Tools CLI Enhancements Linux syntax-highlighting Python prompt-toolkit Sqlite
Source Code
litecli.com
Suggest alternative
Edit details
InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
sqlite-utils-jq litecli
2 4
8 2,032
- 1.4%
3.7 5.8
9 months ago 14 days ago
Python Python
- BSD 3-clause "New" or "Revised" License
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

sqlite-utils-jq

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" \

litecli

Posts with mentions or reviews of litecli. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-08-10.