This content originally appeared on DEV Community and was authored by Helen Anderson
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
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
Moving on to Willian and an introduction to the different types of data models we can use beyond relational and the document based.
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
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
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
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.
This content originally appeared on DEV Community and was authored by Helen Anderson

Helen Anderson | Sciencx (2021-05-29T08:04:15+00:00) SQL & database monthly wrap up – May 2021. Retrieved from https://www.scien.cx/2021/05/29/sql-database-monthly-wrap-up-may-2021/
Please log in to upload a file.
There are no updates yet.
Click the Upload button above to add an update.