Database Tips
Get, Add and Remove JSON Objects from an Array
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
It’s about all keeping promises.
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
Using a JavaScript Set with the Spread operator and JavaScript Array methods .map() and .sort()
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
Get started using a React framework.
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
React form state management without the useState() Hook.
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
Get a local copy of your favorite JavaScript developer’s public code and run it on your local machine.
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
Create an account in the NPM registry, write some code for your package and publish
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.
- Create an NPM registry account.
- Write some code that…
Database Tips
Create, get(as list and rows), modify, add and remove data from an Array
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.
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.
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.
