Oracle vs. PostgreSQL: First Glance

Re:Oracle vs. PostgreSQL: First Glance by hans_castorp on Monday May 04, 2020 @10:41AM (#23068624)

> Biggest difference for me is DDLs are transactional in Postgres, but not on Oracle.

The answer I received more than once from Oracle evangelists regarding transactional DDL: it's useless and if you need it, you are not testing your scripts properly

[ Parent | on HN ]

Re:Oracle vs. PostgreSQL: First Glance by hathawsh on Monday May 04, 2020 @11:26AM (#23069144)

Transactional DDL is, IMHO, the best way to write database tests! I've been really happy with database testing since I built and started using a library that runs DDL and uses savepoints without ever committing a transaction.

https://docs.rs/diesel_pg_tester/0.5.1/diesel_pg_tester/

[ Parent | on HN ]

Re:Oracle vs. PostgreSQL: First Glance by ajuc on Monday May 04, 2020 @10:59AM (#23068826)

> Oracle evangelists

There is such a thing?

> it's useless and if you need it, you are not testing your scripts properly

Is that also their response for static typing and constraints on database :) ?

[ Parent | on HN ]

Re:Oracle vs. PostgreSQL: First Glance by nordsieck on Monday May 04, 2020 @12:14PM (#23069813)

>> Oracle evangelists

> There is such a thing?

Tech evangelist is a common job title.

[ Parent | on HN ]

Re:Oracle vs. PostgreSQL: First Glance by ajuc on Monday May 04, 2020 @12:18PM (#23069870)

I thought X evangelism is when you aren't paid, like with open source. If you are paid you're just a salesman.

[ Parent | on HN ]

Re:Oracle vs. PostgreSQL: First Glance by NickNameNick on Tuesday May 05, 2020 @05:56AM (#23078258)

I've seen 'Developer evangelist' as a job title.

[ Parent | on HN ]