[HN Gopher] Show HN: Run SQL on Spreadsheets
       ___________________________________________________________________
        
       Show HN: Run SQL on Spreadsheets
        
       Author : nafey
       Score  : 15 points
       Date   : 2021-05-23 15:52 UTC (7 hours ago)
        
 (HTM) web link (spanrr.com)
 (TXT) w3m dump (spanrr.com)
        
       | dragonwriter wrote:
       | > Write SQL queries atop of your spreadsheet data. Even, JOIN
       | queries across spreadsheets.
       | 
       | Excel has supported this out-of-the-box for decades, though the
       | process is a little convoluted.
        
         | nafey wrote:
         | 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.
        
       | [deleted]
        
       | glua wrote:
       | 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?
        
         | nafey wrote:
         | Yes autocomplete for query is something we will be working on
         | in near future.
        
       | nafey wrote:
       | 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.
       | 
       | We'll be here all day answering your question.
        
         | delbint wrote:
         | Its really useful tool to have for non technical people.
         | Waiting to see the final product soon.
        
         | rick29 wrote:
         | Pretty interesting
        
       ___________________________________________________________________
       (page generated 2021-05-23 23:02 UTC)