steve-chavez/socnet
View on GitHub ↗ ★ 61 PLpgSQL
A social network schema with row-level security
5 mentions on Hacker News by 2 people: 0 stories, 5 comments · first 2019-10-27 · latest 2021-04-24
20082026
-
…a great example repo to demonstrate an "advanced" scenario of building a social network with RLS: https://github.com/steve-chavez/socnet/ With Postgres you can elevate privileges to bypass RLS (which you may want to do in your middleware),…
comment by kiwicopple · 2021-04-24 · in Ask HN: Example of row-level security in open source project? -
…a sample project[2] that has some tests using it. [1]: https://github.com/okbob/plpgsql_check [2]: https://github.com/steve-chavez/socnet/blob/master/tests/ano...
comment by steve-chavez · 2020-11-21 · in PostgREST: REST API for any Postgres database -
…do some very advanced rules. For example, one of our team built a social network with PG and RLS: https://github.com/steve-chavez/socnet/blob/f1abaadaaedb7c8e... RLS is flexible enough to cover multi-tenant scenarios, though it's up to you…
comment by kiwicopple · 2020-10-21 · in Ask HN: The state of Firebase alternatives in 2020? -
…[4] Policies: https://www.postgresql.org/docs/current/sql-createpolicy.htm... [5] Social network: https://github.com/steve-chavez/socnet/blob/f1abaadaaedb7c8e... [6] GoTrue: https://github.com/netlify/gotrue
comment by kiwicopple · 2020-08-06 · in Auth is now available in Supabase (YC S20) -
…pgTAP could simplify your API tests. Here are some examples of how testing with pgTAP looks like: https://github.com/steve-chavez/socnet/blob/master/tests/fri... (Loading schema/fixtures can be done with a `\i file.sql`) [1]:…
comment by steve-chavez · 2019-10-27 · in PostgreSQL example of self-contained stored procedures