--- title: The API database architecture - Stop writing HTTP-GET... description: The API database architecture eliminates the need for writing HTTP-GET endpoints by using PostgREST as a server to connect to a PostgreSQL database. It... canonical: https://daily.dev/posts/the-api-database-architecture---stop-writing-http-get-endpoints-qcttl6bg6 twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: The API database architecture - Stop writing HTTP-GET endpoints | daily.dev og:description: The API database architecture eliminates the need for writing HTTP-GET endpoints by using PostgREST as a server to connect to a PostgreSQL database. It... og:url: https://daily.dev/posts/the-api-database-architecture---stop-writing-http-get-endpoints-qcttl6bg6 og:image: https://api.daily.dev/og/posts/QcTtL6bG6.png og:image:alt: The API database architecture - Stop writing HTTP-GET endpoints og:image:width: 1200 og:image:height: 630 og:locale: en --- [Community Picks](https://daily.dev/sources/community) [Read post](https://api.daily.dev/r/QcTtL6bG6) # [The API database architecture - Stop writing HTTP-GET endpoints](https://api.daily.dev/r/QcTtL6bG6 "Go to post") The API database architecture eliminates the need for writing HTTP-GET endpoints by using PostgREST as a server to connect to a PostgreSQL database. It supports filtering, sorting, paging, and authentication out of the box. [#postgresql](/tags/postgresql "Check all #postgresql posts")[#rest-api](/tags/rest-api "Check all #rest-api posts") May 13, 2024•8m read time•From [fabianzeindl.com](https://api.daily.dev/r/QcTtL6bG6 "fabianzeindl.com") [](https://api.daily.dev/r/QcTtL6bG6 "Go to post") Table of contents [Table of contents](https://api.daily.dev/r/QcTtL6bG6?a=table-of-contents "Table of contents")[Introduction](https://api.daily.dev/r/QcTtL6bG6?a=introduction "Introduction")[Strategies for adapting existing architectures](https://api.daily.dev/r/QcTtL6bG6?a=strategies-for-adapting-existing-architectures "Strategies for adapting existing architectures")[Benefits of the API database for the software development process](https://api.daily.dev/r/QcTtL6bG6?a=benefits-of-the-api-database-for-the-software-development-process "Benefits of the API database for the software development process") 344 Impressions32 Upvotes1 Comment Comment Bookmark Copy Share your thoughtsPost [](https://daily.dev/sources/community) [Community Picks](https://daily.dev/sources/community "https://daily.dev/sources/community") Community Picks is a section on daily.dev where our community members share the most interesting and... Read more 9.9K Followers • 336.5K Upvotes [](https://daily.dev/moedayraki) [Moe Dayraki](https://daily.dev/moedayraki) [@moedayraki](https://daily.dev/moedayraki) Joined Jan 31\. 2022 1K I create stuff for the web! 🕸🕸 blog@ https://moedayraki.github.io/blog Let's work together!💫💥 #### Would you recommend this post? Copy link WhatsApp Facebook X New Squad Copy linkShare with your friends 32 1 ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"The API database architecture - Stop writing HTTP-GET endpoints","url":"https://daily.dev/posts/the-api-database-architecture---stop-writing-http-get-endpoints-qcttl6bg6","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/the-api-database-architecture---stop-writing-http-get-endpoints-qcttl6bg6"},"datePublished":"2024-05-13T11:21:17.151Z","dateModified":"2024-05-13T11:21:16.465Z","description":"The API database architecture eliminates the need for writing HTTP-GET endpoints by using PostgREST as a server to connect to a PostgreSQL database. It...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/cc2e8736bd79601392158ecbe053eb98?_a=AQAEuiZ","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/cc2e8736bd79601392158ecbe053eb98?_a=AQAEuiZ","isAccessibleForFree":true,"articleSection":"Community Picks","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Community Picks","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1655817725/logos/community","url":"https://daily.dev/sources/community"},"commentCount":1,"discussionUrl":"https://daily.dev/posts/the-api-database-architecture---stop-writing-http-get-endpoints-qcttl6bg6","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":32},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":1}],"keywords":"postgresql,rest-api","timeRequired":"PT8M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Community Picks","item":"https://daily.dev/sources/community"},{"@type":"ListItem","position":3,"name":"The API database architecture - Stop writing HTTP-GET endpoints"}]} {"@context":"https://schema.org","@type":"WebPage","@id":"https://daily.dev/posts/the-api-database-architecture---stop-writing-http-get-endpoints-qcttl6bg6","comment":[{"@type":"Comment","text":"PostgREST is really cool, I think it’s easier to use than graphql","datePublished":"2024-05-15T02:13:16.216Z","url":"https://daily.dev/posts/QcTtL6bG6#c-f31GBg8fs","author":{"@type":"Person","name":"hantian pang","url":"https://daily.dev/hantian_pang","image":"https://avatars.githubusercontent.com/u/6350479?v=4"}}]} ```