SQL & Database Wrap Up - December 2019

Hi! I'm Helen, one of your friendly mods looking after the #sql, #postgres and #database tags.

At the end of each month, I'll be showcasing some of the great posts, projects and insights from the data community.

To kick off the month Wendy explained how to use UNION and UNION ALL to stack the results of queries together for further analysis.

SQL: Union Operator

Wendy Calderon Dec 2 2 min read

#sql #postgres #programming

Next up Johannes kicked off a lively discussion on the advantages of using GraphQL on top of PostgreSQL.

GraphQL for PostgreSQL - Why?

Johannes Lichtenberger Dec 2 1 min read

#discuss #postgres #database #graphql

Jonathan then gave a tutorial on how to create a materialised view with SQL stored procedures using MySQL 5.6.

Creating a materialized view with SQL procedures

Jonathan Sundqvist Dec 4 3 min read

#sql #mysql

SeattleDataGuy has been busy writing this month, adding to the impressive collection of posts on all things Data. This article on Airflow caught my eye. it takes complete beginners through the terminology, tasks, schedules and how to create your first Dag.

How To Write Your First Airflow Pipeline

SeattleDataGuy Dec 5 6 min read

#python #database #devops #bash

Chidiebere continued writing about all things SQL with this post on CTEs and another on the Subquery. If you're curious on which one to use and why check them out.

Whats WITH CTE

Chidiebere Ogujeiofor Dec 13 9 min read

#postgres #database #sql

Next, Tariq showed us the advantages and disadvantages of different techniques to load data into the database. If you're curious about upserts, bulk uploads and making it scale this is a good place to start.

How to Load Data into an SQL database:From simple inserts to bulk loads

Tariq Abughofa Dec 15 3 min read

#sql #database #postgres #datascience

Jill wrote up a thoughtful post all about improving query performance by adding indexes. Creating indexes isn't just for DBAs so have a read and turn a standard database into a super-base just by adding an index data structure.

Database Indexing

Jill Poole Dec 15 4 min read

#javascript #firstyearincode #database #codenewbie

The database migration journey can be long and complicated if you don't have the right tools. Bruno shows us how it's done using the AWS Database Migration Services, snapshots and read replicas.

From Postgres RDS to Aurora

Bruno Ferreira Dec 17 8 min read

#aws #aurora #rds #postgres

Next up we have another #discuss post, this time "Are ORMs still relevant?" Check out the thoughtful comments for more and add your own.

ORM vs Query Builders vs Raw SQL

ImTheDeveloper Dec 17 2 min read

#discuss #orm #sql

Finally we hear from Zohar on database dates, which aren't really dates at all. check out the full post for more.

For the 1024 time DateTime has no format!

Zohar Peled Dec 19 2 min read

#csharp #sql #database #datetime

That wraps up the review for this month. If you'd like to see more check out the #sql and #database tags or follow The Database Dev on Twitter.