Menu
▾
▴
haskelldb-users — For questions, suggestions, bug reports and patches
You can subscribe to this list here.
| 2004 |
Jan
|
Feb
(6) |
Mar
(11) |
Apr
(5) |
May
(23) |
Jun
|
Jul
(5) |
Aug
|
Sep
(13) |
Oct
|
Nov
(10) |
Dec
(1) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2005 |
Jan
(1) |
Feb
(18) |
Mar
|
Apr
(5) |
May
(6) |
Jun
(2) |
Jul
(2) |
Aug
(2) |
Sep
(10) |
Oct
|
Nov
(1) |
Dec
(5) |
| 2006 |
Jan
(2) |
Feb
|
Mar
(11) |
Apr
|
May
|
Jun
|
Jul
(34) |
Aug
(5) |
Sep
|
Oct
(1) |
Nov
|
Dec
|
| 2007 |
Jan
(4) |
Feb
|
Mar
(2) |
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
(3) |
Sep
(5) |
Oct
(3) |
Nov
(14) |
Dec
(15) |
| 2008 |
Jan
(13) |
Feb
(3) |
Mar
(12) |
Apr
(16) |
May
(4) |
Jun
(2) |
Jul
(26) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(3) |
| 2009 |
Jan
|
Feb
(4) |
Mar
(13) |
Apr
(22) |
May
(25) |
Jun
(2) |
Jul
(10) |
Aug
(2) |
Sep
(41) |
Oct
(5) |
Nov
(9) |
Dec
|
| 2010 |
Jan
(3) |
Feb
(4) |
Mar
|
Apr
(5) |
May
|
Jun
|
Jul
|
Aug
(5) |
Sep
(1) |
Oct
(4) |
Nov
(8) |
Dec
|
| 2011 |
Jan
(2) |
Feb
|
Mar
(3) |
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(2) |
Dec
|
| 2012 |
Jan
|
Feb
|
Mar
|
Apr
(3) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(5) |
Nov
|
Dec
(1) |
| 2013 |
Jan
|
Feb
|
Mar
(4) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(4) |
| 2014 |
Jan
(3) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2016 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2017 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Justin B. <jgb...@gm...> - 2011-03-18 22:43:40
|
On Fri, Mar 18, 2011 at 3:04 PM, Simon Michael <si...@jo...> wrote: > Hi Justin.. I have just been trying haskelldb again. Thanks for maintaining > it. The types do seem easier since I tried it a year ago. Glad you are finding it useful. > Do you by any chance have an approved fix for the date conversion error > reported in march > ? http://sourceforge.net/mailarchive/forum.php?thread_name=AANLkTikXyFJeLQXyxJOZyK51G-NTrC3wb6LxA%2B_BHrT_%40mail.gmail.com&forum_name=haskelldb-users > Possibly http://trac.haskell.org/haskelldb/ticket/7 is related. THose two are related, but I don't have a fix. Anyone can submit a patch ... :) > Is haskelldb being used (fully, including running queries) in production by > anyone ? I believe so, but I don't have anyone to point you to. My feeling is that HaskellDB works best for generating SQL which you then execute with your favorite DB library. Justin |
|
From: Deian S. <de...@cs...> - 2011-03-03 09:49:04
|
Hi all,
I'm trying to use HaskellDB with the HaskellDB-HDBC-SQLite3 driver.
Apparently there is an issue when using CalendarTime. Specifically, I
get:
Convertible: error converting source data SqlString
"2011-02-28T15:57:40 PST" of type SqlValue to type
Data.Time.LocalTime.LocalTime.ZonedTime: Cannot parse using default
format string "%Y-%m-%d %T%Q %z"
when reading from the database.
I read some old posts on the same "bug", but to my knowledge they
didn't really resolve this. I did get things working by patching
HDBC.SqlValue (v 2.2.6.1) and HaskellDB.Sql.Defaults (see below), but
this is not very clean and would like to hear if anyone has a cleaner
solution.
Thanks in advance!
-Deian
======================================
diff -rN old-haskelldb/src/Database/HaskellDB/Sql/Default.hs
new-haskelldb/src/Database/HaskellDB/Sql/Default.hs
514c514,515
< where fmt = iso8601DateFormat (Just "%H:%M:%S")
---
> -- where fmt = iso8601DateFormat (Just "%H:%M:%S")
> where fmt = iso8601DateFormat (Just "%T %Z")
======================================
---
Database/HDBC/SqlValue.hs | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/Database/HDBC/SqlValue.hs b/Database/HDBC/SqlValue.hs
index 9710d55..6e45de2 100644
--- a/Database/HDBC/SqlValue.hs
+++ b/Database/HDBC/SqlValue.hs
@@ -18,6 +18,7 @@ import qualified System.Time as ST
import Data.Time
import Data.Time.Clock.POSIX
import Database.HDBC.Locale (defaultTimeLocale, iso8601DateFormat)
+import qualified System.Locale as SL
import Data.Ratio
import Data.Convertible
import Data.Fixed
@@ -720,7 +721,7 @@ instance Convertible SqlValue LocalTime where
instance Convertible ZonedTime SqlValue where
safeConvert = return . SqlZonedTime
instance Convertible SqlValue ZonedTime where
- safeConvert (SqlString x) = parseTime' (iso8601DateFormat (Just
"%T%Q %z")) x
+ safeConvert (SqlString x) = parseTime' (SL.iso8601DateFormat
(Just "%T %Z")) x
safeConvert (SqlByteString x) = safeConvert (SqlString (BUTF8.toString x))
safeConvert (SqlInt32 x) = safeConvert (SqlInteger (fromIntegral x))
safeConvert (SqlInt64 x) = safeConvert (SqlInteger (fromIntegral x))
--
1.7.1
|
|
From: Justin B. <jgb...@gm...> - 2011-01-24 21:29:29
|
If the maintainer of this package is on the list please email me. The maintainership info on the package is not correct and I'd like to get it updated. Thanks! ---------- Forwarded message ---------- From: Bas van Dijk <v.d...@gm...> Date: Mon, Jan 24, 2011 at 11:39 AM Subject: Re: [Haskelldb-users] haskelldb-hdbc-mysql and ghc-7 To: Justin Bailey <jgb...@gm...> On 24 January 2011 16:39, Justin Bailey <jgb...@gm...> wrote: > Thanks for the note. You should contact the maintainer of the > haskelldb-hdbc-mysql pacakage - I'm not sure they read this list. It's > not maintained by me, though. The package states that its maintainer is the haskelldb-users mailinglist: http://hackage.haskell.org/package/haskelldb-hdbc-mysql Bas |
|
From: Bas v. D. <v.d...@gm...> - 2011-01-23 13:32:51
|
Hello, I just want to let you know that haskelldb-hdbc-mysql builds fine on ghc-7 after I bumped the base dependency and after I updated HDBC-mysql to work with ghc-7 (A request to its maintainer to update this his package is underway). It would be great if a 0.1.0.1 release can be made that supports ghc-7. Thanks, Bas |
|
From: Justin B. <jgb...@gm...> - 2010-11-29 17:08:37
|
I would recommend using HaskellDB to generate SQL which you then feed to HDBC. You still get type-safe queries but you don't have to be tied to HaskellDB's interface to HDBC. You will probably find yourself fighting the expression operators which expect strings (`like' in particular) but you can work around that with the `coerce` operator. 2010/11/29 Paul Graphov <gr...@gm...>: > I'am kinda novice in Haskell... > BTW, As I think it is desirable to make type conversion completely supplied > by driver > so that haskelldb itself will not depend on ByteString or anything else but > if I use HDBC > driver, I will be able to use full range of types convertible to HDBC's > SqlValue. > Now I have no ideas how to implement it. I'll think about it. :) > On 29 November 2010 19:31, Justin Bailey <jgb...@gm...> wrote: >> >> No, but I would welcome any patches :) >> >> >> 2010/11/28 Paul Graphov <gr...@gm...>: >> > Hello Haskelldb users! >> > Are there any plans to make Haskelldb able to operate with ByteStrings? >> > Thanks. >> > >> > ------------------------------------------------------------------------------ >> > Increase Visibility of Your 3D Game App & Earn a Chance To Win $500! >> > Tap into the largest installed PC base & get more eyes on your game by >> > optimizing for Intel(R) Graphics Technology. Get started today with the >> > Intel(R) Software Partner Program. Five $500 cash prizes are up for >> > grabs. >> > http://p.sf.net/sfu/intelisp-dev2dev >> > _______________________________________________ >> > Haskelldb-users mailing list >> > Has...@li... >> > https://lists.sourceforge.net/lists/listinfo/haskelldb-users >> > >> > > > > ------------------------------------------------------------------------------ > Increase Visibility of Your 3D Game App & Earn a Chance To Win $500! > Tap into the largest installed PC base & get more eyes on your game by > optimizing for Intel(R) Graphics Technology. Get started today with the > Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs. > http://p.sf.net/sfu/intelisp-dev2dev > _______________________________________________ > Haskelldb-users mailing list > Has...@li... > https://lists.sourceforge.net/lists/listinfo/haskelldb-users > > |
|
From: Paul G. <gr...@gm...> - 2010-11-29 16:54:47
|
I'am kinda novice in Haskell... BTW, As I think it is desirable to make type conversion completely supplied by driver so that haskelldb itself will not depend on ByteString or anything else but if I use HDBC driver, I will be able to use full range of types convertible to HDBC's SqlValue. Now I have no ideas how to implement it. I'll think about it. :) On 29 November 2010 19:31, Justin Bailey <jgb...@gm...> wrote: > No, but I would welcome any patches :) > > > 2010/11/28 Paul Graphov <gr...@gm...>: > > Hello Haskelldb users! > > Are there any plans to make Haskelldb able to operate with ByteStrings? > > Thanks. > > > ------------------------------------------------------------------------------ > > Increase Visibility of Your 3D Game App & Earn a Chance To Win $500! > > Tap into the largest installed PC base & get more eyes on your game by > > optimizing for Intel(R) Graphics Technology. Get started today with the > > Intel(R) Software Partner Program. Five $500 cash prizes are up for > grabs. > > http://p.sf.net/sfu/intelisp-dev2dev > > _______________________________________________ > > Haskelldb-users mailing list > > Has...@li... > > https://lists.sourceforge.net/lists/listinfo/haskelldb-users > > > > > |
|
From: Justin B. <jgb...@gm...> - 2010-11-29 16:32:29
|
No, but I would welcome any patches :) 2010/11/28 Paul Graphov <gr...@gm...>: > Hello Haskelldb users! > Are there any plans to make Haskelldb able to operate with ByteStrings? > Thanks. > ------------------------------------------------------------------------------ > Increase Visibility of Your 3D Game App & Earn a Chance To Win $500! > Tap into the largest installed PC base & get more eyes on your game by > optimizing for Intel(R) Graphics Technology. Get started today with the > Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs. > http://p.sf.net/sfu/intelisp-dev2dev > _______________________________________________ > Haskelldb-users mailing list > Has...@li... > https://lists.sourceforge.net/lists/listinfo/haskelldb-users > > |
|
From: Paul G. <gr...@gm...> - 2010-11-28 09:59:11
|
Hello Haskelldb users! Are there any plans to make Haskelldb able to operate with ByteStrings? Thanks. |
|
From: Justin B. <jgb...@gm...> - 2010-11-16 22:32:43
|
On Tue, Nov 16, 2010 at 1:31 PM, Paul Graphov <gr...@gm...> wrote: > Hello Justin, > I've made a minimal example: > http://hpaste.org/41544/haskelldb_example > Error with removed type signature is as follows: > $ ghc --make Example.hs > [1 of 1] Compiling Main ( Example.hs, Example.o ) > Example.hs:31:7: > Ambiguous type variable `a' in the constraints: > `Database.HaskellDB.Database.GetValue a' > arising from a use of `get_as' at Example.hs:31:7-12 > `Show a' arising from a use of `print' at Example.hs:31:18-22 > Probable fix: add a type signature that fixes these type variable(s) If you give the 'a' attribute a type everything works. You have to tell HaskellDB what type 'a' represents. Without a signature it assumes: a :: Attr A x where 'x' isn't known. With it, 'a' has a concrete type a :: Attr A Int I updated your paste: http://hpaste.org/41546/fixing_the_type_error Thanks for providing the example! Justin |
|
From: Justin B. <jgb...@gm...> - 2010-11-16 17:41:18
|
2010/11/14 Paul Graphov <gr...@gm...>: > Hello HaskellDB users, > First of all, can anybody point some more or less real world example of > HaskellDB usage, > containing everything from defining tables and queries to actual operations > like selecting > and inserting? This would be very useful because now the only source of > knowledge for me > are API docs (which are hard to use without basic understanding) and old > short pdf file... Unfortunately that is the best out there. You can browse the unit tests in the source code at http://code.haskell.org/haskelldb/test too. > That works but I wonder should I always explicitly specify type when I > select fields > (rec ! uid :: Int) and is it possible to avoid creating dummy type for any > query > like BlogUIdRec? If I omit any of them my program fails to compile. I know I don't have to put signatures on all my queries. Not sure why that isn't working for you. Make sure you are using a newer version of GHC (> 6.10) and that you've enabled all language extensions it might complain about. If you can put together self-contained sample (or post an error message from a real file), maybe I or someone else can give a better answer. Justin |
|
From: Justin B. <jgb...@gm...> - 2010-11-16 17:36:08
|
A couple recommendations: * I added more documentation links to the HaskellDB wiki at http://trac.haskell.org/haskelldb/. Start with "Student Paper: HaskellDB Improved". * Searching the mailing list may help (http://sourceforge.net/mailarchive/forum.php?forum_name=haskelldb-users). Hope that helps! 2010/11/15 Román González <rom...@gm...>: > Hello Justin, > I've looking everywhere for a formal documentation-tutorial of HaskellDB, > I've only found some post that don't dig to much, I was about checking the > sourcecode to see the unit tests, and there is not any either. > Is there any place where I can learn a little bit more about your library? > Thanks. > Roman.- > > |
|
From: Paul G. <gr...@gm...> - 2010-11-14 22:37:40
|
Hello HaskellDB users,
First of all, can anybody point some more or less real world example of
HaskellDB usage,
containing everything from defining tables and queries to actual operations
like selecting
and inserting? This would be very useful because now the only source of
knowledge for me
are API docs (which are hard to use without basic understanding) and old
short pdf file...
And more specifically my question is: a am trying to write some
helloworldish application
using haskelldb. I've made a sqlite3 database that contains blog entries. It
looks like follows:
database = "test.db"
withDB = sqliteConnect database
data Title = Title
instance FieldTag Title where fieldName _ = "title"
title = mkAttr Title
data Article = Article
instance FieldTag Article where fieldName _ = "article"
article = mkAttr Article
data Timestamp = Timestamp
instance FieldTag Timestamp where fieldName _ = "timestamp"
timestamp = mkAttr Timestamp
data UId = UId
instance FieldTag UId where fieldName _ = "id"
uid = mkAttr UId
type BlogTable = RecCons UId (Expr Int)
(RecCons Title (Expr String)
(RecCons Article (Expr String)
(RecCons Timestamp (Expr Int)
RecNil)))
blogTable :: Table BlogTable
blogTable = baseTable "blog" $
hdbMakeEntry UId #
hdbMakeEntry Title #
hdbMakeEntry Article #
hdbMakeEntry Timestamp
Next I want to query all ids (uids in my code to avoid confusion with
Prelude.id)
Now it looks like that:
type BlogUIdRec = RecCons UId Int RecNil
getAll :: IO [Record BlogUIdRec]
getAll = withDB $ \db -> query db $ do
t <- table blogTable
project $ uid << t!uid
main = do
rs <- getAll
print $ map (\ rec -> rec ! uid :: Int) rs
That works but I wonder should I always explicitly specify type when I
select fields
(rec ! uid :: Int) and is it possible to avoid creating dummy type for any
query
like BlogUIdRec? If I omit any of them my program fails to compile.
Thanks!
|
|
From: Justin B. <jgb...@gm...> - 2010-10-11 14:59:19
|
On Mon, Oct 11, 2010 at 7:56 AM, Christopher Done <chr...@go...> wrote: > Hey that's cool, I hadn't seen that. This'll reduce my code > significantly, especially mkFieldWithName. Cheers! > I'm not sure if it supports the "parameterization" of records that you detailed in your post - let me know how it works for you. Patches always welcome as well :) Justin |
|
From: Justin B. <jgb...@gm...> - 2010-10-11 14:45:53
|
No immediate plans but thanks for pointing that out - I hadn't seen it yet. Similar functionality exists in the haskelldb-th package, without the special type operators. On Fri, Oct 8, 2010 at 5:19 PM, Bas van Dijk <v.d...@gm...> wrote: > Great work! > > I think I'm going to use it. > > Any plan on packaging up Christopher Done's HaskellDB's type operators: > > http://chrisdone.com/posts/2010-10-07-haskelldb-and-typeoperator-madness.html > > Which allows you to write something like: > > type PersonTable = Table :$: Expr > :%: Id ::: Integer > :+: Age ::: Integer > :+: Email ::: String > :+: Blurb ::: Maybe String > :+: End > > Regards, > > Bas > |
|
From: Bas v. D. <v.d...@gm...> - 2010-10-09 00:20:07
|
Great work! I think I'm going to use it. Any plan on packaging up Christopher Done's HaskellDB's type operators: http://chrisdone.com/posts/2010-10-07-haskelldb-and-typeoperator-madness.html Which allows you to write something like: type PersonTable = Table :$: Expr :%: Id ::: Integer :+: Age ::: Integer :+: Email ::: String :+: Blurb ::: Maybe String :+: End Regards, Bas |
|
From: Justin B. <jgb...@gm...> - 2010-10-08 16:30:16
|
What is it? ======== The HaskellDB library lets you generate SQL queries without writing any actual SQL. Unlike other query generating libraries, you choose the abstraction level. Queries can be built out of independent fragments, just like your programs. Leave hand-written, string-based, SQL libraries behind and check out HaskellDB. Where to get it? ============ You can get it from Hackage (http://hackage.haskell.org/package/haskelldb) or by using cabal (cabal install haskelldb). You also need drivers for your specific database. HaskellDB currently supports the HDBC family of drivers. First, download haskelldb-hdbc (http://hackage.haskell.org/package/haskelldb-hdbc), then get the appropriate package for your database: * ODBC: haskelldb-hdbc-odbc (http://hackage.haskell.org/package/haskelldb-hdbc-odbc) * Postgres: haskelldb-hdbc-postgresql (http://hackage.haskell.org/package/haskelldb-hdbc-postgresql) * Sqllite: haskelldb-hdbc-sqlite3 (http://hackage.haskell.org/package/haskelldb-hdbc-sqlite3) Documentation, Mailing List, Source, etc ======================= Go to http://trac.haskell.org/haskelldb for detailed information. What's New? ========= * New query capabilities: stored procedures, CASTs, query parameters, constants, and more. * Postgres SQL improvements. * Bug fixes around AND and OR associativity. * Query optimization improvements around aggregate expressions. * More tests. Details ===== Back in June 2009, Bjorn Bringert passed maintainership of HaskellDB to me. I've been working this summer to get a release out, which included: * Adding an examples/ directory to the source distribution. * Archiving and consolidating information to http://trac.haskell.org/haskelldb. * Accepting patches for various issues. I have used a lot of ORM & SQL-wrapper libraries during my career and HaskellDB is the first that I've found which does not require you to eventually break the abstraction. Learning to use the the library was a fun challenge but not one that many people are willing to take, when they can easily write SQL by hand. If the library was easier to get started with, I think it would be much more widely used. Help me get HaskellDB better documentation! If you are using HaskellDB and want to help: go to http://trac.haskell.org/haskelldb and write an article, write a blog post, get in touch with me, etc. When I saw that Rails 3.0 uses the "ARel" gem (based on the relational algebra) I groaned - Haskell has had that forever! We need to get the word out! Why 2.0? -------------- Last year Brian Bloniarz contributed an awesome patch which replaced HaskellDB's home-grown record system with the HList library by Oleg Kiselyov (and colleagues). I intended to work with the library for awhile and get a 1.0 release out. Unfortunately, HList proved too daunting for GHC and for me. Compile times went way up, and I could not isolate it enough to give GHC HQ a repro case. Even worse, HList required too many Oleg units for me to comprehend. I could usually fix compile errors, but found myself struggling to extend HaskellDB's functionality. In the end I felt I needed to back the patch out. I really hated to lose some of the functionality but in the end maintainability won out. At that point I had pushed a few patches with a v1.0 cabal file, so I thought it best to make this release 2.0. Who am I? --------------- I started using HaskellDB in early 2009. I use it more as a query-generating library than for executing SQL statements. I have written a largish system for generating a data-access layer in PHP from query descriptions in HaskellDB. Yes, I'm using Haskell to write PHP ... dirty! Unmaintained & Unrelated Packages ----------------------------------------------------- A couple of haskelldb related packages on Hackage are not maintained by me: * haskelldb-hdbc-mysql - This project was created and uploaded independent of me. Contact the author for specifics. However, the haskelldb-hdbc-odbc library is maintained by me and can be used to talk to MySQL. * HSQL (haskelldb-hsql, etc) - I cannot get this backend to compile on my platform. HSQL seems unmaintained so I have let the drivers decay. You'll notice I have not uploaded new packages or changed their version dependencies. * haskelldb-flat and haskelldb-dynamic - Both of these packages have suffered serious bitrot and are not maintained any longer. |
|
From: Justin B. <jgb...@gm...> - 2010-09-01 21:31:07
|
All, Back in June of 2009, Bjorn Bringert passed the maintenance of HaskellDB to me. My desire since then has been to get HaskellDB to a 2.0 release. I think this library is the best SQL modeling tool I've ever used. I have used a lot of ORM & SQL-wrapper libraries during my career and HaskellDB is the first that I've found which does not require you to break its abstraction eventually. However, HaskellDB needs better marketing. Most importantly, it needs better documentation. Learning to use the the library was a fun challenge but not one that many people are willing to take, when they can easily write SQL by hand and execute it via HDBC or other database libraries. To that end, I am asking for your help in getting HaskellDB to v2.0 quality. I have two approaches: * I have created a wiki at http://trac.haskell.org/haskelldb/, which will consolidate all existing HaskellDB information. Please help by filling out the topic areas. In particular, showing how to connect to each supported database is very important. * The source repo now contains an examples/ directory. I would like working examples of each query operator to be available there. Joins, calculated projections and subqueries should also be shown. The queries here should just be used to show what SQL is generated - they shouldn't need a particular database connection. The queries should be against the tables included in that directory. I'll take contributions for the next couple of weeks and then upload a new release to Hackage. |
|
From: yrazes <yr...@gm...> - 2010-08-23 21:59:39
|
I would appreciate if you can help me with this trouble in Ubuntu 9.10 when I try to establish a connection HDBC - Sqlite3. I changed my sources.list too :( ghci>:module Database.HDBC Database.HDBC.Sqlite3 ghci>conn<-connectSqlite3 "test1.db" Loading package syb ... linking ... done. Loading package array-0.2.0.0 ... linking ... done. Loading package containers-0.2.0.1 ... linking ... done. Loading package bytestring-0.9.1.4 ... linking ... done. Loading package old-locale-1.0.0.1 ... linking ... done. Loading package old-time-1.0.0.2 ... linking ... done. Loading package mtl-1.1.0.2 ... linking ... done. Loading package time-1.1.2.4 ... linking ... done. Loading package convertible-1.0.2 ... linking ... done. Loading package utf8-string-0.3.5 ... linking ... done. Loading package HUnit-1.2.0.3 ... linking ... done. Loading package base-3.0.3.1 ... linking ... done. Loading package random-1.0.0.1 ... linking ... done. Loading package QuickCheck-1.2.0.0 ... linking ... done. Loading package filepath-1.1.0.2 ... linking ... done. Loading package unix-2.3.2.0 ... linking ... done. Loading package directory-1.0.0.3 ... linking ... done. Loading package process-1.0.1.1 ... linking ... done. Loading package haskell98 ... linking ... done. Loading package testpack-1.0.2 ... linking ... done. Loading package HDBC-2.1.0 ... linking ... done. Loading package HDBC-sqlite3-2.1.0.2 ... can't load .so/.DLL for: HSHDBC-sqlite3-2.1.0.2 (libHSHDBC-sqlite3-2.1.0.2.so<http://libhshdbc-sqlite3-2.1.0.2.so/>: cannot open shared object file: No such file or directory) ghci> * I've reinstall libghc6-hdbc-sqlite3-dev Regards, Julita Inca |
|
From: Justin B. <jgb...@gm...> - 2010-08-19 15:49:03
|
Don't use the darcs version - it's very unstable. I recommend rolling
back to the 0.14 tag.
On Wed, Aug 18, 2010 at 10:54 PM, Benjamin Perez
<jos...@gm...> wrote:
> great! thank you so much, the HDBC version is 2.2.6.1 and haskelldb from
> darcs version 1.0
>
> I'm test haskelldb to migrate my databases.
>
> On Mon, 2010-08-16 at 20:53 -0700, Justin Bailey wrote:
>> HSQL isn't support anymore, unless someone wants to pick it up. I
>> suggest using HDBC. Make sure you are building 0.14 release, as well.
>>
>> On Mon, Aug 16, 2010 at 2:56 PM, Benjamin Perez <jos...@gm...> wrote:
>> > Hello,
>> >
>> > Ghc 6.10.4
>> > HaskellDB from darcs
>> >
>> > When I compile the library I got this:
>> >
>> > annie:driver-hsql benkio$ runghc Setup.hs build
>> > Preprocessing library haskelldb-hsql-0.11...
>> > Building haskelldb-hsql-0.11...
>> > [1 of 1] Compiling Database.HaskellDB.HSQL ( Database/HaskellDB/HSQL.hs,
>> > dist/build/Database/HaskellDB/HSQL.o )
>> >
>> > Database/HaskellDB/HSQL.hs:54:6:
>> > Occurs check: cannot construct the infinite type: er = Record er
>> > In the `dbQuery' field of a record
>> > In the expression:
>> > Database
>> > {dbQuery = hsqlQuery gen connection,
>> > dbInsert = hsqlInsert gen connection,
>> > dbInsertQuery = hsqlInsertQuery gen connection,
>> > dbDelete = hsqlDelete gen connection,
>> > dbUpdate = hsqlUpdate gen connection,
>> > dbTables = hsqlTables connection,
>> > dbDescribe = hsqlDescribe connection,
>> > dbTransaction = hsqlTransaction connection,
>> > dbCreateDB = hsqlCreateDB gen connection,
>> > dbCreateTable = hsqlCreateTable gen connection,
>> > dbDropDB = hsqlDropDB gen connection,
>> > dbDropTable = hsqlDropTable gen connection}
>> > In the definition of `mkDatabase':
>> > mkDatabase gen connection
>> > = Database
>> > {dbQuery = hsqlQuery gen connection,
>> > dbInsert = hsqlInsert gen connection,
>> > dbInsertQuery = hsqlInsertQuery gen
>> > connection,
>> > dbDelete = hsqlDelete gen connection,
>> > dbUpdate = hsqlUpdate gen connection,
>> > dbTables = hsqlTables connection,
>> > dbDescribe = hsqlDescribe connection,
>> > dbTransaction = hsqlTransaction connection,
>> > dbCreateDB = hsqlCreateDB gen connection,
>> > dbCreateTable = hsqlCreateTable gen
>> > connection,
>> > dbDropDB = hsqlDropDB gen connection,
>> > dbDropTable = hsqlDropTable gen connection}
>> >
>> > Database/HaskellDB/HSQL.hs:160:0:
>> > Occurs check: cannot construct the infinite type: er = Record er
>> > When generalising the type(s) for `hsqlPrimQuery'
>> > annie:driver-hsql benkio$
>> >
>> > thanks,
>> >
>> > -- Benjamin
>> >
>> >
>> >
>> > ------------------------------------------------------------------------------
>> > This SF.net email is sponsored by
>> >
>> > Make an app they can't live without
>> > Enter the BlackBerry Developer Challenge
>> > http://p.sf.net/sfu/RIM-dev2dev
>> > _______________________________________________
>> > Haskelldb-users mailing list
>> > Has...@li...
>> > https://lists.sourceforge.net/lists/listinfo/haskelldb-users
>> >
>>
>> ------------------------------------------------------------------------------
>> This SF.net email is sponsored by
>>
>> Make an app they can't live without
>> Enter the BlackBerry Developer Challenge
>> http://p.sf.net/sfu/RIM-dev2dev
>> _______________________________________________
>> Haskelldb-users mailing list
>> Has...@li...
>> https://lists.sourceforge.net/lists/listinfo/haskelldb-users
>
>
>
|
|
From: Benjamin P. <jos...@gm...> - 2010-08-19 05:55:05
|
great! thank you so much, the HDBC version is 2.2.6.1 and haskelldb from
darcs version 1.0
I'm test haskelldb to migrate my databases.
On Mon, 2010-08-16 at 20:53 -0700, Justin Bailey wrote:
> HSQL isn't support anymore, unless someone wants to pick it up. I
> suggest using HDBC. Make sure you are building 0.14 release, as well.
>
> On Mon, Aug 16, 2010 at 2:56 PM, Benjamin Perez <jos...@gm...> wrote:
> > Hello,
> >
> > Ghc 6.10.4
> > HaskellDB from darcs
> >
> > When I compile the library I got this:
> >
> > annie:driver-hsql benkio$ runghc Setup.hs build
> > Preprocessing library haskelldb-hsql-0.11...
> > Building haskelldb-hsql-0.11...
> > [1 of 1] Compiling Database.HaskellDB.HSQL ( Database/HaskellDB/HSQL.hs,
> > dist/build/Database/HaskellDB/HSQL.o )
> >
> > Database/HaskellDB/HSQL.hs:54:6:
> > Occurs check: cannot construct the infinite type: er = Record er
> > In the `dbQuery' field of a record
> > In the expression:
> > Database
> > {dbQuery = hsqlQuery gen connection,
> > dbInsert = hsqlInsert gen connection,
> > dbInsertQuery = hsqlInsertQuery gen connection,
> > dbDelete = hsqlDelete gen connection,
> > dbUpdate = hsqlUpdate gen connection,
> > dbTables = hsqlTables connection,
> > dbDescribe = hsqlDescribe connection,
> > dbTransaction = hsqlTransaction connection,
> > dbCreateDB = hsqlCreateDB gen connection,
> > dbCreateTable = hsqlCreateTable gen connection,
> > dbDropDB = hsqlDropDB gen connection,
> > dbDropTable = hsqlDropTable gen connection}
> > In the definition of `mkDatabase':
> > mkDatabase gen connection
> > = Database
> > {dbQuery = hsqlQuery gen connection,
> > dbInsert = hsqlInsert gen connection,
> > dbInsertQuery = hsqlInsertQuery gen
> > connection,
> > dbDelete = hsqlDelete gen connection,
> > dbUpdate = hsqlUpdate gen connection,
> > dbTables = hsqlTables connection,
> > dbDescribe = hsqlDescribe connection,
> > dbTransaction = hsqlTransaction connection,
> > dbCreateDB = hsqlCreateDB gen connection,
> > dbCreateTable = hsqlCreateTable gen
> > connection,
> > dbDropDB = hsqlDropDB gen connection,
> > dbDropTable = hsqlDropTable gen connection}
> >
> > Database/HaskellDB/HSQL.hs:160:0:
> > Occurs check: cannot construct the infinite type: er = Record er
> > When generalising the type(s) for `hsqlPrimQuery'
> > annie:driver-hsql benkio$
> >
> > thanks,
> >
> > -- Benjamin
> >
> >
> >
> > ------------------------------------------------------------------------------
> > This SF.net email is sponsored by
> >
> > Make an app they can't live without
> > Enter the BlackBerry Developer Challenge
> > http://p.sf.net/sfu/RIM-dev2dev
> > _______________________________________________
> > Haskelldb-users mailing list
> > Has...@li...
> > https://lists.sourceforge.net/lists/listinfo/haskelldb-users
> >
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by
>
> Make an app they can't live without
> Enter the BlackBerry Developer Challenge
> http://p.sf.net/sfu/RIM-dev2dev
> _______________________________________________
> Haskelldb-users mailing list
> Has...@li...
> https://lists.sourceforge.net/lists/listinfo/haskelldb-users
|
|
From: Justin B. <jgb...@gm...> - 2010-08-17 03:54:14
|
HSQL isn't support anymore, unless someone wants to pick it up. I
suggest using HDBC. Make sure you are building 0.14 release, as well.
On Mon, Aug 16, 2010 at 2:56 PM, Benjamin Perez <jos...@gm...> wrote:
> Hello,
>
> Ghc 6.10.4
> HaskellDB from darcs
>
> When I compile the library I got this:
>
> annie:driver-hsql benkio$ runghc Setup.hs build
> Preprocessing library haskelldb-hsql-0.11...
> Building haskelldb-hsql-0.11...
> [1 of 1] Compiling Database.HaskellDB.HSQL ( Database/HaskellDB/HSQL.hs,
> dist/build/Database/HaskellDB/HSQL.o )
>
> Database/HaskellDB/HSQL.hs:54:6:
> Occurs check: cannot construct the infinite type: er = Record er
> In the `dbQuery' field of a record
> In the expression:
> Database
> {dbQuery = hsqlQuery gen connection,
> dbInsert = hsqlInsert gen connection,
> dbInsertQuery = hsqlInsertQuery gen connection,
> dbDelete = hsqlDelete gen connection,
> dbUpdate = hsqlUpdate gen connection,
> dbTables = hsqlTables connection,
> dbDescribe = hsqlDescribe connection,
> dbTransaction = hsqlTransaction connection,
> dbCreateDB = hsqlCreateDB gen connection,
> dbCreateTable = hsqlCreateTable gen connection,
> dbDropDB = hsqlDropDB gen connection,
> dbDropTable = hsqlDropTable gen connection}
> In the definition of `mkDatabase':
> mkDatabase gen connection
> = Database
> {dbQuery = hsqlQuery gen connection,
> dbInsert = hsqlInsert gen connection,
> dbInsertQuery = hsqlInsertQuery gen
> connection,
> dbDelete = hsqlDelete gen connection,
> dbUpdate = hsqlUpdate gen connection,
> dbTables = hsqlTables connection,
> dbDescribe = hsqlDescribe connection,
> dbTransaction = hsqlTransaction connection,
> dbCreateDB = hsqlCreateDB gen connection,
> dbCreateTable = hsqlCreateTable gen
> connection,
> dbDropDB = hsqlDropDB gen connection,
> dbDropTable = hsqlDropTable gen connection}
>
> Database/HaskellDB/HSQL.hs:160:0:
> Occurs check: cannot construct the infinite type: er = Record er
> When generalising the type(s) for `hsqlPrimQuery'
> annie:driver-hsql benkio$
>
> thanks,
>
> -- Benjamin
>
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by
>
> Make an app they can't live without
> Enter the BlackBerry Developer Challenge
> http://p.sf.net/sfu/RIM-dev2dev
> _______________________________________________
> Haskelldb-users mailing list
> Has...@li...
> https://lists.sourceforge.net/lists/listinfo/haskelldb-users
>
|
|
From: Benjamin P. <jos...@gm...> - 2010-08-16 21:56:40
|
Hello,
Ghc 6.10.4
HaskellDB from darcs
When I compile the library I got this:
annie:driver-hsql benkio$ runghc Setup.hs build
Preprocessing library haskelldb-hsql-0.11...
Building haskelldb-hsql-0.11...
[1 of 1] Compiling Database.HaskellDB.HSQL ( Database/HaskellDB/HSQL.hs,
dist/build/Database/HaskellDB/HSQL.o )
Database/HaskellDB/HSQL.hs:54:6:
Occurs check: cannot construct the infinite type: er = Record er
In the `dbQuery' field of a record
In the expression:
Database
{dbQuery = hsqlQuery gen connection,
dbInsert = hsqlInsert gen connection,
dbInsertQuery = hsqlInsertQuery gen connection,
dbDelete = hsqlDelete gen connection,
dbUpdate = hsqlUpdate gen connection,
dbTables = hsqlTables connection,
dbDescribe = hsqlDescribe connection,
dbTransaction = hsqlTransaction connection,
dbCreateDB = hsqlCreateDB gen connection,
dbCreateTable = hsqlCreateTable gen connection,
dbDropDB = hsqlDropDB gen connection,
dbDropTable = hsqlDropTable gen connection}
In the definition of `mkDatabase':
mkDatabase gen connection
= Database
{dbQuery = hsqlQuery gen connection,
dbInsert = hsqlInsert gen connection,
dbInsertQuery = hsqlInsertQuery gen
connection,
dbDelete = hsqlDelete gen connection,
dbUpdate = hsqlUpdate gen connection,
dbTables = hsqlTables connection,
dbDescribe = hsqlDescribe connection,
dbTransaction = hsqlTransaction connection,
dbCreateDB = hsqlCreateDB gen connection,
dbCreateTable = hsqlCreateTable gen
connection,
dbDropDB = hsqlDropDB gen connection,
dbDropTable = hsqlDropTable gen connection}
Database/HaskellDB/HSQL.hs:160:0:
Occurs check: cannot construct the infinite type: er = Record er
When generalising the type(s) for `hsqlPrimQuery'
annie:driver-hsql benkio$
thanks,
-- Benjamin
|
|
From: MH <mh...@gm...> - 2010-04-10 00:21:55
|
I am trying to use dbdirect-hdbc-odbc to generate database description modules and I am getting the following error: dbdirect-hdbc-odbc: Prelude.(!!): index too large I am running the following command, where "test" is the name of the Oracle schema: dbdirect-hdbc-odbc "test" "dsn=ORACLE_DSN;UID=userName;PWD=password" Do you know what could be the problem and how can I work around it? Thanks, MH |
|
From: Chris D. <ch...@ch...> - 2010-04-02 05:52:14
|
I had some difficult building it--I will persist! Thanks, Chris -----Original Message----- From: R. Emre Başar [mailto:re...@cs...] Sent: 02 April 2010 12:11 AM To: Chris Dornan Cc: has...@li... Subject: Re: [Haskelldb-users] HaskellDB/MySQL I have created an inventory application for my personal use using haskelldb-hsql-mysql a couple of months ago. Though it was not a complex application, I did not have any trouble conecting to MySQL. Chris Dornan said: > Hi everyone, > > > > I am planning to use HaskellDB to interface to MySQL in a commercial > embedded Linux app (though it would be useful if it worked on Windows too). > > > > Is HaskellDB working with MySQL at the moment? > > > > Thanks, > > > > Chris > > > > ---------------------------------------------------------------------- > -------- Download Intel® Parallel Studio Eval Try the new > software tools for yourself. Speed compiling, find bugs proactively, > and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > Haskelldb-users mailing list > Has...@li... > https://lists.sourceforge.net/lists/listinfo/haskelldb-users -- R. Emre Başar İstanbul Bilgi University Department of Computer Science |
|
From: R. E. B. <re...@cs...> - 2010-04-02 05:27:35
|
I have created an inventory application for my personal use using haskelldb-hsql-mysql a couple of months ago. Though it was not a complex application, I did not have any trouble conecting to MySQL. Chris Dornan said: > Hi everyone, > > > > I am planning to use HaskellDB to interface to MySQL in a commercial > embedded Linux app (though it would be useful if it worked on Windows too). > > > > Is HaskellDB working with MySQL at the moment? > > > > Thanks, > > > > Chris > > > > ------------------------------------------------------------------------------ > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > Haskelldb-users mailing list > Has...@li... > https://lists.sourceforge.net/lists/listinfo/haskelldb-users -- R. Emre Başar İstanbul Bilgi University Department of Computer Science |
4 messages has been excluded from this view by a project administrator.
