Browsing Tag
postgres
31 posts
Optimizing Database Performance with Indexing in Apache AGE and PostgreSQL
In the world of databases, performance is paramount. Apache AGE, an extension of PostgreSQL designed for managing graph…
How we made our Go microservice 24x faster
As data intensive backend applications scale and grow, with larger data sets scaled out to higher availability, performance…
Implementing hassle-free audits in the SQL database
A long standing question in computer science is whether we should ever remove the data. This applies to…
Advanced Features of PostgreSQL (Part 01)
Introduction: We will now discuss some more advanced features of SQL that simplify management and prevent loss or…
5 Reasons why you should choose PostgreSQL for your next Project!
In the ever-evolving landscape of data management, choosing the right database for your project can be a daunting…
How to add pg_embedding extension to PostgreSQL
The new pg_embedding extension was recently released, bringing exciting advancements by boosting graph-based approximate nearest neighbor search speed…
API’s, MUI, PERN, & more…
GitHub | LinkedIn | Twitter This week I worked on several tasks and gained experience with various technologies.…
Postgres schema changes are still a PITA
We software engineers don’t agree on much, but we agree on this one: database schema changes are a…
Chapter 3 Query Processing: Join Operations in PostgreSQL
In Relational databases, combining data from multiple tables is done by Join operations which play a very important…
Streamlining Database Connectivity and Oracle Compatibility with EDB Postgres Advanced Server
Introduction: In today’s digital landscape, seamless database connectivity and compatibility are crucial for organizations. EDB Postgres Advanced Server…