We explain the many-to-one SQL relationship and implement it using the Drizzle ORM and NestJS| Marcin Wanago Blog - JavaScript, both frontend and backend
Day: May 27, 2024 | Marcin Wanago Blog - JavaScript, both frontend and backend
We build a REST API for uploading videos to the server and streaming them using NestJS and Prisma| Marcin Wanago Blog - JavaScript, both frontend and backend
We implement REST API versioning in our NestJS application to maintain backward compatibility| Marcin Wanago Blog - JavaScript, both frontend and backend
We learn how to use the PUT and PATCH methods with Prisma and NestJS and outline their differences.| Marcin Wanago Blog - JavaScript, both frontend and backend
Day: July 31, 2023 | Marcin Wanago Blog - JavaScript, both frontend and backend
We serialize the responses in our NestJS API using Prisma and the class-transformer library.| Marcin Wanago Blog - JavaScript, both frontend and backend
We explore using the JSON and JSONB columns with Prisma and PostgreSQL in a NestJS project.| Marcin Wanago Blog - JavaScript, both frontend and backend
Day: June 26, 2023 | Marcin Wanago Blog - JavaScript, both frontend and backend
We explain the CORS mechanism and use it with a NestJS application| Marcin Wanago Blog - JavaScript, both frontend and backend
We learn about SQL database migrations with Prisma and NestJS| Marcin Wanago Blog - JavaScript, both frontend and backend
We use constraints with PostgreSQL and Prisma to have more control over the data in our NestJS project.| Marcin Wanago Blog - JavaScript, both frontend and backend
We implement response serialization in a REST API project with NestJS and the Drizzle ORM| Marcin Wanago Blog - JavaScript, both frontend and backend
We use PostgreSQL with PostGIS and Drizzle ORM to calculate distances and find locations within a radius| Marcin Wanago Blog - JavaScript, both frontend and backend
We explore how to store JSON in a PostgreSQL database using the Drizzle ORM and NestJS| Marcin Wanago Blog - JavaScript, both frontend and backend
We explore the array columns and implement them using NestJS, PostgreSQL, and the Drizzle ORM| Marcin Wanago Blog - JavaScript, both frontend and backend
We split the Drizzle ORM schema for a PostgreSQL database into multiple files in a NestJS project| Marcin Wanago Blog - JavaScript, both frontend and backend
W implement pattern matching search with Drizzle ORM and NestJS. We show how it's different from full-text search.| Marcin Wanago Blog - JavaScript, both frontend and backend
We learn how to shorten our SQL queries by using views with Drizzle ORM, PostgreSQL, and NestJS| Marcin Wanago Blog - JavaScript, both frontend and backend
We cover different methods for storing the date and time in PostgreSQL using the Drizzle ORM and NestJS| Marcin Wanago Blog - JavaScript, both frontend and backend
We cover uploading and streaming files using the bytea column in PostgreSQL with NestJS and Drizzle ORM| Marcin Wanago Blog - JavaScript, both frontend and backend
We learn what SQL migrations are and how to use them in a project with the Drizzle ORM and NestJS| Marcin Wanago Blog - JavaScript, both frontend and backend
We explain how to modify entities using PUT and PATCH methods with NestJS and the Drizzle ORM| Marcin Wanago Blog - JavaScript, both frontend and backend
We go through the cron syntax. We also use cron together with the Nodemailer to schedule emails.| Marcin Wanago Blog - JavaScript, both frontend and backend
We explore how to store monetary values using PostgreSQL and the Drizzle ORM.| Marcin Wanago Blog - JavaScript, both frontend and backend
We cover the basics of database normalization with examples using the Drizzle ORM to make our database easier to maintain.| Marcin Wanago Blog - JavaScript, both frontend and backend
We explore recursive relationships with PostgreSQL, Drizzle ORM, and NestJS| Marcin Wanago Blog - JavaScript, both frontend and backend
We implement a polymorphic association using Drizzle ORM, PostgreSQL, and NestJS| Marcin Wanago Blog - JavaScript, both frontend and backend
We learn how Universally Unique Identifiers (UUIDs) work and implement them with Drizzle ORM, NestJS, and PostgreSQL| Marcin Wanago Blog - JavaScript, both frontend and backend
We explore the concept of integration tests in NestJS applications that use the Drizzle ORM| Marcin Wanago Blog - JavaScript, both frontend and backend
We learn how to write unit tests in a NestJS application that uses Drizzle ORM| Marcin Wanago Blog - JavaScript, both frontend and backend
We explore how to use the built-in NestJS logger and combine it with the Drizzle ORM to log SQL queries| Marcin Wanago Blog - JavaScript, both frontend and backend
We explore the fundamentals of SQL indexes and implement examples using PostgreSQL and the Drizzle ORM| Marcin Wanago Blog - JavaScript, both frontend and backend
We implement a full-text search in an app with PostgreSQL, NestJS, and the Drizzle ORM| Marcin Wanago Blog - JavaScript, both frontend and backend
We compare the serial data type and the identity columns using PostgreSQL and the Drizzle ORM| Marcin Wanago Blog - JavaScript, both frontend and backend
Series: API with NestJS | Marcin Wanago Blog - JavaScript, both frontend and backend
We explore the keyset and offset pagination and learn how to implement it with NestJS, PostgreSQL, and Drizzle ORM| Marcin Wanago Blog - JavaScript, both frontend and backend
We go through SQL constraints with PostgreSQL and implement them using Drizzle ORM and NestJS| Marcin Wanago Blog - JavaScript, both frontend and backend
We explain the one-to-one relationship and implement it with Drizzle. We also use the Query API to avoid doing SQL joins manually.| Marcin Wanago Blog - JavaScript, both frontend and backend
We set up NestJS with Drizzle to perform CRUD operations and manage SQL migrations| Marcin Wanago Blog - JavaScript, both frontend and backend
We explore data types in PostgreSQL and Prisma we can use to handle money and learn why we should avoid the float type| Marcin Wanago Blog - JavaScript, both frontend and backend
We use the Helmet library with NestJS to protect against exploits such as Cross-Site Scripting (XSS), clickjacking, and more| Marcin Wanago Blog - JavaScript, both frontend and backend