Today in my travels I came across Codd’s 12 rules. They are rules for what qualifies as a relational database. Apparently these rules are discussed in RELATIONAL MODEL DATABASE MANAGEMENT 2 but as that is $486 I will not have a copy any time soon…
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!
This came up back on August 9th 2020 in #lobsters on freenode. They were doing a system upgrade and providing a report by using `watch` to `cat` together a HTML header and footer with `mysql -e ‘select * from information_schema.processlist’` to provide a status report. Thought that was a neat hack.
To generate an SSL private key for use with MySQL/MariaDB and PDO:
openssl genrsa -out client-key.pem 4096