Prototyping is my favorite part of programming. I like building new stuff and getting things working. It’s no surprise, then, that I am a big fan of MongoDB and NoSQL in general. Don’t get me wrong: I ...

In order to access geometry data from OGR, the PostGIS extension has to be installed: if it is not installed, geometry will be represented as bytea columns, with well-known binary (WKB) values. To ...

💰 Mentorship to six figure software engineer - https://calcur.tech/mentorship ⚙️ Backend Engineering Mind Map - https://calcur.tech/mindmap 💻 System Design Playlist - ...

PostgreSQL with the pgvector extension allows tables to be used as storage for vectors, each of which is saved as a row. It also allows any number of metadata columns to be added. In an enterprise ...

In this article, we explore how Postgres, a powerful and versatile relational database, can be effectively used to model and traverse graphs and trees. While specialized graph databases exist, such as ...

Our previous blog article, “The Part of PostgreSQL We Hate the Most,” discussed the problems caused by everyone’s favorite street-strength DBMS multi-version concurrency control (MVCC) implementation.

Esri have added a nice example here of how a GeoJSON layer can be created using GeoJSON from a URL. This is great and very useful, however, it won't scale very well. The reason is because all of the ...

PostgreSQL semantic of temporary tables is substantially different from that of Oracle. Oracle temporary tables are permanent, so their structure is static and visible to all users, and the content is ...

I recently published a tutorial describing the different available methods to store data locally in an Android app. However, due to article length constraints, I could not adequately cover creating ...

In my last two articles, I looked at the Django Web application framework, written in Python. Django's documentation describes it as an MTV framework, in which the acronym stands for model, template ...