---
title: "It's the final newsletter of 2018"
publication: "DB Weekly"
issue: 234
published_at: "2018-12-21"
canonical_url: "https://dbweekly.com/issues/234"
---

This week's database news       

#234 — December 21, 2018 

[Read on the Web](https://dbweekly.com/issues/234)   

Database Weekly   

🎵 **It's beginning to look a lot like Christmas...** so we'll be taking a week off after this and will return on January 4 with a roundup of what happened in the database world in 2018. 

We hope you have a fantastic holiday season, whatever you celebrate, and both I and the entire Cooperpress team really appreciate you reading the newsletter over the year. 

_— Peter Cooper, editor_   

[![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/c7irjn57hyuadewsazyo.jpg)](https://medium.com/schkn/sql-is-dead-hail-to-flux-8e8498756049)  

[SQL is Dead, Hail to 'Flux'?](https://medium.com/schkn/sql-is-dead-hail-to-flux-8e8498756049) — An introduction to _Flux_, a data-querying language from InfluxData that this developer is hyping up as a key database trend for 2019. Possibly not, but it certainly contains some interesting ideas and gets me thinking about new ways to build query languages and cross-compile them to work on legacy systems.. 

Antoine Solnichkin   

[The Guardian: 'Bye Bye Mongo, Hello Postgres'](https://www.theguardian.com/info/2018/nov/30/bye-bye-mongo-hello-postgres) — In April, popular British newspaper _The Guardian_ switched off their MongoDB cluster and completed a migration to PostgreSQL on Amazon RDS. Here’s the full story. 

Philip McMahon   [![\](https://copm.s3.amazonaws.com/5bc53113.png)](https://www.enterprisedb.com/edb-postgres-cds) 

[On-Demand EDB Postgres Databases on the AWS Cloud in Minutes](https://www.enterprisedb.com/edb-postgres-cds) — Try the EDB Postgres Cloud Database Service free today. 

EnterpriseDB sponsor   

[How the SQLite Database Works](https://dzone.com/articles/how-sqlite-database-works) — This article looks at some architectural details of database implementation by using an early version of SQLite. 

Dhanushka Madushan   

[The Nine Most Common Database Design Errors](https://www.vertabelo.com/blog/technical-articles/the-9-most-common-database-design-errors) — Database design mistakes to avoid, to save you from some potential future headaches. 

Emil Drkušić    

A 2019 predictions interlude..  

[2019 Open Source Database Trends and Predictions](https://severalnines.com/blog/2019-open-source-database-trends-predictions) — 2018 saw a rise in PostgreSQL, a boom in containizeration and increased adoption of devops in the enterprise. What will 2019 hold? Some of Severalnines employees have their say. 

Forest Lymburner (Severalnines)   

[What's Up with 2019? Some Big Data Predictions](https://www.datanami.com/2018/12/18/whats-up-with-2019-big-data-predictions/) — As 2018 rolls to a close, Datanami turns its attention to 2019 and the possibility that it holds. 5G networks, the ongoing influence of GDPR, Hadoop and machine learning all feature. 

Alex Woodie (Datanami)     

[Data Deletion in a World with Endless Storage](https://www.datanami.com/2018/12/14/data-deletion-in-a-world-with-endless-storage/) — It’s become so easy and inexpensive to store more and more data but being able to effectively _delete_ it again is increasingly important. I suspect we'll see more focus on this topic in 2019 and 2020. 

Brian Vecci   

[The Best PostgreSQL Articles, Tools and News of 2018](https://postgresweekly.com/issues/286) — This week’s Postgres Weekly looked back at the Postgres world in 2018 and the most popular tools and tutorials we linked. 

Postgres Weekly   

[How to Design Highly Available Open Source Database Environments](https://severalnines.com/resources/whitepapers/how-design-highly-available-open-source-database-environments?utm_campaign=Momentum_Campaign_DEC_2018&utm_content=wp&utm_medium=Paid_Search&utm_source=banner) — Learn how to build an environment that stays up-and-running; even in the toughest of circumstances. 

Severalnines sponsor   

[Amazon DynamoDB Increases the Number of Global Secondary Indexes and Projected Index Attributes You Can Create Per Table](https://aws.amazon.com/about-aws/whats-new/2018/12/amazon-dynamodb-increases-the-number-of-global-secondary-indexes-and-projected-index-attributes-you-can-create-per-table/) — And if you need more than 20 global secondary indexes, you can request an increase. 

Amazon Web Services, Inc.   

[Analyzing IMDb Data The Intended Way, with R and ggplot2](https://minimaxir.com/2018/07/imdb-data-analysis/) — For IMDb’s big-but-not-big data, you have to play with the data smartly, and both R and ggplot2 have neat tricks to do just that. This comes from earlier in the year but I really enjoyed it. 

Max Woolf   

▶[Streaming Analytics: How to Get Fast Predictions From Real-Time Data](https://www.youtube.com/watch?v=A2nQzSfZ3fE#t=0m33s) — ..with Flink, Kafka, and Cassandra. 

Bas Geerdink   

[SQL Clause Is Coming to Town](https://dev.to/designpuddle/sql-clause-is-coming-to-town-25ml) — _He’s making a table, he’s sorting it twice.._ 

Chris Bertrand  

💻 Jobs  

[UK Data Engineering Roles? Try hackajob](https://hackajob.co/p/discover?utm_source=cooperpress&utm_medium=paid&utm_campaign=db_nov_w4&utm_term=data) — See how much you could earn by putting your skills to the test, average salary £65k. 

hackajob  

🐦 And seen on Twitter.. 

[![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/ygo6iejgngy5uiyor0ee.jpg)](https://twitter.com/jongalloway/status/1075889210714816512)        

A **[Cooperpress](https://cooperpress.com/)** publication. 

[Change your email address](https://dbweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://dbweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom