News for hackers. Stuff that matters.

A comment on Show HN: PipeSQL – Building SQL queries bottom-up using pipes and filters.

Re:Show HN: PipeSQL – Building SQL queries bottom-up using p... by akavi on Thursday October 09, 2014 @06:17PM (#8435296)
Most of your favorite languages have sql composition libraries that'll get you 90% of this (Arel for Ruby, SqlAlchemy for Python, etc, etc).

The remainder, the "piping" syntax, is pretty easy to implement (Takes about 30-40 lines of ruby on top of Arel, speaking from experience).

So then, is this just a matter of wrapping a library in a web page and calling it SAAS? Or am I just totally missing the point?

[ Parent | on HN ]
Re:Show HN: PipeSQL – Building SQL queries bottom-up using p... by senthadev on Thursday October 09, 2014 @06:35PM (#8435370)
Piping is used to merge the tables rows. Tables can be merged in multiple ways, for example by join, left join, exists, not exists, union, minus etc.. And you can have the pipe chain up to 255 levels.
[ Parent | on HN ]