Mirror of forum.nim-lang.org

10360 :: 0 copy transfer of strings and blobs to SQLite?

• ingo (orginal) [2023-07-27T08:46:04+02:00] view original

  This thread on SQLite peaked my interest. Especially post 6.1 pointing to a Rust library .

  Is this done in Nim / can it be done in Nim?

  (not a (library) feature request, purely interest)

---

• Araq (orginal) [2023-07-27T13:48:52+02:00] view original

  Why would it be impossible with Nim? You can use any entry point that SQLite offers.

---

• ingo (orginal) [2023-07-27T18:53:03+02:00] view original

  Don't know, I only stay very much at the surface of Nim, as an eternal noob.

---

• treeform (orginal) [2023-07-27T20:21:44+02:00] view original

  I believe thats what happens in my sqlite debby wrapper:

  https://github.com/treeform/debby/blob/master/src/debby/sqlite.nim#L120

  I am never re-encoding the string just passing pointers and length to bind. I assume no copy happens but I have not verified this with a debugger.

  It sucks that mysql or postgres do not provide this functionally and require costly binary encodings!

---