Query

Open-source projects categorized as Query
Edit details
Language: + TypeScript + Go + Rust + JavaScript + Java + Python + C# + PHP + Ruby
Topics: SQL Database JSON Python Golang
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
Sponsored

Top 23 Query Open-Source Projects

  • TanStack Query

    🤖 Powerful asynchronous state management, server-state utilities and data fetching for the web. TS/JS, React Query, Solid Query, Svelte Query and Vue Query.

    • Project mention: Best Next.js Libraries and Tools in 2024 | dev.to | 2024-04-10

  • Presto

    The official home of the Presto distributed SQL query engine for big data

    • Project mention: Multi-Database Support in DuckDB | news.ycombinator.com | 2024-01-28

    We have some of this functionality in Presto (https://github.com/prestodb/presto), but it takes fair bit of work to implement it for all the different backends.

  • SurveyJS

    Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

    SurveyJS logo

  • fq

    jq for binary formats - tool, language and decoders for working with binary and text formats

    • Project mention: Reverse-engineering an encrypted IoT protocol | news.ycombinator.com | 2024-02-14

    Hey! fq author here. I have a bunch of related tools in the readme https://github.com/wader/fq?tab=readme-ov-file#tools two suggestions: gnu poke and wireshark (can decode lots of more things then just network protocol)

  • dasel

    Select, put and delete data from JSON, TOML, YAML, XML and CSV files with a single tool. Supports conversion between formats and can be used as a Go package.

    • Project mention: jq 1.7 Released | news.ycombinator.com | 2023-09-06

  • autocomplete

    🔮 Fast and full-featured autocomplete library (by algolia)

    • Project mention: autocomplete - a JavaScript library that lets you quickly build autocomplete experiences | /r/javascript | 2023-06-08

  • octosql

    OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.

    • Project mention: Wazero: Zero dependency WebAssembly runtime written in Go | news.ycombinator.com | 2023-07-01

    Never got it to anything close to a finished state, instead moving on to doing the same prototype in llvm and then cranelift.

    That said, here's some of the wazero-based code on a branch - https://github.com/cube2222/octosql/tree/wasm-experiment/was...

    It really is just a very very basic prototype.

  • sql-translator

    SQL Translator is a tool for converting natural language queries into SQL code using artificial intelligence. This project is 100% free and open source.

    • Project mention: Storybook GPT | dev.to | 2023-05-08

    I started to see more and more applications that use the OpenAI API and I wanted to try it out. One of these apps is this one made by Kate.

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

    WorkOS logo

  • fselect

    Find files with SQL-like queries

  • graphqurl

    curl for GraphQL with autocomplete, subscriptions and GraphiQL. Also a dead-simple universal javascript GraphQL client.

    • Project mention: How to generate a CLI from GraphQL API/schema? | /r/graphql | 2023-06-03

  • roapi

    Create full-fledged APIs for slowly moving datasets without writing a single line of code.

    • Project mention: Full-fledged APIs for slowly moving datasets without writing code | news.ycombinator.com | 2023-10-25

  • pgtyped

    pgTyped - Typesafe SQL in TypeScript

    • Project mention: Type-Safe Printf() in TypeScript | news.ycombinator.com | 2024-03-24

    There is an implementation of SQL that operates on a table shaped type, entirely at type level. For your amusement: https://github.com/codemix/ts-sql

    There are a bunch of more practical takes that codegen types from your database and generate types for your queries, eg: https://github.com/adelsz/pgtyped

    To me the second approach seems much more pragmatic because you don’t need to run a SQL parser in a fairly potato interpreter on every build

  • jaq

    A jq clone focussed on correctness, speed, and simplicity

    • Project mention: Jaq | /r/devopspro | 2023-12-07

  • PyPika

    PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.

    • Project mention: any recommendations for a good query builder library with good support? | /r/learnpython | 2023-07-11

    I recently started using drizzle orm and I am now looking for something similar in python, my goal is to be as close to sql syntax as possible without just passing dml commands as strings, type safety would be cool as well, I saw this one pypika but it ha a lot of open issues and no commits for a year, is there anything similar but more stable?

  • use-http

    🐶 React hook for making isomorphic http requests

  • Apache Lucene

    Apache Lucene.NET

  • gojsonq

    A simple Go package to Query over JSON/YAML/XML/CSV Data

  • use-query-params

    React Hook for managing state in URL query parameters with easy serialization.

  • react-awesome-query-builder

    User-friendly query builder for React

  • EloquentFilter

    An Eloquent Way To Filter Laravel Models And Their Relationships

  • PumpkinDB

    Immutable Ordered Key-Value Database Engine

  • arquero

    Query processing and transformation of array-backed data tables.

    • Project mention: Show HN: Matrices – explore, visualize, and share large datasets | news.ycombinator.com | 2023-12-07

    Hey HN, I'm excited to share a new side project I've been working on.

    The product is called Matrices. You can check it out here: https://matrices.com/.

    With Matrices, you can *explore*, *visualize*, and *share* large (100k rows) datasets–all without code. Filter data down to just what you want, visualize it with built-in charts, and share your results with one click.

    You can use it today (no login or waitlist or anything). Just copy and paste your data from a google sheet or CSV file.

    It's hard to describe the feeling of "gliding over data" you get with Matrices, so I'd rather *show* you how it works instead. This 75s video will give you a sense of how it works: https://www.youtube.com/watch?v=Rrh9_I3Ux8E.

    Data is stored locally in your browser until you publish it, though small sample does go to the OpenAI APIs for AI-assisted features.

    I started building Matrices because I wanted a tool that made it easy to explore new datasets. When I'm first trying to dig into data, I'll have one question... that leads to another... that will invariably lead to five more questions. It's sort of a fractal process, and I couldn't find many good options that were fast, responsive, and visual.

    I figured this crowd would be interested in tech stack as well, it's using arquero [1] bindings over apache arrow for in-memory analytics, and visx [2] for visualizations. I'd like to add duckdb-wasm support at some point to open up a wider set of databases. Data is serialized as parquet to save a bit on bandwidth + storage.

    Give it a spin, and let me know what you think. This is my first 'serious frontend project' so I appreciate any and all feedback and bug reports. Feel free to comment here (I'll be around most of the day), or shoot me a note: [email protected]

    [1]: https://uwdata.github.io/arquero/

  • vue-query

    Hooks for fetching, caching and updating asynchronous data in Vue

  • jsonb_accessor

    Adds typed jsonb backed fields to your ActiveRecord models.

  • 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.

    InfluxDB logo
NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2024-04-10.

Query related posts

Index

What are some of the best open-source Query projects? This list will help you:

Project Stars
1 TanStack Query 39,548
2 Presto 15,582
3 fq 9,355
4 dasel 4,856
5 autocomplete 4,724
6 octosql 4,689
7 sql-translator 3,953
8 fselect 3,800
9 graphqurl 3,300
10 roapi 3,070
11 pgtyped 2,797
12 jaq 2,468
13 PyPika 2,367
14 use-http 2,312
15 Apache Lucene 2,143
16 gojsonq 2,135
17 use-query-params 2,097
18 react-awesome-query-builder 1,773
19 EloquentFilter 1,659
20 PumpkinDB 1,366
21 arquero 1,186
22 vue-query 1,095
23 jsonb_accessor 1,081

Sponsored
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