from Hacker News

Optimizing SQLite for Servers

by unsolved73 on 2/15/24, 3:21 PM with 12 comments

  • by tiffanyh on 2/15/24, 10:00 PM

    I'm surprised they didn't spend more time talking about HCTree branch.

    https://sqlite.org/hctree/doc/hctree/doc/hctree/index.html

  • by neverrroot on 2/15/24, 11:16 PM

    We need more sqlite on the servers. Much more.
  • by ghaering on 2/16/24, 6:30 AM

    For production setups, you usually want high-availability. So unless you use it on a network file system like EFS (which the SQLite author recommends against), SQLite is not an option.
  • by giovannibonetti on 2/16/24, 1:18 AM

    Related: Turbo [1] helps dealing with SQLite replication in a different way.

    [1] https://turso.tech/