Best of PostgreSQL — 2024

  1. 1
    Article
    Avatar of bytebytegoByteByteGo·2y

    EP128: The Ultimate Software Architect Knowledge Map

    Discover the ultimate knowledge map for software architects, exploring essential skills such as mastering programming languages, tools, design and architectural principles, platform knowledge, data analytics, networking, and supporting skills. Learn about the wide-ranging capabilities of PostgreSQL, from time-series data to federated querying and graph databases. Gain insights into advancing from a junior to a senior developer, covering collaboration tools, programming languages, API development, authentication, and system design.

  2. 2
    Article
    Avatar of hnHacker News·2y

    Postgres is eating the database world

    PostgreSQL is an advanced, open-source, and extensible data management framework that is capable of competing with Oracle and MySQL. It offers a wide range of analysis-related extensions and has the potential to become a unified, super-converged database. The emergence of PostgreSQL has shifted the paradigms in the database domain, and it is now considered a mainstream best practice. In the future, the focus will be on database extensions and services, and PostgreSQL ecosystem extensions are expected to lead the way towards a monopoly.

  3. 3
    Article
    Avatar of crunchydataCrunchy Data·2y

    Announcing an Open Source Monitoring Extension...

    Crunchy Data has introduced a new open-source pgMonitor extension aimed at improving PostgreSQL monitoring. The extension enhances query performance and simplifies metric collection by leveraging materialized views and background workers. It offers broad compatibility with various monitoring systems, ensures consistent metric updates, and adapts easily to changes in PostgreSQL versions. Users can also define custom metrics and refresh intervals to meet specific needs.

  4. 4
    Article
    Avatar of hnHacker News·2y

    Making a Postgres query 1,000 times faster

    The author shares their journey of optimizing a Postgres query to make it 1,000 times faster. They discovered that the query was taking longer and longer each time it was executed due to processing all rows in the table and the use of a filter instead of an index condition. By using row constructor comparisons, they were able to significantly improve the query performance.

  5. 5
    Article
    Avatar of hnHacker News·2y

    ChartDB

    ChartDB is a free and open-source database design editor that simplifies the creation of database diagrams. It allows users to import, edit, and export database schemas using a single query, supporting popular relational DBMS like MySQL, MariaDB, PostgreSQL, Microsoft SQL Server, and SQL Lite. Features include a visual query editor, the ability to add tables and notes, and exporting diagrams as SQL scripts or images.

  6. 6
    Article
    Avatar of communityCommunity Picks·2y

    Don't query your PostgreSQL db anymore, prefer PostgREST

    The post discusses the benefits of using PostgREST to replace traditional SQL queries in PostgreSQL databases. It outlines the process of setting up PostgREST, a standalone web server that converts PostgreSQL databases into RESTful APIs, simplifying database interactions. The author shares their experience migrating from MySQL to PostgreSQL and how PostgREST helped streamline their PHP code by eliminating direct SQL queries. The post includes a tutorial on setting up and using PostgREST with Docker, illustrating various query examples and security considerations.

  7. 7
    Article
    Avatar of bytebytegoByteByteGo·2y

    EP119: What do Amazon, Netflix, and Uber have in common?

    Amazon, Netflix, and Uber excel at scaling their systems using strategies such as stateless services, horizontal scaling, load balancing, auto-scaling, caching, database replication, sharding, and asynchronous processing. Figma achieved 100X Postgres scaling by implementing vertical and horizontal partitioning, and using tools like PgBouncer and a custom DBProxy service. Additionally, the post highlights the importance of robust testing techniques like unit, integration, system, load, and error testing to ensure software functionality and performance.

  8. 8
    Article
    Avatar of collectionsCollections·2y

    Databases In-Depth – Complete Course

    A comprehensive course on database architecture and optimization, designed by Keerti Purswani and available on freeCodeCamp.org's YouTube channel. It covers transaction management, storage engines, advanced indexing techniques, an in-depth look at SQLite, and understanding MongoDB and PostgreSQL. Suitable for both beginners and experienced engineers, the course aims to equip learners with the skills to manage and optimize data systems efficiently.

  9. 9
    Article
    Avatar of hnHacker News·1y

    outerbase/studio: A lightweight Database GUI in your browser. It supports connecting to Postgres, MySQL, and SQLite.

    Outerbase Studio is a lightweight, browser-based GUI for managing SQL databases, initially built for LibSQL and SQLite but now supporting a range of databases including MySQL and PostgreSQL. It features a user-friendly query editor, a powerful data editor, a schema editor, and a flexible connection manager. The desktop apps for Windows and Mac offer additional support for drivers not feasible in a browser environment.

  10. 10
    Article
    Avatar of communityCommunity Picks·2y

    The Ultimate Open Source Starter Kit

    The Ultimate Open Source Starter Kit provides a modern stack using Neon.tech for a serverless PostgreSQL database, Next.js, Lucia Auth, Bun, Vercel, ShadCN, Tailwind CSS, and Typescript. Designed for rapid SaaS deployment, the kit includes light/dark mode, and a blog feature with MDX for content management. It offers a robust and scalable foundation easily customizable for your specific needs.

  11. 11
    Video
    Avatar of youtubeYouTube·2y

    Build a Full Stack React Native App with Payments | PostgreSQL, TypeScript, Stripe, Tailwind

    The post describes a comprehensive course on building a full-stack mobile app using React Native. Highlights include creating an Uber clone with 15 screens and advanced features like Expo router, global state management with Zustan, Expo Location, PostgreSQL database, email authentication with Clerk, and Stripe payments. The course aims to teach a wide range of essential mobile app development skills including splash screens, custom tabs, navigation models, Google Maps integration, and responsive design across devices. It also introduces useful development tools like WebStorm for enhanced productivity.

  12. 12
    Article
    Avatar of hnHacker News·2y

    teableio/teable: ✨ A Super fast, Real-time, Professional, Developer friendly, No code database

    Teable is a super fast, real-time, professional, developer-friendly, no-code database built on Postgres. It offers a simple, spreadsheet-like interface, supports various data views, and integrates with popular software tools. It aims to meet the evolving demands of modern software development.

  13. 13
    Article
    Avatar of freecodecampfreeCodeCamp·2y

    How to Build an Admin Dashboard with React

    Learn how to build a stunning admin dashboard with React and Next.js. Discover important Next.js concepts and powerful tools like Prisma, PostgreSQL, Tremor, NextAuth, and TailwindCSS.

  14. 14
    Article
    Avatar of communityCommunity Picks·2y

    PGlite - run Postgres everywhere

    PGlite is a WASM-based Postgres database that works in various JavaScript runtimes, including NodeJS, BUN, Deno, and browsers. It's lightweight, supports popular Postgres extensions, and is ideal for local-first applications, prototypes, local caches, and CI pipelines. The database can be easily installed via npm and used with regular SQL queries.

  15. 15
    Article
    Avatar of supabaseSupabase·2y

    The Open Source Firebase Alternative

    FerretDB is an open source document database that adds MongoDB compatibility to other database backends like Postgres and SQLite. This post explains how to run FerretDB locally via Docker, test it with mongosh, and deploy it on Fly.io for production.

  16. 16
    Article
    Avatar of freecodecampfreeCodeCamp·2y

    How to Build an Invoice SaaS App with Next.js, Resend, Clerk and Neon Postgres

    This tutorial guides you through building a complete invoicing web application using Next.js, Resend, Clerk, and Neon Postgres. Key functionalities include managing customers, creating invoices, printing and sending invoices via email, and handling real-time communication between the frontend and backend. You'll gain experience with setting up a Postgres database, implementing user authentication with Clerk, and using React-to-print for PDF generation.

  17. 17
    Article
    Avatar of devtoDEV·2y

    When to use SQL vs NoSQL

    Choosing between SQL and NoSQL databases can be daunting. SQL excels in data consistency and complex querying, while NoSQL offers scalability and flexibility. Common misconceptions include inflexibility of SQL databases and the lack of transactional support in NoSQL.

  18. 18
    Article
    Avatar of supabaseSupabase·2y

    postgres.new: In-browser Postgres with an AI interface

    Introducing postgres.new, an in-browser Postgres sandbox with AI assistance. It allows the creation and management of Postgres databases directly in the browser using PGlite, a WASM version of Postgres. Key features include drag-and-drop CSV import, report generation, chart creation, and database diagram construction. The platform leverages a large language model for autonomous database operations, and it supports semantic search with pgvector. Future enhancements include deploying databases to S3 and supporting more file types.

  19. 19
    Article
    Avatar of supabaseSupabase·2y

    Supabase + Vercel Partnership

    Vercel has launched official First-Party Integrations, including Supabase, making it easier to manage Postgres databases directly from the Vercel dashboard. This integration supports Vercel Templates, unified billing, and offers dedicated Postgres instances, modular building blocks like AI and Auth, low latency with read replicas, and secure, scalable solutions. It's currently in Public Alpha as of August 28, 2024.

  20. 20
    Article
    Avatar of communityCommunity Picks·2y

    7+ Free PostgreSQL Hosting Platforms for Developers in 2024

    Several cloud providers offer free tiers for PostgreSQL hosting, ideal for developers working on small projects, personal experiments, or startup MVPs. Notable platforms include Neon, Supabase, EdgeDB, Xata, Tembo, Vercel Postgres, Koyeb, Aiven, and Nhost. These options provide scalable, fully managed databases with features like autoscaling, database branching, and integrated authentication, allowing developers to focus on development without worrying about infrastructure costs.

  21. 21
    Article
    Avatar of communityCommunity Picks·2y

    Simplifying Your Tech Stack with PostgreSQL

    Simplifying your tech stack with PostgreSQL can streamline development, reduce operational complexity, and minimize moving parts. PostgreSQL can efficiently replace multiple technologies such as Kafka, RabbitMQ, MongoDB, and Redis, supporting functionalities like caching, message queuing, data warehousing, and full-text search. This approach enhances developer productivity, reduces cognitive load, and ensures robust performance and flexibility. Developers benefit from PostgreSQL's comprehensive support for JSON, geospatial queries, auditing, and more, providing a powerful and scalable backend solution.

  22. 22
    Article
    Avatar of lobstersLobsters·1y

    7 Databases in 7 Weeks for 2025

    This post discusses seven databases that are worth exploring in 2025, each offering unique capabilities and use cases. It covers PostgreSQL, SQLite, DuckDB, ClickHouse, FoundationDB, TigerBeetle, and CockroachDB, highlighting their key features and suggesting practical experiments to deepen understanding. This mix includes both well-established and emerging technologies, offering insights into client-server models, embedded databases, analytics, financial transaction processing, and globally distributed databases.

  23. 23
    Article
    Avatar of communityCommunity Picks·2y

    Can Postgres replace Redis as a cache?

    The post discusses the possibility of using Postgres as a cache instead of Redis, highlighting that while Postgres can simplify the technology stack and reduce costs, it lacks the performance and specialized features of Redis. Unlogged tables in Postgres improve write performance but not read performance. Moreover, Redis offers built-in features like expiration and eviction policies that are complex to implement in Postgres. Ultimately, Redis is recommended for its superior performance and simplicity in use as a caching solution.

  24. 24
    Article
    Avatar of hnHacker News·2y

    Postgres is Enough

    This post discusses various use cases and libraries for working with PostgreSQL, including background jobs, message queues, GIS/mapping, audit logs, access control, search, foreign data integration, and HTTP.

  25. 25
    Article
    Avatar of communityCommunity Picks·2y

    How I built my open-source Social media scheduling tool... 🤯

    Postiz, an open-source social media scheduling tool, leverages OAuth2 for authentication across different platforms. It uses Redis for queue management to schedule posts and Prisma ORM for database operations with PostgreSQL. The tool's architecture supports horizontal scaling with microservices called 'Workers' to handle post jobs efficiently.

See all PostgreSQL archives