[B! fdw] dai_yamashitaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

dai_yamashita id:dai_yamashita

fdwã«é–¢ã™ã‚‹dai_yamashitaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (16)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

FDWã§PostgreSQLã‹ã‚‰MySQLã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’æ“ä½œã™ã‚‹ - Qiita
ã‚„ã‚ŠãŸã„ã“ã¨ RaspberryPiä¸Šã®MySQLã®ãƒ‡ãƒ¼ã‚¿ã‚’ã€VirtualBoxä¸Šã®PostgreSQLã‹ã‚‰æ“ä½œã—ãŸã„ã€‚ ã©ã†ã‚„ã‚‰FDWã¨ã„ã†æ©Ÿèƒ½ã‚’ä½¿ã†äº‹ã§å®Ÿç¾ã§ãã‚‹æ¨¡æ§˜ã€‚ ç’°å¢ƒ macOS High Sierra 10.13.1 Ubuntu17.04(Virtual Box) PostgreSQL9.6 Raspberry Pi Zero W MySQL14.14 ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ç’°å¢ƒ iot_dbãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€‚sht31ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã§ã™ã€‚ FDWã¨ã¯ Foreign Data Wrapperã®ç•¥ã€‚ ãƒãƒ¼ã‚«ãƒ«PostgreSQLã‹ã‚‰ä»–ã®ãƒªãƒ¢ãƒ¼ãƒˆPostgreSQLã‚’æ“ä½œã™ã‚‹äº‹ãŒã§ãã‚‹æ©Ÿèƒ½ã§ã™ã€‚ ä»Šå›žã®ã‚ˆã†ã«PostgreSQLã‹ã‚‰MySQLã‚’æŽ¥ç¶šã™ã‚‹æ™‚ã¯æ¨™æº–æ©Ÿèƒ½ã§ã¯ã§ãã¾ã›ã‚“ã®ã§ã€ mysql_fdw ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ FDWã‚’ä½¿ã†ã¾ã§ã®æ‰‹é † PostgreSQL: m
dai_yamashita 2017/11/11
postgresql

fdw

mysql
ãƒªãƒ³ã‚¯
Page not found
dai_yamashita 2017/08/23
hadoop

postgresql

fdw
ãƒªãƒ³ã‚¯
Foreign Data Wrapperï¼ˆFDWï¼‰ã®æ©Ÿèƒ½å¼·åŒ–
ã„ã‚ˆã„ã‚ˆæœ¬é€£è¼‰ã‚‚æœ€çµ‚å›žã¨ãªã‚Šã¾ã™ã€‚ä»Šå›žã¯ã€PostgreSQL 9.5ï¼ˆä»¥ä¸‹ã€9.5ï¼‰ã§æ©Ÿèƒ½å¼·åŒ–ã•ã‚ŒãŸForeign Data Wrapperï¼ˆFDWï¼‰ã«ã¤ã„ã¦ã€å®Ÿéš›ã«å‹•ã‹ã—ãªãŒã‚‰ç´¹ä»‹ã—ã¾ã™ã€‚ PostgreSQLã«ã¯æ¨™æº–SQLã§å®šç¾©ã•ã‚Œã¦ã„ã‚‹SQL/MEDã®å®Ÿè£…ç³»ã¨ã—ã¦ã€Foreign Data Wrapperï¼ˆFDWï¼‰ã¨ã„ã†å¤–éƒ¨ãƒ‡ãƒ¼ã‚¿ã¸ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ãŸã‚ã®ä»•çµ„ã¿ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ã“ã®ä»•çµ„ã¿ã«ã‚ˆã‚Šã€PostgreSQLã‹ã‚‰SQLã§ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã“ã¨ãŒå¯èƒ½ã«ãªã‚Šã¾ã™ã€‚ 9.5ã«ã¯OSä¸Šã®ãƒ•ã‚¡ã‚¤ãƒ«ã«ç›´æŽ¥ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã€Œfile_fdwã€ã¨ã€å¤–éƒ¨ã®PostgreSQLã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã€Œpostgresql_fdwã€ã®2ã¤ã®FDWãŒæ¨™æº–ã®contribãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¨ã—ã¦æä¾›ã•ã‚Œã¦ã„ã¾ã™ã€‚ã“ã®ä»–ã«ã‚‚ã€éžå…¬å¼ã§ã™ãŒOracleã‚„MySQLã€Mongo DBã€Twitterãªã©ã•ã¾ã–
dai_yamashita 2017/08/14
postgresql

