How to Build Full-Stack PostgreSQL + Flask GUI App in 20 Minutes 🚀 From Static to Live Published Website
There’s something incredibly satisfying about watching, or in my case, describing the transformation of a simple “Hello World” program into a fully functional, live social media platform. It’s like watching a small seedling mature into a towering tree—except this kind of growth happens on a screen and not in the soil. Let’s take a deep […]
Read More
Can Postgres replace your entire stack?
When we think of the essentials of web development, a few key tools and technologies immediately pop to mind. Over a decade ago, when I first dipped my toes into programming, the LAMP stack was the toolkit du jour for web developers. Part of this stack—and a significant part—was MySQL. Ah, MySQL, the friendly neighborhood […]
Read More
Introducing RAG 2.0: Agentic RAG + Knowledge Graphs (FREE Template)
In AI-driven knowledge retrieval, blending multiple strategies can create a potent mix that pushes the boundaries of how machines access and process information. In my recent foray into the world of AI agents, I’ve been particularly captivated by two pivotal tools: vector databases and knowledge graphs. These tools, when combined, form a robust system known […]
Read More){kind=link}
Why 99% of Developers Don’t Get PostgreSQL
Have you ever found yourself at the wheel of a car that’s smooth, powerful, and just responds in a way that other cars do not? That’s akin to harnessing the capabilities of PostgreSQL over your standard-issue MySQL. It’s about understanding not just the machinery but the engineering philosophy that powers it. PostgreSQL, often just called […]
Read More
Postgres 18 just dropped. Now is the best time to learn it!
Let’s not mince words—database updates aren’t typically the stuff of headlines unless you’re deep in the tech trenches. But with PostgreSQL 18 poised at the starting gate, it’s time to divert our gaze to this underappreciated workhorse of the digital world. After all, PostgreSQL doesn’t just power side projects on shoestring budgets—it’s the backbone of […]
Read More
What is Patroni, really? | POSETTE: An Event for Postgres 2025
This week, I caught this riveting presentation by Polina Bungina, a senior software engineer at Zalando and co-maintainer of the Patroni project. It was truly fascinating to delve into the inner workings of Patroni, and I’d like to distill some of the key insights from her talk. Patroni is indeed a kind of game-changer. It […]
Read More
The Unseen Efficiency: A Tale of Two Databases
-
Frank
- October 19, 2024
- anton putra
- Backend Development
- Database Benchmarking
- Database Comparison
- Database Management Systems
- Database Performance
- Database Speed Test
- DevOps
- it infrastructure
- mySQL
- MySQL Performance
- MySQL vs PostgreSQL
- Open Source Databases
- Performance Benchmark
- Postgres
- PostgreSQL
- PostgreSQL Performance
- postgresql vs mysql
- Programming
- Relational Databases
- Software Performance
- SQL Databases
- SQL Performance
- Web Development
In the relational databases, a silent battle rages on, one that’s as critical as it is invisible to the untrained eye. It’s a contest not of strength or speed in the traditional sense, but of efficiency, reliability, and scalability. Today, we delve into the heart of this battle, comparing two giants of the database world: […]
Read More
The Art of Semantic Search in Django: A Journey with Postgres and pgvector
Here’s a video of a conference talk about semantic search with Django, PostgreSQL, and pgvector presented by Paolo Melchiorre at POSETTE: An Event for Postgres 2024. Artificial intelligence is now a required functionality in many fields, and we often find ourselves needing to add to existing projects. The first problem to face is that of […]
Read More
Armchair Architects: LLMs & Vector Databases (Part 1)
-
Frank
- December 12, 2023
- armchair architects
- artificial intelligence
- Azure
- azure ai engineer
- azure enablement show
- Cloud Computing
- cloud computing tutorial
- cloud solution architect
- cloud solutions
- dev
- Development
- large language model fine tuning
- large language model interview questions
- large language model training
- large language models
- large language models explained
- Microsoft
- PostgreSQL
- Tech
- Technology
- vector database
- vector database azure
- vector database use case
Vector databases are designed to store, manage, and index massive quantities of high-dimensional vector data efficiently that can help different types of queries, such as nearest neighbor. In this episode of the Azure Enblement Show, Uli, Eric and David discuss how vector databases convert data to integers, cover some of the use cases of vector […]
Read More){kind=link}
Have We Been Using Redis Wrong the Whole Time?
This video is from Dreams of Code. Redis happens to be one of my more favorite databases out there, but I often relegate it to the caching layer in my application stack. In this video, I decided to look at how to use redis as a database, rather than as a cache, and how that […]
Read More