[B! mysql] yuisekiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

yuiseki id:yuiseki

mysqlã«é–¢ã™ã‚‹yuisekiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (26)

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

GitHub - coresmart/persistencejs: persistence.js is an asynchronous Javascript database mapper library. You can use it in the browser, as well on the server (and you can share data models between them).
persistence.js is a asynchronous Javascript object-relational mapper library. It can be used both in the web browser and on the server using node.js. It currently supports 4 types of data stores: HTML5 WebSQL database, a somewhat controversial part of HTML5 that is supported in Webkit browsers, specifically on mobile devices, including iPhone, Android and Palm's WebOS. Google Gears, a browser plug
yuiseki 2014/02/25
node.js

orm

mysql
ãƒªãƒ³ã‚¯
Sequelize
SequelizeSequelize is a modern TypeScript and Node.js ORM for Oracle, Postgres, MySQL, MariaDB, SQLite and SQL Server, and more. Featuring solid transaction support, relations, eager and lazy loading, read replication and more.
yuiseki 2014/02/25
node.js

orm

mysql
ãƒªãƒ³ã‚¯
GitHub - dresende/node-orm2: Object Relational Mapping
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
yuiseki 2014/02/25
node.js

orm

mysql
ãƒªãƒ³ã‚¯
GitHub - sequelize/sequelize: Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB (v6), DB2 and DB2 for IBM i.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
yuiseki 2013/10/20
node.js

mysql

orm

sequelize

tech
ãƒªãƒ³ã‚¯
CoffeeScriptãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹é›†ã€€Node.jsã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç·¨ï¼ˆ3ï¼‰
CodeZineç·¨é›†éƒ¨ã§ã¯ã€ç¾å ´ã§æ´»èºã™ã‚‹ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚’ã‚¹ã‚¿ãƒ¼ã«ã™ã‚‹ãŸã‚ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒDevelopers Summitã€ã‚„ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç”Ÿãã–ã¾ã‚’ãƒ–ãƒ¼ã‚¹ãƒˆã™ã‚‹ãŸã‚ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒDevelopers Boostã€ãªã©ã€ã•ã¾ã–ã¾ãªã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä¼ç”»ãƒ»é‹å–¶ã—ã¦ã„ã¾ã™ã€‚
yuiseki 2013/10/20
node.js

mysql

orm

sequelize

tech
ãƒªãƒ³ã‚¯
node.jsã§Sequelizeã‚’ä½¿ã†ãŸã‚ã®æº–å‚™ï¼å¾Œç·¨ | Inhale n' Exhale
ãã‚Œã§ã¯ä¸ç·¨ã§æ£šä¸Šã’ã—ã¦ã„ãŸsyncãƒ¡ã‚½ãƒƒãƒ‰ã‚’æä¾›ã™ã‚‹APIã®å®Ÿè£…ã‚’æ›¸ã„ã¦ã„ã“ã†ã€‚ Sequelizeã®ã‚µãƒ³ãƒ—ãƒ«ã‚’è¦‹ã¦ã‚‚ã‚ã‹ã‚‹ã‚ˆã†ã«ã€syncãƒ¡ã‚½ãƒƒãƒ‰ã¯importãƒ¡ã‚½ãƒƒãƒ‰ã«ã‚ˆã£ã¦ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹åŒ–ã•ã‚ŒãŸãƒ¢ãƒ‡ãƒ«ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã«å¯¾ã™ã‚‹å‘¼ã³å‡ºã—ï¼ˆProject.syncï¼‰ã¨ã€Sequelizeã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã«å¯¾ã™ã‚‹å‘¼ã³å‡ºã—ï¼ˆsequelize.syncï¼‰ã®2ãƒ‘ã‚¿ãƒ¼ãƒ³ã‚ã‚‹ã€‚ãƒ¢ãƒ‡ãƒ«ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã«å¯¾ã—ã¦sync()ã‚’å®Ÿè¡Œã™ã‚‹ã¨ã€å¯¾å¿œã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã ã‘ãŒæ§‹ç¯‰ã•ã‚Œã‚‹ã€‚ Sequelizeã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã«å¯¾ã—ã¦sync()ã‚’å®Ÿè¡Œã™ã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å…¨ä½“ãŒæ§‹ç¯‰ã•ã‚Œã‚‹ã€‚ã¾ãŸã€sync()ã®å¼•æ•°ã«{ force: true }ã‚’æ¸¡ã™ã¨ã€æ—¢å˜ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä¸€æ—¦å‰Šé™¤ï¼ˆDROPï¼‰ã—ã¦ã‚¼ãƒã‹ã‚‰ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚Šç›´ã™ï¼ˆå†æ§‹ç¯‰ï¼‰ã€‚ APIã¨ã—ã¦ã¯ã€å€‹ã€…ã®ãƒ†ãƒ¼ãƒ–ãƒ«ï¼ˆãƒ¢ãƒ‡ãƒ«ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆï¼‰ã«å¯¾ã™ã‚‹å‘¼ã³å‡ºã—ã¨ã€å…¨ä½“ï¼ˆSequelizeã‚ªãƒ–ã‚¸ã‚§ã‚¯
yuiseki 2013/10/20
node.js

