I'm building a REST API using NodeJS storing a scraped data that comes from many websites ( the API I'm building is about selling - buying used cars )
There's a potential to scale in the future for more products, not just cars!
I searched a lot for a recommendation for what DB should I use SQL or NoSQL ( MySql or MongoDB )
What I get from searching:
- That MySql slow on writes data ( scraping is about writes ) ( Mongo feature )
- but the data it has relationships like car => brand => model => user ...etc ( MySQL Feature )
Another confusing is the data will not have a schema as can change from site to another ( Mongo Feature )
I'm really frustrated right now? which Database I should use in my situation?