[sqlalchemy] Re: SQLAlchemy 0.4 beta2 released

2007-08-31 Thread sdobrev
long time ago i was talking with a friend on similar problem, back then about Grafix drivers, where u could have many levels of enhancement (sub)drivers and functionalitites done on any level, including in hardware (or none at all). There was some rule like "if u have it at lower level, use th

[sqlalchemy] Re: SQLAlchemy 0.4 beta2 released

2007-08-15 Thread sdobrev
On Thursday 16 August 2007 00:33:57 [EMAIL PROTECTED] wrote: > > Reflection should be configurable whether to stop at dialect > > level (SLint) or go back to abstract types (types.Int) - see my > > autoload.py. > > why would one want to stop the reflection from going back to > abstract types? > i.

[sqlalchemy] Re: SQLAlchemy 0.4 beta2 released

2007-08-15 Thread sdobrev
> Reflection should be configurable whether to stop at dialect > level (SLint) or go back to abstract types (types.Int) - see my > autoload.py. why would one want to stop the reflection from going back to abstract types? i.e. if the current reflection (dialevt-level) is made to autoguess the ab

[sqlalchemy] Re: SQLAlchemy 0.4 beta2 released

2007-08-15 Thread sdobrev
On Wednesday 15 August 2007 20:54:27 Michael Bayer wrote: > I had in mind that the metaclass approach would be used, but not > necesarily with the "walking" stuff going on. the walking is a quick and dirty and very simple way to get away with it - for now. > if you really want to think about thi

[sqlalchemy] Re: SQLAlchemy 0.4 beta2 released

2007-08-15 Thread sdobrev
On Wednesday 15 August 2007 19:51:30 Michael Bayer wrote: > On Aug 15, 2007, at 10:52 AM, [EMAIL PROTECTED] wrote: > > Second, i went to r3312, let init_attr() set a _state as plain > > dict and removed _state as property. The difference > > plain-dict/property (in favor of plain dict) is like 2-3

[sqlalchemy] Re: SQLAlchemy 0.4 beta2 released

2007-08-15 Thread Michael Bayer
I had in mind that the metaclass approach would be used, but not necesarily with the "walking" stuff going on. if you really want to think about this, the idea for a types overhaul is ticket #526. that breaks up the "DDL" from the "adaptation" side of things. a metaclass approach would be

[sqlalchemy] Re: SQLAlchemy 0.4 beta2 released

2007-08-15 Thread Michael Bayer
On Aug 15, 2007, at 10:52 AM, [EMAIL PROTECTED] wrote: > Second, i went to r3312, let init_attr() set a _state as plain dict > and removed _state as property. The difference plain-dict/property > (in favor of plain dict) is like 2-3%. > > property: > loaded 10 items each with 500 subitems > 5

[sqlalchemy] Re: SQLAlchemy 0.4 beta2 released

2007-08-15 Thread sdobrev
On Tuesday 14 August 2007 23:05:44 Michael Bayer wrote: > On Aug 14, 2007, at 3:30 PM, [EMAIL PROTECTED] wrote: > > databases/sqlite: (reflecttable) > > pragma_names is missing the BOOLEAN word/type -> nulltype > > > > btw why isn't each dialect-typeclass adding it's own entry to > > that pragma

[sqlalchemy] Re: SQLAlchemy 0.4 beta2 released

2007-08-15 Thread sdobrev
On Wednesday 15 August 2007 04:26:31 Michael Bayer wrote: > On Aug 14, 2007, at 4:35 PM, Michael Bayer wrote: > > On Aug 14, 2007, at 12:38 PM, svilen wrote: > >> --- > >> orm.attribute > >> AttributeManager.init_attr(): > >> the saving this one eventualy does is too small, compared to >

[sqlalchemy] Re: SQLAlchemy 0.4 beta2 released

2007-08-14 Thread Michael Bayer
On Aug 14, 2007, at 4:35 PM, Michael Bayer wrote: > On Aug 14, 2007, at 12:38 PM, svilen wrote: >> >> >> --- >> orm.attribute >> AttributeManager.init_attr(): >> the saving this one eventualy does is too small, compared to a >> property call of ._state. > > i havent benched this in a w

[sqlalchemy] Re: SQLAlchemy 0.4 beta2 released

2007-08-14 Thread Jonathan Ellis
On 8/14/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > im not sure try/except is faster here - im pretty sure a missing > > key is likely and exception throws are very expensive. would be > > worth a try to see if the missing key exception actually occurs > > here. > i'll have to check, las

[sqlalchemy] Re: SQLAlchemy 0.4 beta2 released

2007-08-14 Thread sdobrev
> > orm.util.AliasedClauses._create_row_adapter() > > class AliasedRowAdapter( object): > > 1. can't this be made as standalone class, returning an > > instance, initialized with the map, which is then __call__()ed ? > > is it faster to say "self.map" or to say "map" from locals() ? its > pr

[sqlalchemy] Re: SQLAlchemy 0.4 beta2 released

2007-08-14 Thread Michael Bayer
On Aug 14, 2007, at 2:12 PM, Brian Beck wrote: > > 0.4 looks awesome. Some names jump out at me though: > * sessionmaker - Strange that it's a noun, and not a verb (like > make_session) the verb would be, "make_session_maker". or "make_session_class", except in some cases it might not be an

[sqlalchemy] Re: SQLAlchemy 0.4 beta2 released

2007-08-14 Thread Michael Bayer
On Aug 14, 2007, at 12:38 PM, svilen wrote: > > > performance-wise - do u have any test/target for profiling? else i can > repeat some tests i did somewhen in february (if i remember them..) look in test/perf for some, just added a "mass-insert/mass-select" test. also the current branch im doi

[sqlalchemy] Re: SQLAlchemy 0.4 beta2 released

2007-08-14 Thread Michael Bayer
On Aug 14, 2007, at 3:30 PM, [EMAIL PROTECTED] wrote: > > databases/sqlite: (reflecttable) > pragma_names is missing the BOOLEAN word/type -> nulltype > > btw why isn't each dialect-typeclass adding it's own entry to that > pragma_names, respectively to the colspecs ? > Or, each class to have

[sqlalchemy] Re: SQLAlchemy 0.4 beta2 released

2007-08-14 Thread sdobrev
databases/sqlite: (reflecttable) pragma_names is missing the BOOLEAN word/type -> nulltype btw why isn't each dialect-typeclass adding it's own entry to that pragma_names, respectively to the colspecs ? Or, each class to have those pragmaword and basetype, and the dicts to be made by walking

[sqlalchemy] Re: SQLAlchemy 0.4 beta2 released

2007-08-14 Thread Brian Beck
On Aug 14, 11:29 am, Michael Bayer <[EMAIL PROTECTED]> wrote: > I just put beta2 up. The important things in this release are major > MS-SQL and Oracle fixes, after we got some on-the-ground testing done. > > Theres also a new function we're planning to use in Pylons called > "engine_from_config(

[sqlalchemy] Re: SQLAlchemy 0.4 beta2 released

2007-08-14 Thread svilen
performance-wise - do u have any test/target for profiling? else i can repeat some tests i did somewhen in february (if i remember them..) = while looking to replace all {} with dict/Dict(), i found some things. Here the list, quite random, probably some can be just ignored if not an