Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

I actually did try this, but I got impatient and stopped it after 30 minutes or so, and a ~20G database file.

For some reason, after that, `ls` in that directory (or even shell completion) would freeze the shell entirely, even after reboot. I eventually managed to delete the file with `rm db.sqlite` (no completion allowed), but even that took like 2 minutes.

I might try again with WAL enabled (based on my shell history, I also deleted a -journal file).



Have you tried DuckDB? It’s the columnar version of SQLite.


Not yet, I might give it a try.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: