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 →Technical Articles
In-depth guides, insights, and best practices for modern software engineering
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 …
[Solved] The provided execution role does not have permissions to call CreateNetworkInterface on EC2
If you are trying to get an AWS Lambda added attached to a VPC, but get the error message:
The provided execution role does not have permissions to …
Entity and Referential Integrity in Relational Databases
Data integrity is the overall completeness, accuracy and consistency of data (Techopedia, n.d.).
In order to achieve data integrity, it is important …
Read Article →Data Warehouses vs Data Marts
Although the terms “data warehouse” and “data mart” sound similar, they are quite different. It is important to first …
Read Article →Amazon’s custom Whois date entry
Whois is an online service that let’s you know registration information about a website or IP address.
For the most part, Whois aggregations are …
Read Article →Graph Databases and their Properties
The concept of a graph in mathematics is simply a collection of elements which are typically called Nodes and are joined together by Edges. Each Node …
Read Article →How to add SSH keys to GitHub
When working with GitHub, you will need to identify yourself. The default way is using your username and password. However, you can also create an SSH …
Read Article →Get the Maximum Length of a Concatenated String with Unique Characters in Python
The problem
Given an array of strings arr. String s is a concatenation of a sub-sequence of arr which have unique characters.
Return the maximum …
Read Article →Apache Kafka’s Role in Big Data Streaming Analytics
The world of Big Data started out as a way of storing and querying obscene amounts of information by comparison to what yesteryears were able to …
Read Article →Mitigating Risks with Software Development Outsourcing
In the Oxford Dictionary, the term “outsourcing” is simply defined as obtaining goods or services by contract from an outside supplier …
Read Article →