Database

59 posts tagged Database.

New to Databases? Start with the Databases learning path.

Go deeper: read the SQL Handbook.

• First-party analytics with SQLiteJul 19, 2026
• Versioning reference data with effective_from datesJul 15, 2026
• The SQL and Databases GuideJul 14, 2026
• Astro SSR with D1 and Drizzle ORMJul 13, 2026
• 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