@sagars01

PostgreSQL Distilled: The way of Postgres

Aug 31, 2023 · 14 min read · Chapter 3: The Way of PostgreSQL Introduction So, we have learnt the basic and essential concepts of PostgreSQL in Chapter 1 and Chapter 2 Now, let's delve a little deeper to know some of the cooler, more advanced stuff that’d be helpful for you whil...

Essential Concepts for PostgreSQL

Aug 20, 2023 · 13 min read · This is Chapter 2 of the series PostgreSQL Distilled, where I teach only the most important parts of PostgreSQL to aspiring Fullstack Engineers. Here is the Chapter 1: Getting Started with PostgreSQL Understanding the Building Blocks: Tables, Rows, a...

Getting Started with PostgreSQL

Aug 10, 2023 · 9 min read · Prerequisites You know basic SQL. You want to learn PostgreSQL for your upcoming project Introduction to PostgreSQL and Its Significance PostgreSQL, often referred to as Postgres is a powerful, open-source object-relational database management system...

Building a Conversational AI Using OpenAI, Faiss, and Flask

Jul 3, 2023 · 4 min read · In this blog post, we'll dive into a Python script that builds a conversational AI. We're using OpenAI's Language Model (LLM), the Faiss library for efficient similarity search of vectors, and Flask to create a web server that communicates with our c...

Frontend developers guide to databases.

Jun 16, 2023 · 8 min read · I was a front-end developer for 5 years before moving to fullstack development. As I gained experience I understood that businesses run on data and it is the only mission-critical component of the system. This note is for an exceptional front-end dev...