mysql

orm

sequelize

tech
ãƒªãƒ³ã‚¯
node.jsã§Sequelizeã‚’ä½¿ã†ãŸã‚ã®æº–å‚™ï¼ä¸ç·¨ | Inhale n' Exhale
å‰ç·¨ã§ã¯ã€Sequelizeã‚’ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹åŒ–ã™ã‚‹ãŸã‚ã«è‡ªå‰ã§dbconnãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä½œã£ã¦ã€app.jsã¯ã“ã‚“ãªæ„Ÿã˜ã«ã‚·ãƒ³ãƒ—ãƒ«ã«æ›¸ã‘ã‚‹ã‚ˆã†ã«ãªã£ãŸã€‚ var express = require('express') , resource = require('express-resource') , config = require('config') , sequelize = require('dbconn')(config) , app = module.exports = express.createServer(); app.resource('users', require('./routes/users'), { id: 'id' }); å®Ÿéš›ã«Sequelizeã‚’ä½¿ã£ã¦DBã«å¯¾ã™ã‚‹CRUDæ“ä½œã‚’è¡Œã†APIã®å®Ÿè£…ã‚’æ›¸ãä»¥å‰ã«ã€ã¾ã DBã™ã‚‰å˜åœ¨ã—ãªã„ã®ã§mysqlã‚³ãƒžãƒ³ãƒ‰ã§DB
yuiseki 2013/10/20
node.js

mysql

orm

sequelize

