Comment by jordand

5 days ago

All these years later, Microsoft Access is still alive and kicking, and just three years ago, the 32bit version got Large Address Aware (LAA) support! Technically my very first software job was writing VBA in Microsoft Access for a few weeks and they're probably still running it (there's no drop in replacement for it or cheap way to migrate away)

Access is so good. I can't believe there's no universal equivalent for Linux and Mac. There are dozens of times when I've used a spreadsheet when a file-based database would have been better.

  • > Access is so good. I can't believe there's no universal equivalent for Linux and Mac.

    On the Mac, it's FileMaker,[1] which was released in 1985. Claris is a subsidiary of Apple.

    [1]: https://www.claris.com/blog/2026/claris-filemaker-2026-is-no...

    • The father of a girl I dated in college (circa 2000s) built an entire student tracking system using FileMaker to use at the High School he was the Principal of.

      We didn't date for long, but I'd be curious to know how long that system ran.

  • I'm shocked in general at the lack of open source Rapid Application Development software.

    • Someone will no doubt correct my hazy memory, but I wonder how much to blame was the fact that default QT apps were so ugly around the time that was the height of RAD, and QT was the only(?) well-supported cross-platform cross-DE gui framework at that time.

      On windows you could RAD your way to a good looking windows application that looked and behaved like everything else. On linux, default behaviour was either ugly, or not very compatible, or heavily customised anyway, and that didn't change until much later with improvements to GTK.

      1 reply →

    • I think Microsoft coming out with XAML/WPF created too much complexity for most of the developers that were working with WinForms. Although the code had better separation from the interface, it also took quite a bit more effort to get an application up and running quickly. They took the "R" out of RAD, and then kind of put both WinForms and WPF on life support, while continuing to tout cross-platform on .NET Core without a first-party GUI platform. Now it just looks like Azure was always going to be the solution, to tie users into a platform they don't fully control.

      2 replies →

    • > I'm shocked in general at the lack of open source Rapid Application Development software.

      They exist:

      - In particular in the 90s and 00s, Tcl/Tk was really magic for creating user interfaces for small applications under GNU/Linux.

      - Lazarus attempts to be an open-source analogue to Delphi

      - LibreOffice Base attempts to fill the same niche as Microsoft Access

      - Historically, in the time of Gtk+ 1.x and 2.x Glade [1] was an editor for clicking together user interfaces. Well, development ceased, and under GNU/Linux there is no attitude of retaining backwards compatibility with applications/libraries that are not maintained anymore (but which might be business-critical).

      - ...

      But of course Rapid Application Development is much more popular in the business world which is (at least in many European countries) a rather Microsoft-centric environment. Additionally, the typical developer that uses Rapid Application Development is often a subject-matter expert in some department who also knows a little bit about programming (i.e. is not in deep love with programming), and not a programming expert who also knows about some other specialized topics that are important for the business.

      On the other hand, the open source environment typically rather attracts people who really like programming.

      ---

      [1] https://en.wikipedia.org/wiki/Glade_Interface_Designer

    • If your into C++, there is U++ (Ultimate++), which is a fully featured RAD ide equivalent to Lazarus with the fastest compiler I've seen. It compiles to Win/Mac/Linux/BSD.

    • Well, (F)OSS projects have never been known for great UI/UX (with some exceptions like Blender), so it doesn't surprise me much

    • Qt Quick and Qt Creator isn't RAD per se but I feel like it gets you close.

    • Nerds have vested interests (exposure/influence/status based on exclusivity of skill) to oppose letting ”the wrong people” create software, versus a company like Microsoft is the other way around because they get paid and get to further-entrench their platforms (but I repeat myself).

      And/or too many people have internalized a feeling of “I am Very Smart because I know better than to ever try anything unique”, as exemplified by that awful xkcd ‘Standards’ learned-helplessness comic somebody will always rush to post in a discussion of any New Thing, and thus would never even dream of creating RAD tools whose entire premise is the creation of bespoke software.

      1 reply →

  • In the mid-2000's, I built a lot of applications replacing Access. I always met with the actual users of the system, and made sure they understood that once I took over development, they weren't going to be able to build out their own forms anymore. A few clients were turned away, but most could live with paying for myself to make any future edits, so that they could concentrate on the business objective rather than coding in Access. I never really had the same success with replacing Excel, except for a few systems where it needed to be true multi-user.

  • There is openoffice base https://help.libreoffice.org/latest/en-US/text/sdatabase/mai...

    I am not going to claim it is any good, it suffers from the same problem most rapid application toolkits have, the easy stuff is easier, the hard stuff is harder. I was playing around at one point to see if it was worth using as a graphical interface to a postgres database. And... it worked. But in the end I preferred writing web applications. As much as I hate web dev it was better than the RAD jank.

  • > Access is so good. I can't believe there's no universal equivalent for Linux and Mac.

    Here you go: https://visualdb.com There are many modern alternatives, in fact.

    • I've looked into these before and they're often a monthly/annual SaaS that are either by a one-person company, or worse, something like AirTable that gets crazy price hikes out of nowhere (or shut down) that's a disaster for a small company. Place I worked already had Microsoft Office paid for so why move away from Access.

      9 replies →

    • That seems to be missing an actual database. Access has everything included. Run Access.exe and away you go. This looks way more complicated.

      1 reply →

  • Technically, MS Power Apps is the successor to MS Access. Power Apps is a web application so that solves the cross platform problem.

    Having played with it, it’s not as turn key as either MS Access or something like Airtable. It can be overly complicated and it’s infected with the paradox of choice.

  • Sqlite?

    • Access is a whole package with form designers, widgets, scripting, etc. so that you can build an entire distributable app from it. SQLite's a brilliant little DB but it only covers a tiny portion of what Access does.

      I kinda loathe access for any number of reasons, but appreciate the dev tools it put into the hands of non-developers. A great many people who'd be passive users on most systems were able to build apps to meet their business and requirements, and although Access was janky as hell, that's very, very cool. I think it's most spiritually similar to HyperCard on Mac: you wouldn't want to write a whole large app in it, and if you're an experienced developer there are any number of tools you'd rather write programs with. But if you weren't a traditional developer (e.g. an office worker or a student or a home computer enthusiast, etc.) it gave you a pleasant hand-holding process for making your ideas come to life. I respect that.

      2 replies →