[B! MySQL] shokaiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

shokai id:shokai

MySQLã«é–¢ã™ã‚‹shokaiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (43)

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

ãƒ«ãƒ¼ã‚¯ï¼MySQLã§ã¯kamipo TRADITIONALã‚’ä½¿ãˆï¼ | ãŠãã‚‰ãã¯ãã‚Œã•ãˆã‚‚å¹³å‡¡ãªæ—¥ã€…
ã‚ˆãMySQLã¯ã‚†ã‚‹ãµã‚ã ã‹ã‚‰ å€¤ãŒå‹æ‰‹ã«åˆ‡ã‚Šè©°ã‚ã‚‰ã‚Œã‚‹ ã‚¨ãƒ©ãƒ¼ãŒèµ·ããšã«å¤‰ãªå€¤/æ—¥ä»˜ãŒå…¥ã‚‹ ä¸æ£ãªã‚¹ã‚ãƒ¼ãƒžãŒå…¥ã£ã¦ã—ã¾ã† ãªã©è¨€ã‚ã‚Œã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ãŸã ãã‚Œã¯ã€ãã‚‚ãã‚‚ã®è¨å®šãŒæ‚ªã„ã®ã§ã™ã€‚(ç¢ºã‹ã«æ˜”ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆãŒã‚†ã‚‹ãµã‚ãªã®ã¯ã„ã‘ãªã‹ã£ãŸã‚“ã§ã™ãŒ) ã¨ã„ã†ã“ã¨ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¯ä¸æ£ãªå€¤ãŒå…¥ã‚‰ãªã„ã‚ˆã†ã«è¨å®šã¯ã¨ã«ã‹ãåŽ³ã—ãã—ã¦ãŠãã®ãŒã‚ªã‚¹ã‚¹ãƒ¡ã§ã™ã€‚ ã˜ã‚ƒã‚ã©ã†ã™ã‚‹ã‹ã€‚ MySQLã¯SQL Modeã«ã‚ˆã£ã¦ã€ãã®è¾ºã‚Šã®åˆ¶ç´„ã‚’ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ä»¥å‰ã€MySQLã®sql-modeã§ä¸€ç•ªåŽ³ã—ã„ã‚„ã¤ã¯TRADITIONALã€ã¨ã„ã†ã®ã‚’æ›¸ã„ãŸã®ã§ã™ãŒã€å®Ÿã¯ãã‚Œã ã‘ã§ã¯ä¸ååˆ†ã§ã€TRADITIONAL,NO_AUTO_VALUE_ON_ZERO,ONLY_FULL_GROUP_BYã¨ã™ã‚‹ã®ãŒã‚ˆã‚Šå®‰å¿ƒãªã‚ˆã†ã§ã™ã€‚ ã“ã‚Œã¯kamipoã•ã‚“ã«æ•™ãˆã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚ @songmu TRADITI
shokai 2015/07/08
MySQL
ãƒªãƒ³ã‚¯
MySQL Indexå‹‰å¼·ä¼šå¤–éƒ¨å…¬é–‹ç”¨
12. Â© CROOZ,Inc. 12 ï¼‘ï¼ŽINDEXã¨ã¯ãªã«ã‹ ä½•æžšç›®ãŒãªã«ã‹ã‚’äº‹å‰ã«ãƒ¡ãƒ¢ã£ã¦ãŠã‘ã°è‰¯ã„ï¼ ã‚¹ãƒ¼ãƒˆ ãƒ©ãƒ³ã‚¯ ä½ç½® ãƒãƒ¼ãƒˆ Q 1 ã‚¹ãƒšãƒ¼ãƒ‰ 9 2 : : : ãƒ€ã‚¤ãƒ¤ 1 40 : : : ã‚¹ãƒšãƒ¼ãƒ‰ 6 45 ãªãœãªã‚‰ã€è¦æ±‚ã¯ã€Œã‚«ãƒ¼ãƒ‰ã‚’å¼•ãå›žæ•°ã‚’æœ€ã‚‚å°‘ãªã ã—ã¦ã‚¹ãƒšãƒ¼ãƒ‰6ã‚’æŽ¢ã™ã“ã¨ã€ ã‚»ã‚³ã„ã¨ã‹ãŠã‚‚ã†ãƒ’ãƒˆã¯ã„ã‚‹ã‹ ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒä½•ã‚‚ã‚»ã‚³ã„ã“ ã¯ã—ã¦ã„ãªã„ã§ã™ã€‚ å‰ææ¡ä»¶ãªã©ä¸€åˆ‡ãªã„ã‹ã‚‰ ã“ã®ãƒ¡ãƒ¢ã•ãˆã‚ã‚Œã°ä½ç½®ã‚’æŒ‡å®šã—ã¦1å›žå¼•ã‘ã°æ¸ˆã‚€
shokai 2013/09/16
MySQL
ãƒªãƒ³ã‚¯
MySQLã®è¨å®šãƒ•ã‚¡ã‚¤ãƒ« my.cnf ã‚’githubã«ã¦å…¬é–‹ã—ã¾ã—ãŸ & ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒã‚¤ãƒ³ãƒˆã®ç´¹ä»‹ - blog.nomadscafe.jp
YAPC::Asiaã®ã‚¹ãƒ©ã‚¤ãƒ‰ã§äºˆå‘Šã—ã¦ã„ãŸé€šã‚Šã€å®Ÿéš›ã«å¼Šç¤¾ã®ã„ãã¤ã‹ã®ã‚µãƒ¼ãƒ“ã‚¹ã§ä½¿ã£ã¦ã„ã‚‹ my.cnf ã‚’å…¬é–‹ã—ã¾ã—ãŸã€‚ github: https://github.com/kazeburo/mysetup/tree/master/mysql ä»Šå›žã€å…¬é–‹ã—ãŸç†ç”±ã¯MySQl Beginners Talksã®ç™ºè¡¨ã®ä¸ã§ã‚‚è§¦ã‚Œã¦ã„ã‚‹é€šã‚Šã§ã™ã€‚MySQLã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ä¸ã«å«ã¾ã‚Œã‚‹ã‚µãƒ³ãƒ—ãƒ«ã®my.cnfãŒæœ€è¿‘ã®ã‚µãƒ¼ãƒãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã‚„é‹ç”¨ã«åˆã‚ãªããªã£ã¦æ¥ã¦ã„ã‚‹ã¨ã„ã†çŠ¶æ³ã§ã€è‡ªåˆ†ã®è¨å®šã«ã‚¤ãƒžã‚¤ãƒè‡ªä¿¡ãŒæŒã¦ã¦ã„ãªã„äººã¯å°‘ãªããªã„ã¯ãšã€‚ãã“ã§å„ç¤¾ç§˜ä¼ã®ã‚¿ãƒ¬çš„ãª my.cnf ã‚’Open & Shareã™ã‚‹ã“ã¨ã§ã€ãƒ¢ãƒ€ãƒ³ãªmy.cnfã‚’ä½œã‚Šä¸Šã’ã‚‹äº‹ãŒã§ãã‚‹ã‚“ã˜ã‚ƒãªã„ã‹ã¨ã„ã†è€ƒãˆã®ä¸‹ã€ä»Šå›ž github ã«ã¦å…¬é–‹ã—ã¾ã—ãŸã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ã¯4ã¤ã‚ã‚Šã€ãã‚Œãžã‚Œ MySQL 4.0ã€5.1ã€5.5ã€ãã—ã¦ãƒ†ã‚¹ãƒˆä¸
shokai 2012/10/06
MySQL
ãƒªãƒ³ã‚¯
Rails ã§ã€Controller ã«å®šç¾©ã•ã‚Œã¦ã„ã‚‹ action ã‚’ä¸€åº¦ã«å–å¾—ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ - QA@IT
å¹³ç´ ã‚ˆã‚ŠQAï¼ ITã‚’ã”åˆ©ç”¨ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ QAï¼ ITã¯ã€Œè³ªå•ã‚„å›žç”ã‚’ã€Žå…±æœ‰ã€ã—ã€Žç·¨é›†ã€ã—ã¦ã„ãã“ã¨ã§ãƒ™ã‚¹ãƒˆãªQAã‚’è“„ç©ã§ãã‚‹ã€IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å•é¡Œè§£æ±ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶šã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€QAï¼ ITã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªè³ªå•ã‚„å›žç”ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”æ”¯æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æƒ…å ±å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„QAã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’æ¤œè¨Žã—ãŸçµæžœã€2020å¹´2æœˆ28æ—¥ï¼ˆé‡‘ï¼‰15:00ã‚’ã‚‚ã¡ã¾ã—ã¦QAï¼ ITã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰ã›ã¨ãªã‚Šã€èª ã«å¿ƒè‹¦ã—ãæ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ä½•ã¨ãžã€ã”ç†è§£ã‚’ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ QAï¼ ITã®7å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
shokai 2012/09/13
PostgreSQL

