text_combined: oleg broytmann otdphdppru hello im pleased announce version 0100 first stable release 010 branch sqlobject sqlobject sqlobject objectrelational mapper database tables described classes rows instances classes sqlobject meant easy use quick get started sqlobject supports number backends mysql postgresql sqlite firebird also newly added support sybase mssql maxdb also known sapdb sqlobject site httpsqlobjectorg development httpsqlobjectorgdevel mailing list httpslistssourceforgenetmailmanlistinfosqlobjectdiscuss archives httpnewsgmaneorggmanecomppythonsqlobject download httpcheeseshoppythonorgpypisqlobject0100 news changes httpsqlobjectorgnewshtml whats new news since 09 features interface dropped support python 22 minimal version python sqlobject 23 removed actively deprecated attributes lowered deprecation level attributes removed 010 sqlbuilder select supports rest selectresults options reversed distinct joins etc sqlobjectselect ie selectresults dbconnectionqueryforselect use sqlbuilder select queries make selects implemented internally via single mechanism sqlbuilder joins handle sqlexpression tables strsqlobjectalias properly sqlrepr added sqlbuilder importproxy allows one ignore circular import issues referring sqlobject classes files uses classregistry string class names fkjoins specifically intended sqlbuilder expressions see teststest_sqlbuilder_importproxypy added selectresultsthroughto allows one traverse relationships fkjoin via sql avoiding intermediate objects additionally simple mechanism precachingeagerloading later fk relationships ie going loop select somepeople ask apersongroup first call listsomepeoplethroughtogroup preload related groups use 2 db queries instead n1 see teststest_select_throughpy added viewsqlobject added sqlmetagetcolumns get columns class including parent classes excluding column childname including column id sqlmetaasdict uses getcolumns need override inheritable sqlmeta class makes asdict work properly inheritable sqlobjects allow mytableselectmytableqforeignkey object object instance sqlobject added rich comparison methods sqlobjects class considered equal id methods return notimplemented rowdestroysignal sent destroying sqlobject instance postfunctions run row destroyed changed implementation type boolcol sqlite tinyint boolean made fromdatabase machinery recognize mysqlconnection db uri accept number sslrelated parameters ssl_key ssl_cert ssl_ca ssl_capath use sets instead dicts tablesused dropped tablesuseddict function instead tablesusedset returns set strings sqlbuilder tablesusedset handles sqlreprable objects mysql picklecol longer uses text column types smallest column blob possible create tinyblob column complete list please see news httpsqlobjectorgnewshtml oleg oleg broytmann httpphdppru otdphdppru programmers dont die gosub without return httpmailpythonorgmailmanlistinfopythonannouncelist support python software foundation httpwwwpythonorgpsfdonationshtml tue 05 aug 2008 152321 0300 sqlobject 0100