5 ms·

Oracle

• VWWHFSfQ 3y ago
  Anybody that has ever used Oracle knows how nice it is. But very few people have that experience because their company isn't spending millions of dollars on the database server.
  • bradleyjg 3y ago
    Yes, that was my point. I get that working with Oracle and their army of lawyers is not cheap or pleasant but the db is still excellent.
• pmarreck 3y ago
  Oracle is a giant mess, is the sense I got from trying to work with it in the past. While I am loathe to recommend any Microsoft product, SQL Server is at least coherent, and has actual transactions like Oracle (and not just "checkpoints")
  • paulryanrogers 3y ago
    Aren't MSSQL and Oracle just doing redo logs, like MySQL? What do you consider not actual transactions? Postgresql keeps dead tuples in place until vacuumed, which seems optimized for rollbacks. But isn't so bad if you're inserting much more than deleting or updating.
    • pmarreck 3y ago
      Nestable transactions = “real transactions” to me, I guess. I almost don’t see the point in non-nestable transactions
      • paulryanrogers 3y ago
        SQL standardizes SAVEPOINT for such nesting. Is that not sufficient? FWIW Postgres supports it.