ãã®ãã¡ã¤ã³ã¯ããåå.comã§åå¾ããã¦ãã¾ãã ãåå.comã®ããããã¼ã¸ã¸ Copyright © 2020 GMO Internet, Inc. All Rights Reserved.
ä½æ¥ã¡ã¢ã§ãã src.rpm ã®åå¾ # cd /usr/src/redhat/SRPMS # wget http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-community-5.1.42-0.rhel5.src.rpm/from/http://ftp.iij.ad.jp/pub/db/mysql/ rpmbuild --recompile ãã«ãæã®ã½ã¼ã¹ããªã¼ãå¿ è¦ãªã®ã§ recompile # rpmbuild --recompile --define 'community 1' /usr/src/redhat/SRPMS/MySQL-community-5.1.42-0.rhel5.src.rpm checkinstall 㧠rpm å make æã« MYSQL_LIBDIR ãã¤ãã¦ãã®ã¯ libmysqlclient.s
ã¬ããªã±ã¼ã·ã§ã³ã¨Q4Mã使ã - JPerl Advent Calendar 2009 Perl ã«é¢ããã¡ãã£ã¨ãã Tips ãã®ã£ãã¦ã¿ãããã¡ããã¨ç¶ãããªï¼ ã¬ããªã±ã¼ã·ã§ã³ã使ã MySQL ã«ã¯ã¬ããªã±ã¼ã·ã§ã³æ©è½ãããã®ã¯ã¨ã¦ãç¥ããã¦ããäºã§ãã ã¬ããªã±ã¼ã·ã§ã³ã®ç¡ã MySQL ã¯ããã©ã¦ã³ç®¡ã®ç¡ããã©ã¦ã³ç®¡ãã¬ããããã®ç©ã§ãããã ãã㦠ORM ã§ãåã£ã¦ãåããªãç©ã§ã¯ç¡ãã§ããããã Data::ObjectDriver ã§ã livedoor ã®ã©ã£ãã®ãµã¼ãã¹ã§èªä½ Driver æ¸ãã¦ä½¿ã£ã¦ãã¨ã DBIC ã®ä¸çã§ã DBIx::Class::Storage::DBI::Replicated ãªãã¦ç©ãããããã§ãã ãã¡ãã Data::Model ã§ã対å¿ãã¦ãã¾ãã Driver::DBI::MasterSlave ã§ãã Driver::D
GT Nitro: Car Game Drag Raceã¯ãå ¸åçãªã«ã¼ã²ã¼ã ã§ã¯ããã¾ãããããã¯ã¹ãã¼ãããã¯ã¼ãã¹ãã«å ¨éã®ã«ã¼ã¬ã¼ã¹ã²ã¼ã ã§ãããã¬ã¼ãã¯å¿ãã¦ãããã¯ãã©ãã°ã¬ã¼ã¹ããã¤ãã¼ï¼å¤å ¸çãªã¯ã©ã·ãã¯ããæªæ¥çãªãã¼ã¹ãã¾ã§ãæãã¯ã¼ã«ã§éãè»ã¨ã«ã¼ã¬ã¼ã¹ã§ãã¾ããã¹ãã£ãã¯ã·ããããã¹ã¿ã¼ããããããè³¢ã使ã£ã¦ç«¶äºãæã¡ç ´ãå¿ è¦ãããã¾ãããã®ã«ã¼ã¬ã¼ã¹ã²ã¼ã ã¯ãã®ãªã¢ã«ãªç©çå¦ã¨ç´ æ´ãããã°ã©ãã£ãã¯ã¹ã§ããªãã®å¿ãççºããã¾ããããã¾ã§ãã¬ã¤ãããã¨ã®ãªããããªãã®ã§ãã GT Nitroã¯ããªãã¬ãã¯ã¹ã¨ã¿ã¤ãã³ã°ã試ãã«ã¼ã¬ã¼ã¹ã²ã¼ã ã§ããæ£ããç¬éã«ã®ã¢ãã·ããããã¬ã¹ãæãåãè¸ãå¿ è¦ãããã¾ããã¾ãã大ç©ãã¡ã¨ç«¶ãã¤ã¤ãè»ã®ãã¥ã¼ãã³ã°ã¨ã¢ããã°ã¬ã¼ããè¡ããªããã°ãªãã¾ãããä¸çä¸ã§æé«ã®ãã©ã¤ãã¼ã¨è»ã¨ã«ã¼ã¬ã¼ã¹ã«æããã¨ã«ãªãããã©ãã°ã¬ã¼ã¹ã®çå
æ¥æ¬PHPã¦ã¼ã¶ä¼ä¸»å¬ éå¬æ¥: 2009å¹´9æ4æ¥(é) æ±äº¬é½ ãªã©ã¯ã«éå±±ã»ã³ã¿ã¼ / 9æ5æ¥(å) æ±äº¬é½ 大ç°åºç£æ¥ãã©ã¶PiO å ¬å¼ã¿ã°: pcj09 ããã°ã©ã è¨å¿µãã¹ã第10åã«ãµããããï¼ Facebook éçºè Brian Shire æ° symfony éçºè Fabien Potencier æ° Taiwan PHP User Group ã® Finjon Kiang æ° ãªã©è±ªè¯ã¹ãã¼ã«ã¼ãè¿ãã¦éå¬ãããã¾ãï¼ ãã¸ãã¹ã㤠2009/09/04(Fri) Time ã»ããã¼ã«ã¼ã 12:00 - 12:30
Hoppyããã:maaash.jp Hoppyãã ã·ãªã³ã³ãã¬ã¼è¡ã£ãæã«åå ãã Flash Game Summit ã¨ãã§ããFITC Toronto 2009ã§ãããã«ããã¬ã¼ã¤ã¼Flashç±ããã ã£ãã®ã§èªåã®å¨ãã§ã¯ãã¦ãã ã¨ãããã¨ã§ãFlash XMLSocketãµã¼ããHoppyããå¥è·¡çã«ãæ°ã«å ¥ã£ã¦ãããæ¹ãããã£ããã£ãã¿ããã§ããªãã¨ãå¬ããéãã§ãã ä½è ã¨ãã¦ã¯ããã¤ãã®æªãçã§ãä½ãã£ã±ãªãã®æ¾ç½®ãã¬ã¤ç¶æ ã ã£ããã§ããããã£ããã使ã£ã¦ããã¦ãæããæ¼ã£ã¦æ¥ã¾ããã®ã§ãä»ä¸åº¦ãææ ãè¾¼ãã¦ã¿ããã¨æãã¾ãï¼ ã¨ããããã§ãå°ã解説è¨äºã§ãæ¸ãã¦ãããããªæããã§ããããã®åã«mashããã®çåã«ã¡ãã£ã¨åçããã¦ããã ãã¨ãã¾ãã DBã¨ã®é£æº POEã¨ã使ã£ãã·ã³ã°ã«ããã»ã¹ã·ã³ã°ã«ã¹ã¬ããã®ãã¼ã¢ã³ã§ãã¼ã¿ãã¼ã¹æ±ãæã¯ã©ãããã®ããããã ããï¼
Shibuya.pm #11ã§çºè¡¨ãã¾ãã ããã«ã¡ã¯ãæ¬æ¥ã®HOTELæ å½ãç´ æµãªã¬ãã£ã¼ãã¨Yappoã§ãã3人ã®è·ç©ã家æã®ãªã¢ãã£ã«ãããªããå¿é ã ãã©ããå¯ããï¼è©±ã¯å¤ãããã©ãacotieããã¯ã¢ã¯ã¡ã¢ã¯ã¡è¨ã£ã¦ã¦ã©ãã ãã¢ã¯ã¡å¥½ããªãã ãï¼ã¨æã£ãã®ã¯å ç·ã ãï¼ ã¨ãã訳ã§Shibuya.pmã§çºè¡¨ãã¦ãã¾ãããäºæ¬ç«ã¦ã§ãã ä¸æ¬ç®ã¯ãä¸è¬çãªperl userã®ä½æ³ã®BããDevel::Peekã®ç´¹ä»ã«å ãã¦ãæ°ããä½ã£ãDevel::RunOpsAnalizeã使ã£ã¦OPCODEã®å®è¡åä½ã§Perlã®åä½ãè¦ãè¦ãæ¹æ³ã®ç´¹ä»ããã¾ããã äºæ¬ç®ã¯LTã§ãdan the eval botã®ä½ãæ¹ã説æããçºã®CentOSã®ã¤ã³ã¹ãã¼ã«ãããã¨ããã®ãå£å®ã«Hatetterã®ã¢ã¼ããã¯ãã£ãããªããããã®è¦ç´ ãæ¡ç¨ããããç´¹ä»ãã¾ããã ãã¡ããCentOSã®ã¤ã³ã¹ãã¼ã«ã
ååãQ4M(Message Queue for MySQL) ã Debianã«ã¤ã³ã¹ãã¼ã«ã§ããã®ã§ãä»åº¦ã¯å®éã«ãã¥ã¼ã使ç¨ããã¢ããªãæ¸ãã¦ã¿ããã¨æãã¾ãã ã¾ãã¯ãã¥ã¼ã« URL ãå ¥ãã¦ãããåãåºãã ãã®ç°¡åãªããã°ã©ã ãä½ã£ã¦ã¿ã¾ãã使ç¨è¨èªã¯ Rubyããã¥ã¼ã¸ã®ã¢ã¯ã»ã¹ã«ã¯ ActiveRecord ã使ã£ã¦ç°¡åãªã©ã¤ãã©ãªã«ãã¦ã¿ã¾ããã ã¾ãã¯ãã¼ãã«ä½æãåæãã¼ã¿æå ¥ã CREATE DATABASE q4m; USE q4m; CREATE TABLE queue (url text) ENGINE=queue; INSERT INTO queue(url) VALUES('http://www.infosia.co.jp/'); ç¶ãã¦ã¢ããªå´ã require 'rubygems' require_gem 'activerecord' ActiveRec
ãµã¤ãã¦ãºå¥¥ããä½ã® q4m ãè·å ´ã§ææ¡ã jdbc ã§æ¥ç¶ããã®ã¯ã¡ãã£ã¨ã»ã»ã»ã¨ããæè¦ãåºãã®ã§ãä¸åã©ããã¼ãæããã¨ã«ãã¦ãç¡äºè·å ´ã§å°å ¥ããããã ã ã©ããã¼ã¯ apache ã® mod ã§ä½æãããåç´ã«ãã¥ã¼æå ¥ãªã¯ã¨ã¹ããåãåã q4m ã«æå ¥ããã ãã®ç°¡åãªãã®ãã¨ã¯ããå é¨ã§ mod_dbd ã使ç¨ããã³ãã¯ã·ã§ã³ãã¼ãªã³ã°ãè¡ãã(apache ä¸ã§åä½ããã¦ãããã)ãã°åºåçã®å¨è¾ºæ©è½ããã©ã¬ãã«ã«è¿½å ãå¤æ´å¯è½ã ãapache ã使ããããããä½ãè¾¼ãã®ã¯çµæ§å¤§å¤ã ã ããã§ãã¥ã¼ã¸ã®ãã¼ã¿æå ¥ã«é¢ãã¦ã¯åç´ãª http ãªã¯ã¨ã¹ãã§è¡ããã¨ãããã¨ã«ãªãã php ã§ã servlet ã§ã cgi ã§ãç°¡åã«ä½ãããã®æ©è½ããã㦠apache ã® mod ã§ä½æããã®ã¯ãããã©ã¼ãã³ã¹ãä¸çªæå¾ ã§ããã®ã§ã¯ã¨èãã¦ã®ãã¨ãã©ããã¼ãããã«ããã¯ã«ãªã
è¤æ°ã®ãã¥ã¼ã®ä¸ã§ããã¼ã¿ã®ãããã®ãæ¢ãã¦åã£ã¦æ¥ã Q4M ã®ä¾¿å©æ©è½ã mysql> SELECT queue_wait('high_priority_table', 'low_priority_table', 10); ããã®ãã¨ã ã¨ã©ã¼ãã¥ã¼ã¨ãã¦ã¦ãã§ã¯ä½¿ããã¨æã£ã¦ããããããã®åãã«è¥å¹²çããã£ãã®ã§ã¡ã¢ã£ã¨ãã ã¾ãããã®æ¸ãæ¹ãããã¨ãã¯ãã¿ã¤ã ã¢ã¦ãæå®ãå¿ é ã select queue_wait('a', 'b'); ããããæ¸ãæ¹ãããã¨ãa ãã¼ãã«ã®ä¸èº«ããè¦ã¦ãããªãã select queue_wait('a', 'b', 60); ã®ããã«ã¿ã¤ã ã¢ã¦ããå¿ ãæå®ãããï¼ä¸ã®ä¾ã ã¨60ç§ï¼ ã¡ãªã¿ã«ãããã¯ãã¥ã¼ããªã¢ã«ã«ãæ¸ãã¦ããã è¥å¹²ï¼ï¼ã«ãªã£ãã®ãã ãã¥ã¼ããªã¢ã«ã®ä¸çªä¸ã«æ¸ãã¦ãããä¸çªç°¡åãªq4mã®ä½¿ãæ¹ãã®ä¾ SQL mysql> SE
ç¾ç¶ã® queue_wait ã¯ãªã¼ãã¼ã¢ã¼ãã§å¼ã³åºããæã«ãåæã« queue_end ãèµ°ãããã«ãªã£ã¦ãããã¾ããqueue_end ã¯éãªã¼ãã¼ã¢ã¼ãã§ãä½åº¦ã§ãå¼ã¹ãã ããèããããä»æ§ãªã®ã ããç§ãè¥å¹²ç¹æ®ãªä½¿ãæ¹ããããã¨ãã¦ãããã¨ããã£ã¦ãqueue_wait æã«åæã« queue_end ãã¦ããããããªããè¦ããã«ãªã¼ãã¼ã¢ã¼ãæ㯠queue_wait ãã¦ã»ãããªãã¨ãããã¨ã ãã¾ããqueue_end ããªã¼ãã¼ã¢ã¼ãã ãã§å®è¡åºæ¥ã¦ã»ããã â» ã¡ãªã¿ã«ãä»èªåããªã¼ãã¼ã¢ã¼ãã«å± ããã©ããã¯ã select queue_rowid(); ã§ç¢ºèªã§ããããªã¼ãã¼ã¢ã¼ãã§ãªãã¨ããã®SQLã¯ã¨ã©ã¼ã«ãªãã ã§ãqueue_wait, queue_end ã®åä½ãä¸è¨ã®ããã«å¤æ´ããç°¡åãªããããä½æããã対象ãã¼ã¸ã§ã³ã¯ 0.8.4ã 使ãæ¹ã¯ãq4m ã®
ã¯ã¦ãªã®ãæ°ã«å ¥ãã¢ã³ãããTwitter Clientã§è¦ããã²ã¼ãã¦ã§ã¤ãHatetterãä½ãã¾ãã 注æï¼ããã¯ãã¼ã¯ã ãã§ãªãããæ°ã«å ¥ãã¢ã³ããã®ãã£ã¼ãã使ãããã«ãªãã¾ããã ã¯ã¦ãã®ãæ°ã«å ¥ããªã¹ãã£ã¦RSSãªã¼ãã¨ãã§è¦ããããã®ãå¤ããã§ããããã£ã¨Twitterã®ããã«ã«ã¸ã¥ã¢ã«ã«ã¦ãªãããããã¨æã£ã¦ããæ°ã«å ¥ããªã¹ãã®RSSãTwitter APIäºæã®Feedã«å¤æãããµã¼ããæ¸ãã¾ããã Hatter - 太ã£è ¹ã«ã½ã¼ã¹ã³ã¼ããå ¬éãã¦ãã®ã§ãèªå® ãµã¼ãã¨ãã«ç½®ãã¦ä½¿ãã£ã¦ã®ãã§ãã¾ãã ãã¨ãã°id:acotieããæ°ã«å ¥ãã«å ¥ãã¦ã人éã®ããã¯ãã¼ã¯ãTwitter風ã«å¤æãããæ㯠http://hatetter.blogdb.jp/acotie/statuses/friends_timeline.json ããã㯠http://hatetter.b
Q4Måãæ±ãæã Queue::Q4M 使ã£ã¦æ¥½ãããã¨æã£ãã®ã ããQueue::Q4M ã¯ããåä½ã§ä½¿ããªãã¨queue_abortã¨ãå¼ã³ã¾ãããããªå®è£ ã ã£ãã®ã§ãå ¨é¨èªåã§ãã³ããªã³ã°ããã£ãã use Data::Model::Driver::Queue::Q4M; my $driver = Data::Model::Driver::Queue::Q4M->new( dsn => 'dbi:mysql:database=test', username => '', password => '', timeout => 60, # queue_wait timeout ); { package MyQueue; use base 'Data::Model::Extend::Queue::Q4M'; use Data::Model::Schema; base_driver $dr
Q4MãMacPortsã®MySQLç°å¢ã«å ¥ããæ¹æ³ macportsã§mysqlå ¥ãã㨠/opt/local/lib/mysql5/mysql ã¨ãããç¬åµçãªæã«ã©ã¤ãã©ãªãå ¥ãã®ã§ããã®ã¾ãã¾ã®Q4Mã®configureãã./configureããä¸æãåããªãããã°ã°ã£ã¦ãè¯ãããããªãã®ã§ã¦ã£ã¨ãæ©ãconfigure.inãæ¸ãæãããã ãããã¯http://gist.github.com/94339ãã å®è¡ä»¤ã¨ãã¯ä¸è¨ã®éãã $ patch < ../for-macports.patch $ autoconf # include ãã£ã¬ã¯ããªã追å ããã®ãå¿ è¦ $ CPPFLAGS=-I/opt/local/include ./configure --with-mysql=/opt/local/var/macports/sources/rsync.macports.
ããæ¥Q4Mãå©ç¨ããã·ã¹ãã ãéç¨ãã¦ããã¨ãããããã°ã©ãã®æ¹ãã ãQ4Mã®ãã¼ãã«ãå£ããã£ã½ãã®ã ãã©ããããã ã¨ã®å ±åããããç¶æ³ãèãã¦ã¿ãã ã©ãããQueueã«çªã£è¾¼ãã ãã©ãå¦çããããªããã¼ã¿ããã£ãã¨ããçç±ã§ä¸é¨ã®è¡ãDELETEããã¨ã®ãã¨ã ã§ãæ©éDBã調ã¹ã¦ã¿ãã¨ãå ¨é¨queue_waitã§åãåºããã«ãé¢ãããè¡æ°ã0ã«ãªããªãã£ããã çºè¡ãã¦ããqueue_endãå®è¡ãããã«ãã£ã¨ããã»ã¹ãæ®ã£ã¦ããããã¦å¤§å¤ã«ãªã¹ãªç¶æ ã«ãªã£ã¦ããã (insertãæ¢ã¾ã£ã¦ãã) ãã®å ´ã§ã¯MySQLãå¼·å¶çã«åèµ·åãã¦ãtableãschemaãdropãã¦åä½æãã¦ããããã¨ã§ãã¨ãªããå¾ãã ããä»æ¥å¸°ã£ã¦ãã¦Q4Mã®ãã¼ã¸ãè¦ã¦è¬ã解決ã Q4Mã®ãLimitations and Known Issuesãã« removal of multiple
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}