Sq.io: jq for databases and much more

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

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.
coderabbit.ai
featured
Nutrient – The #1 PDF SDK Library, trusted by 10K+ developers
Other PDF SDKs promise a lot - then break. Laggy scrolling, poor mobile UX, tons of bugs, and lack of support cost you endless frustrations. Nutrient’s SDK handles billion-page workloads - so you don’t have to debug PDFs. Used by ~1 billion end users in more than 150 different countries.
www.nutrient.io
featured
  1. prql

    PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement

  2. CodeRabbit

    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.

    CodeRabbit logo
  3. liteJQ

    jq extension for SQLite.

    I mean, how much data is actually leaving the database?

    [0] https://github.com/Florents-Tselai/liteJQ

  4. pgJQ

    jq extension for Postgres

  5. jsquery

    JsQuery – json query language with GIN indexing support

  6. simple-postgres-container

    Simple Postgres docker container with sample of data

    SQLite: https://duckdb.org/docs/extensions/sqlite

    You can try this yourself.

    1. Clone this repo and create a postgres container with sample data: https://github.com/TemaDobryyR/simple-postgres-container

    2. Install duckdb if you haven't and if you have just access it on the console: https://duckdb.org/docs/installation/index?version=stable&en...

    3. Load the postgres extension: INSTALL postgres;LOAD postgres;

    4. Connect to the postgres database: ATTACH 'dbname=postgres user=postgres host=127.0.0.1 password=postgres' AS db (TYPE POSTGRES, READ_ONLY);

    D SHOW ALL TABLES;

  7. super

    An analytics database that puts JSON and relational tables on equal footing

  8. Platform

    Free, open-source community platform, decentralized alternative to Big Tech. For apps that empower people and unite communities. (by Qbix)

    Actually, when it comes to SQL specifically, it almost demands using a language one higher up.

    Any language that features the ability to embed/interpolate unescaped quotes is not secure enough to be used directly by professional developers. Just not worth it to track down all the potential injection attacks.

    And if an abstraction lets you understand the structure of queries (eg for sharding them) and even writes the code for you and balances parentheses, flags other syntax errors at compile time etc. then it’s a net benefit.

    And of course there is the Adapter Pattern to abstract away connection logic and differences between mysql, pg, etc.

    I wrote the “Db” library 12 years ago in PHP and still use it.

    I never released it on HN for reasons like this. But I might. Here it is, embedded in my larger library, but I might break it out:

    https://github.com/Qbix/Platform/tree/main/platform/classes/...

  9. Nutrient

    Nutrient – The #1 PDF SDK Library, trusted by 10K+ developers. Other PDF SDKs promise a lot - then break. Laggy scrolling, poor mobile UX, tons of bugs, and lack of support cost you endless frustrations. Nutrient’s SDK handles billion-page workloads - so you don’t have to debug PDFs. Used by ~1 billion end users in more than 150 different countries.

    Nutrient logo
  10. prql-query

    Discontinued Query and transform data with PRQL

    Some time ago I wrote pq (https://github.com/prql/prql-query) which aimed to be a simple CLI for PRQL to wrangle data on the command line, much like sq.

    Unfortunately I haven't had time to maintain it so it is now archived and out of date. I hope that I might get a chance to update it again. More has happened since then and there are low hanging fruit to make it more usable, for example adding connector_arrow (https://github.com/aljazerzen/connector_arrow) support for other databases, etc...

  11. connector_arrow

    Apache Arrow database client for many databases.

    Some time ago I wrote pq (https://github.com/prql/prql-query) which aimed to be a simple CLI for PRQL to wrangle data on the command line, much like sq.

    Unfortunately I haven't had time to maintain it so it is now archived and out of date. I hope that I might get a chance to update it again. More has happened since then and there are low hanging fruit to make it more usable, for example adding connector_arrow (https://github.com/aljazerzen/connector_arrow) support for other databases, etc...

  12. textql

    Execute SQL against structured text like CSV or TSV

    I really like the idea of https://github.com/dinedal/textql, which uses SQL to interact with file-based data stores. However, I don't understand why sq does the opposite—using a new DSL to access a database that already has a widely-adopted and easy-to-use language: good old SQL.

  13. Db

    Versatile, Battle-Tested Database Library for PHP (MySQL, etc.) (by Qbix)

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • Ask HN: People that use jq extensively, I'd like to talk to you

    2 projects | news.ycombinator.com | 6 May 2024
  • LiteJQ: Jq Support in SQLite

    1 project | news.ycombinator.com | 3 Mar 2024
  • A surprising thing about PyPI's BigQuery data

    1 project | dev.to | 24 Nov 2024
  • The fastest local database ever!!!!

    1 project | dev.to | 27 May 2024
  • Introducing Verse.db: The Next Generation of Lightweight, High-Performance Databases

    2 projects | dev.to | 26 May 2024

Did you know that C is
the 6th most popular programming language
based on number of references?