[B! PostgreSQL] gfxã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

gfx id:gfx

PostgreSQLã«é–¢ã™ã‚‹gfxã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (14)

${{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}}

CommitFestã§ãƒ‘ãƒƒãƒã®ãƒ¬ãƒ“ãƒ¥ãƒ¼ã«å‚åŠ ã—ã¦ã¿ã‚ˆã†
æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³9.3ã®betaãŒå…ˆæ—¥ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã°ã‹ã‚Šã§ã™ãŒã€PostgreSQLã®æœ€å…ˆç«¯ã®é–‹ç™ºã¯æ¬¡ã€…æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®9.4ã«å‘ã‹ã£ã¦ãŠã‚Šã€ãã®9.4ã®é–‹ç™ºã«å‘ã‘ã¦ã®1å›žç›®ã®CommitFestãŒä»Šé€±ã‹ã‚‰å§‹ã¾ã‚Šã¾ã—ãŸã€‚ [9.4 CF 1] Commit Fest has started http://www.postgresql.org/message-id/51BE003A.2050600@agliodbs.com ä»Šå›žã¯ã€ã€ŒCommitFestã¨ã¯ä½•ã‹ã€ã¨ã„ã†è©±ã¨ã€ã€Œé–‹ç™ºãƒ—ãƒã‚»ã‚¹ã«å‚åŠ ã—ã¦ã¿ãŸã„ãªã€ã¨æ€ã£ã¦ã„ã‚‹æ–¹ã«å‘ã‘ã¦ã€ã€ŒCommitFestã§ãƒ‘ãƒƒãƒã®ãƒ¬ãƒ“ãƒ¥ãƒ¼ã«å‚åŠ ã—ã¦ã¿ã‚ˆã†ã€ã¨ã„ã†è©±ã§ã™ã€‚ â– CommitFest(CF) ã¨ã¯ PostgreSQLã¯ã”å˜ã˜ã®é€šã‚Šã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã®ã§ã€ãã®é–‹ç™ºãƒ—ãƒã‚»ã‚¹ã§ã¯ã€æ©Ÿèƒ½è¿½åŠ ã‚„æ€§èƒ½æ”¹å–„ãªã©ã®ãƒ‡ã‚£ã‚¹ã‚«ãƒƒã‚·ãƒ§ãƒ³ã¯é–‹ç™ºè€…ã®ãƒ¡ãƒ¼ãƒªãƒ³ã‚°ãƒª
gfx 2019/02/15
PostgreSQL