fdw
ãƒªãƒ³ã‚¯
Postgre sqlã‹ã‚‰è¦‹ã‚‹nosql
MyNAãƒ»JPUGåˆåŒDBå‹‰å¼·ä¼š in æ±äº¬ã®ç™»å£‡è³‡æ–™ã§ã™ã€‚ https://dbstudychugoku.github.io/events/tokyo-001.htmlRead less
dai_yamashita 2015/06/26
postgresql

slide

fdw
ãƒªãƒ³ã‚¯
Compiling write-able mongo_fdw extension on binary format of PostgreSQL installation.
Compiling write-able mongo_fdw extension on binary format of PostgreSQL installation. A short blog to enable write-able mongo_fdw extension in PostgreSQL 9.4. PostgreSQL provides a powerful feature called Foreign Data Wrappers (FDW), which allows DBAs to connect to other data sources from within PostgreSQL. Foreign Data Wrapper implementation is based on SQL/MED, that's supported from PostgreSQL 9
dai_yamashita 2015/06/26
Compiling write-able mongo_fdw extension on binary format of PostgreSQL installation.

postgresql

fdw

mongodb
ãƒªãƒ³ã‚¯
SIOS "OSSã‚ˆã‚ãš" ãƒ–ãƒã‚°å‡ºå¼µæ‰€: PostgreSQLã®ä»–ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ä»•çµ„ã¿ï¼ˆFDW(Foreign Data Wrapper)ç·¨ï¼‰
SIOS "OSSã‚ˆã‚ãš"ãƒ–ãƒã‚°å‡ºå¼µæ‰€ã¯ã‚µã‚¤ã‚ªã‚¹ãŒæ–°ãŸã«ã‚ªãƒ¼ãƒ—ãƒ³ã—ã¾ã—ãŸã€ŒSIOS Tech.Labã€ãƒ–ãƒã‚°ã«ç§»è¨ã—ã¾ã™ã€‚ æ–°ã‚µã‚¤ãƒˆã®URLã¯ä¸‹è¨˜ã¨ãªã‚Šã¾ã™ã€‚å¼•ãç¶šãã®ã”æ„›èªã‚’ã‚ˆã‚ã—ããŠé¡˜ã„ã—ã¾ã™ã€‚ https://tech-lab.sios.jp/ ã“ã‚“ã«ã¡ã¯ã€ç¨²åž£ã§ã™ã€‚ å‰å›žã¯ PostgreSQLã«ã¯ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ä»•çµ„ã¿ã¨ã—ã¦ dblink ã‚’ã”æ¡ˆå†…ã—ã¾ã—ãŸã€‚ ä»Šå›žã¯ FDW(Foreign Data Wrapper) ã«ã¤ã„ã¦ã”æ¡ˆå†…ã—ã¾ã™ã€‚ å‰å›žã® dblink ã®è¨˜äº‹ã¯ã“ã¡ã‚‰ã‹ã‚‰ã”ç¢ºèªãã ã•ã„ã€‚ â– FDWã¨ã¯ï¼Ÿ FDWã¯PostgreSQL 9.1ã‹ã‚‰å°Žå…¥ã•ã‚Œã€9.2ã‹ã‚‰postgres_fdwãŒåˆ©ç”¨ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ç¾åœ¨ã‚‚æ§˜ã€…ãªæ‹¡å¼µãŒè¡Œã‚ã‚Œã¦ã„ã¾ã™ã€‚ FDWã¯ã‚ˆã‚Šæ±Žç”¨çš„ãªå¤–éƒ¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹æ‰‹æ®µã‚’æä¾›ã—ã¾ã™ã€‚PostgreSQL Wikiã«ã‚ˆã‚‹ã¨
dai_yamashita 2014/05/28
PostgreSQL

