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 Kevin from the AppLand team with a RailsConf presentation and demo on how to auto-document database schemas with a gem called rails-erd.
How to auto-document the database schema of your Rails app
Kevin Gilpin for AppLand ・ Jun 8 ・ 2 min read
#database
#techtalks
Next, we have LordGhostX with a post showing how by integrating HarperDB with Python and Flask, we can build a contact manager with CRUD functionalities.
Building a Contact Manager with Python, Flask, and HarperDB
LordGhostX ・ Jun 2 ・ 9 min read
#tutorial
#database
#beginners
Mohmed then shares some of the most important tips you need when you’re building relational databases like MySQL, and PostgreSQL.
Build Relational Databases Like A Pro (MySQL, PostgreSQL, etc.)
Mohmed Ishak ・ Jun 16 ・ 3 min read
#sql
#mysql
Moving on to Curious Paul and their post on how to build a telegram bot using a database on Fauna’s serverless system to host user data.
Building An E-commerce Telegram Bot Using Python and Fauna.
Curious Paul ・ Jun 13 ・ 17 min read
#faunadb
#database
#tutorial
This next post by Sandor demonstrates how to build a fully functional Q&A board for asking and upvoting the most interesting questions with Redis.
Next, we have SeattleDataGuy who returns to the wrap up with a list of data sources that can be utilised for data engineering and a few ways other developers have implemented these datasets for you to draw inspiration from.
5 Data Sources for Your Next Data Engineering Projects
SeattleDataGuy ・ Jun 5 ・ 6 min read
#datascience
#beginners
#sql
Our last post is from AWS Community Builder Joël and a deep dive into data lakes, lakehouses, and data mesh.
Each data architecture model has benefits and shortcomings, there is no good and bad approach. This post evaluates how these data architecture patterns can be applied using great examples.
Architecture options for building a basic Data Lake on AWS – Part 1
Joël FARVAULT for AWS Community Builders ・ Jun 2 ・ 5 min read
#database
#architecture
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.