DEV Community

Cover image for SQL & database wrap up - July 2020

SQL & database wrap up - July 2020

helenanders26 profile image Helen Anderson Updated on ・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.

Our first post is from Margo and the team at HarperDB. Check it out for an overview of database architectures, use cases, and pros and cons of the database options available. To keep the conversation going there's now a follow up deep-dive on NewSQL databases from the team.

Carrying on the theme of database comparisons, OM talks us through NoSQL v SQL in a quickfire round. Check it out for a refresher on the qualities of each database type.

Sreeram then introduces us to Deta Base, the production-grade NoSQL database provided by Deta. This post describes how they used it for a side project and how setting up the database was the easiest part of the project.

Ali then gives us a quick start guide for RethinkDB - an open-source solution for a realtime database.

In the next post Aman shows us how to build a simple REST API using Express, Node.js, and HarperDB Cloud to store the data.

The Educative team has shared Christina Kopecky's post comparing MongoDB and PostgreSQL. There isn’t one that’s particularly better than the other. What is most important is how your data is going to be used, what structure will it have, and how will your application scale. Once the answers to these questions become evident, the choice will become clearer.

To finish up the wrap up Osinachi has written about the tools used in database design. Before starting a project using a database, you must design your database to prevent confusion and bad app design down the project's roadmap.

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 (0)

Editor guide