[Haskell-beginners] Sqlite3 - INSERT statement question

Patrick Lynch kmandpjlynch at verizon.net
Thu Feb 3 22:37:19 CET 2011

...BTW: do you know if there is a good tutorial on Haskell and Sqlite3....
...I'm pretty good at SQL, and if I can get thru Chapters 21, 22 and 23 in 
"Real World Haskell"...I'd like to take a careful look at one...
...If there isn't a good tutorial available, I think I'll write one initally 
for my own use and if it is any good I'll share it with the group...

...Overall, I found the installation of Sqlite3 on Windows Vista to be a 
major challenge - I still don't think that I have the procedure to do it 
again...but I need to install it on my Mac...not looking forward to 
that...I've been fighting with the Apple support people already...bummer...

...As for installing gtk2hs, I'm getting nowhere with this...I'll tackle it 
next week...

Thanks again for your help...I hope that I can repay your kindness 


----- Original Message ----- 
From: "Brent Yorgey" <byorgey at seas.upenn.edu>
To: "Patrick Lynch" <kmandpjlynch at verizon.net>
Cc: <beginners at haskell.org>
Sent: Thursday, February 03, 2011 3:22 PM
Subject: Re: [Haskell-beginners] Sqlite3 - INSERT statement question

> On Thu, Feb 03, 2011 at 02:09:41PM -0500, Patrick Lynch wrote:
>> ...looks good, thank you - see following: [note: the '1' on the 2nd
>> line indicates a successful command execution] --
>> Prelude Database.HDBC Database.HDBC.Sqlite3> run conn "INSERT INTO
>> test VALUES (?, ?)" [toSql (0::Int), toSql ("zero"::[Char])]
>> 1
> Great. Note that the ::[Char] annotation is not strictly necessary,
> since the type of "zero" is unambiguous*.  But of course it can't hurt
> anything.
> -Brent
> * Well, unless you have enabled -XOverloadedStrings... 

More information about the Beginners mailing list