Excited about the latest news regarding our open-source agentic AI offerings for Postgres? Take part in the discussion on HackerNews - we'd love to hear what you think!

Leave feedback on the Agentic AI Toolkit: https://news.ycombinator.com/item?id=46304036

Or talk to us about the Postgres MCP server and natural language agent: https://news.ycombinator.com/item?id=46304050

Hope to hear from you 💬

#aiengineering #devcommunity #dev #opensource #postgresql #postgres #developer #developers #programming #llm #ai #mcp #hackernews #hacker #hn

Brand-new: an #OpenSource MCP server for #Postgres that (unlike others!) can be used independently with any standard version of Postgres 14+ (including Amazon #RDS).

Point it at your existing databases so your use of AI code builders and agents is not restricted to new greenfield development!

Learn more about the pgEdge MCP Server for Postgres (and how to connect it to Claude Code and Cursor!) here: https://www.pgedge.com/blog/introducing-the-pgedge-postgres-mcp-server

#agentic #agenticai #ai #llm #mcp #dev #postgresql #tech #programming

pgEdge Agentic AI Toolkit for Postgres: now available for free to all Postgres users. 🐘

Get everything from a full-featured MCP server, to Postgres extensions to support AI applications (including a RAG server!) all out-of-the box with fully open-source licensing. Compatible with all community Postgres distributions including Amazon #RDS.

Learn more about it in our latest blog: https://www.pgedge.com/blog/building-ai-agents-on-postgres-why-we-built-the-pgedge-agentic-ai-toolkit

#agenticai #aiops #programming #ai #llm #devops #tech #postgres #postgresql #opensource

The first #PostgreSQL #Edinburgh meetup was a success! Did you miss @vyruss delivering RAGTime with Postgres?

His comprehensive slides on learning about AI power with pgvector and Retrieval-Augmented Generation can be found here:

https://vyruss.org/computing/slides/postgresedi_ragtime_with_postgres.pdf

cc @PostgresEDI

#postgres #ai #aiops #llmops #llm #aiengineering #programming #opensource #tech #dev #devcommunity

Excited about the new open source utility pgedge-anonymizer for anonymizing sensitive information in your #PostgreSQL database? If you have any questions or just want to let us know what you think, join the discussion on HackerNews!

https://news.ycombinator.com/item?id=46290635

#dataprotection #cybersecurity #compliance #data #databaseadmin #securityengineer #datasecurity

If you've ever wanted to build a #RAG server with #PostgreSQL, now's your chance. Dave Page wrote a 3 part series using OpenAI, Voyage AI, or a local Ollama installation.

💡 Have you given it a try? Did you get a chance to experiment with other LLMs not covered by the article? What were your results? Let us know!

Find it all here:

1️⃣ : https://www.pgedge.com/blog/building-a-rag-server-with-postgresql-part-1-loading-your-content

2️⃣ : https://www.pgedge.com/blog/building-a-rag-server-with-postgresql-part-2-chunking-and-embeddings

3️⃣ : https://www.pgedge.com/blog/building-a-rag-server-with-postgresql-part-3-deploying-your-rag-api

#ollama #llama #postgres #api #openai #voyageai #devops #dev #devcommunity

Ever wondered if there is an easier way to anonymize sensitive data for addressing data privacy regulations such as GDPR, CCPA, & HIPPA? There is now!

Introducing the pgEdge Anonymizer, an open source utility that replaces PII in #PostgreSQL databases with realistic fake values while preserving referential integrity & data consistency.

Read more about it here: https://www.pgedge.com/blog/anonymising-pii-in-postgresql-with-pgedge-anonymizer

#cybersecurity #audit #dataprivacy #data #datamanagement #dataadministration #dba #postgres #opensource #tech

In our latest video, Solution Engineer Paul Rothrock demonstrates how pgEdge's Zero Downtime Add Node feature within Spock enables seamless cluster scaling and major version upgrades—without any service interruption.

Scripts to automate this process are available here: https://github.com/pgEdge/spock/tree/main/samples/Z0DAN

Check it out: 👉 https://www.pgedge.com/video/new-feature-highlight-zero-downtime-add-node

All pgEdge software is 100% open source under the PostgreSQL license.

#developers #programming #database #data #tech #technology #opensource #postgresql #postgres

That’s a wrap on the first #PostgreSQL #Edinburgh #meetup! 🐘

Huge thanks to @intrbiz for the talk, @pgEdgeDistributedPostgres for the 🍕, and UoE for the venue.

Slides:
🔹 PG Tricks: https://nexteam.co.uk/files/talks/pg-tricks-postgresedi-meetup.pdf
🔹 RAGtime with #Postgres: https://vyruss.org/computing/slides/postgresedi_ragtime_with_postgres.pdf

We return Feb 12th and need speakers! 🎤 DM/reply if you have a talk idea or feedback!

Happy holidays! 🎄

#TechMeetup #OpenSource #Database

In the final post of the "Building a RAG Server with PostgreSQL" series, learn how to deploy the open-source pgEdge RAG Server for a simple HTTP API you can use to ask questions about your content, and get answers based on your own documentation.

Check it out 👉 https://www.pgedge.com/blog/building-a-rag-server-with-postgresql-part-3-deploying-your-rag-api

