---
title: "#153: SQL Is 43 Years Old, 8 Reasons We Still Use It Today"
publication: "DB Weekly"
issue: 153
published_at: "2017-05-05"
canonical_url: "https://dbweekly.com/issues/153"
---

Database Weekly 153   . 

This week's database news -[Read this on the Web](http://dbweekly.com/issues/153) 

[Database Weekly](http://dbweekly.com) Issue 153 — May 5, 2017     

Featured [SQL Is 43 Years Old: 8 Reasons We Still Use It Today](http://blog.sqlizer.io/posts/sql-43/?utm_source=dbweekly&utm_medium=email) — SQL came in as the 2nd most common language in Stack Overflow’s recent survey - remarkable for a language approaching 50 years old. SQLizernews [How to Stream Data from Amazon DynamoDB to Amazon Aurora](https://aws.amazon.com/blogs/database/how-to-stream-data-from-amazon-dynamodb-to-amazon-aurora-using-aws-lambda-and-amazon-kinesis-firehose/?utm_source=dbweekly&utm_medium=email) — You might use DynamoDB for rapidly ingesting high-velocity data but then want to replicate it into Aurora for longer-term use. Here’s how to do that with AWS Lambda and Amazon Kinesis Firehose. Amazontutorial [Don't Use the String Concatenation 'Trick' in SQL Predicates](https://blog.jooq.org/2017/05/03/dont-use-the-string-concatenation-trick-in-sql-predicates/?utm_source=dbweekly&utm_medium=email) — When concatenating strings in SQL, take care that you’re including the right delimiters as well or unintended consequences could occur. JavaOOQtutorial [How to get started with MongoDB](https://resources.mongodb.com/getting-started-with-mongodb?jmp=cpress&utm_campaign=WW_CP_newsletter_sponsorship_FY17Q2&utm_content=primary&utm_medium=display&utm_source=dbweekly) — We put together a hub of our most popular resources to help jump-start your understanding of MongoDB. Check it out today. MONGODBsponsored [![\](https://copm.s3.amazonaws.com/6f3bb49a.png)](https://resources.mongodb.com/getting-started-with-mongodb?jmp=cpress&utm_campaign=WW_CP_newsletter_sponsorship_FY17Q2&utm_content=primary&utm_medium=display&utm_source=dbweekly) [The Simplifying Power of SQL Views in Data Reporting](https://reflect.io/blog/database-views/?utm_source=dbweekly&utm_medium=email) — A powerful way to build an in-database reporting layer is to create _views_, an abstraction that can greatly simplify queries and enhance the accessibility of data. Luc Perkinstutorial [Set Theory: The Method to Database Madness](https://medium.com/basecs/set-theory-the-method-to-database-madness-5ec4b4f05d79?utm_source=dbweekly&utm_medium=email) — If you’ve not formally studied math, you might find this primer on set theory (and how it relates to databases) useful. Vaidehi Joshitutorial [Six Things to Know About Securing Your Database](http://www.vertabelo.com/blog/technical-articles/six-things-you-need-to-know-about-securing-your-database?utm_source=dbweekly&utm_medium=email) — Whether you store secret government information or standard user data, you don’t want some unknown person to access to your database. Vertabelotutorial In brief [The Struggle for Hegemony in Oracle's Database Empire](https://db-engines.com/en/blog_post/69?utm_source=dbweekly&utm_medium=email) — Oracle and MySQL are fighting it out in DB Engines’ rankings. DB Enginesnews [Only a Fraction of 160 Zettabyte 'Datasphere' to Be Stored](https://www.datanami.com/2017/04/25/fraction-160-zettabyte-datasphere-stored/?utm_source=dbweekly&utm_medium=email) — The Internet of Things will contribute to 10x more data being produced in 2025, claims an IDC report. Datanaminews [Breaking the WiredTiger Logjam: The Write-Ahead Log](https://engineering.mongodb.com/post/breaking-the-wiredtiger-logjam-the-write-ahead-log-1-2?utm_source=dbweekly&utm_medium=email) — A series digging into the WAL of MongoDB’s newest storage engine. Sue LoVersotutorial [How to Maximize Availability Using Apache Cassandra](https://dzone.com/articles/how-to-maximize-availability-using-apache-cassandr?utm_source=dbweekly&utm_medium=email) Ben Slatertutorial [SQL Server's Pivot and Unpivot Features Explained](https://gavindraper.com/2017/05/04/sql-server-pivot-unpivot-explained/?utm_source=dbweekly&utm_medium=email) Gavin Drapertutorial [Sending Apache Logs to Amazon Elasticsearch Service with Kinesis Firehose](https://aws.amazon.com/blogs/database/send-apache-web-logs-to-amazon-elasticsearch-service-with-kinesis-firehose/?utm_source=dbweekly&utm_medium=email) Amazontutorial [Advanced Stored Procedures in MySQL](https://medium.com/@peter.lafferty/advanced-stored-procedures-in-mysql-9673d396a220?utm_source=dbweekly&utm_medium=email) Peter Laffertytutorial [Webinar: How to get mega performance for your metadata](https://www.brighttalk.com/webcast/15241/259387?utm_source=SelectStar+powered+by+Blue+Medora&utm_medium=brighttalk&utm_campaign=259387) — Learn how you can get better performance out of key content and metadata-oriented databases like Couchbase SelectStarsponsored [MySQL's Evolution From 5.6 to 8.0 in 42 Slides](https://drivy.engineering/mysql-evolution/?utm_source=dbweekly&utm_medium=email) — A quick tour of what’s changed along the way. Michael Bensoussan [That Giant Sucking Sound? Hadoop Moving Into The Cloud](http://redmonk.com/jgovernor/2017/05/04/that-giant-sucking-sound-hadoop-moving-into-the-cloud/?utm_source=dbweekly&utm_medium=email) — Companies like Google and Amazon are tripping over themselves to pick up people tired of running Hadoop locally. James Governorstory [Why To Favor Postgres Over MySQL or MariaDB](http://www.cybertec.at/why-favor-postgresql-over-mariadb-mysql/?utm_source=dbweekly&utm_medium=email) Hans-Juergen Schoenigopinion [The Big Old Reliable Elephant: Talking About Postgres with Craig Kerstiens](https://notamonadtutorial.com/the-big-old-reliable-elephant-talking-about-postgres-with-craig-kerstiens-a07ddec3e460?utm_source=dbweekly&utm_medium=email) — An interview covering the benefits of Postgres over other databases. Federico Carroneopinion [High Available and Scalable Open Source Database - SiriDB](http://siridb.net/) — SiriDB is robust, fast and has a unique query language that makes it easy to create charts for your application. Transceptor Technologytools sponsored [EVM: A Simple Elasticsearch Version Manager](https://github.com/duydo/evm?utm_source=dbweekly&utm_medium=email) — So simple that it’s really just a bash script. Duy Dotools [Tad: A Tabular Data Viewing App for macOS](http://tadviewer.com/?utm_source=dbweekly&utm_medium=email) — View CSV-style data in a data grid which can also be used as a pivot table. tadviewer.​comtools [Pilosa: A Distributed Bitmap Index, Powered by Go](https://github.com/pilosa/pilosa?utm_source=dbweekly&utm_medium=email) — An open source, distributed bitmap index system for accelerating queries across massive data sets. [Intro here.](https://www.pilosa.com/docs/introduction/) Pilosacode [LMDB: A Look Back At The First Version of Redis, Written in Tcl](https://gist.github.com/antirez/6ca04dd191bdb82aad9fb241013e88a8?utm_source=dbweekly&utm_medium=email) Salvatore Sanfilippocode    

Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/153) [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