MySQL
ãƒªãƒ³ã‚¯
http://www.2ch-search.net/blog/3
shokai 2012/06/27
MySQL
ãƒªãƒ³ã‚¯
Q4M - a Message Queue for MySQL
Q4M (Queue for MySQL) is a message queue licensed under GPL that works as a pluggable storage engine of MySQL, designed to be robust, fast, flexible. It is already in production quality, and is used by several web services (see Users of Q4M). To start using Q4M, download either a binary or source distribution from the install page, and follow the installation instructions. A small tutorial is also
shokai 2009/08/31
Q4M

MySQL
ãƒªãƒ³ã‚¯
ã“ã“ã‚®ã‚³ï¼: mysqlã®ç©ºé–“æ‹¡å¼µå¯¾å¿œãŒé€²ã‚“ã§ã„ã‚‹ã‚ˆï¼ï¼ˆC/Wï¼šPostgresä½¿ã†ãªã‚‰PostGISä½¿ãŠã†ã‚ˆï¼‰
2009å¹´07æœˆ08æ—¥ mysqlã®ç©ºé–“æ‹¡å¼µå¯¾å¿œãŒé€²ã‚“ã§ã„ã‚‹ã‚ˆï¼ï¼ˆC/Wï¼šPostgresä½¿ã†ãªã‚‰PostGISä½¿ãŠã†ã‚ˆï¼‰ åŒåƒšãŒè¦‹ã¤ã‘ã¦ãã‚ŒãŸãƒã‚¿ã€ãƒ‘ã‚¯ã‚‹æ„Ÿã˜ã§ç”³ã—è¨³ãªã„ã®ã§ã™ãŒ...ã€‚ mysqlã®ç©ºé–“æ‹¡å¼µã¨è¨€ãˆã°ã€ç©ºé–“ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§MBRï¼ˆæœ€å°å¤–æŽ¥çŸ©å½¢ï¼‰ãƒ™ãƒ¼ã‚¹ã®çµžè¾¼ã¿ãŒã§ãã‚‹ãã‚‰ã„ã§ã€å¾Œã¯æ²–é›»æ°—ã•ã‚“ãŒãƒ¦ãƒ¼ã‚¶é–¢æ•°ã§distance_sphereé–‹ç™ºã•ã‚ŒãŸã‚Šã¨ã‹ã€ãã†ã„ã†æ„Ÿã˜ã ã£ãŸã‚“ã§ã™ã‘ã‚Œã©ã‚‚ã€è£ã§ã¯ã¾ã ãƒ™ãƒ¼ã‚¿ç‰ˆãªãŒã‚‰ã€å¤§åˆ†ã„ã‚ã‚“ãªæ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚Œã¦ã‚‹ã¿ãŸã„ã§ã™ãã€‚ Categories: MySQLDevelopment | Software Preview | GIS Functions BUFFER(g1 geometry, d numeric) returns a Geometry defined by buffering a distance d around g1 where
shokai 2009/07/08
MySQL

