6 ms·
I'm the only competent developer in our company. So believe it or not, but I'm doing it all, from tinkering in disassembled Oracle 9i JDBC driver, to planning O
by vbezhenar 8y ago
I'm the only competent developer in our company. So believe it or not, but I'm doing it all, from tinkering in disassembled Oracle 9i JDBC driver, to planning Oracle migration to writing SQL queries, reverse-engineering stored procedures, modifying Delphi sources, writing Java code, writing Kotlin code, writing HTML, JavaScript, CSS, Objective
C, rolling out some tiny PHP website, writing brute-forcer to crack P12 private key because someone forgot password LoL. Sure, I'm not an expert in any of those fields. I don't even like most of them. Give me task to write Kotlin library (reimplementing React!) and I'd be happy sitting in the corner for the next few years. But I don't have that luxury and generally stuff I'm doing works well enough. And given our income, it's just not possible to hire few competent developers and they would do nothing most of the time anyway. But if I can do it all, I'm busy most of the time and I can have some money as well. Full stack, that is.
- bcheung 8y agoHow was your day at work? > writing brute-forcer to crack P12 private key because someone forgot password LOL
- nickpeterson 8y agoI'm sure your reasons are valid, but I laughed a bit when I read that you use Oracle and don't have the budget for more people.
- mmt 8y ago> I laughed a bit when I read that you use Oracle and don't have the budget for more people. Why? Because you believe the former causes the latter? There are many valid criticisms to be levied against Oracle the company, enteprise software in general, and especially its pricing. However, it's important to remember that, for many businesses, it's either impractical or downright impossible to hire enough engineers to make up for to lost features of replacing Oracle with even somethig as relatively feature-dense as PostgreSQL.
- JamesBarney 8y agoI think the idea though is most companies that have such small development team usually don't have the need or expertise to take advantage of those features.
- mmt 8y agoThat idea just doesn't stand to reason, though, to be fair, if you say "most companies that" you're expressing a stereotype, which can easily fail, as it does here, when applied to a specific case. I personally know a "such a small development team" (i.e. a single person) who certainly has the expertise, by virtue of having trained to become an Oracle DBA after a fairly extensive career as a software engineer. As for need, I'm no expert on Oracle's unique features, but the GP specifically mentioned "reverse-engineering stored procedures", which implies at least previous developers thought there was a need to use an arguably advanced database feature. In fact, even just having a substantial quantity of stored procedures written in PL/SQL, perhaps at a time when that company had (or contracted out to) a larger development team may make it prohibitive to switch to any other language. Reliably implementing business logic as-is is a pretty big feature.
- stickfigure 8y agofor many businesses, it's either impractical or downright impossible to [...] make up for [...] features of replacing Oracle I would have granted you this if you'd said "for a few specialized businesses", but you're waaay overselling it. 99.9% of businesses using Oracle would do just fine with a "lesser database".
- mmt 8y ago> would do just fine with a "lesser database" And I would grant you that if you could make the credible argument that a "lesser" [1] database could be a suitable replacement on a drop-in basis, without significant engineering effort. As I pointed out in a downthread comment, a very useful feature is that existing stored procedure that encode business logic already work. Are you really saying that only 0.1% of business database users fall into even that category? My second-hand (DBA I know) experience contradicts this, but if you have a better source, I'm certainly interested. [1] I don't actually intend to make any overall value judgment, since my point isn't that Oracle has feature/performance superiority over any other database. Instead, I'm saying that it has specific features that the business needed at the time it was chosen that may not be offered by a different one.
- ww520 8y agoOracle Express is free. It's close to full feature as the Standard one, except some limitation on number of connections and some enterprise feature.
- thorin 8y agoYes Oracle 11g XE is free although you are stuck a version behind the latest 12c release. You get a lot of stuff in there although you are limited on db size as well. You do get apex which you can use to build web apps easily and all your pl/sql will work but there are some limitations around Java in the database and anything that relies on that. It's definitely worth a go, but if you are starting from scratch Postgres is probably more appealing now.
- Illniyar 8y agoI didn't know you can even use Oracle Express in a commercial settings, I've always seen it as a developer edition.
- vbezhenar 8y agoIt's historical reasons. They use Oracle 9i with 15-year old software and they don't have budget to upgrade, so, I guess, they'll use it for another 15 years. Actually it works well for its age. I'd say that PostgreSQL would as well and I'd choose it any day if I have to pay for it. But I have to work with what I've got.
- fouc 8y agoHow many developers are there at your company?
- kovacs 8y agoOh... it's just her/him :-P
- vbezhenar 8y ago5 people, me as a developer, another guy as a mostly database stuff (he knows Java and sometimes helps me, but prefers to work with database-related tasks), 2 kind of management guys to work with papers, money, documents and all that stuff and recently we hired one young guy to help with boring stuff (something like first line technical support).