OSS
ãƒªãƒ³ã‚¯
ã¨ã‚ã‚‹ã‚¯ã‚¨ãƒªã‚’2ä¸‡å€é€Ÿã«ã—ãŸè©± -ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ°—æŒã¡ã«ãªã‚‹- å‰ç·¨ - dwango on GitHub
æŠ€è¡“ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³å®¤ OSSã‚°ãƒ«ãƒ¼ãƒ—ã®é«™ï¨‘ã§ã™ã€‚ å½“ã‚°ãƒ«ãƒ¼ãƒ—ã§ã¯ã€ãƒžã‚¹ãƒˆãƒ‰ãƒ³ã¨ã„ã†ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®åˆ†æ•£åž‹ãƒžã‚¤ã‚¯ãƒãƒ–ãƒã‚°ã«ã¤ã„ã¦ã€ å¼Šç¤¾ãŒé‹å–¶ã™ã‚‹ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã€Œfriends.nicoã€ã®é‹å–¶ã€ç‹¬è‡ªæ©Ÿèƒ½ã®é–‹ç™ºã€é‹ç”¨ã€ãªã‚‰ã³ã«ãã‚Œã‚‰ã§å¾—ãŸçŸ¥è¦‹ã‚’ä¸Šæµã®ãƒ—ãƒ¬ãƒ¼ãƒ³ãªãƒžã‚¹ãƒˆãƒ‰ãƒ³ã¸contributeã™ã‚‹ã¨ã„ã†æ¥å‹™ã‚’ä¸»ã«è¡Œã£ã¦ã„ã¾ã™ã€‚ æœ¬è¨˜äº‹ã§ã¯ã€tableã«é©åˆ‡ãªindexã‚’å¼µã‚‹ã“ã¨ã«ã‚ˆã£ã¦ã¨ã‚ã‚‹ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªã®é€Ÿåº¦æ”¹å–„ã‚’è¡Œã£ãŸäº‹ä¾‹ã«ã¤ã„ã¦ã€å®Ÿéš›ã«ä¸Šæµã¸è¡Œã£ãŸPullRequestã‚’ãƒ™ãƒ¼ã‚¹ã«ãŠè©±ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ å†…å®¹ã¨ã—ã¦ã¯åé¢æ•™å¸«ã¨ã™ã‚‹ã¹ãå¤±æ•—ä¾‹ã‚’ä¼´ã£ãŸã€éžå¸¸ã«åŸºç¤Žçš„ãªPostgreSQLã®å®Ÿè¡Œè¨ˆç”»ã®èªã¿æ–¹ãªã‚‰ã³ã«ã‚¯ã‚¨ãƒªã«åˆã‚ã›ãŸindexã®å¼µã‚Šæ–¹ã§ã™ã€‚ ã¾ãŸã€è¡¨é¡Œã®2ä¸‡å€é€Ÿã¨ã„ã†ã®ã¯æ”¹å–„å‰ã®æœ€æ‚ªã®å ´åˆæ¯”ã§ã‚ã‚Šå˜˜ã§ã¯ãªã„ã‚‚ã®ã®ã€é€šå¸¸å•ã„åˆã‚ã›ã•ã‚Œã‚‹ç¯„å›²ã®æ¡ä»¶ã§ã¯ã ã„ãŸã„3ã€œ30å€é€Ÿã§ã‚ã‚‹ã¨ã„ã†
gfx 2018/01/18
PostgreSQL
ãƒªãƒ³ã‚¯
Add bulk alter support for PostgreSQL by dinahshi Â· Pull Request #31331 Â· rails/rails
You 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
gfx 2017/12/11
rails

PostgreSQL
ãƒªãƒ³ã‚¯
ä»Šã™ãã”åˆ©ç”¨å¯èƒ½ â€“ Amazon Aurora with PostgreSQL Compatibility | Amazon Web Services
Amazon Web Services ãƒ–ãƒã‚° ä»Šã™ãã”åˆ©ç”¨å¯èƒ½ â€“ Amazon Aurora with PostgreSQL Compatibility æ˜¨å¹´å¾ŒåŠã€Amazon Aurora ã« PostgreSQL äº’æ›ã®ã‚¨ãƒ³ã‚¸ãƒ³ã‚’è¿½åŠ ã™ã‚‹è¨ˆç”»ã‚’ãŠè©±ã—ã¾ã—ãŸã€‚ã“ã®ã‚¢ãƒŠã‚¦ãƒ³ã‚¹ã®ã™ãå¾Œã«ã€ãƒ—ãƒ©ã‚¤ãƒ™ãƒ¼ãƒˆãƒ™ãƒ¼ã‚¿ã‚’é–‹å§‹ã—ã€ä»Šå¹´ã®å‰åŠã«ã¯ã‚ªãƒ¼ãƒ—ãƒ³ãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼ã‚’é–‹å§‹ã—ã¾ã—ãŸã€‚ã“ã®ãƒ™ãƒ¼ã‚¿ã¨ãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼ã®æœŸé–“ã€éžå¸¸ã«ç´ æ™´ã‚‰ã—ã„æ•°å¤šãã®ãƒ•ã‚£ãƒ¼ãƒ‰ãƒãƒƒã‚¯ã‚’ã„ãŸã ãã€ã“ã®ã‚µãƒ¼ãƒ“ã‚¹ãŒãŠå®¢æ§˜ã®ãƒ‹ãƒ¼ã‚ºã‚’æº€ãŸã—ã€æœŸå¾…å€¤ã‚’è¶…ãˆã‚‹ã“ã¨ãŒç¢ºã‹ãªã‚‚ã®ã«ãªã‚‹ã‚ˆã†ã«ã€ã§ãã‚‹é™ã‚Šã®ã“ã¨ã‚’ã—ã¾ã—ãŸï¼ ä¸€èˆ¬åˆ©ç”¨å¯èƒ½ã« æœ¬æ—¥ã€Amazon Aurora with PostgreSQL Compatibility ãŒä¸€èˆ¬åˆ©ç”¨å¯èƒ½ã¨ãªã‚Šã€4ã¤ã®ãƒªãƒ¼ã‚¸ãƒ§ãƒ³ã§åˆ©ç”¨ã§ãã‚‹ã‚ˆã†ã«ãªã£ãŸã“ã¨ã‚’ãŠä¼ãˆã—ã¾ã™(ãã®ä»–ã®ãƒªãƒ¼ã‚¸ãƒ§ãƒ³ã¯ä»Šå¾Œå¯¾å¿œã—ã¦ã„ãã¾ã™)ã€‚æœ¬ã‚µ
gfx 2017/10/25
aurora