gis
ãƒªãƒ³ã‚¯
Ruby on Rails + MySQL ã§å…¨æ–‡æ¤œç´¢ - ãƒ‰ãƒ¯ãƒ³ã‚´ ç ”ç©¶é–‹ç™ºãƒ–ãƒã‚°
ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯ Ruby on Rails ã¨ MySQL ã‚’ä½¿ã£ã¦æ—¥æœ¬èªžã®å…¨æ–‡æ¤œç´¢ã‚’è¡Œã†æ–¹æ³•ã‚’è¨˜è¿°ã™ã‚‹ã€‚Ruby on Rails ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 2.0.2ã€MySQL ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 5.0.67ã€Tritonn ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 1.0.12ã€Hyper Estraier ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 1.4.10 ã‚’ä½¿ç”¨ã—ãŸã€‚ã‚µãƒ³ãƒ—ãƒ«ã®æ–‡ç« ãƒ‡ãƒ¼ã‚¿ã¨ã—ã¦ã€ã‚ã‚‰ã‚†ã‚‹æ—¥æœ¬äººã«ã¨ã£ã¦æ¥µã‚ã¦èº«è¿‘ãªè‘—ä½œæ¨©åˆ‡ã‚Œæ–‡ç« ã§ã‚ã‚‹ã€Žãƒ‰ã‚°ãƒ©ãƒ»ãƒžã‚°ãƒ©ã€ã¨ã€Žé»’æ»é¤¨æ®ºäººäº‹ä»¶ã€ã‚’åˆ©ç”¨ã—ãŸã€‚å‡¦ç†ã®ãŸã‚ã«æ•´å½¢ã—ãŸãƒ‡ãƒ¼ã‚¿ã¯æœ¬ã‚¨ãƒ³ãƒˆãƒªã«æ·»ä»˜ã—ã¦ãŠãã€‚ã¾ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã‚³ãƒ¼ãƒ‰ã§ã¯ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’é™¤ãã§ãã‚‹ã ã‘ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’å–ã‚‹ã‚ˆã†ã«ã—ã€ãã®çµæžœã¯æœ¬ã‚¨ãƒ³ãƒˆãƒªã®æœ€å¾Œã«è¨˜è¼‰ã™ã‚‹ã€‚ ãƒšãƒ¼ã‚¸ãƒãƒ¼ã‚·ãƒ§ãƒ³ Rails ã§ãƒšãƒ¼ã‚¸ãƒãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®Ÿç¾ã™ã‚‹ will_paginate ã¨ã„ã† plugin ã¯ ActiveRecord ã«æ¨™æº–ã§ã¤
shokai 2009/02/03
Rails

