SQLObject 0.10.0b1

Discussion in 'Python' started by Oleg Broytmann, Jan 11, 2008.

  1. Hello!

    I'm pleased to announce the 0.10.0b1, the first beta release of a new
    SQLObject branch, 0.10.


    What is SQLObject
    =================

    SQLObject is an object-relational mapper. Your database tables are described
    as classes, and rows are instances of those classes. SQLObject is meant to be
    easy to use and quick to get started with.

    SQLObject supports a number of backends: MySQL, PostgreSQL, SQLite, and
    Firebird. It also has newly added support for Sybase, MSSQL and MaxDB (also
    known as SAPDB).


    Where is SQLObject
    ==================

    Site:
    http://sqlobject.org

    Development:
    http://sqlobject.org/devel/

    Mailing list:
    https://lists.sourceforge.net/mailman/listinfo/sqlobject-discuss

    Archives:
    http://news.gmane.org/gmane.comp.python.sqlobject

    Download:
    http://cheeseshop.python.org/pypi/SQLObject/0.10.0b1

    News and changes:
    http://sqlobject.org/News.html


    What's New
    ==========

    Features & Interface
    --------------------

    * Dropped support for Python 2.2. The minimal version of Python for
    SQLObject is 2.3 now.

    * Removed actively deprecated attributes;
    lowered deprecation level for other attributes to be removed after 0.10.

    * SQLBuilder Select supports the rest of SelectResults options (reversed,
    distinct, joins, etc.)

    * SQLObject.select() (i.e., SelectResults) and DBConnection.queryForSelect()
    use SQLBuilder Select queries; this make all SELECTs implemented
    internally via a single mechanism.

    * SQLBuilder Joins handle SQLExpression tables (not just str/SQLObject/Alias)
    and properly sqlrepr.

    * SQLBuilder tablesUsedDict handles sqlrepr'able objects.

    * Added SQLBuilder ImportProxy. It allows one to ignore the circular import
    issues with referring to SQLObject classes in other files - it uses the
    classregistry as the string class names for FK/Joins do, but specifically
    intended for SQLBuilder expressions. See
    tests/test_sqlbuilder_importproxy.py.

    * Added SelectResults.throughTo. It allows one to traverse relationships
    (FK/Join) via SQL, avoiding the intermediate objects. Additionally, it's
    a simple mechanism for pre-caching/eager-loading of later FK
    relationships (i.e., going to loop over a select of somePeople and ask
    for aPerson.group, first call list(somePeople.throughTo.group) to preload
    those related groups and use 2 db queries instead of N+1). See
    tests/test_select_through.py.

    * Added ViewSQLObject.

    * Added sqlmeta.getColumns() to get all the columns for a class (including
    parent classes), excluding the column 'childName' and including the column
    'id'. sqlmeta.asDict() now uses getColumns(), so there is no need to
    override it in the inheritable sqlmeta class; this makes asDict() to work
    properly on inheritable sqlobjects.

    * Changed the implementation type in BoolCol under SQLite from TINYINT to
    BOOLEAN and made fromDatabase machinery to recognize it.

    * Added rich comparison methods; SQLObjects of the same class are
    considered equal is they have the same id; other methods return
    NotImplemented.

    * MySQLConnection (and DB URI) accept a number of SSL-related parameters:
    ssl_key, ssl_cert, ssl_ca, ssl_capath.

    For a more complete list, please see the news:
    http://sqlobject.org/News.html

    Oleg.
    --
    Oleg Broytmann http://phd.pp.ru/
    Programmers don't die, they just GOSUB without RETURN.
    Oleg Broytmann, Jan 11, 2008
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Bastian Gorke

    running eXist 1.0b1 under windows

    Bastian Gorke, Jan 9, 2004, in forum: XML
    Replies:
    1
    Views:
    375
    Unregistered
    Jan 19, 2004
  2. Jacob Smullyan

    [ANN] PyDO-2.0b1 Released

    Jacob Smullyan, Jul 26, 2005, in forum: Python
    Replies:
    0
    Views:
    280
    Jacob Smullyan
    Jul 26, 2005
  3. Oleg Broytmann

    SQLObject 0.8.0b1

    Oleg Broytmann, Dec 18, 2006, in forum: Python
    Replies:
    0
    Views:
    279
    Oleg Broytmann
    Dec 18, 2006
  4. Daniel Nogradi

    sqlobject 0.8.0b1 and python 2.5

    Daniel Nogradi, Jan 13, 2007, in forum: Python
    Replies:
    3
    Views:
    276
    Daniel Nogradi
    Jan 13, 2007
  5. Oleg Broytmann

    SQLObject 0.9.0b1

    Oleg Broytmann, Apr 11, 2007, in forum: Python
    Replies:
    0
    Views:
    280
    Oleg Broytmann
    Apr 11, 2007
Loading...

Share This Page