GitHub - agroal/pgagroal: High-performance connection pool for PostgreSQLYou signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
sqldefã¨pgrollを利用ã—ãŸPostgreSQLã§ã®ã‚¹ã‚ーマブルーグリーンデプãƒã‚¤ãƒ¡ãƒ³ãƒˆ
ã“ã®è¨˜äº‹ã¯ã“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ä»¥ä¸‹ã®ã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ã®11日目ã®è¨˜äº‹ã§ã™ã€‚ 3-shake Advent Calendar 2023 昨日ã¯toyb0xã«ã‚ˆã‚‹ TODOコメントをãƒã‚±ãƒƒãƒˆç®¡ç†ã™ã‚‹ãŸã‚ã®ESLint Custom Ruleã§ã—ãŸã€‚ PostgreSQL Advent Calendar 2023 昨日ã¯@ozozatyã«ã‚ˆã‚‹ PostgreSQLã®jsonbåž‹ã§JSONパスå¼(JSONPath)を使ã†ã§ã—ãŸã€‚ ã¯ã˜ã‚ã« PostgreSQLã§ã¯DDLã¯ãã®æ€§è³ªã‹ã‚‰ãƒ†ãƒ¼ãƒ–ルレベルã§ãƒãƒƒã‚¯ã‚’å–å¾—ã—ã¦ã—ã¾ã„ã¾ã™ã€‚ SREã‚„Platform Engineeringãªã©DevOpsã®ãƒ—ラクティスを実践ã™ã‚‹çµ„ç¹”ã§ã¯ãƒªãƒªãƒ¼ã‚¹ãŒå¤šããªã‚Šã€å¿…然的ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®DDL実行も多ããªã‚‹ã§ã—ょã†ã€‚ ãã®ãŸã‚ã©ã‚“ãªã«æ¥µå°ã®DDLã«ã‚ˆã‚‹ãƒãƒƒã‚¯ã‚‚ç©ã‚Œã°å¤§ããªåœæ¢æ™‚é–“ã«ãªã£ã¦ã—ã¾ã„ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®è² 利益ãŒå¢—大ã—ã¾
GitHub - GreenmaskIO/greenmask: PostgreSQL database anonymization tool
Deterministic transformers — deterministic approach to data transformation based on the hash functions. This ensures that the same input data will always produce the same output data. Almost each transformer supports either random or hash engine making it universal for any use case. Dynamic parameters — almost each transformer supports dynamic parameters, allowing to parametrize the transformer dy
PgTyped - Typesafe SQL in Typescript | PgTyped
TypesafetyPgtyped generates TS types for parameters and results of SQL queries of any complexity. Parse SQL and TS filesQueries can be written in SQL files together with useful parameter annotations. In Typescript files, queries can be defined using a sql template string literal. Prevent SQL injectionsPgTyped prevents SQL injections by separately sending queries and parameters to the DB for execut
Amazon RDS for PostgreSQL ã§ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„る外部データラッパーを使用ã™ã‚‹ - Amazon Relational Database Service
外部データラッパー (FDW) ã¯ã€å¤–部データã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚’æä¾›ã™ã‚‹ç‰¹å®šã®ã‚¿ã‚¤ãƒ—ã®æ‹¡å¼µæ©Ÿèƒ½ã§ã™ã€‚例ãˆã°ã€oracle_fdw 拡張機能を使用ã™ã‚‹ã¨ã€ RDS for PostgreSQL DB クラスター㌠Oracle データベースã¨é€£å‹•ã§ãるよã†ã«ãªã‚Šã¾ã™ã€‚別ã®ä¾‹ã§ã¯ã€PostgreSQL ãƒã‚¤ãƒ†ã‚£ãƒ–ã® postgres_fdw 拡張機能を使用ã™ã‚‹ã¨ã€RDS for PostgreSQL DB インスタンスã®å¤–部ã«ç½®ã‹ã‚ŒãŸ PostgreSQL DB インスタンスã«ä¿å˜ã•ã‚Œã¦ã„るデータã«ã‚¢ã‚¯ã‚»ã‚¹ã§ãã¾ã™ã€‚ 以下ã§ã€PostgreSQL ã§ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹ã€ã„ãã¤ã‹ã® 外部データラッパーã«ã¤ã„ã¦ã®æƒ…å ±ã‚’ç¢ºèªã§ãã¾ã™ã€‚ SQL を使用ã—㟠DB ãƒã‚°ã®ã‚¢ã‚¯ã‚»ã‚¹ã®ãŸã‚ã® log_fdw 拡張機能ã®ä½¿ç”¨ RDS for PostgreSQL DB インスタンスã¯ã€SQL インターフェイスを通
Oracleデータベースリンクを postgres_fdw ã«ç§»è¡Œã—ã¦ã¿ã‚ˆã†ï¼ã‚±ãƒ¼ã‚¹åˆ¥ã®æ¯”較もã—ã¦ã¿ãŸ | ã¬ã“ã®ãŸã®ã—ã„ã½ã™ãれ教室 | æƒ…å ±ç•‘ã§ã¤ã‹ã¾ãˆã¦
Oracleデータベースリンクを postgres_fdw ã«ç§»è¡Œã—ã¦ã¿ã‚ˆã†ï¼ã‚±ãƒ¼ã‚¹åˆ¥ã®æ¯”較もã—ã¦ã¿ãŸ Oracleデータベースリンクを使用ã—ã¦ã„ã‚‹å ´åˆã€PostgreSQL移行時ã«postgres_fdwã§å®Ÿç¾ã•ã›ã‚‹ã®ãŒæœ€é©ã§ã‚ã‚‹ã¨ã„ã†ã“ã¨ã‚’ã€ã»ã‹ã®ç§»è¡Œæ–¹æ³•ã¨ã®æ¯”較ã§è©•ä¾¡ã™ã‚‹ã€‚ ã¬ã“ã®ãŸã®ã—ã„ã½ã™ãれ教室 - 2022å¹´11月21日公開 ã¯ã˜ã‚ã« ã“ã‚“ã«ã¡ã¯ï¼NTTテクノクãƒã‚¹ã§PostgreSQLã®æŠ€è¡“支æ´ã‚’ã‚„ã£ã¦ã„ã¾ã™ã€ä¸æ‘ã§ã™ã€‚ ã„ããªã‚Šã§ã™ãŒã€çš†ã•ã‚“ã¯ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒªãƒ³ã‚¯ã€ã‚’利用ã•ã‚ŒãŸã“ã¨ã¯ã‚ã‚Šã¾ã™ã§ã—ょã†ã‹ï¼Ÿ 「データベースリンクã€ã¨ã¯ã€ãƒãƒ¼ã‚«ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã—ãªãŒã‚‰ã€å¤–部ã«ã‚る別ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸Šã®ã‚ªãƒ–ジェクト（テーブルãªã©ï¼‰ã‚‚ ãƒãƒ¼ã‚«ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸Šã«å˜åœ¨ã™ã‚‹ã‹ã®ã‚ˆã†ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã“ã¨ãŒã§ãる機能ã§ã™ã€‚ PostgreSQLã§ã¯ã„ã‚ゆる「データベースリンクã€ã®å®Ÿç¾æ‰‹æ®µãŒ
外部データã¨ã®é€£æº ～FDWã§æ§˜ã€…ãªãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã¨ã¤ãªã～｜PostgreSQLインサイド
デジタル技術ã®é€²åŒ–ã«ã‚ˆã‚Šã€ãƒ“ジãƒã‚¹ã¯å¤§ãã変ã‚ã‚Šã¤ã¤ã‚ã‚Šã¾ã™ã€‚IoTã«ã‚ˆã‚Šå–å¾—ã§ãる多種多様ãªãƒ‡ãƒ¼ã‚¿ã¨ã€æ—¢å˜ã®æ¥å‹™ãƒ‡ãƒ¼ã‚¿ã¨ã‚’組ã¿åˆã‚ã›ã¦ã€æ–°ãŸãªä¾¡å€¤ã¸ã¨ã¤ãªã’ã‚‹ãªã©ã€ã‚·ã‚¹ãƒ†ãƒ ã¯æ§˜ã€…ãªãƒ‡ãƒ¼ã‚¿ï¼ˆã‚·ã‚¹ãƒ†ãƒ ）ã¨é€£æºã§ãã‚‹ã“ã¨ãŒæ±‚ã‚られã¦ã„ã¾ã™ã€‚PostgreSQLã«ã¯ã€Foreign Data Wrapper（日本語ã§ã¯ã€Œå¤–部データラッパーã€ã¨å‘¼ã°ã‚Œã€ä»¥é™ã€ŒFDWã€ã¨ç•¥ã—ã¾ã™ï¼‰ã¨ã„ã†æ©Ÿèƒ½ãŒã‚ã‚Šã€RDBã‚„NoSQLãªã©æ§˜ã€…ãªå¤–部データã«ã‚¢ã‚¯ã‚»ã‚¹ã§ãã¾ã™ã€‚ã“ã“ã§ã¯ã€FDWã®æ¦‚è¦ã¨ä»•çµ„ã¿ã€åˆ©ç”¨æ™‚ã®ãƒã‚¤ãƒ³ãƒˆã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ãªãŠã€ã“ã®è¨˜äº‹ã¯ã€PostgreSQL 11.1ã§æ¤œè¨¼ã—ã¦ã„ã¾ã™ã€‚ 1. FDWã¨ã¯ FDWã¨ã¯ã€SELECT文やUPDATEæ–‡ãªã©ã®SQL文を使用ã—ã¦ã€å¤–部ã«ã‚るデータã«ã‚¢ã‚¯ã‚»ã‚¹ã§ãるよã†ã«ã™ã‚‹ãŸã‚ã®ã€PostgreSQLã®æ‹¡å¼µæ©Ÿèƒ½ã§ã™ã€‚ FDWã¯ã€PostgreSQLãŒå…¬é–‹ã—ã¦ã„
PostgreSQLã®ãƒˆãƒ©ãƒ–ルシュートã¨ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° | Let's POSTGRES
NTT オープンソースソフトウェアセンタ ç¬ åŽŸ è¾°ä» ã“ã®è¨˜äº‹ã¯ã€gihyo.jp & Let's Postgres 連動ä¼ç”»ã€Œä»Šã“ãï¼PostgreSQLã€ã®ç¬¬6回記事ã§ã™ã€‚第6回目ã¯ã€PostgreSQLã®ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚„å†…éƒ¨æƒ…å ±ã‚’è¦‹ã¦ã€ç™ºç”Ÿã—ã¦ã„ã‚‹å•é¡Œã®ç‰¹å®šã¨ãã®å¯¾ç–ã¨ãªã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’紹介ã—ã¾ã™ã€‚ãªãŠã€ãƒˆãƒ©ãƒ–ルã®ç™ºç”Ÿãƒ»äºˆå…†ã‚’é©åˆ‡ã«æ•æ‰ã™ã‚‹ãŸã‚ã«ã‚‚ã€ãƒã‚°ã®è¨å®šã‚„ç¨¼å‹•çµ±è¨ˆæƒ…å ±ã®ç›£è¦–ã‚’ã—ã¦ãŠãã¾ã—ょã†ã€‚ エラーメッセージã«ã¤ã„㦠トラブルã¨å¯¾ç–ã®å‰ã«ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã®ãƒ¬ãƒ™ãƒ«ã«ã¤ã„ã¦èª¬æ˜Žã—ã¦ãŠãã¾ã™ã€‚PostgreSQLã¯è¤‡æ•°ã®ã‚¨ãƒ©ãƒ¼ãƒ¬ãƒ™ãƒ«ã‚’影響範囲や深刻度ã«ã‚ˆã£ã¦ä½¿ã„分ã‘ã¦ã„ã¾ã™ã€‚エラーレベルãã‚Œãžã‚Œã®è§£é‡ˆã®ä»•æ–¹ã‚’下記ã®è¡¨ã«ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ データベース管ç†è€…ã¯ã€æ·±åˆ»ãªçŠ¶æ³ã§ã‚ã‚‹ PANIC ã¨ã€æ€§èƒ½æƒ…å ±ã‚’å«ã‚€ LOG レベルã®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã«æ³¨æ„ã—ã¾ã—ょã†ã€‚一方ã€ã‚¢ãƒ—リケーション開発者
Pgpool-IIã®æŽ¥ç¶šæ€§èƒ½ã®æ”¹å–„ | Let's POSTGRES
SRA OSS, Inc. 日本支社 石井　é”夫 ã¯ã˜ã‚㫠本記事ã¯2013å¹´ã®PostgreSQL Advent Calendar ã® 12/17 ã®è¨˜äº‹ã§ã™ã€‚pgpool-IIã«å¤šæ•°ã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆåŒæ™‚ã«æŽ¥ç¶šã™ã‚‹ã¨ã€æ¥µç«¯ã«ãƒ¬ã‚¹ãƒãƒ³ã‚¹ãŒè½ã¡ã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ã“ã“ã§ã¯ãã®åŽŸå› ã¨æ”¹å–„方法ã«ã¤ã„ã¦è€ƒãˆã¾ã™ã€‚ pgpool-IIã¯pre-forkåž‹ã®ã‚¢ãƒ¼ã‚テクãƒãƒ£ pgpool-IIã¯ã€è¤‡æ•°ã®PostgreSQLを使ã£ãŸã‚¯ãƒ©ã‚¹ã‚¿ã‚·ã‚¹ãƒ†ãƒ を構築ã§ãるミドルウェアã§ã™ã€‚pgpool-IIã§ã¯ã€num_init_childrenã¨ã„ã†ãƒ‘ラメータã®æ•°ã ã‘ã‚らã‹ã˜ã‚プãƒã‚»ã‚¹ã‚’èµ·å‹•(pre-fork)ã—ã¦ãŠãã¾ã™ã€‚クライアントã‹ã‚‰ã®æŽ¥ç¶šè¦æ±‚ãŒã‚ã‚‹ã¨ã€ãã®ãƒ—ãƒã‚»ã‚¹ã®ä¸€ã¤ãŒã‚«ãƒ¼ãƒãƒ«ã‹ã‚‰é¸æŠžã•ã‚Œã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰ã®æŽ¥ç¶šã‚’å—付ã‘ã¦ã€å‡¦ç†ã‚’開始ã—ã¾ã™ã€‚ã“ã‚Œã¯Apacheãªã©ã¨åŒã˜æ–¹å¼ã§ã€ã‚らã‹ã˜ã‚プãƒã‚»ã‚¹ã‚’フォークã—ã¦
GitHub - graphile/crystal: 🔮 Graphile's Crystal Monorepo; home to Grafast, PostGraphile, pg-introspection, pg-sql2 and much more!
At Graphile we love GraphQL so much we named ourself for our love of it! This repository houses many of the Graphile packages that relate to GraphQL (or relate to the packages that relate to GraphQL, or relate to those package...); the two headline projects are Grafast and PostGraphile but there's many other packages, a fair few of which can be used independently - see below for more details. Graf
Citus Data | Distributed Postgres. At any scale.
POSETTE: An Event for Postgres 2025 will happen virtually Jun 10-12, 2025. Call for Speakers is open! 💥
GitHub - microsoft/pg_paxos: Basic implementation of Paxos and Paxos-based table replication for a cluster of PostgreSQL nodes
This PostgreSQL extension provides a basic implementation of the Paxos algorithm in PL/pgSQL and basic table replication through Paxos. Warning: pg_paxos is in an early stage, consider it experimental. pg_paxos can be used to replicate a table across multiple PostgreSQL servers. Every INSERT/UPDATE/DELETE on a replicated table is logged through Paxos. When a query is performed on the table, pg_pax
ランã‚ング
ランã‚ング
ランã‚ング
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
Zapatos: Zero-Abstraction Postgres for TypeScript
GitHub - gajus/slonik: A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.
GitHub - PostgREST/postgrest: REST API for any Postgres database
GitHub - ossc-db/dblink_plus: Send query from PostgreSQL to other RDBMS like contrib/dblink
GitHub - porsager/postgres: Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare
GitHub - supabase/supabase: The open source Firebase alternative. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
GitHub - kanmu/dgw: dgw generates Golang struct, and simple Table/Row Data Gateway functions from PostgreSQL table metadata
GitHub - duckdb/duckdb: DuckDB is an analytical in-process SQL database management system
{{#tags}}- {{label}}
{{/tags}}