--- title: "The best of DB Weekly in 2016" publication: "DB Weekly" issue: 135 published_at: "2016-12-22" canonical_url: "https://dbweekly.com/issues/135" --- Database Weekly 135 . This year's top database news -[Read this on the Web](http://dbweekly.com/issues/135) [Database Weekly](http://dbweekly.com) 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](https://blog.jooq.org/2016/04/25/10-sql-tricks-that-you-didnt-think-were-possible/?utm_source=dbweekly&utm_medium=email) — 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](https://eng.uber.com/mysql-migration/?utm_source=dbweekly&utm_medium=email) — 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](https://blog.dataloop.io/top10-open-source-time-series-databases?utm_source=dbweekly&utm_medium=email) — 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.](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-primary) — 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. linodesponsored — [![\](https://copm.s3.amazonaws.com/c740311a.png)](https://welcome.linode.com/db-weekly/?utm_source=cooperpress&utm_medium=email&utm_term=db&utm_campaign=db-weekly-primary) [NoSQL Databases: A Survey and Decision Guidance](https://medium.com/baqend-blog/nosql-databases-a-survey-and-decision-guidance-ea7823a822d?utm_source=dbweekly&utm_medium=email) — An incredibly thorough overview of the NoSQL landscape. Felix Gessert [SQL Injection Cheat Sheet](https://www.netsparker.com/blog/web-security/sql-injection-cheat-sheet/?utm_source=dbweekly&utm_medium=email) — 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](http://blog.jooq.org/2016/03/17/10-easy-steps-to-a-complete-understanding-of-sql/?utm_source=dbweekly&utm_medium=email) — 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](http://www.vertabelo.com/blog/technical-articles/all-about-indexes-the-very-basics?utm_source=dbweekly&utm_medium=email) — 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](http://charlesleifer.com/blog/five-reasons-you-should-use-sqlite-in-2016/?utm_source=dbweekly&utm_medium=email) — 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](http://code.tutsplus.com/tutorials/7-handy-sql-scripts-for-sql-developers--cms-25834?utm_source=dbweekly&utm_medium=email) — “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](http://www.vertabelo.com/blog/notes-from-the-lab/19-online-resources-for-learning-about-database-design-errors?utm_source=dbweekly&utm_medium=email) — 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](http://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q4-16-dbweekly) — 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](https://compose.com/articles/seven-databases-in-seven-days-a-cloud-data-services-journey/?utm_source=cooper&utm_medium=newsletter&utm_content=db) — Our colleagues at IBM CDS have been blogging about the databases available on IBM Bluemix. Here’s the summary. Composesponsored [5 Mistakes Beginners Make When Working with Databases](http://www.craigkerstiens.com/2016/06/07/five-mistakes-databases/?utm_source=dbweekly&utm_medium=email) Craig Kerstiens [Designing Schemaless, Uber Engineering’s Scalable Datastore](https://eng.uber.com/schemaless-part-one/?utm_source=dbweekly&utm_medium=email) — Uber developed its own MySQL-based schemaless storage system. Uber Engineering [Why Most Programmers Get Pagination Wrong](https://blog.jooq.org/2016/08/10/why-most-programmers-get-pagination-wrong/?utm_source=dbweekly&utm_medium=email) JavaOOQ [How Uber Manages 1M Writes/Second Using Mesos and Cassandra](http://highscalability.com/blog/2016/9/28/how-uber-manages-a-million-writes-per-second-using-mesos-and.html?utm_source=dbweekly&utm_medium=email) High Scalability [Data Denormalization Is Broken](https://hackernoon.com/data-denormalization-is-broken-7b697352f405?utm_source=dbweekly&utm_medium=email) Liron Shapira [Ask HN: How to Handle 50GB of Transaction Data Each Day?](https://news.ycombinator.com/item?id=11157829&utm_source=dbweekly&utm_medium=email) Hacker News [Building a Real-Time Recommendation Engine](https://neo4j.com/blog/real-time-recommendation-engine-data-science/?utm_source=dbweekly&utm_medium=email) Nicole White [Denormalization: When, Why, and How](http://www.vertabelo.com/blog/technical-articles/denormalization-when-why-and-how?utm_source=dbweekly&utm_medium=email) Emil Drkušić [OmniDB: An Open Source Web Tool for DB Management](http://omnidb.com.br/en_index.html?utm_source=dbweekly&utm_medium=email) OmniDBtools [Sqlectron: A Simple SQL Desktop Client for Multiple Databases](https://sqlectron.github.io/?utm_source=dbweekly&utm_medium=email) Sqlectrontools [Five Online Database Modelling Services](https://www.simple-talk.com/sql/database-administration/-five-online-database-modelling-services/?utm_source=dbweekly&utm_medium=email) Robert Sheldontools Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/135) [See our archives](http://dbweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*) [Stop getting this newsletter](*|UNSUB|*) Published by [Cooperpress](https://cooperpress.com/) Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK