HackerTrans
TopNewTrendsCommentsPastAskShowJobs

magden

no profile record

Submissions

Postgres for analytics: these are the ways

justpostgres.tech
3 points·by magden·5 months ago·0 comments

Just Use Postgres the Book

manning.com
3 points·by magden·last year·1 comments

What Is the Open Source Alternative to CockroachDB?

medium.com
10 points·by magden·2 years ago·6 comments

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

yugabyte.com
1 points·by magden·2 years ago·0 comments

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

yugabyte.com
24 points·by magden·2 years ago·3 comments

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

yugabyte.com
2 points·by magden·2 years ago·1 comments

When to use distributed Postgres for gen AI apps?

yugabyte.com
1 points·by magden·2 years ago·0 comments

YugabyteDB Moves Beyond PostgreSQL 11

yugabyte.com
2 points·by magden·2 years ago·0 comments

Will Postgres use my index or not?

medium.com
1 points·by magden·2 years ago·0 comments

Why Has Figma Reinvented the Wheel with PostgreSQL?

medium.com
169 points·by magden·2 years ago·91 comments

[untitled]

1 points·by magden·2 years ago·0 comments

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

blog.pythagora.ai
63 points·by magden·2 years ago·49 comments

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

yugabyte.com
32 points·by magden·2 years ago·3 comments

Why Postgres RDS didn't work for us

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

comments

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