Preparing data for machine learning in PostgreSQL
Most of the code related to machine learning available today is overloaded. Why not prepare the data in SQL? It's easier & more flexible.
Finding patterns in timeseries: A poor man's method
UPDATED Aug 2023: Learn a trick in PostgreSQL timeseries analysis: Look for trends or known patterns in data - encode timeseries as strings.
Forking databases - the art of copying without copying
I received a question about how to fork PostgreSQL databases like you can do on Heroku. As I did not […]