Articles and step-by-step guides

Structured Query Language - a primer (part 3)

Part 3 - Structured Query Language (SQL) is the language of databases - responsible for the creating, reading, updating, and deleting of data in those databases. Since its first appearance in the mid-70's SQL has defined how the management and handling of structured data. In turn, relational database management systems now underpin storage of the worlds data. Further underlining the importance of SQL followed it's acceptance as a standard of the American National Standards Institute (ANSI) and later the International Organization for Standardization (ISO). In this article we take a look at the basic syntax for the most important and frequently used SQL operations.

Hero Banner in React, Tailwind CSS, and Glidejs

When we talk about a 'Hero banner' we're usually refering to the landing page of a website - where, at or near the top of the page there may be a large image with some text overlaid. In fact often there will be more than one image, and after a set period of time the image being displayed will change to one of the others. Usually this occurs with some sort of animation (slide-in, fade-in, etc.), again after a fixed period of time, and in a cyclical fashion. Hence, the 'Hero banner', can contain images that relate to the business, individuals, or individual that the website represents with the overlaying text conveying a message that is in someway relevent to it's location, perhaps including buttons that lead the user through to other content. And again this is usually placed at the top of the landing page. In this post I'll walk through how such a 'Hero banner' can be made using React, Tailwindcss, and the JavaScript library Glidejs.

Structured Query Language - a primer (part 2)

Part 2 - Structured Query Language (SQL) is the language of databases - responsible for the creating, reading, updating, and deleting of data in those databases. Since its first appearance in the mid-70's SQL has defined how the management and handling of structured data. In turn, relational database management systems now underpin storage of the worlds data. Further underlining the importance of SQL followed it's acceptance as a standard of the American National Standards Institute (ANSI) and later the International Organization for Standardization (ISO). In this article we take a look at the basic syntax for the most important and frequently used SQL operations.

Structured Query Language - a primer (part 1)

Part 1 - Structured Query Language (SQL) is the language of databases - responsible for the creating, reading, updating, and deleting of data in those databases. Since its first appearance in the mid-70's SQL has defined how the management and handling of structured data. In turn, relational database management systems now underpin storage of the worlds data. Further underlining the importance of SQL followed it's acceptance as a standard of the American National Standards Institute (ANSI) and later the International Organization for Standardization (ISO). In this article we take a look at the basic syntax for the most important and frequently used SQL operations.

Efficient inventory management

A core function of any inventory management system is to always have up to date information about every customer - their purchase history, deliver status, account details, etc. In inventory management, being real-time or near real-time for a customer makes a big impact on the customer experience. Inventory management systems must therefore query each and every customer account to ensure these details are up to date. But - how can we code an efficient scheduling system - for a database consisting of 1000's, tens of thousands, even millions of customers?

Python Data Structures - Dictionaries

The Python dictionary data structure can be a lot easier to create and edit than Python lists; and they lend themselves very neatly to self-documentation, making them an ideal alternative for data heavy scripts.