Remove code clean1.sql
article thumbnail

Database triggers to clean text inputs

Derek Sivers

So no matter what code is inserting or updating, a database trigger will sanitize it before saving. create table people ( id serial primary key, name text, code text ); create table emails ( id serial primary key, person_id integer not null references people(id), email text ); download code. dr.l@jmlim.com download code.

40