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
Fun with Gravitational Physics and Python
2020-02-03
While reading about how my favorite programing language (Python) was used to develop the first ever image of a black hole, I felt inspired to use the language to do some gravitational physics of my own. Mind you, I am not a physicist, nor do I have an extensive mathematical background, so I certainly was not using Python to do anything that was terribly complicated. Instead, I was using it to do more simple, but still productive (not to mention fun) calculations.…more
Adventures in Containerizing Databases
2020-01-28
I recently made a breakthrough by finally getting a handle on containerizing databases with Docker. If you don’t already know, Docker is software that allows you to run software in isolated, virtual environments that contain all the necessary dependencies that said software needs to run. Therefore, Docker can considerably simplify both setting up development environments, and deploying software to production. I was making a similar face when I got this all worked out…more