[Haskell-cafe] Haskell SQL backends: How is data handed over?

Anthony Clayden anthony.d.clayden at gmail.com
Tue Aug 9 20:50:55 UTC 2022


> the backend constructs a complete SQL query statement in form of a string
(including the SqlValues), and hands that to the database driver to parse.
Is that indeed so?
>

Hi Olaf, that's the usual format for any HLL to pass statements (queries or
updates) to SQL.

Most HLLs provide some sort of modulate/demodulate so your program doesn't
see the raw numbers-as-strings, but the parsing is going on in the
background.

Going via CSV isn't really saving anything: the "bulk insert" is again
parsing those commas and the bits in between. (A dedicated SQL engine is
probably more efficient than Haskell's string handling.)

AntC
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.haskell.org/pipermail/haskell-cafe/attachments/20220810/16493a6c/attachment.html>


More information about the Haskell-Cafe mailing list