[B! db] tekimenã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

tekimen id:tekimen

dbã«é–¢ã™ã‚‹tekimenã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

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

ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
åºæ–‡ ç§ã®ä»•äº‹ã¯ã€DB ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã™ã€‚ã¨ã„ã£ã¦ã‚‚åˆ¥ã«æœ›ã‚“ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œã¸ããŸã‚ã‘ã§ã¯ãªãã€å½“åˆã€ç§ã¯ã“ã®åˆ†é‡ŽãŒé¢ç™½ãã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸã€‚ã€ŒWebç³»ã¯èŠ±å½¢ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯æ—¥é™°ã€ã¨ã„ã†è¨€è‘‰ã‚‚å›ã‹ã‚Œã¦ã„ã¾ã—ãŸã€‚ä»Šã§ã‚‚å›ã‹ã‚Œã¦ã„ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã§ã™ãŒã€ã—ã°ã‚‰ããƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è§¦ã£ã¦ã„ã‚‹ã†ã¡ã«ã€ç§ã¯ã“ã®ä¸–ç•Œã«ã¨ã¦ã‚‚èˆˆå‘³æ·±ã„ãƒ†ãƒ¼ãƒžãŒå¤šãã‚ã‚‹ã“ã¨ã‚’çŸ¥ã‚Šã¾ã—ãŸã€‚ãªãœã‚‚ã£ã¨æ—©ãæ°—ã¥ã‹ãªã‹ã£ãŸã®ã‹ã€å¾Œæ‚”ã™ã‚‹ã“ã¨ã—ãã‚Šã§ã™ã€‚ ã‚‚ã¡ã‚ã‚“ã€è‡ªåˆ†ã®ä¸æ˜ŽãŒæœ€å¤§ã®åŽŸå› ã§ã™ãŒã€ã“ã®ä¸–ç•Œã«è¶³ã‚’è¸ã¿å…¥ã‚ŒãŸå½“æ™‚ã€å…ˆç”Ÿã‚‚ã€å°Žãã®æ›¸ã¨ãªã‚‹å…¥é–€æ›¸ã‚‚ãªã‹ã£ãŸã“ã¨ã‚‚äº‹å®Ÿã§ã™ã€‚ ä»Šã§ã“ããƒã‚¤ãƒ–ãƒ«ã¨ä»°ãã€Žãƒ—ãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®SQL ç¬¬2ç‰ˆã€ã‚‚æ–°å…¥ç¤¾å“¡ã«ã¯æ•·å±…ãŒé«˜ã™ãŽã¾ã—ãŸ (2015å¹´2æœˆè¿½è¨˜ï¼šãã®å¾Œã€è‡ªåˆ†ã§ç¬¬4ç‰ˆã‚’è¨³å‡ºã§ããŸã®ã ã‹ã‚‰ã€ äººç”Ÿã¯ä½•ãŒã‚ã‚‹ã‹åˆ†ã‹ã‚‰ãªã„ã‚‚ã®ã§ã™)ã€‚ ãã“ã§ã€ã§ã™ã€‚ã“ã®ã‚µã‚¤ãƒˆã®ç›®çš„ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œã«è¶³ã‚’è¸ã¿
tekimen 2024/03/01
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

sql

db
ãƒªãƒ³ã‚¯
IBMi db2ã¸ã€PHP ODBCã‹ã‚‰æŽ¥ç¶šã™ã‚‹ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? å°Žå…¥ ã“ã‚“ã«ã¡ã¯ã€‚phpã§ãŠä»•äº‹ã—ã¦ã¾ã™ã€‚ ãŠä»•äº‹ã®å‚ã€php-srcã®ã‚³ãƒ³ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚¿ã‚‚ã—ã¦ã„ã¾ã™ã€‚ ä»Šå›žã€phpã®odbc_connect()ãŠã‚ˆã³odbc_pconnect()ã®æ”¹ä¿®ã‚’ã™ã‚‹ã«ã‚ãŸã‚Šã€ã„ã‚ã‚“ãªODBCãƒ‰ãƒ©ã‚¤ãƒã®æŒ™å‹•ã‚’è¦‹ã‚‹å¿…è¦ãŒå‡ºã¦ãã¦IBMi db2ã«åˆã‚ã¦è§¦ã‚‹ã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ æ—¥æœ¬èªžã«ã—ã‚è‹±èªžã«ã—ã‚ã¾ã¨ã¾ã£ãŸæƒ…å ±æºãŒãªãã€ã‹ãªã‚Šæ‰‹æŽ¢ã‚Šã§æŽ¥ç¶šã¾ã§ãŸã©ã‚Šç€ã„ãŸã®ã§ã€å‚™å¿˜éŒ²ã‚’å…¼ãã¦è¨˜äº‹ã«ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸ ãªãŠã€ã“ã®è¨˜äº‹ã§ã¯ DBã«PUB400ã®IBMi db2ã‚’ä½¿ç”¨ phpã¯8.4ï¼ˆåŸ·ç†æ™‚ç‚¹ã®php-src mast
tekimen 2023/10/05
php

