Re: [Haskell-cafe] Takusen - is anyone currently using it on Win32 - ODBC?
2009/9/1 Günther Schmidt gue.schm...@web.de: One of the files for instance has 298 k lines. A glance over sushi revealed that parsec is involved so I can only presume it is read into memory all at once. That would certainly be a problem. There is nothing inherent about parsec that would cause all input to be read into memory, TxtSushi uses parsec for parsing SQL, not for CSV, by the way. ___ Haskell-Cafe mailing list Haskell-Cafe@haskell.org http://www.haskell.org/mailman/listinfo/haskell-cafe
Re: [Haskell-cafe] Takusen - is anyone currently using it on Win32 - ODBC?
Hi Alistair, I'm using Takusen to read in static data from an SQLite database and that works just fine. My app then needs to read in dynamic data, a set of 4 CSV files, and I had been using Microsofts ODBC driver with HDBC.ODBC and that worked too. When I try to swap it for Takusen though I get an *** Exception: DBError (HY,C00) 106 [Microsoft][ODBC Text Driver] Optional Feature was not implemented Which is a bit of a shame, because using the ODBC text driver was much simpler than parsing the CSV files. I'm using WinXP Pro with ghc 6.10.4 (Haskell plattform) here. Günther Am 23.08.2009, 22:47 Uhr, schrieb Alistair Bayley alist...@abayley.org: 2009/8/23 Günther Schmidt gue.schm...@web.de: is anyone currently using takusen with odbc on Win32? In particular with MS Access? I'm asking because I noticed that when database libraries are declared to work with ODBC no one seems to mean Win32 ODBC, but rather Unix ODBC. Yes. The ODBC backend is tested on Win32, although not with MS Access (Oracle, PostgreSQL, and MS SQL Server have been tested). If you have problems with MS Access, do let me know. Alistair ___ Haskell-Cafe mailing list Haskell-Cafe@haskell.org http://www.haskell.org/mailman/listinfo/haskell-cafe
Re: [Haskell-cafe] Takusen - is anyone currently using it on Win32 - ODBC?
Günther Schmidt wrote: My app then needs to read in dynamic data, a set of 4 CSV files, and I had been using Microsofts ODBC driver with HDBC.ODBC and that worked too. When I try to swap it for Takusen though I get an *** Exception: DBError (HY,C00) 106 [Microsoft][ODBC Text Driver] Optional Feature was not implemented Which is a bit of a shame, because using the ODBC text driver was much simpler than parsing the CSV files. A simple but powerful way to access CSV files is via TxtSushi, which gives SQL access to CSV files, without needing ODBC: Home page: http://keithsheppard.name/txt-sushi/ Hackage: http://hackage.haskell.org/package/txt-sushi You'd have to use it directly, since afaik it won't work with Takusen, although a Takusen back end for it ought to be possible. Anton ___ Haskell-Cafe mailing list Haskell-Cafe@haskell.org http://www.haskell.org/mailman/listinfo/haskell-cafe
Re: [Haskell-cafe] Takusen - is anyone currently using it on Win32 - ODBC?
Hi Anton, well the problem isn't really accessing the data as such, it's quite easy to use HDBC.ODBC for instance to read in the data in a very comfortable way. I was explicitly asking for Takusen because it make certain guarantees regarding resources, memory consumption and such. One of the files for instance has 298 k lines. A glance over sushi revealed that parsec is involved so I can only presume it is read into memory all at once. That would certainly be a problem. Thanks, Günther Am 31.08.2009, 19:47 Uhr, schrieb Anton van Straaten an...@appsolutions.com: Günther Schmidt wrote: My app then needs to read in dynamic data, a set of 4 CSV files, and I had been using Microsofts ODBC driver with HDBC.ODBC and that worked too. When I try to swap it for Takusen though I get an *** Exception: DBError (HY,C00) 106 [Microsoft][ODBC Text Driver] Optional Feature was not implemented Which is a bit of a shame, because using the ODBC text driver was much simpler than parsing the CSV files. A simple but powerful way to access CSV files is via TxtSushi, which gives SQL access to CSV files, without needing ODBC: Home page: http://keithsheppard.name/txt-sushi/ Hackage: http://hackage.haskell.org/package/txt-sushi You'd have to use it directly, since afaik it won't work with Takusen, although a Takusen back end for it ought to be possible. Anton ___ Haskell-Cafe mailing list Haskell-Cafe@haskell.org http://www.haskell.org/mailman/listinfo/haskell-cafe
Re: [Haskell-cafe] Takusen - is anyone currently using it on Win32 - ODBC?
2009/8/23 Günther Schmidt gue.schm...@web.de: is anyone currently using takusen with odbc on Win32? In particular with MS Access? I'm asking because I noticed that when database libraries are declared to work with ODBC no one seems to mean Win32 ODBC, but rather Unix ODBC. Yes. The ODBC backend is tested on Win32, although not with MS Access (Oracle, PostgreSQL, and MS SQL Server have been tested). If you have problems with MS Access, do let me know. Alistair ___ Haskell-Cafe mailing list Haskell-Cafe@haskell.org http://www.haskell.org/mailman/listinfo/haskell-cafe