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