27 posts
Sometimes you can't install MariaDB with apt/yum, or you want every node in a database cluster running exactly the same MariaDB version. My motivation this time was building a MariaDB cluster with identical versions across nodes for easier management.
If you use the Flowable/Activiti process engine and the application hangs on startup with the error 'liquibase - Waiting for changelog lock....', it means a database table's lock was never released. This isn't a database-level table lock, so you won't find any locked table by querying — it's a logical lock.
A project needed KingbaseES V8 R3, but the vendor pulled the R3 download page, so people kept grabbing V8 R6 instead. R6 drivers and management clients cannot connect to an R3 database, and R6 and R3 cannot back up or restore to each other directly.
Tired of domestic databases shipping no macOS installer while doing localization work? This tutorial runs Kingbase V8 R3 (a Chinese domestic database) in a Docker container on macOS, giving your MacBook a working Kingbase development environment.
We use Redis at work to cache and speed up static content. Since it was a dev environment I just spun up a Redis image in Docker and skipped setting a password, figuring iptables would keep me safe. Recently it started misbehaving.
Last time we learned what Hive is. This post walks you through installing and deploying Hive so you can try this legendary data warehouse yourself.
Newer DBeaver versions no longer support ODBC connections, probably because the JDBC-ODBC bridge was removed from Java 8. So the old tutorials telling you to use ODBC no longer work. Here's the correct way to connect DBeaver to DaMeng.
The original post derived two complements, CuB and CuA, from the first comparison, then pulled the real data for a second comparison. Applying this in production revealed that pulling the source data in the second comparison can be skipped, so I've corrected the ETL steps from that post.
MariaDB/MySQL is case-sensitive on Linux, so any mismatch in capitalization between your table or column names and your SQL throws errors. That's why we usually turn case sensitivity off first.
In SQL, the LIKE operator searches for a specified pattern in a column inside a WHERE clause. It's a very common way to query in practice, and most people only use the % wildcard — but several other patterns are supported too.
