HackerTrans
TopNewTrendsCommentsPastAskShowJobs

magden

no profile record

Submissions

Postgres for analytics: these are the ways

justpostgres.tech
3 points·by magden·5 mesi fa·0 comments

Just Use Postgres the Book

manning.com
3 points·by magden·anno scorso·1 comments

What Is the Open Source Alternative to CockroachDB?

medium.com
10 points·by magden·2 anni fa·6 comments

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

yugabyte.com
1 points·by magden·2 anni fa·0 comments

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

yugabyte.com
24 points·by magden·2 anni fa·3 comments

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

yugabyte.com
2 points·by magden·2 anni fa·1 comments

When to use distributed Postgres for gen AI apps?

yugabyte.com
1 points·by magden·2 anni fa·0 comments

YugabyteDB Moves Beyond PostgreSQL 11

yugabyte.com
2 points·by magden·2 anni fa·0 comments

Will Postgres use my index or not?

medium.com
1 points·by magden·2 anni fa·0 comments

Why Has Figma Reinvented the Wheel with PostgreSQL?

medium.com
169 points·by magden·2 anni fa·91 comments

[untitled]

1 points·by magden·2 anni fa·0 comments

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

blog.pythagora.ai
63 points·by magden·2 anni fa·49 comments

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

yugabyte.com
32 points·by magden·2 anni fa·3 comments

Why Postgres RDS didn't work for us

medium.com
2 points·by magden·2 anni fa·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 anni fa·243 comments

comments

magden
·anno scorso·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 anni fa·discuss
Cool, works with my YugabyteDB deployment using the provided scripts for Postgres.
magden
·2 anni fa·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 anni fa·discuss
In light of the recent license changes by CockroachDB, their competitor (YugabyteDB) took another approach that seems to work well.
magden
·2 anni fa·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 anni fa·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.