tech
ãƒªãƒ³ã‚¯
node.jsã§Sequelizeã‚’ä½¿ã†ãŸã‚ã®æº–å‚™ï¼å‰ç·¨ | Inhale n' Exhale
MVCã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œã‚‹éš›ã€ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ©ï¼ˆCï¼‰ã¨ãƒ“ãƒ¥ãƒ¼ï¼ˆVï¼‰ã¯å‰å›žç´¹ä»‹ã—ãŸexpress-resourceãŒé¢å€’ã‚’è¦‹ã¦ãã‚Œã‚‹ã€‚REST APIã®å ´åˆã¯ãƒ“ãƒ¥ãƒ¼ã¨å‘¼ã¶ã»ã©ã®ã‚‚ã®ã§ã¯ãªã„ãŒã€APIã®å‡ºåŠ›å½¢å¼ã‚’XMLã€JSONã¨è¤‡æ•°å¯¾å¿œã™ã‚‹ã«ã¯ã‚³ãƒ³ãƒ†ãƒ³ãƒˆãƒã‚´ã‚·ã‚¨ãƒ¼ã‚·ãƒ§ãƒ³ãŒå¼·åŠ›ãªãƒ“ãƒ¥ãƒ¼æ©Ÿèƒ½ã‚’æä¾›ã—ã¦ãã‚Œã‚‹ã¨è¨€ãˆã‚‹ã€‚ ã•ã¦ã€ä»Šå›žã¯ãƒ¢ãƒ‡ãƒ«ï¼ˆMï¼‰ã«ç›¸å½“ã™ã‚‹éƒ¨åˆ†ã‚’ä½œã‚‹éš›ã«æ¬ ã‹ã›ãªã„Sequelizeã‚’ç´¹ä»‹ã—ã‚ˆã†ã€‚ Sequelizeã‚’ä½¿ã†ã¨ã€DBã®ã‚¹ã‚ãƒ¼ãƒžã‚„ãƒ‡ãƒ¼ã‚¿ã‚’ã€node.jsã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å†…ã§JavaScriptã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¨ã—ã¦æ‰±ãˆã‚‹ã‚ˆã†ã«ãªã‚‹ã€‚ã„ã‚ã‚†ã‚‹O/Rãƒžãƒƒãƒ‘ãƒ¼ã‚’å®Ÿç¾ã—ã¦ãã‚Œã‚‹ã€‚MySQLã€SQLiteã€ PostgreSQLã¨ä¸»ãªã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®RDBMSã¯ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ãŠã‚Šã€RDBMSæ¯Žã«å¾®å¦™ã«ç•°ãªã‚‹SQLã®æ–¹è¨€ãªã©ã‚’å¸åŽã—ã¦ãã‚Œã‚‹ã®ã§ã€ä»®ã«é–‹ç™ºéŽç¨‹ã§RDBMSã‚’ä¹—ã‚Šæ›ãˆã‚‹ã“ã¨ãŒã‚ã£
yuiseki 2013/10/20
node.js

mysql

orm

sequelize

tech
ãƒªãƒ³ã‚¯
ï¼•æ¬¡å…ƒã®ã‚«ã‚ªã‚¹: expressã¨sequelize.jsã§MySQLã‚’è©¦ã—ã¦ã¿ã‚‹
yuiseki 2013/10/20
node.js

mysql

orm

sequelize

tech
ãƒªãƒ³ã‚¯
SequelizeãŒæ€–ãã¦ä½¿ãˆãªã„ - $ cat /var/log/shin
Node.jsã§åˆ©ç”¨ã§ãã‚‹Sequelize Â» A multi-dialect Object-Relational-Mapper for Node.JSã¨ã„ã†ï¼ˆç¾æ™‚ç‚¹ã§å”¯ä¸€ã®ï¼Ÿï¼‰ORMãŒã‚ã‚Šã¾ã™ã€‚ä½¿ã„æ–¹ã«ã¯ã‚¯ã‚»ãŒã‚ã‚Šã¾ã™ãŒã€è‰²ã€…ã„ã˜ã£ã¦ã„ã‚Œã°1æ—¥ã»ã©ã§ä½¿ãˆã‚‹ã‚ˆã†ã«ãªã‚‹ãã‚‰ã„ã®é›£ã—ã•ã ã¨æ€ã„ã¾ã™ã€‚v1.5.0æ™‚ç‚¹ã§å¯¾å¿œã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯MySQLã€PostgresSQLã€SQLiteã§ã™ã€‚é©å½“ãªéŠã³ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’ä½œã‚‹ã‚ˆã†ãªæ™‚ã«ã€SQLiteãŒä½¿ãˆã‚‹ã¨ã„ã†ã®ã¯å¤§å¤‰ã‚ã‚ŠãŒãŸã„ã®ã§ã€ã“ã“ã®æ‰€ã€Node.jsã€Expressã€Sequelizeã®çµ„ã¿åˆã‚ã›ã§ã„ã‚ã„ã‚éŠã‚“ã§ã„ã¾ã—ãŸã€‚ ã•ã¦æœ¬é¡Œã§ã™ãŒã€Sequelizeã«ã¤ã„ã¦ç¾æ™‚ç‚¹ã§å•é¡Œã ã¨æ€ã†éƒ¨åˆ†ãŒã‚ã‚Šã¾ã™ã®ã§ã€æŒ™ã’ã¦ãŠãã¾ã™ã€‚ ã©ã“ã§ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—å‡¦ç†ã—ã¦ã„ã‚‹ã®ã‹ã‚ã‹ã‚‰ãªã„ ã“ã‚ŒãŒå®Ÿéš›ã«ä½¿ã†æ™‚ã«ä¸€ç•ªæ€–ã„ã¨ã“ã‚ã§ã™ã€‚å…¬å¼ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã«ã‚‚æ›¸ã„ã¦ã‚ã‚Šã¾
yuiseki 2013/10/20
node.js

