The previous two parts have looked at some solutions offered by triggers. Let’s look now at some wishful triggers solutions, which are currently unavailable because of triggers limitations.
Triggers Use Case Compilation, Part I
Triggers Use Case Compilation, Part II
Limitations and wishful features
Triggers are slow
The overhead of adding triggers is usually an even breaker. But I would [...]
In Triggers Use Case Compilation, Part I, I’ve demonstrated some triggers use scenarios.
We continue our examples of triggers usage.
Counters and aggregations bookkeeping
Consider the City table: each city belongs to a certain country. Some questions we may be interested in are:
How many cities are there per country?
What’s the sum of cities population per country?
What’s the population [...]
I’ve run by quite a few triggers lately on production systems. In previous posts, I’ve written about problems solved with triggers. So here’s a compilation of some solutions based on triggers; and some problems which are not (yet?) solvable due to current triggers limitations.
Triggers can be used to:
Maintain integrity
Enhance security
Enhance logging
Assist with archiving
Restrict table size
Manage [...]
Web applications face constant exploitation attempts. Those with a user base must keep their users’ private data, well… private.
While the MySQL security model allows restricting users access to databases, tables and even columns, it has no built in feature for restricting the rows access within the given table.
One cannot allow a user to only update [...]
There’s a lot of buzz around memcached. memcached is widely used, and has clients for many programming languages and platforms. TangentOrg have developed a memcached client in the form of MySQL UDFs (User Defined Functions).
I wish to discuss the memcached functions for MySQL: if and how they should be used.
Disclaimer: I do not work with [...]