4 ms·
SQLAlchemy really is great. Alembic (the schema migration toolkit) still lacks some functionality compared to e.g. the Django "South" package, especially concer
by ThePhysicist 11y ago
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 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 https://github.com/zzzeek/sqlalchemy/graphs/contributors), which somtimes makes me wonder if he is a real person or just a pseudonym under which a group of talented programmers publish code ;)
- keithy 11y agoHe reminds me of TJ Hollowaychuk, who singlehandedly wrote most of Express.js. Makes me wonder what the node community would be without him.
- hokkos 11y agoTJ is a group, like Nicolas Bourbaki.
- kawera 11y agoI didn't know that, thanks. Could you cite a reference?
- ics 11y agoParent might not have meant it as fact but rather in reference to this: https://medium.com/@kelas/how-is-tj-holowaychuk-so-insanely-productive-604818b4e9eb https://medium.com/@kelas/how-is-tj-holowaychuk-so-insanely-...
- rattray 11y agoI don't believe this to be generally regarded as true.
- dangoor 11y agoEven more amazing, at the time Mike started SQLAlchemy, his day job was working in Java... So SQLAlchemy was a total side project. I don't know if that has changed. Mike is a master.
- foota 11y agoI believe I read that someone hired him to work on SQLAlchemy full time.
- zzzeek 11y agoI work for Red Hat in the Openstack group. I can spend part of my time working on SQLAlchemy upstream as it is a core component of Openstack. But we still take donations!! http://www.sqlalchemy.org/ http://www.sqlalchemy.org/ :) :)
- sametmax 11y agoHi man, Do you plan on adding await/async support to mako ? Cheers
- antod 11y agoYeah you can sense the Java experience, SQLAlchemy is what Hibernate wishes it could be :)
- shazow 11y agoAnother great one is zzzeek's mako templating, by far my favorite templating language: http://docs.makotemplates.org/ http://docs.makotemplates.org/ Anytime I write a web frontend in anything other than Python, I miss it very dearly. But really it's well-suited for any kind of templating work, even code generating—I've seen a few projects use it to generate C code. It's very powerful and doesn't try to dumb itself down because of some dogma about not using logic in templates.