fdw

postgresql
ãƒªãƒ³ã‚¯
json_fdw: Foreign Data Wrapper for JSON files / PostgreSQL Extension Network
dai_yamashita 2013/11/19
postgresql

fdw
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
dai_yamashita 2013/09/18
fdw

postgresql
ãƒªãƒ³ã‚¯
PostgreSQL 9.3ãƒªãƒªãƒ¼ã‚¹è¨˜å¿µã€€ FDWã§æœ¬å½“ã®ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã«ã¯ã¾ã£ã¦ã¿ã‚ˆã† - interdbâ€™s blog
2013å¹´9æœˆ9æ—¥ã€ã„ããªã‚ŠPostgreSQL9.3ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã€‚ ãã‚Œã‚’è¨˜å¿µã—ã¦FDWã‚’ä½¿ã£ã¦æœ¬å½“ã®ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯çŠ¶æ…‹ã‚’ã¤ãã£ã¦éŠã‚“ã§ã¿ã‚ˆã†ã¨æ€ã†ã€‚ æº–å‚™ ã‚µãƒ¼ãƒã‚’ï¼’å°æº–å‚™ã™ã‚‹ã€‚ã‚µãƒ¼ãƒã¯test1ã¨test2ã¨ã™ã‚‹ã€‚ test1 PostgreSQLã¨postgres_fdwã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹testdbã‚’ä½œã‚‹ã€‚ $ cd contrib/postgres_fdw $ make && make install $ cd /usr/local/pgsql $ ./bin/createdb testdb æ¬¡ã«ã€CREATE EXTENSIONã§postgres_fdwã‚’å‘¼ã³è¾¼ã¿ã€ãƒ†ã‚¹ãƒˆç”¨ã®ãƒ†ãƒ¼ãƒ–ãƒ«aã¨bã‚’ä½œã‚‹ã€‚ testdb=# CREATE EXTENSION postgres_fdw; CREATE EXTENSION testdb=# CREATE TABLE a (i
dai_yamashita 2013/09/11
postgresql

fdw
ãƒªãƒ³ã‚¯
pgsql_fdw
åå‰ pgsql_fdw -- å¤–éƒ¨ã®PostgreSQLã‚µãƒ¼ãƒã«å¯¾ã—ã¦æ¤œç´¢ã‚’å®Ÿè¡Œã™ã‚‹ãŸã‚ã®å¤–éƒ¨ãƒ‡ãƒ¼ã‚¿ãƒ©ãƒƒãƒ‘ã§ã™ã€‚ æ¦‚è¦ pgsql_fdwã‚’ç”¨ã„ã‚‹ã¨ã€å¤–éƒ¨ã®PostgreSQLã‚µãƒ¼ãƒã«ã‚ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾å¿œã™ã‚‹å¤–éƒ¨ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã§ãã¾ã™ã€‚ã¾ãŸã€ã€ãã®å¤–éƒ¨ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ç”¨ã„ãŸé€šå¸¸ã®SELECTæ–‡ã‚’å®Ÿè¡Œã™ã‚‹ã“ã¨ã§ã€é€šå¸¸ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¨åŒæ§˜ã«å¤–éƒ¨ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ã“ã¨ãŒã§ãã¾ã™ã€‚ pgsql_fdwã¯ã€ã‚µãƒ¼ãƒé–“ã§ã®ãƒ‡ãƒ¼ã‚¿è»¢é€é‡ã‚’å‰Šæ¸›ã™ã‚‹ãŸã‚ã«ã€å¤–éƒ¨ã®PostgreSQLã«ç™ºè¡Œã™ã‚‹ã‚¯ã‚¨ãƒªã‚’æœ€é©åŒ–ã—ã¾ã™ã€‚ ã‚¯ã‚¨ãƒªã«å¿…è¦ã®ãªã„åˆ—ã‚’SELECTå¥ã‹ã‚‰çœç•¥ã—ã¾ã™ã€‚ ä¸€éƒ¨ã®WHEREå¥æ¡ä»¶ã‚’å¤–éƒ¨ã‚µãƒ¼ãƒå´ã§ã‚‚è©•ä¾¡ã—ã¾ã™ã€‚ PostgreSQL 9.1ã§ã¯å¤–éƒ¨ãƒ†ãƒ¼ãƒ–ãƒ«ã¯èªã¿å–ã‚Šå°‚ç”¨ã®ãŸã‚ã€pgsql_fdwã§å®šç¾©ã—ãŸå¤–éƒ¨ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã™ã‚‹æ›´æ–°(INSERT/UPDATE/DELETE)ã¯ã‚¨ãƒ©ãƒ¼ã¨ãªã‚Šå®Ÿè¡Œã§ãã¾ã›ã‚“ã€‚ å°Žå…¥æ–¹æ³• p
dai_yamashita 2013/08/24
postgresql

