SQL & database monthly wrap up - May 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 Josh with a performance optimisation story and the journey to understand the cause of a performance hit. There is a lot to be learned by being willing to dig into a problem, even if you can only understand it a little bit at a time.

Beware The Missing Foreign Key Index: A Postgres Performance Gotcha

Josh Branchaud May 27 12 min read

#sql #postgres #database #performance

SeattleDataguy returns to the wrapup with 'Software Engineer Vs Data Engineer - Which Position Is Right For You?' The duties of data engineers and software engineers overlap, especially in smaller companies. But there are tangible differences between the two. Check out the post for more.

Software Engineer Vs Data Engineer - Which Position Is Right For You?

SeattleDataGuy May 1 6 min read

#career #database #beginners #discuss

Moving on to Willian and an introduction to the different types of data models we can use beyond relational and the document based.

A salada de frutas dos modelos de dados

Willian Frantz May 11 7 min read

#database #elixir

This next post by Evan explores the historical reasons for the 191 character limit as a default in most relational databases.

Why do database columns have a character length of 191?

Evan Tahler May 17 5 min read

#database #history #i18n #mysql

Next, we have InHuOfficial with analysis into the top contributors on Stack Overflow and the query that allows you to grab all of the questions, answers and comments on a given tag, ranked by number of answers given.

A couple of interesting Stack Overflow queries to play with [Query Stack Overflow]

InHuOfficial May 19 7 min read

#sql #api #webdev #showdev

Our last post is the MongoDB team with their MongoDB $weeklyUpdates.

Here Adrienne has curated tutorials, upcoming official MongoDB events, Twitch streams, and podcasts.

$weeklyUpdate #22 (May 10, 2021): Latest MongoDB Tutorials, Events, Podcasts, & Streams!

Adrienne Tacke May 10 5 min read

#mongodb #database #news #programming

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.