TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

SQLAlchemy 0.9.0 Released

109 点作者 kbambz超过 11 年前

8 条评论

auvrw超过 11 年前
a really solid, perhaps unique, library that, as far as i can tell, completely addresses the &quot;impedence mismatch&quot; argument. if you&#x27;re directly using a database api in a structured way, you&#x27;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&#x27;t. if you&#x27;re already using an orm, refactoring to use sqlalchemy will allow you to to start optimizing the low-level database operations in a coherent way (i.e. not just sprinkling SQL throughout the models). there&#x27;s a nice writeup in the architecture of open source applications ( <a href="http://www.aosabook.org/en/sqlalchemy.html" rel="nofollow">http:&#x2F;&#x2F;www.aosabook.org&#x2F;en&#x2F;sqlalchemy.html</a> )<p>now, fantods aside, is there anything like this for java? according to the aosa writeup, sqlalchemy&#x27;s author found python&#x27;s multiple inheritance useful for implementing certain ideas, so porting probably isn&#x27;t straightforward. also, the relevant stackoverflow question ( <a href="http://stackoverflow.com/questions/10537766/closest-equivalent-to-sqlalchemy-for-java-scala" rel="nofollow">http:&#x2F;&#x2F;stackoverflow.com&#x2F;questions&#x2F;10537766&#x2F;closest-equivale...</a> ) seems inconclusive.<p>this is not to criticize java as a language, but rather because <i>i really wish there was something like sqlalchemy for java</i>.
评论 #6990086 未加载
评论 #6991081 未加载
评论 #6990383 未加载
评论 #6990849 未加载
评论 #6994976 未加载
评论 #6990022 未加载
yeukhon超过 11 年前
&gt; support for Postgresql JSON types,<p>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.<p>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&#x27;t seem to update the repository as often as he should. A lot of outstanding tickets and pull requests. Some are merged but they are never closed. So I always end up bringing up SQLAlchemy myself into Flask because I just don&#x27;t trust the library. Is that how people feel too? For Pyramid, SQLAclemy is the &quot;standard&quot; ORM to use and with ini file it is supposed easy to integrate SA into Pyramid app.
评论 #6990291 未加载
评论 #6991235 未加载
评论 #6993210 未加载
TheSmoke超过 11 年前
sqlalchemy is the best database toolkit for python developers. you can use it as an orm or you can just use its core functionality; write sql expressions in python, define your tables, columns and types. anything you can think of, in terms of dbs, you can do with sqlalchemy.<p>i&#x27;d like to take a moment and thank to @zzeeek [1][2] and all of the contributors.<p>[1] <a href="https://news.ycombinator.com/user?id=zzzeek" rel="nofollow">https:&#x2F;&#x2F;news.ycombinator.com&#x2F;user?id=zzzeek</a><p>[2] <a href="https://twitter.com/zzzeek" rel="nofollow">https:&#x2F;&#x2F;twitter.com&#x2F;zzzeek</a>
megaman821超过 11 年前
Thanks for this release. Learning SQL before ever touching an ORM, SQLAlchemy&#x27;s approach makes a lot more sense to me than something &quot;simplier&quot; like Django&#x27;s ORM.<p>Anyone know, is there any chance Django would pull in SQLAlchemy core as a dependency and implement their ORM on top of it?
评论 #6991233 未加载
评论 #6990615 未加载
评论 #6991043 未加载
jgalt212超过 11 年前
I dunno. I just don&#x27;t get ORMs. I certainly see their use case in easy prototyping, but with the advent of NoSQL, why not just prototype with MongoDB, or similar, and if it turns out your data is close to uniform in structure, just switch over to MySQL, or similar.<p>To keep my code portable, I stick to standard SQL and don&#x27;t use any stored procedures. I&#x27;m sure this is probably not a tenable strategy for web-scale apps, but with 100s&#x2F;1000s of users and only millions of records, it seems to work just fine.<p>This comment is no way meant to disparage SQLAlchemy which by all accounts seems to be a first rate work of engineering. I am speaking of ORMs in general, and why should we use them.
评论 #6993908 未加载
chrismorgan超过 11 年前
Why 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 &quot;1.0&quot;?
评论 #6990719 未加载
评论 #6990588 未加载
评论 #6989931 未加载
评论 #6990115 未加载
reinhardt1053超过 11 年前
I&#x27;d love to have something as good as sqlalchemy in go
评论 #6990776 未加载
评论 #6990298 未加载
Demiurge超过 11 年前
how does SQLAlchemy support for PostGIS compare to GeoDjango ORM?
评论 #6990578 未加载