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 →Technical Articles
In-depth guides, insights, and best practices for modern software engineering
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 →