MySQL

HyperEstraier

Tritonn

å…¨æ–‡æ¤œç´¢
ãƒªãƒ³ã‚¯
monoã‹ã‚‰MySQLã«æŽ¥ç¶šã§ããŸã‚ˆï¼ - ã¯ã‹ã¾ã™ãŸã„ã‚‹ï¼ãã‚‡ã‚ã®æŠ€çš„é›‘è¨˜
å‰å›žã®ã‚¨ãƒ³ãƒˆãƒªã§æ›¸ã„ãŸã€Œmonoã‹ã‚‰MySQLã¸ã®æŽ¥ç¶šã€ã«é–¢ã—ã¦ã®ç¶šå ±ã§ã™ãŒã€ æ‰‹å…ƒã®ç’°å¢ƒ(FreeBSD7.0+mono1.2.5)ã§MySQLã«æŽ¥ç¶šã—ã¦ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿å‡ºã™ã“ã¨ãŒã§ãã¾ã—ãŸï¼ï¼ ã‚„ã£ãŸãï¼ï¼ˆâ‰§â–½â‰¦ï¼‰ ã‚„ã¯ã‚ŠMySQL Connector/Netã®ã‚½ãƒ¼ã‚¹ãŒé–“é•ã£ã¦ã„ãŸã¿ãŸã„ã§ã™ã€‚ ã€Monoã§ä»–ã®DBã‚‚ä½¿ã£ã¦ã¿ãŸã‚ˆï¼ï¼ˆPostgreSQLã€MySQLç·¨ï¼‰ ã€‘ http://codezine.jp/article/detail/2913?p=4 ã“ã¡ã‚‰ã®è¨˜è¿°ã‚’å…ƒã«ä¿®æ£ã—ã¦ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã—ãŸã¨ã“ã‚ã€å•é¡Œãªãå‹•ãã¾ã—ãŸã€‚ ä»Šå›žä¿®æ£ã—ã¦ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã—ãŸmonoä¸Šã§ã®å‹•ä½œç¢ºèªæ¸ˆã¿ãƒ‡ãƒ¼ã‚¿ãƒ‰ãƒ©ã‚¤ãƒã®ãƒã‚¤ãƒŠãƒªã‚’é…å¸ƒã—ã¾ã™ã®ã§ã€èˆˆå‘³ã®ã‚ã‚‹æ–¹ã¯ã”åˆ©ç”¨ãã ã•ã„ã€‚ å‹•ä½œã¯ç„¡ä¿è¨¼ã§ã™ã€‚å•é¡ŒãŒã‚ã£ãŸå ´åˆã¯é…å¸ƒã‚’ä¸æ¢ã—ã¾ã™ã®ã§ã‚ã—ã‹ã‚‰ãšã€‚ MySQL Connector/NET ãƒ‡ãƒ¼ã‚¿ãƒ‰ãƒ©ã‚¤ãƒä¿®æ£ç‰ˆ(116KB
shokai 2009/01/11
Mono

