Some interesting thoughts on How to Efficiently Choose the Right Database for Your Applications.
I read The Next Gen Database Servers Powering Let’s Encrypt which mentioned how they tuned ZFS.
Today on 8.3.6 Multiple-Column Indexes I learned about the hash index technique:
SELECT * FROM tbl_name WHERE hash_col=MD5(CONCAT(val1,val2)) AND col1=val1 AND col2=val2;
As they say: “As an alternative to a composite index, you can introduce a column that is “hashed” based on information from other columns. If this column is short, reasonably unique, and indexed, it might be faster than a “wide” index on many columns. In MySQL, it is very easy to use this extra column.”
Read this great article Stop checking for NULL pointers! It mentions that there are many other invalid pointers than NULL, which is the same idea I had recently with regard to foreign keys in databases.
This old chestnut What ORMs have taught me: just learn SQL popped up on HN today.
Today I read The Surprising Impact of Medium-Size Texts on PostgreSQL Performance which popped up on reddit.
Stumbled upon the Null (SQL) Wikipedia article. Looks interesting. Will read.
Today I discovered sequences in MariaDB. Gonna take them for a spin!