Easy Postgres Installation and Setup on Windows with Chocolatey
2020-02-15
This post will be demonstrating how to easily install, configure and update a PostgreSQL instance on Windows, specifically via the Chocolatey package manager. Yes, you can always take the old school route by going to the official Postgres website, and download an installer, followed by clicking through a wizard a bunch of times. However, using a package manager makes it easier to install, and much easier to update regularly. Installing Chocolatey To install Chocolatey, you will first need to open a Powershell terminal, specifically in admin mode.…more
Integrating JSONB Data into Django Projects
2020-02-13
This post follows up on my earlier post about storing json data in Postgres. In this article, I will be going over how to integrate the same JSONB data I used in that post with a Django web application. Modeling the Data Modeling JSONB data with Django’s ORM tool is rather easy, as the framework has built in support for this in the django.contrib module. Therefore, we would model our data like this in our models.…more
Storing and Querying JSON Data in PostgreSQL
2020-01-22
I recently started exploring how to store JSON data in a traditional relational database management system (RDBMS), rather than a dedicated form of JSON/document storage, like MongoDB. While I could write a lot more about the problems with MongoDB, that’s not what I want to do here. Instead, I want to focus primarily on how to store and query JSON in PostgreSQL. However, I should note that PostgreSQL is not the only RDBMS that supports JSON storage.…more
Migrating Data to the Cloud with Python
2020-01-16
In the past year, or so, I have been experimenting with writing my own custom ETL programs in Python. Among the functionality that I included was extracting data from a local Postgres database, and migrating to a Postgres database in the cloud. The Reasoning While I’m aware that platforms-as-a service (PaaS) like AWS, and Azure provide their own services for this. Nevertheless, I opted to implement my own solution for data migration(s).…more