Ask HN: What's your favorite way of getting a web app up quickly in 2018?

Re:Ask HN: What's your favorite way of getting a web app up ... by JepZ on Sunday June 03, 2018 @04:25AM (#17218533)

Please correct me if I am wrong, but as far as I remember the combination of PHP and sqlite fails fairly quickly when if comes to concurrent users?

Don't get me wrong, I am very fond of sqlite, but to use it efficiently you have to manage the connections to the database and from what I have heard, that doesn't work particularly well with PHP.

This doesn't mean that the above recommendation is wrong (in fact, I used similar approaches in the past), I just thought that it should be mentioned and if someone wants to build something that has a lot of concurrent users by design, he knows which part will be the first bottle neck.

[ Parent | on HN ]

Re:Ask HN: What's your favorite way of getting a web app up ... by edthrowaway on Sunday June 03, 2018 @10:11AM (#17219588)

Sqlite's limitations have nothing to do with PHP. But you're correct that it's not intended for use as a multi user database. The limitation is in concurrent writes. If your app is read-oriented, then there is not a problem.

However, I'd personally always use postgres in this case, myself.

[ Parent | on HN ]