Blog Posts

Home /
Blog Posts

How to increase column size in Redshift database tables

April 25, 2020

Aws , Databases

It is only possible to alter VARCHAR columns, and only under the following circumstances:

[Solved] The provided execution role does not have permissions to call CreateNetworkInterface on EC2

April 24, 2020

If you are trying to get an AWS Lambda added attached to a VPC, but get the error message:

Entity and Referential Integrity in Relational Databases

April 23, 2020

Databases

Data integrity is the overall completeness, accuracy and consistency of data (Techopedia, n.

Data Warehouses vs Data Marts

April 22, 2020

Big data , Databases

Although the terms “data warehouse” and “data mart” sound similar, they are quite different.

Amazon’s custom Whois date entry

April 21, 2020

Domains

Whois is an online service that let’s you know registration information about a website or IP address.

Graph Databases and their Properties

April 20, 2020

Databases

The concept of a graph in mathematics is simply a collection of elements which are typically called Nodes and are joined together by Edges.

How to add SSH keys to GitHub

April 19, 2020

When working with GitHub, you will need to identify yourself. The default way is using your username and password.

Get the Maximum Length of a Concatenated String with Unique Characters in Python

April 18, 2020

Interview , Python

The problem Given an array of strings arr. String s is a concatenation of a sub-sequence of arr which have unique characters.

Apache Kafka’s Role in Big Data Streaming Analytics

April 17, 2020

Big data

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

Mitigating Risks with Software Development Outsourcing

April 16, 2020

Software

In the Oxford Dictionary, the term “outsourcing” is simply defined as obtaining goods or services by contract from an outside supplier (OxfordDictionaries.

The Primary Data Types in Java

April 15, 2020

Java

In Java there are eight basic data types; which are: byte, short, int, long, float, double, boolean and char.

Comparing Objects in Java

April 14, 2020

Java

TLDR; When to use == in Java When comparing two operands.

As with many programming languages such as C, C++ and C# (known commonly as the C family), it is possible to “overload methods” (sometimes called functions if not used in classes, such as C) in order to take a different amount of parameters so that they can be used in multiple scenarios with similar internals.

uncaught typeerror: $ is not a function

April 12, 2020

Javascript

The dollar-sign ($) in Javascript has for many years now been associated with jQuery.

How to get the last element of a list in Python

April 11, 2020

Python

Let’s say that you have a Python list with the following 5 foods:

How to embed a web server in your Python3 app

April 10, 2020

Python

This is not the first time that I created a Python3 application that spat out some output and required access to it via an HTTP server.

How to get the Range Sum of Binary Search Tree using Java

April 9, 2020

Interview , Java

Given the root node of a binary search tree, return the sum of values of all nodes with value between L and R (inclusive).

How to duplicate zeros in place using Python

April 8, 2020

Interview , Python

Given a fixed length array arr of integers, duplicate each occurrence of zero, shifting the remaining elements to the right.

A Quick Introduction to Asyncio in Python3

April 7, 2020

Python

Python has never been the best at doing multiple things at the same time.

How to replace newlines with commas in CLI

April 6, 2020

If you need to replace all newline characters with a comma, or perhaps some other delimiter, then using the build-in tr utility will work very well for you.