PostgresML comes with a web app to provide visibility into models and datasets in your database. If you're running our Docker container, you can view it running on http://localhost:8000/.
Generate example data
The test suite for PostgresML is composed by running the SQL files in the examples directory. You can use these examples to populate your local installation with some test data. The test suite only operates on the
pgml schema, and is otherwise isolated from the rest of the PostgresML installation.
psql -f pgml-extension/sql/test.sql \ -P pager \ postgres://firstname.lastname@example.org:5433/pgml_development
Projects organize Models that are all striving toward the same task. They aren't much more than a name to group a collection of models. You can see the currently deployed model for each project indicated by a star.
Models are the result of training an algorithm on a snapshot of a dataset. They record metrics depending on their projects task, and are scored accordingly. Some models are the result of a hyperparameter search, and include additional analysis on the range of hyperparameters they are tested against.
A snapshot is created during training runs to record the data used for further analysis, or to train additional models against identical data.
Every deployment is recorded to track models over time.
Join our Discord and ask us anything! We're friendly and would love to talk about PostgresML.
Try It Out
Try PostresML using our free managed cloud. It comes with 5 GiB of space and plenty of datasets to get you started.