News for hackers. Stuff that matters.
Re:SQLite Release 3.25.0 adds support for window functions by newusertoday on Wednesday August 15, 2018 @07:02AM (#17765135)
I am interested in this topic as well, although sqlite explicitly says that it is not meant for client-server configuration. I still want to see if it is feasible and someone is using it in production.
Re:SQLite Release 3.25.0 adds support for window functions by zip1234 on Wednesday August 15, 2018 @10:51AM (#17766440)
What they mean by that comment is that it doesn't have users in the sense that mysql, SQL Server, etc have. https://www.sqlite.org/whentouse.html The documentations says that it works well for websites. For client server, you just need to make an API that handles the interactions with the database.
Re:SQLite Release 3.25.0 adds support for window functions by move-on-by on Wednesday August 15, 2018 @09:23AM (#17765814)
I got thrown into a legacy web project that used sqlite as the database. It was a small internal-only app, I guess the original developer(s) figured it was so small that sqlite would be plenty and it would reduce the environment complexity.

Unsurprisingly they were wrong. It was small, but sqlite couldn't handle multiple users. I believe this was before sqlite had WAL support, so reading would lock the DB. The 'solution' was to split the sqlite database into many smaller DBs that would allow users to use the site at the same time as long as they were in different areas. This greatly added to the complexity of the application. Some reports would need to access multiple databases to get what it needed, so it would still lock out people. Complexity was much higher then having all the data in a single postgresql/mysql database. All the users hated the system and often ran into DB lock issues.

> sqlite explicitly says that it is not meant for client-server configuration

They are right and their advice should be heeded.

Re:SQLite Release 3.25.0 adds support for window functions by zip1234 on Wednesday August 15, 2018 @10:39AM (#17766316)
Since 2010, SQLite has had Write-Ahead-Logging. Perhaps your project was using an older version of SQLite? https://www.sqlite.org/wal.html
Re:SQLite Release 3.25.0 adds support for window functions by misframer on Wednesday August 15, 2018 @10:14AM (#17766135)
Expensify uses SQLite for their core database.

https://blog.expensify.com/2018/01/08/scaling-sqlite-to-4m-q...

Re:SQLite Release 3.25.0 adds support for window functions by yread on Wednesday August 15, 2018 @11:16AM (#17766658)
Interesting discussion of bedrock

https://news.ycombinator.com/item?id=12739771

Re:SQLite Release 3.25.0 adds support for window functions by siscia on Wednesday August 15, 2018 @12:04PM (#17767095)
Most applications don't need the level of concurrency that Pg or MySQL provide and they will be just fine with something simple to operate, which is why I wrote https://redisql.com/