DB

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
PostgreSQLã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ãƒ¼æ¦‚è¦ï½œPostgreSQLã‚¤ãƒ³ã‚µã‚¤ãƒ‰
PostgreSQLã«ã¯ã€ç”¨é€”ã‚„ç’°å¢ƒã«å¿œã˜ã¦æ§˜ã€…ãªæ§‹æˆã‚’çµ„ã¿ã€æœ€é©ãªãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã§å‹•ä½œã•ã›ã‚‰ã‚Œã‚‹ã‚ˆã†ã€è¨å®šãƒ•ã‚¡ã‚¤ãƒ«postgresql.confã«å¤šãã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãƒ¼ãŒå˜åœ¨ã—ã¾ã™ã€‚ãã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãƒ¼ã‚’æ£ã—ãè¨å®šã—èª¿æ•´ã‚’è¡Œã†ãŸã‚ã«ã¯ã€PostgreSQLã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ãƒ¼ã‚’ç†è§£ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã“ã§ã¯ã€æŠ¼ã•ãˆã¦ãŠããŸã„ã€PostgreSQLã®åŸºæœ¬çš„ãªã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ãƒ¼ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ãªãŠã€ã“ã®è¨˜äº‹ã§å¯¾è±¡ã«ã—ã¦ã„ã‚‹PostgreSQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯9.5ä»¥é™ã§ã™ã€‚ 1. PostgreSQLã®åŸºæœ¬æ§‹æˆ PostgreSQLã®åŸºæœ¬çš„ãªæ§‹æˆã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ã¯ã˜ã‚ã«ã€ä¸»ãªãƒ—ãƒã‚»ã‚¹ã€ãƒ¡ãƒ¢ãƒªãƒ¼ã€ãŠã‚ˆã³ã€ãƒ•ã‚¡ã‚¤ãƒ«ã«ã¤ã„ã¦ã®æ§‹æˆå›³ã‚’ç¤ºã—ã¾ã™ã€‚ å›³1 PostgreSQLã®åŸºæœ¬æ§‹æˆ PostgreSQLã‚’æ§‹æˆã™ã‚‹ä¸»ãªãƒ—ãƒã‚»ã‚¹ã€ãƒ¡ãƒ¢ãƒªãƒ¼ã€ãƒ•ã‚¡ã‚¤ãƒ«ã«ã¤ã„ã¦ã€ãã®ç”¨èªžã¨æ¦‚è¦ã‚’èª¬æ˜Žã—ã¾ã™ã€‚ ãƒªã‚¹ãƒŠãƒ¼ãƒ—ãƒã‚»ã‚¹
tekimen 2023/08/14
postgresql

