how does SQLAlchemy support for PostGIS compare to GeoDjango ORM?
SQLAlchemy 0.9.0 Released
11–20 of 43 posts
Re: SQLAlchemy 0.9.0 Released
#12> support for Postgresql JSON types, This. Finally :) I know I was searching this a few months ago and there was a long due ticket for this to be added. Thank you whoever did this patch. A side note. I personally use Pyramid (I use Pyramid more, however) and Flask. For Flask project I never use flask-sqlalchemy because mitsuhiko doesn't seem to update the repository as often as he should. A lot of outstanding tickets…
Currently on a big project using flask + sqlalchemy and didn't want to use flask-sqlalchemy as well. At first, it was because it didn't seem like i needed to, then it was for a better understanding of the sqlalchemy session / flask request lifecycle coordination. That knowledge proved to be very useful once i needed to reuse my stack in a celery task.
Re: SQLAlchemy 0.9.0 Released
#13I'd love to have something as good as sqlalchemy in go
That would probably make me switch from python to go. Not just because of the lib itself, but because it would help me gain confidence in the modeling and abstraction power of Go.
Re: SQLAlchemy 0.9.0 Released
#14Thanks for this release. Learning SQL before ever touching an ORM, SQLAlchemy's approach makes a lot more sense to me than something "simplier" like Django's ORM.
Anyone know, is there any chance Django would pull in SQLAlchemy core as a dependency and implement their ORM on top of it?
Re: SQLAlchemy 0.9.0 Released
#15a really solid, perhaps unique, library that, as far as i can tell, completely addresses the "impedence mismatch" argument. if you're directly using a database api in a structured way, you've probably already reimplemented the sqlalchemy core, and refactoring your program to use sqlalchemy will give you an orm, should you want one, and make your code portable across database implementations even if you don't. if you'…
I find Jooq to be similiar in some ways.
Re: SQLAlchemy 0.9.0 Released
#16how does SQLAlchemy support for PostGIS compare to GeoDjango ORM?
Looks like it's pretty robust: http://www.geoalchemy.org/tutorial.html
Re: SQLAlchemy 0.9.0 Released
#17Why is SQLAlchemy still under 1.0? Are there good reasons, or is it just the apparently typical (and typically irrational) fear of the version number "1.0"?
If I had to venture to guess, the project most likely started with 0.x notation because the first few releases didn't have major planned features such as the declarative ORM. After that there were never any truly backwards incompatible versions to merit a full number increment.
Really, it's a credit to just how much Mike got right on the first go.
Re: SQLAlchemy 0.9.0 Released
#18Thanks for this release. Learning SQL before ever touching an ORM, SQLAlchemy's approach makes a lot more sense to me than something "simplier" like Django's ORM. Anyone know, is there any chance Django would pull in SQLAlchemy core as a dependency and implement their ORM on top of it?
The ORM is mediocre compared to SQLAlchemy, the template system is weak compared to Jinja2.
If you swap Django's ORM with SQLAlchemy and replace Django Templates with Jinja2, you end up with something like Flask.
The killer feature for me is Django's "admin" app. When I'm not using the "admin", the rest of Django kind of gets in the way. Nowadays I prefer a less opinionated framework like Flask if I'm not using the "admin".
Also, Django lacks any concept of multi-tenancy and does not support composite primary keys nor schemas, which makes it a poor choice for SaaS projects. That said, Django REST Framework is awesome for API-first development and makes it a whole different game (in a positive way).
Re: SQLAlchemy 0.9.0 Released
#19Why is SQLAlchemy still under 1.0? Are there good reasons, or is it just the apparently typical (and typically irrational) fear of the version number "1.0"?
originally i was going to skip from 0.8 just to 1.0, but then a lot more new features and behaviors came into 0.9, so i figured lets just do the one more non-1.0 number. There's not going to be an "0.10", it'll be 1.0.
Re: SQLAlchemy 0.9.0 Released
#20I'd love to have something as good as sqlalchemy in go
I looked at Go a little bit as maybe a place to write a kind of "uber-Core" system, e.g. a high performance database abstraction layer that could power libs in other languages. But apparently Go is not at all designed to be embedded in other runtimes, it isn't even possible. Also it seems to lack a standard database API and the connectors that were there seemed a little all over the place.