DEV Community

Cover image for Five classic SQL & database posts - June 2021

Five classic SQL & database posts - June 2021

Helen Anderson
Data wrangler at Kiwibank, AWS Data Hero, and tag moderator on
・2 min read

Hi! I'm Helen, one of #SQL and #database tag moderators.

Each month I'll be taking a trip down memory lane and showcasing some classic data posts. Some of these might be your 'go-to' resources already, others may offer some new insight or ideas.

Let's jump into the posts!

First up Adi writes about the building blocks that open a whole new world of workload management, various types of files, log systems, and architectures specifically designed to handle scale.

This classic post from jen dives into PostgreSQL and what you can do with the SELECT clause. Check out the post and the comments for more.

Next up is a post from Wendy and a post tackling outer joins with useful examples and images to make them easier to understand.

This classic post from Matt discusses what deadlocks are, how to interpret deadlock graphs, and some options for handling deadlocks.

Our last post is from Jill and covers the differences between relational and non-relational databases. Check out the post for more on how to plan your next data project.

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.

Alt Text

Discussion (1)

adipolak profile image
Adi Polak

Wow! thank you so much @helenanders26 ! Such a fantastic like minded SQL experts :)