Code Monkey home page Code Monkey logo

wdshin / postgresml Goto Github PK

View Code? Open in Web Editor NEW

This project forked from postgresml/postgresml

0.0 0.0 0.0 178.47 MB

PostgresML is an end-to-end machine learning system. It enables you to train models and make online predictions using only SQL, without your data ever leaving your favorite database.

Home Page: https://postgresml.org

License: MIT License

Shell 0.93% JavaScript 7.13% Python 18.22% Rust 51.42% CSS 7.71% HTML 11.84% PLpgSQL 2.08% Dockerfile 0.67%

postgresml's Introduction

PostgresML

Simple machine learning with PostgreSQL

CI Join our Discord!

Train and deploy models to make online predictions using only SQL, with an open source extension for Postgres. Manage your projects and visualize datasets using the built in dashboard.

PostgresML in practice

The dashboard makes it easy to compare different algorithms or hyperparameters across models and datasets.

PostgresML dashboard

See it in action โ€” demo.postgresml.org

What's in the box

See the documentation for a complete list of functionality.

All your favorite algorithms

Whether you need a simple linear regression, or extreme gradient boosting, we've included support for all classification and regression algorithms in Scikit Learn and XGBoost with no extra configuration.

Managed model deployements

Models can be periodically retrained and automatically promoted to production depending on their key metric. Rollback capability is provided to ensure that you're always able to serve the highest quality predictions, along with historical logs of all deployments for long term study.

Online and offline support

Predictions are served via a standard Postgres connection to ensure that your core apps can always access both your data and your models in real time. Pure SQL workflows also enable batch predictions to cache results in native Postgres tables for lookup.

Instant visualizations

Run standard analysis on your datasets to detect outliers, bimodal distributions, feature correlation, and other common data visualizations on your datasets. Everything is cataloged in the dashboard for easy reference.

Hyperparameter search

Use either grid or random searches with cross validation on your training set to discover the most important knobs to tweak on your favorite algorithm.

SQL native vector operations

Vector operations make working with learned emebeddings a snap, for things like nearest neighbor searches or other similarity comparisons.

The performance of Postgres

Since your data never leaves the database, you retain the speed, reliability and security you expect in your foundational stateful services. Leverage your existing infrastructure and expertise to deliver new capabilities.

Open source

We're building on the shoulders of giants. These machine learning libraries and Postgres have recieved extensive academic and industry use, and we'll continue their tradition to build with the community. Licensed under MIT.

Quick Start

  1. Clone this repo:
$ git clone [email protected]:postgresml/postgresml.git
  1. Start dockerized services. PostgresML will run on port 5433, just in case you already have Postgres running:
$ cd postgresml && docker-compose up
  1. Connect to PostgreSQL in the Docker container with PostgresML installed:
$ psql postgres://postgres@localhost:5433/pgml_development
  1. Validate your installation:
pgml_development=# SELECT pgml.version();
 
 version
---------
 0.8.1
(1 row)

See the documentation for a complete guide to working with PostgresML.

postgresml's People

Contributors

levkk avatar montanalow avatar samdobson avatar dependabot[bot] avatar soggy-mushroom avatar changyaochen avatar dpereira avatar garrrikkotua avatar jonatas avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.