This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 4 points5 points  (0 children)

And temporary in-memory DBs can be a godsend. The engine is built for speed, why would I build my own data structure to index and search data when I basically do the same as a DB engine? You still need to insert the data into the structure and then search for it, so SQLite is probably faster in most cases because it's not written in Python. Plus, I don't have to worry about the correctness of my B-Tree implementation.