ð£ Announcement: The Future of TypeORM â We're excited to share our vision for a revitalized TypeORM! Read the full announcement
Hi everybody, my name is Felix Geisendörfer and today I'd like to talk about "Faster than C? Parsing Node.js Streams!". Before I get started, I would like to appologize for the "Title Bait". This talk is analyzing the performance of JavaScript vs C-Bindings for MySQL in node.js, but not JavaScript vs. C itself. So, I have this module I wrote that lets you talk to MySQL databases in node.js. I star
JIS X 0213:2004ã§è¿½å ããããå±ãã®ç°ä½åã¯ãUnicodeã«ããã¦ã¯ãUTF-8ã§ç¬¦å·åããã¨4ãã¤ãã«ãªããã³ã¼ããå²ãå½ã¦ããã¦ãããã¾ããä¸å½èªãã¾ã¨ãã«æ±ããã¨æã£ãããUTF-8ã§4ãã¤ããã®æåãæ±ãå¿ è¦ãåºã¦ããã ãããªæåã©ããMySQLãã¼ã¿ãã¼ã¹ã«æ¾ãè¾¼ããã¨ãUTF-8æå®ã§ããã°ã£ã¦ããã®ã ããã²ã¨ã¤ã®çµè«ã«è¡ãçãããããã MySQLã®"UTF-8"ã«ãç¨å¿ - yanok.net ãUTF-8ã§4ãã¤ããã®æåãæ±ããã¨æã£ãããMySQL 5.5.3以éã使ããããã«"utf8mb4"ãæå®ãããã¨ããåè«ã®ãããªæ¬å½ã®è©±ã ã¾ãã°ãã°ãè¨ã£ã¦ãå§ã¾ããªãã®ã§ãã¾ãã¯æå ã«ããç°å¢ã§è©¦ãã¦ã¿ãã¨ããããã äºåæºå ç°å¢ã¨ãã¦ã以ä¸ã®ãã®ã使ç¨ããã OS Windows Vista Business SP2 (x86) PHP v5.3.
Full MySQL Support Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases. Perfect Web Development Companion Whether you are a Mac Web Developer, Programmer or Software Developer your workflow will be streamlined with a native Mac OS X Application! Flexible Connectivity Sequel Pro gives you direct access to your MySQL Databases on local and remote se
å¤ãã®æå·å颿°ããã³å§ç¸®é¢æ°ã§ã¯ãçµæã«ä»»æã®ãã¤ãå¤ãå«ã¾ãã¦ããå¯è½æ§ã®ããæååãè¿ããã¾ãã ãããã®çµæãæ ¼ç´ããå ´åã¯ãVARBINARY ã¾ã㯠BLOB ãã¤ããªæååãã¼ã¿åã®ã«ã©ã ã使ç¨ãã¾ãã ããã«ããããã¤ããªä»¥å¤ã®æååãã¼ã¿å (CHAR, VARCHAR, TEXT) ã使ç¨ãã¦ããå ´åãªã©ããã¼ã¿å¤ã夿´ããå¯è½æ§ãããå¾ç¶ã®é ååé¤ã¾ãã¯æåã»ããå¤æã®æ½å¨çãªåé¡ãåé¿ã§ãã¾ãã ä¸é¨ã®æå·å颿°ã¯ ASCII æåã®æååãè¿ãã¾ã: MD5(), SHA(), SHA1(), SHA2(), STATEMENT_DIGEST(), STATEMENT_DIGEST_TEXT()ã æ»ãå¤ã¯ãcharacter_set_connection ããã³ collation_connection ã·ã¹ãã 夿°ã«ãã£ã¦æ±ºå®ãããæåã»ããã¨ç §åé åºãæã¤æ
ï¼ ITç·¨éé¨ã®ã»ããã¼ã«åºã¦ãã¾ãã 3æ2æ¥ã«ãï¼ ITç·¨éé¨ä¸»å¬ã®ãï¼ IT ã»ãã¥ãªãã£ã½ãªã¥ã¼ã·ã§ã³ Live! in Tokyoãã«ã¦ãNTTãã¼ã¿å 端æè¡ã®è¾»ããã¨ã¤ã³ã¿ã¼ãããã¤ãã·ã¢ãã£ãã®æ ¹å²¸ããã¨ã¨ãã«ãã©ã³ãã»ãã·ã§ã³ã«åºæ¼ãã¦ãã¾ãããè¾»ããï¼æ ¹å²¸ããã®ãã¼ã¯ã«çµ¡ã¾ãã¦ãããããã£ã¨ããéã«ã©ã³ãã»ãã·ã§ã³ã¯æ¥½ããçµäºãã¾ããã äºåã®æºåä¸ã¯ããã ãããããã¨è©±ããã¨æã£ã¦ããã®ã«ãããå§ã¾ãã¨æéãè¶³ããªããããçãä¸ããã¾ãããã¡ãã£ã¨ç©è¶³ããªãã¨æãããããããã®ããããã¾ãããããã®ä¼å ´ã§ä½¿ã£ãã2002å¹´ã¨2012å¹´ä»è¿ã®åºæ¥äºã示ããè³æããã¡ãã§ãã ç§ã¯ã¡ããã©10å¹´åã®2002å¹´ã«ã©ãã¯ã«å ¥ç¤¾ãã¾ãããæ¯ãè¿ã£ã¦ã¿ãã°ãã£ã¨ããéã®10å¹´ã®ç¤¾ä¼äººçæ´»ã§ãããããã¦ã¿ãã¨ãããããªã¤ã³ã·ãã³ãããªã¢ã«ä¸çã¨ãµã¤ãã¼ã®ä¸çã§èµ·ãã£ã¦ãããã ãªã¨æããããª
è³è²¸ä½å® ä½ã¾ããç¬èº«ã®æ¹ãæå¾ãä½é¡ã¨ããç¶æ ã§ãå¹´åã®ï¼åã®ï¼ããå°ãªãéé¡ã叿ãããªãã°ã審æ»ã§OKã¨ãªããã¨ãæå¾ ãããã¨è¨ã£ã¦ããã¨æãã¾ãã é·ã人çã®ä¸ã«ããã¦ã¯ãã©ããªäººã§ãæãããããå¾ ã£ããªãã§ãã£ãã·ã¥ãå ¥ç¨ã«ãªããã¨ãããã§ãããããããã£ãæã«ã¯ã峿¥èè³ã«å¯¾å¿ãã¦ãããã£ãã·ã³ã°ãé常ã«å½¹ã«ç«ã¤ã¨æãã¾ãã ãéè¡ã§ç³è«ããã«ã¼ããã¼ã³ãã¯ãã¾ã信販系ã®è²¸ä»ãµã¼ãã¹ã¨ããã®ã¯ãå®éã®ã¨ãã審æ»ã«æéããããã®ã§ã¯ãªããï¼ï¼½ã¨å¿é ãã¦ããããããã¾ããããããæè¿ã§ã¯å³æ¥èè³ã宿½ãã¦ããéèæ¥è ãæ¬¡ç¬¬ã«å¤ããªã£ã¦ããã¨ã®ãã¨ã§ãã ã©ããªå 容ã®ãã¼ã³ãçµãã¨ãã¾ãã¦ããä¸ãä¸ãã£ãã·ã³ã°ã«ãã£ã¦ãéãåãã¦ããç¶æ³ãªãããã¼ã³å©ç¨ã«ããåå ¥éã¯ç¸®æ¸ããããã¨ã¯èããããã§ãããã çµ¦ææ¥ãæ¥ãã¾ã§ãæ°æ¥éå©ãã¦è²°ããã®ããã£ãã·ã³ã°ã§ã¯ãªãã§ããããï¼ç·æ¥ã®æã
ç¥ããªãã£ãã®ã§ã¡ã¢ã mysql> SELECT @foo := UNIX_TIMESTAMP(), FROM_UNIXTIME(@foo) +--------------------------+---------------------+ | @foo := UNIX_TIMESTAMP() | FROM_UNIXTIME(@foo) | +--------------------------+---------------------+ | 1331202141 | 2012-03-08 19:22:21 | +--------------------------+---------------------+ @variable := expr ã§å¤æ°ã«ä»£å ¥ããããããã®å ´ã§ä½¿ããã¨ãã§ããããã¾ã¾ã§ã¯ SET @variable = expr ãã¦ãããã使ããªãã®ããªã¼ã¨æã£ã¦
http://mysql-casual.org/2011/11/mysql-casual-advent-calendar-2011.html ã®6æ¥ç®ã®è¨äºã¨ãã¦æ¸ããã¦ããã ãã¾ããsugyanã§ãã å¢ãã§åå 表æãã¦ãã¾ãã仿¥æ ã¦ã¦ä¹ ãã¶ãã«MySQLã触ãã¾ããã MySQLã§FizzBuzz ã¹ãã¢ãããã·ã¼ã¸ã£ã£ã¦ä½¿ã£ããã¨ç¡ãã£ãã®ã§åãã¦è§¦ã£ã¦ã¿ã¾ããã DROP PROCEDURE IF EXISTS FizzBuzz; delimiter // CREATE PROCEDURE FizzBuzz(n INT) BEGIN DECLARE i INT DEFAULT 1; WHILE i <= n DO SELECT CASE WHEN i % 3 = 0 AND i % 5 = 0 THEN 'FizzBuzz' WHEN i % 5 = 0 THEN 'Buzz'
MySQL ã®ãã¼ãã«ãç ´æããå ´åãæ¬¡ã®ã³ãã³ãã§ç¢ºèªãããã¨ãåºæ¥ã¾ãã $ myisamchk /ãã¼ã¿ãã¼ã¹ã®ãã¹/*.MYI ä¾ãã°ã¨ã©ã¼ãããå ´åãæ¬¡ã®ããã«è¡¨ç¤ºããã¾ãã myisamchk: error: Checksum for key: 1 doesn't match checksum for records æéã¯ãããã¾ããããã詳細ã«ãã§ãã¯ãã¦ããã -e ãªãã·ã§ã³ãããã¾ãã $ myisamchk -e /ãã¼ã¿ãã¼ã¹ã®ãã¹/*.MYI 修復 ã¨ã©ã¼ãçºè¦ãããå ´åãæ¬¡ã®ã³ãã³ãã§ä¿®å¾©ãã¾ãã $ myisamchk -r -q /ãã¼ã¿ãã¼ã¹ã®ãã¹/ãã¼ãã«å -pãªãã·ã§ã³ãæå®ãããã¨ã§ãã¼ã¿ãã¡ã¤ã«ã«ã¯è§¦ããªãã§ã¤ã³ããã¯ã¹ãã¡ã¤ã« ã®ä¿®å¾©ã試ã¿ã¾ãã ä¸è¨ä¾ã§ä¿®å¾©ã§ããªãå ´åã-rãªãã·ã§ã³ã®ã¿ã§ä¿®å¾©ã試ã¿ã¾ãã念ã®ãã修復 ã®åã«ãã¼ã¿ãã¡ã¤ã«
â»ãã¿ã§ã â»UDFã§ã Mysql 5.1 Plugin Development ä½è : Andrew Hutchings,Sergei Golubchikåºç社/ã¡ã¼ã«ã¼: Packt Publishingçºå£²æ¥: 2010/08/30ã¡ãã£ã¢: ãã¼ãã¼ããã¯è³¼å ¥: 1人 ã¯ãªãã¯: 45åãã®ååãå«ãããã° (2ä»¶) ãè¦ã ãã°ããç©ãèªãã¦ãããã®æ¬ãã¡ãã£ã¨çºãã¦ã¿ãããMySQLã®UDFã£ã¦ç°¡åã«ä½ãããã ãªã¼ãã¨æã£ã && ããããV8ã£ã¦ã©ã¤ãã©ãªã¨ãã¦ç°¡åã«ãªã³ã¯ã§ããã¯ãã ãªãã¨æãåºãã ã®ã§ãã¤ãã«ãã¨ãªã£ã¦ä½ã£ãã http://github.com/zentooo/mysqludf-jseval UDFããã¬ï½ ã»ã¨ãã©âã®æ¬ã®åã売ãã«ãªããã©ãä¸å¿MySQLã®UDFã«ã¤ãã¦åå¿é²ä»£ããã«è»½ãç´¹ä»ãã¦ãã㨠UDFã追å ããå ´åãMySQLã®åã³ã³ãã¤
ã¦ãã¨ã§ãã°ããOpenIDã§ãã°ã¤ã³ãè¾ãã®ã§ã¨ã¦ãããåããªãããã°ãªã¢ã³ã§ããã£ã¨ãã°ã¤ã³åºæ¥ãããã«ãã¦ã¿ãã // ==UserScript== // @name logpi_openid // @namespace tikilabo // @include http://logpi.jp/ // ==/UserScript== (function(){ var frm = document.getElementsByTagName("form")[0]; var openid = document.createElement("input"); openid.type = "hidden"; openid.name = "openid"; //èªåã®OpenIDãè¨å® openid.value = ""; frm.appendChild(openid); frm.action
ãµã¼ãã¼ã®ãã¤ããªãã°ã¯ããã¼ã¿ãã¼ã¹ã®å 容ã«å¯¾ãã夿´ãè¨è¿°ãããã¤ãã³ãããå«ããã¡ã¤ã«ã§æ§æããã¾ãã ãµã¼ãã¼ã¯ãããã®ãã¡ã¤ã«ããã¤ããªå½¢å¼ã§æ¸ãåºãã¾ãã å 容ãããã¹ãå½¢å¼ã§è¡¨ç¤ºããã«ã¯ãmysqlbinlog ã¦ã¼ãã£ãªãã£ã¼ã使ç¨ãã¾ãã ã¾ããmysqlbinlog ã使ç¨ãã¦ãè¤è£½è¨å®ã§è¤è£½ãµã¼ãã¼ã«ãã£ã¦æ¸ãè¾¼ã¾ãããªã¬ã¼ãã°ãã¡ã¤ã«ã®å 容ã表示ãããã¨ãã§ãã¾ããããã¯ããªã¬ã¼ãã°ã®å½¢å¼ããã¤ããªãã°ã¨åãã§ããããã§ãã ãã¤ããªãã°ããã³ãªã¬ã¼ãã°ã¯ãã»ã¯ã·ã§ã³5.4.4ããã¤ããªãã°ãããã³ã»ã¯ã·ã§ã³17.2.4ããªã¬ã¼ãã°ããã³ã¬ããªã±ã¼ã·ã§ã³ã¡ã¿ãã¼ã¿ãªãã¸ããªãã§ããã«èª¬æãã¾ãã mysqlbinlog ã¯æ¬¡ã®ããã«èµ·åãã¾ãã shell> mysqlbinlog [options] log_file ... ãã¨ãã° binlog.000003
SAVEPOINTãROLLBACK TO SAVEPOINT ããã³ RELEASE SAVEPOINT ã¹ãã¼ãã¡ã³ã
åãã¾ãã¦ã2010å¹´ã®3æã«å ¥ç¤¾ãã oinume ã§ããæ°å¹´1æããã¦ã£ã«ã¹æ§èè ¸çã«ç½¹ããªããããªãã¨ããã®ã¨ã³ããªã¼ãæ¸ãã¦ãã¾ããä»åã¯ãmysqlã³ãã³ãã«é¢ããèªåãä»ã¾ã§å¦ãã ï¼æãã¦ããã£ãç´°ããå®è·µçãªTIPSãç´¹ä»ãã¾ããå°ç²ã§ããä½ãã®å½¹ã«ç«ã¦ã°å¹¸ãã§ãã edit (Â¥e)ã³ãã³ã mysqlããã³ããã«ããªããä»»æã®ã¨ãã£ã¿ã§SQLãç·¨éã§ãã¡ããã¾ããå ·ä½çã«ã¯ãmysqlã³ãã³ãã§ããã³ããå¾ ã¡ã®ç¶æ ã§ mysql> edit ã®ããã« edit ã¾ã㯠¥e ã¨å ¥åããã¨ãç°å¢å¤æ°EDITORã§è¨å®ãã¦ããã¨ãã£ã¿ãç«ã¡ä¸ããSQLãç·¨éå¯è½ã«ãªãã¾ããç·¨éãçµãã£ããã¨ãã£ã¿ãçµäºã㦠; ã¨ããã°SQLãå®è¡ããã¾ããviãªã©ã¿ã¼ããã«ã§åãã¨ãã£ã¿ã«æ £ãã¦ãã人ã¯é·ãSQLãç·¨éããæã«éå®ããæ©è½ã§ãããããã®æã¯åè·ã®ååã«æãã¦ããã£ã¦ã以é便
åå¿è ã«ã¨ã£ã¦ã使ããããã¹ã¿ã¼ãã¢ãããªãã·ã§ã³ã¯--safe-updates (ãããã¯åã广ã®ãã--i-am-a-dummy)ã§ããããã¯DELETE FROM tbl_nameã¹ãã¼ãã¡ã³ããçºè¡ããããWHEREç¯ãå¿ãã¦ãã¾ã£ãå ´åã«ä¾¿å©ã§ããé常ããã®ãããªã¹ãã¼ãã¡ã³ãã¯ãã¼ãã«ããå ¨ã¦ã®è¡ãæ¶å»ãã¾ãã--safe-updatesã§ã¯ãè¡ã表ããã¼å¤ãã¨ãã¦ããããã¨ã§é£²ã¿ãè¡ãæ¶å»ãããã¨ãã§ãã¾ããããã«ãããééããäºæ ãäºé²ãã¾ãã --safe-updatesãªãã·ã§ã³ã使ç¨ããã¨ããmysqlã¯MySQLãµã¼ãã«æ¥ç¶ããé以ä¸ã®ã¹ãã¼ãã¡ã³ãã çºè¡ãã¾ãã SET SQL_SAFE_UPDATES=1,SQL_SELECT_LIMIT=1000, SQL_MAX_JOIN_SIZE=1000000; 詳ããã¯ãã¡ãããåç §ãã¦ãã ããé 12.5.3. ã
ã¯ããã¾ãã¦ãæ¨å£ã¨ç³ãã¾ãã å æ¥ã®DeNA Technology Seminar #2ã§ã話ããã¦ããã ãã¾ãã HandlerSocket Plugin for MySQL ã®ã½ã¼ã¹ã³ã¼ããå ¬éãã¾ããã HandlerSocketã¨ã¯ï¼ ç°¡åã«è¨ãã¨ãMySQLãã¼ã¿ãã¼ã¹ã¸ã®ã¢ã¯ã»ã¹ãé«éåããããã®ãã©ã°ã¤ã³ã§ããMySQLã®SQLãã¼ã¶ããã£é£ã°ãããããã¯ã¼ã¯éä¿¡ã¨ãã«ãã¹ã¬ããå¦çå¨è¾ºãç½®ãæãããã¨ã«ãã£ã¦ãInnoDBçã®ãã¼ã¿ãã¼ã¹ã¨ã³ã¸ã³ã®æ§è½ãéçã¾ã§å¼ãåºãã¾ãã ãã®HandlerSocketã§ããããã§ã«ã¢ãã²ã¼ã¿ã¦ã³ã«ã¦å®éã«éç¨ãã¦ãã¾ãã徿¥MySQLã¨memcachedã®æ§æã§éç¨ãã¦ããç®æããHanderSocketãçµã¿è¾¼ãã MySQLã ãã®æ§æã«ç½®ãæãã¾ããããã®çµæãMySQLãµã¼ãã®è² è·è»½æ¸ãmemcachedã®è² è·è»½æ¸ããããã¯ã¼ã¯
ã¡ã³ããã³ã¹
ã©ã³ãã³ã°
ãç¥ãã
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}