PostgreSQL Conference 2012ã§è¬æ¼ããæ©ä¼ãé ãã¾ããã®ã§å ±åãã¾ãã æ¥æï¼2012å¹´2æ24æ¥ï¼éææ¥ï¼ 14æ30åã17æ20åï¼å¾³ä¸¸ã®åºçªã¯16:30ã17:00ï¼ å ´æï¼AP åå· ï¼æ±äº¬é½æ¸¯åºï¼ è²»ç¨ï¼3,500åï¼ç³ãè¾¼ã¿ã¯ãã¡ãï¼ è¬æ¼ã¿ã¤ãã«ï¼å®å ¨ãªSQLã®å¼ã³åºãæ¹ ä»åã¯ãIPAã®å®å ¨ãªSQLã®å¼ã³åºãæ¹ãé¡æã¨ãã¦ãSQLã¤ã³ã¸ã§ã¯ã·ã§ã³ã®çºçåçãããå®å ¨ãªSQLã®å©ç¨æ¹æ³ãåºç¤ããå®éã¾ã§ã説æãã¾ãã ãã¾ãããªããã¼ãªæ»æã®æ¹æ³ã¯ããªãã¤ããã§ãåºç¤çãªè©±ãä¸å¿ã¨ãªãã¾ããå®å ¨ãªSQLã®å¼ã³åºãæ¹ã®ä½æçµç·¯ã«ã¤ãã¦ã¯ããä»å¤ãããããå®å ¨ãªSQLã®å¼ã³åºãæ¹ ã é«æ¨æµ©å æ°ã«èãã¦ã¿ãããåç §ä¸ããã ãã¦ããå®å ¨ãªSQLã®å¼ã³åºãæ¹ãã¯ä»¥ä¸ã®äºåã«ããå·çã¨ãªã£ã¦ãã¾ãã å·çè 徳丸 浩ãã æ°¸å® ä½å¸å ãã ç¸é¦¬ åºé¦ãã å
PostgreSQL Conference ã¯ãæ¥æ¬ PostgreSQL ã¦ã¼ã¶ä¼ï¼JPUGï¼ãæ¯å¹´éå¬ãã¦ãã æè¡ç話é¡ãä¸å¿ã¨ããã«ã³ãã¡ã¬ã³ã¹ã§ãPostgreSQL ã«é¢ããå å¤ã®å°å ¥äºä¾ ããã³æè¡æ å ±ãæä¾ããæä¾ã®ã¤ãã³ãã¨ãªã£ã¦ããã¾ãã æ¨å¹´ãPostgreSQL ã¯ã¬ããªã±ã¼ã·ã§ã³æ©è½ãä¼´ã£ããã¼ã¸ã§ã³ 9.0 ãå ¬éããã ä»å¹´ã¯ããã«é²åãããã¼ã¸ã§ã³ 9.1 ãå ¬éããããªã©ã ç¾å¨ãçºå±ã¨é²åãçå®ã«ç¶ãã¦ããå é²ç㪠DBMS ã§ãã æ´æ°å±¥æ´ è³æãå ¬éãã¾ããã New! 2012/02/22 ãåå ã®çæ§ã¸ã®ãæ¡å ãæ²è¼ãã¾ããã 2012/02/22 Ustream ã§ã®ä¸ç¶ã«ã¤ãã¦æ²è¼ãã¾ããã 2012/02/20 VMware ãã¾ã®ã©ã³ãã»ãã·ã§ã³ãæ²è¼ãã¾ããã 2012/02/20 ãã±ãã販売ç¶æ³ãæ²è¼ãã¾ãããã«ã³ãã¡ã¬ã³ã¹ã®ãã±ã
å¹³ç´ ãããPHPããï¼ãããæ顧ããã ããèª ã«ãããã¨ããããã¾ãã 2006å¹´ããéå¶ãã¦ã¾ããã¾ãããPHPããï¼ãã§ããããµã¼ãã¹ã®å©ç¨ç¶æ³ãéã¿ã¾ãã¦ã2018å¹´9æ25æ¥ï¼ç«ææ¥ï¼ããã¡ã¾ãã¦ãµã¼ãã¹ãçµäºããã¦ããã ããã¨ã«ãªãã¾ããã ãµã¼ãã¹çµäºã«ä¼´ãã¾ãã¦ã2018å¹´8æ28æ¥ï¼ç«ææ¥ï¼ãæã¡ã¾ãã¦ãæ°è¦ä¼å¡ç»é²ãªãã³ã«Q&Aæ²ç¤ºæ¿ã¸ã®æ°ããªè³ªåãåçã®æ稿ãåæ¢ããã¦ããã ãã¾ãã ãªãããç»é²ããã ããçæ§ã®å人æ å ±ã«ã¤ãã¾ãã¦ã¯ããµã¼ãã¹çµäºå¾ãå¼ç¤¾ã責任ããã£ã¦æ¶å»ãããã¾ãã ããã¾ã§å¤ãã®çæ§ã«ãå©ç¨ãããã ãã¾ãã¦ãèª ã«ãããã¨ããããã¾ããã ãµã¼ãã¹çµäºã«ä¼´ããçæ§ã«ã¯ãä¸ä¾¿ãããããããã¾ããã¨ãå¿ãããè©«ã³ç³ãä¸ãã¾ãã æ¬ä»¶ã«é¢ãããåãåããã¯ãã¡ããããé¡ããããã¾ãã
(Last Updated On: 2018å¹´8æ13æ¥)PostgreSQL Advent Calenderç¨ã®ã¨ã³ããªã§ãã ã¨ã¹ã±ã¼ãå¦çãå¿ è¦ãªã®ã«ã¨ã¹ã±ã¼ãç¨ã®APIãç¡ãç¶æ ã¯è¯ãããã¾ãããã¨ã¹ã±ã¼ãããªãããã«åããªãã®ã¯ã¾ã è¯ãæ¹ã§ããã¨ã¹ã±ã¼ããå¿ è¦ãªã®ã«ã¨ ã¹ã±ã¼ããããªãã¦ãåãã¦ãã¾ããã»ãã¥ãªãã£ä¸ã®åé¡ã¨ãªãå ´åãããã¾ããå ¨ã¦ã®ã¢ããªã±ã¼ã·ã§ã³ã»ã©ã¤ãã©ãªã¯ã¨ã¹ã±ã¼ããå¿ è¦ãªãã¼ã¿ã«å¯¾ããAPIãæã£ã¦ããã¹ã ã§ããä»åã¯PostgreSQL 9.0ãã追å ãããã¨ã¹ã±ã¼ãé¢æ°ãç´¹ä»ãã¾ãã PostgreSQL使ãå§ãã¦æåã®é ã«æ°ã¥ãã®ã¯userãªã©ã®äºç´èªããã£ã¼ã«ãåã«ä½¿ããªãäºããç¥ãã¾ãããä¾ãã°ã yohgaki@[local] test=# CREATE TABLE user (name text); ERROR: syntax erro
大å£ããã®å¯ç¨¿è¨äºã第44å ã»ãã¥ãªãã£å¯¾çã確å®ã«å®æ½ãããªã2ã¤ã®çç±ï¼ãªãPHPã¢ããªã«ã»ãã¥ãªãã£ãã¼ã«ãå¤ãã®ã?ï½gihyo.jp ⦠æè¡è©è«ç¤¾ãã®ã¾ã¨ãã«ã¦ããæå¾ã«ãä½ãæ£ããã®ãï¼ã常ã«èããããã«ãã¦ãã ãããã¨æ¸ããã¦ãã¾ãããã®é¨åã¯ãç§ã¸ã®åè«ã®ããã§ãã®ã§ããã®ã¨ã³ããªã§è¿çãããã¨æãã¾ãã 大å£ããã®ä¸»å¼µ å ã«ãè¿°ã¹ãããã«ã大å£ããã¯ãã®ã¨ã³ããªã®ãã¾ã¨ããã¨ãã¦ä»¥ä¸ã®ããã«æ¸ããã¦ãã¾ãã æå¾ã«ãä½ãæ£ããã®ãï¼ã常ã«èããããã«ãã¦ãã ããã http://gihyo.jp/dev/serial/01/php-security/0044?page=2 ãã®ä¸»å¼µèªä½ã«ã¯ç§ã大è³æã§ãã大å£ããã®è¨äºã¯ä»¥ä¸ã®ããã«ç¶ãã¾ãã ä¾ãã°ï¼SQLæãä½æããå ´åã«ãªãã©ã«ï¼ãã©ã¡ã¼ã¿ï¼ãæååã¨ãã¦ã¨ã¹ã±ã¼ãããã¨æµ®åå°æ°ç¹åã®ãã¼ã¿ãæ£ããå¦çãããªãã
PostgreSQL9.1ã®ä»æ§å¤æ´ã«ã¦ãããã©ã«ãæã®è¨å®ã¨ãã¦ãstandard_conforming_stringsãonã¨ã¿ãªãããããã«ãªãã¾ããããã®ä»æ§å¤æ´ã«ãããããã©ã«ãè¨å®ã§ã®PostgreSQLã¯ãããã¯ã¹ã©ãã·ã¥ãã¨ã¹ã±ã¼ãããå¿ è¦ããªããªããISOè¦æ ¼ã®SQLã¨åæ§ã®ã¨ã¹ã±ã¼ãã«ã¼ã«ï¼ã·ã³ã°ã«ã¯ã©ã¼ããéããã®ã¿ï¼ã¨ãªãã¾ãã PostgreSQLã®æååãªãã©ã«ã¯ãå ã MySQLåæ§ã«ãããã¯ã¹ã©ãã·ã¥ãã¨ã¹ã±ã¼ãããä»æ§ã§ããããã®å¾ããªãªã¼ã¹8.1ã«ã¦ãè¨å®ãã©ã¡ã¼ã¿ standard_conforming_strings ã追å ããããã®å¤ã on ã®å ´åãããã¯ã¹ã©ãã·ã¥ãã¨ã¹ã±ã¼ãããªãï¼ISOè¦æ ¼ã¨åæ§ã®ï¼ä»æ§ã¨ãªãã¾ãããå¾æ¥ã®ãªãªã¼ã¹ã§ã¯ãstandard_conforming_stringsãæå®ããªãå ´åoffã¨ã¿ãªããã¦ãã¾ãããããã¯ãå¾
PostgreSQL 9.1.0 ã 2011å¹´9æ12æ¥ã«ãªãªã¼ã¹ããã¾ããã ææ°çã®ãã¤ããªãã½ã¼ã¹ã³ã¼ã㯠"ãã¦ã³ãã¼ãç¨ãã¼ã¸" ã§é å¸ããã¦ãã¾ãã 9.1 ã§ã¯ã9.0 ã§æ°è¦ã«æ¡ç¨ãããã¬ããªã±ã¼ã·ã§ã³æ©è½ã®ä½¿ãåæã®å¼·åã®ä»ãå¤é¨ã®ãã¡ã¤ã«ã DB ã«ç´æ¥ã¢ã¯ã»ã¹ã§ãã SQL/MED ããæ¡å¼µã¢ã¸ã¥ã¼ã«ã®ç®¡çæ©è½ãªã©ããããªãå¼·åãè¡ããã¦ãã¾ãã äºææ§ã«é¢ãã注æ æåã注æã«ãªã£ã¦ãã¾ãã¾ããã以åã®ãã¼ã¸ã§ã³ã¨ã®äºææ§ã®ç¡ãè¨å®ãããã©ã«ãã«å¤æ´ããã¦ãã¾ããæ¯è¼çå¤ãã®ã¢ããªã±ã¼ã·ã§ã³ã§åé¡ã«ãªãå¯è½æ§ããããããããã¦å¼·èª¿ãã¦æ³¨æããã¦ãããã¾ãã standard_conforming_strings ã®ããã©ã«ãã on ã«å¤æ´ standard_conforming_strings = on ãããã©ã«ãã«ãªãã¾ãããE'...' å½¢å¼ã§ãªãæååå
E.76.1. Overview This release shows PostgreSQL moving beyond the traditional relational-database feature set with new, ground-breaking functionality that is unique to PostgreSQL. The streaming replication feature introduced in release 9.0 is significantly enhanced by adding a synchronous-replication option, streaming backups, and monitoring improvements. Major enhancements include: Allow synchrono
http://pc.nikkeibp.co.jp/article/column/20110519/1031877/ ä»å¾ã«æå¾ ãç¾æ®µéã§ã¯ãã以å¤ã«ç¹ã«çµè«ã¯ãªãã ã¨ãããã¨ã§ããã®ãã QVC = Qã«Voã¼ã«ãCuiãã®ã§ã è¦ãããæ¥ã«ãã¼ã«ãæ¥ããã°ã©ããæããã°ããã§ããï¼ããããªãã¦ãªã¼ãã£ãºã http://gihyo.jp/dev/serial/01/php-security/0042 å··ã§å©ããã¦ãã¾ããã ãã®è¨äºèªãã§ããããã§ããªã¬ã¯ãã¤ã³ãå¤æ°ã使ç¨ãã¦ç¡å®³åã¯JDBCãã©ã¤ãã«ä»»ããã¹ãã ã¨æããã©ããæ¼ãããã®ããµãã¿ã¤ãºã¨ã¹ã±ã¼ãã ã¨ãRDBMSã«ãã£ã¦å¯¾è±¡ã®æåãå¤ããããã Javaã§è¨ãPreparedStatementã ã¨ãã¼ãã«åãååããã¤ã³ãå¤æ°ã«ã§ããªããã¨ããã®ã¨ãã ããPreparedStatementãããªãã¦ãµãã¿ã¤ãºã¨ã¹ã±ã¼ããã£
Sunday, April 10, 2011 MySQL ã® Prepared Statement ããã¯ãSQL ã¤ã³ã¸ã§ã¯ã·ã§ã³ãå°ãã ãåå¼·ããã®ã§ãããã«é¢ãã¦ãããç§çãªã¡ã¢ãæ¸ãæ®ãã¦ãããã¨æããæ å ±å¦çæ¨é²æ©æ§ (IPA) ã® ãå®å ¨ãªã¦ã§ããµã¤ãã®ä½ãæ¹ã ã§ã¯ãSQL ã¤ã³ã¸ã§ã¯ã·ã§ã³ã®èå¼±æ§ãäºé²ããããã®æ ¹æ¬ç解決ã¨ãã¦ãã¾ã第ä¸ã« ãSQL æã®çµã¿ç«ã¦ã¯å ¨ã¦ãã¬ã¼ã¹ãã«ãã§å®è£ ããã(æ¹è¨ç¬¬5ç p.9) ã¨è¿°ã¹ã¦ããã ãã¬ã¼ã¹ãã«ãã¼ã«ã¯ãåçãã¬ã¼ã¹ãã«ãã¼ã¨éçãã¬ã¼ã¹ãã«ãã¼ããã£ã¦ããããã«ã¤ãã¦ã¯ IPA ã® ãå®å ¨ãª SQL ã®å¼ã³åºãæ¹ã ã詳ããã ã¾ããæè¿åè¡ããã ãä½ç³»çã«å¦ã¶ å®å ¨ãª Web ã¢ããªã±ã¼ã·ã§ã³ã®ä½ãæ¹ã(徳丸浩è ã½ãããã³ã¯ã¯ãªã¨ã¤ãã£ã ISBN978-4-7973-6119-3) ã«ã詳ãã解説ãè¼ã£ã¦ããã大
ãªã¼ãã³ã½ã¼ã¹ãã¼ã¿ãã¼ã¹ãå éããããã ã©ãã¼ãã¼ãã®ããã°ã§ããã«ã¬ã¼æ¥è¨ãå ¼ãã¦ã¾ãããªãèè ã¯2010-06-01ããæ¥æ¬ãªã©ã¯ã«ã«å¨ç±ãã¦ãã¾ãããæ¬ãµã¤ãï¼ããã°ãã¾ãã¯ã¦ã§ããµã¤ãï¼ã«ããã¦ç¤ºããã¦ããè¦è§£ã¯ãç§èªèº«ã®è¦è§£ã§ãã£ã¦ããªã©ã¯ã«ã®è¦è§£ãå¿ ãããåæ ãããã®ã§ã¯ããã¾ããã
ãSQLã¤ã³ã¸ã§ã¯ã·ã§ã³ãåé¿çã¨ãã¦èããã®ã§ãããã©ããªãã§ããããï¼ï¼ï¼ SQLã¤ã³ã¸ã§ã¯ã·ã§ã³ã®å¯¾çã§æ©ãã§ã¾ã ã¦ã¼ã¶å test ãã¹ã¯ã¼ã pass ãå ¥åãããã©ã¼ã ãããã¾ãã ã¦ã¼ã¶åã¨ãã¹ã¯ã¼ããå ¥åããããã¾ãä¸è¨ã®ï¼³ï¼±ï¼¬ãå®è¡ SELECT user_password FROM a_m_user WHERE USER_ID = 'test' ãã®ãã¨åå¾ããuser_passwordã¨å ¥åãããã¹ã¯ã¼ãï¼passï¼ãæ¯è¼ããããæ¹ãªã®ã§ããã SQLã¤ã³ã¸ã§ã¯ã·ã§ã³ã¾ãã¯ã»ãã¥ãªãã£çã«ã¯ä¸å ¨ãªã®ã§ããããï¼ï¼ï¼ â»ä¸å ¨ã¨ããè¨èã¯é£ããã¨æãã¾ãããæªæã®ããæ»æããããã¯ã§ããã§ãããï¼ï¼ï¼'
ããã«ã¡ã¯ãSQLãæãã¦ãã¾ãªãmoriyoshiã§ãã ã¹ãã¢ãããã·ã¼ã¸ã£ã¯ãä¸é£ã®SQLæããµãã«ã¼ãã³ã®ããã«DBãµã¼ãã«è¨é²ãã¦ãããå¾ãããããå¼ã³åºããã¨ãã§ããããã«ããä»çµã¿ã§ããè¿ä»£çãªRDBMSã«ã¯æ¨æºçã«åãã£ã¦ããæ©è½ã¨ããã¾ãã å¶å¾¡æ§é ãªã©ãSQLæã§è¨è¿°ãããã¨ãã§ããã®ã§ãçµæçã«ããããããã¸ãã¯ãSQLã®ã¿ã§è¨è¿°ãããã¨ãã§ãã¾ããæç¶ãåããã°ã©ãã³ã°ã«ã©ã£ã·ã浸ãã£ãç¾å ´ã®æ¹ããæç¨ããã¦ããã¨è¨ããã¦ãã¾ãã ä»åã¯ãã¹ãã¢ãããã·ã¼ã¸ã£ã®å¿ç¨ã¨ãã¦ãWebã¹ã¯ã¬ã¤ãã³ã°ãè¡ãªã£ã¦ã¿ã¾ããããWebã¹ã¯ã¬ã¤ãã³ã°ã¨ã¯ãç¹å®ã®Webãµã¤ãã«ã¢ã¯ã»ã¹ãããã®ãã¼ã¸ã®å 容 (HTML) ãåå¾ã解æããå¿ è¦ãªæ å ±ãåãåºãã¨ããä¸é£ã®æä½ãèªååãããã¨ã§ããWebã¹ã¯ã¬ã¤ãã³ã°ãå¹æçã«æ´»ç¨ããã¨ã人éããã©ã¦ã¶ã«åãã£ã¦åç´ä½æ¥ãç¹°ãè¿ãå¿ è¦ããª
ãã¼ã > mysql | perl > mysqlã§skip-character-set-client-handshakeã¯ãã使ããªãã»ããããã¨æãã æ°ãã å¤ã skip-character-set-client-handshake ã [mysqld] ã»ã¯ã·ã§ã³ã«è¿½è¨ããã¨ãã¯ã©ã¤ã¢ã³ããã©ããªæåã³ã¼ãè¨å®ããã£ã¦ããããåçç¡ç¨ã§ character_set_* ã (_system ãã®ããã¦) ãã¹ã¦åãå¤ã«çµ±ä¸ãã¦ããã http://d.hatena.ne.jp/a666666/20090826/1251270979 ãµã¼ãã skip-character-set-client-handshakeãè¦ããææ¸ããããä¸ã«ã¯ããã転ãã£ã¦ããã ãã©ãããã«ã¯å¤§ããªè½ã¨ãç©´ãããã ãããã«è¡¨ç¤ºãããcharacter_set_*ã¯çµ±ä¸ããããããããªããããã¯ããã¾
ãµã¼ãã¹çµäºã®ãç¥ãã ãã¤ãYahoo! JAPANã®ãµã¼ãã¹ããå©ç¨ããã ãèª ã«ãããã¨ããããã¾ãã ã客æ§ãã¢ã¯ã»ã¹ããããµã¼ãã¹ã¯æ¬æ¥ã¾ã§ã«ãµã¼ãã¹ãçµäºãããã¾ããã ä»å¾ã¨ãYahoo! JAPANã®ãµã¼ãã¹ããæ顧ãã ããã¾ãããããããããé¡ããããã¾ãã
SQL 㧠LIKE æ¡ä»¶ã使ãã¨ãã¿ã¼ã³ä¸è´æ¤ç´¢ãå®è¡ã§ãã¾ãã ãã®æã'%'ã¨'_'ã¯ããããä»»æã®æååãä»»æã®ï¼æåã表ãç¹æ®æåã¨ãã¦æ±ããã¾ãã ãããã£ã¦ã'%'ã'_'ã¨ããæåãæ¤ç´¢ãããå ´åã¯ãã¨ã¹ã±ã¼ãæåã使ç¨ãã¦ãæåã¨ãã¦ã®'%'ã'_'ã§ãããã¨ãæ示ããå¿ è¦ãããã¾ãã ä¾ãã°ãCOL1 ã«'_'ãå«ã TBL1 ã®ã¬ã³ã¼ããæ¤ç´¢ãããå ´åã¯ä»¥ä¸ã®ããã«è¨è¿°ãã¾ãã SELECT * FROM TBL1 WHERE COL1 LIKE '%\_%' ESCAPE '\' ã¨ãããã¾ã§ã¯ SQL ã®å¸¸èã§ãã ããããå®ã¯ãã®'%'ã¨'_'ãå ¨è§ã®'ï¼ 'ã'_'ã§ããã¯ãç¹æ®æåã¨ãã¦èªèããã¦ãã¾ãã®ã§ãã ã¤ã¾ãã SELECT * FROM TBL1 WHERE COL1 LIKE '%_%' ã¨è¨è¿°ããã¨ãâä»»æã®ï¼æåãå«ãâã¨ãªãã¾ãã®ã§ãNul
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}