nowfound

AI · September 18, 2020

PostgreSQL and Machine Learning - step-by-step python tutorial

Learn how to combine PostgreSQL and machine learning workflows in Python, from data extraction to model training and analysis.

PostgreSQL and Machine Learning - step-by-step python tutorial launched on September 18, 2020 with 6 votes, #1,359 of 3,898 launches that month and more than 50% of that year's launches. The site was still online in September 2026, 6 years on.

What it does

I will show you how to apply Machine Learning algorithms on data from the PostgreSQL database to get insights and predictions. I will use an Automated Machine Learning (AutoML) supervised . It is an open-source python package. Thanks to AutoML I will get quick access to many ML algorithms: Decision Tree, Logistic Regression, Random Forest, Xgboost, Neural Network. The AutoML will handle feature engineering as well. I will show you python code snippets that can be reused to integrate Machine Learning with PostgreSQL as a part of the ETL pipeline. I will use Portugese Bank Marketing dataset ( bank_cleaned.csv file). This dataset is about the marketing campaigns, which aim to promote financial…from mljar.com

Does a similar job

all alternatives →
  • PN
    PostgresML, now with analytics and project management2022 · postgresml.org · ▲444

    We've been hard at work for a few weeks and thought it's time for another update. In case you missed our first post, PostgresML is an end-to-end machine learning solution, running alongside your favorite database. This time we have more of a suite offering: project management, visibility into the datasets and the deployment pipeline decision making. Let us know what you think! Demo link is on the page, and also here: https://demo.postgresml.org

  • MindsDB2022 · ▲235

    In-database machine learning

  • PostgresML2023 · postgresml.org · ▲106

    You know Postgres, now you know machine learning

  • PostgresML, end-to-end machine learning in your favorite db2022 · github.com · ▲15

    Postgres with GPUs for ML/AI apps. Contribute to postgresml/postgresml development by creating an account on GitHub.

  • PgQueuer – Transform PostgreSQL into a Job Queue2024 · github.com · ▲376

    PgQueuer is a Python job queue that uses PostgreSQL for everything — queue storage, locking, notifications. No Redis, no RabbitMQ, no separate broker to operate. If your app already has Postgres, you already have the broker. After ~2 years and 26 minor releases, 1.0 ships today as the first stable release. Strict semver from here on. Thanks to everyone who contributed and left feedback!

  • 1R
    1M rows/s from Postgres to Python2016 · magic.io · ▲296

More ai this month

the category →
  • Video model that turns script into viral social media videos

    AI · 19d ago · spira.ai

  • The browser where Claude Code and Codex work beside you

    AI · 19d ago · rill.love

  • Kolibri is Aleph Alpha

    AI · 20d ago · tej.as

  • Paintings by AI models: programs run through a simulation of oil paint.

    AI · 22d ago · stillwet.art

  • Beam.win▲378

    Run AI agents on one Mac and use its windows on another

    AI · 5d ago · beam.win

  • Route requests to the right LLM for cost, latency & quality

    AI · 23d ago · fastrouter.ai

Source: Show HN post ↗

Launched alongside, September 2020

the whole month →
  • Synthesia▲943

    Generate professional-looking AI videos from text in minutes

    AI · 2020 · synthesia.io

  • IdeasAI▲801

    OpenAI-powered startup idea generator

    AI · 2020 · ideasai.com

  • Tables helps teams easily track & automate tasks

    Work · 2020 · tables.area120.google.com

  • LS

    Almost eight years ago I launched an online “Linux sysadmin course for newbies” here at HN. It was a side-project that went well, but never generated enough money to allow me to fully commit to leaving the Day Job. After surviving the Big C, and getting made redundant I thought I might improve and relaunch it commercially – but my doctors are a pessimistic bunch, so it looked like I didn’t have the time. Instead, I rejigged/relaunched it via a Reddit forum this February as free and open - and have now gathered a team of helpers to ensure that it keeps going each month even after I can’t…

    Commerce · 2020

  • A pool party in your pocket

    Life & fun · 2020 · cellular.poolside.fm

  • 65 solo founders making $370,000/mo

    Life & fun · 2020