This talk popped up in my news feed today: Ideology. It’s a discussion of static vs dynamic languages and what they can and can’t do with regard to modelling and testing correct systems.
Monthly Archives: March 2021
Database Programming – An Intermediate MySQL Tutorial – Scripting, Data Types, Examples
I found this great collection of notes: Database Programming – An Intermediate MySQL Tutorial – Scripting, Data Types, Examples.
Prepared statement needs to be re-prepared
I have seen this error before, Prepared statement needs to be re-prepared, I’m not sure if I will see it again, but just in case I’m keeping this link…
MySQL admin with Ian Gilfillan
I was doing some reading today and I came upon an old series of articles over on www.databasejournal.com by a dude called Ian Gilfillan:
- MySQL backups
- Database Replication in MySQL
- Restoring lost data from the Binary Update Log
- Optimizing MySQL: Queries and Indexes
- Optimizing MySQL: Hardware and the Mysqld Variables
- MySQL’s Query Cache
- MySQL’s Over-looked and Under-worked Slow Query Log
For the ‘type’ in SQL ‘EXPLAIN’ Ian says: from best to worst the types are: system, const, eq_ref, ref, range, index, all.
It seems this Ian Gilfillan fellow has been rather prolific.
Reading time as lines-of-code per hour
I was wondering how many lines of code it was possible to read per hour. I found on the Wikipedia code review article the claim: “Code review rates should be between 200 and 400 lines of code per hour.” They say any faster is too fast to find errors. I also found on the Wikipedia article source lines of code that a contemporary Linux kernel has 20 million lines-of-code. So if you didn’t sleep and read code 24×7 you could read the Linux kernel in a little over 5 years…
Why every single element of SOLID is wrong
Don’t End The Week With Nothing
This on HN today: Don’t End The Week With Nothing. It referenced Developer Evangelism: The Whole Story and Jason Cohen – Designing the perfect bootstrapped startup MicroConf 2013 (audio and transcript here). Jason Cohen’s formula is:
Predictable acquisition of recurring revenue with an annual pre-pay option with a product which solves a demonstrable, enduring pain point for a business.
Sony Releases Stupid Piece Of Shit That Doesn’t Fucking Work
Charts.css
Kickass: Charts.css. Also of interest: Which color scale to use when visualizing data.
Disable KDE Wallet popup from Chromium
So today I found how to disable kwallet popups from chrome. That’s been annoying me for a while now…