Connecting Docker to localhost PostgreSQL on an Ubuntu 18.04 Host

It is possible to access a service such as PostgreSQL on the localhost of an Ubuntu/Linux host machine from inside of a docker container with a bit of configuration. Networking Configuration First thing here is to understand that there are different docker networking modes, and the method you use to connect to a host service from inside the docker container will differ depending on the networking mode of the container.
Read more →

Date Handling for Postgres, JSON/API, and JavaScript/Client

The following is a write-up I did while working on the ScoutRed ETL pipeline and attempting to find the best way to serialize and store dates when the data source comes primarily from paper-form based data where we don’t necessarily know (or want to know) the timezone or locality. A date is defined here as an entity which includes year, month, and day, but does not include any information about the time or timezone.
Read more →