YugaByteDB

Reduce the complexity: be sharing and open source

By Franck Pachot . I thought that my last post on this blog was the previous one but I blog when it comes to my mind – nothing planned. And two things got me to write(…)

See you on Polywork (an new LinkedIn?)

By Franck Pachot . I have published 105 additional blog posts here since the 500th one https://www.dbi-services.com/blog/rollback-to-savepoint/ that I have written on my come back to dbi-services. On Oracle Database, of course, other databases as well,(…)

K8s on Windows/VirtualBox

By Franck Pachot . This is a little demo, easy to copy-paste, if you want to play with Kubernetes on your laptop. And, not a simple “Hello World” but a real database running here, able to scale up and(…)

Foreign Keys in MySQL, SQL, NoSQL, NewSQL

By Franck Pachot . In the NoSQL times, it was common to hear thinks like “SQL is bad”, “joins are bad”, “foreign keys are bad”. Just because people didn’t know how to use them, or they were running on(…)

The myth of NoSQL (vs. RDBMS) “joins dont scale”

By Franck Pachot . I’ll reference Alex DeBrie article “SQL, NoSQL, and Scale: How DynamoDB scales where relational databases don’t“, especially the paragraph about “Why relational databases don’t scale”. But I(…)

ysql_bench: the YugaByteDB version of pgbench

By Franck Pachot . This follows the previous post on testing YugaByteDB 2.1 performance with pgbench: https://www.dbi-services.com/blog/yugabytedb-2-1/ A distributed database needs to reduce inter-node synchronization latency and then replaces two-phase pessimistic locking by(…)

YugaByteDB 2.1: the Open Source multi-region distributed database with PostgreSQL API is in GA with huge performance improvement

By Franck Pachot . 9 months ago I was looking at YugaByteDB which was still in beta version for its 'YSQL' API. I published my first test on Medium: https://medium.com/@FranckPachot/running-pgbench-on-yugabytedb-1-3-3a15450dfa42. I have been very enthusiastic about(…)