Notes on TypeORM and Lessons Learned DBA
- TypeORM seems to have some opinionations that are pretty unfamiliar. While it may seem advantageous to use them, it's not advantageous to from a 3 year view. When you build a DB it should always be prepared for inevitable change. It's not unforeseeable that we at some point get integrated into a bigger company.
- PostgreSQL has some awesome new features(plugins, jsonb aggregators); however, it's always my best practice to right as I possibly can to ther SQL-92 spec(SQL - ANSI (American National Standards Institute) SQL (Standard|Reference|Specification) - SQL (92|99|2003|2011))
- SQL-92 is primarily what most base database connectors connect to. There are subtle differences to each kind of architecture for example:
- mssql TOP:
SELECT TOP 10 * FROM users;
- mssql TOP:
- Postgres LIMIT