News for hackers. Stuff that matters.

A comment on Red Hat Satellite to standardize on PostgreSQL backend. Parent comment

Re:Red Hat Satellite to standardize on PostgreSQL backend by int_19h on Thursday February 14, 2019 @01:25AM (#19160016)
> The DB may only care that it's UTF and max 20 chars. But the system requires more validation than that.

Are you familiar with SQL constraints, triggers, user-defined functions, stored procedures?..

[ Parent | on HN ]
Re:Red Hat Satellite to standardize on PostgreSQL backend by garyclarke27 on Thursday February 14, 2019 @03:18AM (#19160418)
Yes + Postgres has Domains which are very nice, especially if you use only Functions for data insert (which i do) This gives you more granularity, than a domain on a Column. Domians are like Dependent Types, offering very fine grained control, enforced by RegEx, functions, enums, even lookup functions are ok so long as lookup tables are stable.
[ Parent | on HN ]
Re:Red Hat Satellite to standardize on PostgreSQL backend by bushin on Thursday February 14, 2019 @04:48AM (#19160764)
lmao, “my schema is my app layer”.
[ Parent | on HN ]