You could use the sql builder component of sql alchemy and skip the orm part. The web.db part of web.py might work as well.
On 3/3/10, Dhananjay Nene <dhananjay.n...@gmail.com> wrote: > Hi, > > On Wed, Mar 3, 2010 at 6:51 PM, steve <st...@lonetwin.net> wrote: > >> Hi, >> >> On 03/03/2010 04:36 PM, Dhananjay Nene wrote: >> >>> Looking for a simple opensource python database library >>> >>> Objectives : >>> - Should work at a level of abstraction above DB-Api. I should not have >>> to >>> change code generally except for changing database configuration >>> parameters. >>> - Should be able to write code independent of the database (except where >>> the >>> SQL itself was to be different in which case thats beyond the library's >>> control) >>> - Should support most reasonably popular databases (I am looking >>> primarily >>> for MySQL but at least Postgres, SQL Server and Oracle support will be >>> useful) >>> >> >> All of that is available in popular ORMs. I prefer SQLObject to >> SQLAlchemy. >> Could you elaborate a bit on why an ORM would not be suitable ? > > > I need to build some simple relational database access over 2-3 tables in a > utility program. While it is quite solvable through ORM, the fairly limited > scope and nature of database access does not require the capabilities of a > full blown ORM. I use SQLAlchemy in my day job and I like it. Its just that > I wouldn't want to introduce a dependency on a much bigger toolset > especially when a smaller one could suffice. > > >> >> - Abstractions should be at a relational level. Thus any ORMs are out of >>> scope. >>> >>> ehe .. ORM == Object /Relational/ Mapper. What do you mean by >> "Abstractions should be at a relational level" ? > > > I meant the API should reflect cursors, sqlcommands etc (not objects, > relationships, inheritance etc.). Having said that I realise "at a > relational level" was not the most appropriate wording. > > >> >> I have found ADODb for Python so far. Looking for additional >>> recommendations. >>> >>> anydbm ? ( http://docs.python.org/library/anydbm.html ), of course that >> though is not relational. >> > > Thanks for the tip. It got me thinking whether I could just choose to use it > instead. Thats still a thought under progress. > > >> >> A quick google OTOH gives me this: >> >> http://wiki.python.org/moin/DbApiModuleComparison > > > >> >> >> Also, the little that i read online, I see that at least in theory all >> python DBI should follow: http://www.python.org/dev/peps/pep-0249/ >> >> ...which if is also true in practice takes care of concerns you might have >> about cross DB API. >> > > Thats not how I have seen it work. For example mysql prepared sql uses "%s" > whereas others use "?". The database connection parameters are actually > different between different databases. SQLAlchemy works with and deals with > these issues. For example it has separate derived classes per database to > handle some of these variations. Also it uses a connection URI to skip over > the differences in the connection parameter differences. (The URI is always > a string - even if the string itself is composed quite differently .. thus > the code which uses the URI doesn't have to change even when the connection > parameters change). So essentially what I am looking for (being the lazy > person I am) is if someone has done this hard work of abstracting away the > database dbapi implementation differences :) > >> >> cheers, >> - steve >> >> -- >> random non tech spiel: http://lonetwin.blogspot.com/ >> tech randomness: http://lonehacks.blogspot.com/ >> what i'm stumbling into: http://lonetwin.stumbleupon.com/ >> > > Thanks > Dhananjay > > -- > -------------------------------------------------------- > blog: http://blog.dhananjaynene.com > twitter: http://twitter.com/dnene http://twitter.com/_pythonic > _______________________________________________ > BangPypers mailing list > BangPypers@python.org > http://mail.python.org/mailman/listinfo/bangpypers > -- Sent from my mobile device ~noufal http://nibrahim.net.in _______________________________________________ BangPypers mailing list BangPypers@python.org http://mail.python.org/mailman/listinfo/bangpypers
