News for hackers. Stuff that matters.
Re:Vectors Are the New JSON in PostgreSQL by riku_iki on Wednesday June 28, 2023 @01:33PM (#36509760)
> Right, but they can (and do) also prepackage ML inference services that don't involve Postgres.

but then you would need some dataprocessing/warehousing infra integrated to produce dataset for inference and then do something with inference results. Having one db with everything packaged would reduce complexity significantly.

Re:Vectors Are the New JSON in PostgreSQL by hot_gril on Wednesday June 28, 2023 @02:54PM (#36510868)
I was just looking at inference, meaning you need some separate infra to do the training either way. If the DB does the training too, then yeah. I think we're pretty far from that, and Postgres by itself might not be the platform for it. There are platforms with SQL-like interfaces that use databases underneath, but there's a lot happening on top.
Re:Vectors Are the New JSON in PostgreSQL by riku_iki on Wednesday June 28, 2023 @03:39PM (#36511542)
I think it is all few months work project, given you can run any arbitrary py/c code in extension in postgres, so it is a matter of data wrangling: convert pg table to recordio, run train/inference, convert results back to pg table, wrap logic into pg/py or pg/c functions.
Re:Vectors Are the New JSON in PostgreSQL by tarasglek on Friday June 30, 2023 @03:11AM (#36531537)
Postgresml.org extension can do training. End to end ml workflows within postgres... Posting this as a happy user.