sqlalchemy

it might be theoretical in hibernate, but sqlalchemy does a TON of this stuff as an example: https://github.com/zzzeek/sqlalchemy/blob/master/lib/sqlalch... heaps of this kind of thing are nicely dotted around the code so you don’t have to deal with weird driver quirks, maps “Text” column type to whatever it needs to be in your given database to have an unbounded text blob id say that’s far more than theoretical EDIT: typo EDIT 2: also, on DB specific features, SQLA supports a bunch (not all). eg: https://github.com/zzzeek/sqlalchemy/blob/master/lib/sqlalch...

I'm talking here about a developer API that is extremely flexible and extensible. Even one-liner contributions can have bad effects, and virtually all contributions I receive "work" at a superficial level and if they provide tests the tests usually pass. "made it through testing" is a low bar, the bigger implications of a patch need to be considered. Examples of PRs that "work" exactly as intended yet are the wrong way to solve the problem: https://github.com/zzzeek/sqlalchemy/pull/381 https://github.com/zzzeek/sqlalchemy/pull/382 Here's a large PR: https://github.com/zzzeek/sqlalchemy/pull/365 that after lots and lots of back and forth I finally merged with lots of edits from me at: https://github.com/zzzeek/sqlalchemy/commit/7d3da6f850dca54b... ...aannnnndddd - after all that work and testing, it was wrong! Fortunately someone caugh

SQLAlchemy: https://github.com/zzzeek/sqlalchemy http://docs.sqlalchemy.org/en/latest/ https://www.youtube.com/watch?v=vunIDi9Z-_8 (Introduction to SQLAlchemy, 2014, 2:52:50) http://www.aosabook.org/en/sqlalchemy.html (Overview in The Architecture of Open Source Applications)

Inheritance is helpful when the domain is well-defined and the underlying problem is broadly similar enough to fill-in differences across what's being abstracted. Some hand-picked examples of well-implemented inheritance in open source: An example of where inheritance makes great sense is Django CBV (Class-based views), https://docs.djangoproject.com/en/1.11/topics/class-based-vi..., as well as Django REST Framework class views (http://www.django-rest-framework.org/api-guide/views/) An example of where inheritance in the form of runtime metaprogramming makes sense is SQLAlchemy declarative and Django ORM. An example where inheritance in the form of mixins make sense would be Django ORM, such as TimeStampedModel in django-extensions https://github.com/django-extensions/django-extensions/blob/.... An example where classes make sense in stan

Django does have some really clean code and it is very easy to navigate. I feel like I only grokked Django after I started going through its internals. I also highly recommend giving Tornado[0] and Bottle[1] a read. Outside of the the web stuff, Sqlalchemy[2] is good [0] - https://github.com/tornadoweb/tornado [1] - https://github.com/bottlepy/bottle [2] - https://github.com/zzzeek/sqlalchemy

SQLAlchemy[1] is a large project with a very solid codebase; it is very well documented and the API is exemplary. 1: https://github.com/zzzeek/sqlalchemy/

SQLAlchemy really is great. Alembic (the schema migration toolkit) still lacks some functionality compared to e.g. the Django "South" package, especially concerning the handling of cyclic dependencies (where it just "bails out") and some things that are still not correctly implemented for various database backends (such as Enum fields), but apart from that it's a really really great tool. Recently I have used it to implement MongoDB query sntax on SQL which was not only possible using SQLAlchemy but even enjoyable (for those who are interested in running Mongo queries on SQL: https://github.com/adewes/blitzdb -> see feature/sql_backend branch, which is still not 100 % stable though). What makes it especially amazing is that Mike Bayer has written 90 % of the code base by himself (https://github.com/zzzeek/sqlalchemy/graphs/contributors),

SQLAlchemy - https://github.com/zzzeek/sqlalchemy - http://www.aosabook.org/en/sqlalchemy.html - http://docs.sqlalchemy.org/en/rel_1_0/

SQLAlchemy is one of my favourite larger python codebases: https://github.com/zzzeek/sqlalchemy

SQLAlchemy - https://github.com/zzzeek/sqlalchemy - http://www.aosabook.org/en/sqlalchemy.html - http://docs.sqlalchemy.org/en/rel_1_0/

Python => SQLAlchemy Very clean, feature-rich yet pragmatic and well documented. https://github.com/zzzeek/sqlalchemy