Get the Second Highest Salary in MySQL
The problem
Write a SQL query to get the second highest salary from the Employee table.
+----+--------+ | Id | Salary | +----+--------+ | 1 | 100 …Read Article →
Technical Articles
In-depth guides, insights, and best practices for modern software engineering
Find Maximum Subarrays using Java
The problem
Given an integer array nums, find the contiguous subarray (containing at least one number) which has the largest sum and return its sum. …
Finding Number Complements using Java
The problem
Given a positive integer num, output its complement number. The complement strategy is to flip the bits of its binary representation. …
Forensic Analysis on Linux (Unix)
Operating Systems come in a few competing choices, of which the major players are Apple’s MacOS, Microsoft’s Windows and then the various …
Read Article →Self Dividing Numbers using Python
Introduction
A self-dividing number is a number that is divisible by every digit it contains.
For example, 128 is a self-dividing number because 128 % …
RuntimeError: thread.__init__() not called (Python)
Today I got a really dumb error from Python.
RuntimeError: thread.init() not called
But luckily it’s really easy to fix!
Below is the code …
Read Article →All About Distributed Databases
A database “is a structured collection of data. Card indices, printed catalogues of archaeological artefacts and telephone directories are all …
Read Article →Network systems security risks
Networking has played a vital part in the transfer of information as well as the accessibility of information that was never available to previous …
Read Article →Communications and The Software Development Process
Software Engineering or the Software Development Process is broken down into the following phases.
- Requirements
- Design
- Implementation
- Verification …
Get the total size of all the files in a directory
It’s amazing how many times I’ve need to find out the total size of all the files in a directory on one of our servers.
I have grown to …
Read Article →Structured and Object-Oriented Programming
Software development has really come a long way over the past few decades.
Programming used to always be about doing things in a very procedural way, …
Read Article →Moving a MySQL Database without downtime
At Statvoo Analytics we found ourselves in the position where we needed to move our master MySQL database without ANY downtime and for anyone …
Read Article →How to use Google Analytics in AngularJS
It seems to be quite a popular question with not as many answers to hold the weight.
Google Analytics has always been more of a pageviews type …
Read Article →Converting from Legacy to Client-Server or Distributed Systems
What is a legacy system?
A legacy system is a computing system that has been around for a very long period of time, tends to be difficult to maintain, …
Read Article →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 →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 →