[makkesk8]

Awesome work! A killer feature of sqlite that I would love to see in pglite would be javascript window functions.

[isoprophlex]

Huh, can you do that? I can't google anything just now, got a link to some docs about js window functions in sqlite?! Sounds very powerful

[AlexErrant]

Maybe they're talking about https://www.sqlite.org/appfunc.html where you can define a window fn in the (perhaps JS) app via `sqlite3_create_window_function()`.

[samwillis]

This is high on my list, I have a few ideas how to do it, one being a "PL/JS" extension that calls out to the host JS environment to run JS functions.

[AlexErrant]

FYI Turso does it with WASM https://turso.tech/blog/webassembly-functions-for-your-sqlit...

[isoprophlex]

I think PG is relatively ideal for that. In a classical data warehousing/ETL context, I've called python directly from inside PG, which has its quirks but is pretty doable, all in all...

https://www.postgresql.org/docs/current/plpython.html