mysql

orm

sequelize

tech
ãƒªãƒ³ã‚¯
http://sequelizejs.com/documentation
yuiseki 2013/10/20
node.js

mysql

orm

sequelize

tech
ãƒªãƒ³ã‚¯
é•·å¹´ã®è°è«–ã«çµ‚æ¢ç¬¦ -- MySQLã¨MariaDBã®é•ã„ä¸€è¦§ - æŠ€è¡“ãƒ¡ãƒ¢ç½®ãå ´
(2014.12.3è¿½è¨˜ï¼šã“ã®blogã®å†…å®¹ã¯ã€ä»¥ä¸‹ã®æ›¸ç±ã«ã‚‚åæ˜ ã•ã›ãŸã€‚) SQLãƒ¬ãƒ™ãƒ«ã®å·®ç•° MariaDB5.5ã¨MySQL5.5ã§ã¯SQLãƒ¬ãƒ™ãƒ«ã§ã®é•ã„ã¯ã»ã¨ã‚“ã©ãªã‹ã£ãŸã€‚autoincrementã®æœ€å¤§å€¤ã®æ‰±ã„ãã‚‰ã„ã€‚ ãŸã ã—ã€MariaDB10.0ã§REGEXPãŒãƒžãƒ«ãƒãƒã‚¤ãƒˆå¯¾å¿œã«ãªã£ãŸã®ã§ã€ã‚¢ãƒ—ãƒªå´ã¯æ³¨æ„ã€‚ é …ç›® MySQL MariaDB Autoincrement æœ€å¤§å€¤ã«é”ã™ã‚‹ã¨ã€ä»¥é™ã¯æœ€å¤§å€¤ã‚’ç¹°ã‚Šè¿”ã™ã€‚Warningã®ã¿ã€‚ã‚¨ãƒ©ãƒ¼ã«ãªã‚‰ãªã„ã€‚tinyintãªã‚‰â€¦,125,126,127,127,127â€¦ æœ€å¤§å€¤-1ã¾ã§ã€‚ä»¥é™ã¯ã‚¨ãƒ©ãƒ¼ã‚’è¿”ã™ã€‚tinyintãªã‚‰â€¦,125,126,ERROR,ERROR,â€¦ EXPLAINæ–‡ JSONå½¢å¼ ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6ã‹ã‚‰ æœªå¯¾å¿œ Optimizer Trace ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6ã‹ã‚‰ æœªå¯¾å¿œï¼ˆãŸã ã—ã€MariaDBã®ã»ã†ãŒã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶
yuiseki 2013/09/20
tech

mysql

mariadb
ãƒªãƒ³ã‚¯
ORDER BY RAND() ä½¿ã†ãª ---- Original by: â€œDo not use ORDER BY RAND()â€ or â€œHow to get random rows from table?â€ http://www.titov.net/2005/09/21/do-not-use-order-by-rand-or-how-to-get-random-rows-from-table/
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
yuiseki 2013/07/04
mysql

sql
ãƒªãƒ³ã‚¯
http://www.titov.net/2005/09/21/do-not-use-order-by-rand-or-how-to-get-random-rows-from-table/
yuiseki 2013/07/04
mysql

