7 ms·
Our company spent US$50K on an Oracle database and my boss forbade me from using triggers, because he wanted the application to be database independent. Never m
by forinti 17y ago
Our company spent US$50K on an Oracle database and my boss forbade me from using triggers, because he wanted the application to be database independent. Never mind that we used Oracle syntax in our queries.
- tt 17y agoAlso: not allowed to use Oracle's native date data type, and no foreign key constraints allowed!
- sunkencity 17y agoHow often does one actually switch between databases? I can see that yeah, some projects have a very slight change of migrating from mysql or postgres to oracle if they are really successful. But for many projects, the time and pain spent on using a database abstraction layer, or even worse building one is a total waste of time. Not that I mind using a well written ORM like active record, the benefits from that doesn't come mostly from that it's database agnostic.
- GrandMasterBirt 17y agoWhen you have many clients each with a diff database. All other times the argument is moot.