db
ãƒªãƒ³ã‚¯
GPUã¨SSDãŒPostgreSQLã‚’åŠ é€Ÿã™ã‚‹ï½žã‚¯ã‚¨ãƒªå‡¦ç†ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆ10GB/sã¸ã®æŒ‘æˆ¦ï½ž [DB Tech Showcase Tokyo/2017]
2. HeteroDBç¤¾ã«ã¤ã„ã¦ â–Œä¼šç¤¾ãƒ—ãƒãƒ•ã‚£ãƒ¼ãƒ« ï° å•†å·ï¼š ãƒ˜ãƒ†ãƒï¼¤ï¼¢æ ªå¼ä¼šç¤¾ ï° æ‰€åœ¨åœ°ï¼š æ±äº¬éƒ½å“å·åŒºè¥¿å¤§äº•ï¼‘ãƒ¼ï¼‘ãƒ¼ï¼’ ï° è¨ç«‹ï¼š 2017å¹´7æœˆ4æ—¥(ç«) ï° äº‹æ¥å†…å®¹ï¼š GPU/SSDã«ã‚ˆã‚‹é«˜é€ŸSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è£½å“ã®é–‹ç™ºãƒ»è²©å£² GPUç‰ã®æ´»ç”¨ã‚’å«ã‚€SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚µãƒ¼ãƒ“ã‚¹ ï° ä¸»è¦æ ªä¸»ï¼š è¨ç«‹ãƒ¡ãƒ³ãƒãƒ¼ã«ã‚ˆã‚‹100%ä¿æœ‰ â–Œè¨ç«‹ãƒ¡ãƒ³ãƒãƒ¼ æµ·å¤– æµ©å¹³ï¼ˆãƒãƒ¼ãƒ•ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒˆ å…¼ ä»£è¡¨å–ç· å½¹ç¤¾é•·ï¼‰ OSSé–‹ç™ºè€…ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã«ãŠã„ã¦ã€Linux kernelã‚„PostgreSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é–‹ç™ºã«10å¹´ä»¥ä¸Šå¾“äº‹ã€‚ PostgreSQLã®SELinuxå¯¾å¿œã‚„FDWæ©Ÿèƒ½æ‹¡å¼µãªã©ã‚³ã‚¢æ©Ÿèƒ½å¼·åŒ–ã«è²¢çŒ®ã—ã¦ãŠã‚Šã€PostgreSQLã®Major Contributor ã¨ã—ã¦çŸ¥ã‚‰ã‚Œã¦ã„ã‚‹ã€‚ 2012å¹´ã€ GPUã«ã‚ˆã‚‹PostgreSQLã®é«˜é€ŸåŒ–æ©Ÿæ§‹ã§ã‚ã‚‹PG-Stromã®é–‹ç™ºã«ç€æ‰‹ã€‚ä»¥é™ã€ãƒ˜ãƒ†
tekimen 2018/02/04
GPU

db

postgresql
ãƒªãƒ³ã‚¯
MySQLã®FLOATåž‹ã‚’ä½¿ã†ç†ç”±ãŒè¦‹ã¤ã‹ã‚‰ãªã„ä»¶ - hnwã®æ—¥è¨˜
MySQLã®ãƒ‡ãƒ¼ã‚¿åž‹ã¨ã—ã¦FLOATåž‹ã¨ã„ã†åž‹ãŒã‚ã‚‹ã®ã§ã™ãŒã€ã“ã‚Œã‚’æŽ¡ç”¨ã™ã‚‹ã®ã¯æ··ä¹±ã®å…ƒã§ã¯ãªã„ã‹ï¼Ÿã¨æ„Ÿã˜ãŸã®ã§ã€ãã®è©³ç´°ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ãã‚‚ãã‚‚ã“ã®è©±ã®ãã£ã‹ã‘ã¯ã€ŒMySQLã§6æ¡ã¾ã§ã®å°æ•°ç‚¹ã‚’ä¸¸ã‚ãšã«æ‰±ã†ãªã‚‰FLOATåž‹ã‚’ä½¿ã†ã¹ãç†ç”±ã€ã¨ã„ã†è¨˜äº‹ãŒç›®ã«æ¢ã¾ã£ãŸã“ã¨ã§ã™ã€‚ãã‚Œãªã‚Šã«äººæ°—ã‚’é›†ã‚ã¦ã„ã‚‹è¨˜äº‹ã®ã‚ˆã†ã§ã™ãŒã€ç§ã®èªã‚“ã é™ã‚Šã§ã¯FLOATåž‹ã‚’ä½¿ã†ã ã‘ã®æ ¹æ‹ ãŒæ–‡ä¸ã‹ã‚‰èªã¿å–ã‚Œãšã€ã•ã‚‰ã«é¡žä¼¼ã™ã‚‹ä¸€æ¬¡æƒ…å ±ã‚„è‹±èªžè¨˜äº‹ãŒå…¨ãè¦‹ã¤ã‹ã‚‰ãªã‹ã£ãŸã®ã§ã€çœŸå½ãŒæ€ªã—ã„æƒ…å ±ã ã¨æ„Ÿã˜ã¾ã—ãŸã€‚ ãã®å¾Œã€MySQLä¸Šã§å®Ÿé¨“ã—ãŸã‚ŠCã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’èªã‚“ã§ã¿ãŸã‚Šã—ãŸçµæžœã€ç§ã®å¾—ãŸçµè«–ã¯çœŸé€†ã®ã‚‚ã®ã«ãªã‚Šã¾ã—ãŸã€‚MySQLè¦å¯Ÿã®æ–¹ã‚„æµ®å‹•å°æ•°ç‚¹æ•°è¦å¯Ÿã®æ–¹ã€è¿½è©¦ã‚„åè«–ãªã©é ‚ã‘ã‚‹ã¨åŠ©ã‹ã‚Šã¾ã™ã€‚ MySQLã®FLOATåž‹ã¨ã¯ MySQLã®FLOATåž‹ã¯åŽŸå‰‡ã¨ã—ã¦IEEE754æµ®å‹•å°æ•°ç‚¹æ•°å˜ç²¾åº¦åž‹ï¼ˆ32bitï¼‰ã§å®Ÿç¾ã•ã‚Œã¾ã™*1ã€‚
tekimen 2017/12/22
MySQL

