<br><br><div class="gmail_quote">On Sat, Mar 22, 2008 at 1:40 PM, Deng Chao <<a href="mailto:knifewolf@gmail.com">knifewolf@gmail.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi all,<br>
I'm learning sqlite, and as I know haskell has some libraries like<br>
HDBC or HSQL can access sqlite DB. Can anybody give me a small example<br>
to show how to use it? It will be very appreciate? Thanks!<br>
<br>
Best Regards,<br>
Deng Chao<br>
<br>
_______________________________________________<br>
Haskell-Cafe mailing list<br>
<a href="mailto:Haskell-Cafe@haskell.org">Haskell-Cafe@haskell.org</a><br>
<a href="http://www.haskell.org/mailman/listinfo/haskell-cafe" target="_blank">http://www.haskell.org/mailman/listinfo/haskell-cafe</a><br>
</blockquote></div><br><br>Here's a quick GHCi session with HDBC.<br><br>Prelude> :m +Database.HDBC<br>Prelude Database.HDBC> :m +Database.HDBC.Sqlite3<br>Prelude Database.HDBC Database.HDBC.Sqlite3> conn <- connectSqlite3 "mydb"<br>
Prelude Database.HDBC Database.HDBC.Sqlite3> quickQuery conn "CREATE TABLE mytable (FirstName varchar, LastName varchar, Age int )" []<br>[]<br>Prelude Database.HDBC Database.HDBC.Sqlite3> quickQuery conn "INSERT INTO mytable VALUES ('Sebastian','Sylvan',26)" []<br>
[]<br>Prelude Database.HDBC Database.HDBC.Sqlite3> commit conn<br>Prelude Database.HDBC Database.HDBC.Sqlite3> quickQuery conn "SELECT * FROM mytable" []<br>[[SqlString "Sebastian",SqlString "Sylvan",SqlString "26"]]<br>
Prelude Database.HDBC Database.HDBC.Sqlite3> disconnect conn<br><br><br>Not sure why that Age field came back as a string though :-)<br><br><br>-- <br>Sebastian Sylvan<br>+44(0)7857-300802<br>UIN: 44640862