pREST
postgrest
Our great sponsors
pREST | postgrest | |
---|---|---|
15 | 98 | |
4,064 | 21,971 | |
0.9% | 1.3% | |
8.0 | 9.7 | |
17 days ago | 8 days ago | |
Go | Haskell | |
MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pREST
- Need help connecting VueJS 3 UI to a database
- Postgres as Rest
-
pREST on YugabyteDB
In a previous post, I published an example with PostgREST on YugabyteDB. Here is another one: pREST opens a REST API to PostgreSQL. YugabyteDB is a PostgreSQL-compatible Open-Source Distributed SQL database. It adds horizontal scalability to applications built for PostgreSQL. Let's see how it integrates with pREST.
-
PostgREST – Serve a RESTful API from Any Postgres Database
Pretty sure I started with this: https://github.com/prest/prest/blob/main/cmd/root.go
And from there you can execute your own command and add handlers or other things as you wish.
-
Accessing Postgres via REST using pRest
With pRest, it is possible to create a RESTFul API to access the contents of a Postgres database in a fast and straightforward way. The project, written in Go, can be found on its official website and Github.
-
Admin panel for Go back end?
So this is something I've been pondering about for a while and I think I've settled to using Directus: https://directus.io/ as my db admin and dbmate for migrations. Alternatively you could use react admin: https://marmelab.com/react-admin/ . The only problem with the latter is that it requires you to build your rest endpoint for CRUD but you can use postgrest: https://postgrest.org/en/stable/ (or it's go alternative prest: https://prestd.com/) for that.
-
Full Text Search in PostgreSQL
prest / prest
There is PostgREST written in Haskell, but keeping Haskell software in production is not an easy job. With this need pREST was born. Read more.
This feature was implemented in version 1.0.5 as a search filter and works like this:
postgrest
- Soul: A SQLite REST and Realtime Server
-
Build a simple project management app with Neon, PostgREST, and DigitalOcean
wget 'https://github.com/PostgREST/postgrest/releases/download/v11.2.0/postgrest-v11.2.0-linux-static-x64.tar.xz'
-
Oink: An API for PHP in a single file
You don't need this PHP snippet:
To get the same functionality without the extra step, simply use PostgREST [1]
- Ask HN: Popular open source tool originally written in Haskell?
-
Use PostgREST and HTMX to Build RESTful APIs from PostgreSQL Databases
PostgREST is a standalone web server that turns your PostgreSQL database into a RESTful API using the database's structural constraints and permissions to define the API's endpoints and operations. In this tutorial, you will create a simple note-taking app by leveraging PostgREST to construct a RESTful API for the app and using htmx to deliver HTML content.
-
We built our customer data warehouse all on Postgres
You might find some info in the docs of PostgREST [1] or in the previous discussions on HN about it [2].
For the versioning, I just have a git repo where I keep every role, schema, table, view, function, trigger, etc. definitions. Every time I change something in the database I first change it in the git repo too to have an history.
-
Pandoc
Don't know if you would call this a "program" but PostgREST is written is Haskell too.
-
2024 Web Development Wish List
Despite what most people think, postgREST is incredibly powerful. I know, I am a sponsor. I specifically am trying to get nested mutation built-in. Currently, queries are probably more powerful than Hasura or Prisma, but most people don't know this.
-
DB2Rest VS postgrest - a user suggested alternative
2 projects | 8 Jan 2024
Others https://github.com/Azure/data-api-builder https://github.com/directus/directus https://github.com/dreamfactorysoftware/dreamfactory https://github.com/prest/prest
-
PostgREST: Providing HTML Content Using Htmx
[2]: Also part of the PostgREST team and major contributor https://github.com/PostgREST/postgrest/graphs/contributors
What are some alternatives?
Hasura - Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
supabase - The open source Firebase alternative.
postgres-websockets - PostgreSQL + Websockets
Appwrite - Build like a team of hundreds_
gotrue - An SWT based API for managing users and issuing SWT tokens.
TimescaleDB - An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
supabase-graphql-example - A HackerNews-like clone built with Supabase and pg_graphql
appsmith - Platform to build admin panels, internal tools, and dashboards. Integrates with 25+ databases and any API.
simpleconfig
json - Haskell JSON library
swagger2 - Swagger 2.0 data model.
pg-transact - Another postgresql-simple transaction monad