oliverrice

10 ms·

61.
Postgres Auditing in 150 lines of SQL(supabase.com)
313 points by oliverrice 5y ago|77 comments
62.
by oliverrice 5y ago
Like Timescale (below), I'm not aware of anything in these implementations that would be incompatible with pg_graphql, but it has not been tested As long as pg_catalog schema is visible & the base postgres version is >= 13 it sh
63.
by oliverrice 5y ago
There have been a few discussions about offline-sync support for the postgREST clients but nothing concrete to announce yet On the graphql side, we'll be targeting making mutations offline capable but are still in the brainstorming pha
64.
by oliverrice 5y ago
yep!
65.
by oliverrice 5y ago
It has not been tested, but I'm not aware of any differences Timescale introduces that would be a compatibility issue.
66.
by oliverrice 5y ago
Yes, event triggers are built right into Postgres so they're supported out-of-the-box Event triggers are the mechanism pg_graphql uses to keep the GraphQL schema up-to-date with the SQL schema
67.
by oliverrice 5y ago
Currently, any datatypes that are not in the allow list https://supabase.github.io/pg_graphql/reflection/#type-conve... are cast as strings, but prioritizing a JSON conversion if one is available is a great idea t
68.
by oliverrice 5y ago
> What's the relationship between Supabase and Postgrest? Supabase uses PostgREST for its automatic/reflected REST API > Supabase is just an user. Is that correct? yep! > Does Supabase employs engineers dedicated to it?
69.
by oliverrice 5y ago
PostgREST does solves a few of the core challenges that GraphQL is intended to address like over/under-selection and resource embedding (relationships). Even so, there has still been a lot of interest in GraphQL so users can leverage t
70.
by oliverrice 5y ago
There is high level public roadmap that covers the minimum features required before we'd consider going GA here: https://supabase.github.io/pg_graphql/roadmap/ Its early days, so the conversations around aggr
71.
by oliverrice 5y ago
Very cool! I was not familiar with this project. It does takes a similar approach to query building. It is described in the README as an alpha POC
72.
by oliverrice 5y ago
Apache Age is based around the openCypher graph query language rather than GraphQL
73.
by oliverrice 5y ago
sure, if we're talking free-tier: Postgres runs in a 1 GB VM all by itself with some optimizations to get the most that limited hardware All other services are in a second 1 GB VM. You can see a list of those services here https:&#x2F
74.
by oliverrice 5y ago
We don't have an apples-to-apples comparison for similar hardware and queries at this point but here are the links to performance figures for pg_graphql and grahile. Hasura does not publish throughput number afaik pg_graphql: https:&#
75.
by oliverrice 5y ago
its very similar in goals to postgraphile as samwillis mentioned, the memory footprint is tiny, which is a big perk for supabase's platform (or if you're self hosting) but its also fully language agnostic which opens up lots of op
76.
by oliverrice 5y ago
The extension is compatible with your existing row level security policies. If you connect to the database as a role like `authenticated` then those policies will be applied. The columns and tables that are visible are also controlled by th
77.
by oliverrice 5y ago
author here! happy to answer questions
78.
by oliverrice 5y ago
> does this also work for tables where the GRANT hides certain columns from different users? Yes, it does! Any columns that are not selectable by the user's role are hidden from the JSON `response` and `old_response` keys and are no
79.
alembic –-autogenerate for SQL functions and views(github.com)
3 points by oliverrice 6y ago|0 comments
80.
by oliverrice 7y ago
If someone could send me an invite to lobste.rs so I can post there too I'd appreciate it! My email address can be found here https://github.com/olirice/nebulo/blob/ee16a6acbf91652ae84ea...
81.
by oliverrice 7y ago
Author here! Nebulo is very much a work-in-progress, but its reached proof-of-concept viability so I'd love to hear what the community thinks! At the moment, the motivation for the CLI is mostly to give quick feedback to people who wan
82.
Nebulo: Python Library and CLI for Reflecting GraphQL APIs from PostgreSQL(olirice.github.io)
8 points by oliverrice 7y ago|2 comments
83.
Show HN: Flupy – Data Pipelines in Python(github.com)
8 points by oliverrice 7y ago|1 comments