r/mariadb • • Nov 30 '25

ChatGPT: MariaDB is the quiet, sensible grown-up in the corner wearing beige pants

9 Upvotes

I won't bore you with the entire conversation, but I asked ChatGPT why everyone says Postgres is better than MariaDB, and this is what it led with (this isn't meant to be a Postgres vs the world post, I just thought the reply was funny and wanted to share):

Postgres has a huge developer-culture hype wave

Postgres is the darling of:

  • tech Twitter

  • indie devs

  • YC startups

  • Rails and Django communities

  • the “JSONB solved everything!” crowd

  • engineers who came from MySQL 5.0 era trauma

It became a kind of identity database.
Like how people swear by Arch Linux or swear that Rust is the only safe language.

MariaDB?
It’s the quiet, sensible grown-up in the corner wearing beige pants.

MariaDB/MySQL’s strengths are in the trenches, not in blog-posts

When your workload is:

  • high-throughput writes

  • low-latency reads

  • simple hot-paths

  • microsharded key-value style data

  • billions of tiny rows

  • massive concurrency

  • replication fan-out

  • multi-version upgrades without downtime

MariaDB/MySQL is boringly fast and predictable.

That doesn’t win popularity contests, but it wins production battles.


r/mariadb • • Jan 10 '25

XAMPP is not secure - Announcement - Apache + MariaDB + PHP + Perl + OpenSSL etc

Thumbnail
github.com
0 Upvotes

r/mariadb • • Dec 18 '24

Can't get Mariadb and excel for mac to work

0 Upvotes

I've got homeBrew installed

I've got the MariaDB installed

I created a blank db and imported data into it

I installed the mariadb odbc connector

But I can't figure out how to make excel connect to the data.

Can anyone help


r/mariadb • • Feb 09 '26

PostgreSQL vacuuming: the real operational cost

Thumbnail
reddit.com
1 Upvotes

r/mariadb • • Dec 08 '23

Let's say you want to build a frontend on top of data stored in MariaDB! How would you do that?

1 Upvotes

Hey everyone,

Recently I have started using MariaDB and have my employee data stored in it. Now I am looking to build a frontend on it, as my frontend would fetch data from MariaDB, there will be a few dashboards controls to display some important metrics, and also it should let me perform CRUD on the database.

How will you build this kind of frontend on top of MariaDB? Any tool suggestions?


r/mariadb • • Apr 06 '23

MariaDB.com is dead, long live MariaDB.org

Thumbnail medium.com
8 Upvotes

r/mariadb • • Feb 06 '25

Apache Log Parser and Data Normalization Application | Application runs on Windows, Linux and MacOS | Database runs on MySQL and MariaDB | Track log files for unlimited Domains & Servers | Entity Relationship Diagram included

0 Upvotes

Python handles File Processing & MySQL or MariaDB handles Data Processing

ApacheLogs2MySQL consists of two Python Modules & one Database Schema apache_logs to automate importing Access & Error files, normalizing log data into database and generating a well-documented data lineage audit trail.

Database Schema is designed for data analysis of Apache Logs from unlimited Domains & Servers.

Database Schema apache_logs currently has 55 Tables, 908 Columns, 188 Indexes, 72 Views, 8 Stored Procedures and 90 Functions to process Apache Access log in 4 formats & Apache Error log in 2 formats. Database normalization at work!

https://willthefarmer.github.io/


r/mariadb • • Dec 08 '25

Mirror, Mirror on DB-Engines: The MariaDB Story

Thumbnail
mariadb.org
0 Upvotes

r/mariadb • • Dec 25 '25

Maria DB Photo Album extraction

0 Upvotes

Hello guys,

I have a Nextcloud Ubuntu server at home for my family (with MariaDB). Each family member has their own area where they can upload photos (I use the Memories extension). I have also created a family album where everyone can upload photos from their own area. Now I want to copy all these photos (the ones from the album) into a folder so that they can be displayed on a digital picture frame. So far, I have managed to find the individual photos in the MariaDB terminal.

However, I am now struggling to turn this into a script. It would be great if someone could help me.

Here is my previous work:

maximilian@macmini:**~**$ mysql -u nuser -p nextcloud

Enter password: 

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 3033

Server version: 10.11.13-MariaDB-0ubuntu0.24.04.1 Ubuntu 24.04

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [nextcloud]> SELECT album_id, name  FROM oc_photos_albums;

+----------+---------+

| album_id | name    |

+----------+---------+

|        2 | Familie |

+----------+---------+

1 row in set (0.001 sec)

MariaDB [nextcloud]> SELECT

