3 ms·
This is an excellent article! I wonder if there is any equivalent for Django? ArchiveBox uses SQLite via django and I've run into exactly the issue the author
by nikisweeting 2y ago
This is an excellent article! I wonder if there is any equivalent for Django?
ArchiveBox uses SQLite via django and I've run into exactly the issue the author describes in rails fairly often. It would be awesome to have a SQLite-layer solution that doesn't require serializing all my writes through some other channel in the app.
- DataDive 2y agoI recall a post by Simon Willison https://simonwillison.net/2022/Oct/23/datasette-gunicorn/#benchmarking-sqlite https://simonwillison.net/2022/Oct/23/datasette-gunicorn/#be...
- nikisweeting 2y agoThanks, he's even building a similar product as me on the same stack as me! shotscraper looks very similar to ArchiveBox.
- BiteCode_dev 2y agoYes, there is: https://gcollazo.com/optimal-sqlite-settings-for-django/ https://gcollazo.com/optimal-sqlite-settings-for-django/
- nikisweeting 2y agoAwesome, thanks. I think @flexterra (aka gcollazo) should also add `"check_same_thread": False` to the recommended OPTIONS, right? Unless they left it out intentionally?