Skip to content

Tag: Oracle

  • Is Oracle-Compatible Postgres Actually Useful?

    By Ruohang Feng In PGSQL 1053 words 5 min

    Ruohang FengPostgreSQLOracleDomestic Database

    Is Oracle-Compatible Postgres Actually Useful?

    I used to roll my eyes at “Oracle compatibility” in PostgreSQL forks. My take was simple: if your SQL doesn’t run on vanilla Postgres, fix your app rather than database. Then a migration task slightly changed my mind. The Problem: A JAR and Nothing …

    I used to roll my eyes at “Oracle compatibility” in PostgreSQL forks. My take was simple: if your SQL doesn’t run on vanilla Postgres, fix your app rather than database. Then a migration task slightly changed my mind. The Problem: A JAR and Nothing …

  • Comparing Oracle and PostgreSQL Transaction Systems

    By Laurenz Albe In Database 828 words 4 min

    Laurenz AlbePostgreSQLOracleDatabaseTransactions

    Comparing Oracle and PostgreSQL Transaction Systems

    Original by Laurenz Albe. Translation and commentary by Feng Ruohang. Transactions sit at the heart of relational databases. They guarantee data integrity for applications. SQL defines some transactional behavior but leaves plenty unspecified, so …

    Original by Laurenz Albe. Translation and commentary by Feng Ruohang. Transactions sit at the heart of relational databases. They guarantee data integrity for applications. SQL defines some transactional behavior but leaves plenty unspecified, so …