->   f.fileid,

->   f.name,

->   f.path,

->   a.album_id

-> FROM oc_photos_albums_files a

-> JOIN oc_filecache f ON a.file_id = f.fileid

-> WHERE a.album_id = 2;

+--------+----------------------+-----------------------------------+----------+

| fileid | name                 | path                              | album_id |

+--------+----------------------+-----------------------------------+----------+

|   1527 | tempImageqOd6G7.heic | files/Photos/tempImageqOd6G7.heic |        2 |

|   1601 | IMG_3745.jpeg        | files/Photos/IMG_3745.jpeg        |        2 |

|   1602 | IMG_3746.jpeg        | files/Photos/IMG_3746.jpeg        |        2 |

|   1603 | IMG_3747.jpeg        | files/Photos/IMG_3747.jpeg        |        2 |

|   1604 | IMG_3744.jpeg        | files/Photos/IMG_3744.jpeg        |        2 |

|   1605 | IMG_3748.jpeg        | files/Photos/IMG_3748.jpeg        |        2 |

|   1606 | IMG_3743.jpeg        | files/Photos/IMG_3743.jpeg        |        2 |

|   1607 | IMG_3741.jpeg        | files/Photos/IMG_3741.jpeg        |        2 |

|   1672 | IMG_2685.jpeg        | files/Photos/IMG_2685.jpeg        |        2 |

+--------+----------------------+-----------------------------------+----------+

9 rows in set (0.001 sec)


r/mariadb • • Nov 24 '21

#13:How to Install MariaDB in Ubuntu 20.04 LTS | Secure MariaDB On Ubunt...

Thumbnail
youtube.com
0 Upvotes

r/mariadb • • Dec 12 '18

What are the benefits of using MariaDB over the Oracle Database?

0 Upvotes

r/mariadb • • Apr 15 '24

If your database is a MariaDB database, when you put it up on the server, is it just a .mariadb file, or how exactly does that work? I have been reading up on how a person queries one with Javascript/Python, and, I think wikipedia actually use MariaDB..so, it seemed good as a database?

0 Upvotes

putting mariadb on a server?


r/mariadb • • Jan 15 '19

Migrating from Mariadb to Mysql

0 Upvotes

I have mariadb , i want to migrate to Mysql from Mariadb

I couldn't find any official documentation. Please if you have any walkthroughs on migrating from Mariadb to Mysql


r/mariadb • • Sep 07 '21

SQL Server Crashing

0 Upvotes

Hi Guys,

I'm learning about MariaDB and running into some issues on my SQL Server. It seems the SQL server is consistently crashing every few days. I'm trying to figure out why but not sure where to start.

Any pointers would be greatly appreciated!


r/mariadb • • Aug 17 '22

How do you connect to systemd-journal using the CONNECT engine?

0 Upvotes

Assuming the systemd-journal format is good, I want to connect to it with the database engine and read from it. If the format is not good, why not.


r/mariadb • • Nov 11 '21

Having trouble with a password hash trigger

0 Upvotes

I built my trigger in HeidiSQL as a before insert trigger.

BEGIN
	SET @t = NOW();
--   SET @t = 0;
	SET NEW.CreationTime = @t;
-- 	SET @pass = NEW.PassHash;
	SET @pass = "";
	SELECT NEW.PassHash INTO @pass;
	INSERT INTO debuglog (Message) VALUES (@pass);
	INSERT INTO debuglog (Message) VALUES (NEW.PassHash);
	INSERT INTO debuglog (Message) VALUES (@t);

	SET @passHash = SHA2(CONCAT(NEW.CreationTime, @pass), 256);
	INSERT INTO debuglog (Message) VALUES (@passHash);
	SET NEW.PassHash = @passHash;
	INSERT INTO debuglog (Message) VALUES ('DONE');
--	SET NEW.ID2 = NEW.ID;
END

The INSERT INTO code is for logging, the commented out parts are different things I've tried.

The problem: Every variation of this code generates an incorrect hash from SHA2 when the password is obtained from NEW.PassHash. If I instead SET @pass='qwerty' and then insert a new user, the code works correctly.

How I know its not working: Hash generated from SHA2(CONCAT(NEW.CreationTime, New.PassHash (or @pass if its set to NEW.PassHash)) for my most recent entry: 4099c6e334b0454e4fe6b4f25dce0d7cc9db47f79ae4c79a1c8ed27b78154ecd

Hash generated using the same info (by looking up the creation time), but in the console (CODE: SHA2(CONCAT('2021-11-10 21:22:00', 'qwerty'), 256);): 38851446d079e6887e84c97f7e0115a72f5a315e4cad49722b51c8d152243264

That same hash (the second one) is the one I get from inputting 2021-11-10 21:22:00qwerty into https://passwordsgenerator.net/sha256-hash-generator/

EDIT: This is a testing solution. My final implementaiton will be in an admin client that will manage users, Right now I am just trying to get something in place thats good enough to test regular user authentication.

EDIT2: The answer was that somehow the trigger is operating using a different character encoding than UTF8, and I confirmed this by performing various test hashes in C#. Converting a string to a byte array of via Encoding.Convert(Encoding.Unicode, Encoding.UTF8, myArray); produced the same hash as the console did, so I just wrote an app that inserts a root user in, and gave it the appropriate role to add users for initial setup of the admin account. I'm gonna say this is solved, even though its not since no one actually bothered to answer, and I never recieved a response that contained any resemblence of a fix for the actual problem, as opposed to "Dur Hur don't do it that way". I also wont be coming back here for help, gate keepers have no place in any development or programming community. Thanks for nothing.


r/mariadb • • Sep 20 '22

What is your opinion on Confidential computing?

0 Upvotes

Hey folks,

working with mariadb you might be looking for a solution to protect your data in use.

What do you know and think about confidential computing?

Quickly explained: https://youtu.be/LZ10X1AlnJs

enclaive.io is adressing this challenge. Check out the work and I am looking forward to what you think:

https://github.com/enclaive


r/mariadb • • Aug 27 '22

Download the open source edition from MariaDB.com or MariaDB ?

2 Upvotes

So there is MariaDB.com and MariaDB.org; One is the Corp and the other is the Foundation, but how different is the Community Edition (available in com), and the Server Edition (available in org)..

Such basic questions, yet neither site provides clarity on what's what.. back to MySql I go, hello Oracle


r/mariadb • • Jan 25 '23

I'll just leave this here (👏 to whoever made this)

Post image
8 Upvotes

r/mariadb • • Aug 16 '26

Looking for feedback on a lightweight MariaDB client I'm developing

0 Upvotes

Hi,

I'm developing a Windows database client called TrapSQL and I'd like to get some feedback from MariaDB users.

My goal is to create a relatively lightweight tool for everyday database work without making the interface unnecessarily complicated.

Currently it provides:

MariaDB/MySQL database browsing

SQL editor

query execution and history

browsing table data

easy navigation through related tables

an AI assistant that can help with SQL queries

OpenAI

I'm particularly interested in making TrapSQL useful for developers who spend a lot of time exploring existing databases and relationships between tables.

For those of you using MariaDB professionally:

What would a new database client need to offer for you to consider switching from your current tool?

TrapSQL is free and available for Windows:

https://apps.microsoft.com/detail/xpfg27z9595v2r

Any feedback is appreciated.

10 votes, Aug 23 '26
4 I need fast and simple database/table browsing
1 I need Easy navigation between related tables
2 Powerful SQL editor
0 AI assistance for writing and explaining SQL
2 Database administration tools
1 Something else – tell me in the comments

r/mariadb • • 1d ago

Blog post MariaDB Foundation TAF: What happens when we give MariaDB more machine?

Post image
0 Upvotes

With AMD supporting MariaDB Foundation, we're preparing TAF to push MariaDB at scale on AMD EPYC hardware and investigate where scaling changes and why.

Here's the plan, along with links to the new TAF test cases:

https://mariadb.org/from-big-iron-to-amd-epyc-preparing-taf-to-push-mariadb-at-scale/

To all, “Happy benchmarking!”


r/mariadb • • Oct 13 '20

Best way to replicate clusters between clouds

1 Upvotes

I have a mariadb Galera cluster setup with a cloud provider and require it to be replicated onto a cluster on a different cloud provider, what would be some ideas as the best way to achieve that.


r/mariadb • • Jan 06 '21

The Most Popular Databases - 2006/2020 - Statistics and Data

Thumbnail
statisticsanddata.org
1 Upvotes

r/mariadb • • May 26 '23

False documentation on replication with TLS

1 Upvotes

Hi,

I hope a MariaDB developer/maintainer reads this.
Several options in CHANGE MASTER TO, for example MASTER_SSL_CA, have the following text in their documentation: ' This option implies the MASTER_SSL option.'

This is false. In fact, there is a comment at the bottom of that very page where someone reported this over a year ago. MASTER_SSL=1 must be explicitly set.

I am too lazy to create a jira account to report this. But maybe I can save people a few hours of debugging with this post.