SQL

Open-source projects categorized as SQL
Edit details
Language: + Java + Go + C++ + TypeScript + Rust + C + Python + Scala + Haskell + JavaScript + C#
Topics: Database Postgresql MySQL Sqlite Python
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

Top 23 SQL Open-Source Projects

  • devops-exercises

    Linux, Jenkins, AWS, SRE, Prometheus, Docker, Python, Ansible, Git, Kubernetes, Terraform, OpenStack, SQL, NoSQL, Azure, GCP, DNS, Elastic, Network, Virtualization. DevOps Interview Questions

    • Project mention: DevOps Exercises | news.ycombinator.com | 2023-08-07

  • Apache Spark

    Apache Spark - A unified analytics engine for large-scale data processing

    • Project mention: "xAI will open source Grok" | news.ycombinator.com | 2024-03-11

  • 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

  • dbeaver

    Free universal database tool and SQL client

    • Project mention: DBeaver โ€“ open-source Database client | news.ycombinator.com | 2024-03-10

    Yes but not in the community version:

    https://github.com/dbeaver/dbeaver/wiki/Schema-compare

  • tidb

    TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try AI-powered Chat2Query free at : https://tidbcloud.com/free-trial

    • Project mention: A MySQL compatible database engine written in pure Go | news.ycombinator.com | 2024-04-09

    tidb has been around for a while, it is distributed, written in Go and Rust, and MySQL compatible. https://github.com/pingcap/tidb

    Somewhat relatedly, StarRocks is also MySQL compatible, written in Java and C++, but it's tackling OLAP use-cases. https://github.com/StarRocks/starrocks

  • ClickHouse

    ClickHouseยฎ is a free analytics DBMS for big data

    • Project mention: We Built a 19 PiB Logging Platform with ClickHouse and Saved Millions | news.ycombinator.com | 2024-04-02

    Yes, we are working on it! :) Taking some of the learnings from current experimental JSON Object datatype, we are now working on what will become the production-ready implementation. Details here: https://github.com/ClickHouse/ClickHouse/issues/54864

    Variant datatype is already available as experimental in 24.1, Dynamic datatype is WIP (PR almost ready), and JSON datatype is next up. Check out the latest comment on that issue with how the Dynamic datatype will work: https://github.com/ClickHouse/ClickHouse/issues/54864#issuec...

  • cockroach

    CockroachDB - the open source, cloud-native distributed SQL database.

    • Project mention: 11 Planetscale alternatives with free tiers | dev.to | 2024-04-11

    CockroachDB is an open source distributed SQL database designed for scalability and resilience. While it offers SQL databases, CockroachDB is also compatible with PostgreSQL.

  • Sequelize

    Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB (v6), DB2 and DB2 for IBM i.

    • Project mention: Full Stack Web Development Concept map | dev.to | 2024-03-23

    Sequelize - modern Typescript and NodeJS ORM for Oracle, Postgres, MySQL, MariaDB, SQLite, SQL Server+docs

  • SaaSHub

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

    SaaSHub logo

  • surrealdb

    A scalable, distributed, collaborative, document-graph database, for the realtime web

    • Project mention: Show HN: I made a tool to easily compare pricing of developer tools and services | news.ycombinator.com | 2024-04-23

    you should add https://surrealdb.com -- basically an open source firebase. and they will launch a paid cloud offering soon.

  • Directus

    The Modern Data Stack ๐Ÿฐ โ€” Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.

    • Project mention: How to Deploy Directus as a Backend-as-a-Service (BaaS) on Koyeb | dev.to | 2024-04-25

    Directus is an open data platform built to serve as a headless CMS, API, or Backend-as-a-Service (BaaS) for other applications. It is designed to make data accessible to people of all technical levels and to make it easy to build data-centric applications. Directus is extensible and can be integrated with many different frontend technologies to create stable, well-structured development and user experiences.

  • Apache Flink

    Apache Flink

    • Project mention: First 15 Open Source Advent projects | dev.to | 2023-12-15

    7. Apache Flink | Github | tutorial

  • TDengine

    TDengine is an open source, high-performance, cloud native time-series database optimized for Internet of Things (IoT), Connected Cars, Industrial IoT and DevOps.

    • Project mention: TDengine: NEW Data - star count:22190.0 | /r/algoprojects | 2023-11-14

  • postgrest

    REST API for any Postgres database

    • Project mention: Supabase โ€“ General Availability Week | news.ycombinator.com | 2024-04-15

    hey hn, supabase ceo her

    we just announced GA, after ~4 years of beta. for those who don't know: supabase is a postgres hosting company. we also host other open source "backend" tools that make it easy to get started with postgres (tools like PostgREST for auto-generate APIs [0])

    we owe a lot to the HN community. you launched us 4 years ago [1], when we were just a few developers. since then HN has been a staple in our journey, one of the best sources of product feedback [2]

    the GA badge is mostly to signify organizational readiness. we're at a stage where we can take any profile of customer. we have a support team that works 24/7, and a success team that will help customers improve their postgres usage. we released our Index Advisor [3] yesterday, and we'll be releasing a few more products this week that helps customer with performance and security.

    on a personal note: i read HN most days, and love going through the ShowHN's to see what devs are building. thanks for being an awesome community and my favorite place to lurk on the internet. i'll stick around to answer any questions

    [0] PostgREST: https://postgrest.org

    [1] Launch: https://news.ycombinator.com/item?id=23319901

    [2] HN journey: https://hn.algolia.com/?dateRange=all&page=0&prefix=false&qu...

    [3] Index Advisor: https://news.ycombinator.com/item?id=40028111

  • OSQuery

    SQL powered operating system instrumentation, monitoring, and analytics.

    • Project mention: Ask HN: SQLite in Production? | news.ycombinator.com | 2024-04-07

    Perhaps the OP means OsQuery: https://github.com/osquery/osquery

    OsQuery is an SQLite extension consisting of hundreds of virtual tables

  • drizzle-orm

    Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too ๐Ÿ˜…

    • Project mention: A Software Engineer's Tips and Tricks #1: Drizzle | dev.to | 2024-04-29

    Enter Drizzle, a lightweight typesafe ORM for TypeScript that comes with one promise: If you know SQL โ€” you know Drizzle.

  • shardingsphere

    Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.

    • Project mention: Managing Data Residency - the demo | dev.to | 2023-05-25

    Opposite to what the documentation tells, the full prefix is jdbc:shardingsphere:absolutepath. I've opened a PR to fix the documentation.

  • MyBatis

    MyBatis SQL mapper framework for Java

    • Project mention: MyBatis makes it easier to use a relational database with OO applications | news.ycombinator.com | 2023-10-05

  • Knex

    A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.

    • Project mention: JavaScript Libraries for Implementing Trendy Technologies in Web Apps in 2024 | dev.to | 2024-04-09

    Knex.js

  • cube.js

    ๐Ÿ“Š Cube โ€” The Semantic Layer for Building Data Applications

    • Project mention: MQL โ€“ Client and Server to query your DB in natural language | news.ycombinator.com | 2024-04-07

    I should have clarified. There's a large number of apps that are:

    1. taking info strictly from SQL (e.g. information_schema, query history)

    2. taking a user input / question

    3. writing SQL to answer that question

    An app like this is what I call "text-to-sql". Totally agree a better system would pull in additional documentation (which is what we're doing), but I'd no longer consider it "text-to-sql". In our case, we're not even directly writing SQL, but rather generating semantic layer queries (i.e. https://cube.dev/).

  • Dapper

    Dapper - a simple object mapper for .Net

    • Project mention: Working with Dapper/SQL-Server Framework 4.8 C# | dev.to | 2024-01-27

    In both samples to get all records and to get a single record works fine but there is a better way to perform the same work using NuGet package Dapper. Dapper is extremely easy to use and built with performance in mind. In the source code provided the basic operations are covered, to take things to the next level and read the information at GitHub, the following page and other code samples in the following repository.

  • dolt

    Dolt โ€“ Git for Data

    • Project mention: A MySQL compatible database engine written in pure Go | news.ycombinator.com | 2024-04-09

    Hi, this is my project :)

    For us this package is most important as the query engine that powers Dolt:

    https://github.com/dolthub/dolt

    We aren't the original authors but have contributed the vast majority of its code at this point. Here's the origin story if you're interested:

    https://www.dolthub.com/blog/2020-05-04-adopting-go-mysql-se...

  • duckdb

    DuckDB is an in-process SQL OLAP Database Management System

    • Project mention: ๐Ÿช„ DuckDB sql hack : get things SORTED w/ constraint CHECK | dev.to | 2024-04-04

  • TimescaleDB

    An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.

    • Project mention: TimescaleDB: An open-source time-series SQL database | news.ycombinator.com | 2024-02-06

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

  • SaaSHub

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

    SaaSHub 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).

SQL related posts

Index

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

Project Stars
1 devops-exercises 63,556
2 Apache Spark 38,414
3 dbeaver 37,481
4 tidb 36,169
5 ClickHouse 34,269
6 cockroach 29,119
7 Sequelize 29,055
8 surrealdb 25,462
9 Directus 25,417
10 Apache Flink 23,190
11 TDengine 22,829
12 postgrest 22,342
13 OSQuery 21,361
14 drizzle-orm 19,921
15 shardingsphere 19,442
16 MyBatis 19,420
17 Knex 18,758
18 cube.js 17,174
19 Dapper 17,140
20 dolt 16,993
21 duckdb 16,749
22 TimescaleDB 16,500
23 Presto 15,603

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com