3 ms·
> 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 tr
by hans_castorp 6y ago
> 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
- ajuc 6y ago> 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 :) ?
- nordsieck 6y ago>> Oracle evangelists > There is such a thing? Tech evangelist is a common job title.
- ajuc 6y agoI thought X evangelism is when you aren't paid, like with open source. If you are paid you're just a salesman.
- NickNameNick 6y agoI've seen 'Developer evangelist' as a job title.
- hathawsh 6y agoTransactional 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/ https://docs.rs/diesel_pg_tester/0.5.1/diesel_pg_tester/