hi Thadeus, On 30-10-2010 19:42, Thadeus Burgess wrote: > Just my 2 cents. > > Using the DAL on anything but web2py is going to be a pain in the ass and a > nightmare waiting to > happen. This is due to its inherent forced procedural coding style. You "can" > wrap DAL calls as > methods, but it just gets really messy. I'm a clean code zealot, so I bet I > care more than most. I guess I'm the opposite, I'm not a programmer ( although I write code), but I like the write with as few words as possible (and to learn and to know as little as possible), to create the functionality I need ;-) > > For any kind of software your developing that uses object oriented > programming, use a database > system that is structured around classes and declarative bases. so what would be a good suggestion ? > You will find this is much much much easier to integrate into, for example a > wxWidgets program, > than the DAL is. The reason to see if the DAL could be used for desktop applications: I've a number of applications, that uses SQLite / Access / Sybase databases. I want to make these applications independent of their underlying databases, and want to possibility to move to SQL-Server / MySQL or PostGres. My feeling tells me that about 80 to 90 % of the used SQL queries can be handled by an abstraction layer like DAL.
I've looked at other abstraction layers in the past, but found the learning step to high. In fact I find the learning step for the Web2Py also too high ;-) but as I've chozen Web2Py for web design, I'll have to learn it anyway. cheers, Stef > > -- > Thadeus >
