Re:Soul: A SQLite REST and Realtime Server
by geenat on Wednesday March 20, 2024 @04:01AM
(#39763824)
Btw ws4sqlite rewrite in rust that's allegedly faster: https://github.com/proofrock/sqliterg
[ Parent
| on HN ]
Re:Soul: A SQLite REST and Realtime Server
by geenat on Wednesday March 20, 2024 @07:16AM
(#39764970)
Ran the same test, same server (Ubuntu 22.04 + 32 thread 7950X + Gen 4 NVME + 64GB DDR5) -- nearly zero difference sqliterg vs ws4sqlite.
sqliterg (CURL)
20,000 / 2,500 / 237
For those wondering about write performance...its poor except for direct SQLite. If you're write heavy, look elsewhere, or use SQLite directly (preferably with multiple databases and WAL2).
INSERT INTO users (id) VALUES (..); per second ( 1x / 10x / 100x )
SQLite WAL
11,000 / 3,000 / 300
SQLite WAL2
14,500 / 3,000 / 760
SQLite WAL2 (3x Database files)
29,000 / 6,000 / 1,400
sqliterg (CURL)
1,750 / 181 / blocks indefinitely