5 ms·

You need to give them a tool that's as easy to use as a spreadsheet, and yet stores data in a relational database. There are plenty of spreadsheet-database hybr

You need to give them a tool that's as easy to use as a spreadsheet, and yet stores data in a relational database. There are plenty of spreadsheet-database hybrids in the market.

gregates 1y ago
Are any of them as easy to use as a spreadsheet?
- breadwinner 1y ago
  I would say Airtable is. Or if your users are slightly more technical you can try https://visualdb.com/ https://visualdb.com/ because it lets you use your own Postgres instance as the backend db.
  - pletnes 1y ago
    I’ve used Airtable a bit. I think it’s really cool and would like more people to use it. However, it’s a lot more clicks and key presses to get things done - especially data entry - than in Excel. This also makes it better, since you can put constraints on tables, for instance.
    - breadwinner 1y ago
      You are absolutely right about needing more clicks and key strokes in Airtable. You have to reach the pain threshold in order to look for alternatives to Excel. And how soon you reach the pain threshold depends on how big your data is and how many users are trying to modify the same data at the same time. See here to understand what you are missing out by not using a database: https://visualdb.com/comparison/#integrity https://visualdb.com/comparison/#integrity
  - mstkllah 1y ago
    I feel quite comfortable in Excel - used various tools like Power Pivot, Power Query, OLEDB, created my own functions, Python within Excel, etc. - but Airtable felt so confusing and limiting. Other former colleagues also struggled with Airtable; maybe it was not explained to us correctly.
  - snerbles 1y ago
    NocoDB is also a self-hosted option. I used it to power a family project that required regular API access, but without the rate limits of Google Sheets.
analog31 1y ago
Using any tool but Excel has the same problem as finding programmers who are willing to use some obscure proprietary programming language. They're going to worry about career lock if they're not developing portable skills. Even though Excel is proprietary too, it's ubiquitous enough that people don't have to worry about it.
- breadwinner 1y ago
  That's true, nothing is as ubiquitous as Excel. But Excel is not designed for multiple people simultaneously updating data. At some point you need a database.
  - NotMichaelBay 1y ago
    It's not perfect, but Excel can track changes by multiple users. Excel files shared on OneDrive/SharePoint allow multiple people to simultaneously update the data, and it tracks each individual change by each user.
- nextaccountic 1y ago
  What about a tool that tracks updates to shared Excel spreadsheet and replicate them in a SQL database? And then, if somebody makes a change in the database, a trigger will update the spreadsheet Such a two-way binding makes it possible to continue relying on spreadsheets for UX, all the while the data is not locked in there and we can also have other processes handling the data (a web app, some cron job, etc) Maybe market it as an API for excel or something
  - analog31 1y ago
    I don't use Excel much, but I do the analogous kinds of things with Python and Jupyter notebooks. The problem is that adding some kind of layer requires the involvement of corporate IT, which blows away the advantages of DIY'ing things.

You need to give them a tool that's as easy to use as a spreadsheet, and yet stores data in a relational database. There are plenty of spreadsheet-database hybrids in the market.

gregates 1y ago

Are any of them as easy to use as a spreadsheet?

breadwinner 1y ago
I would say Airtable is. Or if your users are slightly more technical you can try https://visualdb.com/ https://visualdb.com/ because it lets you use your own Postgres instance as the backend db.
- pletnes 1y ago
  I’ve used Airtable a bit. I think it’s really cool and would like more people to use it. However, it’s a lot more clicks and key presses to get things done - especially data entry - than in Excel. This also makes it better, since you can put constraints on tables, for instance.
  - breadwinner 1y ago
    You are absolutely right about needing more clicks and key strokes in Airtable. You have to reach the pain threshold in order to look for alternatives to Excel. And how soon you reach the pain threshold depends on how big your data is and how many users are trying to modify the same data at the same time. See here to understand what you are missing out by not using a database: https://visualdb.com/comparison/#integrity https://visualdb.com/comparison/#integrity
- mstkllah 1y ago
  I feel quite comfortable in Excel - used various tools like Power Pivot, Power Query, OLEDB, created my own functions, Python within Excel, etc. - but Airtable felt so confusing and limiting. Other former colleagues also struggled with Airtable; maybe it was not explained to us correctly.
- snerbles 1y ago
  NocoDB is also a self-hosted option. I used it to power a family project that required regular API access, but without the rate limits of Google Sheets.

analog31 1y ago

Using any tool but Excel has the same problem as finding programmers who are willing to use some obscure proprietary programming language. They're going to worry about career lock if they're not developing portable skills. Even though Excel is proprietary too, it's ubiquitous enough that people don't have to worry about it.

breadwinner 1y ago
That's true, nothing is as ubiquitous as Excel. But Excel is not designed for multiple people simultaneously updating data. At some point you need a database.
- NotMichaelBay 1y ago
  It's not perfect, but Excel can track changes by multiple users. Excel files shared on OneDrive/SharePoint allow multiple people to simultaneously update the data, and it tracks each individual change by each user.
nextaccountic 1y ago
What about a tool that tracks updates to shared Excel spreadsheet and replicate them in a SQL database? And then, if somebody makes a change in the database, a trigger will update the spreadsheet Such a two-way binding makes it possible to continue relying on spreadsheets for UX, all the while the data is not locked in there and we can also have other processes handling the data (a web app, some cron job, etc) Maybe market it as an API for excel or something
- analog31 1y ago
  I don't use Excel much, but I do the analogous kinds of things with Python and Jupyter notebooks. The problem is that adding some kind of layer requires the involvement of corporate IT, which blows away the advantages of DIY'ing things.