DEV Community

Cover image for SQL & database monthly wrap up - March 2021

SQL & database monthly wrap up - March 2021

helenanders26 profile image Helen Anderson ・2 min read

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 Ovid with a post on database naming standards. Well-chosen naming standards can make it easier to understand your code and make it possible to see an error in a single line of code. Check out this very popular post, and Ovid's other recent writing, for more great tips.

Next, we have Kirk with a ten-step database security checklist for small teams. This post outlines what modern database security in 2021 looks like, especially useful if you’re in the tech field and looking into creating or supporting your own database management system.

Suman then shares how to work with machine learning on Amazon Redshift. This series of posts explains how to get started with Amazon Redshift ML from the perspective of a database administrator, data analyst and an advanced machine learning expert.

Moving on to Jacob from the HarperDB team with a post on tackling data latency. Many organisations have come to accept latency as a given, but it doesn’t have to be. With the power of a geographically distributed database, we can empower innovators to create faster and smoother applications by reducing latency caused by long-distance routing.

This next post by awalias from the Supabase team focuses on the transactional side of PostgreSQL and offers some areas that you may want to go a little deeper on to impress your interviewer.

Next, we have Lisa and a post to help you understand the relevance of your search with Elasticsearch and Kibana. Master these concepts to create a great search experience for your users.

Our last post is from Igor and a tutorial where you'll learn how to build an analytical application on top of Google BigQuery, a serverless data warehouse, and use a few public datasets to visualise the impact of the COVID-19 pandemic on people's lives.

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)

Editor guide
igorlukanin profile image
Igor Lukanin

Wow, thanks! It’s my pleasure to be on this list.

Also, check this tutorial on ClickHouse, you’ll definitely gonna like it: