[HN Gopher] PLJS - JavaScript Language Plugin for PostreSQL
       ___________________________________________________________________
        
       PLJS - JavaScript Language Plugin for PostreSQL
        
       Author : alonp99
       Score  : 21 points
       Date   : 2023-07-23 19:43 UTC (3 hours ago)
        
 (HTM) web link (github.com)
 (TXT) w3m dump (github.com)
        
       | tantalor wrote:
       | Typo in headline
        
         | codetrotter wrote:
         | PostreSQL. People from Spainish speaking countries would love
         | it!
        
       | cyanydeez wrote:
       | I hope this supplants the v8 standard since trying to build v8
       | breaks every release, which makes plv8 no longer packaged with
       | typical releases.
        
       | jsdwarf wrote:
       | Use cases? Examples?
        
         | ttfkam wrote:
         | Off the top of my head:
         | 
         | The ability to do advanced regexp replacements with a function
         | parameter in JS far outstrips anything native in Postgres.
         | 
         | Array manipulation, reordering, and deduplication are worlds
         | easier in JS than native Postgres.
         | 
         | Manipulating byte buffers in JS are much faster and more
         | flexible than introspecting bytea columns in native Postgres.
         | 
         | JSON parsing and object transformation are much easier, faster,
         | and clearer than native Postgres (even with the recent jsonb
         | improvements).
        
         | nattaylor wrote:
         | (I haven't tried pljs but I think this is relevant) I've used
         | JavaScript UDFs in Snowflake for array processing and also dumb
         | POCs things like importing an entire library for useragent
         | parsing
        
       ___________________________________________________________________
       (page generated 2023-07-23 23:00 UTC)