What the best database solution for web and smartphones dev?
Is mysql the good choice?
I’m an “old” dev with old usage, php-mysql-JavaScript.
Is it a 2018 solution or am i a dinosaur?
All data will be stored on server side. Web and smartphone app as client.
Thanks for your experience sharing.

📌

If you know mysql its a good choice.
At least until you find you struggle to get it to do what you need, thats when you start looking at alternative.

As a sql db mysql is a pretty good fit form mostly anything until you need to scale up a lot and even then only some parts will fit well with another solution so when that happens you probably will not switch all to another db but just some parts.

First add so me caching db like memcache or redis

Next you might need a graph db or object db.

But I would avoid those until you really have a concrete problem, its very easy to jump on a new cool db just to be burned when you realize its very bad at some common tasks while shining in one specific.

I would start with a relational database for the reasons @voxera has already mentioned, but I would suggest checking out psql instead of mysql. It's still free and it's very similar but there are some extra goodies: https://blog.panoply.io/postgresql-...

Also for smartphone dev, if it's possible to make your app usable offline, I would recommend doing that and maybe looking into sqlite. It's a good solution for a database that lives on the client's machine. I generally prefer to use apps that store my data locally especially since data plans where I live kind of suck and I live in an area without fantastic cell service.

If you need to store much data, MySQL is good. It's stupidly fast.

Web only - MySQL
Smartphone only - SQLite
Both - PHP API using MySQL, mobile apps would make API calls and your web apps could either use API calls or interact with the database directly.