Menu

One database, four dialects: MySQL, MariaDB, SQL Server and PostgreSQL clients on one server
📰

One database, four dialects: MySQL, MariaDB, SQL Server and PostgreSQL clients on one server

DEV Community: database·Rust Studio·about 2 hours ago
#ElvEqYgg
#devtodatabase#devto#dev#mysql#dialect
Reading 0:00
15s threshold

Count the databases your team runs. If you got to one, congratulations. Most of us get to three or four, and not because we wanted to:

the web app was written for MySQL ,

the reporting tool wants PostgreSQL ,

the vendor product you bought last year ships with SQL Server ,

the CMS is still on MariaDB .

Four installers, four backup scripts, four monitoring setups, four upgrade days.

I have been working on a database server called Raft DB that tries to give that back: one install that speaks all of those protocols, so you keep your drivers and your SQL and change only the address in the connection string.

What it looks like

After the install, each protocol has its usual port:

Client Port

MySQL / MariaDB 3306

SQL Server (T-SQL) 1433

PostgreSQL 5432

Raft DB native protocol, HTTP API, web studio 7480

(If a port is taken, the installer uses the next free one and prints which.) And you connect with the tools you already have:

mysql -h 127.0.0.1 -P 3306 -u admin -p psql "host=127.0.0.1 port=5432…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.