---
title: "Don't query your PostgreSQL db anymore, prefer PostgREST"
url: https://daily.dev/posts/don-t-query-your-postgresql-db-anymore-prefer-postgrest-ny117r5hj
source_url: https://www.avonture.be/blog/docker-postgrest/
type: article
source: "Community Picks"
published: 2024-07-07T15:27:43.875Z
updated: 2024-08-23T15:54:10.329Z
tags: ["webdev", "docker", "php", "postgresql", "rest-api"]
reading_time: 7
upvotes: 270
comments: 20
language: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Don't query your PostgreSQL db anymore, prefer PostgREST

**[Community Picks](https://daily.dev/sources/community)** · 7 min read · 270 upvotes · 20 comments

## Summary

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.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://www.avonture.be/blog/docker-postgrest/>

## Community discussion

Top comments from developers on daily.dev.

**@mykytanikitenko42** · 13 upvotes

> So, did you expose the entire database of your project to the Internet? :)

**@falze** · 7 upvotes

> It's crazy how far people would go to just avoid writing queries

**@sachinkotian** · 3 upvotes

> no

**@vikyw** · 2 upvotes

> this comes free with supabase, you got a nice GUI, CLI, restSDK, auth, and row level security

**@adarsh1806** · 2 upvotes

> I see the project has been archived

## Similar posts on daily.dev

- [Don’t just attend KubeCon \+ CloudNativeCon, Merge Forward your experience\!](https://daily.dev/posts/don-t-just-attend-kubecon-cloudnativecon-merge-forward-your-experience--l0rpp73x8) · CNCF · 0 upvotes · 0 comments
- [Announcing H2 2026 KCDs](https://daily.dev/posts/announcing-h2-2026-kcds-m96goajm1) · CNCF · 1 upvotes · 0 comments
- [Two months of Open Community Groups](https://daily.dev/posts/two-months-of-open-community-groups-asf52zhbs) · CNCF · 0 upvotes · 0 comments
- [CNCF Unveils Schedule for KubeCon \+ CloudNativeCon Europe 2026](https://daily.dev/posts/cncf-unveils-schedule-for-kubecon-cloudnativecon-europe-2026-ikhcoa5cb) · CNCF · 2 upvotes · 0 comments
- [CNCF Debuts KubeCon \+ CloudNativeCon Japan 2026 Schedule](https://daily.dev/posts/cncf-debuts-kubecon-cloudnativecon-japan-2026-schedule-xp5pyudub) · CNCF · 1 upvotes · 0 comments

---

Tags: [#webdev](https://daily.dev/tags/webdev), [#docker](https://daily.dev/tags/docker), [#php](https://daily.dev/tags/php), [#postgresql](https://daily.dev/tags/postgresql), [#rest-api](https://daily.dev/tags/rest-api)

[View this post on daily.dev](https://daily.dev/posts/don-t-query-your-postgresql-db-anymore-prefer-postgrest-ny117r5hj)