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. Learn more →
Top 23 Cockroachdb Open-Source Projects
-
-
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
-
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.
-
TypeORM
ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
-
-
postgres
Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare (by porsager)
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
upper.io/db
Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.
-
-
-
-
-
-
gnomock
Test your code without writing mocks with ephemeral Docker containers 📦 Setup popular services with just a couple lines of code ⏱️ No bash, no yaml, only code 💻
-
-
postgresql-parser
Pure Golang PostgreSQL (SQL:2011, SQL:2008, SQL:2003, SQL:1999, and SQL-92 Standard) Parser
-
dbbench
🏋️ dbbench is a simple database benchmarking tool which supports several databases and own scripts
-
SQLGateway
HTTP Gateway for SQL databases with connection pooling and caching. An Edge Functions's best friend.
-
dbdoc
Document your database schema, because your team will thank you, and a single text file makes it easy. Works well with PostgreSQL and others.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Project mention: A list of SaaS, PaaS and IaaS offerings that have free tiers of interest to devops and infradev | dev.to | 2024-02-05netdata.cloud — Netdata is an open-source tool to collect real-time metrics. It's a growing product and can also be found on GitHub!
In the world of software development, there are two kinds of developers: those who have never had to complain about ORMs and those who have actually used them. Whether it’s Django ORM for Python, Active Record for Ruby, GORM for Golang, Doctrine for PHP, or Prisma for TypeScript, a common issue persists: writing simple queries is straightforward, but constructing complex or optimized queries can take hours, if not days.
If you use Sequalize, TypeORM or for MongoDB, we have Mongoose these types of ORM tools, then you are safe by default because these help us against the SQL query injection attacks by default.
CockroachDB is an open source distributed SQL database designed for scalability and resilience. While it offers SQL databases, CockroachDB is also compatible with PostgreSQL.
Project mention: Neon Is Generally Available: Serverless Postgres | news.ycombinator.com | 2024-04-15I want to use this as a chance to bring attention to a GitHub issue that I think would help reduce friction for Neon:
https://github.com/neondatabase/neon/issues/4989
If the Neon driver were to allow us to easily pass in a localhost connection, the development and test experience would be easier. Perhaps Neon could swap to something like this internally: https://github.com/porsager/postgres.
Having run a local dev environment connected to Neon and tests connected to Neon got in our way of adoption. We'd prefer to develop and run tests against a regular Postgres localhost database.
To the PMs of Neon, put yourself in the shoes of a new developer thinking of giving Neon a try. What changes will I have to make to my code and my development workflow?
Project mention: The API database architecture – Stop writing HTTP-GET endpoints | news.ycombinator.com | 2024-05-10Yeah, I fully agree. The tooling for putting that much logic into the database is just not great. I've been decently happy with Sqitch[0] for DB change management, but even with that you don't really get a good basis for testing some of the logic you could otherwise test in isolation in app code.
I've also tried to rely heavily on the database handling security and authorization, but as soon as you start to do somewhat non-trivial attribute-/relationship-based authorization (as you would find in many products nowadays), it really isn't fun anymore, and you spend a lot of the time you saved on manually building backend routes on trying to fit you authz model into those basic primitives (and avoiding performance bottlenecks). Especially compares to other modern authz solutions like OPA[1] or oso[2] it really doesn't stack up.
[0]: https://github.com/sqitchers/sqitch
[1]: https://www.openpolicyagent.org
[2]: https://www.osohq.com
"I can make a JS or Go program perform the same way. In fact the exact same thing happened in my shop with Go/Gorm. The key question is: how do you compute the 5mb of JSON? The devil is in those details. We changed the way we computed ours, and the issue was gone."
The problem is ActiveRecord in my case. The data layout is not great (lots of joins through relationships, I thik 12 tables or so). What do you use (except raw sql) in Ruby if you cannot use ActiveRecord? I actually reimplemented the same API endpoint in Go using https://github.com/go-jet/jet and measured 10MB of allocations and essentially zero overhead over queries itself, a 50x speedup.
Project mention: Solving duplicate data with performant deduplication | news.ycombinator.com | 2023-11-22
Project mention: Connect()- a new API for creating TCP sockets from Cloudflare Workers | news.ycombinator.com | 2023-05-16Super excited for this! I had made https://github.com/danthegoodman1/SQLGateway as a result of not having this capability.
One issue I see is the cost of constantly opening and closing a TCP connection for something like the postgres example. Postgres specifically has quite a high cost for each connection. Pgbouncer helps, but this could still be pretty consequential at the concurrency that workers can offer.
Maybe in the future we could create local pools that can be shared across executions, similar to how AWS Lambda does it now?
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).
Cockroachdb related posts
-
Linux surpasses the Mac among Steam gamers
-
rage - a minimalistic load testing tool
-
Eli5: Why do companies use the products of Oracle to store information, when they can just use spreadsheets like Excel, or make their own spreadsheet software?
-
Connect()- a new API for creating TCP sockets from Cloudflare Workers
-
NextJS is fullstack, why some people use it only for frontend and how can you use it in fron end ?
-
I made a free landing page template using Next.js and Tailwind CSS
-
Prisma Editor - A powerful tool to visualize and edit Prisma Schema.
-
A note from our sponsor - InfluxDB
www.influxdata.com | 10 May 2024
Index
What are some of the best open-source Cockroachdb projects? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | Netdata | 68,352 |
| 2 | Prisma | 37,328 |
| 3 | TypeORM | 33,430 |
| 4 | cockroach | 29,148 |
| 5 | postgres | 6,750 |
| 6 | sqlchat | 3,765 |
| 7 | PonyORM | 3,528 |
| 8 | upper.io/db | 3,477 |
| 9 | datastation | 2,854 |
| 10 | graphjin | 2,842 |
| 11 | sqitch | 2,708 |
| 12 | jet | 2,076 |
| 13 | Ebean ORM | 1,429 |
| 14 | sqlancer | 1,408 |
| 15 | gobuffalo/pop | 1,409 |
| 16 | gnomock | 1,308 |
| 17 | node-pg-migrate | 1,235 |
| 18 | Evolve | 826 |
| 19 | prisma-editor | 678 |
| 20 | postgresql-parser | 248 |
| 21 | dbbench | 96 |
| 22 | SQLGateway | 52 |
| 23 | dbdoc | 42 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com