SQL vs NoSQL (Notes)

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)

Installing MediaWiki with Ansible (Linux)

Ansible Playbook, a YAML file

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)

Security: OWASP Top Ten (Notes)

The Open Web Application Security Project (OWASP) provides a top ten security risks in web applications at https://owasp.org/www-project-top-ten/ . The ranking of risks can help developers (and organisations) make their applications more secure. The 2021 OWASP Top Ten Broken Access Control Cryptographic Failures Injection Insecure Design Security Misconfiguration Vulnerable and Outdated Components Identification and Authentication … Continue reading Security: OWASP Top Ten (Notes)