I have a project I’m working to to gather and analyse economic data. To get the daily gold spot price, I’m going to use goldpricez.com.
They provide a simple RESTful API serves up gold price data. You can check them out at the following link.
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. Continue reading
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. Continue reading
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. Continue reading
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. Continue reading
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.