On Mon, Mar 8, 2021, at 19:46, Joel Jacobson wrote:
> However, for certain tasks, when a high-level language is preferred,
> and when the raw performance of C isn't necessary, then maybe SQL/PLpgSQL
> could be a serious alternative to Perl?
Before we had jsonb, this would have been totally unrealistic.
But with jsonb, I think we actually have complete coverage of Perl's data types:
Perl array <=> jsonb array
Perl hash <=> jsonb object
Perl scalar <=> jsonb string/boolean/number
I've been using jsonb with great success for code generation.
ASTs are nicely represented as nested jsonb arrays.
/Joel