Hi,
I have made an alternative version of [sqlsingle] (an object by Iain Mott for querying Postgres databases), which holds the connection to the database open by default and closes it on demand, rather than closing (and vacuuming) the database after every query. I intend to call the new object [psql], and maintain/develop it. Before committing to CVS, does anyone ahave any objections to this?
I just ask in case Iain is still maintaining [sqlsingle], or someone has already done a similar thing.
Jamie
This would be great! Is a [sql] object possible that would access any SQL database? That would be even better.
.hc
On Feb 6, 2006, at 11:14 AM, Jamie Bullock wrote:
Hi,
I have made an alternative version of [sqlsingle] (an object by Iain Mott for querying Postgres databases), which holds the connection to the database open by default and closes it on demand, rather than closing (and vacuuming) the database after every query. I intend to call the new object [psql], and maintain/develop it. Before committing to CVS, does anyone ahave any objections to this?
I just ask in case Iain is still maintaining [sqlsingle], or someone has already done a similar thing.
Jamie
PD-dev mailing list PD-dev@iem.at http://lists.puredata.info/listinfo/pd-dev
________________________________________________________________________ ____
"The arc of history bends towards justice." - Dr. Martin Luther King, Jr.
Hallo!
This would be great! Is a [sql] object possible that would access any SQL database? That would be even better.
hm - what do you mean by any SQL database? I once made a simple abstraction to access SQL database with pyext and the python SQL Interface... if that would be useful I could search for it ...
LG Georg
On Feb 6, 2006, at 12:55 PM, Georg Holzmann wrote:
Hallo!
This would be great! Is a [sql] object possible that would access any SQL database? That would be even better.
hm - what do you mean by any SQL database? I once made a simple abstraction to access SQL database with pyext and the python SQL Interface... if that would be useful I could search for it ...
I guess I mean like an ODBC kind of thing, since SQL is just the query language rather than a standard way of accessing a database.
Perhaps a [sql] object would generate SQL queries, and an [odbc] object would handle the connection to the database.
.hc
________________________________________________________________________ ____
On 6 Feb 2006, at 18:47, Hans-Christoph Steiner wrote:
On Feb 6, 2006, at 12:55 PM, Georg Holzmann wrote:
This would be great! Is a [sql] object possible that would access any SQL database? That would be even better.
hm - what do you mean by any SQL database? I once made a simple abstraction to access SQL database with pyext and the python SQL Interface... if that would be useful I could search for it ...
I guess I mean like an ODBC kind of thing, since SQL is just the query language rather than a standard way of accessing a database.
Perhaps a [sql] object would generate SQL queries, and an [odbc] object would handle the connection to the database.
Are we talking about full persistence, here? That would be amazing. If we could have an [sql] object actually populate a db from say, a yaml file?
d
-- David Plans Casal Researcher, UEA Studios d.casal at uea dot ac dot uk http://www.davidcasal.com
Hallo, Hans-Christoph Steiner hat gesagt: // Hans-Christoph Steiner wrote:
I guess I mean like an ODBC kind of thing, since SQL is just the query language rather than a standard way of accessing a database.
Perhaps a [sql] object would generate SQL queries, and an [odbc] object would handle the connection to the database.
I personally think implementing db connections into Pd is a waste of time, when we have Python and Ruby available in Pd. Of course that should not stop anyone from still doing it, cause in some regard, Pd is all about wasting time.
Databases are slow and most probably not realtime save, so some kind of threading would be useful. Pd needs faster guaranteed response times than a website.
Many people really don't want to code SQL directly anymore, unless force is applied. Object-oriented wrappers are everywhere now. (though it is debatable if OO-wrappers would match Pd's message system very well.)
All of these features are available in Python and Ruby directly. I don't know Ruby, but for Python SQLObject would be worth a try, at least, that's what I'm using for years now to do website (I wrote the first Sqlite driver for SQLObject so I may be biased.) Threads are easy an very secure in Python as well, though threads can be hard to get right in regard to data bases.
Ciao
Hi!
On Mon, 06 Feb 2006 18:55:37 +0100 Georg Holzmann grhPD@gmx.at wrote:
Hallo!
This would be great! Is a [sql] object possible that would access any SQL database? That would be even better.
hm - what do you mean by any SQL database? I once made a simple abstraction to access SQL database with pyext and the python SQL Interface... if that would be useful I could search for it ...
Currently [sqlsingle] and my [psql] adaptation can only talk to Postgres databases. I presume Hans is alluding to the ability to connect to other servers such as MySql etc. I think this would be a good thing, but not something I could start immediately.
I was aware of the facility to do this in Python, but since there was already an extern out there I could easily adapt, I decided to opt for that. However, I would be very interested to see your abstraction, in part to compare the performance and functionality, and also to help with my Python, which at the moment is fairly non-existant.
BTW, what does LG stand for?
Jamie
Hallo!
However, I would be very interested to see your abstraction, in part to compare the performance and functionality, and also to help with my Python, which at the moment is fairly non-existant.
okay, I will try to find it again ... ;)
BTW, what does LG stand for?
LG = Liebe Grüße (= german), which means in english something like lovely greetings (BTW: that's also LG ;) - in german you usually write that at the end of a letter or email ...
LG Georg
Georg Holzmann a écrit :
Hallo!
This would be great! Is a [sql] object possible that would access any SQL database? That would be even better.
hm - what do you mean by any SQL database? I once made a simple abstraction to access SQL database with pyext and the python SQL Interface... if that would be useful I could search for it ...
It would be nice to use a database abstraction layer for C. Then, the user would just need to provide the proper DSN to connect to the right manager, and then write his queries in messages. This is an example of a C database abstraction layer I just googled : http://linux.softpedia.com/get/Database/Database-Engines/Database-Independen...
Of course, it would be a whole new object. It is very interesting. :-)
aalex
-
Alexandre Quessy -
David Plans Casal -
Frank Barknecht -
Georg Holzmann -
Hans-Christoph Steiner -
Jamie Bullock