|almost 3 years ago||7 days ago|
|BSD 3-clause "New" or "Revised" 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.
We haven't tracked posts mentioning typed-admin yet.
Tracking mentions began in Dec 2020.
Five Easy to Miss PostgreSQL Query Performance Bottlenecks
4 projects | news.ycombinator.com | 18 Jan 2022
For OLAP-style use-cases, I wouldn't recommend SQLite, but rather something equally (apparently) unfashionable: stored procedures.
In both cases, the goal is to save the time spent round-tripping queries and responses to the DB. But with OLAP, you more-than-likely have a large dataset that needs its own dedicated beefy DB to process. So rather than moving the data to the code (with e.g. SQLite), move the code to the data (by moving as much of your business layer as possible into the DB. Or possibly all of it, ala https://postgrest.org/.)
Optimizing Docker image size and why it matters
11 projects | news.ycombinator.com | 6 Jan 2022
Can second Nix! With Nix we were able to reduce PostgREST image size from over 30 MB to about 4 MB.
Any general purpose visualisation "just add the data" framework
2 projects | reddit.com/r/Frontend | 3 Jan 2022
There's numerous standard backends which frontenders could use in simplistic cases to start, say https://github.com/PostgREST/postgrest or https://github.com/parse-community/parse-server
FOSS News International #5: November 29 - December 5, 2021
5 projects | reddit.com/r/fossnews | 6 Dec 2021
Release v9.0.0 · PostgREST/postgrest (github.com)
Realtime Postgres RLS Now Available on Supabase (YC S20)
4 projects | news.ycombinator.com | 1 Dec 2021
Of course this is PostgREST-specific, only when going through it you'd enforce this condition.
Lightweight Dev Solutions
1 project | reddit.com/r/softwaredevelopment | 30 Nov 2021
Postgrest (a front-end to postgresql) can automatically turn your database into an api you can call. So you will need to write sql, and a front-end but hopefully nothing else.
User Authentication in Next.js with Supabase
7 projects | dev.to | 23 Nov 2021
@supabase/postgrest-js for PostgREST (REST API for PostgreSQL)
Please I need ASAP help on connecting a flutter web app to a python-run PostgreSQL database
2 projects | reddit.com/r/PostgreSQL | 29 Oct 2021
I've been able to use postgrest to provide an API for a flutter app. I used Keycloak for logging in and providing the json web token to the flutter app that postgrest then accepts. I think (but can't remember for sure) that it was this auth0 with flutter article I used, with small modifications to connect to Keycloak. I recall discovering a few design flaws with the approach, but I don't remember what they were. I was able to modify it to my satisfaction.
What libraries/frameworks are you using with SvelteKit to connect to the database and other stuff?
2 projects | reddit.com/r/sveltejs | 27 Oct 2021
I was gravitating towards PostgREST, which is also open source.
What backend to use for Vue?
2 projects | reddit.com/r/vuejs | 26 Oct 2021
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. Follow to stay updated about our public Beta.
TimescaleDB - An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
pg-transact - Another postgresql-simple transaction monad
swagger2 - Swagger 2.0 data model.
subzero-starter-kit - Starter Kit and tooling for authoring GraphQL/REST API backends with subZero
Grafana - The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.
postgres-websockets - PostgreSQL + Websockets
gotrue - An SWT based API for managing users and issuing SWT tokens
json - Haskell JSON library
storage-api - A S3 compatible object storage service that integrates with Postgres and Gotrue