Inserting a billion rows in SQLite under a minute
Hey all, author here. I didn't expect this to reach front page of HN. I came here to submit and it was here already! I am looking for more ideas to experiment. Here's one idea which someone from another forum gave me: exploring recursive queries and using SQLite random methods to do the insertions.Another crazy idea is to learn about SQLite file format and just write the pages to disk.