Databases are such an essential building block of anything significant in I.T…
For the longest time, I have worked with relational databases such as MS SQL Server, Oracle and then #MySQL when it became usable (around v3.23).
MySQL later forked to MariaDB, which still has its place for data that requires referential integrity (it’s also well integrated into #homeassistant . However, for my own devs, I now prefer #clickhouse for log & time series data. I also like #SQLite for fast local-running databases.
In order to determine which MySQL version you're running you can type the following command: mysql -V
Sample results: # mysql -V mysql Ver 14.7 Distrib 4.1.11, for pc-linux-gnu (i386)
# mysql -V mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu…...
Once you start messing around with charsets in MySQL you eventually get to a situation where the default charset for your database is UTF-8 but you want to import old backups in their own charset, for instance ISO-LATIN-1. But when you import it, MySQL…...
Many people think that DB abstraction is cool. I get emails about this topic all the time. People suggesting we add a DB abstraction layer to b2evolution, or offering to do so themselves. So why haven't we added one yet? Well, simply because DB…...
Okay, I desperately lack time to write full articles posts lately, so I'm going to make this quick! :P Background: Suppose you have a table named Now, here's my point: from my experience I have found that a hell lot of things can go wrong when you try…...
I could not find anything like this on the net, so I thought I'd make my own chart and share it... ;) MySQL version 3.23.58 +InnoDB 4.0.22 4.1.7 5.0 Release date 11-sept-03 27-oct-04 23-oct-04 not stable yet Row level locking yes yes yes yes…...
PhpMyAdmin does a pretty decent job at exporting MySql database with their structure and/or their data to a plain SQL file. One thing bugged me though: it encloses every table/column/whatever name in backquotes like in Life is good! :D...
We had this quite interesting situation at work today: I export an UTF-8 MySQL database into an UTF_8 SQL file. I *binary* FTP the file over to him. He plays the SQL in PHPmyAdmin all configured for UTF-8. He then checks the data in PHPmyAdmin: special…...
Running an app under PHP 4.3.8 and trying to connect to a MySQL 4.1 database can be pretty frustrating. By default it gives you a message like this: "Client does not support authentication protocol requested by server; consider upgrading MySQL client".…...
Lately, I've seen quite a few people claiming XML to be the definitive way to store data, because it's supposed to be the most flexible format... Others claim RDBMSes have been providing an efficient solution to data storage for years or decades and…...
(via Cédric) Jim Gray [Links gone]: "Larry Ellison announced that Oracle is now running entirely on Linux. But he didn't say, "Incidentally we're going to run all of Oracle on MySQL on Linux." If you just connected the dots, that would be…...