Re: status of chickenlib: build process and mysql interface usage sample
gian paolo ciceri <gp.ciceri <at> suddenthinks.com>
2004-09-01 13:05:21 GMT
Jörg F. Wittenberger wrote:
|> > Thanks Joerg for your feedback,
|> > but it seems to me the file in attachment is the
|> > mysql interface itself, while I need a little sample
|> > how to use it, say a connect, a select query, and insert/update
|> > query and a disconnect.
|> >
|> >
|>
|>wopuld it be hard to provide a generalised sql interface on the lines
|>of Perl's DBI/DBD architecture?
|
|
| Well, it basically stems from such an idea. I do have mysql and
| postgresql, sqllite is not hard, but the db2 implementation turned up,
| that the interface might be worth some minor reconsideration, since db2
| doesn't allow "seek"operations in the result set. However it's not hard
| to modify.
mmmh., chickenlib has something following this schema (dbi/dbd),
for mysql and oracle - as eggs we've postgresql and sqlite that
don't follow this approach AFAIK.
Perhaps it's worth the effort to unify all of this attempts
in an unique common framework - and dbi/dbd could be the
right one (even if python db-api could be an alternative).
Felix, any suggestion for this ?
(Continue reading)