InfluxDB Platform is powered by columnar analytics, optimized for cost-efficient storage, and built with open data standards. Learn more →
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
-
InfluxDB
Purpose built for real-time analytics at any scale. InfluxDB Platform is powered by columnar analytics, optimized for cost-efficient storage, and built with open data standards.
-
The Python Library components of Ray could be considered analogous to solutions like numpy, scipy, and pandas (which is most analogous to the Ray Data library specifically). As a framework and distributed computing solution, Ray could be used in place of a tool like Apache Spark or Python Dask. It’s also worthwhile to note that Ray Clusters can be used as a distributed computing solution within Kubernetes, as we’ve explored here, but Ray Clusters can also be created independent of Kubernetes.
-
This is the third and the final article of the series. It's written based on the results of checking DBeaver version 24 with the help of the PVS-Studio static analyzer. The tool detected a few suspicious code fragments that caught our development team's attention and prompted us to cover them in several articles. If you haven't read the previous ones, you can find them here:
-
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://www.pingcap.com/tidb-serverless/
-
We chose ClickHouse to store the dictionary as we ran into deadlock and performance issues with Postgres writes as we scaled the number of workers. ClickHouse's async inserts are fantastic for this task and allowed us to ingest the entire 38M+ document dataset in < 1hr.
-
cockroach
CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
code in a given file is licensed under the BSL and ..." That is sucky.
[0] https://github.com/cockroachdb/cockroach?tab=License-1-ov-fi...
-
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.
3. Sequelize
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
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: Directus VS wabe - a user suggested alternative | libhunt.com/r/directus | 2024-09-08 -
Project mention: Ask HN: Lesser-known/underrated cool new web-oriented tech? | news.ycombinator.com | 2024-07-23
I've been surveying the space lately and I re/discovered some really powerful new-ish tech which woke up my tech taste buds and am now looking for more such "tasty" tech (sorry I guess I'm due for a meal soon :P)
Example as starters:
- Qwik and resumable web apps (https://qwik.dev/)
- SurrealDB, maximally flexible multi-model DB (https://surrealdb.com/)
There are others, but I'm trying to keep to the starkest examples and not to influence the discussion too much.
I do think this is the best place to ask such questions - I'm explicitly interested in cutting-edge tech, but the edge doesn't have to be excessively sharp ;).
-
You can find example of usage in org/apache/flink/contrib/streaming/state package (https://github.com/apache/flink/tree/9fe8d7bf870987bf43bad63078e2590a38e4faf6/flink-state-backends/flink-statebackend-rocksdb/src/main/java/org/apache/flink/contrib/streaming/state).
-
TDengine
High-performance, scalable time-series database designed for Industrial IoT (IIoT) scenarios
Project mention: TDengine: Open-Source, High-Performance Time-Series DB for IoT and Cloud | news.ycombinator.com | 2024-08-14 -
PostgREST 12.2 is out! It comes with Observability and API improvements. In this post, we'll see what's new.
-
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: drizzle-orm VS rado - a user suggested alternative | libhunt.com/r/drizzle-orm | 2024-08-09 -
The last I read, the Spark API was to become the focus point.
https://duckdb.org/docs/api/python/spark_api
Not sure what the current status is.
ref: <https://github.com/duckdb/duckdb/issues/2000#issuecomment-18...>
-
Project mention: SQL powered operating system instrumentation, monitoring, and analytics | news.ycombinator.com | 2024-09-10
-
shardingsphere
Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.
-
I'm working on https://github.com/drawdb-io/drawdb trying to optimize the editor and have it lag less when the number of tables increases. Also have some highly requested features I'd like to implement before launching on Product Hunt.
Then I wanted a change of pace and started on something so ambitious that it's stupid... I'm trying to make a web browser from scratch I guess. So far tokenizing the html is going fine but I'm not sure how far I'll be able to get.
-
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: Low-code drag-and-drop tool for building RESTful APIs with in minutes. | dev.to | 2024-07-04Knex: SQL query builder used in the application to manage sql databases queries in a easier way by letting knex handel all the hassle for us.
-
Project mention: Why you should keep an eye on Apache DataFusion and its community. | dev.to | 2024-07-08
LanceDB, Cube.dev, InfluxData, Denormalized, and Greptime are building completely different products. What they have in common, though, is that their products are a database system at their core and they are also using DataFusion to build them.
-
We built a MySQL-compatible one and are building a Postgres-compatible one :-) Free and open source.
https://github.com/dolthub/dolt
We use the reset functionality to speed up our tests.
https://www.dolthub.com/blog/2022-06-10-enginetest-perf/
-
Dapper is a simple, lightweight, and high-performance Object-Relational Mapping (ORM) library for .NET. It is widely used for database access in C# applications due to its speed and simplicity. In this guide, we will explore how to use Dapper in combination with a Generic Repository pattern to streamline database interactions.
-
TimescaleDB
An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
> based on the time period
Is it the kind of thing where the TimescaleDB extension would make sense?
https://github.com/timescale/timescaledb
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
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 discussion
SQL related posts
-
Show HN: Musoq – I've Added AI and Piping to My "SQL for Everything" Tool
-
SQLite on Rails: The how and why of optimal performance
-
Rust in Illumos
-
SQL powered operating system instrumentation, monitoring, and analytics
-
Sqlc: Compile SQL to type-safe code
-
DuckDB 1.1.0 Released
-
Parchment Style - FAV0 Weekly #014
-
A note from our sponsor - InfluxDB
www.influxdata.com | 13 Sep 2024
Index
What are some of the best open-source SQL projects? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | devops-exercises | 65,751 |
| 2 | Apache Spark | 39,259 |
| 3 | dbeaver | 39,211 |
| 4 | tidb | 36,882 |
| 5 | ClickHouse | 36,676 |
| 6 | cockroach | 29,864 |
| 7 | Sequelize | 29,428 |
| 8 | Directus | 27,070 |
| 9 | surrealdb | 26,615 |
| 10 | Apache Flink | 23,828 |
| 11 | TDengine | 23,194 |
| 12 | postgrest | 23,182 |
| 13 | drizzle-orm | 23,134 |
| 14 | DuckDB | 22,452 |
| 15 | OSQuery | 21,705 |
| 16 | shardingsphere | 19,760 |
| 17 | drawdb | 19,695 |
| 18 | MyBatis | 19,690 |
| 19 | Knex | 19,166 |
| 20 | cube.js | 17,725 |
| 21 | dolt | 17,717 |
| 22 | Dapper | 17,439 |
| 23 | TimescaleDB | 17,457 |
Sponsored
Purpose built for real-time analytics at any scale.
InfluxDB Platform is powered by columnar analytics, optimized for cost-efficient storage, and built with open data standards.
www.influxdata.com