Skip to content
FLAVIO COPES
flaviocopes.com
2026
[ BLOG ]
[ BOOKS ]
[ COURSES ]
[ BOOTCAMP ]
[ NEWSLETTER ]
[ AI WORKSHOP ]
Posts tagged "database"
Connect to Postgres local vs Vercel Postgres with Kysely
Set up Lucia Auth for local Postgres DB vs Vercel Postgres
Vercel Postgres, no transactions?
How to reset Postgres SERIAL number
SQL, copy data from one table to another
How to use Supabase as your PostgreSQL hosting
Where to host a PostgreSQL database
How to define an auto increment primary key in PostgreSQL
How to fix PostgreSQL saying "relation does not exist"
PostgreSQL, fix the `psql: error: could not connect to server` error
Using multiple fields for a unique key in Prisma
How to create a PostgreSQL database
Prisma, how to reverse order
Prisma, how to clear the database
Prisma relations
How to use Prisma
How to solve the `prisma/client did not initialize yet` error on Vercel
How to create an empty SQLite database
How to remove all items from a MongoDB collection
How to insert multiple items at once in a MongoDB collection
SQL Views
SQL Joins
SQL, how to delete data and tables
SQL, how to update a table structure
SQL, how to update data
SQL, Unique and Primary keys
SQL, Handling empty cells
SQL, how to use SELECT
SQL, adding data to a table
SQL, creating a table
MySQL User Permissions
SQLite User Permissions
PostgreSQL vs MySQL, a comparison
Creating a user on MySQL
How to install MySQL on macOS
How to list tables in the current database using PostgreSQL
How to list all databases using PostgreSQL
How to switch database using PostgreSQL
How to list all users in PostgreSQL
PostgreSQL User Permissions
Introduction to PostgreSQL
How to install SQLite on macOS
Do you always need a database for your app?
How to install PostgreSQL on macOS
Introduction to SQL
What is a Database? And a DBMS?
Relational Databases
Relational Algebra
The Relational Model
Introduction to the ER Data Model
Data models
Information systems, data and information
How MongoDB is different from a SQL database
The MongoDB basics tutorial