Blog


Npgsql Insert Time Without Timezone

I’m just getting started with Npgsql for .NET Core Entity Framework and I ran into some trouble trying to do an insert into a Postgres table with a time data type. I initially tried to use a DateTime object, as worked with the date data type, but that didn’t work. The documentation said to use a TimeSpan, but I didn’t know what to span. Here’s what I did to get it to work.




PostgreSQL Quickstart

I’ve used mostly MySQL in the past, but a recent project called for working with PostgreSQL. The most immediate difference was that databases and schemas were semantically different. I took a liking to the DBMS – database management system, and plan to be using it in future projects. So, here I will notate some commands to quickly get up and running with PostgreSQL.




Vue.js v-for set Option Selected

I recently started working with Vue.js. I found it to be quite a well engineered product and a well designed framework. In the framework, one can use a v-for attribute within markup to to loop over data stored in their view model and with each iteration generate more markup. I was utilizing the v-for to loop over data to create <options> for a drop-down menu – a common usage – and I wanted to set a specific option to be selected.




MySQL and Python3

MySQL and Python Logos

I’m using Python more and more so it’s not surprising that recently the need arose to connect to and insert into a MySQL database. I was using (and usually do) Python3, and I ran into a couple of issues in the begining. This post will document those issues and the solutions I found to get MySQL and Python3 to work together.




Writing Web Scraped HTML to a File

I was working on a project for a client where I needed to scrape data from a Web page. I wanted to save the page to a file so that I wouldn’t be making requests to the server hosting the page each time I wanted to test my code. I was using Python3 and the Requests library. When attempting to perform the write to a file, I ran into encoding issues. This task was not as straightforward as I first imagined.




Statistics – Probability Density Function and Z Table

It turns out that normally distributed values are quite important in statistics. Not only because the pattern is remarkably common, the central limit theorem enables statisticians to infer conclusions about how a given treatment will affect a given population. To make such inferences, we need to learn about the Probability Density Function and a useful shortcut: the Z Table.