News for hackers. Stuff that matters.
Re:Ask HN: Why did Visual Basic die? by LeifCarrotson on Monday September 11, 2023 @03:47PM (#37472653)
SQLite. It's not close in terms of ease-of-use of the GUI administration and forms, but as a single-server database solution to embed into a line-of-business app it's fantastic.
Re:Ask HN: Why did Visual Basic die? by afavour on Monday September 11, 2023 @03:55PM (#37472752)
The GUI and forms is what made Access, though. Back in the day I actually made a system with Access that connected to a SQL Server database on the backend rather than Access's file-based engine.

It's a real shame Access died, now there's no path from a spreadsheet to something more sensible.

Re:Ask HN: Why did Visual Basic die? by jkaplowitz on Monday September 11, 2023 @04:30PM (#37473242)
> It's a real shame Access died, now there's no path from a spreadsheet to something more sensible.

Although it has certainly died in terms of mindshare, it's officially still supported for PC (not Mac):

https://www.microsoft.com/en-us/microsoft-365/access

I actually have it installed right now, because it comes with Microsoft 365 Family, which I have on the Windows PC on which I'm typing this comment. I haven't used the modern version of it, though.

Re:Ask HN: Why did Visual Basic die? by bonzini on Monday September 11, 2023 @04:12PM (#37472974)
I know how to write a Django app with a SQLite backend, but that's not what Access does.

There are basic SQLite GUIs, but they have no reporting functionality and no customizable forms.

Re:Ask HN: Why did Visual Basic die? by chasil on Monday September 11, 2023 @04:09PM (#37472933)
...it's fantastic if you are able to live within its limitations, primarily being a single writer.

If your application grows into the need for concurrent writes, then it will be time for another database.

Re:Ask HN: Why did Visual Basic die? by wild_egg on Monday September 11, 2023 @04:30PM (#37473243)
You may be surprised at how far you need to grow to truly need concurrent writes. Blazing fast sequential writes is good enough for the vast majority of applications
Re:Ask HN: Why did Visual Basic die? by eastern on Monday September 11, 2023 @09:27PM (#37475953)
This is so true.

A cross platform Access-like front-end that used sqlite as the data storage engine would conqueror large parts the territory.