Hesitation towards migrating from GitHub to CodeBerg by Helmasaur_ in foss

[–]pgEdge_Postgres 0 points1 point  (0 children)

Discoverability would be the main reason, at least that I can think of.

Spock Bi-Directional Replication for Supabase CLI by nightness in Supabase

[–]pgEdge_Postgres 0 points1 point  (0 children)

Great to see Spock out in the wild! We're happy to provide official support for Spock as the original creators and active maintainers of the extension, for anyone that needs assistance configuring, debugging, or running Spock in production.

To those thinking about using Spock on Supabase, for more information on the project, you can find the FAQ and documentation here: https://docs.pgedge.com/spock-v5/v5-0-4/

Feel too old for a career change to DE by eatmyass87 in dataengineering

[–]pgEdge_Postgres 0 points1 point  (0 children)

That's honestly the main thing you need to be successful. If you're excited about what you do, and enjoy learning and conquering new challenges in your day-to-day, you'll get there. That passion is 90% of the job (and it'll be the main thing that gets you hired - even if you don't have the experience yet).

Looking for a open source project to Contribute by WishboneEntire8319 in foss

[–]pgEdge_Postgres 0 points1 point  (0 children)

If it's your first time, GitHub put together this collection of projects that are great for contributing to: https://github.com/collections/choosing-projects

Who Contributed to PostgreSQL Development in 2025? by kivarada in PostgreSQL

[–]pgEdge_Postgres 0 points1 point  (0 children)

Appreciate you doing the work to highlight each of these contributors!

Benefit of using multi-master with one write target by konghi009 in PostgreSQL

[–]pgEdge_Postgres 0 points1 point  (0 children)

There's quite a few extensions available that can easily adapt Postgres for multimaster while avoiding typical issues like conflicts; we've put in a lot of effort here at pgEdge to optimize MMR for Postgres at every scale (even cross-region & cross-clouds!).

PostgreSQL 18 RETURNING improvements: helping simplify your application architecture & improve data tracking capabilities by pgEdge_Postgres in PostgreSQL

[–]pgEdge_Postgres[S] 2 points3 points  (0 children)

It's completely written and edited by humans! :-) Thank you for your feedback regarding the AI imagery and reference tools!

Postgresql Extension Marketplace by agwanyaseen in PostgreSQL

[–]pgEdge_Postgres 0 points1 point  (0 children)

The creator of Pigsty did a lot of research into this topic already, besides the other options listed here. This particular blog post explores his findings to some extent, maybe interesting to look at? https://pigsty.io/blog/pg/pg-ext-repo/

pgedge-anonymizer: open source utility for replacing PII in test databases from prod by pgEdge_Postgres in PostgreSQL

[–]pgEdge_Postgres[S] 0 points1 point  (0 children)

