
I've had some questions about my intentions for HDBC. The Current Plan is: Release 1.0.0 next week. Before that happens, I want to have a stable and useful API. I have one feature request to implement yet (examinine properties of arbitrary tables in the database). I also want to finish the ODBC driver first, which should happen yet this week. After that, I will probably also release a MySQL backend. I hope that HDBC can be a community effort. Towards that end, I hope to be able to get some trac pages going on somebody's server and perhaps a mailing list where ideas and implementations for future enhancements can be discussed. I'd also like to be able to help people that would like to write backends for additional databases. (I also should announce hsql-testsuite, the common HUnit suite that is used to test each database backend.) The development time for a HDBC backend looks like about 1 day per database, including the amount of time it takes to learn that database's C API. (A bit more for ODBC because its API is weird and the documentation is unhelpful) Post 1.0.0, I will spend some time optimizing performance in the existing database drivers. There are several opportunities to do that, and they should yield significant results for certain use cases (such as inserting thousands or millions of rows of data at once.) Comments and suggestions are quite welcome. Patches too ;-) -- John

On Wed, 2006-01-04 at 19:25 +0000, John Goerzen wrote:
I hope that HDBC can be a community effort. Towards that end, I hope to be able to get some trac pages going on somebody's server and perhaps a mailing list where ideas and implementations for future enhancements can be discussed.
That would be very nice.
The development time for a HDBC backend looks like about 1 day per database, including the amount of time it takes to learn that database's C API. (A bit more for ODBC because its API is weird and the documentation is unhelpful)
Huh..being a Haskell newbie (still) learning the language, I can only dream about such productivity :-) Nonetheless, I am very happy seeing the progress of your work and looking forward to help (in any way) so that Haskell get a very solid framework for developing database-aware applications making it (even) more useful/attractive for wider audience of programmers.
Comments and suggestions are quite welcome. Patches too ;-)
For now, I can only say: thank you! Sincerely, Gour

Hi John, Thanks for releasing HDBC. This is probably more of a GHC question, but is there any way to staticly link in the Sqlite3 libraries with an application that uses HDBC.Sqlite3? Thanks! -Tom John Goerzen wrote:
I've had some questions about my intentions for HDBC. The Current Plan is:
Release 1.0.0 next week. Before that happens, I want to have a stable and useful API. I have one feature request to implement yet (examinine properties of arbitrary tables in the database). I also want to finish the ODBC driver first, which should happen yet this week.
After that, I will probably also release a MySQL backend.
I hope that HDBC can be a community effort. Towards that end, I hope to be able to get some trac pages going on somebody's server and perhaps a mailing list where ideas and implementations for future enhancements can be discussed. I'd also like to be able to help people that would like to write backends for additional databases. (I also should announce hsql-testsuite, the common HUnit suite that is used to test each database backend.) The development time for a HDBC backend looks like about 1 day per database, including the amount of time it takes to learn that database's C API. (A bit more for ODBC because its API is weird and the documentation is unhelpful)
Post 1.0.0, I will spend some time optimizing performance in the existing database drivers. There are several opportunities to do that, and they should yield significant results for certain use cases (such as inserting thousands or millions of rows of data at once.)
Comments and suggestions are quite welcome. Patches too ;-)
-- John
_______________________________________________ Haskell-Cafe mailing list Haskell-Cafe@haskell.org http://www.haskell.org/mailman/listinfo/haskell-cafe

On Fri, Jan 06, 2006 at 03:06:07PM -0600, Tom Hawkins wrote:
Hi John,
Thanks for releasing HDBC. This is probably more of a GHC question, but is there any way to staticly link in the Sqlite3 libraries with an application that uses HDBC.Sqlite3?
Yes, you can do that. I think that using ghc -optc -static will do what you want. Or some permutation thereof. That will, of course, also link in libc and everything else statically. Alternatively, you can manually reference libsqlite3.a. However, since the Cabal package is compiled to link in sqlite3 automatically, you'll have to hack your ghc package info first, I think. Hopefully that will give you enough to get started at least. -- John
participants (3)
-
Gour
-
John Goerzen
-
Tom Hawkins