senthadev
Re:Creating a SQL complex query report, with visual design approach, v...
on Friday November 14, 2014 @05:01PM (#8609768)
pipeSQL author here:
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.
Show HN: (Up):Building SQL queries in bottom-up approach using pipes and filters
Re:Fibonacci(50) Performance: Java C C++ D Go Terra (Lua) Lua-JI...
on Monday October 20, 2014 @08:46AM (#8481803)
You should try to implement the Fib with tail call and then test it. http://en.wikipedia.org/wiki/Tail_call
Re:Show HN: PipeSQL – Building SQL queries bottom-up using pipes and f...
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.
Re:Show HN: PipeSQL – Building SQL queries bottom-up using pipes and f...
on Thursday October 09, 2014 @06:18PM (#8435298)
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 :) .
Re:Show HN: PipeSQL – Building SQL queries bottom-up using pipes and f...
on Thursday October 09, 2014 @04:56PM (#8434986)
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.
Re:Show HN: PipeSQL – Building SQL queries bottom-up using pipes and f...
on Thursday October 09, 2014 @04:54PM (#8434980)
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.
Re:Show HN: PipeSQL – Building SQL queries bottom-up using pipes and f...
on Thursday October 09, 2014 @04:51PM (#8434965)
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.
Re:Show HN: PipeSQL – Building SQL queries bottom-up using pipes and f...
on Thursday October 09, 2014 @04:47PM (#8434949)
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.
Re:Show HN: PipeSQL – Building SQL queries bottom-up using pipes and f...
on Thursday October 09, 2014 @04:45PM (#8434943)
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.
Show HN: PipeSQL – Building SQL queries bottom-up using pipes and filters
Re:What makes VoIP / SMS sending attractive to customers?
on Sunday September 21, 2014 @02:09PM (#8347806)
How about sending binary SMS such as SIM-RFM messages?
Search-based applications called "intelligent assistants"
String tokenizer in SQL (Oracle db)
Re:Cubli - Its a 15 × 15 × 15 cm cube that can jump up and balance on ...
on Thursday December 26, 2013 @05:11PM (#6968363)
Thanks for aggregating and publishing the links.
Cubli - Its a 15 × 15 × 15 cm cube that can jump up and balance on its corner
Re:Ask HN: What new skill or tech you intend to master in 2014?
on Friday December 20, 2013 @07:48PM (#6945158)
Functional programming using F#
Re:Ask HN: How do you deal with being burnt out?
on Thursday December 19, 2013 @02:28AM (#6933364)
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.
Re:Ask HN: What business domain needs SMS/USSD based UI the most?
on Wednesday December 04, 2013 @06:00AM (#6846158)
Hello nabo :), definitely we should have some beer. My contact email is in profile.
Re:Ask HN: What business domain needs SMS/USSD based UI the most?
on Wednesday December 04, 2013 @05:58AM (#6846152)
Bank sector and USSD are good combination, but banking sector doesn't interest me. Thanks for the input.
Re:Ask HN: What business domain needs SMS/USSD based UI the most?
on Wednesday December 04, 2013 @05:51AM (#6846127)
Yes, this looks interesting. thanks.
Ask HN: What business domain needs SMS/USSD based UI the most?
Hello HN,Last few years I have been developing SMS (binary SMS)-as-a-Service applications, in python and java eco stack, where I've learned the internals of SMS (3GPP TS 23.040) and SIM cards security(3GPP TS 23.048).Now I've allocated 30% of my work week to work on something new, something challenging on my own by mixing this hard earned knowledge with other different domain. According to...
Ask HN: How to apply the hard learned SMS/SIM internals in Startup?
Hello HN,Last few years I have been developing SMS (binary SMS)-as-a-Service applications, in python and java eco stack, where I've learned the internals of SMS (3GPP TS 23.040) and SIM cards security(3GPP TS 23.048). Now I've allocated 30% of my work week to work on something new, something challenging on my own by mixing this hard earned knowledge with other different domain.According to...
Re:Ask HN: Freelancer? Seeking freelancer? (December 2013)
on Sunday December 01, 2013 @02:51PM (#6828911)
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
Bill Gates jumps over an office chair
Re:We got rejected by Y Combinator
on Monday November 18, 2013 @05:21PM (#6757585)
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.