ITNEXT·3yFull stack WebPageForm builder, NextJs, Typescript ( React ), Dnd-Kit, PostgreSQL, Prisma
A tutorial on building a full stack PageForm builder using NextJs, TypeScript, Dnd-Kit, PostgreSQL, and Prisma. The tutorial includes features such as a drag and drop designer, various form fields, form preview, form sharing, form stats, and more.
freeCodeCamp·3yPostgreSQL Course for Beginners
A comprehensive PostgreSQL course is available on the freeCodeCamp.org YouTube channel. It covers PostgreSQL introduction, installation, SELECT statement, WHERE clauses, advanced query structures, aggregate functions, and more. Suitable for developers, aspiring Database Administrators, computer science students, and tech enthusiasts.
freeCodeCamp·3yFull Stack Project Tutorial – Create a Recipe App Using React, Node.js and PostgreSQL
In this in-depth tutorial, we'll build a full stack recipe app from scratch, using React, Node.js, Postgres and the Spoonacular API. We'll cover features such as: Building an API server in Node - Integrating securely with a 3rd party API - Interacting with a Postgres database using Prisma.
Supabase·3yDynamic Table Partitioning in Postgres
This article discusses the problem of storing large amounts of data in a single table in Postgres and explores the solution of table partitioning. Partitioning data in Postgres can help improve query performance, facilitate archiving and data loading, and prevent issues like slower SELECTs and INSERTs.
Vercel·3yVercel Postgres is now available for Hobby and Pro users – Vercel
Vercel Postgres, a serverless SQL database, is now available for Hobby and Pro users. The storage pricing has been reduced by 60% and the usage prices for Pro users have been provided. Users can opt out of using Vercel Postgres by backing up and deleting their database.
TigerData (Creators of TimescaleDB)·3yReal-time Analytics in Postgres: Why It's Hard (and How to Solve It)
Enabling real-time data analytics is a key capability of modern applications, but PostgreSQL materialized views have limitations, such as inefficient refreshes, lack of automatic refreshes, and not showing up-to-date results. Timescale's continuous aggregates solve these limitations by providing automatic and efficient refreshes, as well as combining materialized data with raw data. Continuous aggregates are suitable for real-time analytics, live dashboards, reporting, and more.