It’s not uncommon for people on one hand to expound the functionality, performance and features of Oracle, whilst on the other hand, lament the potential high cost of the product.
I’m not pontificating here – I’m commonly one of these people. So much good stuff in Oracle….yet so much to pay to get that good stuff
So in the interests of fairness, I thought I’d share a little story where an Oracle solution was implemented with total expenditure of: ZERO
A friend saw a request on a "volunteer registry", asking if anyone could (on a voluntary basis) help sort out a book keeping mess. The request was from a small organisation, and their list of contacts, organisations, memberships, and the like, was a jumbled mish-mash of spreadsheets, word documents, post-it notes, emails etc. They knew it was a bad, but didn’t really have the capability or time to fix it. They had a number of PC’s that they used day to day, and a "server" (aka, a spare PC), where they shared information. Backups consisted of a manually run program once every few weeks to dump the server folders onto an external USB drive.
So my friend, armed with not much more than good Oracle SQL skills, spent a few days becoming a self-taught "Application Express developer", spent a few months on the occasional evenings and weekends building an application for them. And just last weekend, with a little design review and a little implementation knowledge from myself, the application has "gone live" for the organisation – staff using Apex against the embedded PLSQL gateway listener running out of Oracle Express Edition. RMAN backs up the whole lot each night. A couple of Apex plugins delivers ad-hoc reports, and caters for mail out’s etc.
Total license cost: nil
Total additional hardware cost: nil
Training cost: nil
No-one is claiming that the application is a show case for Application Express. When you’re a new developer to a technology, you go with what works, rather than what is the best way. But it proves that with a little SQL and a grasp of the relational fundamentals, you can deliver fully functional Oracle systems in places that you would not expect to ever be Oracle "customers". And moreover, for a cost not measured in dollars, but purely in one’s enthusiasm to play with the technology.
Now that’s a real success story