Bring Machine Learning to PostgreSQL with BigML

As of late, we've been using PostgreSQL in BigML quite a lot, and so do some of our customers. We love the features that they are bringing in the next release (which is in Beta as I write) and particularly the one that allows creating what they call generated columns. In this post, I'll be explaining what these generated columns are and how they can use the Machine Learning models in BigML to fill in any numeric or categorical field in your table. A generated column is a special column that is defined as the result of a computation that involves any of the values of the regular columns in the row. Say you have a table of contacts in your database where you fill in their first and last name plus their email.