4 ms·
I’m surprised nobody had said MS Access. You don’t need to learn any programming languages, it comes with everything you need, and every Access app has lasted
by kube-system 5y ago
I’m surprised nobody had said MS Access. You don’t need to learn any programming languages, it comes with everything you need, and every Access app has lasted way longer than anyone wanted it to. ;)
- unnouinceput 5y ago><You don’t need to learn any programming languages Yes you do. If you want to have buttons and tables and do something above of only showing the data you'll need to learn VBA. Also SQL implementation for MSAccess has some peculiar stuff in regards to LIKE or how datetime is handled. So you'll learn 2 programming languages actually - VBA % the variaton of SQL that MSAccess has. And you can't scale up from single user to multiple users as MSAccess is not a server like PostgreSQL.
- kube-system 5y agoIIRC (it's been a while), you can check all the boxes of C, R, U, and D, using forms. And Access is multi-user. You don't want a lot of users on it, but you can have more than one. This is extra credit though, the OP never asked for a multi-user solution.
- Rizz 5y agoMS Access works just as well on an SQL Server database as on its internal database, so your scaling works just as well as on any other established database server, and then the SQL dialect is T-SQL, which is reasonably standards compliant.
- jaxrtech 5y agoCan also say that the SQL implementation in Access is reprehensible in terms of silent errors and other weirdness.
- buescher 5y agoIf Access had straightforward (ideally one-click), rock-solid tools for web deployment, it would be the killer no-code app.
- sidpatil 5y agoAgreed 100%. The fact that this doesn't exist is one of Microsoft's biggest missed opportunities, in my opinion.
- joenathanone 5y agoI started my CRUD with MS Access, then moved to SQL Server > MVC > .Net 6 web app. MS Access was a great launching point.
- awinter-py 5y ago^ legit point -- tight coupling between data + UX widgets is like postgREST + retool in a single package that has been evolutionarily stagnant since like 1992
- Someone 5y agoThat and FileMaker were my first thoughts, too, but reading https://support.microsoft.com/en-us/office/access-2010-web-databases-roadmap-f778cc30-bfa3-4be4-bab2-55ef4b50e814 https://support.microsoft.com/en-us/office/access-2010-web-d... Access isn’t an option anymore if web access is required. FileMaker Pro (https://www.claris.com/filemaker/pro/ https://www.claris.com/filemaker/pro/) probably still is an option. It isn’t free in any sense, though. dBase also still exists (http://www.dbase.com/ http://www.dbase.com/ (web page looks like a print of an ugly presentation)), but I wouldn’t know whether that ticks all the boxes.