Browsing Tag
postgres
31 posts
Using JSONB in PostgreSQL
Introduction JSONB, short for JSON Binary, is a data type developed from the JSON data type and supported…
Leveraging PostgreSQL CAST for Data Type Conversions
Converting data types is essential in database management. PostgreSQL’s CAST function helps achieve this efficiently. This article covers…
Docker Compose for a Full-Stack Application with React, Node.js, and PostgreSQL
The Premise So you’ve built a Full Stack application that you got working as you wanted, and want…
Introducing usage monitoring in Xata
We’re excited to announce a brand new feature to monitor what you’re using in your Xata workspace! Understandably…
PostgreSQL or MySQL: What Should I Choose for My Full-Stack Project?
Choosing the right database is a pivotal decision for full-stack developers, impacting everything from application performance to scalability.…
My binary vector search is better than your FP32 vectors
Within the field of vector search, an intriguing development has arisen: binary vector search. This approach shows promise…
Mastering Dynamic Task Scheduling with Redis: How We Actually Solved Our SAAS Problem?
I am thrilled to share my journey learning about and eventually solving intricate challenges using Redis’s powerful sorted…
Demystifying Materialized Views in PostgreSQL
Welcome back, dear readers! It’s been a while since I last shared my thoughts and insights through my…
Demystifying Apache AGE and PostgreSQL: Your Guide to Understanding Database Systems
Introduction: Navigating the world of database systems can be a daunting task, especially when faced with terms like…
