Re: [Modeling-users] Stability of Modeling

[Sebastien B. <sbi...@us...>]

Edmund Lian <el...@in...> wrote:
> Hello,
>=20
> I'm new to Modeling and this list.

       Hi & welcome here ;)

> I've been looking around for a decent Python ORM for a long time, and
> it looks like Modeling just popped out of nowhere earlier this year,
> very fully featured at version 0.8. Where did it come from?

The framework's first public release was at the end of July 2002. As
stated in the historical preamble in the User's Guide=20
(http://modeling.sourceforge.net/UserGuide/intro-history.html)=20
that you maybe have already read, the project started because I missed
Apple's EOF and couldn't stand for having to write SQL by hand and embed
sql statements within OO-code. Weird but true, at that time I searched
but didn't find any of the existing python ORM.

  A great part of it was developped on my spare time --however, my
  former company did support the effort and quickly used it in its
  projects.  Admittedly most of the testing, including pre-alpha and
  alpha stages, was made by the company's developpers while working on
  clients' projects.

> Is Modeling stable and useful for production?=20

  To my knowledge it has already been put in production for 6/7 months
  in two major applications --short description: a zope-based web
  app. (multi-threaded) dedicated to the supervision of doctors in duty
  for the french emergency services, and a python-gtk-based
  app. (single-threaded) for bookshops' stock and sales management.
  Both are using the postgresql DB (psycopg adaptor), the former's DB
  size is ~1.5Mo, 10 tables, the latter: ~200Mo, 52 tables.

    [size: size of the file generated by pg_dump/format:plain-text SQL
           script file]

  Other users on this list might comment on this with their own
  experience and deployed projects, if any.

> Does it scale well, etc.

  Could you be more specific about which kind of informations you'd like
  to get?

> Would anybody care to tell me how Modeling fits in amongst all the
> other Python ORMs? As far as I can see, Modeling stands alone in its
> sophistication, ability to handle joins, etc., but I've not used it,
> hence the desire for some comments...
=20=20
There is quite a bunch of existing python orms, true
 cf. http://www.python.org/cgi-bin/moinmoin/HigherLevelDatabaseProgramming

 Unfortunately, I do not know them well. We once discussed some of the
 differences between mdl and middlekit, see
https://sourceforge.net/mailarchive/forum.php?thread_id=3D1569043&forum_id=
=3D10674

  AFAIK, transparent support for inheritance is not available in other
orms. Another probably unique feature is that transactions are also
available at the object level, see
http://modeling.sourceforge.net/UserGuide/nested-editing-context.html

  Keep in mind that this is no "authoritative" answer since I never
  really used other orms, I just read their docs. Feel free to ask for
  more, we'll be happy to answer to the best of our knowledge.

        Regards,

-- S=E9bastien.