postgresql
ãƒªãƒ³ã‚¯
PostgreSQLã§Hello World!! - Qiita
ã“ã‚Œã¯ã€PostgreSQL Advent Calendar 2015ã®Day2ã®è¨˜äº‹ã§ã™ã€‚ ä»Šå›žã¯ã€PostgreSQLçµŒç”±ã§ã€Hello Worldã®Cãƒ—ãƒã‚°ãƒ©ãƒ ã‚’æ›¸ã„ã¦ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã—ã¦å®Ÿè¡Œã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ PostgreSQLã®æŽ¥ç¶šãƒãƒ¼ãƒˆã ã‘é–‹ã„ã¦ã„ã‚‹ã‚ˆã†ãªã‚µãƒ¼ãƒä¸Šã§Hello Worldã—ãŸã„ã¨ãã«ä½¿ãˆã‚‹ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã§ã™ï¼ï¼ ä»¥é™ã®SQLã¯ã€ã™ã¹ã¦ã‚¹ãƒ¼ãƒ‘ãƒ¼ãƒ¦ãƒ¼ã‚¶ã§å®Ÿè¡Œã—ã¦ãã ã•ã„ã€‚ -- Hello Worldã®ã‚½ãƒ¼ã‚¹ã‚’ä¿å˜ã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã—ã¾ã™ã€‚ CREATE TABLE hello_source (line serial, code text); -- Hello Worldã®Cãƒ—ãƒã‚°ãƒ©ãƒ ã®å®Ÿè¡Œçµæžœã‚’ä¿å˜ã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã—ã¾ã™ã€‚ CREATE TABLE hello_result (output text); -- COPY FROM stdinã§ã€Hello World
gfx 2015/12/02
PROGRAM clause å¼·ã„â€¦ã€‚

