Victor Skvortsov
@r4victor.bsky.social
Hardcore backend stuff, python, cloud and ml
Author of Python behind the scenes
Building dstack.ai
My blog: http://tenthousandmeters.com
Other projects: https://github.com/r4victor
Author of Python behind the scenes
Building dstack.ai
My blog: http://tenthousandmeters.com
Other projects: https://github.com/r4victor
Wait, there is a podcast on python internals? Please keep it up guys! I've gone listening to all the episodes.
January 26, 2025 at 7:02 PM
Wait, there is a podcast on python internals? Please keep it up guys! I've gone listening to all the episodes.
An article on this: www.golang.dk/articles/ben...
Benchmarking SQLite Performance in Go
SQLite has a reputation of being a toy database useful only for hobby projects and integration tests. I’ll show you why this is not true, with data to back it up.
www.golang.dk
January 26, 2025 at 6:47 PM
An article on this: www.golang.dk/articles/ben...
Benchmarked this on mpb 2021 inserting 1KB blobs. Each insert is a separate transaction.
Explanation: SQLite is known to have limited concurrency. It uses a global lock to sync writes. With too much contention it's less efficient than, say, a go mutex because it's a file lock.
Explanation: SQLite is known to have limited concurrency. It uses a global lock to sync writes. With too much contention it's less efficient than, say, a go mutex because it's a file lock.
January 26, 2025 at 6:27 PM
Benchmarked this on mpb 2021 inserting 1KB blobs. Each insert is a separate transaction.
Explanation: SQLite is known to have limited concurrency. It uses a global lock to sync writes. With too much contention it's less efficient than, say, a go mutex because it's a file lock.
Explanation: SQLite is known to have limited concurrency. It uses a global lock to sync writes. With too much contention it's less efficient than, say, a go mutex because it's a file lock.