DB Weekly
Archives| Latest| RSS
« Prev
Next »
Database Weekly
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   
5 Mistakes Beginners Make When Working with Databases
Craig Kerstiens
Designing Schemaless, Uber Engineering’s Scalable Datastore — Uber developed its own MySQL-based schemaless storage system.
Uber Engineering
Why Most Programmers Get Pagination Wrong
JavaOOQ
How Uber Manages 1M Writes/Second Using Mesos and Cassandra
High Scalability
Data Denormalization Is Broken
Liron Shapira
Ask HN: How to Handle 50GB of Transaction Data Each Day?
Hacker News
Building a Real-Time Recommendation Engine
Nicole White
Denormalization: When, Why, and How
Emil Drkušić
OmniDB: An Open Source Web Tool for DB Management
OmniDB    tools   
Sqlectron: A Simple SQL Desktop Client for Multiple Databases
Sqlectron    tools   
Five Online Database Modelling Services
Robert Sheldon    tools   
« Prev
Next »