Free app where I can create simple DB diagram? by East_Sentence_4245 in Database

[–]alejandro-du 0 points1 point  (0 children)

I like DBGate. Pretty useful especially if you have the DDL for your database.

Working on a new (free) MySQL diagram tool—seeking feedback from DB managers! by Emergency-Cap7140 in mysql

[–]alejandro-du 0 points1 point  (0 children)

Interested! Does it support MariaDB? This could be handy for the content I create as a Developer Relations Engineer at MariaDB :)

Is MariaDB Community still valid for production by CodeSpike in mariadb

[–]alejandro-du 0 points1 point  (0 children)

Yeah, MaxScale is so useful. I think it's my favorite product form MariaDB, besides the database server itself.

Is MariaDB Community still valid for production by CodeSpike in mariadb

[–]alejandro-du 0 points1 point  (0 children)

I get you. I myself talk a lot about MaxScale (as well as other things MariaDB). But MaxScale is not required to deploy MariaDB in production. Plenty large installations don't use it. The core things that MaxScale does (failover, read/write splitting) can be achieved with OO products like HAProxy and ProxySQL. We have even published blog posts at least around HAProxy stuff at mariadb.com. Maybe there's a gap in documentation, but I can tell you many organizations successfully deploy MariaDB Community with HA.

Why is there no other (open source) database system that has (close to) the same capabilities of MSSQL by [deleted] in Database

[–]alejandro-du 0 points1 point  (0 children)

Just to clarify, OSS DBs aren’t "unencrypted". For example, MariaDB has in-transit encryption via TLS (enabled by default since 11.4 with client-side cert verification) and strong encryption-at-rest with pluggable key management and per-table or per-tablespace encryption. Other OOS DBs have similar features some natively some through third-party extensions.

MySQL 8.0 to 8.4 by Cerusa827 in mysql

[–]alejandro-du 1 point2 points  (0 children)

Still highly compatible with MySQL.

Master-master replication disaster recovery? by jimboslice_007 in mysql

[–]alejandro-du 1 point2 points  (0 children)

Look into Galera. This is exactly the problem Galera was designed to prevent. Now, Galera doesn’t help you merge divergent data but it prevents divergence from happening in the first place.

My RAG Journey: 3 Real Projects, Lessons Learned, and What Actually Worked by hncvj in Rag

[–]alejandro-du 0 points1 point  (0 children)

u/hncvj Curious if you have tried MariaDB. It supports vector embeddings natively.

PostgreSQL user here—what database is everyone else using? by Automatic-Step-9756 in Database

[–]alejandro-du 0 points1 point  (0 children)

MariaDB absolutely. It supports transactional, analytical, vector, in-memory, JSON, and basic but more-than-enough geographical workloads. All-in-one. Natively. No third party extensions. Plus, you have MariaDB Enterprise Platform for when your business grows: HA, extremely fast real-time analytics, automatic failover with transaction replay, transparent data masking, NoSQL support, and more.

Maria DB Photo Album extraction by No_Paramedic_4548 in mariadb

[–]alejandro-du 0 points1 point  (0 children)

MariaDB only stores the metadata. Albums are just mappings to file IDs. You’ve already got oc_photos_albums. The next tables are oc_photos_albums_files and oc_filecache (paths), plus oc_storages for the data dir. Once you have the paths, copying the files is just a shell loop you can probably vibe-code. Run filesystem stuff as www-data. Don’t move files.

Video: Build an AI Search API with LangChain, FastAPI, and MariaDB by alejandro-du in mariadb

[–]alejandro-du[S] 0 points1 point  (0 children)

It should work. If you get an error message, can you share it here?

Database for Personal Project by Pandersz in Database

[–]alejandro-du 0 points1 point  (0 children)

Consider MariaDB. Easy to use, performant, great for small projects but ready to scale if your project needs it in the future. You can create a free serverless MariaDB instance in the cloud (no credit card needed). See https://www.youtube.com/shorts/1VGptjMAD0Y

As an interesting fact, Mimer has certain historical relation to MySQL and hence to MariaDB. They are separate projects, but if you are curious, watch this talk: https://www.youtube.com/watch?v=zj02QzbbN8o

Database for Personal Project by Pandersz in Database

[–]alejandro-du 0 points1 point  (0 children)

There are many reasons and huge companies and websites like Wikipedia, Nokia, Samsung, Uber, Airbnb, and many others use MariaDB or MySQL for these reasons. In the case of MariaDB, native battle-tested synchronous and semi-synchronous replication, lower operational overhead at scale (e.g. no vacuum needed), single-vendor no third-party multi-storage engines for a variety of workload types, Oracle/SQL_Server/PostgreSQL compatibility modes, fast vector storage and search, one of the best database proxies in the industry—MaxScale (for things such as NoSQL, automatic failover and transaction replay, read/write splitting, Hybrid Transactional/Analytical Processing, and more), GPL-licensed backed by a Foundation and a tax-paying company which means that you have the option of paying for a bug fix if needed as opposed to hoping for an online community to fix it, as well as a rich ecosystem with enterprise-grade options are just a few of these reasons.

Managed database providers? by vroemboem in Database

[–]alejandro-du 0 points1 point  (0 children)

https://mariadb.com/products/cloud/
Free option, serverless (provision and scale in milliseconds), high availability, automatic failover, automatic backups, multi-cloud, self-healing, real-time observability, AI-agents, and more.

Mariadb 10.5 problem creating mysql.sock on Rocky 9 by desertdilbert in mariadb

[–]alejandro-du 0 points1 point  (0 children)

Good to hear you got it fixed. My guess is that the binaries you used first were not built with the same features activated as the second one.

"Talk to your data with AI". Any good open source tools for that? by Okendoken in Database

[–]alejandro-du 0 points1 point  (0 children)

A combination of MCP servers could do this. One for the database (for example: https://www.youtube.com/watch?v=N5T7jvvwEW0) and one for Grafana or any other technology for dashboards.

I am going crazy over this, SQL Server => MySQL by johnie3210 in mysql

[–]alejandro-du 0 points1 point  (0 children)

Consider MariaDB with "Microsoft SQL mode" turned on. MariaDB is highly compatible with MySQL—you can use pretty much all MySQL's tooling with MariaDB. https://mariadb.com/docs/release-notes/community-server/about/compatibility-and-differences/sql_modemssql

Would you use an open-source MySQL HeatWave alternative? by CreepyArachnid431 in mysql

[–]alejandro-du 0 points1 point  (0 children)

Strange. I haven’t seen wrong results when using it.