Top 23 Database Open-Source Projects
The Prometheus monitoring system and time series database.Project mention: Implementing Istio in a Kubernetes cluster | dev.to | 2021-10-25
For simplicity and example purposes, the following section will use the demo manifests for deploying Kiali, Jaeger, Prometheus, and Grafana.
Distributed reliable key-value store for the most critical data of a distributed systemProject mention: Package Management Nightmare | reddit.com/r/golang | 2021-10-12
They have an open issue for it and looks like no blockers, and a PR bumping the otel version, so it looks like it's moving.
Scout APM: A developer's best friend. Try free for 14-days. Scout APM uses tracing logic that ties bottlenecks to source code so you know the exact line of code causing performance issues and can get back to building a great product faster.
TiDB is an open source distributed HTAP database compatible with the MySQL protocolProject mention: Question regarding computing industry | reddit.com/r/NTU | 2021-06-20
My knowledge is still quite limited because I never worked on the internals of distributed databases (I've only used and deployed them as an intern) but I have taken Advanced Databases CZ4031 in NTU and Parallel and Distributed Algorithms CS4231 in NUS which helped me get some basic understanding so you can consider taking those if you are interested. If you want to see how an open source database looks like, I would recommend TiDB because their documentation is quite good.
LevelDB is a fast key-value storage library written at Google that provides an ordered mapping from string keys to string values.Project mention: How to set up an Electrum Server on Windows machine? | reddit.com/r/btc | 2021-09-06
Here you go: https://github.com/spesmilo/electrumx/ You'll need python 3.7 or later, and LevelDB https://github.com/google/leveldb Both available for Windows so it should work fine :)
The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:Project mention: Metabase VS Chartbrew - a user suggested alternative | libhunt.com/r/metabase | 2021-10-26
This bug is a total showstopper for our app, and it was randomly introduced in a minor version update way back in March: https://github.com/typeorm/typeorm/issues/7736
Run Linux Software Faster and Safer than Linux with Unikernels.
An easy-to-use multi SQL dialect ORM tool for Node.jsProject mention: Looking for a mentor who can teach me backend using node js. | reddit.com/r/node | 2021-10-21
👩💻👨💻 Awesome cheatsheets for popular programming languages, frameworks and development tools. They include everything you should know in one single file.Project mention: Awesome Cheatsheets | reddit.com/r/webdev | 2021-10-13
MongoDB object modeling designed to work in an asynchronous environment.Project mention: Transitioning from MySQL to MongoDB | dev.to | 2021-10-25
To go through this article, we'll use the Mongoose npm package.
Free universal database tool and SQL clientProject mention: How to Change Another User's Password? | reddit.com/r/dbeaver | 2021-10-06
CockroachDB - the open source, cloud-native distributed SQL database.Project mention: CockroachDB Grants and Schemas explained | dev.to | 2021-08-28
And here: https://github.com/cockroachdb/cockroach/issues/16790
Scalable datastore for metrics, events, and real-time analyticsProject mention: Honestly, is Go useful for anything but microservices? | reddit.com/r/golang | 2021-10-20
No, not really.
Automatic SQL injection and database takeover toolProject mention: How do password hashes reach the public? | reddit.com/r/cybersecurity | 2021-10-22
In the real life the syntax may become very cumbersome depending on the application and database specifics, filtering in place, etc. Tools like sqlmap do that automatically, so attackers don't construct the queries themselves.
A library that provides an embeddable, persistent key-value store for fast storage.Project mention: Hello guys , needed help for building a key-value data store | reddit.com/r/Database | 2021-10-09
- RocksDB - kv store that uses LSM tree;
The MongoDB DatabaseProject mention: Transitioning from MySQL to MongoDB | dev.to | 2021-10-25
The NoSQL database of choice we would be looking at today is MongoDB.
ClickHouse® is a free analytics DBMS for big dataProject mention: What is ClickHouse how it compares to PostgreSQL and TimescaleDB for time series | news.ycombinator.com | 2021-10-21
Hi Ajay! Thanks for the thoughtful response and email. I would love a direct meeting and will contact you shortly.
I don't mean to gloss over ClickHouse imperfections. There are lots of them. For my money the biggest is that it still takes way too much expertise in ClickHouse for ordinary developers to use it effectively. Part of that is SQL compatibility, part of it is lack of tools of which simple backup is certainly one. To the extent that ClickHouse is risky, the risk is finding (and retaining) staff who can use it properly. Our business at Altinity exists in large part because of this risk, so I know it's real.
The big aha! experience for me has been that the things like lack of ACID transactions or weak backup mechanisms are not necessarily the biggest issues for most ClickHouse users. I came to ClickHouse from a long background in RDBMS and transactional replication. Things that would be game ending in that environment are not in analytic systems.
What's more interesting (mind-expanding even) is that techniques like deduplication of inserted blocks and async multi-master replication turn out to be just as important as ACID & backups to achieve reliable systems. Furthermore, services like Kafka that allow you to have DC-level logs are an essential part of building analytic applications that are reliable and performant at scale. We're learning about these mechanisms in the same way that IBM and others developed ACID transaction ideas in the 1970s--by solving problems in real systems. It's really fun to be part of it.
My comment didn't convey this clearly, for which I heartily apologize. I certainly don't intend to portray ClickHouse as perfect and still less to bash Timescale. I don't know enough about the latter to make any criticism worth reading.
p.s., Non-transactional insert (specifically non-atomicity across blocks and tables) is an undisputed problem. It's being fixed in https://github.com/ClickHouse/ClickHouse/issues/22086. Altinity and others are working on backups. Backup comes up in my job just about every day.
Powerful, fast, and an easy to use search engineProject mention: Scaling Indexing and Search – Algolia New Search Architecture | news.ycombinator.com | 2021-10-15
REST API for any Postgres databaseProject mention: Can we trust Microsoft with Open Source? | news.ycombinator.com | 2021-10-23
That's not true, for example in PostgREST we setup a nix-shell that allows us to run tests in different PostgreSQL versions(from 9.6 to 14).
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite & MongoDB (Preview)Project mention: Contentlayer & Effect — Architectural Patterns And Decisions. | dev.to | 2021-10-25
Johannes Schickling — Founder of Prisma and creator of Contentlayer.
💾 Database Tools incl. ORM, Migrations and Admin UI (Postgres, MySQL & MongoDB)Project mention: Preferred SQL ORM | reddit.com/r/node | 2021-10-16
Mongoose is quite a standard also open-source, but Prisma is an emerging modern solution that seems to take the cake.
Native GraphQL Database with graph backendProject mention: Uber using External Consistency database Google Cloud Spanner | reddit.com/r/googlecloud | 2021-09-30
Thanks, cool. I will check out https://dgraph.io/
What are some of the best open-source Database projects? This list will help you:
Are you hiring? Post a new remote job listing for free.