Issue 135 — December 22, 2016
Featured
In this final issue of 2016, we're looking back at the most popular items featured throughout the year. We'll be back in the first week of 2017 - thanks for your support and we hope you have a happy holiday season! :-)
10 SQL Tricks That You Didn’t Think Were Possible — A fun, and very extensive, walkthrough of the possibilities and properties of SQL you may have overlooked.
Lukas Eder
Why Uber Engineering Switched from Postgres to MySQL — Uber Engineering explains the technical reasoning behind its switch in database technologies from Postgres to MySQL - an uncommon direction to migrate in.
Evan Klitzke
A Comparison of 10 Open Source Time Series Databases — The author looks at and ranks DalmatinerDB, InfluxDB, Prometheus, Riak TS, OpenTSDB, KairosDB, Elasticsearch, Druid, Blueflood and Graphite.
Steven Acreman
Linode is the SPEEDIEST SSD host for your DB - simple, reliable & powerful. — MySQL? MariaDB? PostgreSQL? Whatever DB you use, run it on a Linode, the most scalable, reliable and fastest servers in the cloud. Use promo code DB20 for a 20ドル credit and get started.
linode sponsored
NoSQL Databases: A Survey and Decision Guidance — An incredibly thorough overview of the NoSQL landscape.
Felix Gessert
SQL Injection Cheat Sheet — A detailed resource to find technical information about the many different variants of SQL injection vulnerabilities. A good reference for both seasoned penetration testers and those just getting started in web app security.
Ferruh Mavituna
10 Easy Steps to a Complete Understanding of SQL — A walk through some of the fundamentals of SQL and the key concepts it introduces by being a declarative language rather than imperative or object oriented.
Jooq
All About Indexes: The Very Basics — Well defined indexes will improve your database’s performance significantly, but how do they work?
Emil Drkušić
5 Reasons You Should Use SQLite in 2016 — SQLite, a self-contained, zero-config SQL database engine, is frequently underestimated. But it’s fast, convenient, and there are compelling reasons to use it in certain contexts.
Charles Leifer
7 Handy SQL Scripts for SQL Developers — "a few SQL scripts which have proven to be very useful for my daily job as a SQL developer.."
Sovit Poudel
19 Resources for Learning About Database Design Errors — A look at numerous online resources for avoiding poor database design that can lead to many problems and cost both time and money.
Jeffrey Edison
Jobs
One Application, 4,000+ Opportunities - Try Hired — You're smart, you're efficient. Why job hunt the old way? Try Hired and get your profile in front of thousands of innovative companies.
Hired
In brief
Seven databases in seven days - a Cloud Data Services journey — Our colleagues at IBM CDS have been blogging about the databases available on IBM Bluemix. Here’s the summary.
Compose sponsored
Craig Kerstiens
Designing Schemaless, Uber Engineering’s Scalable Datastore — Uber developed its own MySQL-based schemaless storage system.
Uber Engineering
High Scalability
Liron Shapira
Nicole White
Emil Drkušić
OmniDB tools
Sqlectron tools
Robert Sheldon tools