Have you ever wondered where those npm packages you install come from Well, wonder no longer, they come from developers like you!
In this tutorial, we will create and publish to the NPM registry, an NPM package using the following steps.
Our focus will be on the process and not the package per se. …
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.
In this article, I’d like to focus on another data type, the Array data type. Why? Because Arrays are great for storing, at a minimum, lists. Lists of text, numbers and more.
Array Type
PostgreSQL gives the opportunity to define a column of a table as a variable length single or multidimensional array. …
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. Pagination can be done on the front-end, back-end, or both.
Note: This article is specific to Microsoft’s SQL Server. For MySQL or PostgreSQL, see this article.
Pagination, also known as paging, is the process of dividing a document into discrete pages, … Server-side pagination is appropriate for large data sets providing faster initial page load.
-Wikipedia
Server-side pagination is more common. Client-side pagination can be used when there are very few records to be accessed, in which case all records can be returned, and the client can use JavaScript or CSS to view the separate pages. …
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.
Note: This technique works well in PostgreSQL and MySQL. For Microsoft SQL Server see this article.
Pagination, also known as paging, is the process of dividing a document into discrete pages, … Server-side pagination is appropriate for large data sets providing faster initial page load.
-Wikipedia
Server-side pagination is more common. Client-side pagination can be used when there are very few records to be accessed, in which case all records can be returned, and the client can use JavaScript or CSS to view the separate pages. …
In this article we will explore two ways of tracking state using a simple registration form.
The user enters their name, email address and a password and we keep track of state in two different ways.
Both are valid ways but the second may be preferred for larger forms.
You can use an existing React project (I often keep a “SandBox” application for experimenting) or bootstrap a new project. …
Although React’s useEffect hook allows you to do many things, In this tutorial we will walk through how to use the useEffect hook specifically to fetch data from an API, and refresh that data periodically.
You can use whatever API you prefer but we will be using the fake API https://jsonplaceholder.typicode.com/ to fetch posts.
https://jsonplaceholder.typicode.com/posts
By using this Hook, you tell React that your component needs to do something after render. React will remember the function you passed (we’ll refer to it as our “effect”), and call it later after performing the DOM updates.
Something important to notice in the statement above is that the useEffect hook runs after the DOM updates. Therefore it will not block the render process. …
Can you make money on Fiverr?
The short answer to this is yes! I’m not saying you will make a living from Fiverr, maybe you can, but it can certainly be a decent additional income stream.
For me, if I took every request, I could earn between $500-$1,500 of additional income per month.
What I have found is it is best to have several “Gigs”. Why? Because they may not all be in demand at the same time. I have four Gigs.
There are many styles of the ampersand, but I’m just talking about the simple one you see on your keyboard, &.
I write mine backwards. By that I mean, on a keyboard, mine would look like this,
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.
In this article, I’d like to continue our work with a jsonb column containing an Array of Objects and explore how to,
About