Best of PostgreSQL — 2023
- 1
- 2
DZone·3y
Postgres vs. MySQL: a Complete Comparison
Postgres has taken over the first place spot from MySQL and become the most admired, desired database. As Postgres gains momentum, choosing between them is still hard and often causes heated debate. Postgres is still the world's most popular open-source database by install base.
- 3
ITNEXT·3y
Full 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.
- 4
Community Picks·3y
Typescript CRUD API: Next.js, Tailwind, tRPC, Prisma Postgres, Docker
Learn how to build a FULL CRUD API app, including a simple frontend to use it, using the following technologies: Next.js, Tailwind, tRPC, Prisma Postgres, Docker. All the code is available for free on GitHub(link in video description) Learn how to code your own blockchain and create your own crypto-currency with the CoinCamp.
- 5
The Complete Modern React Developer 2022
Course covering the full stack development using React, Node.js, MongoDB, and PostgreSQL. Backend setup using Express.js or Nest.js. Includes tutorials for setting up local databases and using Docker. Frontend tests using React Testing Library and Cypress.
- 6
Build a full stack app with Rust, Next.js and Docker
Learn how to build a full stack app with Rust, Next.js, and Docker. The app uses Next.js 14 with TypeScript and Tailwind CSS for the frontend, Rust without any framework for the backend, and PostgreSQL for the database. Docker and Docker Compose are used to containerize and run the app. The article provides step-by-step instructions on setting up the database, backend, and frontend, as well as testing the app using Postman.
- 7
- 8
freeCodeCamp·3y
PostgreSQL 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.
- 9
Full 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.
- 10
- 11
AWS in Plain English·3y
All your servers accessible directly and securely from your Browser
All your servers are accessible directly and securely from your Browser. Border0 client portal is a beautiful and efficient web interface that allows your users to quickly and easily discover all servers they have access to. The dashboard features app cards for each service, with easily distinguishable icons and details.
- 12
DBconvert·3y
MySQL vs PostgreSQL in 2023.
PostgreSQL and MySQL are both reliable, secure and scalable databases that have been around for decades. They each have different strengths and weaknesses that make one more suitable for certain use cases than the other. This article will compare them to aid in making an informed decision in 2023.
- 13
- 14
Amplication·3y
SQL Versus NoSQL Databases: Which to Use, When, and Why
The right choice means we can scale up an application quickly and handle increasing user requests without encountering problems. Choosing the right database for your application is no mean feat, given the number of available databases. There are many differences between SQL and NoSQL databases, such as how they handle relational data, their query languages.
- 15
EverSQL·3y
PostgreSQL is taking the lead
PostgreSQL is taking the lead from other relational databases such as MySQL. Postgres is gaining popularity among startups and large enterprises. Cloud vendors are going in a PostgreSQL-first approach, with cloud vendors creating customized databases based on PostgreSQL. PostgreSQL has an internal engine that can be trusted to build other technologies.
- 16
DEV·3y
All your ssh and database servers accessible directly from your Browser
New Border0 client portal allows users to quickly and easily discover all servers they have access to. The dashboard features app cards for each service, with easily distinguishable icons and details. We offer both a card and a list view and the choice between dark or light mode. The search box at the top of the screen supports fuzzy search capabilities.
- 17
Unzip·3y
Vector Databases 🧫 Explained
vector databases use algorithms like ANN(Approximate Nearest Neighbors) so they can facilitate efficient storage, retrieval, and similarity search operations. These databases excel at handling structured data with a fixed schema. But they often struggle with unstructured or high-dimensional data, such as images, audio, and text.
- 18
- 19
Modern API design with Golang, PostgreSQL and Docker
Go is a powerful language that's highly performant and has concurrency built in the language itself making it perfect for micro services. This article is aimed at anyone who wants to build a CRUD micro service or a simple RESTful API using Go (or Golang for SEO purposes) You can find all the code in my repository.
- 20
- 21
- 22
Go + TypeScript full stack web app, with nextjs, PostgreSQL and Docker
Learn how to create a full stack web app using Go and TypeScript in this article. The app uses Next.js, Tailwind CSS, Go, PostgreSQL, and Docker. It provides step-by-step instructions for setting up the backend, creating a database with Docker, and building the frontend. You can find the full code on GitHub.
- 23
The SQL Handbook – A Free Course for Web Developers
The SQL Handbook is a free and open text-based handbook for Web Developers. Try the interactive version of this SQL course on Boot.dev, complete with coding challenges and projects. Watch the video walkthrough of this course on FreeCodeCamp's YouTube channel.
- 24
Full Stack Project Tutorial – Create A Notes App Using React and Node.js
Learn how to create a full stack notes app using React and Node.js. The tutorial covers building the UI, connecting it to the backend, and adding features like validation and error handling. By the end of the tutorial, readers will have a functional notes app that they can use as a starting point for their own projects.
- 25
