Top 6 Databases trending recently (as per stackoverflow developer report) and what each of them are used for?
MySQL , PostgreSQL are the top 2 open source SQL databases used by most tech companies and great for interview preparation. They are mainly relational databases. To compare the syntax you can refer to (https://tipseason.com/postgres-vs-mysql-syntax-comparision/)
SQLite: Is a light weight database that is embedded into most mobile applications. If you are an Android/IOS developer definitely take a look at it.
MongoDB: Is widely using NoSQL database. Its a cross-platform document-oriented database program.
Microsoft SQL Server: Its a microsoft version of SQL implementation for relational databases. Great for Azure or .Net applications.
Redis: This is a must learn open source, in-memory data store used by millions of developers as a database, cache, streaming engine, and message broker. Great for caching .
PS: For top interview questions: https://tipseason.com/coding-interviews.html
What DB do you use for devleopment ?
Follow me on twitter for daily updates:
TipSeason@thetipseason
If you are looking for previous article on detailed comparison, you can get it from here: tipseason.com/postgres-vs-my…06:36 AM - 27 Jun 2022
Top comments (4)
MongoDB primarily for new development, although some of my maintenance work relies on MySql because of Wordpress. However, I do not do much directly with it, nor do I have any intention of doing so in the future.
I do some work with Sqlite3, but mostly reads of existing data files. I suspect I'll do a bit more with it since it just seems to work so well for local storage not just with mobile devices.
Redis is one I suppose I should get smarter with, but most of my front end work is in React, and for that I'm using Redux.
Interesting to know about Redux. Do you use it for front end data cache,?
I suppose one could characterize it that way.
For me it is a companion lib for ReactJS to manage state. So, any data that is loaded from an API or perhaps the user will likely get stored in my Redux store.
However, I do admit that I may be “overusing” it, especially with larger objects. And wondering if there are better approaches. Still on the steep part of the learning curve when it comes to making bigger apps.
Amazing usecase. I was looking for similar libraries recently for my project at TipSeason.com . Will definitely give it a try. Thank you so much for your detailed response 🙌