Not every piece of code needs to be perfectly optimized. Over-focusing on performances can sometimes lead to code that’s unnecessarily complex and unreadable without real benefits. However, being aware of common performance pitfalls lets us navigate and avoid them effectively. What is performance? When we talk about performance, we’re referring to how efficiently a program […]
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 […]
The internet has a ton of valuable data, but it’s not always easy to grab in a usable format. We can use web scraping to pull data from websites that don’t make it easy to download. This gives us a way to analyze our competitors, monitor prices, track trends, and more. In the previous article, we learned […]
The internet is filled with vast amounts of valuable data. However, much of the information isn’t available in a structured format we can download and use. To handle that, we can use web scraping. Web scraping is a process of extracting data from websites that don’t provide it in a structured format out of the […]
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. […]
Artificial Intelligence (AI) is a broad and complex field, and getting started can be overwhelming. In this article, we learn how Machine Learning is related to AI and train our first model to determine whether a given piece of text is a spam message. Artificial Intelligence and Machine Learning Artificial Intelligence focuses on developing systems […]
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 […]
