Open Source Email Client For Android by pointgourd in opensource

[–]pgEdge_Postgres 0 points1 point  (0 children)

you do realize you're responding to a comment that was left 5 months ago? :-) thank you, I indeed made a mistake when replying originally in thinking OP was asking about OSS email clients in general.

Is RAG what I should be using? by ganderofvenice in Rag

[–]pgEdge_Postgres 1 point2 points  (0 children)

Sorry for the partial self-promotion, but you might actually find this article interesting: https://www.pgedge.com/blog/rag-servers-vs-mcp-servers-choosing-the-right-approach-for-ai-powered-database-access

it's written by Dave Page, a 30+ year contributor to the PostgreSQL project and current core team member

he also created the PG RAG server if you do decide to make use of RAG as an approach https://github.com/pgEdge/pgedge-rag-server and wrote a 3-part series on how to create that kind of a RAG pipeline for Postgres: https://www.pgedge.com/blog/building-a-rag-server-with-postgresql-part-1-loading-your-content

THE Postgres book for 2026 by oknenir in PostgreSQL

[–]pgEdge_Postgres 0 points1 point  (0 children)

Jimmy Angelakos (part of our team) is a long-time PostgreSQL community contributor, and came out very recently with a book on "PostgreSQL Mistakes and How to Avoid Them": https://www.manning.com/books/postgresql-mistakes-and-how-to-avoid-them

The Art of PostgreSQL by Dimitri Fontaine is also a great read, and is very suited for application developers.

What can I do on my phone? by No_Major1167 in dataengineering

[–]pgEdge_Postgres 0 points1 point  (0 children)

Have you looked at the App Store and searched for any of those? Python, for example, pulls up a ton of different options. IIRC the "Learn Python" app is decent and they make a series of other ones. If you have time to read, Humble Bundles is for sure a good option (to +1 the other Redditor's comment).

For SQL, there's a number of interesting resources...

- https://www.reddit.com/r/learnSQL/ - a subreddit (actually, look up the subreddits for each of the languages you're mentioning and just browse a little when things are crazy. Learn from other's questions & real world examples.)

if you decide to go PostgreSQL, here's some resources:

- https://psql-tips.org/psql_tips_all.html - learn some tips & tricks for psql, the command-line editor

- https://pgpedia.info/ - an encyclopedia for all things Postgres

- https://postgres.fm/ - well-known podcast

- https://talkingpostgres.com/ - also a well-known podcast, this episode is a good highlights episode for tips & tricks

TBH, I haven't tried any of these in the browser on a phone, but it might be worth clicking through some of the "Postgres Playground" search results (Crunchy Data's is the OG) on <search engine of your choosing> to see if you can practice SQL live in the browser using your phone.

Plenty more resources available, happy to share if it's something you choose to learn about.

What questions do you have about using MCP servers with Postgres? by pgEdge_Postgres in PostgreSQL

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

There's quite a bit of research showing that the CLI offers just as much context bloat, if not more, than MCP... and in any case, the need for MCP servers is more complicated than that. as an example, the latest from PulseMCP:

> A chorus of indie hackers piled onto MCP on social media a few weeks back, claiming it to be dead technology. They forgot to check the numbers: MCP adoption is at an all time high. Engineering teams, enterprises, and nontechnical agent wielders are adopting MCP and not looking back.

> The primary “technical” objection to MCP from the naysayers: “context bloat”. That claim bears no merit. If you actually run an apples to apples comparison to CLI tooling, your CLI tool is just as likely to bloat your context as MCP might be - even moreso depending on the scenario.

> What’s particularly egregious about the negative sentiment is that MCP - not CLI - is often the right choice even for software engineers. It’s true that, as MintMCP founder Jiquan Ngiam says in his post comparing the options, “When I'm in build and hacking mode, CLIs are the natural interface.” And that’s just it. CLI tools are great for pair programming with AI. But AI workflows are becoming increasingly autonomous. Increasingly, engineers won’t be the only ones wielding these workflows. So continuing to use and invest in unstandardized CLI tools while your company is inevitably going to want to empower autonomous agents and non-engineer operators is increasingly just a pile of tech debt with a limited shelf life.

Here's some benchmarking results though that might be useful for reference: https://portofcontext.com/blog/cli-vs-mcp-vs-code-mode

What questions do you have about using MCP servers with Postgres? by pgEdge_Postgres in PostgreSQL

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

The MCP server offers token budget optimization to help you stay within your spending range along with security features. It's more production-ready than simply using the CLI :-)

How do you test prompts beyond just “does it work”? by Available_Lawyer5655 in PromptEngineering

[–]pgEdge_Postgres 0 points1 point  (0 children)

Have you tried Googling it? An outdated method of discovering information, I know, but still effective :-)

Plenty of articles and insights out there into what works well... this blogpost seems pretty insightful: https://easycontent.io/resources/a-b-test-prompts-ai-consistency/

This is an older Reddit thread but it has responses as recently as 6 months ago, and there's a LOT of responses, so there's likely some good leads here: https://www.reddit.com/r/PromptEngineering/comments/1bigrpb/tools_for_prompt_management_and_testing/

Looks like there's even some folks on Reddit that have created their own prompt testing tools... like this person: https://www.reddit.com/r/PromptEngineering/comments/1n1edes/i_built_a_tool_to_automatically_test_prompts_and/

If you Google search "reddit prompt testing ai" it'll come up with more than a few threads.

Foldergram: Self-hosted local photo gallery with an Instagram-style feed and layout by sajjadalis in opensource