sql
ãƒªãƒ³ã‚¯
æ£ã—ã„ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’ã™ã‚‹ãŸã‚ã®10ã®ãƒã‚¤ãƒ³ãƒˆ
ä¸–ã®ä¸ã§ã¯ãŸãã•ã‚“ã®äººãŒç‹¬è‡ªã«ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’è¡Œãªã„ã€ç‹¬è‡ªã«æƒ…å ±ç™ºä¿¡ãŒã•ã‚Œã¦ã„ã¾ã™ã€‚ãã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã®ä¸ã«ã¯ã€éžå¸¸ã«å‚è€ƒã«ãªã‚‹ã‚‚ã®ã‚‚ã‚ã‚Œã°ã€ç¾å®Ÿæ€§ã«å¤§ããæ¬ ã‘ã‚‹ã‚‚ã®ã‚‚ã‚ã‚Šã¾ã™ã€‚ç«¶åˆä»–ç¤¾ãŒã€ãƒ©ã‚¤ãƒãƒ«ç¤¾ã®è£½å“ã«ã¨ã£ã¦ä¸åˆ©ãªæ¡ä»¶ã§ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’è¡Œã„ã€ãã‚Œã‚’ç™ºä¿¡ã™ã‚‹ã“ã¨ã‚‚æ—¥å¸¸çš„ã«è¡Œã‚ã‚Œã¦ã„ã¾ã™ã€‚ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã®çµæžœã‚’éµœå‘‘ã¿ã«ã™ã‚‹ã“ã¨ã¯å±é™ºã§ã€çµæžœã®æ„å‘³ã‚’åˆ¤æ–ã™ã‚‹ã‚¹ã‚ãƒ«ã‚’æŒã¤ã“ã¨ãŒé‡è¦ã§ã™ã€‚ã“ã‚Œã¯ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«ãŠã„ã¦è² è·ãƒ†ã‚¹ãƒˆã‚’è¡Œã†å ´åˆã«ã‚‚é‡è¦ã§ã™ã€‚è² è·ãƒ†ã‚¹ãƒˆã®æ¡ä»¶è¨å®šãŒæ£ã—ã„ã‹ã©ã†ã‹ã‚’åˆ¤æ–ã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ãŸã‚ã§ã™ã€‚ ã“ã“ã§ã¯ã€ç§ãŒDBã‚µãƒ¼ãƒã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯/è² è·ãƒ†ã‚¹ãƒˆã‚’è¡Œã£ãŸã‚Šçµæžœã‚’èªã‚“ã ã‚Šã™ã‚‹ä¸Šã§ã€å¿ƒãŒã‘ã¦ã„ã‚‹ãƒã‚¤ãƒ³ãƒˆã‚’10å€‹ã»ã©ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ â– ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã«é–¢ã™ã‚‹4ã¤ã®ãƒã‚¤ãƒ³ãƒˆ 1. ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã®ã‚¹ãƒšãƒƒã‚¯ã¨è¨å®šã‚’æ³¨è¦–ã™ã‚‹ ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢æ§‹æˆã«ã‚ˆã£ã¦ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯çµæžœã¯åŠ‡çš„ã«å¤‰ã‚ã‚‹ã®ã§ã€è¨€ã‚ãš
yuiseki 2012/10/24
ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯

mysql