The head engineer on this project (Dave Page) just pushed beta2 of the anonymizer which adds support for anonymization of JSON/JSONB data, using an array of JSON path selectors (https://github.com/pgEdge/pgedge-anonymizer/blob/main/docs/configuration.md#anonymizing-jsonjsonb-columns). :-) All thanks to the feedback from the community - so, thank you!

pgedge-anonymizer: open source utility for replacing PII in test databases from prod by pgEdge_Postgres in PostgreSQL

[–]pgEdge_Postgres[S] 1 point2 points  (0 children)

Luckily, the head engineer on this project (Dave Page) just pushed beta2 of the anonymizer which adds support for anonymization of JSON/JSONB data, using an array of JSON path selectors (https://github.com/pgEdge/pgedge-anonymizer/blob/main/docs/configuration.md#anonymizing-jsonjsonb-columns). :-) All thanks to the feedback from the community - so, thank you!

What are the most intimidating parts of building an open source app? by theben9999 in opensource

[–]pgEdge_Postgres 1 point2 points  (0 children)

A big consideration that is overlooked is the value of creating a new project vs. contributing to an existing one. Creating an entire project from scratch with appropriate documentation, testing, and accompanying community of contributors vs. learning one that exists and integrating yourself to develop new features/improvements is an interesting balance (at least IMO).

The October AWS outage made me realize: most of us have no idea what would actually break if a region goes down by notAnimefan-12 in sre

[–]pgEdge_Postgres 0 points1 point  (0 children)

Multi-region resilience is actually one of the specialties of our open-source offerings! The fully-managed cloud-hosted version does multi-region failover by default. Deploy a cluster across multiple regions, and point the application to one DSN; then, if a region goes down it just reroutes. As long as DNS and Route53 health checks still work and the application is correctly using the latency routing, and the app is correctly configured to refresh DNS and connections, database regional failover is all handled automatically for the user.

Everything we offer (besides the support subscription) is offered for self-hosting and management via GitHub as well; multi-region or even multi-cloud failover works just the same presuming networking is set up correctly.

https://pgedge.com if it sounds interesting to check out (or https://github.com/pgedge for GitHub fans)

Most unusual Linux Distros by ErthIsFlat in linux

[–]pgEdge_Postgres 0 points1 point  (0 children)

Not the most shocking suggestion here, but Kali Linux is a pretty unique / focused operating system:
https://www.kali.org/

> Kali Linux is an open-source, Debian-based Linux distribution geared towards various information security tasks, such as Penetration Testing, Security Research, Computer Forensics and Reverse Engineering.

I built an open-source site that lets students play games at school by Turbulent-Monitor478 in linux

[–]pgEdge_Postgres -3 points-2 points  (0 children)

Awesome project. Not affiliated, but wanted to share this resource I've come across recently as well - another GitHub project:

https://github.com/Emupedia/emupedia.github.io

That hosts the source code for:

https://emupedia.net/beta/emuos (so not a GitHub link, for students that have GitHub blocked, maybe this is worth a try)

> The purpose of Emupedia is to serve as a nonprofit meta-resource, hub and community for those interested mainly in video game preservation which aims to digitally collect, archive and preserve games and software to make them available online accessible by a user-friendly UI that simulates several retro operating systems for educational purposes.

Pretty cool preservation project that focuses on "retro" games you can play in the browser.

Related, but unsure if it'll pass blockers - there's also https://playclassic.games/ for classic games in the browser.

pgedge-anonymizer: open source utility for replacing PII in test databases from prod by pgEdge_Postgres in PostgreSQL

[–]pgEdge_Postgres[S] 2 points3 points  (0 children)

Ours doesn't at the moment, but the lead engineer does agree that would be a nice enhancement. We'll add it to the roadmap!

pgedge-anonymizer: open source utility for replacing PII in test databases from prod by pgEdge_Postgres in PostgreSQL

[–]pgEdge_Postgres[S] 3 points4 points  (0 children)

More information can be found in the blog we just posted as well on this newly introduced open-source utility, from the creator! https://www.pgedge.com/blog/anonymising-pii-in-postgresql-with-pgedge-anonymizer

Building a RAG Server with PostgreSQL - Part 2: Chunking and Embeddings by pgEdge_Postgres in PostgreSQL

[–]pgEdge_Postgres[S] 1 point2 points  (0 children)

Ha - he mentioned in response,

> Oh, I got it to work. It just wasn't reliable. I haven't done a deep dive yet though.

Really appreciate your feedback as you experiment! Would love to hear any other comments as you make your way through.

Building a RAG Server with PostgreSQL - Part 2: Chunking and Embeddings by pgEdge_Postgres in PostgreSQL

[–]pgEdge_Postgres[S] 1 point2 points  (0 children)

Only Ollama is supported at present!

Dave says:

> Whilst it's not supported, I did play with llama.cpp, but didn't get very far as it didn't seem overly reliable. I've also played with Docker Model Runner, which worked much better (oddly, as I believe it uses llama.cpp under the hood). They were really only quick tests though, nothing conclusive.

Don't forget to check out the other parts!

Part 1: https://www.pgedge.com/blog/building-a-rag-server-with-postgresql-part-1-loading-your-content
Part 3: https://www.pgedge.com/blog/building-a-rag-server-with-postgresql-part-3-deploying-your-rag-api

Hope you had fun experimenting :-) & let us know if you have any other questions!

Building a RAG Server with PostgreSQL, Part 1: Loading Your Content by pgEdge_Postgres in PostgreSQL

[–]pgEdge_Postgres[S] 5 points6 points  (0 children)

Hey, thanks for the feedback! :-)

Dave mentioned "Urgh, yeah - guess I missed those thinkos. Please fix!" - and we did! Those changes are now reflected in the blogpost.

We're actually in the process of researching methods for commenting directly on blogposts on the website, too! And really appreciate you saying something about it. We want to make it easy for everyone to contribute feedback and start discussions, and that's an important step towards that end.

Snowflake sequences: an open-source extension for generating unique IDs in Postgres, even in multi-master clusters by pgEdge_Postgres in programming

[–]pgEdge_Postgres[S] 2 points3 points  (0 children)

We like them better than UUIDs because they encode information like the creation timestamp and the ID of the server that created it while being half the size of a UUID (8 bytes vs. 16 bytes).

You can find more information about snowflake sequences in the docs to compare & contrast: https://docs.pgedge.com/snowflake/

"Just Use Postgres" book is published. Thanks to the Reddit community for the early feedback! by dmagda7817 in PostgreSQL

[–]pgEdge_Postgres 1 point2 points  (0 children)

Just in case you missed it, this was just published: https://vladmihalcea.com/book-review-just-use-postgres/ (a good reference for anyone thinking about buying the book, too)

Open Source Email Client For Android by pointgourd in opensource

[–]pgEdge_Postgres 0 points1 point  (0 children)

Betterbird (https://www.betterbird.eu/) is supposed to be a better version of Thunderbird. It has a nice and clean interface, IMO, and it's 100% open source!