3 ms·
Database stored procedures almost invariably involve writing Python (or whatever) inside of SQL/DDL. Database change management systems (e.g. Liquibase) will of
by radiowave 12y ago
Database stored procedures almost invariably involve writing Python (or whatever) inside of SQL/DDL. Database change management systems (e.g. Liquibase) will often involve writing chunks of SQL inside of XML/JSON/YAML. More generally, configuration files often involve string parameter values that are actually expressions in some subsystem or related system.
- imanaccount247 12y ago>Database stored procedures almost invariably involve writing Python (or whatever) inside of SQL/DDL What? They can involve that, but it is very variably. I never do that. I find python, perl, etc are much worse than plpgsql.
- radiowave 12y agoSorry, good point. In my head I was thinking "except when using the native procedural language", but it appears I didn't get around to actually typing that bit.