SQL

Open-source projects categorized as SQL | Edit details

Top 23 SQL Open-Source Projects

  • Apache Spark

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

    Project mention: How to use Spark and Pandas to prepare big data | dev.to | 2022-05-10

    Apache Spark is one of the most actively developed open-source projects in big data. The following code examples require that you have Spark set up and can execute Python code using the PySpark library. The examples also require that you have your data in Amazon S3 (Simple Storage Service). All this is set up on AWS EMR (Elastic MapReduce).

  • tidb

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

    Project mention: Insights for any repository on Github | reddit.com/r/programming | 2022-05-14

    As the database supporter for ossinsight.io, I also use this to get many insights for TiDB itself, see https://ossinsight.io/analyze/pingcap/tidb.

  • SonarQube

    Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.

  • dbeaver

    Free universal database tool and SQL client

    Project mention: Most popular PostgreSQL GUIs in 2022: the (almost) scientific list | dev.to | 2022-05-17

    OmniDB is more complex than a Postico or TablePlus but less advanced than a DataGrip or Navicat. It's a good free option but maybe less complete than DBeaver, which has a better documentation and a seemingly larger community.

  • Sequelize

    An easy-to-use and promise-based multi SQL dialects ORM tool for Node.js | Postgres, MySQL, MariaDB, SQLite, MSSQL, Snowflake & DB2

    Project mention: Do Open Source programs have supervisors? | reddit.com/r/opensource | 2022-05-16
  • cockroach

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

    Project mention: How we built a cost-based SQL optimizer | reddit.com/r/programming | 2022-04-29

    CRDB implements the algorithm described in a 2013 paper called "On the correct and complete enumeration of the core search space". It is a bottom-up DP approach that is able to handle inner, left, anti, semi, full, etc. joins (many papers only cover inner joins). In addition, CRDB extends it in a few ways that enable reorderings in some important practical cases that the paper doesn't cover (a full description can be found here). As a result, it's able to reorder in a number of cases that other optimizers don't even consider.

  • 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: Joining DevOps! | reddit.com/r/devops | 2022-04-19

    This guy https://github.com/bregman-arie/devops-exercises made an awesome practice material for DevOps tasks

  • ClickHouse

    ClickHouse® is a free analytics DBMS for big data

    Project mention: Ask HN: Free and open source distributed database written in C++ or C | news.ycombinator.com | 2022-05-16
  • Scout APM

    Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.

  • OSQuery

    SQL powered operating system instrumentation, monitoring, and analytics.

    Project mention: invintory for linux. | reddit.com/r/sysadmin | 2022-05-09

    osquery, with or without fleetdm or kolide.

  • MyBatis

    MyBatis SQL mapper framework for Java

    Project mention: 20 years of Hibernate | reddit.com/r/java | 2021-05-24

    How about batch insert, updates, and deletes? I had to fix a broken MyBatis project recently and was surprised that this feature doesn't even seem to be implemented, at least according to this GitHub issue.

  • shardingsphere

    Ecosystem to transform any database into a distributed database system, and enhance it with sharding, elastic scaling, encryption features & more

    Project mention: Apache ShardingSphere -Proxy Performance with PostgreSQL is Improved 26.8% with Version 5.1.0 | dev.to | 2022-04-25

    Relevant PR:https://github.com/apache/shardingsphere/pull/11459/files

  • Knex

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

    Project mention: SQL: One to Many Join Query in an Optimal way with Node.js | dev.to | 2022-05-16

    Knex.js as Query Builder

  • Dapper

    Dapper - a simple object mapper for .Net

    Project mention: i get a "Unable to cast object of type 'System.Byte' to type 'System.Int32'.'" error. I have looked on google but I can't really find a solution | reddit.com/r/csharp | 2022-04-15

    Dude, cant use dapper? https://github.com/DapperLib/Dapper

  • Presto

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

    Project mention: Let's write a compiler, part 5: A code generator | news.ycombinator.com | 2021-08-19
  • TimescaleDB

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

    Project mention: Database structure for pipelines | reddit.com/r/algotrading | 2022-05-16

    If you need persistent storage, TimescaleDB is a PostgreSQL extension designed for time-series data.

  • cube.js

    📊 Cube — Headless Business Intelligence for Building Data Applications

    Project mention: Building a Bubble Dashboard with Cube | reddit.com/r/api | 2022-05-19

    In this piece, we will teach you how to leverage the power of Cube to build an analytics dashboard that aggregates data from a relational database and displays it using Bubble.

  • go-sql-driver/mysql

    Go MySQL Driver is a MySQL driver for Go's (golang) database/sql package (by go-sql-driver)

    Project mention: Golang future web frameworks! | reddit.com/r/golang | 2022-04-24

    go-sql-driver/mysql 12.1k Stars, Used by 72.4k

  • dolt

    Dolt – It's Git for Data

    Project mention: [Self Promotion] Hosted Dolt is here! | reddit.com/r/Database | 2022-05-18

    For those of you new to Dolt (https://github.com/dolthub/dolt). Dolt is like Git and MySQL had a baby. We built a SQL database from the storage engine up to support branch, merge, clone, diff and all the other Git idioms.

  • rqlite

    The lightweight, distributed relational database built on SQLite

    Project mention: Let's build a distributed Postgres proof of concept | news.ycombinator.com | 2022-05-17

    Every node in the cluster "knows" the network address of the Leader. It knows because a) it's part of the Raft cluster configuration, and every follower "heartbeats" to the Leader periodically.

    So it's actually pretty simple. If a node receives a request which must be performed on the leader, and that node is not itself the Leader, it can do one of the following things:

    1) reject the request with an error, but this isn't really a production-viable option.

    2) reject the request with an error, but tell the client where the leader can be found, so the leader can retry the request.

    3) transparently forward the request to the leader, wait for the leader to execute the request, get the respond, and return the response to the client. In this case the client doesn't even know the forwarding to the leader happened.

    rqlite supports mode 2 and 3, client can choose which behavior it wants, on a request-by-request basis. Option 3 is the default.

    https://github.com/rqlite/rqlite/blob/master/DOC/DATA_API.md...

  • sql.js

    A javascript library to run SQLite on the web.

    Project mention: Extending SQLite with Rust | reddit.com/r/rust | 2022-05-17

    The reason I originally looked into this was to see if there's a way to use sqlite in wasm with indexeddb as the storage backend, getting a full SQL engine in the browser (like WebSQL, but actually using web standard API). Here is sqlite compiled to wasm, but only with the in-memory database, which is only of limited use. My conclusion was that it might be possible, but needs a ton of work in C interfacing with web APIs through emscripten, which is not fun at all.

  • Bitwarden

    The core infrastructure backend (API, database, Docker, etc). (by bitwarden)

    Project mention: How to disable robust password requirement? | reddit.com/r/portainer | 2022-05-18

    This has been answered already, but until the patch comes out a password manager like bitwarden can trivialize the issue.

  • beekeeper-studio

    Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.

    Project mention: Looking for a very simple GUI for a beginner | reddit.com/r/sqlite | 2022-05-09
  • q

    q - Run SQL directly on delimited files and multi-file sqlite databases (by harelba)

    Project mention: OpenOffice. Necesito ver una hoja de cálculo que tiene 6 millones de columnas, pero no puedo | reddit.com/r/AskArgentina | 2022-05-15
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 2022-05-20.

SQL related posts

Index

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

Project Stars
1 Apache Spark 32,903
2 tidb 31,319
3 dbeaver 26,450
4 Sequelize 26,139
5 cockroach 24,577
6 devops-exercises 24,205
7 ClickHouse 23,738
8 Apache Flink 18,920
9 OSQuery 18,896
10 MyBatis 17,176
11 shardingsphere 15,869
12 Knex 15,799
13 Dapper 14,895
14 Presto 13,478
15 TimescaleDB 13,060
16 cube.js 12,964
17 go-sql-driver/mysql 12,233
18 dolt 10,633
19 rqlite 10,322
20 sql.js 10,119
21 Bitwarden 9,776
22 beekeeper-studio 9,677
23 q 9,059
Find remote jobs at our new job board 99remotejobs.com. There are 7 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com