One other suggestion: in the info displayed after answering a question, a link to the Postgres documentation for the relevant query would be nice.
This is no doubt a game changer in the way you organize (modularise for reuse) your views, functions and stored procedures.
In the MS SQL world it's CROSS APPLY.
And modern SQL at all - http://use-the-index-luke.com/blog/2015-02/modern-sql
They are complete, comprehensive, and well worth your time.
I greatly enjoyed watching the talk. You make it obvious what to take away from the talk and your explanations are easy to follow along with. In the first part of the talk, you really took advantage of Python's dynamicity to describe something very static. I hope that's something that will stay in my mind and change how I write code in the future.
"The Python SQL Toolkit and Object Relational Mapper
SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL."
So I would say it is in fact an ORM even if it is also a toolkit.
The Expression Language on which the ORM is built on is more powerful than the ORM itself. You can do asynchronous IO with the Expression Language or generate SQL with it that you couldn't with the ORM.
This distinction matters. You can't just point to somewhere in the SQLAlchemy docs and say argue that because SQLAlchemy allows you do to X, there exists an ORM that can do X. Calling SQLAlchemy an ORM is a simplification that may be fine in some contexts but it ultimately isn't true.
That being said it was also one of the hardest libraries for me to learn. The docs are okay but it seemed like I found more features in peoples github repos that were not documented on the Slick website.
Also, thanks for linking the one in this thread. The interface looks clean (on my laptop at least).
More details on the implementation here: https://brianbondy.com/blog/168/sql-on-khan-academy-enabled-...
I hope to improve things myself someday. Unfortunately I'm mid-emigration currently - so it will probably be a while.
That's what I needed, as well. :) Randomly found it and decided to share.
OOT, at first glance, the design of website looks like Ubuntu documentation page.
Edit: the downvote anchor is completely missing in random fashion. Didn't notice the problem in other topics.
It's better to send questions like this to email@example.com, though, as the site guidelines (https://news.ycombinator.com/newsguidelines.html) ask.
We detached this comment from https://news.ycombinator.com/item?id=12023677 and marked it off-topic.
The author spent many hours of hard work creating this site, for free, and makes it available to anyone who wants to use it. The least that you could do is not phone in a design critique by just posting a screenshot and saying "this site is poorly designed".
FWIW I think the comment was perhaps a little over the top given the severity of the issue, but on the other hand I'm very happy to have received the bug report :-).