HackerTrans
TopNewTrendsCommentsPastAskShowJobs

magden

no profile record

Submissions

Postgres for analytics: these are the ways

justpostgres.tech
3 points·by magden·قبل 5 أشهر·0 comments

Just Use Postgres the Book

manning.com
3 points·by magden·السنة الماضية·1 comments

What Is the Open Source Alternative to CockroachDB?

medium.com
10 points·by magden·قبل سنتين·6 comments

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

yugabyte.com
1 points·by magden·قبل سنتين·0 comments

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

yugabyte.com
24 points·by magden·قبل سنتين·3 comments

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

yugabyte.com
2 points·by magden·قبل سنتين·1 comments

When to use distributed Postgres for gen AI apps?

yugabyte.com
1 points·by magden·قبل سنتين·0 comments

YugabyteDB Moves Beyond PostgreSQL 11

yugabyte.com
2 points·by magden·قبل سنتين·0 comments

Will Postgres use my index or not?

medium.com
1 points·by magden·قبل سنتين·0 comments

Why Has Figma Reinvented the Wheel with PostgreSQL?

medium.com
169 points·by magden·قبل سنتين·91 comments

[untitled]

1 points·by magden·قبل سنتين·0 comments

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

blog.pythagora.ai
63 points·by magden·قبل سنتين·49 comments

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

yugabyte.com
32 points·by magden·قبل سنتين·3 comments

Why Postgres RDS didn't work for us

medium.com
2 points·by magden·قبل سنتين·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·قبل سنتين·243 comments

comments

magden
·السنة الماضية·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
·قبل سنتين·discuss
Cool, works with my YugabyteDB deployment using the provided scripts for Postgres.
magden
·قبل سنتين·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
·قبل سنتين·discuss
In light of the recent license changes by CockroachDB, their competitor (YugabyteDB) took another approach that seems to work well.
magden
·قبل سنتين·discuss
Here is a detailed article covering various design patterns for multi-region deployments: https://www.yugabyte.com/blog/multi-region-database-deployme...
magden
·قبل سنتين·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.