fdw
ãƒªãƒ³ã‚¯
monetdb_fdw: PostgreSQL meets column store. Finally.
dai_yamashita 2013/07/20
postgresql

fdw

monetdb
ãƒªãƒ³ã‚¯
redis_fdwã‚’ä½¿ã£ã¦ã¿ãŸ - æ—¥ã€…ã®è¨˜éŒ² åˆ¥é¤¨
Redisã‚’å…¥ã‚Œã¦ã¿ãŸ å…ˆæ—¥ã€ã¡ã‚‡ã£ã¨Radisã«ã¤ã„ã¦èª¿ã¹ã‚‹æ©Ÿä¼šãŒã‚ã£ãŸã®ã§ã€æ‰‹å…ƒã®ç’°å¢ƒã«Redis 2.6.14ã‚’å…¥ã‚Œã¦ã¿ãŸã€‚ ã§ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆAPIã¨ã—ã¦Cè¨€èªžç”¨ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒª(hiredis)ã‚‚å…¥ã‚Œã¦ã€Cè¨€èªžã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ç°¡å˜ãªæ€§èƒ½æ¤œè¨¼ã‚’ã‚„ã£ã¦ãŸã€‚ radis_fdwã‚‚ä½¿ã£ã¦ã¿ãŸ ã§ã€PostgreSQLã®FDWã®ã¨ã—ã¦ã€ä»¥å‰ã‹ã‚‰Redisç”¨ã®FDW(redis_fdw: Redis FDW for PostgreSQL 9.1+ / PostgreSQL Extension Network)ã¨ã„ã†ã®ãŒã‚ã‚‹ã®ã¯çŸ¥ã£ã¦ã„ãŸãŒã€ä»Šã¾ã§Redisã‚’ä½¿ã†ã“ã¨ã‚‚ãªã‹ã£ãŸã®ã§å…¨ç„¶ä½¿ã£ã¦ã„ãªã‹ã£ãŸã€‚ ã›ã£ã‹ãã®æ©Ÿä¼šãªã®ã§ä½¿ã£ã¦è¦‹ã‚‹ã“ã¨ã«ã™ã‚‹ã€‚ å¹¸ã„ã€ä¾å˜ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¯æ—¢ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ¸ˆã¿ã®hiredisã ã‘ã ã£ãŸã®ã§ã€ã•ã£ã•ã¨redis_fdwã‚’ãƒ“ãƒ«ãƒ‰ã—ã¦ã¿ã‚‹ãƒ»ãƒ»ãƒ» ãƒ“ãƒ«ãƒ‰ æœ€åˆã¯9.3-be
dai_yamashita 2013/07/02
postgresql

fdw

