Conceptual Architectural Views, with a focus on the Development View
What is Conceptual Architectural Views?
Architectural views are abstractions, or simplifications, of the entire design, in which important …
Read Article →Technical Articles
In-depth guides, insights, and best practices for modern software engineering
Assessing Reusable Parts in a Software Architecture
During the Software Development Life Cycle (SDLC) the development team will come to realise that parts of any application have already been created …
Read Article →An Introduction to 2-Tier and 3-Tier Client-Server Systems
All software systems can be grouped in either a 2-tier or a 3-tier formation.
The former is essentially where all clients contain application and …
Read Article →Remove the Outermost Parentheses using Python
The Question
A valid parentheses string is either empty (""), "(" + A + ")", or A + B, where A and B are valid …
The Pros and Cons of Agile in Software Development
What is Agile in Software Engineering?
Agile approaches help teams respond to unpredictability through incremental, iterative work cadences and …
Read Article →Contemporary and beneficial uses of Big-Data Systems
Big data is a term applied to datasets whose size or type is beyond the ability of traditional relational databases to capture, manage, and process …
Read Article →Distributed Database Systems Observations
Traditional database systems were a centralised powerful database server that housed all operations pertaining to the database.
There are countless …
Read Article →Functions of an Operating System
I am in a bit of an unusual situation where “I use” a combination of three different laptops, which each run different platforms. Namely; …
Read Article →ORDER BY RAND() – Faster Alternative
MySQL’s ORDER BY RAND() function can be so useful for returning random items from a table, in fact, we have used it a million times over the …
Top-down vs Bottom-up Database Design
There are essentially two different approaches one can take when designing databases; these, from a high-level analytic point of view, narrow down to …
Read Article →How to keep your web server or blog up when you get a traffic spike
So you’re about to be featured on some very high ranking website.
You’re worried that when all the visitors come rushing towards you, your …
Read Article →How to get the UTC Timestamp in Python
All dates in your server applications should be stored in the UTC timezone.
This is because you always want to store time without the offset of the …
Read Article →How to setup the AWS CLI for multiple profiles
The AWS CLI provides the ability to use the wide range of Amazon Web Services tools and services straight from the command-line. If you’re …
Read Article →How to get the size of an AWS S3 bucket
If you need to get the size of an AWS S3 folder, or even an entire bucket, you can do so with the following command:
aws s3api --profileRead Article →list-objects …
Comparing Java and Javascript
Perhaps the first thing that most people ask when they hear the names of these two programming languages are. “Why do they have the same …
Read Article →An Introduction to Data Structures
When bringing up the topic of “Data Structures”, it is first important to understand what they are. TechTarget states that “a data structure is a …
Read Article →Relational Database Proprietary Extensions
Standard Query Language – or SQL for short – is a language designed for relational databases that allows end users such as developers and database …
Read Article →Locks used in Database Management Systems
Database Management Systems (DBMS?) are designed to store any amount of data that can then be retrieved or manipulated at a later date.
In order to …
Read Article →Tail and Grep: display all output but highlight search matches
I tail logs quite a lot.
An example would be to tail the Apache2 access logs.
This is simple to do:
tail -f /var/log/apache2/access.log
This will show …
Read Article →Convert URL String into a Javascript Object
Sometimes you find yourself with a String, something like and you want to repeatably access elements of it correctly.
Let’s say that you want …
Read Article →How to make an HTTP Request in AWS Lambda using Python
The requests module for Python is very useful in helping simplify HTTP/s requests from Python, but how would you use it in an AWS Lambda script? …
How to fix a Javascript Uncaught ReferenceError
Sometimes you may get an error that looks something like this:
Uncaught ReferenceError: <some_variable_or_function> is not defined
At first this …
Read Article →Resolving InsufficientPrivilege Errors in Redshift
If you are getting the mysterious error:
[ERROR] InsufficientPrivilege: permission denied for schema errors
Then you can easily resolve this by …
Read Article →How to increase column size in Redshift database tables
It is only possible to alter VARCHAR columns, and only under the following circumstances:
- You can not alter a column with compression encodings …