senthadev | 11 years ago | on: Creating a SQL complex query report, with visual design approach, via pipeSQL
senthadev's comments
senthadev | 11 years ago | on: Fibonacci(50) Performance: Java C C++ D Go Terra (Lua) Lua-JIT (Lua)
You should try to implement the Fib with tail call and then test it. http://en.wikipedia.org/wiki/Tail_call
senthadev | 11 years ago | on: Show HN: PipeSQL – Building SQL queries bottom-up using pipes and filters
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.
senthadev | 11 years ago | on: Show HN: PipeSQL – Building SQL queries bottom-up using pipes and filters
This is an example where SQL can be written in multiple ways to get the same result. It doesn't matter how many lines SQL contains since its all depends on how the database engine going to execute it. Therefore, pipeSQL's main aim is to make it easier to read and understand the query after couple of days/weeks :) .
senthadev | 11 years ago | on: Show HN: PipeSQL – Building SQL queries bottom-up using pipes and filters
This is not a replacement for SQL. Its a tool to create SQL in a different angle. An angle which is similar to UNIX pipeline concept.
senthadev | 11 years ago | on: Show HN: PipeSQL – Building SQL queries bottom-up using pipes and filters
API would be charge by usage. But the desktop APP will be one time payment(per year) since it will include the parser to translate the pipeSQL to database dialect. Still not finalised, but happy to hear your thoughts on the pricing model.
senthadev | 11 years ago | on: Show HN: PipeSQL – Building SQL queries bottom-up using pipes and filters
Main aim of this tool is to create complex queries in a bottom-up approach. Say you want to create a query by joining 5 tables. Even though we declare 5 tables in the FROM clause, database will join 2 at a time. And then join another table with the previous result set. So this tool helps to build query similar to execution plan tree structure.
senthadev | 11 years ago | on: Show HN: PipeSQL – Building SQL queries bottom-up using pipes and filters
This is a tool to generate complex queries in a bottom-up approach. Once the SQL is generated, then we can use the SQL in the application for future use. It's not another layer between apps and database.
senthadev | 11 years ago | on: Show HN: PipeSQL – Building SQL queries bottom-up using pipes and filters
Exactly, its a tool to generate SQL in a elegant manner. Once the SQL is generated, we can uses the generated SQL in the app. There is no need of a new additional layer between apps and database.
senthadev | 11 years ago | on: What makes VoIP / SMS sending attractive to customers?
How about sending binary SMS such as SIM-RFM messages?
senthadev | 12 years ago | on: Cubli - Its a 15 × 15 × 15 cm cube that can jump up and balance on its corner
Thanks for aggregating and publishing the links.
senthadev | 12 years ago | on: Ask HN: What new skill or tech you intend to master in 2014?
Functional programming using F#
senthadev | 12 years ago | on: Ask HN: How do you deal with being burnt out?
Traveling in the same boat as you do, not eligible to advice. Although I read in HN before that burnt out is a signal by the brain stating that we are working without any foreseeable reward.
senthadev | 12 years ago | on: Ask HN: What business domain needs SMS/USSD based UI the most?
Hello nabo :), definitely we should have some beer. My contact email is in profile.
senthadev | 12 years ago | on: Ask HN: What business domain needs SMS/USSD based UI the most?
Bank sector and USSD are good combination, but banking sector doesn't interest me. Thanks for the input.
senthadev | 12 years ago | on: Ask HN: What business domain needs SMS/USSD based UI the most?
Yes, this looks interesting. thanks.
senthadev | 12 years ago | on: Ask HN: Freelancer? Seeking freelancer? (December 2013)
SEEKING TO SOLVE MOBILE COMMUNICATION PROBLEMS:
I have built my knowledge around (U)SIM (SmartCard) and SMS (deeper level such as binary SMS etc.). Please do contact me : senthadev'at'gmail.com
senthadev | 12 years ago | on: We got rejected by Y Combinator
Vinod khosla (Sun co-founder) says "Fail Fast", meaning that learn all the possibilities (specially the dead ends, how not to use) of the new technology/idea before competitors do. So when the competitors place their baby step on the idea you're more far from the starting line. Good luck.
senthadev | 12 years ago | on: Ask HN: Quit my job for a year to write open source code, what should I work on?
This is what I was looking for, data producers control their own data and manage the app providers to use the data..
senthadev | 12 years ago | on: Ask HN: Quit my job for a year to write open source code, what should I work on?
Self hosting real time "Commenting" web application with text mining/taming functionality. (A replacement for Disque)
page 1
Sorry, I didn't understand your answer. It is very important to understand the complex query in-order to debug or re-engineer. One way is to visualise it as mentioned in the article and convert it to SQL via pipeSQL.