Show HN: PostgresML, now with analytics and project management • Hacker News Board

Re: Show HN: PostgresML, now with analytics and project management

#71

Post by prometheon1 » Tue, May 03, 2022, 10:11 AM UTC

craigkerstiens wrote: post #27

montanalow wrote: post #18

Earlier quoted context omitted.

We can’t control the extensions RDS allows to be installed, and they are historically conservative. Lev and I do have some fairly extensive experience with replication patterns to Postgres instances running in EC2. Foreign data wrappers are also an option, and depending on workload may be a good horizontal scaling strategy in addition.

I just gave it a try to install on Crunchy Bridge [1], disclaimer I work at Crunchy Data. I did this as a standard user vs. anything special about access. I got quite close, but looks like I'm limited by Python version, we give you plpython3u with Python 3.6. Is there any chance of supporting an earlier 3.x version? If so I'm pretty sure could give a guide on how to self-install on top of us. [1] https://www.crunchyd…

Just in case you were not aware, Python 3.6 reached end of life ~4 months ago: https://endoflife.date/python

Re: Show HN: PostgresML, now with analytics and project management

#72

Post by wodenokoto » Tue, May 03, 2022, 10:27 AM UTC

Is this a competitor to bigquery autoML or to something like kubeflow?

Re: Show HN: PostgresML, now with analytics and project management

#73

Post by xpe » Tue, May 03, 2022, 12:14 PM UTC

xpe wrote: post #52

I wonder if/how a PostgreSQL plug-in can provide an optimal mix of computing and storage resources for varying machine learning workloads.

Anyone care to reframe the question or improve it?

Re: Show HN: PostgresML, now with analytics and project management

#74

Post by montanalow » Thu, May 05, 2022, 1:12 AM UTC

kipukun wrote: post #31

Neat project. Any roadmap for cross-validation support (GridSearchCV and friends)?

Landed a PR to enable GridSearchCV and RandomSearchCV. https://github.com/postgresml/postgresml/pull/83

Re: Show HN: PostgresML, now with analytics and project management

#75

Post by ttfkam » Thu, May 05, 2022, 12:57 PM UTC

LunaSea wrote: post #14

Do you plan on adding support for managed PostgreSQL services like RDS in the future?

Amazon Aurora already has ML extensions for connecting to AWS SageMaker and AWS Comprehend. I doubt they'd add another, especially one they didn't write and isn't integrated with their existing lineup. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide...

Re: Show HN: PostgresML, now with analytics and project management

#76

Post by Abishek_Muthian » Thu, May 05, 2022, 1:52 PM UTC

Congratulations on the launch!

This is the most exciting ML related project I've seen in a while, Mainly because the barrier for entry seems low as anyone with PG database could apply a model on them using PostgresML if I understood the premise correctly.

Most of the comments here seems to regarding separating the compute from the database machine which it seems isn't possible right now with PostgresML, But the GitHub reads at the start:

> The system runs Postgres with the pgml-extension installed on port 5433 by default, *just in case you happen to be running Postgres already*:

  $ psql -U postgres -h 127.0.0.1 -p 5433 -d pgml_development

I think the second part needs to be clarified better, Is it installing PGML extension on a machine running a existing PG database and connecting to it (or) does it mean just starting the postgres session of the PGML docker package?