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!
While it may not have reached the level of Laravel or Rails, the current efforts in the JS world have recognized this issue. If you look at the toolkit of the solution mentioned above, you'll find a common name: Prisma
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: The Notifier Pattern for Applications That Use Postgres | news.ycombinator.com | 2024-05-14Great post!
Postgres.js actually does this implicitly through a simple API[1] mimicking the postgres way, thereby using only a single dedicated connection for listening per process.
Listen/notify is also super useful with triggers.
[1] https://github.com/porsager/postgres
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
Project mention: Eradicating N+1s: The Two-Phase Data Load and Render Pattern in Go | news.ycombinator.com | 2024-05-28Jet can automatically load joined objects into embedded Go structs: https://github.com/go-jet/jet/wiki/Query-Result-Mapping-(QRM...
Depending on what you are doing there might be some duplication that you could remove by creating hash lookups as in this post, but I would reach for Jet first.
sqlc supports embedding but not embedded slices?
Project mention: Solving duplicate data with performant deduplication | news.ycombinator.com | 2023-11-22
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 | 3 Jun 2024
Index
What are some of the best open-source Cockroachdb projects? This list will help you:
Project | Stars | |
---|---|---|
1 | Netdata | 68,627 |
2 | Prisma | 37,690 |
3 | TypeORM | 33,531 |
4 | cockroach | 29,297 |
5 | postgres | 6,837 |
6 | sqlchat | 3,946 |
7 | PonyORM | 3,545 |
8 | upper.io/db | 3,487 |
9 | datastation | 2,857 |
10 | graphjin | 2,851 |
11 | sqitch | 2,721 |
12 | jet | 2,124 |
13 | Ebean ORM | 1,431 |
14 | gobuffalo/pop | 1,411 |
15 | sqlancer | 1,415 |
16 | gnomock | 1,316 |
17 | node-pg-migrate | 1,244 |
18 | Evolve | 826 |
19 | prisma-editor | 705 |
20 | postgresql-parser | 249 |
21 | dbbench | 97 |
22 | SQLGateway | 52 |
23 | dbdoc | 43 |
Sponsored