I like having this website (www.geektechstuff.com) hosted, but at times I also need a local website for testing whatever I’m looking at at the time (e.g. JavaScript). Previously I’ve just thrown a few lines of HTML down leaving a very sparse looking page that may (or may not) demonstrate the functions I’m looking at but … Continue reading Building A Testing Site (HTML, CSS, JavaScript)
To assist with the pupils attending Code Club I’ve knocked up a quick HTML tag reference sheet for the basic tags used in the first few projects. HTML Tags HTML stands for Hyper Text Markup Language. All the tags have and opening tag <> and a closing tag </> <head> </head> … Continue reading HTML Tag Reference Sheet (Code Club)
From the beginning of 2018 the Code Club I run has been going through the Web-Dev projects of Code Club projects with the attendees learning about HTML and CSS. Today they completed Module 1 and I’m proud of them. When I first did any web development it was at GCSE level (IT) and the teacher … Continue reading HTML / CSS Code Club Module 1
I have got my Flask (Python) web application live and being deployed via CI/CD, and I have reports on my code coverage so that I know where code testing needs improving. However, this is not a moment to relax as up next is security testing. Note: This blog post discusses security tooling which should not … Continue reading Web Security – OWASP ZAP
For my assets web app, written in Flask (Python) I have separated the app and the database into separate instances. This allows me to update the app and its dependencies without impacting the database and its dependencies, or vice-versa. The database could be one of many as I’m using SQLAlchemy to handle the connectivity between … Continue reading Flask and SQLAlchemy: Connecting To MySQL (Python / Notes)
Testing is important, especially in Continuous Integration / Continuous Deployment (CI/CD) environments, as it gives some reassurance that a code commit has not broken anything. But what happens if you are unsure how much of your project is covered by tests? Code Coverage Code coverage monitors tests as they run and checks which parts of … Continue reading Code Coverage (Python / DevOps)
The Software Engineering & Agile module of my degree apprenticeship is coming to a close. With that in mind I think I can now share the coding I’ve done for the assignment especially as I needed to store it in a public repository (it’s on my GitHub at https://github.com/geektechdude/qa-se-webapp ) as part of the submissions … Continue reading An Asset WebApp (Flask / Python)
A quick overview of the differences between SQL and NoSQL. SQL Structured Query Language (SQL) is used for relational databases, which are table based. For example, an column in table A (e.g. User_ID) may have a relation with a column in table B (e.g. Order_Ref) and table B may have a relation to a column … Continue reading SQL vs NoSQL (Notes)
MediaWiki was developed originally for Wikipedia and has grown to support lots of sites. With this in mind you may consider installing MediaWiki and running a local wiki, especially as MediaWiki provides instructions on specific operating system installs. In an effort to speed up installs I’ve created an Ansible playbook to carry out the MediaWiki … Continue reading Installing MediaWiki with Ansible (Linux)
Every network interface controller (NIC) has a Media Access Control (MAC) address which is unique to the interface. A device may have multiple network interfaces (e.g., a ethernet network interface and a wireless network interface) and will a MAC address for each interface (e.g., a Rasperry Pi 4 has one MAC address for the ethernet … Continue reading Security: MAC Address and ARP (Notes)
GeekTechStuff 