2 ms·
> But people forget the major reason for DB enforcement is multiple application on one database. While that may be the major reason there are other reasons tha
by 7steps2much 5y ago
> But people forget the major reason for DB enforcement is multiple application on one database.
While that may be the major reason there are other reasons that are just as valid. Such as multiple developers working on a single application, loading "wrong" values into the database for example.
If SQLite enforced typing it would be a great alternative for me, but the way it is right now it is "nice", but not nice enough to beat PostgreSQL in any way unless I need an embedded DB. At least in my opinion.
- massysett 5y agoAll you have to do is put a column constraint on there. CREATE TABLE t ( intcol CHECK (typeof(intcol) = ‘integer’));
- jhgb 5y ago> If SQLite enforced typing it would be a great alternative for me, but the way it is right now it is "nice", but not nice enough to beat PostgreSQL in any way unless I need an embedded DB. At least in my opinion. You still have the option of embedding Firebird if you want enforced types AND embedded operation.