db
ãƒªãƒ³ã‚¯
NoSQLã¨ã—ã¦MySQLã‚’ä½¿ã†DeNAãŒã€memcachedã‚ˆã‚Šã‚‚é«˜é€Ÿãª75ä¸‡ã‚¯ã‚¨ãƒªï¼ç§’ã‚’å®Ÿç¾
ãƒ¢ãƒã‚²ãƒ¼ã§çŸ¥ã‚‰ã‚Œã‚‹DeNAã¯ã€ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«NoSQLã‚’ä½¿ã£ã¦ã„ã¾ã›ã‚“ã€‚ãªãœã‹ï¼Ÿ ãã‚Œã¯MySQL/InnoDB 5.1ã®ç’°å¢ƒã§ç§’é–“75ä¸‡ã‚¯ã‚¨ãƒªã¨ã„ã†ã€å¤šãã®NoSQLã§ã‚‚å®Ÿç¾ã§ããªã„ã‚ˆã†ãªé«˜æ€§èƒ½ã‚’å®Ÿç¾ã—ã¦ã„ã‚‹ã‹ã‚‰ã€‚DeNAã®æ¾ä¿¡å˜‰ç¯„ï¼ˆã¾ã¤ã®ã¶ã‚ˆã—ã®ã‚Šï¼‰æ°ã¯ã€è‡ªèº«ã®ãƒ–ãƒã‚°ã«ã“ã‚“ãªå†…å®¹ã®ã‚¨ãƒ³ãƒˆãƒªã€ŒUsing MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity serverã€ï¼ˆè‹±èªžï¼‰ã‚’ãƒœã‚¹ãƒˆã—ã¦ã„ã¾ã™ã€‚ Yoshinori Matsunobu's blog: Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server æ¾ä¿¡æ°ãŒæŒ‡æ‘˜ã™ã‚‹ã‚ˆã†ã«ã€å¤§è¦æ¨¡ãªãƒãƒƒãƒˆã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã—ã¦ã„ã‚‹ä¼æ¥ã®å¤šãã¯åˆ†æ•£ç’°å¢ƒã§
yuiseki 2012/06/05
mysql
ãƒªãƒ³ã‚¯
ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ãƒ»ãƒ©ãƒ³ã‚ãƒ³ã‚°ã‚’è€ƒãˆã‚‹ | GREE Engineering
ã¯ã˜ã‚ã« ã“ã‚“ã«ã¡ã¯ã€‚ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ é–‹ç™ºéƒ¨ã®sp1rytusã¨ç”³ã—ã¾ã™ã€‚ å…ˆæ—¥ã€ç§ã‚‚ã¤ã„ã«30æ³ã®ãŠã£ã•ã‚“ã«ãªã£ã¦ã—ã¾ã„ã¾ã—ãŸã€‚åŠ é½¢è‡ãŒå‡ºãªã„ã‚ˆã†ã«ãŒã‚“ã°ã‚Šã¾ã™ï¼ ãƒ©ãƒ³ã‚ãƒ³ã‚°ã£ã¦ï¼Ÿ ãƒ©ãƒ³ã‚ãƒ³ã‚°ã¯èª°ã§ã‚‚ã‚ã‹ã‚‹ã€ä½•ã‚‰ã‹ã®å¾—ç‚¹ã‚’ã‚½ãƒ¼ãƒˆã—ã¦é †ä½ä½ç½®ã‚’æ±ºå®šã™ã‚‹å‡„ãç°¡å˜ã§ã‚·ãƒ³ãƒ—ãƒ«ãªã‚‚ã®ã§ã™ã€‚ã—ã‹ã—ã€ã‚²ãƒ¼ãƒ ã‚’æ‰±ã†ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ãƒ»ã‚µãƒ¼ãƒ“ã‚¹ã«ãŠã„ã¦ã¯ã€å¾—ç‚¹ã‚’é€šç®—/æ—¥åˆ¥ã«é †ä½ä»˜ã‘ã•ã‚ŒãŸã‚‚ã®ãŒç›´ãã«ç›®ã«å…¥ã‚‹ã‚ˆã†ã«ã€ä»–äººã¨è‡ªåˆ†ã‚’æ¯”è¼ƒã™ã‚‹éžå¸¸ã«é‡è¦ãªå½¹å‰²ã‚’æžœãŸã—ã¦ã„ã¾ã™ã€‚ãã“ã§ã€ã“ã®è¨˜äº‹ã§ã¯æ¬¡ã®ï¼“ã¤è¦ä»¶ã‚’æº€ãŸã™ã‚ˆã†ãªãƒ©ãƒ³ã‚ãƒ³ã‚°ãƒ»ã‚·ã‚¹ãƒ†ãƒ ã®é›£ã—ã•ã¨ã€ãã‚Œã‚’è§£æ±ºã™ã‚‹ãŸã‚ã®ä¸€ä¾‹ã‚’ç°¡å˜ã«èª¬æ˜Žã•ã›ã¦é ‚ãã¾ã™ã€‚ é †ä½ä»˜ã‘ã¯ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã«è¡Œã„ã€é›†è¨ˆæ™‚é–“ã‚’å¿…è¦ã¨ã—ãªã„ã€‚ 100ä¸‡ä»¶ä»¥ä¸Šã®å¾—ç‚¹ãƒ‡ãƒ¼ã‚¿ãŒæ‰±ãˆã‚‹ã€‚ ã™ã¹ã¦ã®ãƒ‡ãƒ¼ã‚¿ãŒæ£ã—ã„é †ä½ä»˜ã‘ã§å–å¾—ã§ãã‚‹(ç·šå½¢è£œå®Œãªã©ã§é †ä½ã‚’æ¦‚ç®—ã—ãªã„ï¼‰ã€‚ ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã«ã‚ˆã‚‹æ£ç¢ºãªé †ä½ä»˜ã‘ã¯ã€ãƒ‡ãƒ¼ã‚¿ä»¶æ•°
yuiseki 2012/06/05
ãƒ©ãƒ³ã‚ãƒ³ã‚°

mysql
ãƒªãƒ³ã‚¯
MySQLæ—¥æœ¬èªžåˆ©ç”¨å¾¹åº•å…¥é–€
1. <Insert Picture Here> MySQL æ—¥æœ¬èªžåˆ©ç”¨å¾¹åº•å…¥é–€ æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«æ ªå¼ä¼šç¤¾ MySQL Global Business Unit ãƒ†ã‚¯ãƒ‹ã‚«ãƒ«ã‚¢ãƒŠãƒªã‚¹ãƒˆ å¥¥é‡Žå¹¹ä¹Ÿ 2012 å¹´ 5 æœˆ 29 æ—¥ CopyrightÂ© 2012, Oracle. All rights reserved. 2. 2 ä»¥ä¸‹ã®äº‹é …ã¯ã€å¼Šç¤¾ã®ä¸€èˆ¬çš„ãªè£½å“ã®æ–¹å‘æ€§ã«é–¢ã™ã‚‹æ¦‚è¦ã‚’èª¬æ˜Žã™ã‚‹ã‚‚ã®ã§ã™ã€‚ã¾ ãŸã€æƒ…å ±æä¾›ã‚’å”¯ä¸€ã®ç›®çš„ã¨ã™ã‚‹ã‚‚ã®ã§ã‚ã‚Šã€ã„ã‹ãªã‚‹å¥‘ç´„ã«ã‚‚çµ„ã¿è¾¼ã‚€ã“ã¨ã¯ã§ã ã¾ã›ã‚“ã€‚ä»¥ä¸‹ã®äº‹é …ã¯ã€ãƒžãƒ†ãƒªã‚¢ãƒ«ã‚„ã‚³ãƒ¼ãƒ‰ã€æ©Ÿèƒ½ã‚’æä¾›ã™ã‚‹ã“ã¨ã‚’ã‚³ãƒŸãƒƒãƒˆãƒ¡ãƒ³ãƒˆï¼ˆç¢º ç´„ï¼‰ã™ã‚‹ã‚‚ã®ã§ã¯ãªã„ãŸã‚ã€è³¼è²·æ±ºå®šã‚’è¡Œã†éš›ã®åˆ¤æ–ææ–™ã«ãªã•ã‚‰ãªã„ã§ä¸‹ã•ã„ã€‚ã‚ª ãƒ©ã‚¯ãƒ«è£½å“ã«é–¢ã—ã¦è¨˜è¼‰ã•ã‚Œã¦ã„ã‚‹æ©Ÿèƒ½ã®é–‹ç™ºã€ãƒªãƒªãƒ¼ã‚¹ãŠã‚ˆã³æ™‚æœŸã«ã¤ã„ã¦ã¯ã€å¼Š ç¤¾ã®è£é‡ã«ã‚ˆã‚Šæ±ºå®šã•ã‚Œã¾ã™ã€‚ Oracle ã¨ Java ã¯ã€ Oracle Cor
yuiseki 2012/05/31
mysql

æ—¥æœ¬èªž

æ–‡å—ã‚³ãƒ¼ãƒ‰
ãƒªãƒ³ã‚¯
1å°ã‹ã‚‰500å°ã¾ã§ã®MySQLé‹ç”¨ MySQL Beginners
5. On-Demand WorkforceWorkforce On-Demand On-Demand Workforce On-Demand Workforce On-Demand Workforce Our Service (livedoor) Amazon MechanicalAmazon Mechanical Turk Mechanical Turk Amazon Mechanical Turk Mechanical Turk Turk Amazon Amazon t/ Workers Workers Requester Requester On-Demand WorkforceWorkforce On-Demand On-Demand Workforce On-Demand Workforce On-Demand Workforce Amazon MechanicalAmazon
yuiseki 2012/05/30
mysql
ãƒªãƒ³ã‚¯
MySQLã«å¯¾ã—ã¦ã€ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã«ã‚„ã£ã¦ã¯ã„ã‘ãªã„äº‹ã‚’ã‚„ã£ã¦ã¿ã‚ˆã†[è¿½è¨˜ã‚¢ãƒª] - oranie's blog
â€»ãƒ–ã‚¯ãƒžã‚³ãƒ¡ãƒ³ãƒˆã§æŒ‡æ‘˜é ‚ã„ãŸç®‡æ‰€ã‚’è¿½è¨˜ã—ã¾ã—ãŸï¼žï¼œ MySQL Casual Advent Calendar 2011ã€€21æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ å‰æ—¥ã¯@sohgohã•ã‚“ã® ã€ŒMySQLã®UDFã§ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã«ãƒ•ã‚¡ã‚¤ãƒ«æ“ä½œã€MySQL Casual Advent Calendar 2011 20æ—¥ç›®ã€‘ã€ ã§ã—ãŸã€‚å›³ã‚„å‹•ç”»ã‚‚ã‚ã£ã¦è¦‹ã‚„ã™ã„ã§ã™ãï¼ æ”¹ã‚ã¦è‡ªå·±ç´¹ä»‹ã§ã™ã€‚21æ—¥ç›®ã‚’æ‹…å½“ã™ã‚‹ã€ä»Šå›žã®ã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ã§No.1ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã®åº§ã‚’ç‹™ã£ã¦ã„ã‚‹id:oranieï¼ˆã‚ªãƒ©ãƒ‹ã‚¨ï¼‰ã§ã™ã€‚ ä»Šå›žã¯MySQLã‚‚ãã“ãã“ã§ã€åƒ•ã®åå‰ã®æ£ã—ã„èªã¿æ–¹ã ã‘ã‚’è¦šãˆã¦ãã‚Œã‚Œã°ä»Šæ—¥ã¯å¤§ä¸ˆå¤«ã§ã™ã€‚ æ„å›³çš„ã«é–“é•ãˆã¦ã„ã‚‹äººã‚‚ãŸã¾ã«ã„ã¾ã™ãŒã€å¿ƒãŒæ±šã‚Œã™ãŽã¦ã„ã‚‹ã¨æ€ã†ã®ã§ãŠå¯ºã§åº§ç¦…ã¨ã‹ã—ãŸæ–¹ãŒã„ã„ã¨æ€ã„ã¾ã™ã€‚ ä»Šã¾ã§ã®è¨˜äº‹ã‚’æ‹è¦‹ã•ã›ã¦é ‚ãã€ã¿ã‚“ãªçœŸé¢ç›®ã«è‰²ã€…Tipsã‚’æ›¸ã„ã¦ã„ã‚‹ã®ã§ãƒ‹ãƒƒãƒç‹™ã„ï¼†åˆå¿ƒè€…ã®åƒ•ã¯ ã€ŒMySQLã«å¯¾ã—ã¦ã€ã‚«ã‚¸ãƒ¥ã‚¢
yuiseki 2011/12/21
mysql

å®Ÿé¨“

ã‚ã¨ã§èªã‚€

ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