Re:Show HN: Run SQL on Spreadsheets
by nafey on Sunday May 23, 2021 @12:03PM
(#27256015)
Hi HN, We are Nafey and Akhil, founders of Spanrr. After spending months building apps on spreadsheets and working with existing spreadsheets api we realized while people might need customisable apps, what they really prefer any day is a better spreadsheet.
Key differentiators:
- You can write SQL queries on your spreadsheet. You can also do JOIN queries across spreadsheets, do summaries and statistics.
- Easily handle millions of rows smoothly
- API out of the box for your data so you can wire it to other systems.
- Import your CSV or Excel files and run SQL queries over
- Native connection to MySQL database
- Save SQL queries for future use
Upcoming features :
- Connection to PostgreSQL, SQL Server and MongoDb.
- Self hostable version.
- Granular permission.
- Version control and error checking.
- Command-line based access.
- Connect Spanrr directly to your Web application as a MySQL database.
Please let us know any use cases for which you want to try it out or if you like to see anything new on the product.
Re:Show HN: Run SQL on Spreadsheets
by nafey on Sunday May 23, 2021 @01:23PM
(#27256739)
We have found it a very cumbersome process to set up SQL support on excel. We are building this spreadsheet ground up to work well with SQL and databases in general. Also we have built this spreadsheet in such a way that it can handle millions of rows which is another place where excel does not provide good user experience.
Re:Show HN: Run SQL on Spreadsheets
by glua on Sunday May 23, 2021 @12:52PM
(#27256497)
I signed up to check out Spanrr.
I find it useful for preview of our data from database, by non-tech stuff. Seems we could use this as a CRM for our business.
Do you plan to implement auto-complete / suggestions for queries, so it is easier for our stuff to use more advanced queries?
Re:Show HN: Run SQL on Spreadsheets
by smutnure on Monday May 24, 2021 @02:49AM
(#27261655)
A good took for non developers. For PMs who are handy with basic SQL, spannr is a good tool to reduce dependency on data analysts. PMs can quickly run all sorts of analysis on the data. Looking forward to extension of the tool for marketers too.
Re:Show HN: Run SQL on Spreadsheets
by nafey on Monday May 24, 2021 @07:54AM
(#27263298)
Spanrr is a browser based spreadsheet application which comes with SQL support. Datagrid is a frontend component so it is not quite what we are offering.
Re:Show HN: Run SQL on Spreadsheets
by hurricaneditka on Wednesday May 26, 2021 @11:19AM
(#27291656)
ok i get the sql over spreadsheet but what about actual spreadsheet features? will i be writing spreadsheet-esque formulas? adding visualizations directly in the spreadsheet? can i create custom formulas? etc... very promising thank you.
Re:Show HN: Run SQL on Spreadsheets
by oyeakhil on Tuesday May 25, 2021 @03:27AM
(#27273922)
Both behaves like relational DB...yes.
But here you can process millions of rows, bring in data from intercom,hubspot, database natively and you will get much better APIs ( and limits) to build apps on top of :)
Key differentiators:
Upcoming features : Please let us know any use cases for which you want to try it out or if you like to see anything new on the product.We’ll be here all day answering your question.
Excel has supported this out-of-the-box for decades, though the process is a little convoluted.
Do you plan to implement auto-complete / suggestions for queries, so it is easier for our stuff to use more advanced queries?
But here you can process millions of rows, bring in data from intercom,hubspot, database natively and you will get much better APIs ( and limits) to build apps on top of :)
We re-used our old failed ideas design because we didn't have time. Happy to learn you liked it.