Types of Computer Programming Languages

0 Comments

We learnt in the previous class about what a computer program and programming means. We thus know that we need a language to be able to “talk” or communicate with a computer. There are three basic types of programming languages. A computer can however understand ONLY Machine Language directly. The earliest computer programs were written […]

A Frequent Question: Does jOOQ Have a First Level Cache?

0 Comments
PostgreSQL 11’s Support for SQL Standard GROUPS and EXCLUDE Window Function Clauses

One of the more frequent questions people have when switching from JPA to jOOQ is how to migrate from using JPA’s first level cache? Speaking of that, are there any jOOQ guides on how to replace JPA? Any patterns on how to work without EntityManager to manage in-memory state (EM#merge()), 1st level cache, etc. — […]

Understanding the Dynamics of Custom Software Development

0 Comments
Understanding the Dynamics of Custom Software Development

Many organizations find themselves looking for software solutions that simply do not exist on the market today. After endless searching, they finally decide to seek out a software development company, like BairesDev, to turn their ideas into a reality. The process of custom software development is the designing, creation, deployment, and maintenance of software built […]

How to Divert Traffic Using IP2Location in a Next.js Website

0 Comments
How to Divert Traffic Using IP2Location in a Next.js Website

This article was created in partnership with IP2Location. Thank you for supporting the partners who make SitePoint possible. In a world where online commerce has become the norm, we need to build websites that are faster, user friendly and more secure than ever. In this article, you’ll learn how to set up a Node.js powered […]

WordPress Block Transforms

0 Comments
WordPress Block Transforms

This has been the year of Gutenberg for us here at CSS-Tricks. In fact, that’s a goal we set at the end of last year. We’re much further along that I thought we’d be, authoring all new content in the block editor¹, enabling the block editor for all content now. That means when we open […]

How to Write Multiset Conditions With Oracle VARRAY Types

0 Comments
PostgreSQL 11’s Support for SQL Standard GROUPS and EXCLUDE Window Function Clauses

Oracle is one of the few databases that implements the SQL standard ORDBMS extensions, which essentially allow for nested collections. Other databases that have these features to some extent are CUBRID, Informix, PostgreSQL. Oracle has two types of nested collections: — Nested tables CREATE TYPE t1 AS TABLE OF VARCHAR2(10); / — Varrays CREATE TYPE […]

How to Install Node.js on Windows, Mac or Linux

0 Comments
node js installer

In this tutorial, I’ll be teaching you how you can install Node.js on windows, mac or linux in under 15 minutes. Node is an open-source runtime environment for javascript. It is a cross-platform environment providing its support for Mac, Windows and Linux. It runs Chrome’s V8 javascript engine, outside the browser, and because of this, […]

10 Zsh Tips & Tricks: Configuration, Customization & Usage

0 Comments
10 Zsh Tips & Tricks: Configuration, Customization & Usage

As web developers, the command line is becoming an ever more important part of our workflow. We use it to install packages from npm, to test API endpoints, to push commits to GitHub, and lots more besides. My shell of choice is zsh. It is a highly customizable Unix shell, that packs some very powerful […]

How to Build a Chrome Extension

0 Comments
How to Build a Chrome Extension

I made a Chrome extension this weekend because I found I was doing the same task over and over and wanted to automate it. Plus, I’m a nerd living through a pandemic, so I spend my pent-up energy building things. I’ve made a few Chrome Extensions over the years, hope this post helps you get […]

How SQL DISTINCT and ORDER BY are Related

0 Comments
PostgreSQL 11’s Support for SQL Standard GROUPS and EXCLUDE Window Function Clauses

One of the things that confuse SQL users all the time is how DISTINCT and ORDER BY are related in a SQL query. The Basics Running some queries against the Sakila database, most people quickly understand: SELECT DISTINCT length FROM film This returns results in an arbitrary order, because the database can (and might apply […]