Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: PipeSQL – Building SQL queries bottom-up using pipes and filters

pipesql.com

Post reply on HN
Print view View original

1–10 of 38 posts

Re: Show HN: PipeSQL – Building SQL queries bottom-up using pipes and filters

#2

Post by trimtab »

So using this tool and building scripts in it just ties users to yet another vendor, right?

In that case, if you are already tied to Oracle why not just use their tools rather than something like this? Oracle's tools will hopefully work in lock-step with their releases and there should be no support lag.

This looks neat, but why add another layer of lock-in to yet another vendor with the uncertainty that entails?

Re: Show HN: PipeSQL – Building SQL queries bottom-up using pipes and filters

#3

Post by vkb »

This might be good for developers, but I'm not sure how it's helpful for either heavy users or beginners. For business analysts, it's just another layer on top of SQL, which slows down processing time, and for beginners, it's now two types of syntax and order they have to learn instead of one.

Re: Show HN: PipeSQL – Building SQL queries bottom-up using pipes and filters

#4

Post by michaelmior »

trimtab wrote: post #2

So using this tool and building scripts in it just ties users to yet another vendor, right? In that case, if you are already tied to Oracle why not just use their tools rather than something like this? Oracle's tools will hopefully work in lock-step with their releases and there should be no support lag. This looks neat, but why add another layer of lock-in to yet another vendor with the uncertainty that entails?

I'm not sure I understand your point about being tied to a vendor. This isn't tied to Oracle and it's mentioned at the bottom that you can also generate SQL for MySQL, MSSQL, and others.

Re: Show HN: PipeSQL – Building SQL queries bottom-up using pipes and filters

#5

Post by JustSomeNobody »

michaelmior wrote: post #4
trimtab wrote: post #2

So using this tool and building scripts in it just ties users to yet another vendor, right? In that case, if you are already tied to Oracle why not just use their tools rather than something like this? Oracle's tools will hopefully work in lock-step with their releases and there should be no support lag. This looks neat, but why add another layer of lock-in to yet another vendor with the uncertainty that entails?

I'm not sure I understand your point about being tied to a vendor. This isn't tied to Oracle and it's mentioned at the bottom that you can also generate SQL for MySQL, MSSQL, and others.

One would have to purchase this, yes? One would use this tool to build one's queries, yes? So what's not to understand about being tied to yet another vendor?

I thought that was a clear and honest question.

Re: Show HN: PipeSQL – Building SQL queries bottom-up using pipes and filters

#6

Post by michaelmior »

JustSomeNobody wrote: post #5
michaelmior wrote: post #4

Earlier quoted context omitted.

I'm not sure I understand your point about being tied to a vendor. This isn't tied to Oracle and it's mentioned at the bottom that you can also generate SQL for MySQL, MSSQL, and others.

One would have to purchase this, yes? One would use this tool to build one's queries, yes? So what's not to understand about being tied to yet another vendor? I thought that was a clear and honest question.

Ah, sorry. I was being naive and assuming this was open source.

Re: Show HN: PipeSQL – Building SQL queries bottom-up using pipes and filters

#7

Post by slimbods »

vkb wrote: post #3

This might be good for developers, but I'm not sure how it's helpful for either heavy users or beginners. For business analysts, it's just another layer on top of SQL, which slows down processing time, and for beginners, it's now two types of syntax and order they have to learn instead of one.

I don't think it is another layer, and I don't think it ties you to a vendor. This is a query builder tool that produces SQL code. You then take that SQL and run it against the DB. Once you've generated the SQL, you can modify it, you're not tied to the original pipesql.

Re: Show HN: PipeSQL – Building SQL queries bottom-up using pipes and filters

#10

Post by rnovak »

vkb wrote: post #3

This might be good for developers, but I'm not sure how it's helpful for either heavy users or beginners. For business analysts, it's just another layer on top of SQL, which slows down processing time, and for beginners, it's now two types of syntax and order they have to learn instead of one.

I don't even think it should be used with Devs. For one, a good dev should know how to build queries, otherwise he/she is missing a good foundation, in which case shouldn't be working with the db. Just my personal take though
Post reply on HN