Database Tips

Source: PostgreSQL Wiki

In my last article, we focused on turning a PostgreSQL jsonb column, that contained an Array of Objects, into a recordset, so that it could be queried in a relational manner.

What We Will Do

In this article, I’d like to continue our work with a jsonb column containing an Array of Objects and…


JavaScript Tips

Photo by marcos mayer on Unsplash

The .map() Method Of An Array

The map() method creates a new array populated with the results of calling a provided function on every element in the calling array.

The .map() method of an Array loops through each item in an Array and does whatever the function, callback function or Arrow function specifies. The result of…


Working with JavaScript Objects

Photo by Noah Näf on Unsplash

The Problem To Be Solved

If you look at the sample data below you will see the data we are working with and what we want to achieve (desired result.)

We have a JavaScript Array which contains an Object for each of our friends.


Component-Based Development

Photo by Arnold Francisca on Unsplash

In this tutorial, we will examine:

  • What Next.js is and how it is different from just React.
  • What server-side rendering is.
  • How to Bootstrap a Next.js application.
  • The basics of creating routes.
  • Using React components.

The source code for this can be found on GitHub.

Assumptions

This tutorial does assume you…


React Tips

Photo by Kelly Sikkema on Unsplash

In this tutorial, we will explore React form state management using React Final Form. React Final Form allows us to manage state without the need for the useEffect() hook.

What is React Final Form?

High performance subscription-based form state management for React

React Final Form is a React wrapper for Final Form, which is that…


Source Control

Photo by Victor Serban on Unsplash

So you found the public GitHub account of your favorite JavaScript/React developer and want to run some of the examples in their repositories. Or a tutorial mentions “the complete solution can be found here.” Great. Now what?

Cloning is done through the command ‘git clone’ and it is a process…


NPM Packages

Photo by Jess Bailey on Unsplash

Have you ever wondered where those npm packages you install come from Well, wonder no longer, they come from developers like you!

What We Will Do

In this tutorial, we will create and publish to the NPM registry, an NPM package using the following steps.


Database Tips

PostgreSQL is an open source relational database that supports some amazing data types. In prior articles, we looked at performing CRUD-like operations on the jsonb data type as well as converting a jsonb array of objects in to a recordset for easy querying.

What We Will Do

In this article, I’d like to focus…


Database Tips

Using the OFFSET and FETCH clauses in Microsoft’s SQL Server.

Photo by K. Mitch Hodge on Unsplash

A common need when working with large amounts of data is how to fetch the data and display it in a reasonable amount of time.

The solution to this problem is pagination. …


Database Tips

Using the LIMIT, OFFSET and FETCH NEXT operators.

Photo by Annie Spratt on Unsplash

A common need when working with large amounts of data is how to fetch the data and display it in a reasonable amount of time.

The solution to this problem is pagination. Pagination can be done on the front-end, back-end, or both.

gravity well (Rob Tomlin)

Self-Employed Software Engineer, Trainer, Consultant. Keeping up to date. I’ve noticed in over 30 years of programming, one’s current skills have a shelf life.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store