Database

55 posts tagged Database.

Go deeper: read the SQL Handbook.

~~~

Connect to Postgres local vs Vercel Postgres with KyselyNov 10, 2023
Set up Lucia Auth for local Postgres DB vs Vercel PostgresNov 10, 2023
Vercel Postgres, no transactions?Nov 10, 2023
How to reset Postgres SERIAL numberNov 8, 2023
SQL, copy data from one table to anotherFeb 5, 2023
How to use Supabase as your PostgreSQL hostingJun 23, 2022
Where to host a PostgreSQL databaseJun 22, 2022
How to define an auto increment primary key in PostgreSQLMay 16, 2022
Fix PostgreSQL 'relation does not exist' errorMay 15, 2022
Fix psql 'could not connect to server' in PostgreSQLAug 23, 2021
Using multiple fields for a unique key in PrismaJul 29, 2021
How to create a PostgreSQL databaseJul 27, 2021
Prisma, how to reverse orderJul 15, 2021
Prisma, how to clear the databaseJul 14, 2021
Prisma relationsJul 13, 2021
How to use PrismaJul 7, 2021
Fix 'prisma/client did not initialize yet' on VercelJul 1, 2021
How to create an empty SQLite databaseMay 4, 2021
How to remove all items from a MongoDB collectionOct 29, 2020
How to insert multiple items at once in a MongoDB collectionOct 28, 2020
How to store passwords in the databaseMay 22, 2020
SQL ViewsApr 4, 2020
SQL JoinsApr 3, 2020
SQL, how to delete data and tablesApr 2, 2020
SQL, how to update a table structureApr 1, 2020
SQL, how to update dataMar 31, 2020
SQL, Unique and Primary keysMar 30, 2020
SQL, Handling empty cellsMar 29, 2020
SQL, how to use SELECTMar 28, 2020
SQL, adding data to a tableMar 27, 2020
SQL, creating a tableMar 26, 2020
MySQL User PermissionsJan 16, 2020
SQLite User PermissionsJan 15, 2020
PostgreSQL vs MySQL, a comparisonJan 8, 2020
Creating a user on MySQLJan 6, 2020
How to install MySQL on macOSJan 5, 2020
How to list tables in the current database using PostgreSQLJan 4, 2020
How to list all databases using PostgreSQLJan 3, 2020
How to switch database using PostgreSQLJan 2, 2020
How to list all users in PostgreSQLJan 1, 2020
PostgreSQL User PermissionsDec 30, 2019
Introduction to PostgreSQLDec 29, 2019
How to install SQLite on macOSDec 28, 2019
Do you always need a database for your app?Dec 26, 2019
How to install PostgreSQL on macOSDec 25, 2019
Introduction to SQLDec 24, 2019
What is a Database? And a DBMS?Dec 23, 2019
Relational DatabasesDec 22, 2019
Relational AlgebraDec 21, 2019
The Relational ModelDec 20, 2019
Introduction to the ER Data ModelDec 19, 2019
Data modelsDec 18, 2019
Information systems, data and informationDec 17, 2019
How MongoDB is different from a SQL databaseNov 23, 2018
The MongoDB basics tutorialNov 22, 2018