Blog Posts

Home /
Blog Posts

Remove the Outermost Parentheses using Python

May 15, 2020

Interview

The Question A valid parentheses string is either empty (""), "(" + A + ")", or A + B, where A and B are valid parentheses strings, and + represents string concatenation.

The Pros and Cons of Agile in Software Development

May 14, 2020

Agile , Software

What is Agile in Software Engineering? Agile approaches help teams respond to unpredictability through incremental, iterative work cadences and empirical feedback.

Contemporary and beneficial uses of Big-Data Systems

May 13, 2020

Big data

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 the data with low-latency.

Distributed Database Systems Observations

May 12, 2020

Databases , Distributed

Traditional database systems were a centralised powerful database server that housed all operations pertaining to the database.

Functions of an Operating System

May 11, 2020

Misc

I am in a bit of an unusual situation where “I use” a combination of three different laptops, which each run different platforms.

ORDER BY RAND() – Faster Alternative

May 10, 2020

My SQL

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 years.

Top-down vs Bottom-up Database Design

May 9, 2020

Databases

There are essentially two different approaches one can take when designing databases; these, from a high-level analytic point of view, narrow down to what is typically called “Top-down” and “Bottom-up” philosophies or methods.

How to keep your web server or blog up when you get a traffic spike

May 8, 2020

Hosting

So you’re about to be featured on some very high ranking website.

How to get the UTC Timestamp in Python

May 7, 2020

Python

All dates in your server applications should be stored in the UTC timezone.

How to setup the AWS CLI for multiple profiles

May 6, 2020

The AWS CLI provides the ability to use the wide range of Amazon Web Services tools and services straight from the command-line.

How to get the size of an AWS S3 bucket

May 5, 2020

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:

Comparing Java and Javascript

May 4, 2020

Java , Javascript

Perhaps the first thing that most people ask when they hear the names of these two programming languages are.

An Introduction to Data Structures

May 3, 2020

Misc

When bringing up the topic of “Data Structures”, it is first important to understand what they are.

Relational Database Proprietary Extensions

May 2, 2020

Databases

Standard Query Language – or SQL for short – is a language designed for relational databases that allows end users such as developers and database administrators (DBAs) to manipulate data.

Locks used in Database Management Systems

May 1, 2020

Databases

Database Management Systems (DBMS?) are designed to store any amount of data that can then be retrieved or manipulated at a later date.

Tail and Grep: display all output but highlight search matches

April 30, 2020

I tail logs quite a lot. An example would be to tail the Apache2 access logs.

Convert URL String into a Javascript Object

April 29, 2020

Javascript

Sometimes you find yourself with a String, something like and you want to repeatably access elements of it correctly.

How to make an HTTP Request in AWS Lambda using Python

April 28, 2020

Aws , 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

April 27, 2020

Javascript

Sometimes you may get an error that looks something like this:

Resolving InsufficientPrivilege Errors in Redshift

April 26, 2020

Aws , Databases

If you are getting the mysterious error: [ERROR] InsufficientPrivilege: permission denied for schema errors

Blog Posts

Tags