4 ms·
> he campaigned for putting the entire web app into an Oracle database with all the logic in stored procedures. Oracle have already done this, it's called Appl
by jacques_chester 7y ago
> he campaigned for putting the entire web app into an Oracle database with all the logic in stored procedures.
Oracle have already done this, it's called Application Express[0]. I used it for my last job. In practice it was pretty good for fast prototyping and iterating on database-backed apps. It took the schema as the source of truth and would add useful interface features based on it (eg, dropdown lists derived from foreign keys, converting some check constraints to javascript validation code etc).
But on the downside it was essentially untestable and version control meant dumping a massive file of autogenerated PL/SQL and checking it into git. For anything more complicated than basic CRUD and reporting you'd wind up cracking the hood to directly use PL/SQL and then skin it with APEX. The tradeoff being that you lost some of the roundtrip niceties.
I wouldn't recommend it in general, but it fit ... OK in its context. It was included in the Oracle license, the org had experience with operating Oracle and it allowed each of us in a small programming group to build little apps to solve genuine business problems that were either too small to select OSS/COTS or too specialised to find anything to select.
The best part of the job was getting rid of painful processes built around sharing Excel and Word docs. I remember occasion when a user broke down in tears because a (to me) trivial app meant that a stressful, high-pressure, error-prone month-long process turned into a non-event. One of the best days of my career and I partially owe it to a platform that I think is, in most respects, a mistake.
[0] https://apex.oracle.com/en/ https://apex.oracle.com/en/
- jagged-chisel 7y agoThis was before an official release, late 1990s. I'm sure he'd gotten his hands on either some documentation discussing the concept, or an early alpha release of Oracle's ApEx.
- dahdum 7y agoMight have been Oracle Web DB, it predated the APEX line but was roughly the same concept and released in the late 90's.
- jacques_chester 7y agoOh very possibly. Wikipedia reckons HTML DB (the original package) was released in 2004, but the APEX website clear claims to being 19 years old, which would put it circa 2000. But in the meantime if you're doing late-90s CGI with Perl, why not `SELECT my_amazing_function()`?
- jagged-chisel 7y agoHey, buddy, we were cutting edge with the brand-spankin-new ASP! (Although, we did have a Perl guy who insisted we'd be renaming all our .asp files to .aspl because MS had 'opened up' the scripting engine to take whatever language you'd want to write an engine for ... and a Perl engine existed at that moment.)