HackerTrans
TopNewTrendsCommentsPastAskShowJobs

magden

no profile record

Submissions

Postgres for analytics: these are the ways

justpostgres.tech
3 points·by magden·5 miesięcy temu·0 comments

Just Use Postgres the Book

manning.com
3 points·by magden·w zeszłym roku·1 comments

What Is the Open Source Alternative to CockroachDB?

medium.com
10 points·by magden·2 lata temu·6 comments

Postgres to YugabyteDB in 100 Apps: The Postgres App Century Challenge

yugabyte.com
1 points·by magden·2 lata temu·0 comments

Does Open Source Work as a Long-Term Business Model?

yugabyte.com
24 points·by magden·2 lata temu·3 comments

[2019] We Changed YugabyteDB Licensing to 100% Open Source

yugabyte.com
2 points·by magden·2 lata temu·1 comments

When to use distributed Postgres for gen AI apps?

yugabyte.com
1 points·by magden·2 lata temu·0 comments

YugabyteDB Moves Beyond PostgreSQL 11

yugabyte.com
2 points·by magden·2 lata temu·0 comments

Will Postgres use my index or not?

medium.com
1 points·by magden·2 lata temu·0 comments

Why Has Figma Reinvented the Wheel with PostgreSQL?

medium.com
169 points·by magden·2 lata temu·91 comments

[untitled]

1 points·by magden·2 lata temu·0 comments

What we learned in 6 months of working on an AI Developer

blog.pythagora.ai
63 points·by magden·2 lata temu·49 comments

Live Streaming the Super Bowl: The Art of Scaling Across Multiple Cloud Regions

yugabyte.com
32 points·by magden·2 lata temu·3 comments

Why Postgres RDS didn't work for us

medium.com
2 points·by magden·2 lata temu·1 comments

We switched to Java 21 virtual threads and got a deadlock in TPC-C for Postgres

blog.ydb.tech
280 points·by magden·2 lata temu·243 comments

comments

magden
·w zeszłym roku·discuss
I’ve always thought that "Just Use Postgres" would make an excellent title and topic for a book. And we’ve partnered with Manning to bring it to life.

Looking forward to your feedback on the TOC and chapters that have already been released. The book is current in the Manning Early Access Program (MEAP), which lets read it while I continue to write the chapters.
magden
·2 lata temu·discuss
Cool, works with my YugabyteDB deployment using the provided scripts for Postgres.
magden
·2 lata temu·discuss
1. Nope, I don't think that CRDB is generally faster than Yugabyte. Vendors can't say otherwise in their own benchmarks :)

3. That code must be the tooling around the db and various smart drivers (that extend default drivers of Postgres for various programming languages). Overall, the core database engine of Yugabyte is written in C.
magden
·2 lata temu·discuss
In light of the recent license changes by CockroachDB, their competitor (YugabyteDB) took another approach that seems to work well.
magden
·2 lata temu·discuss
Here is a detailed article covering various design patterns for multi-region deployments: https://www.yugabyte.com/blog/multi-region-database-deployme...
magden
·2 lata temu·discuss
(I'm the author of the article)

There are several design patterns depending on whether you need to optimize the latency for reads, writes, or both.

If it's all abour reads, then you can use follower reads (as shown in the article) or read replicas. If you also need writes, then a geo-partitioned deployment or standalone database instances for each region would be good starting points.