PostgreSQLがあれば十分
PostgreSQL Is Enough (gist.github.com)
要約
この記事「PostgreSQLがあれば十分」は、PostgreSQLがこれまで専門的なデータベースやツールに任されてきた多くの機能を処理できると主張しています。バックグラウンドジョブ、メッセージキュー、GIS、監査ログ、アクセス制御、検索、時系列データ、カラム指向データ、NoSQL、グラフデータ、外部データ、カスタム型、代替クエリ言語、HTTP、API、イベント、レプリケーション、キャッシング、単体テスト、HTML/アプリケーション、グラフィックス、マイグレーション、パフォーマンスチューニング、スケーリング、ダッシュボード、パッケージ管理、言語サーバー、ブラウザ内/WASMアプリケーションなど、PostgreSQLエコシステム内の拡張機能、ツール、機能の包括的なリストを提示しています。著者は、PostgreSQLを「世界最高のデータベース」としての地位をさらに強化するために、不足しているツールがあればコミュニティが貢献するよう奨励しています。
全文翻訳
PostgreSQL is Enough
Copy link Copy Markdown
Author
Copy link Copy Markdown
Copy link Copy Markdown
@cpursley - no product is needed, just the right features:
- partitioning
- query parallelism
- dimensional model (rather than say one-big-table)
- pre-computed aggregate tables for common queries
- appropriate hardware (sufficient memory, cpu, maybe very fast IO)
This is missing an MPP configuration (data distributed across multiple servers working together on queries), and columnar structures. But, those aren't absolutely essential.
Copy link Copy Markdown
Copy link Copy Markdown
Author
Copy link Copy Markdown
I've recently put together the Rust crate postgresql-embedded that will allow you to embed PostgreSQL into an executable for use in environments where downloading the installation may not be an option.
Copy link Copy Markdown
Copy link Copy Markdown
Copy link Copy Markdown
Copy link Copy Markdown
Copy link Copy Markdown
Copy link Copy Markdown
Not sure if it’s any good, but PostgresML claims to do RAG infra (for use with LLMs and chat bots).
Copy link Copy Markdown
Amazing list, very helpful.
Scaling section can be improved further.
Connection Pools and Load balancers: (similar to Supavisor added by you)
PgCat
PgBouncer
PgPool-II
Sharding:
Citus can be under scaling as well due to sharding capability.
I am not sure below Postgres derivatives can be part of the list as they are not open source but they are part of Postgres compatible scaling solutions.
Distributed Postgres flavors:
Yugabyte
Multi-master Postgres derivatives for scaling :
Spock
EDB Postgres-distributed
AWS PGACTIVE
Copy link Copy Markdown
I'd like to know how postgres can join to the blockchain world since this is a less discussed topic.
Copy link Copy Markdown
Copy link Copy Markdown
Copy link Copy Markdown
Edgedb should be in there somewhere.
Copy link Copy Markdown
I would love to see some self hosting best practices and gotchas!
Copy link Copy Markdown
Copy link Copy Markdown
Copy link Copy Markdown
Copy link Copy Markdown
Copy link Copy Markdown
Great repo - @cpursley !!
I’d suggest adding this 5-part blog series on advanced data science with PostgreSQL window functions:
https://data-nerd.blog/tag/window-functions/
Covers ranking, rolling stats, gaps/islands, and more—pure SQL, no external tooling. Could fit under Analytics or Advanced SQL with PostgreSQL.
Copy link Copy Markdown
Copy link Copy Markdown
Copy link Copy Markdown
I'm the author of QueenMQ, a C++ queue system backed by Postgres; we replaced Kafka with it in some of our B2B SaaS products.
Is also available as pg extension, that reproduce Kafka semantics directly from SQL. So you can use it without the server and the client, if needed.
Copy link Copy Markdown
Author
Copy link Copy Markdown
Copy link Copy Markdown
Copy link Copy Markdown