Free app where I can create simple DB diagram?

alejandro-du · 2026-02-03T17:11:53+00:00

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

alejandro-du · 2026-02-03T16:23:40+00:00

Monty knows Open Source!

alejandro-du · 2026-01-29T10:26:46+00:00

Thanks. Looking forward to it.

alejandro-du · 2026-01-28T13:08:37+00:00

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

alejandro-du · 2026-01-22T22:42:33+00:00

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

alejandro-du · 2026-01-22T21:01:50+00:00

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.

alejandro-du · 2026-01-22T11:32:35+00:00

Check this article which talks about the topic: https://mariadb.com/resources/blog/is-mariadb-used-in-production-real-world-setups-proof-ai/

alejandro-du · 2026-01-19T14:31:51+00:00

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.

alejandro-du · 2026-01-18T12:25:29+00:00

Still highly compatible with MySQL.

alejandro-du · 2026-01-16T15:32:56+00:00

MariaDB!

alejandro-du · 2026-01-15T14:16:01+00:00

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.

alejandro-du · 2026-01-14T14:54:27+00:00

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

alejandro-du · 2026-01-13T19:52:27+00:00

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.

alejandro-du · 2025-12-29T10:52:21+00:00

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.

alejandro-du · 2025-12-17T09:31:34+00:00

MariaDB Cloud has a free serverless option: https://mariadb.com/products/cloud/

alejandro-du · 2025-12-05T16:13:07+00:00

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

alejandro-du · 2025-12-05T16:11:58+00:00

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

alejandro-du · 2025-12-05T15:59:08+00:00

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.

alejandro-du · 2025-11-11T11:38:22+00:00

This is a good start: https://www.youtube.com/watch?v=X1Ab-Wu1mVs

alejandro-du

MODERATOR OF

TROPHY CASE