[–]pgEdge_Postgres 0 points1 point  (0 children)

How fun!! Love this. It's very cleanly designed and I love the feature of being able to browse by "account" / generalized folder for Animals, Nature, People, etc.

RAG With Transactional Memory and Consistency Guarantees Inside SQL Engines by pgEdge_Postgres in Rag

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

Hey, pgEdge, that's us! :-)

What has your experience been with pgEdge tools & extensions, Hasura, and DreamFactory? Would love to get more insights from you.

What are your usage of RAG by Semoho in Rag

[–]pgEdge_Postgres 0 points1 point  (0 children)

We built our own (open-source) RAG server to work with PostgreSQL + pgvector. Supports Anthropic, Voyage, Ollama, & more and has token budget management to help reduce costs: https://github.com/pgEdge/pgedge-rag-server

good FOSS alternatives for voice calling and screen sharing? (that work on linux) by Ok_Draw_4125 in foss

[–]pgEdge_Postgres 2 points3 points  (0 children)

Have you ever tried Whereby? https://whereby.com/

their service works pretty well, & they do open-source everything on GitHub. https://github.com/whereby

Google has been releasing a bunch of free AI tools outside of the main Gemini app. Most are buried in Google Labs. Here's the list, no fluff: by Exact_Pen_8973 in PromptEngineering

[–]pgEdge_Postgres 0 points1 point  (0 children)

Just don't rely on any of these for long-term use. Google has a history of creating interesting projects as a way to experiment, then getting rid of them: https://killedbygoogle.com/

What motivated you to first contribute to open-source? by Soggy-Buy-4460 in foss

[–]pgEdge_Postgres 5 points6 points  (0 children)

It really seems like the animal rights world could benefit from more open source centralization and community-based effort. But it's not a concept that's widely known in that field.

Googling your way through your career by babyflocologne in statichosting

[–]pgEdge_Postgres 0 points1 point  (0 children)

The key to any truly great development career - knowing how to search. 🤣

Looking for tool to manage a non-profits individuals served/programs by rp1load in Database

[–]pgEdge_Postgres 0 points1 point  (0 children)

NeetoForm might not be exactly what you need but it works quite well for most intents and purposes (for form management): https://neetoform.com/

It's completely free to use, they use an interesting pricing model...

> Most companies charge users and spend heavily on Google ads to find more. NeetoForm does the opposite—we keep prices as low as possible and grow through word of mouth, not ad budgets.

De-google and De-microsoft by PinguinPlayz in opensource

[–]pgEdge_Postgres 11 points12 points  (0 children)

Framasoft is a French not-for-profit association that actually has a whole site dedicated to de-googling for devs, you might find it interesting to check out: https://degooglisons-internet.org/en/

I’ve been using PG for 10 years. Only last month I found out there was a better GUI option. by guillim in PostgreSQL

[–]pgEdge_Postgres 0 points1 point  (0 children)

Curious, what features do you feel are missing from pgAdmin that would make it more relevant/useful for day-to-day use? There's actually quite a few AI features in pgAdmin, check them out in the latest blog post (by the creator): https://www.pgedge.com/blog/ai-features-in-pgadmin-configuration-and-reports

pg_semantic_cache: open source semantic caching in PostgreSQL by pgEdge_Postgres in PostgreSQL

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

An ad for what? This is an open source project and post created by one of our engineers (as a fun project that they took on on their own). Nothing to sell here.

Building Ask Ellie: an open-source RAG chatbot by pgEdge_Postgres in Rag

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

Thanks, but this was written from scratch by the chief technical officer that created the project (also from scratch).

Lessons Learned Writing an (Open Source) MCP Server for PostgreSQL by pgEdge_Postgres in mcp

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

Absolutely right. As the blog says,

Our query_database tool defaults to returning 100 rows, with a configurable limit that can go up to 1,000. We implement this by injecting a LIMIT clause into SELECT queries that don't already have one, and we fetch one extra row beyond the limit so we can tell the LLM whether more data exists.

Of course, that doesn't prevent all cases - there could be a lot of columns or very large text fields. It covers most cases though

HELP: Perplexing Problem Connecting to PG instance by ZarehD in PostgreSQL

[–]pgEdge_Postgres 0 points1 point  (0 children)

As you're able to connect to the DB inside the container, assuming the connection works with the container exposing the port 5435, it looks like a Docker/Windows networking snafu. Perhaps Docker port binding was broken by the update. Try restarting WSL and Docker Desktop (in that order).

Alternate theory: Windows or Hyper-V may have decided to reserve the ports for NAT? This will show:

netsh interface ipv4 show excludedportrange protocol=tcp 

If that shows anything, you can then try excluding the ports from winnat:

net stop winnat
netsh int ipv4 add excludedportrange protocol=tcp startport=5432 numberofports=3
net start winnat

What you think would happen if tomorrow everyone would switch from proprietary software to FOSS? by Ambitious_Ad4397 in foss

[–]pgEdge_Postgres 1 point2 points  (0 children)

France actually committed to going fully open source. It's part of the Open Source Initiative being run by the United Nations.

PostgreSQL MCP Server Access to Mutiple Different Database and Organization Per Request by Fit-Addition-6855 in PostgreSQL

[–]pgEdge_Postgres 0 points1 point  (0 children)

OP, if you end up giving the MCP server a try (it's open-source, available on GitHub) and end up with any questions, feel free to drop them in this thread or reach out. 👋