Librebase
Librebase vs the usual stack.
Same computer. Same tests. Librebase vs the . Every number below was measured.
0 vs 499, both at 100% correct
0 MBidle RAM, vs ~1.85 GB
0.0 MBinstall size, vs ~7.5 GB
0 msuntil ready, vs ~442 ms
Size
One process. 2 MB idle.
The open stack needs a fleet of services for the same product. Librebase is one small program.
open stack12
Librebase1
open stack~1.85 GB
Librebase~2 MB
Install size
open stack~7.5 GB
Librebase8.2 MB
open stack~442 ms
Librebase~265 ms
01
Search
9.4× faster at 100% correct.
That 9.4× is 4,683 vs 499 searches per second, both at 100% correct. Same 10,000 items, same questions.
open stack499 QPS
Librebase4,683 QPS
open stack1,129 QPS
Librebase4,683 QPS
open stack853 QPS
Librebase2,746 QPS
open stack543 QPS
Librebase1,500 QPS
open stack
Librebase669 QPS
Settingsearches/secmicrosecondscorrecttop result
Exact, no shortcut669 ()1,495 ()100% ()100% ()
ef=404,683 (1,129)214 (885)100% (88.7%)100% (88.7%)
ef=802,746 (853)364 (1,172)100% (92.5%)100% (92.5%)
ef=1601,500 (543)667 (1,842)100% (96.9%)100% (96.9%)
ef=320823 (499)1,214 (2,005)100% (100%)100% (100%)
ef=640581 (488)1,721 (2,051)100% (100%)100% (100%)
Librebase first, open stack in parentheses. Same setting on each row.
02
Writes and reads
5× the write speed.
5,591 vs 1,124 rows per second. Then we asked for one row, a range, and a page. Times are typical (the middle result).
open stack1,124 /s
Librebase5,591 /s
open stack~3.4 ms
Librebase0.05 ms
open stack~15.8 ms
Librebase0.06 ms
open stack~3.6 ms
Librebase0.06 ms
03
App API and sign-in
Sign-in is about 4× faster.
Log in is 52 ms vs 196 ms. Creating an account is 56 ms vs 207 ms. The app API is faster too, by a smaller amount.
open stack196.1 ms
Librebase52.0 ms
open stack206.8 ms
Librebase56.0 ms
open stack6.52 ms
Librebase4.63 ms
open stack5.10 ms
Librebase3.59 ms
open stack5.95 ms
Librebase4.14 ms
open stack6.24 ms
Librebase4.37 ms
open stack4.99 ms
Librebase4.07 ms
04
Files
Uploads are 8× faster.
24.2 ms vs 2.8 ms to upload. Downloads and links are faster too.
open stack24.2 ms
Librebase2.8 ms
open stack12.6 ms
Librebase2.2 ms
open stack8.8 ms
Librebase4.8 ms
open stack11.4 ms
Librebase2.0 ms
05
Live updates
Live connections are about 3× faster.
Time to open a live connection and subscribe to updates.
open stack~5.1 ms
Librebase~1.6 ms
open stack~1.9 ms
Librebase~0.6 ms
06
Compatibility
111 of 111 core tests pass.
The basic tests for reading and writing tables over the web. The full suite is 274/350 — extra Postgres features we do not ship yet.
Core table testsFull suite
Librebase111/111274/350
Open stack111/111350/350
07
Summary
The scoreboard
DimensionWinnerDetail
SizeLibrebase1 vs 12 services · ~2 MB vs ~1.85 GB idle
Time to readyLibrebase~265 ms vs ~442 ms
Search at 100% correctLibrebase4,683 vs 499 QPS (9.4×)
WritesLibrebase5,591 vs 1,124 rows/s (5×)
Sign-inLibrebase52 ms vs 196 ms to log in
FilesLibrebase2.8 ms vs 24.2 ms to upload
Live updatesLibrebase~1.6 ms vs ~5.1 ms to connect
Core table testsTie111/111 both
Methodology
  • Same computer, same tests, measured numbers only.
  • Open stack means Postgres plus login, files, and search, as we ran it.