PostgreSQL
ãƒªãƒ³ã‚¯
12.9.Â Preferred Index Types for Text Search
There are two kinds of indexes that can be used to speed up full text searches: GIN and GiST. Note that indexes are not mandatory for full text searching, but in cases where a column is searched on a regular basis, an index is usually desirable. To create such an index, do one of: CREATE INDEX name ON table USING GIN (column); Creates a GIN (Generalized Inverted Index)-based index. The column must
gfx 2015/11/27
PostgreSQL
ãƒªãƒ³ã‚¯
auto_explain - PostgreSQL 9.4
F.3. auto_explainauto_explainãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯ã€æ‰‹å‹•ã§EXPLAINã®å®Ÿè¡Œã‚’å¿…è¦ã¨ã›ãšã€è‡ªå‹•çš„ã«é…ã„æ–‡ã®å®Ÿè¡Œè¨ˆç”»ã‚’ãƒã‚°è¨˜éŒ²ã™ã‚‹æ‰‹æ®µã‚’æä¾›ã—ã¾ã™ã€‚ å¤§ããªã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã‘ã‚‹æœ€é©åŒ–ã•ã‚Œã¦ã„ãªã„å•ã„åˆã‚ã›ã‚’è¿½è·¡ã™ã‚‹ã®ã«ç‰¹ã«æœ‰ç”¨ã§ã™ã€‚ ã“ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯SQLã§ã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹é–¢æ•°ã‚’æä¾›ã—ã¾ã›ã‚“ã€‚ ä½¿ç”¨ã™ã‚‹ã«ã¯ã€ã‚µãƒ¼ãƒã«å˜ã«èªã¿è¾¼ã¾ã›ã¾ã™ã€‚ ã‚ã‚‹å€‹åˆ¥ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã«èªã¿è¾¼ã¾ã›ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ LOAD 'auto_explain'; ï¼ˆå®Ÿè¡Œã™ã‚‹ãŸã‚ã«ã¯ã‚¹ãƒ¼ãƒ‘ãƒ¼ãƒ¦ãƒ¼ã‚¶ã§ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ï¼‰ ã‚ˆã‚Šä¸€èˆ¬çš„ãªä½¿ç”¨æ–¹æ³•ã¯ã€postgresql.confã®session_preload_librariesã¾ãŸã¯shared_preload_librariesã«auto_explainã‚’å«ã‚ã¦ã€ç‰¹å®šã®ã¾ãŸã¯ã™ã¹ã¦ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã§äº‹å‰ã«ãƒãƒ¼ãƒ‰ã—ã¦ãŠãã“ã¨ã§ã™ã€‚ ã™ã‚‹ã¨ã€æƒ³å®šå¤–ã«ä½Žé€Ÿãªå•ã„
gfx 2015/10/22
postgresql
ãƒªãƒ³ã‚¯
ããƒ¼ã ã„ãªã‚‹ã‚‰ããŒãå¸³: 2å¤§OSSãƒ†ã‚™ãƒ¼ã‚¿ãƒ˜ã‚™ãƒ¼ã‚¹ã®MySQLã¨PostgreSQLã®é•ã„ã«ã¤ã„ã¦è©±ã—ã¦ããŸ
ç¬¬32å›ž PostgreSQL å‹‰å¼·ä¼š(2015å¹´10æœˆ10æ—¥)ã§ç™»å£‡ã—ã¦ãã¾ã—ãŸã€‚ å†…å®¹ã¯å‰ã«æ›¸ã„ãŸã‚¨ãƒ³ãƒˆãƒªãƒ¼ã® MySQLä½¿ã„ãŒçŸ¥ã‚‹ã¹ãPostgreSQLã¨ã®é•ã„ã¨å¤‰ã‚ã‚‰ãªã„ä¸€ã¤ã®ã“ã¨ MySQLä½¿ã„ã®äººãŒPostgreSQLã‚’å§‹ã‚ã‚‹ã¨ãã®ç½ ã‚’ã¾ã¨ã‚ã¦ã¿ãŸ ã‚’å…ƒã«ç™ºè¡¨ã—ã¦ãã¾ã—ãŸã€‚ ã¨è¨€ã£ã¦ã‚‚ä»Šå›žã¯å‚åŠ è€…ãŒPostgresSQLã«è©³ã—ã„å‰æã ã£ãŸã®ã§MySQLã‚’ä¸å¿ƒã«è©±ã‚’ã—ã¾ã—ãŸã€‚ å®Ÿéš›ã®è³‡æ–™ã¯ä¸‹è¨˜ã®ã¨ãŠã‚Šã§ã™ã€‚ å½“æ—¥ã¯ãƒ“ãƒ‡ã‚ªæ’®å½±ãŒã‚ã£ãŸã®ã§ãã®ã†ã¡å‹•ç”»ãŒä¸ŠãŒã‚‹ã¨æ€ã„ã¾ã™ã€‚ ç¬¬32å›ž PostgreSQL å‹‰å¼·ä¼šã¾ã¨ã‚ ~ togetter ~ æµçŸ³ã«ï¼’æ™‚é–“ã¯ç–²ã‚Œã¾ã—ãŸã€‚ å†…å®¹ã¨ã—ã¦ã¯çœ ããªã‚‰ãªã„ã‚ˆã†ã«é¢ç™½ãŠã‹ã—ãä¼ãˆã‚ˆã†ã¨æ€ã£ãŸã®ã§ã™ãŒãªã‹ãªã‹é›£ã—ã‹ã£ãŸã§ã™ã€‚ å‰åŠã¯MySQLã¨PostgreSQLã®æ–¹å‘æ€§ã®é•ã„ã‚’ãƒ¡ã‚¤ãƒ³ã«ã—ã¾ã—ãŸã€‚ å¾ŒåŠã¯MySQLã¯åƒ•ãŒå®Ÿéš›ã«ãƒãƒžã£ãŸäº‹ãªã©ã‚’ãƒ¡ã‚¤
gfx 2015/10/13
PostgreSQL
ãƒªãƒ³ã‚¯
pg_nosql_benchmark - æ—¥ã€…ã®è¨˜éŒ² åˆ¥é¤¨
æ˜¨å¹´ã€PostgreSQL 9.4-betaãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®é ƒã‹ã‚‰ã€ãªã‚“ã¨ãªãJSONBåž‹ã‚’è¿½ã£ã¦ããŸã‚ã‘ã§ã™ãŒã€æœ€è¿‘ã¯ãƒ©ã‚¤ãƒãƒ«(?)ã§ã‚ã‚‹Mongo DBã¨ã®æ¯”è¼ƒãªã‚“ã‹ã‚‚ã‚„ã£ã¦ã¾ã—ã¦ã€ä»Šæ—¥ã¯ã¡ã‚‡ã£ã¨ã—ãŸãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã§æ€§èƒ½ã‚’æ¯”è¼ƒã—ã¦ã¿ã¾ã—ãŸã‚ˆã£ã¨ã€‚ pg_nosql_benchmark ã“ã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã€æ˜¨å¹´ã«EnterpriseDBç¤¾ãŒGithubä¸Šã§å…¬é–‹ã—ãŸãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã§ã™ã€‚ GitHub - EnterpriseDB/pg_nosql_benchmark: A tool which can be used to benchmark PostgreSQL (JSONB) and Mongo DB (BSON) ã§ã€ã“ã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯çµæžœã‚’å…¬é–‹ã—ã¦ã‚‹ã‚ã‘ã§ã™ãŒã€ãƒ›ãƒ³ãƒˆã«ãã‚“ãªã«å·®ãŒã‚ã‚‹ã®ã‹ã¨ã€è‹¥å¹²ç–‘å•ã¯æŒã£ã¦ã„ãŸã‚ã‘ã§ã™ã€‚ ãªã®ã§ã€ä»¶æ•°çš„ã«ã¯å°ã‚¹ã‚±ãƒ¼ãƒ«ã§ã¯ã‚ã‚‹ã‘ã©ã€æ‰‹å…ƒã«ã‚ã‚‹VMç’°å¢ƒã§ã‚‚ã€ã“ã®ãƒ™ãƒ³
gfx 2015/01/22
PostgreSQL

