Web Development (9)

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.

Group not Showing in SharePoint List

I recently had an issue working on a SharePoint list dealing with a User or Group column. When the list would initially load, the value for the column (i.e. the group name) was displayed but after a moment it would disappear. I found the solution by using JSON formatting to format the column values.

Installing Nodejs for Linux

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