nit: 'Python-based' would imply to me that it's written in Python, but it looks like it's mostly C++ & LLVM:
Considering at least 2 people have gone to look at the source and then come here to comment, it would have been a net benefit for all involved. Plus, what does it say about the potential quality of your compiler if you can't even make correct English statements? This seems easier to get right than if( x = *p++ )
For people with native or fluent English, for sure. For the others, probably not.
2. There are lots of good developers who aren't capable of making any statements in English.
I thought it would have higher memory usage? (based only on reading)
code here: https://github.com/avinassh/fast-sqlite3-inserts
my blog post: https://avi.im/blag/2021/fast-sqlite-inserts/