HTSQL: A Navigational Query Language for Relational DBs — Designed for data analysts and ‘accidental programmers’ who have complex business inquiries to solve and need a productive tool to write and share database queries. Open source.
Auto-generated REST APIs from any database — Version 2.3 of DreamFactory’s powerful open source API automation platform brings major enhancements to speed, caching, and versatility. Free demo.
QuineDB: A Quine That Is Also A Key-Value Store — A quine is a program that, when run, outputs its own source code. Stores data in a shell variable. Solely for fun and an interesting experiment.
Gary Fredericks code
Jobs
Find Your Perfect Company Match — You're smart, you're efficient. Why job hunt the old way? Try Hired and get your profile in front of thousands of top tech companies.
Calculating Proportional Values in SQL — Aggregations are common and generally straightforward in SQL, but some more complex operations like medians require a bit more work as demonstrated here.
Periscope tutorial
MySQL 8.0's Invisible Indexes — Invisible indexes are a new feature in MySQL 8.0 to hide an index from MySQL’s optimizer.
