COPY in PostgreSQL: Moving data between servers
More than copy data between a file and a table: a pretty cool feature was added to PostgreSQL. You can send data directly to the UNIX pipe.
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 […]
