Tag: postgresql
-
2025/06/25 [GADM-api]
I started working on “next page url” header. I considered few approaches and settled on the one that balances complexity, maintainability and performance. I will create a separate query that selects FID column offset by page size. This way I am not querying an redundant row together with it’s geometry but also I am keeping…
-
2025/06/21 [GADM-api]
I refined logging mechanism and messages. I added severity levels (DEBUG, INFO, WARN, ERROR) and introduced middleware that logs each request. Also I installed the air package that re-builds and runs my server when I modify files.I discovered I can use Caddy for rate limiting. It seems very easy to setup and will save so…
-
Back to building apps
I am building another webapp – a chat room for my neighbors. The difference is that this time I will deploy it and focus on getting the users in.
-
SQL/Postgres – Relations and Join Command
In a relational database, each table typically stores information about a single entity, such as ‘Student,’ ‘School,’ or ‘Teacher.’ The process of combining information stored in rows across multiple tables is achieved through a method called table join. The ANSI SQL standard defines the `JOIN … ON` command to execute table joins.
-
SQL/Postgres – The Basics
I decided to take a closer look at various lower-level technologies to improve my general knowledge about programming and the web. I used to work a lot with high-level abstractions, meta-frameworks, systems, and libraries like Next.js, GCP, TypeORM, or GraphQL. They greatly increase development speed and offer a lot of functionality out of the box,…