News for hackers. Stuff that matters.
Re:Microsoft Access: The Database Software That Won't Die by dvdhsu on Wednesday October 30, 2019 @10:53PM (#21405309)
Hi! I'm working on a project called Retool (https://retool.com), and it's basically Access, in the cloud. We connect to any sort of cloud database / API, and let you build UIs quickly. It's good for building forms that write back to APIs, tables that read data from databases, etc.

I'd really appreciate HN's feedback on this -- if anybody has thoughts -- I'd love to hear them! I'm also david@ if you'd rather email me anything. Thanks!

Re:Microsoft Access: The Database Software That Won't Die by edraferi on Wednesday October 30, 2019 @11:12PM (#21405410)
Hey David - love what you’re doing with Retool. I think it’s a good solution for the front end piece of this challenge. Please correct me if I’m wrong, but doesn’t Retool focus on working with existing enterprise databases and APIs? If so then I think the missing piece is a DBaaS with great guardrails.

Access (and to a lesser extent, Excel) empower anyone to model their data and manipulate it without asking permission. The problem is they don’t scale well, there are no backups, they don’t show up in a data catalog anywhere, no integration with enterprise SSO, etc. They do benefit from file-focused solutions for these issues (eg the Access file lives on a network drive which is backed up) but they fall far short from what you expect from a production database.

So my challenge is: how can I let anyone in my organization create a new database, with all the backup/authentication/discovery/scalability out of the box, for them to connect to Retool?

Re:Microsoft Access: The Database Software That Won't Die by ThrowawayR2 on Thursday October 31, 2019 @11:39AM (#21409948)
Half of the point of Access is that it's not in the cloud; it's a locally installed app that doesn't even require network access or admin rights.
Re:Microsoft Access: The Database Software That Won't Die by cutler on Thursday October 31, 2019 @01:41PM (#21411515)
Access has had a decent MySQL connector for a long time so the scalability, availability and other network factors can be a non-issue if Access is used purely as a GUI.