Best of PostgreSQL — January 2025

  1. 1
    Article
    Avatar of communityCommunity Picks·1y

    Making Beautiful API Keys

    Developers are often dissatisfied with the aesthetics and usability of conventional API keys. A startup focused on developer-first solutions created a new package called 'uuidkey' to solve this problem. This package encodes UUIDv7 using Crockford Base32 and adds dashes for symmetry and readability. These keys are secure, globally unique, sortable, and more visually appealing. The keys are also performant in PostgreSQL and designed for easy implementation.

  2. 2
    Video
    Avatar of wdsWeb Dev Simplified·1y

    Build A Course Platform LMS With Next.js 15, React 19, Stripe, Drizzle, Shadcn, Postgres

    The post provides a detailed tutorial on how to build a course platform LMS using Next.js 15, React 19, Stripe, Drizzle, and Postgres. The platform allows users to purchase individual courses or bundles, with functionalities for signing in, processing payments, viewing purchase histories, and marking course progress. The admin side includes dashboards to manage sales, refunds, courses, and products. Key practices include setting up databases with Drizzle, using the canary version of Next.js for the latest features, and integrating Clerk for user management. This comprehensive guide also covers best practices and the technical reasons behind various coding choices.

  3. 3
    Video
    Avatar of javascriptmasteryJavaScript Mastery·1y

    Build and Deploy a Fullstack App with Admin Dashboard | Next.js, PostgreSQL, Redis, Auth.js

    This post guides you through building and deploying a production-grade University Library management system using Next.js, PostgreSQL, Redis, and Auth.js. The project consists of two interconnected applications within a monorepo architecture, teaching industry-standard practices such as rate limiting, DDoS protection, caching, database queries, multimedia uploads, and automated workflows. Technologies like Tailwind CSS, Drizzle ORM, and ImageKit are used to create a polished and scalable application, catering to both user-facing and admin interfaces.

  4. 4
    Article
    Avatar of cybertec_postgresqlCYBERTEC PostgreSQL·1y

    PostgreSQL Development Introduction

    This post provides a comprehensive guide for absolute beginners on how to contribute to PostgreSQL development. It covers how to compile and install PostgreSQL using different build systems (Meson for version 16 and newer, GNU Autoconf for version 15 and older), set up a development environment, and create custom extensions. The guide walks through essential commands, environment setup, and debugging techniques, emphasizing the importance of understanding each step and practicing by breaking and fixing code.

  5. 5
    Article
    Avatar of communityCommunity Picks·1y

    Code snippet organizer for pros

    A detailed guide on setting up a Rails application on a DigitalOcean droplet using Ubuntu 16.04. The guide covers the creation of a non-root Rails user, adding swap space, installing and configuring NGINX, ElasticSearch, RVM, Rails, and Postgres. Additionally, it includes steps for deploying with Capistrano and securing the server with Let's Encrypt.

  6. 6
    Article
    Avatar of gcgitconnected·1y

    Why Knowing TOAST in PostgreSQL is necessary for Backend Devs!

    TOAST (The Oversized-Attribute Storage Technique) in PostgreSQL helps manage large data values exceeding the 8kB page size limit using compression and out-of-line storage. It supports various data types and uses four storage strategies: PLAIN, EXTERNAL, EXTENDED, and MAIN, each with different methods for managing oversized data. Understanding TOAST strategies can help optimize database performance.

  7. 7
    Article
    Avatar of neontechNeon·1y

    Build an end-to-end RAG pipeline entirely in psql using pgrag and DeepSeek

    Retrieval-Augmented Generation (RAG) pipelines can be built entirely within psql using the pgrag extension, which works alongside the pgvector extension to enable efficient semantic searches within Postgres. The pgrag extension simplifies both the preparation of document embeddings and the handling of questions to retrieve relevant information. Users can extract text, generate embeddings, rerank results, and prompt AI chat models like DeepSeek directly within their database environment.

  8. 8
    Article
    Avatar of bytesdevBytes by ui.dev·1y

    Bun is eating the world

    Bun 1.2 introduces major updates including improved Node.js compatibility, HTML imports for bundling JS and CSS, built-in S3 object support, native PostgreSQL bindings, and a text-based lockfile for easier diff viewing. These updates enhance Bun's efforts to become an all-in-one JavaScript toolchain.

  9. 9
    Article
    Avatar of tdsTowards Data Science·1y

    Designing, Building & Deploying an AI Chat App from Scratch (Part 1)

    Learn how to design, build, and deploy an AI-powered chat application from scratch with a focus on modern, scalable web applications. This guide covers microservices architecture, setting up various backend services with Docker containers, building REST APIs with FastAPI, and creating a simple user interface. Key components include a language model API, PostgreSQL database, private Docker network, and Nginx reverse proxy. The project emphasizes engineering and cloud deployment over using commercial platforms, providing a deeper understanding of real-world systems.

  10. 10
    Article
    Avatar of lnLaravel News·1y

    VS Code database management extension launches v2

    DevDb, a lightweight VS Code extension for database management, has launched version 2.0. This update includes new features like one-click row deletion, easy column value editing, SQL query explanation using MySQL Visual Explain, and more keyboard shortcuts. It supports SQLite, MySQL/MariaDB, PostgreSQL, and Microsoft SQL Server, making it versatile for various developers.

  11. 11
    Article
    Avatar of hnHacker News·1y

    Back to Basics: Why We Chose Long Polling Over WebSockets

    Learn how to implement real-time updates with Node.js, TypeScript, and PostgreSQL using HTTP long polling. This approach avoids the complexities of WebSockets, simplifies authentication and infrastructure compatibility, and retains standard HTTP observability. The post provides a detailed implementation guide, optimization tips, and comparisons with alternative solutions like ElectricSQL.

  12. 12
    Video
    Avatar of bytegradByteGrad·1y

    Prisma Postgres Is A Game Changer - Databases Are Changing Forever

    Prisma has released a new PostgreSQL database offering, which integrates several of their other products to create a comprehensive database management solution. It includes features such as Pulse for database event notifications, Accelerate for caching and query optimization, and Optimize for providing helpful tips on improving database queries. This integration allows users to manage many database-related tasks within a single platform, greatly simplifying the development process.

  13. 13
    Article
    Avatar of hnHacker News·1y

    PostgreSQL Anonymizer

    PostgreSQL Anonymizer is an extension for masking or replacing personally identifiable information (PII) or commercially sensitive data in a PostgreSQL database. It features a declarative approach to anonymization, allowing developers to define masking rules directly within the database schema. Various masking methods and functions are provided to apply data anonymization effectively. The extension also includes detection functions to identify columns needing anonymization. This helps enhance data privacy without compromising database functionality.

  14. 14
    Video
    Avatar of codeheimcodeHeim·1y

    #74 Golang - PostgreSQL with PGX in Go: Step-by-Step Tutorial

    Learn to use the PGX package to interact with PostgreSQL in Go. This tutorial covers installation, setting up connections, creating tables, inserting data, handling transactions, querying data, and updating and deleting records efficiently using PGX.

  15. 15
    Article
    Avatar of communityCommunity Picks·1y

    Forget SQL vs NoSQL - Get the Best of Both Worlds with JSON in PostgreSQL

    The post explains how to leverage JSON within PostgreSQL to combine the benefits of both SQL and NoSQL databases. It details the evolution of JSON support in PostgreSQL, from the introduction of the JSON data type to more advanced features like JSONB and JSONPath. Additionally, it covers how to create and query JSON data, the importance of indexing for performance, and common anti-patterns to avoid. The post concludes by comparing JSON in PostgreSQL with traditional NoSQL databases and outlines when it's best to use each approach.

See all PostgreSQL archives