4 ms·

> Oracle's DB is quite stable and reliable Can't speak for the OP but I think that's what he/she meant. Tooling might not be the best due to their proprietary

by mk89 4y ago

> Oracle's DB is quite stable and reliable Can't speak for the OP but I think that's what he/she meant. Tooling might not be the best due to their proprietary nature, but the software itself kicks ass.

chris_wot 4y ago
It does it really? I’ve worked in a company who had to file bugs against data access components and they point blank refuse to fix the issues. Tuning an Oracle database is a dark art of undocumented parameters. Increasingly, you can swap out Oracle with Postgres.
- mk89 4y ago
  > Increasingly, you can swap out Oracle with Postgres. Well, there is also a huge decrease of DB competencies around (myself first, not shifting the blame on anyone). So, now finally all you need is "just a db", DBAs are gone. Most people don't even need non-relational DBs but hey that's cool. Don't get me started :) I wouldn't blame it on the software (oracle) itself but on the fact that with microservices (and managed DBs) the role of a specific DB seems to have decreased significantly.
  - to11mtm 4y ago
    I'd say the 'increasingly' isn't simply because of the loss of DB competency. I worked at a shop that for years was an 'always oracle' even though every license renewal visit left management paranoid and dejected, that got won over by the level of similarity between the two. MSSQL doesn't mesh well with oracle because it isn't MVCC by default, so risk of conversion goes WAY up. MySQL, well it was(is?) missing a number of other features alongside a touchy datatype model and other warts in people's memory. PG tends to do well at picking the right features from other DBs, and you just pay a quote tax to enjoy the benefits. > the fact that with microservices (and managed DBs) the role of a specific DB seems to have decreased significantly. I do think this is the third point in the trident. In some shops (I've yet to see one!) you can get a database per-microservice. More frequently I see 'database-per-ecosystem' which means your microservices share a DB.
hestefisk 4y ago
Oracle RAC runs rings around pretty much any other RDBMS in highly available database clustering. It’s very good (and very $$$).
- datavirtue 4y ago
  Bubkis. SQL Server's high availability is a dream to use and rock solid. Everything else is a joke in that space.

by mk89 4y ago

chris_wot 4y ago

It does it really? I’ve worked in a company who had to file bugs against data access components and they point blank refuse to fix the issues. Tuning an Oracle database is a dark art of undocumented parameters. Increasingly, you can swap out Oracle with Postgres.

mk89 4y ago
> Increasingly, you can swap out Oracle with Postgres. Well, there is also a huge decrease of DB competencies around (myself first, not shifting the blame on anyone). So, now finally all you need is "just a db", DBAs are gone. Most people don't even need non-relational DBs but hey that's cool. Don't get me started :) I wouldn't blame it on the software (oracle) itself but on the fact that with microservices (and managed DBs) the role of a specific DB seems to have decreased significantly.
- to11mtm 4y ago
  I'd say the 'increasingly' isn't simply because of the loss of DB competency. I worked at a shop that for years was an 'always oracle' even though every license renewal visit left management paranoid and dejected, that got won over by the level of similarity between the two. MSSQL doesn't mesh well with oracle because it isn't MVCC by default, so risk of conversion goes WAY up. MySQL, well it was(is?) missing a number of other features alongside a touchy datatype model and other warts in people's memory. PG tends to do well at picking the right features from other DBs, and you just pay a quote tax to enjoy the benefits. > the fact that with microservices (and managed DBs) the role of a specific DB seems to have decreased significantly. I do think this is the third point in the trident. In some shops (I've yet to see one!) you can get a database per-microservice. More frequently I see 'database-per-ecosystem' which means your microservices share a DB.

hestefisk 4y ago

Oracle RAC runs rings around pretty much any other RDBMS in highly available database clustering. It’s very good (and very $$$).

datavirtue 4y ago
Bubkis. SQL Server's high availability is a dream to use and rock solid. Everything else is a joke in that space.