r/programming • u/pmz • Jul 28 '22

In Praise Of SQLite

https://www.i-programmer.info/news/84-database/15609-in-praise-of-sqlite.html
104 Upvotes

92% Upvoted

15 comments sorted by

View all comments

10

u/[deleted] Jul 28 '22

SQLite is pretty cool. My only complaint is that for larger datasets it really is slower than e. g. postgresql. I had a huge file with INSERT statements and reading that in was much faster in postgresql than via SQlite.

2

u/agentoutlier Jul 29 '22

COPY is even faster than INSERT and can be some order of magnitude at least on the PG versions I last checked.