SQL & database monthly wrap up - April 2021

Hi! I'm Helen, one of your friendly mods looking after the #sql, #postgres, #mysql, 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 get us started we have SeattleDataGuy with a post and a tool to assist you as a new data engineer. This pyramid can be thought of as a hierarchy of skill set needs to build a solid foundation as you move onto more specific skills.

What Skills Do Data Engineers Need - The Data Engineering Skill Pyramid

SeattleDataGuy Apr 16 6 min read

#career #database #datascience #analytics

Next, we have Nehal with a project showing how to model many-to-many relationships where categories can have multiple products, and products can be in multiple categories. Check it out to see if it could be useful for a future project.

Many-to-Many relationship in MongoDB . Nodejs | Express | Mongoose

Nehal Ahmad Apr 3 4 min read

#mongodb #node #database #webdev

Joo Henrique then shares part three in the "Writing a SQLite clone from scratch in Rust" series. In this post, you'll define the limitations of some data structures, break down the problem into smaller pieces, and learn how to deal with tables and indexes.

What would SQLite look like if written in Rust? Part 3

Joo Henrique Machado Silva Apr 7 12 min read

#database #rust #computerscience #programming

Moving on to Inee and a post with some learnings on LIKE. Check it out for tips on how to get started with wildcards and some great examples.

Like, so confused...

Inee Ader Apr 5 2 min read

#sql #operator #like #sqlite

Next, we have Cassidy and the story of performance challenges, the EXPLAIN plan, slow indexes, and some experimentation. Give it a read for a great data story.

One WEIRD Trick for Speeding Up ORDER BY That You Probably Shouldn't Use

Cassidy K (she/her) Apr 9 3 min read

#postgres #sql #performance

Our last post is from Joe and the OneSignal team. This post is packed full of lessons learned from five years of scaling PostgreSQL. In this article, you'll read about the challenges the team has dealt with and the solutions they've put in place by figuring it out the hard way. Read the whole post from the top, or jump in at any point to learn something new.

Lessons Learned From 5 Years of Scaling PostgreSQL

Joe Wilm Apr 19 18 min read

#engineering #architecture #database #postgres

That's all for this month! For more from the data community check out the #sql, #postgres, #mysql, and #database tags, and follow @TheDatabaseDev on Twitter.