FLOAT

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

DB
ãƒªãƒ³ã‚¯
ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆä¸Šã«å…¬é–‹ã•ã‚Œã¦ã—ã¾ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«(2017-08-08) - JPCERT/CC Eyes
2017å¹´6æœˆä¸‹æ—¬ã«ãƒ‰ã‚¤ãƒ„ã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ç ”ç©¶è€…ã‚ˆã‚Šã€æ—¥æœ¬å›½å†…ã®å¤šæ•°ã®Webã‚µã‚¤ãƒˆã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ï¼ˆä»¥ä¸‹ã€Œãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã€ï¼‰ãŒå¤–éƒ¨ã‹ã‚‰é–²è¦§ã§ãã‚‹çŠ¶æ…‹ã«ã‚ã‚‹ã¨ã®å ±å‘Šã‚’å—ã‘ã¾ã—ãŸã€‚JPCERT/CCã§ã¯ã€æä¾›ã„ãŸã ã„ãŸæƒ…å ±ã‚’ã‚‚ã¨ã«è©²å½“ã™ã‚‹Webã‚µã‚¤ãƒˆã®ç®¡ç†è€…ã«é€£çµ¡ã—ã€çŠ¶æ³ã‚’ç¢ºèªã—ã¾ã—ãŸã€‚ä»Šå›žã¯ã€ã“ã®å•é¡Œã«ã¤ã„ã¦ç¢ºèªã§ããŸçŠ¶æ³ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ã¾ãŸã€å ±å‘Šè€…ã¯2017å¹´7æœˆ5æ—¥ã«ã€ã“ã®å•é¡Œã«ã¤ã„ã¦ä¸–ç•Œã§ã®çŠ¶æ³ã‚’è¨˜äº‹[1]ã¨ã—ã¦å–ã‚Šä¸Šã’ã¦ã„ã¾ã™ã€‚ ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãƒ«ãƒ¼ãƒˆç›´ä¸‹ã«è¨ç½®ã•ã‚ŒãŸãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ« å•é¡Œã®ãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã¯ã€ã©ã®Webã‚µã‚¤ãƒˆã§ã‚‚dump.sqlãªã©ã®ãƒ•ã‚¡ã‚¤ãƒ«åã§Webã‚µãƒ¼ãƒã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãƒ«ãƒ¼ãƒˆç›´ä¸‹ã«ç½®ã‹ã‚Œã¦ãŠã‚Šã€ãã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‚ç…§ã™ã‚‹URLã«ç›´æŽ¥ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚Œã°ã€ãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã‚’é–²è¦§ã§ãã‚‹çŠ¶æ…‹ã«ãªã£ã¦ã„ã¾ã—ãŸã€‚ JPCERT/CCã§ã¯ã€å ±å‘Šã‚’å—ã‘ãŸå½“åˆã€åºƒç¯„å›²ã«è¡Œã‚ã‚ŒãŸä½•ã‚‰ã‹ã®
tekimen 2017/08/08
ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãƒ«ãƒ¼ãƒˆé…ä¸‹ã—ã‹ã‚¢ã‚¯ã‚»ã‚¹è¨±å¯ã®ãªã„(FTP(å¯Ÿã—ã¦)ã‚‚)ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ãªã©ã§ãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã›ã–ã‚‹ã‚’å¾—ãªã„ã¨ã„ã†ã‚µãƒ¼ãƒãƒ¼ã‚’å¤‰ãˆã¦ã»ã—ã„ã®ã«ã§ããªã„ã€‚å‘¨ã‚Šã«ç†è§£è€…ãŒã„ãªã‹ã£ãŸã‚±ãƒ¼ã‚¹

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

web

db

security
ãƒªãƒ³ã‚¯
1