MySQL

kyoro
ãƒªãƒ³ã‚¯
Monoã§ä»–ã®DBã‚‚ä½¿ã£ã¦ã¿ãŸã‚ˆï¼ï¼ˆPostgreSQLã€MySQLç·¨ï¼‰
1.ã¯ã˜ã‚ã« å‰å›žã€ãƒžãƒ«ãƒãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ï¼ˆLinux,Mac,Windowsï¼‰å¯¾å¿œã®.NET Frameworkäº’æ›ç’°å¢ƒã€ŒMonoã€ã¨SQLiteã‚’ä½¿ç”¨ã—ãŸåŸºæœ¬çš„ãªDBã‚¢ã‚¯ã‚»ã‚¹ã«ã¤ã„ã¦è§£èª¬ã‚’è¡Œã„ã¾ã—ãŸã€‚Monoã§ã¯SQLiteä»¥å¤–ã«ã‚‚ä¸»è¦ãªDBMSç”¨ãƒ‡ãƒ¼ã‚¿ãƒ—ãƒãƒã‚¤ãƒ€ãŒä½¿ç”¨ã§ãã€ä»Šå›žã€å‰ç·¨ã¨ã—ã¦Monoã¨PostgreSQLã€MySQLã‚’ä½¿ç”¨ã—ãŸDBã‚¢ã‚¯ã‚»ã‚¹ã€å¾Œç·¨ã¨ã—ã¦Monoã¨SQL Serverã€Oracleã‚’ä½¿ç”¨ã—ãŸDBã‚¢ã‚¯ã‚»ã‚¹ã«ã¤ã„ã¦è§£èª¬ã‚’è¡Œã„ã¾ã™ã€‚ å‰å›žã®å†…å®¹ã«ã¤ã„ã¦ã¯ä»¥ä¸‹ã‚’å‚ç…§ã—ã¦ä¸‹ã•ã„ã€‚ Monoã§SQLiteã‚’ä½¿ã£ã¦ã¿ãŸã‚ˆï¼ï¼ˆDBã‚¢ã‚¯ã‚»ã‚¹ï¼ã‚³ãƒžãƒ³ãƒ‰ç·¨ï¼‰ Monoã§SQLiteã‚’ä½¿ã£ã¦ã¿ãŸã‚ˆï¼ï¼ˆDBã‚¢ã‚¯ã‚»ã‚¹ï¼ãƒ‡ãƒ¼ã‚¿ã‚¢ãƒ€ãƒ—ã‚¿ç·¨ï¼‰ 2.å¯¾è±¡èªè€… Monoã‚’è©¦ã—ã¦ã¿ãŸã„äºº PostgreSQLã€MySQLã€SQL Serverã€Oracleã‚‚è©¦ã—ã¦ã¿ãŸã„äºº ADO.NETåˆå¦è€… 3
shokai 2009/01/08
Mono

PostgreSQL

MySQL

