Skip to content

Instantly share code, notes, and snippets.

@revskill10
Forked from cpursley/postgresql_is_enough.md
Created February 7, 2024 11:27
Show Gist options
  • Select an option

  • Save revskill10/71d21b8b6e0c5ba998aa31d40f9e8737 to your computer and use it in GitHub Desktop.

Select an option

Save revskill10/71d21b8b6e0c5ba998aa31d40f9e8737 to your computer and use it in GitHub Desktop.

Revisions

  1. @cpursley cpursley revised this gist Feb 7, 2024. 1 changed file with 1 addition and 0 deletions.
    1 change: 1 addition & 0 deletions postgresql_is_enough.md
    Original file line number Diff line number Diff line change
    @@ -18,6 +18,7 @@

    ## Audit Logs

    - https://github.com/arkhipov/temporal_tables
    - https://github.com/supabase/supa_audit
    - https://github.com/pgMemento/pgMemento
    - https://github.com/pgaudit/pgaudit
  2. @cpursley cpursley revised this gist Feb 7, 2024. 1 changed file with 5 additions and 0 deletions.
    5 changes: 5 additions & 0 deletions postgresql_is_enough.md
    Original file line number Diff line number Diff line change
    @@ -33,8 +33,13 @@

    ## Search

    ### Full Text

    - [Postgres Full Text Search](https://gist.github.com/cpursley/e3586382c3a42c54ca7f5fef1665be7b?permalink_comment_id=4213119#gistcomment-4213119) (bunch of helpful links)
    - https://github.com/paradedb/paradedb

    ### Vector

    - https://github.com/neondatabase/pg_embedding
    - https://github.com/pgvector/pgvector

  3. @cpursley cpursley revised this gist Feb 7, 2024. 1 changed file with 2 additions and 1 deletion.
    3 changes: 2 additions & 1 deletion postgresql_is_enough.md
    Original file line number Diff line number Diff line change
    @@ -3,7 +3,7 @@
    - [Just Use Postgres for Everything](https://www.amazingcto.com/postgres-for-everything/)
    - [Simplify: move code into database functions](https://sive.rs/pg)

    ## Background Jobs
    ## Background and Cron Jobs

    - https://github.com/citusdata/pg_cron

    @@ -18,6 +18,7 @@

    ## Audit Logs

    - https://github.com/supabase/supa_audit
    - https://github.com/pgMemento/pgMemento
    - https://github.com/pgaudit/pgaudit

  4. @cpursley cpursley revised this gist Feb 6, 2024. 1 changed file with 1 addition and 0 deletions.
    1 change: 1 addition & 0 deletions postgresql_is_enough.md
    Original file line number Diff line number Diff line change
    @@ -32,6 +32,7 @@

    ## Search

    - [Postgres Full Text Search](https://gist.github.com/cpursley/e3586382c3a42c54ca7f5fef1665be7b?permalink_comment_id=4213119#gistcomment-4213119) (bunch of helpful links)
    - https://github.com/paradedb/paradedb
    - https://github.com/neondatabase/pg_embedding
    - https://github.com/pgvector/pgvector
  5. @cpursley cpursley revised this gist Feb 6, 2024. 1 changed file with 1 addition and 6 deletions.
    7 changes: 1 addition & 6 deletions postgresql_is_enough.md
    Original file line number Diff line number Diff line change
    @@ -9,12 +9,7 @@

    ## Message Queues

    ### Reading

    - https://adriano.fyi/posts/2023-09-24-choose-postgres-queue-technology/

    ### Libraries

    - https://adriano.fyi/posts/2023-09-24-choose-postgres-queue-technology
    - https://github.com/tembo-io/pgmq

    ## GIS/Mapping
  6. @cpursley cpursley revised this gist Feb 6, 2024. 1 changed file with 4 additions and 0 deletions.
    4 changes: 4 additions & 0 deletions postgresql_is_enough.md
    Original file line number Diff line number Diff line change
    @@ -45,6 +45,10 @@

    - https://github.com/timescale/timescaledb

    ## Graph Data

    - https://age.apache.org

    ## Foreign Data

    - https://github.com/supabase/wrappers
  7. @cpursley cpursley revised this gist Feb 6, 2024. 1 changed file with 1 addition and 0 deletions.
    1 change: 1 addition & 0 deletions postgresql_is_enough.md
    Original file line number Diff line number Diff line change
    @@ -58,6 +58,7 @@

    - https://github.com/PostgREST/postgrest
    - https://github.com/hasura/graphql-engine
    - https://postgraphile.org
    - https://supabase.github.io/pg_graphql

    ## Events, Replication, CDC,
  8. @cpursley cpursley revised this gist Feb 6, 2024. 1 changed file with 1 addition and 0 deletions.
    1 change: 1 addition & 0 deletions postgresql_is_enough.md
    Original file line number Diff line number Diff line change
    @@ -64,6 +64,7 @@

    - https://www.postgresql.org/docs/current/sql-notify.html
    - https://github.com/cpursley/walex (Disclosure: I maintain this and think it's pretty awesome)
    - https://github.com/PeerDB-io/peerdb
    - https://github.com/debezium/debezium
    - https://github.com/2ndQuadrant/pglogical

  9. @cpursley cpursley revised this gist Feb 6, 2024. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion postgresql_is_enough.md
    Original file line number Diff line number Diff line change
    @@ -63,7 +63,7 @@
    ## Events, Replication, CDC,

    - https://www.postgresql.org/docs/current/sql-notify.html
    - https://github.com/cpursley/walex
    - https://github.com/cpursley/walex (Disclosure: I maintain this and think it's pretty awesome)
    - https://github.com/debezium/debezium
    - https://github.com/2ndQuadrant/pglogical

  10. @cpursley cpursley revised this gist Feb 6, 2024. 1 changed file with 3 additions and 1 deletion.
    4 changes: 3 additions & 1 deletion postgresql_is_enough.md
    Original file line number Diff line number Diff line change
    @@ -96,4 +96,6 @@

    ## Language Servers

    - https://github.com/supabase/postgres_lsp
    - https://github.com/supabase/postgres_lsp

    # What's missing? Please share in the comments.
  11. @cpursley cpursley revised this gist Feb 6, 2024. 1 changed file with 25 additions and 5 deletions.
    30 changes: 25 additions & 5 deletions postgresql_is_enough.md
    Original file line number Diff line number Diff line change
    @@ -1,8 +1,7 @@
    # PostgreSQL is Enough

    https://www.postgresql.org

    https://sive.rs/pg
    - [Just Use Postgres for Everything](https://www.amazingcto.com/postgres-for-everything/)
    - [Simplify: move code into database functions](https://sive.rs/pg)

    ## Background Jobs

    @@ -31,11 +30,21 @@ https://sive.rs/pg

    - https://github.com/arkhipov/acl

    ## Authorization

    - https://www.postgresql.org/docs/current/pgcrypto.html
    - https://github.com/michelp/pgjwt

    ## Search

    - https://github.com/paradedb/paradedb
    - https://github.com/neondatabase/pg_embedding
    - https://github.com/pgvector/pgvector

    ## Time Series

    - https://github.com/timescale/timescaledb

    ## Foreign Data

    - https://github.com/supabase/wrappers
    @@ -53,6 +62,7 @@ https://sive.rs/pg

    ## Events, Replication, CDC,

    - https://www.postgresql.org/docs/current/sql-notify.html
    - https://github.com/cpursley/walex
    - https://github.com/debezium/debezium
    - https://github.com/2ndQuadrant/pglogical
    @@ -61,6 +71,11 @@ https://sive.rs/pg

    - https://github.com/theory/pgtap

    ## Migrations

    - https://github.com/purcell/postgresql-migrations
    - https://www.bytebase.com/

    ## Dashboards / UIs

    - [Baserow](https://baserow.io)
    @@ -72,8 +87,13 @@ https://sive.rs/pg
    - [Evidence](https://evidence.dev)
    - [Metabase](https://metabase.com)

    ## HTML
    ## HTML and Applications

    - [SQLpage](https://github.com/lovasoa/SQLpage)
    - [Omnigres](https://github.com/omnigres/omnigres)
    - [pg_render](https://github.com/mkaski/pg_render)
    - [plmustache](https://github.com/PostgREST/plmustache)
    - [plmustache](https://github.com/PostgREST/plmustache)

    ## Language Servers

    - https://github.com/supabase/postgres_lsp
  12. @cpursley cpursley revised this gist Dec 18, 2023. 1 changed file with 7 additions and 1 deletion.
    8 changes: 7 additions & 1 deletion postgresql_is_enough.md
    Original file line number Diff line number Diff line change
    @@ -70,4 +70,10 @@ https://sive.rs/pg
    ## Data Visualization

    - [Evidence](https://evidence.dev)
    - [Metabase](https://metabase.com)
    - [Metabase](https://metabase.com)

    ## HTML

    - [Omnigres](https://github.com/omnigres/omnigres)
    - [pg_render](https://github.com/mkaski/pg_render)
    - [plmustache](https://github.com/PostgREST/plmustache)
  13. @cpursley cpursley revised this gist Oct 17, 2023. 1 changed file with 4 additions and 0 deletions.
    4 changes: 4 additions & 0 deletions postgresql_is_enough.md
    Original file line number Diff line number Diff line change
    @@ -27,6 +27,10 @@ https://sive.rs/pg
    - https://github.com/pgMemento/pgMemento
    - https://github.com/pgaudit/pgaudit

    ## Access Control

    - https://github.com/arkhipov/acl

    ## Search

    - https://github.com/neondatabase/pg_embedding
  14. @cpursley cpursley revised this gist Oct 2, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion postgresql_is_enough.md
    Original file line number Diff line number Diff line change
    @@ -61,7 +61,7 @@ https://sive.rs/pg

    - [Baserow](https://baserow.io)
    - [NocoDB](https://github.com/nocodb/nocodb)
    - [AppSmith][(https://appsmith.com)
    - [AppSmith](https://appsmith.com)

    ## Data Visualization

  15. @cpursley cpursley revised this gist Oct 2, 2023. 1 changed file with 12 additions and 1 deletion.
    13 changes: 12 additions & 1 deletion postgresql_is_enough.md
    Original file line number Diff line number Diff line change
    @@ -55,4 +55,15 @@ https://sive.rs/pg

    ## Unit Tests

    - https://github.com/theory/pgtap
    - https://github.com/theory/pgtap

    ## Dashboards / UIs

    - [Baserow](https://baserow.io)
    - [NocoDB](https://github.com/nocodb/nocodb)
    - [AppSmith][(https://appsmith.com)

    ## Data Visualization

    - [Evidence](https://evidence.dev)
    - [Metabase](https://metabase.com)
  16. @cpursley cpursley revised this gist Oct 2, 2023. 1 changed file with 2 additions and 0 deletions.
    2 changes: 2 additions & 0 deletions postgresql_is_enough.md
    Original file line number Diff line number Diff line change
    @@ -1,5 +1,7 @@
    # PostgreSQL is Enough

    https://www.postgresql.org

    https://sive.rs/pg

    ## Background Jobs
  17. @cpursley cpursley revised this gist Sep 25, 2023. 1 changed file with 6 additions and 0 deletions.
    6 changes: 6 additions & 0 deletions postgresql_is_enough.md
    Original file line number Diff line number Diff line change
    @@ -8,6 +8,12 @@ https://sive.rs/pg

    ## Message Queues

    ### Reading

    - https://adriano.fyi/posts/2023-09-24-choose-postgres-queue-technology/

    ### Libraries

    - https://github.com/tembo-io/pgmq

    ## GIS/Mapping
  18. @cpursley cpursley renamed this gist Aug 20, 2023. 1 changed file with 0 additions and 0 deletions.
    File renamed without changes.
  19. @cpursley cpursley revised this gist Aug 20, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion postgres.md
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,4 @@
    # Postgres is Enough
    # PostgreSQL is Enough

    https://sive.rs/pg

  20. @cpursley cpursley revised this gist Aug 20, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion postgres.md
    Original file line number Diff line number Diff line change
    @@ -17,7 +17,7 @@ https://sive.rs/pg
    ## Audit Logs

    - https://github.com/pgMemento/pgMemento
    - https://github.com/pgaudit/pgaudit/tree/master
    - https://github.com/pgaudit/pgaudit

    ## Search

  21. @cpursley cpursley revised this gist Aug 20, 2023. 1 changed file with 12 additions and 1 deletion.
    13 changes: 12 additions & 1 deletion postgres.md
    Original file line number Diff line number Diff line change
    @@ -14,6 +14,16 @@ https://sive.rs/pg

    - https://github.com/postgis/postgis

    ## Audit Logs

    - https://github.com/pgMemento/pgMemento
    - https://github.com/pgaudit/pgaudit/tree/master

    ## Search

    - https://github.com/neondatabase/pg_embedding
    - https://github.com/pgvector/pgvector

    ## Foreign Data

    - https://github.com/supabase/wrappers
    @@ -29,10 +39,11 @@ https://sive.rs/pg
    - https://github.com/hasura/graphql-engine
    - https://supabase.github.io/pg_graphql

    ## Events, CDC
    ## Events, Replication, CDC,

    - https://github.com/cpursley/walex
    - https://github.com/debezium/debezium
    - https://github.com/2ndQuadrant/pglogical

    ## Unit Tests

  22. @cpursley cpursley revised this gist Aug 20, 2023. 1 changed file with 0 additions and 4 deletions.
    4 changes: 0 additions & 4 deletions postgres.md
    Original file line number Diff line number Diff line change
    @@ -10,10 +10,6 @@ https://sive.rs/pg

    - https://github.com/tembo-io/pgmq

    ## Search

    - https://github.com/Casecommons/pg_search

    ## GIS/Mapping

    - https://github.com/postgis/postgis
  23. @cpursley cpursley revised this gist Aug 20, 2023. 1 changed file with 4 additions and 0 deletions.
    4 changes: 4 additions & 0 deletions postgres.md
    Original file line number Diff line number Diff line change
    @@ -10,6 +10,10 @@ https://sive.rs/pg

    - https://github.com/tembo-io/pgmq

    ## Search

    - https://github.com/Casecommons/pg_search

    ## GIS/Mapping

    - https://github.com/postgis/postgis
  24. @cpursley cpursley revised this gist Aug 20, 2023. 1 changed file with 5 additions and 1 deletion.
    6 changes: 5 additions & 1 deletion postgres.md
    Original file line number Diff line number Diff line change
    @@ -32,4 +32,8 @@ https://sive.rs/pg
    ## Events, CDC

    - https://github.com/cpursley/walex
    - https://github.com/debezium/debezium
    - https://github.com/debezium/debezium

    ## Unit Tests

    - https://github.com/theory/pgtap
  25. @cpursley cpursley revised this gist Aug 20, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion postgres.md
    Original file line number Diff line number Diff line change
    @@ -29,7 +29,7 @@ https://sive.rs/pg
    - https://github.com/hasura/graphql-engine
    - https://supabase.github.io/pg_graphql

    ## Events (WAL)
    ## Events, CDC

    - https://github.com/cpursley/walex
    - https://github.com/debezium/debezium
  26. @cpursley cpursley revised this gist Aug 20, 2023. 1 changed file with 6 additions and 1 deletion.
    7 changes: 6 additions & 1 deletion postgres.md
    Original file line number Diff line number Diff line change
    @@ -27,4 +27,9 @@ https://sive.rs/pg

    - https://github.com/PostgREST/postgrest
    - https://github.com/hasura/graphql-engine
    - https://supabase.github.io/pg_graphql
    - https://supabase.github.io/pg_graphql

    ## Events (WAL)

    - https://github.com/cpursley/walex
    - https://github.com/debezium/debezium
  27. @cpursley cpursley revised this gist Aug 20, 2023. 1 changed file with 6 additions and 6 deletions.
    12 changes: 6 additions & 6 deletions postgres.md
    Original file line number Diff line number Diff line change
    @@ -2,28 +2,28 @@

    https://sive.rs/pg

    # Background Jobs
    ## Background Jobs

    - https://github.com/citusdata/pg_cron

    # Message Queues
    ## Message Queues

    - https://github.com/tembo-io/pgmq

    # GIS/Mapping
    ## GIS/Mapping

    - https://github.com/postgis/postgis

    # Foreign Data
    ## Foreign Data

    - https://github.com/supabase/wrappers

    # HTTP
    ## HTTP

    - https://github.com/pramsey/pgsql-http
    - https://github.com/supabase/pg_net

    # APIs
    ## APIs

    - https://github.com/PostgREST/postgrest
    - https://github.com/hasura/graphql-engine
  28. @cpursley cpursley created this gist Aug 20, 2023.
    30 changes: 30 additions & 0 deletions postgres.md
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,30 @@
    # Postgres is Enough

    https://sive.rs/pg

    # Background Jobs

    - https://github.com/citusdata/pg_cron

    # Message Queues

    - https://github.com/tembo-io/pgmq

    # GIS/Mapping

    - https://github.com/postgis/postgis

    # Foreign Data

    - https://github.com/supabase/wrappers

    # HTTP

    - https://github.com/pramsey/pgsql-http
    - https://github.com/supabase/pg_net

    # APIs

    - https://github.com/PostgREST/postgrest
    - https://github.com/hasura/graphql-engine
    - https://supabase.github.io/pg_graphql