I see some discussion abour MariaDB
I switched to PostgreSql long ago, and it works well.
Can any Clarion programmer explain why MariaDB is his/her favourite ?
Maria is a fork off MySql. I never really got into either.
They lacked some of the advanced features I wanted in a DB, like relational constraints. It was a good lightweight fast DB for web use though.
I’ve standardised on postgres, which has everything, and it’s gained enough performance to rival MySql/Maria.
2 Likes
Editors, languages, SQL databases, AI engines, whatever…
90% of the time it boils down to “it’s the one we’re most familair with, the one we’ve used before, the one we are used to.”
Sure, there are differences, but for most work (especially Clarion type work) those differences are minor. Most programs treat the SQL database as a storage engine, and frankly there are a whole host of databases that will do that job perfectly well.
1 Like
MariaDB is our current “favourite”, and probably will be for some years to come.
We gave been building, maintaining and expanding our core product (on-premises production system with all kinds of additions - I’m guessing about 150-200 installations) for our clients for about 30 years now. Built in Clarion (mostly hand-coded, class structured, multi-dll,…), with recent additional growing codesets in c#, Kotlin, Swift, and others - but all working off the same db - be it via direct db access, desktop, mobile apps, api’s, …
A solid, stable, fast database is - of course - critical.
For our first 25-odd years MySQL had been our db. And it is good! And free! (???) (No wonder it still is the most widely used db)
However - after many unsuccessful attempts to figure out exactly how MySQL’s licensing model could potentially impact us or our clients, we opted to slowly move to MariaDB shortly after the fork happened. The migration had (so far) been relatively painless…some nuance differences with MySQL here-and-there… some instances where MariaDB seems faster. And the licensing is OK (free for all basically).
That being said… peering over the fence these days towards PostgreSQL with some wonder, the grass looks pretty green over there. But alas! It would not be practical for use to migrate again now… we have no issues with MariaDB anyway - works fine, fast, stable - no licensing threats on the horizon…
2 Likes