When building a REST API, we must prepare for various cases. At first, everything might run smoothly, but as our API gains traction, we might encounter some issues. We might run into users who begin sending hundreds or thousands of requests per second, pulling data far more often than necessary. This might cause our server […]
With NestJS 11, the framework now comes with Express 5 by default. While the update is mostly painless, there are some breaking changes to consider. In this article, we go through what new features Express 5 brings to the table and how it affects NestJS. Installing Express 5 Express 4 was released in April 2014. […]
When using PostgreSQL with PostGIS, we can do various operations using polygons. In this article, we learn how to do that both through raw SQL queries and the Drizzle ORM. Storing polygons using the Drizzle ORM To store polygons using the Drizzle ORM, we use a custom data type and the areas table. database-schema.ts
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 |
import { serial, text, pgTable } from 'drizzle-orm/pg-core'; import { customType } from 'drizzle-orm/pg-core'; import { Geometry } from 'wkx'; type Coordinate = [number, number]; interface GeoJson { type: string; coordinates: Coordinate[][]; } const polygon = customType<{ data: Coordinate[][]; driverData: string }>({ dataType() { return 'geometry(Polygon, 4326)'; }, toDriver(coordinates: Coordinate[][]): string { return JSON.stringify({ type: 'Polygon', coordinates, }); }, fromDriver(data: string) { const geoJson = Geometry.parse( Buffer.from(data, 'hex'), ).toGeoJSON() as GeoJson; return geoJson.coordinates; }, }); export const areas = pgTable('areas', { id: serial().primaryKey(), name: text().notNull(), polygon: polygon('polygon').notNull(), }); export const databaseSchema = { areas, }; |
[…]
PostgreSQL, together with PostGIS, allows us to store various types of geographical data. Besides working with simple coordinates, we can also store entire areas in the form of polygons. In this article, we learn how to handle polygons with PostgreSQL and the Drizzle ORM. While Drizzle ORM does not support it out of the box, we […]
PostgreSQL provides many options for working with geographical data, especially with the PostGIS extension. In this article, we’ll explore how to calculate the distance between two coordinates and how to identify locations within a specific radius. If you want to check out the basics of storing coordinates in PostgreSQL with the Drizzle ORM, check out […]
Many applications rely on geographical data to calculate distances and track locations. PostgreSQL offers several ways to store geospatial data, each designed with different goals. In this article, we learn how to store coordinates when working with PostgreSQL and the Drizzle ORM. Latitude and longitude A coordinate consists of two numbers that pinpoint a location […]
When we execute an SQL query, PostgreSQL follows a process that consists of multiple steps. First, it parses the SQL statement, checking for syntax errors. Next, it analyzes whether the tables and columns used in the query exist. Then, it plans the instructions necessary to achieve the desired result. Finally, it executes the instructions based on […]
As our application grows, it gets increasingly important to create a file structure that’s easy to maintain. Also, if we care about it from the start, it is easier to achieve. In this article, we learn how to organize the database schema when working with the Drizzle ORM and NestJS. Handling column names When working […]
Searching through text documents is a very common feature in many web applications. In this article, we learn how to implement it using pattern matching using the Drizzle ORM, PostgreSQL, and NestJS. Pattern matching with LIKE and ILIKE With pattern matching, we can determine if a given piece of text matches a particular pattern. To […]
When fetching data from the database, we often don’t want to present it to the user in its raw form. To prevent that, we need to serialize the response in NestJS before sending it. The most popular way to achieve that in NestJS is using the class-transformer library. In this article, we explain how to […]
