Posts about Fun with SQL
Replacing Lines of Code with 2 Little Regexs in Postgres
For those of you who have a bad taste in your mouth from earlier run-ins with regexs, this will be more use case focused and I will do my best to explain the search patterns I used.
7 min read
Using Postgres for Statistics: Centering and Standardizing Data
Today we are going to examine methods for calculating z-scores for our data in the database. We want to do this transformation because, when we carry out logistic regression we want to be able to compare the effects of the different factors on fire probability.
8 min read
Election Night Prediction Modeling using PL/R in Postgres
I was sent a link to a tweet regarding election night forecasting and of course the default questions was... could be run under PL/R inside Postgres. Like about everything else at Crunchy Data we believe all things are better with Postgres.
10 min read.png)
Using PostgreSQL and SQL to Randomly Sample Data
In the last post of this series we introduced trying to model fire probability in Northern California based on weather data. We showed how to use SQL to do data shaping and preparation.
7 min read
Joins or Subquery in PostgreSQL: Lessons Learned
Today's post is going to work through the advice I received on using joins rather than subqueries.
7 min read
Building a recommendation engine inside Postgres with Python and Pandas
Learn how you can leverage Python and Pandas from directly inside PostgreSQL to build your own recommendation engine.
5 min read
Announcing the Crunchy Data Developer Portal
Crunchy Data is proud to announce the initial release of our application developer portal. An awesome team has been working behind the scenes to bring together this website to help application developers find all their Postgres needs in one place.
5 min read
Quick and Dirty Address Matching with LibPostal
Learn how to do address normalization with PostgreSQL and PostGIS to provide a standard set of addresses for consistent searches over a data set.
8 min read
