News for hackers. Stuff that matters.
Re:Cold Showers: For when people get too hyped up about things by barrkel on Friday July 24, 2020 @02:01PM (#23942587)
You've just moved a bunch of problems to whatever is accessing SQLite. How do you scale out the application server compute if it needs to make transactionally conditional updates?

E.g.:

    transaction {
      if (expensiveFunction(query()))
        update();
    }
(My applications always get much faster when I plug them into Postgres after SQLite. But then I do do the odd sort and group by, not OLAP, but because they express the computation I want and Postgres is simply much better at that.)

There are no comments on this comment yet.