4 ms·
Productivity has to be measured with the implemented use-case held stable. Visual FoxPro was probably the pinnacle of "easy to make CRUD apps", but the result
by derefr 11y ago
Productivity has to be measured with the implemented use-case held stable.
Visual FoxPro was probably the pinnacle of "easy to make CRUD apps", but the result is, at most, an program that runs on a few computers on a corporate Intranet, that each must use a specific version of Windows with a pre-installed runtime.
A modern LAMP app, despite being composed of layers upon layers of kludges, can be immediately interacted with from any computer in the world, with no sysadmin experience, by entering a URL, and—with no particular effort into architecture or scaling—allows for thousands of simultaneous users to submit changes to the same data in a perfectly consistent fashion with no "whole document is locked for modification"-type problems.
The LAMP app also has a number of modular boundaries that the FoxPro app doesn't: the backend server treats its database as a black box, so it could actually be a replicated cluster, or a different DBMS the next week; the frontend JS treats the backend as an opaque HTTP API, so either of the two could be rewritten or outsourced, and the API could be repurposed by new clients with no additional effort put in on the backend team's behalf; the frontend is built up from layers of specifications (e.g. CSS features) that are each optional, such that you can visit the site from a copy of IE7 on a Windows XP machine in a dusty Korean net-cafe and it'll still let you use the app, just in a less pretty fashion; and so forth.
(And this is ignoring the 10x advantage in accessibility for blind users markup gives over old pixel-blitting GUIs. Modern GUIs are "markup-based" in a similar sense—Cocoa NIBs, Microsoft XAML, etc.—because it's far easier to accessibility-enable a frontend when it exists in the form of an UA-inspectable DOM, rather than an opaque framebuffer.)
If all you need is the paired-Windows-98-machines-in-your-office use-case, sure, use Visual FoxPro (or whatever the modern equivalent is. FileMaker Pro?) You can go even simpler, if you like, and just use green-screen terminals pointed at an ncurses app running on your office machine. But if you need the Internet use-case—where everyone with any tech experience level can use your app from anywhere on any old device, all at the same time—nothing less than the stack of kludges we've got is actually up to solving that problem.
- chadcmulligan 11y agoI never mentioned visual fox pro, it's not comparable and I would never say it was the pinnacle of easy to make CRUD apps which is why I mentioned Delphi and VB, Delphi in particular I'd say was (and still is in some ways). I don't know where to begin with the rest - "whole document is locked for modification" - what on earth is that - and why does the web have anything to do with that, if you mean optimistic locking, then many apps use that. All the products I mentioned produced a product comparable to a web product - client server enterprise level applications, which could be run over the nascent web (dial ups even - it was done regularly). The complification of modern software stacks has reduced productivity, perhaps your argument is that the use cases addressed by modern applications (web in particular) differs from earlier systems?
- derefr 11y ago> "whole document is locked for modification" - what on earth is that It's what happens when everyone in the office is trying to edit the same Excel spreadsheets over SMB/CIFS at the same time. Most "easy CRUD app maker" solutions didn't produce something much better, architecturally, than that baseline. I mentioned FoxPro because a lot of people give it as an example of such an "easy CRUD app maker." Hypercard and Lotus Notes are others. These are the points clustered on one side of the "easy design vs. architecturally-sound product" spectrum. Delphi/VB are closer to the middle of that spectrum; not quite as easy, but they at least have a concept of "a database" that doesn't refer to a proprietary file format built into the runtime. The web is on the right of that spectrum: not at all easy, but the product is something that works, in a sense that other apps can hardly hope for. A correctly-architected web-app will work on Chrome Canary, IE6, w3m, a Palm Pilot's WAP browser, the Wayback Machine, several web spiders, IFTTT, as an offline cache, through corporate proxies, with Cloudflare, through Tor, with screen-readers, when printed, with UA CSS overrides for e.g. contrast-enhancement, with any sized viewport, with any sized fonts, and even with people who disable Javascript. That is the use-case. As you go to the right on the spectrum, you approach being able to solve for that use-case—but it takes a slight while longer to build.
- chadcmulligan 11y agoOK, for > It's what happens when everyone in the office is trying to edit the same Excel spreadsheets ... That really isn't solved by the web either so lets forget about that > Delphi/VB are closer to the middle of that spectrum... I disagree - and have evidential support - I have worked on cross platform Delphi products (iOS/android/OSX/Windows) that have a REST backend and what would be called 'web scale' products > The web is on the right of that spectrum... Well this is where the argument gathers some steam - when people say 'the web' they usually mean a large blob of technologies from Web browsers to LAMP stacks etc. So can we differentiate these into two components? 1. The web browser 2. The backend stack
- mahyarm 11y agoAlthough I don't have much experience with delphi/vb since it was before my productive time, I can definitely see how they are an improvement in creating a front client end very quickly. There is nothing about their design that should make the backend not handle multiple users or to use something more standard such as sql-lite.
- blub 11y agoA modern LAMP app will probably require the latest browser with JavaScript enabled otherwise it will fall flat on its face. It would probably not be accessible at all to users with disabilities, but it would have a beautiful flat design and plenty of tracking and ads which increase the download size by megabytes to display what should essentially be a bunch of text, some images and maybe some forms. The mobile version would offer half the features of the full version and disable zooming. When you first open the site you get a cookie notification followed by a newsletter subscription notification. It will be a nightmare to maintain it for longer than a year, because by then most of the JavaScript frameworks it was developed with will have been replaced with newer and better frameworks. With no particular effort into architecture or scaling, it will run out of resources as soon as a few thousand clients try to access it, but elegantly avoid locked for modification problems by displaying a 404 instead.