Planet MariaDB Server
Someone is deleting my shared memory segments!
When we work with PostgreSQL under our myEnv, we regularly get shared memory segment errors. Example: psql: error: connection to server on socket “/tmp/.s.PGSQL.5433” failed: FATAL: could not open shared…
Load CSV files into the database
Recently, I wanted to display the places of residence of the members of my club on a map for a personal gimmick (IGOC members). I knew the addresses of the…
Load CSV files into the database
Recently, I wanted to display the places of residence of the members of my club on a map for a personal gimmick (IGOC members). I knew the addresses of the…
PGDay and FOSDEM Report from Kai
The following thoughts and comments are completely my personal opinion and do not reflect my employers thoughts or beliefs. If you don’t like anything in this post, reach out to…
New binlog implementation in MariaDB 12.3
I have recently completed a large project to implement a new improved binlog format for MariaDB. The result will be available shortly in the upcoming MariaDB 12.3.1 release. In this…
New binlog implementation in MariaDB 12.3
I have recently completed a large project to implement a new improved binlog format for MariaDB. The result will be available shortly in the upcoming MariaDB 12.3.1 release. In this…
Hackorum – A Forum-Style View of pg-hackers
Last year at pgconf.dev, there was a discussion about improving the user interface for the PostgreSQL hackers mailing list, which is the main communication channel for PostgreSQL core development. Based…
Tuning MySQL for Performance: The Variables That Actually Matter
There is a special kind of boredom that only database people know. The kind where you stare at a server humming along and think, surely there is something here I…
The concepts of forking
Lately there has been a lot of discussion about “hard” or “soft” forks related to MySQL. As someone who has done a successful fork of MySQL, I think this is…
The concepts of forking
Lately there has been a lot of discussion about “hard” or “soft” forks related to MySQL. As someone who has done a successful fork of MySQL, I think this is…
SQL Savepoints and When to Use Them
Not many developers know about savepoints in relational databases. Even less of them know when to use them. It’s not their fault: I can’t remember seeing a good explanation of…
MariaDB doesn’t depend on MySQL
Thoughts on how MariaDB is incorrectly perceived merely as a fork of MySQL and how MariaDB is independent from MySQL yet highly compatible
Vettabase and HammerDB Partner to de-Risk Database Migrations
Vettabase and HammerDB are announcing a partnership to de-risk and assist database migrations. As vendor-independent companies that offer services for multiple database technologies, Vettabase and HammerDB intend to help organisations…
Distributed, Multi-Database Transactions Involving MariaDB and PostgreSQL
In some situations, an application needs to run a single logical transaction that involves multiple database technologies: in our example, they’ll be MariaDB and PostgreSQL. This is not an optimal…
OIDC in PostgreSQL: With Keycloak
We spent a long time, two blog posts to be specific, talking about OAuth/OIDC in theory. Now we’ll take a more practical look at the topic: how can we configure…