5 ms·
I said probably because I thought about it myself while writing that comment. I also have good experience with it, but if sqlite only talks SQL then just creati
by comboy 9y ago
I said probably because I thought about it myself while writing that comment. I also have good experience with it, but if sqlite only talks SQL then just creating string representation of binaries would already be prohibitive.
- ComputerGuru 9y ago> but if sqlite only talks SQL What does that mean? Like any RDBMS, SQLite is interfaced with in SQL, but can store and process binary data just fine.
- comboy 9y agoI mean that you need to serialize binary just to make an SQL statement that includes it, and that's very expensive. E.g. postgresql's COPY supports binary format which allows you to avoid that.
- ComputerGuru 9y agoThe fact that SQLite is embedded means it can take full advantage of pointer passing. I don't think it serializes anything when you bind parameters to a blob.
- anarazel 9y agoFWIW, you can use the binary protocol for SELECTs too.