Steve Chavez

Note about quoting on curl

3

In bash a request that includes `&` must be quoted: ```bash curl "http://localhost:3000/rpc/add_them?a=1&b=2" ``` Otherwise, on `&` it'll run curl as a background process. Related to https://github.com/PostgREST/postgrest/issues/1107.

Tutorial for login with jwt/sessions

2

See if we can use the example in https://github.com/PostgREST/postgrest/pull/664

How-to for accessing sql server with FDW

1

Related to https://github.com/PostgREST/postgrest/issues/1214. Using sql server with docker and creating an FDW is actually simple to show.

Related to https://github.com/PostgREST/postgrest/issues/249, recommend to set a high enough `statement_cost_limit` to the authenticator role.

In [Block Full-Table Operations](https://postgrest.org/en/v5.0/admin.html#block-full-table-operations), related to https://github.com/PostgREST/postgrest/issues/1132.

Map `GET /resource.csv` to `GET /resource` with `Accept: text/csv`. In https://postgrest.org/en/v5.0/admin.html#alternate-url-structure.

How-to for using JWT in cookies

1

Use the snippet in https://github.com/PostgREST/postgrest/issues/773#issuecomment-275602759

Remap escape key in vi mode

2

I'm trying to remap escape to "jk" how can this be accomplished?

Previously discussed on https://github.com/PostgREST/postgrest/issues/1069, this is useful for concurrent updates and also concurrent reads. It could be done with a header: ```http Prefer: tx=commit;isolation=read-commited Prefer: tx=commit;isolation=repeatable-read Prefer: tx=commit;isolation=serializable ``` `read-commited`...

Failed resource embedding opens an empty transaction

1

```bash $ PGRST_DB_ANON_ROLE='postgrest_test_anonymous' postgrest-with-postgresql-14 postgrest-run curl 'localhost:3000/projects?select=*,wrong(*)' {"code":"PGRST200","details":null,"hint":"Verify that 'projects' and 'wrong' exist in the schema 'test' and that there is a foreign key relationship between them. If a new...