Feature Description

There is a feature in SQLite called "Strict Tables" (https://www.sqlite.org/stricttables.html).

It would great to add the possibility to globally or directly in the entity enable table creation with strict mode set.

The Solution

It could be added as option in @Entity like @Entity({ strict: true }).

Also, it would be nice to enable it by default when creating the DataSource like new DataSource({ strictTables: true, ... });

Considered Alternatives

Modifying the migrations manually would be an alternative. I did not find a solution when setting synchronize: true in the DataSource constructor though.

Additional Context

No response

Relevant Database Driver(s)

• aurora-mysql
• aurora-postgres
• better-sqlite3
• cockroachdb
• cordova
• expo
• mongodb
• mysql
• nativescript
• oracle
• postgres
• react-native
• sap
• spanner
• sqlite
• sqlite-abstract
• sqljs
• sqlserver

Are you willing to resolve this issue by submitting a Pull Request?

Yes, I have the time, but I don't know how to start. I would need guidance.