Machine Learning with LightGBM and Python

10

LightGBM Models with PostgresML

In this chapter, we’ll look at a unique MLOps platform called PostgresML. PostgresML is a Postgres database extension that allows you to train and deploy ML models using SQL.

PostgresML and SQL are a significant departure from the scikit-learn style of programming we’ve used throughout this book. However, as we’ll see in this chapter, performing ML model development and deployment at the database level has significant advantages regarding data movement requirements and inferencing latency.

The main topics in this chapter are as follows:

• An overview of PostgresML
• Getting started with PostgresML
• A customer churn case study with PostgresML and LightGBM

Technical requirements

This chapter includes practical examples ...