MariaDB has amd64 support.

Hi Tux,

I'm struggling to understand how defaults relate to migration (sql_mode?). Do you have time to provide me with more details? Which source databases do you consider here?

If dbeaver (feature request 10070) exposed the roles functionality that has been there since 10.0.5 would this be acceptable?

Other notable user-management options that have existed for a while, that can easily get missed are: account locking was added in 10.4.2 and password expiry in 10.4.3. The SUPER privilege was split up in 10.5.2.

With these it looks almost comparable to Postgres in terms of user management features. Or have I missed a key feature that still is required?

1. On windows file names are case insensative and tables are created the way the user used capitalisation on typing the "create table" SQL command. I've seen more than once that migration to file systems that are not case insensative will FAIL on the ANSI standard the typing table names in SQL commands is ought to be case insensative does not work. Likewise for compiled programs that use all lowercase vs all uppercase in SQL commands.

2. The default installation for mysql was (and I fear still is) prohibits spaces on places that will make end users curse: "select count (*) from foo;" is (was) not allowed in a default installation. (a space between count and (*)). This is for all functions.

So I need to add two lines to /etc/my.cnf to be able to work with MySQL/MariaDB at all

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,IGNORE_SPACE
lower_case_table_names=1

Easy on my own boxes, but not on servers or other peoples boxes

I *LOVE* DBeaver! It takes away most of my user-management issues for MySQL and Oracle.
Thanks for the extra links, I'm going to store them in my mysql notes

Maria

I vote SQLite, simply because it works out of the box, for all users. No admin privs required, no network setup, it just works.

PostgreSQL and performance in one sentence? Very cool. Performance is better than in 9.X versions, but query optimizer is still pretty primitive, at least compared to MS SQL Server. On SQL Server I write my query however and it's fast. On PostgreSQL - write however and it's slow, so then google, ask around for every trick imaginable - way faster than initial quickly written query, still slower than SQL Server.

You can even write inefficient code in Assembly... ;-)

MariaDB

Gotta vote for MariaDB

MariaDB agree
 

Yes agree MariaDB

Blah, meant to say arm64 support. And armhf/armel are packaged by Debian and others.

Not all ARMv8 (Aarch64) are created equal. All currently supported MariaDB server releases should work on the Raspberry Pi. Early 10.5 releases crashed on 64-bit Raspberry Pi models, but that was addressed by https://github.com/MariaDB/server/pull/1645.

MariaDB
 

MariaDB!!

Just joined
 

Just joined LinuxQuestions and looking forward to engaging. Happy New Year all!

Welcome to LQ, mmalgeri777. Please don't use the MCA threads for introductory postings. :)