C#
ãƒªãƒ³ã‚¯
monoã‹ã‚‰ã®MySQLæŽ¥ç¶šã«å¸Œæœ›ã®å…‰ï¼ - ã¯ã‹ã¾ã™ãŸã„ã‚‹ï¼ãã‚‡ã‚ã®æŠ€çš„é›‘è¨˜
ãƒãƒƒãƒˆä¸Šã®è³‡æ–™ã‚„MySQLã®ã‚ªãƒ•ã‚£ã‚·ãƒ£ãƒ«ã‚µã‚¤ãƒˆã«ã¯ã€Œç°¡å˜ã«ã§ãã‚‹ãœã€çš„ãªäº‹ãŒæ›¸ã„ã¦ã‚ã‚‹ã®ã ãŒã€ä½•åº¦ã‚„ã£ã¦ã‚‚ã©ã†ã‚„ã£ã¦ã‚‚monoä¸Šã§ã¯MySQL Connector/NetãŒä¸Šæ‰‹ãå‹•ã‹ãªã‹ã£ãŸã€‚ ã©ã†ã‚„ã£ã¦ã‚‚æœ€å¾Œã®æœ€å¾Œã§ä¾‹å¤–ã‚’åã„ã¦æ»ã¬ã€‚ ã‹ã‚Œã“ã‚Œï¼‘å¹´ãã‚‰ã„ãµã¨æ€ã£ãŸã¨ãã«æŒ‘æˆ¦ã—ã¦ã„ãŸã®ã ãŒã€ãªã‹ãªã‹ä¸Šæ‰‹ãã„ã‹ãªã„ã€‚ ã€Œã¾ãmonoã ã—ãªã€œã€ã¨åŠã°è«¦ã‚ã¦ã„ãŸã®ã ãŒã€æœ¬æ—¥ã“ã‚“ãªè¨˜äº‹ã‚’ç™ºè¦‹ã€‚ ã€Monoã§ä»–ã®DBã‚‚ä½¿ã£ã¦ã¿ãŸã‚ˆï¼ï¼ˆPostgreSQLã€MySQLç·¨ï¼‰ ã€‘ http://codezine.jp/article/detail/2913?p=4 å½“åˆã€ã€ŒConnector/Net 5.2.3ã€ã®ã€ŒWindows Binaries, no installer ï¼ˆZIPï¼‰ã€ç‰ˆã‚’ä½¿ç”¨ã—ã€æŽ¥ç¶šç¢ºèªã‚’è¡Œã£ãŸã¨ã“ã‚ Unhandled Exception: System.ArgumentExcep
shokai 2009/01/08
Mono

MySQL
ãƒªãƒ³ã‚¯
Capistranoã§migrationsã™ã‚‹å‰ã«è‡ªå‹•ã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—
Photo by mondopiccolo Capistranoã§ã¯deployã—ã¦ã‚‚ã€å‰ã®ã‚½ãƒ¼ã‚¹ãŒæ®‹ã£ã¦ã„ã‚‹ãŸã‚ã«ã€ã™ãã«å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«æˆ»ã›ã¾ã™ãŒã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ãã†ã¯ã„ãã¾ã›ã‚“ã€‚ ãã“ã§ã€deploy:migrationsã‚’å®Ÿè¡Œã™ã‚‹å‰ã«è‡ªå‹•ã§DBã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã‚‹ã‚ˆã†ãªã‚¿ã‚¹ã‚¯ã‚’æŽ¢ã—ã¦ã¿ã¾ã—ãŸã€‚ MySQLå°‚ç”¨ã§ã™ãŒã€ã“ã‚Œã§ãƒãƒ¼ã‚«ãƒ«ã®backupsã¨ã„ã†ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ã€migrationå®Ÿè¡Œå‰ã®ãƒ€ãƒ³ãƒ—ãŒãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã•ã‚Œã¾ã™ã€‚ require 'yaml' desc "Backup the remote production database" task :backup, :roles => :db, :only => { :primary => true } do filename = "#{application}.dump.#{Time.now.to_i}.sql.bz2" fi
shokai 2008/10/31
Rails

Capistrano

MySQL
ãƒªãƒ³ã‚¯
Adminer - Database management in a single PHP file
Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch, Mongo DB and others via plugin. Features, Requirements, Skins, References Why is Adminer better than phpMyAdmin? Replace phpMy
shokai 2008/07/27
MySQL
ãƒªãƒ³ã‚¯
MacPortsã‚’ä½¿ã£ã¦Macã«MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - æ‹¡å¼µç¾å®Ÿãƒ©ã‚¤ãƒ•
ç§ã€é¤¡åã®ãŸã‚ãªã‚‰é€†ç«‹ã¡ã ã£ã¦ã—ã¾ã™ã‚ˆã€‚ ã“ã˜ã‚‰ã›ã¦ã„ã‚‹ã€‚ é£Ÿã¹ãŸã„ã¨æ€ã£ãŸã‚‰é£Ÿã¹ãŸã„ã®ã§ã‚ã‚‹ã€‚ ã“ã“ãŒåŒ—ã‚«ãƒªãƒ•ã‚©ãƒ«ãƒ‹ã‚¢ã®ç‰‡ç”°èˆŽã§ã‚ã‚ã†ã¨ã€ç§ãŒã‚ã‚“ã¿ã¤ãŒé£Ÿã¹ãŸã„ã¨æ€ãˆã°ã€ã‚ã‚“ã¿ã¤ã¯ä»Šã™ãä½œã£ã¦é£Ÿã¹ãªãã¦ã¯ã„ã‘ãªã„ã‚‚ã®ã«ãªã‚‹ã€‚é£Ÿã„ã—ã‚“åŠã®æ€è€ƒã¯å‡„ã¾ã˜ã„ã€‚ åä¾›ãŒè¦³ã¦ã„ãŸã‚¢ãƒ‹ãƒ¡ã§ã€èµ¤ã¡ã‚ƒã‚“ãŒç©ºã®â€¦
shokai 2008/03/20
MySQL

