Hacker News new | ask | show | jobs
by psoots 1962 days ago
I'm very skeptical of this. It doesn't seem like something that could scale. By accessing database files through PHP, you are begging for race conditions while serving multiple requests simultaneously. At best, you will hit write-errors while other requests are working with the file. SQLite has a good explanation of the problem here: https://sqlite.org/faq.html#q5
1 comments

You are correct, it is suitable for small-medium traffic websites with less write operations and more read operations. We have a simple file locking mechanism to handle this situation. The caching part makes it a static storage by combining multiple files per query.
Seems great for blogs and marketing sites, especially if you've got a CDN in front.