Hacker News new | ask | show | jobs
by richardboegli 3433 days ago
It exists already. It's called MS Access.
3 comments

Except Access has many of the same issues as Excel. You can work around some of the nastier stuff like file locking by using liked database files and having everyone save their own copy of the "frontend" database file, but it's more of a pain in the ass than it's worth (and oh god is it slooow).
I think you mean MS SQL Server, it is faster and has more features than Access.

Access is good to prototype a database and use GUI/UX controls to make forms and other stuff. It is good for small projects, but once you need to upscale you need to go to SQL Server. I did this in the late 1990s and early 2000s migrated databases from Excel and Access to SQL Server.

On Linux, people use MySQL or PostgreSQL for the same reason and upgrade from SQLlite3 etc.

<shudder> how many paths to mdb corruption? Let me count the ways.

I wrote Access apps in college for cash to doctors and small business and I still have no love for the tool.