| 1. | | SQLite prefixes its temp files with `etilqs_` (avi.im) |
| 1 point by birdculture 7 months ago | past |
|
| 2. | | SQLite prefixes its temp files with `etilqs_` (avi.im) |
| 3 points by avinassh 7 months ago | past |
|
| 3. | | Setsum: Order agnostic, additive, subtractive checksum (avi.im) |
| 2 points by fanf2 on Sept 22, 2025 | past |
|
| 4. | | Setsum – order agnostic, additive, subtractive checksum (avi.im) |
| 1 point by thunderbong on Sept 14, 2025 | past |
|
| 5. | | Setsum – order agnostic, additive, subtractive checksum (avi.im) |
| 2 points by adityaathalye on Sept 14, 2025 | past |
|
| 6. | | Setsum – order agnostic, additive, subtractive checksum (avi.im) |
| 4 points by avinassh on Sept 13, 2025 | past | 1 comment |
|
| 7. | | Oldest recorded transaction (avi.im) |
| 182 points by avinassh on Sept 6, 2025 | past | 106 comments |
|
| 8. | | Replacing a cache service with a database (avi.im) |
| 81 points by avinassh on Aug 31, 2025 | past | 66 comments |
|
| 9. | | SQLite (with WAL) doesn't do `fsync` on each commit under default settings (avi.im) |
| 106 points by Bogdanp on Aug 24, 2025 | past | 91 comments |
|
| 10. | | PSA: SQLite WAL checksums fail silently and may lose data (avi.im) |
| 279 points by avinassh on July 24, 2025 | past | 129 comments |
|
| 11. | | Rickrolling Turso DB (SQLite Rewrite in Rust) (avi.im) |
| 4 points by todsacerdoti on July 21, 2025 | past |
|
| 12. | | Fun facts about SQLite (avi.im) |
| 393 points by avinassh on Dec 30, 2024 | past | 191 comments |
|
| 13. | | How bloom filters made SQLite 10x faster (avi.im) |
| 504 points by avinassh on Dec 22, 2024 | past | 121 comments |
|
| 14. | | It is becoming difficult for me to be productive in Python (avi.im) |
| 2 points by avinassh on Dec 20, 2024 | past | 1 comment |
|
| 15. | | In Search of a Faster SQLite (avi.im) |
| 355 points by avinassh on Dec 16, 2024 | past | 149 comments |
|
| 16. | | In Search of a Faster SQLite (avi.im) |
| 2 points by wakawaka28 on Dec 16, 2024 | past | 1 comment |
|
| 17. | | In Search of a Faster SQLite (avi.im) |
| 4 points by redbell on Dec 15, 2024 | past |
|
| 18. | | In Search of a Faster SQLite (avi.im) |
| 15 points by avinassh on Dec 14, 2024 | past |
|
| 19. | | Galloping Search (avi.im) |
| 1 point by avinassh on Dec 7, 2024 | past |
|
| 20. | | Building a distributed log using S3 (under 150 lines of Go) (avi.im) |
| 63 points by todsacerdoti on Dec 1, 2024 | past | 31 comments |
|
| 21. | | Zero Disk Architecture for Databases (avi.im) |
| 3 points by avinassh on Nov 26, 2024 | past |
|
| 22. | | Zero Disk Architecture (avi.im) |
| 2 points by fofoz on Nov 25, 2024 | past |
|
| 23. | | Zero Disk Architecture for Databases (avi.im) |
| 2 points by thunderbong on Nov 25, 2024 | past |
|
| 24. | | Zero Disk Architecture (avi.im) |
| 7 points by todsacerdoti on Nov 24, 2024 | past |
|
| 25. | | PSA: Most databases do not do checksums by default (avi.im) |
| 1 point by ksec on Nov 11, 2024 | past |
|
| 26. | | PSA: Most databases do not do checksums by default (avi.im) |
| 2 points by tosh on Nov 10, 2024 | past |
|
| 27. | | SQLite does not do checksums (avi.im) |
| 132 points by todsacerdoti on Nov 9, 2024 | past | 98 comments |
|
| 28. | | Disaggregated Storage – A Brief Introduction (avi.im) |
| 1 point by asicsp on Nov 4, 2024 | past |
|
| 29. | | Disaggregated Storage – A Brief Introduction (avi.im) |
| 5 points by todsacerdoti on Nov 3, 2024 | past |
|
| 30. | | Towards Inserting 1B Rows in SQLite Under a Minute (2021) (avi.im) |
| 2 points by tosh on Sept 16, 2024 | past |
|
|
| More |