tools (8)

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.

Installing Nodejs for Linux

This post documents the steps to install nodejs on a Linux system using console (terminal) commands.

Printing ASP.NET Debugging Output

For ASP.NET development, I use Microsoft’s Visual Studio (IDE). In any development environment, I regularly use print statements to discover and verify my programming’s actual functionality. In Java, simply printing to the console (with System.out.println) achieves this aim, but with ASP.NET and Visual Studio I tried the same approach (using Console.WriteLine) to no avail.