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 […]

Student Registration Form in HTML with JavaScript Validation

0 Comments
Student Registration Form in HTML with JavaScript Validation

In this tutorial, I will tell you how to make student registration form in html with javascript validation. Javascript is basically used to validate HTML pages in web application. Validations are basically some rules to follow when inputting values to register on-site. Validation can be anything like: Some input fields cannot be empty. Some values […]

Building a Habit Tracker with Prisma 2, Chakra UI, and React

0 Comments
Building a Habit Tracker with Prisma, Chakra UI, and React

In June 2019, Prisma 2 Preview was released. Prisma 1 changed the way we interact with databases. We could access databases through plain JavaScript methods and objects without having to write the query in the database language itself. Prisma 1 acted as an abstraction in front of the database so it was easier to make […]