JSON
ãƒªãƒ³ã‚¯
PostgreSQLã‚¯ã‚¨ãƒªå®Ÿè¡Œã®åŸºç¤ŽçŸ¥è˜ ï½žExplainã‚’èªã¿è§£ã“ã†ï½ž
ãƒ•ãƒƒã‚¯ã‚’ä½¿ã£ãŸPostgreSQLã®æ‹¡å¼µæ©Ÿèƒ½ã‚’ä½œã£ã¦ã¿ã‚ˆã†ï¼ï¼ˆç¬¬33å›žPostgreSQLã‚¢ãƒ³ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹@ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ ç™ºè¡¨è³‡æ–™ï¼‰
gfx 2015/01/22
PostgreSQL
ãƒªãƒ³ã‚¯
What's new in PostgreSQL 9.4 - PostgreSQL wiki
This page contains an overview of PostgreSQL Version 9.4's features, including descriptions, testing and usage information, and links to blog posts containing further information. See also PostgreSQL 9.4 Open It ems. Major new features JSONB Binary JSON storage With the new JSONB data type for PostgreSQL, users no longer have to choose between relational and non-relational data stores: they can hav
gfx 2015/01/16
PostgreSQL
ãƒªãƒ³ã‚¯
Querying JSON in Postgres - Schinckel.net
Posted: 2014-05-25 @ 16:25:15 Tags: postgres json sql Comments: here. Yesterday, I discovered how you can enable jsonb in postgres/psycopg2. Today, I experimented around with how to query the data in json columns. There is documentation, but it wasnâ€™t initially clear to me how the different operations worked. CREATE TABLE json_test ( id serial primary key, data jsonb ); INSERT INTO json_test (data
gfx 2014/11/11
PostgreSQL

JSON
ãƒªãƒ³ã‚¯
GitHub - umitanuki/mongres
You 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
gfx 2014/10/02
MongoDB

PostgreSQL
ãƒªãƒ³ã‚¯
MySQL ã¨ SQLite ã«å¯¾å¿œã—ãŸ DBIx ãªãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ PostgreSQL ã«å¯¾å¿œã•ã›ã‚‹ Tips ã„ãã¤ã‹ - Articles Advent Calendar 2010 Casual
ã“ã‚“ã«ã¡ã¯ã€‚PostgreSQL ã‚’ã‚ˆãä½¿ã£ã¦ã„ã‚‹ id:sfujiwara (@fujiwara) ã§ã™ã€‚ ä¸–é–“ã§ã¯ MySQL ã®ã»ã†ãŒ PostgreSQL ã‚ˆã‚Šäººæ°—ã®ã‚ˆã†ã§ã™ã (ç‰¹ã« Web æ¥ç•Œã§ã¯)ã€‚ãªã®ã§ã€DBIx ãªä¾¿åˆ©ãªãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚‚é–‹ç™ºå½“åˆã¯ MySQL ã¨ SQLite ã§ã—ã‹å‹•ã‹ãªã‹ã£ãŸã‚Šã—ã¦æ‚²ã—ã„æ€ã„ã‚’ã™ã‚‹ã“ã¨ãŒã‚ã‚Šã€ã“ã¡ã‚ƒã“ã¡ã‚ƒ patch ã‚’æ›¸ã„ãŸã‚Šã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ ãã“ã§æºœã¾ã£ãŸã„ãã¤ã‹ã® Tips ã‚’ã“ã“ã§å…¬é–‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ 1. auto increment ã®æ‰±ã„ ã¾ãšã€ã„ã‚ã‚†ã‚‹è‡ªå‹•ç™ºç•ªãªã‚«ãƒ©ãƒ ã®æ‰±ã„ã«ã¤ã„ã¦ã€‚MySQL ã§ã¯ã‚«ãƒ©ãƒ å®šç¾©ã§ AUTO_INCREMENT æŒ‡å®šã€SQLite ã§ã¯æœ€åˆã®ã‚«ãƒ©ãƒ ã®åž‹ã‚’ INTEGER ã«ã—ã¦ PRIMARY KEY æŒ‡å®šã€ã§ã§ãã‚‹ã‚„ã¤ã§ã™ãã€‚PostgreSQL ã§ã¯ SERIAL åž‹ã‚’ä½¿ç”¨ã—ã¦å®šç¾©ã—ã¾ã™
gfx 2010/12/06
perl

database

postgresql
ãƒªãƒ³ã‚¯
1