Mac
ãƒªãƒ³ã‚¯
Update geometry field using SQL with ActiveRecord
shokai 2008/03/14
GeomFromText('POINT(lat lon)')ã‚’å®Ÿè£…

ActiveRecord

GIS

MySQL
ãƒªãƒ³ã‚¯
403 ã‚¢ã‚¯ã‚»ã‚¹ç¦æ¢
shokai 2008/03/14
GeomFromText('POINT(lat lon)')ã‚’å®Ÿè£…

ActiveRecord

GIS

MySQL
ãƒªãƒ³ã‚¯
s.h.log: Flashä½¿ã„ã®ãŸã‚ã®XAMPPã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨è¨å®š
shokai 2007/05/11
ä¿ºç”¨php.ini

XAMPP

Apache

MySQL

PHP

Perl

Server
ãƒªãƒ³ã‚¯
mysql ã‚’é«˜é€ŸåŒ–ã—ãŸã„ã¨ãã«èªã‚€ãƒ¡ãƒ¢ (TechKnowledge)
çµ¦æ–™ã®æŒ¯è¾¼å£åº§ã¨ã—ã¦ä¸‰äº•ä½å‹éŠ€è¡Œã«å£åº§ã‚’æŒã£ã¦ã„ã¾ã™ã€‚è‡ªå‹•æ”¯æ‰•ã„ã‚µãƒ¼ãƒ“ã‚¹ã‚’ä½¿ç”¨ã—ã¦å…‰ç†±è²»ç‰ã®å…¬å…±æ–™é‡‘ã®æ”¯æ‰•ã„ã‚’ã—ã¦ã„ã¾ã™ãŒã€å…ˆæ—¥ãã‚Œã‚‰ã®å†…ã®ä¸€ã¤ã‚’å¤±å¿µã—ã¦ãŸã“ã¨ã«æ°—ã¥ãã¾ã—ãŸã€‚å£åº§ã‚’ç¢ºèªã—ãŸæ™‚ã«ã¯ã™ã§ã«å¼•ãè½ã¨ã—ãŒå®Œäº†ã—ã¦ã„ãŸãŸã‚ã€æ‰‹å…ƒã®è³‡é‡‘ãŒå¿ƒç´°ããªã£ãŸçŠ¶æ…‹ã§æ•°æ—¥ã‚’éŽã”ã•ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸‰äº•ä½å‹éŠ€è¡Œã§å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ãŒå¯èƒ½ã§ã‚ã‚Œã°ã€æ˜¯éžåˆ©ç”¨ã—ãŸã„ã®ã§ã™ãŒã€‚ é‹ãŒè‰¯ã‘ã‚Œã°ã€ä¸‰äº•ä½å‹éŠ€è¡Œã®å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã¯å¯èƒ½ ä¸‰äº•ä½å‹éŠ€è¡Œã®ç‰¹å¾´ã¯ã¾ãšã‚¯ãƒ¬ã‚¸ãƒƒãƒˆã‚«ãƒ¼ãƒ‰ä¼šç¤¾ã¨ã®é€£æºã—ãŸã‚µãƒ¼ãƒ“ã‚¹ãŒé…åŠ›çš„ãªã“ã¨ãŒã‚ã’ã‚‰ã‚Œã¾ã™ã€‚ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã§ã¯éŠ€è¡Œã‚«ãƒ¼ãƒ‰ãƒãƒ¼ãƒ³ã§ã™ã‹ã‚‰ã€ä½•ã‚ˆã‚Šå®‰ã„é‡‘åˆ©ãŒå¤§ãã„åˆ©ç‚¹ã«ãªã‚Šã¾ã™ã€‚æ¦‚ãéŠ€è¡Œç³»ã®å¯©æŸ»ã«å¿…è¦ãªæ™‚é–“ã¯é•·ããªã‚‹ã‚ˆã†ã§ã™ãŒã€ä¸‰äº•ä½å‹éŠ€è¡Œã§ã¯ã‚«ãƒ¼ãƒ‰ç™ºè¡ŒãŒå½“æ—¥ã«è¡Œãªã£ã¦ãã‚Œã¾ã™ã€‚ ä¸‰äº•ä½å‹éŠ€è¡Œã¯å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ãŒã§ãã‚‹ã‹ã¨è¨€ã†ã¨å¾®å¦™ãªã“ã¨ã«ãªã‚Šã¾ã™ã€‚ç”³è¾¼ã‹ã‚‰å¯©æŸ»çµæžœã®é€£çµ¡ã¾ã§ã¯ã€åœŸæ—¥
shokai 2006/11/28
MySQL
ãƒªãƒ³ã‚¯
ã“ã“ã‚®ã‚³ï¼: MySQL4.1ä»¥é™ã§ã®ç©ºé–“æƒ…å ±ã®æ‰±ã„æ–¹
Posted by nene2001 at 01:25 / Tag(Edit): mysql spatial / 2 Comments: Post / View / 1 TrackBack / Google Maps Web2.0ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ§ãƒƒãƒ—ã§è¬›æ¼”ã™ã‚‹ã®ã«ã€ãŸã ã§ã•ãˆä¸€äººã ã‘ç´ äººã§ã¾ã¨ã‚‚ãªè¬›æ¼”ã§ãã‚‹ã‹ä¸å®‰ãªã®ã«ã€å‹‰å¼·ã›ãšã«ä»Šã®çŸ¥è˜ã ã‘ã§ã¯ã„ã‹ã‚“ã ã‚ã†ã¨ã„ã†ã“ã¨ã§ã€ä»Šã¾ã§ã»ã£ãŸã‚‰ã‹ã—ã¦ããŸMySQL4.1ä»¥é™ã®ç©ºé–“æƒ…å ±åˆ©ç”¨æ³•ã‚’å‹‰å¼·ã€‚ ã¨ã„ã£ã¦ã‚‚ã€ã“ã¡ã‚‰ã«4.1ã®æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‚ã‚‹ã®ã§å…¨ç„¶è‹¦åŠ´ãªã—ã ãŒã€‚ ãŸã å‹•ä½œç¢ºèªã¯5.1ã§ã‚„ã£ã¦ã„ã‚‹ã®ã§ã€è‹±èªžç‰ˆ5.1ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã¨ã®ç…§ã‚‰ã—åˆã‚ã›ã¯ã‚„ã£ã¦ã¾ã™ã‘ã©ã€‚ä¸€å¿œã€‚ PostGISã¨ã®æ¯”è¼ƒã§æ›¸ãã¨ã€PostGISã®å ´åˆã€PostgreSQL æœ¬ä½“ã¨ã¯åˆ¥ã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã§ã‚ã‚‹ã›ã„ã‹ã€ä½ç½®æƒ…å ±ã‚«ãƒ©ãƒ ã®ã¤ã„ãŸãƒ†ãƒ¼ãƒ–ãƒ«ã¯ã„ã£ãºã‚“ã«ã¯ã§ããªã„ã€‚ ä¾‹ãˆ
shokai 2006/11/20
PostGIS

MySQL

GIS
ãƒªãƒ³ã‚¯
Index of /max: some externals for max/msp--
folks- the google externals have been broken by changes by google, none have been updated for intel macs, and generally all are in a sad, neglected state as i've been spending my time on other things lately. you're welcome to them as they are, but don't get your hopes up. i'm happy to provide source code and encouragement to anyone who's interested in giving them a new home. sincerely, the mana
shokai 2006/11/10
Maxã§MySQLä½¿ãˆã‚‹

Max-MSP

MySQL
ãƒªãƒ³ã‚¯
1 2 3 æ¬¡ã®ãƒšãƒ¼ã‚¸