3 ms·
> SQL databases should be conservative in what they accept. Once you've inserted crap into the DB, it's hard to fix it. You can make your schema very light and
by fail2fail2ban 10y ago
> SQL databases should be conservative in what they accept. Once you've inserted crap into the DB, it's hard to fix it.
You can make your schema very light and accepting almost like NoSQL which is how you get into the situation you described; the solution is to use stricter schema. That and it helps to hire a full time data engineer/administrator.
> Using NoSQL as a fast cache
I'd rather use caching technology, specifically designed for caching, like Redis or Varnish or Squid.