Jeff Martin on Nostr: npub1kkecg…92d7c Yeah, that's essentially the prepared statements approach, right? ...
npub1kkecgjtdpk2e43ka38xg968xtkh5x00hsruw6htfkj6tl8ll6g7q492d7c (npub1kke…2d7c) Yeah, that's essentially the prepared statements approach, right? I've recently learned of SQLx and I'm looking into it. It looks very nice actually.
The trouble I've run into with prepared statements in the past is parameter type matching with the programing language. Those errors usually aren't detectable at compile time. As far as I know? still learning about SQLx.
Some key-value stores have a nice simplicity to them in that values are always just byte arrays. Handling serialization myself in the app isn't hard at all. Rust has very nice serialization libraries. And if you use a wire format like protobufs, you get quite a bit of future-proofing for almost free.
The trouble I've run into with prepared statements in the past is parameter type matching with the programing language. Those errors usually aren't detectable at compile time. As far as I know? still learning about SQLx.
Some key-value stores have a nice simplicity to them in that values are always just byte arrays. Handling serialization myself in the app isn't hard at all. Rust has very nice serialization libraries. And if you use a wire format like protobufs, you get quite a bit of future-proofing for almost free.