Experiment with the RAG Server on #GitHub: https://github.com/pgEdge/pgedge-rag-server

Want to see more of this kind of content? Let us know 💬

#programming #ai #llm #vectordatabase #pgvector #vector #postgresql #postgres #data

Why did we create snowflake sequences when UUIDs exist? ❄️

While they're very similar in purpose, snowflake sequences are more efficient because they encode information like the creation timestamp & the ID of the server that created it in half the size (8 bytes vs. 16 bytes).

They're a huge asset for unique ID management & key generation in distributed databases. Learn more about them here: https://www.pgedge.com/blog/introducing-snowflake-sequences-in-a-postgres-extension-2

#postgresql #postgres #programming #tech #databases #data #devops #opensource

pgEdge Vectorizer: an open-source #PostgreSQL extension that automatically chunks text content and generates #vector embeddings using background workers.

Dave Page's latest blog "Building a RAG Server with PostgreSQL - Part 2: Chunking and Embeddings" walks you through how to use this extension to create a searchable vector database that can find relevant content based on context instead of exact keyword matching.

Check it out ➡️ https://www.pgedge.com/blog/building-a-rag-server-with-postgresql-part-2-chunking-and-embeddings

Part 3 coming soon!

#ai #llm #pgvector

Local to #Edinburgh? The next #PostgreSQL Edinburgh Meetup is this Thursday, December 11 and you'll be able to catch @vyruss delivering "RAGTime with Postgres: AI Power with pgvector and Retrieval-Augmented Generation".

It's bound to be a great deal of fun - register here if you'd like to attend: https://luma.com/b9kv5fds

Too far to join, but still want to learn about the topic? Let us know 💬

#scotland #postgres #devcommunity #rag #ai #pgvector #llm #aiengineering #programming #engineering

Now, you can use open-source pgEdge components designed for high-availability & multi-master replication combined with #CloudNativePG for cloud-native #PostgreSQL orchestration.

Our goal was to make it easy for developers to adopt powerful open-source and vendor lock-in free solutions.

How are you currently managing your Postgres deployments on Kubernetes? 💬

Find the full video on YouTube: https://www.youtube.com/watch?v=r442LvNxaoE

#postgres #kubernetes #cloudnative #devops #opensource #database #devcommunity

Did you miss it? The new pgEdge Control Plane is a 100% open source declarative API for managing Postgres clusters with flexible deployment options (like single-primary with failover replicas, and multi-zone active-active infrastructure).

You can also add logical nodes without downtime and use the API for quick and easy failover and switchover.

Read more about how it's used and how to install it on our blog: https://www.pgedge.com/blog/introducing-the-pgedge-control-plane-high-availability-postgres-simplified

#programming #coding #opensource #postgresql #postgres #foss

pgEdge's Dave Page took part in sharing big data and database/infrastructure predictions for 2026 in one of DBTA's latest articles. What changes would you like to see within the PostgreSQL project to shift how the project is currently run?

Check out his and other expert predictions for 2026, here: www.dbta.com/Editorial/News-Flashes/Experts-Give-8-Big-Data-Predictions-for-2026-172655.aspx

#programming #postgresql #postgres #data #opensource #devcommunity #dev #developer #bigdata #devops #tech

If you've ever wondered how to build your own RAG server with #PostgreSQL, now's your chance to learn. Dave Page kicks off a multi-part series on the topic in our latest blogpost, covering topics like..

⭐ Why PostgreSQL for RAG?
⭐ How to set up the database
⭐ How to install the document loader
⭐ Working with different source formats
⭐ Handling multiple documentation sets

..and much more.

Here’s the link to the first, stay tuned for the rest: https://www.pgedge.com/blog/building-a-rag-server-with-postgresql-part-1-loading-your-content

#ai #rag #llm #postgres

Snowflake sequences: for generating unique identifiers in #PostgreSQL, while avoiding conflicts and other errors that can occur when operating a multi-master database cluster.

It is now easier than ever to install using the pgEdge Control Plane, our Helm chart, our container images, or any other mode of installation for pgEdge Enterprise and Distributed #Postgres.

📖 Read more about it in our updated blog: https://www.pgedge.com/blog/introducing-snowflake-sequences-in-a-postgres-extension-2

#programming #opensource #developers #dev #data #k8s #kubernetes

We’re excited to share that pgEdge Enterprise Postgres has been named one of DBTA’s Trend-Setting Products in Data & Information Management for 2026.

This recognition reinforces our commitment to 100% open source, fully standard #PostgreSQL that provides organizations with the reliability, manageability, and enterprise-class support they need to scale #Postgres across demanding workloads.

Read the full list here: 🔗 https://www.dbta.com/Editorial/Trends-and-Applications/Trend-Setting-Products-in-Data-and-Information-Management-for-2026-172607.aspx?PageNum=6

#programming #opensource #tech #technology #developers

What happens when a conflict cannot be resolved in a distributed database system, such as when there's network or hardware failures?

Here, Paul Rothrock discusses how pgEdge handles duplicate or missing primary keys, and missed DDL statements.

Curious to know more about the snowflake sequences extension mentioned in the video? Find it on GitHub: https://github.com/pgEdge/snowflake

Find the full video on YouTube: https://youtu.be/prkMkG0SOJE

#programming #postgres #postgresql #dataarchitecture #software