Our regular collection of links that have caught the eye of Compose's Technical Content Curator over the week. This week, we have databases and development links including SQL tips, Pithos, PostgreSQL, Linux 4.4, LoDash 4.0, ChakraCore and Memoizeit. We finish with a security alert for anyone who uses OpenSSH.
Clearer SQL – Sometimes it's the little things that make for more readable code and SQL is no different. Craig Kerstiens gives some handy tips in Writing More Legible SQL, including a good reason for writing SQL keywords in UPPER CASE.
Pithos – An interesting use of Cassandra as an object storage system, Pithos uses the Amazon S3 protocols as its API which lets you plug in your S3 tools – they've even tested a number of clients.
PostgreSQL Futures – EnterpriseDB's Robert Haas has posted an article which looks at the features that people are looking at for future PostgreSQL (beyond 9.6) developments.
Linux 4.4 - The latest kernel arrived with tighter I/O, LightNVM support for Open-Channel SSDs, a lockless TCP listener and more.
Automated Memoization – Lambda the Ultimate drew our attention to a paper and a tool called Memoizeit which dynamically looks for opportunities to increase performance by memoizing results from function calls. This is the stuff that your profilers have been missing.
OpenSSH – There's a security alert out for OpenSSH - CVE-2016-0777 It's a big one as the flaw can let an OpenSSH client be tricked into dumping memory including private keys. If you can't upgrade immediately, as root do
echo -e 'Host *\nUseRoaming no' >> /etc/ssh/ssh_config
and this will close the hole. More information is available over on the OpenBSD Journal and on the Qualys advisory.