graphile-engine
pREST
Our great sponsors
graphile-engine | pREST | |
---|---|---|
6 | 15 | |
752 | 4,084 | |
0.0% | 1.0% | |
5.8 | 8.0 | |
3 days ago | 5 days ago | |
JavaScript | Go | |
- | 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.
graphile-engine
- Sketch of a Post-ORM
-
Business Logic Inside Database - How Evil Is It?
But it doesn’t have to work this way. Some modern databases support a feature called "row-level security". It allows you to define access control policies at the row level based on the current user’s attributes (id, role, group membership, etc.). As long as the application can securely pass the current user’s identity to the database, it can leave all authorization checking to the database. And since the rules are defined at the table level instead of the API level, it has a much smaller surface to protect. The "row-level security" feature is the foundation of products like PostgREST, PostGraphile, and Supabase.
- PostgREST – Serve a RESTful API from Any Postgres Database
-
You may not need an SQL query builder or ORM
I really love the way pg-sql2 is going about that.
-
Ask HN: Solo Dev Stack of 2022?
I've been enjoying developing on top of PostGraphile. https://www.graphile.org/
Good starter: https://github.com/graphile/starter
I can add a column the the db, and my frontend gets that autimagically (in dev mode, it generates a graphql schema out of the db, and from that it creates composables for my frontend wiht graphql-codegen). On the frontend I use Vue 3, the starter is build with nextjs/react.
-
Best resource to learn PL/pgSQL?
I don't much direct knowledge on the internals, but here's a snippet from the graphile-engine repo README:
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.
-
Constant work to onboarding new members into engineering team
Improve local tests execution — it is frustrating that someone wants to contribute and cannot run the local tests (we use e2e tests, making requests to prestd's own API), a way was implemented where the tests run inside docker using docker-compose;
- pREST
- GitHub - prest/prest: pREST (PostgreSQL REST), low-code, simplify and accelerate development, ⚡ instant, realtime, high-performance on any Postgres application, existing or new
-
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.
-
When is the best time to share a "new" product?
View on GitHub
- pREST (PostgreSQL REST), simplify and accelerate development, ⚡ instant, realtime, high-performance on any Postgres application, existing or new
What are some alternatives?
starter - Opinionated SaaS quick-start with pre-built user account and organization system for full-stack application development in React, Node.js, GraphQL and PostgreSQL. Powered by PostGraphile, TypeScript, Apollo Client, Graphile Worker, Graphile Migrate, GraphQL Code Generator, Ant Design and Next.js
InfluxDB - Scalable datastore for metrics, events, and real-time analytics
pgsql-http - HTTP client for PostgreSQL, retrieve a web page from inside the database.
go-cache - An in-memory key:value store/cache (similar to Memcached) library for Go, suitable for single-machine applications.
annuaire-entreprises-sirene-api
go-mysql - a powerful mysql toolset with Go
postgrest-starter-kit - Starter Kit and tooling for authoring REST API backends with PostgREST
diskv - A disk-backed key-value store.
sqlc - Generate type-safe code from SQL
pgweb - Cross-platform client for PostgreSQL databases
datasette - An open source multi-tool for exploring and publishing data
tidb - TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try AI-powered Chat2Query free at : https://tidbcloud.com/free-trial