Thread: [SQLObject] exploring SQLObject as a bridge
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Donnal W. <don...@ya...> - 2003-04-25 17:10:17
|
The custom (clinical) application development framework on which I have been working consists of abstraction and presentation layers. The abstraction layer produces a directed, labeled, object graph in which the nodes support links to the presentation layer in what may be called a model-view-presenter (MVP) architecture. ("Presenters" are thick wrappers around wxPython "Views" attached to "Models" in the abstraction layer.) Until recently I had not intended to support relational database persistence for the abstraction layer, but others have convinced me that this would be a worthwhile feature to consider. Therefore, I am interested in exploring SQLObject as a possible bridge between the abstraction layer and relational databases. I am sure I will have other question of a more theoretical nature, but my first question is merely to ask for recommendations for a database backend. Since I am only exploring for now, I would am interested in the easiest to install on my local machine. I had planned on using Gadfly, for example, but I don't see it on the list of databases supported by SQLObject. SQLite seems attractive, but if I understand the instructions correctly, I would have to compile it myself, and I don't have a C compiler. (Or is there a Windows binary available?) What RDBMS would you recommend? Thanks, Donnal Walter, MD Arkansas Children's Hospital http://mindwrapper.org |
From: David M. C. <da...@da...> - 2003-04-25 17:56:27
|
On Fri, Apr 25, 2003 at 10:10:12AM -0700, Donnal Walter wrote: > I am sure I will have other question of a more theoretical nature, > but my first question is merely to ask for recommendations for a > database backend. Since I am only exploring for now, I would am > interested in the easiest to install on my local machine. I had > planned on using Gadfly, for example, but I don't see it on the > list of databases supported by SQLObject. SQLite seems attractive, > but if I understand the instructions correctly, I would have to > compile it myself, and I don't have a C compiler. (Or is there a > Windows binary available?) What RDBMS would you recommend? Both sqlite and pysqlite have win32 binaries. You may want to download something like dev-c++ (which comes with mingw) or cygwin in any case. http://www.bloodshed.net/dev/devcpp.html http://cygwin.com Dave Cook |
From: Frank B. <fb...@fo...> - 2003-04-25 20:35:59
|
Hallo, Donnal Walter hat gesagt: // Donnal Walter wrote: > I am sure I will have other question of a more theoretical nature, > but my first question is merely to ask for recommendations for a > database backend. Since I am only exploring for now, I would am > interested in the easiest to install on my local machine. I had > planned on using Gadfly, for example, but I don't see it on the > list of databases supported by SQLObject. It is not currently supported, but writing support for a RDBMS in SQLite has shown to be very easy. Even I as a python beginner could do it with the initial sqlite support. But is Gadfly still in active development? I guess, SQLite will be faster anyway. > SQLite seems attractive, but if I understand the instructions > correctly, I would have to compile it myself, and I don't have a C > compiler. (Or is there a Windows binary available?) What RDBMS would > you recommend? SQLite is really cool for small or standalone applications, where you don't want to or cannot run a 'real' database server. It might be a bit more difficult to get it working in a threaded environment, but a couple of locks should make it possible as well. For bigger things I would use a db-server, though. MySQL and PostgreSQL both are good. ciao -- Frank Barknecht _ ______footils.org__ |
From: Brad B. <br...@bb...> - 2003-04-26 01:04:48
|
On 04/25/03 10:10, Donnal Walter wrote: > I am sure I will have other question of a more theoretical nature, > but my first question is merely to ask for recommendations for a > database backend. Since I am only exploring for now, I would am > interested in the easiest to install on my local machine. I had > planned on using Gadfly, for example, but I don't see it on the > list of databases supported by SQLObject. SQLite seems attractive, > but if I understand the instructions correctly, I would have to > compile it myself, and I don't have a C compiler. (Or is there a > Windows binary available?) What RDBMS would you recommend? Well, since you're asking for opinions, I'll offer mine: PostgreSQL. PostgreSQL is transactional, fast (enough), easy to use, featureful, and exceedingly well documented. I've recently used SQLObject and PostgreSQL to build an invoicing system, and am currently involved in a project using these same tools to build a unified credit card payment interface for multiple, pluggable, online merchant backends. PostgreSQL has a Windows binary available here: ftp://ftp3.ca.postgresql.org/pub/binary/v7.3.1/Windows/ That's the latest compiled version I found, anyway. I don't use Windows, but the PostgreSQL team is a highly-dedicated bunch and I see no reason to think the quality would suffer in a non-Linux/Unix environment. Hope that helps. -- Brad Bollenbach BBnet.ca |
From: Ian B. <ia...@co...> - 2003-04-29 09:14:22
|
On Fri, 2003-04-25 at 12:10, Donnal Walter wrote: > I am sure I will have other question of a more theoretical nature, > but my first question is merely to ask for recommendations for a > database backend. Since I am only exploring for now, I would am > interested in the easiest to install on my local machine. I had > planned on using Gadfly, for example, but I don't see it on the > list of databases supported by SQLObject. SQLite seems attractive, > but if I understand the instructions correctly, I would have to > compile it myself, and I don't have a C compiler. (Or is there a > Windows binary available?) What RDBMS would you recommend? I'd recommend SQLite -- I've only been using it very recently, but it seems quite nice, and seems like it fits your environment. If you really want minimal dependencies, DBMConnection will do that for you -- all the dependencies are included in the standard library. Ian |