DEV Community

loading...
Cover image for SQL & database monthly wrap up - February 2021

SQL & database monthly wrap up - February 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.


First up, Forbes has some great advice for your next node project. Check out the resources on which database is right for you.



Next, Igor builds a stock market data visualisation with candlestick charts, and take a look at ClickHouse. This is a long one, but a good one. Check it out for the step-by-step tutorial.



Jacob from the HarperDB team takes us through how to pick a BI tool. Check out this guide for what you should look for when you want to turn data into insights.



For something completely different we have the first edition of 'Five classic SQL and database posts'. If you're looking for some great reads on all things data check out this edition and look out for the next one in the middle of March.



In this post Kevin shares the techniques they are using at AppLand to make JSON data act "relational". With JSONB data in PostgreSQL, you can get the best of the structured and unstructured world.



Next up, Ademílson continues their series on Vue + Supabase. In this post, we learn how to show a new publication whenever it is inserted into the database.



To finish up the wrap up Frastyawan shares how to use Google Sheets in your next project. Give it a read, then give it a try.




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)

pic
Editor guide
Collapse
hanpari profile image
Pavel Morava

If I may be so bold and recommend an excellent source about databases, I would love to share Greg Kemnitz's Database Space.