Introduction PostgreSQL is a powerful, open-source database system. It is a relational database management system (RDBMS) based on the SQL language. PostgreSQL is one of the most popular database systems in the world. It is the go-to database for man...

Introduction The jsonb_array_elements function returns a set of rows, one for each element of the input array. The input array can be a top-level array or a nested array. In this tutorial, we will learn how to flatten JSON array in SQL using jsonb_ar...

Introduction Hacktoberfest is a month-long event where people are awarded for contributing to open source projects 🙌. In order to participate you need to sign up here and then Submit four pull requests (PRs) to a GitHub repo tagged with the hacktober...

Introduction npm is a package manager for Node.js. It is used to install and manage packages for your JavaScript projects. npm is open source and was initially released in 2009. The npm repository is a collection of open-source packages and tools for...

Introduction Similar to a Bash script where you can pass arguments to a script using the $1 syntax, you can also pass arguments to a Node.js app. In this quick tutorial, you will learn how to pass arguments to a Node.js app using the process.argv arr...

Introduction WebSockets allow you to send and receive data over a network without having to use a traditional HTTP protocol. Using WebSockets, you can build a real-time application. For example, you can send messages to other users without having to ...

Introduction This is a self-contained example of a real-time chart powered by Deno, Web Sockets, Chart.js, and Materialize. Deno is a simple and secure runtime for JavaScript and TypeScript that uses V8. Deno, just like Materialize, is also written i...

Introduction Materialize is a streaming database for real-time analytics. It was launched in 2019 to address the growing need for the ability to build real-time applications easily and efficiently on streaming data so that businesses can obtain actio...

Introduction Materialize is a streaming database for real-time analytics. It was launched in 2019 to address the growing need for the ability to build real-time applications easily and efficiently on streaming data so that businesses can obtain actio...

Introduction This is a self-contained example of a real-time notification app with Deno, Materialize and Discord. Deno is a simple and secure runtime for JavaScript and TypeScript that uses V8. Deno, just like Materialize, is also written in Rust. In...