Using SQL With JavaScript Part 1 – Installing SQL, Node.js, Creating a Connection and Creating A Database

A little while ago I completed a SQL database course via FutureLearn (it's a free course if you want to learn some SQL) to brush up on my SQL knowledge. Today I am going to use Javascript (via Node.Js) to connect to SQL and create a database. Installing SQL I am using Raspberry Pi OS … Continue reading Using SQL With JavaScript Part 1 – Installing SQL, Node.js, Creating a Connection and Creating A Database

The Raspberry Pi Pico / Pimoroni Pico Display

Raspberry Pi Pico and Pimoroni Pico Display

It's January 2021 and the awesome folks over at Raspberry Pi have announced a new device, a micro controller called the Raspberry Pi Pico. The full details / news about the device can be found at: https://www.raspberrypi.org/blog/raspberry-pi-silicon-pico-now-on-sale/ . I grabbed one from the excellent Pimoroni and with speedy delivery from Royal Mail it arrived over … Continue reading The Raspberry Pi Pico / Pimoroni Pico Display

Tackling Fractions With Python

Python function to run call on other functions depending on user input

Fractions, not something I've really looked at since my school days. However with home schooling currently taking place here in the UK due to another Coronavirus lockdown, it is something that I've been refreshing my knowledge on this week. Note: https://www.calculatorsoup.com/calculators/math/fractions.php provides an online calculator to help with fractions. The site also provides the formulas … Continue reading Tackling Fractions With Python

Using An API Call To Make Multiple Grafana Users (Python)

A little while ago I looked at using Grafana on a Raspberry Pi ( https://geektechstuff.com/2020/06/25/grafana-prometheus-and-node-exporter-on-raspberry-pi-via-ansible-raspberry-pi-and-linux/ ), today I created a quick Python script to create new Grafana user accounts using the Grafana API. Why Use The API? Grafana does have a graphical web based interface for creating users, and if creating a single user account … Continue reading Using An API Call To Make Multiple Grafana Users (Python)

Real World Python – Book Review (Python)

Front cover of Real World Python Book

However, I also have periods where a form of writer’s block kicks in and wonder, “What else could I use Python for?”. As if by magic, Lee Vaughan has answered with “Real World Python” which contains examples of real-world problems being answered by Python and then expands on the solutions with fun challenge projects and further reading.