Latest posts from Steve Pousty
Using PostgreSQL to Shape and Prepare Scientific Data
Today we are going to walk through some of the preliminary data shaping steps in data science using SQL in Postgres.
9 min read
R Predictive Analytics in Data Science Work using PostgreSQL
Today we are going to finish up by showing how to use that stored model to make predictions on new data. By the way, I did all of the Postgres work for the entire blog series in Crunchy Bridge. I wanted to focus on the data and code and not on how to run PostgreSQL.
8 min read
Using R in Postgres for Logistic Regression Modeling
Greetings friends! We have finally come to the point in the Postgres for Data Science series where we are not doing data preparation. Today we are going to do modeling and prediction of fire occurrence given weather parameters… IN OUR DATABASE!
8 min read
Using PL/pgSQL to Calculate New Postgres Columns
In our last blog post on using Postgres for statistics, I covered some of the decisions on how to handle calculated columns in PostgreSQL. I chose to go with adding extra columns to the same table and inserting the calculated values into these new columns. Today’s post is going to cover how to implement this solution using PL/pgSQL.
8 min read
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
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
Iterators in PostgreSQL with Lateral Joins
When the keyword LATERAL is added to your join the output will now apply the right hand part of the join to every record in the left part of the join.
4 min read
Composite Primary Keys, PostgreSQL and Django
Learn how to use composite primary keys in a PostgreSQL many-to-many relationship table while building a Django application.
8 min read
Using the Crunchy PostgreSQL Operator with PostGIS
How to easily spin up PostGIS in your Kubernetes or OpenShift cluster using the PostgreSQL Operator.
10 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
Using PostgreSQL for JSON Storage
Learn how to use PostgreSQL for all your JSON needs plus free learning resources.
4 min read
Set Up and Run PostgreSQL Operator Client (pgo) on Windows
How to prepare your Windows computer to talk to the Crunchy PostgreSQL Operator for Kubernetes.
6 min read
