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 ha…

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.

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.

João 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.

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.

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.

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.

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


Print Share Comment Cite Upload Translate
APA
Helen Anderson | Sciencx (2024-03-29T07:42:37+00:00) » SQL & database monthly wrap up – April 2021. Retrieved from https://www.scien.cx/2021/04/27/sql-database-monthly-wrap-up-april-2021/.
MLA
" » SQL & database monthly wrap up – April 2021." Helen Anderson | Sciencx - Tuesday April 27, 2021, https://www.scien.cx/2021/04/27/sql-database-monthly-wrap-up-april-2021/
HARVARD
Helen Anderson | Sciencx Tuesday April 27, 2021 » SQL & database monthly wrap up – April 2021., viewed 2024-03-29T07:42:37+00:00,<https://www.scien.cx/2021/04/27/sql-database-monthly-wrap-up-april-2021/>
VANCOUVER
Helen Anderson | Sciencx - » SQL & database monthly wrap up – April 2021. [Internet]. [Accessed 2024-03-29T07:42:37+00:00]. Available from: https://www.scien.cx/2021/04/27/sql-database-monthly-wrap-up-april-2021/
CHICAGO
" » SQL & database monthly wrap up – April 2021." Helen Anderson | Sciencx - Accessed 2024-03-29T07:42:37+00:00. https://www.scien.cx/2021/04/27/sql-database-monthly-wrap-up-april-2021/
IEEE
" » SQL & database monthly wrap up – April 2021." Helen Anderson | Sciencx [Online]. Available: https://www.scien.cx/2021/04/27/sql-database-monthly-wrap-up-april-2021/. [Accessed: 2024-03-29T07:42:37+00:00]
rf:citation
» SQL & database monthly wrap up – April 2021 | Helen Anderson | Sciencx | https://www.scien.cx/2021/04/27/sql-database-monthly-wrap-up-april-2021/ | 2024-03-29T07:42:37+00:00
https://github.com/addpipe/simple-recorderjs-demo