3 ms·
> Stored procedures, triggers and views are banned. So... NoSQL? I'm only half-joking -- I find it strange how people will use an SQL DBMS, and yet choose not
by e12e 12y ago
> Stored procedures, triggers and views are banned.
So... NoSQL? I'm only half-joking -- I find it strange how people will use an SQL DBMS, and yet choose not to use the main features. Model, Normalize/refactor, then apply views/triggers/stored procedures to present a simple "API" (or maybe just "view") of your datamodel to the application?
If you don't use the DBMS for modelling the data, do you really need it for storing your data (obviously, one valid answer is "no" -- see "NoSQL-movement", Object DMBS, Document DBs etc...).
- sudowhodoido 12y agoActually we use both. Both have their advantages so we use SQL Server and Redis. The data model is what we're exposing, not the table model.