redis
ãƒªãƒ³ã‚¯
mysql ã‚ˆã‚Š psql ã®è£œå®ŒãŒå¥½ããªã®ã§ MySQL ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ PostgreSQL ã‹ã‚‰æ“ä½œã—ã¦ã¿ãŸã‚ˆ - é›‘æ–‡ç™ºæ•£(2013-01-27)
â–¼ [PostgreSQL][MySQL] mysql ã‚ˆã‚Š psql ã®è£œå®ŒãŒå¥½ããªã®ã§ MySQL ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ PostgreSQL ã‹ã‚‰æ“ä½œã—ã¦ã¿ãŸã‚ˆ ã“ã®ã¨ã“ã‚ MySQL ã® CUI ã§ã‚ã‚‹ã¨ã“ã‚ã® mysql ã‚³ãƒžãƒ³ãƒ‰ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ã‚“ã ã‘ã©ã€ãƒ†ãƒ¼ãƒ–ãƒ«åãªã©ã®è£œå®Œæ©Ÿèƒ½ãŒ PostgreSQL ã® psql ã‚³ãƒžãƒ³ãƒ‰ã¨é•ã£ã¦ã„ã¦ã‚¦ãƒ‹ãƒ£ã‚¦ãƒ‹ãƒ£ã—ãŸæ°—æŒã¡ã«ãªã£ã¦ã„ã‚‹ã€‚ ã ã£ãŸã‚‰ psql ã‚³ãƒžãƒ³ãƒ‰ã§ MySQL ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’æ“ä½œã§ããŸã‚‰ã„ã„ã‚“ã˜ã‚ƒãï¼Ÿã¨æ€ã£ã¦ã€mysql_fdw ã‚’è©¦ã—ã¦ã¿ãŸã€‚ æœ€è¿‘ã® PostgreSQL ã«ã¯ Foreign Data Wrapperï¼ˆFDW : å¤–éƒ¨ãƒ‡ãƒ¼ã‚¿ãƒ©ãƒƒãƒ‘ï¼‰ã¨ã„ã†æ©Ÿèƒ½ãŒã‚ã£ã¦ã€PostgreSQL ã®å¤–éƒ¨ã«å˜åœ¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’å¼•ã£å¼µã£ã¦ããŸã‚Šã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ã€‚ mysql_fdw ã¨ã„ã†ã®ã¯ã€ã“ã® FDW ã‚’ä½¿ã£ã¦ã€ŒPos
dai_yamashita 2013/01/27
mysql

postgresql

fdw
ãƒªãƒ³ã‚¯
Redis in my Postgres - CRAIG KERSTIENS
Yesterday there was a post which hit Hacker News that talked about using SQL to access Mongo. While this is powerful I think much of the true value was entirely missed within the post. SQL is an expressive language, though people are often okay with accessing Mongo data through its own ORM. The real value is that you could actually query the data from within Postgres then join across your data sto
dai_yamashita 2012/12/30
redis

fdw

postgresql
ãƒªãƒ³ã‚¯
PostgreSQLæ‹¡å¼µredis_fdwã®ä½¿ã„æ–¹
redis_fdwã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã¿ã¾ã—ãŸã€‚ PGXNã§redis_fdwã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ ä½¿ã„æ–¹ã‚’èª¿ã¹ã¦ã¿ã¾ã™ã€‚ ãªãŠã€å¯¾è±¡ã¯Arch Linuxã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸPostgreSQL 9.1.3ã§ã™ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ç›´å¾Œã®æ³¨æ„ç‚¹ redis_fdwã¯ã€create extensionã‚³ãƒžãƒ³ãƒ‰ã§æœ‰åŠ¹ã«ã™ã‚‹ã®ã§ã™ãŒã€ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ç›´å¾Œã ã¨ã€ã“ã‚“ãªã‚¨ãƒ©ãƒ¼ã«ãªã‚Šã¾ã™ã€‚ # create extension redis_fdw; ERROR: could not load library "/usr/lib/postgresql/redis_fdw.so": libhiredis.so.0.10: cannot open shared object file: No such file or directory èª¿ã¹ã¦ã¿ã‚‹ã¨ã€ã©ã†ã‚„ã‚‰redis_fdwãŒä¾å˜ã—ã¦ã„ã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€hiredisã®
dai_yamashita 2012/12/30
redis

postgresql

fdw
ãƒªãƒ³ã‚¯
PGXNã§redis_fdwã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹
dai_yamashita 2012/12/05
postgresql

redis

fdw

pgxn
ãƒªãƒ³ã‚¯
1