[B! sqlite] inouetakuyaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

inouetakuya id:inouetakuya

sqliteã«é–¢ã™ã‚‹inouetakuyaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (16)

${{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ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã€SQLITEã«ç§»å‹•ã—ã¦ä½¿ã„ãŸã„ - ãã‚Œãƒžã‚°ã§ï¼
MySQLâ†’SQLiteã¨ã„ã†ç‰©ã‚’è€ƒãˆã¦ã‚„ã£ã¦ã¿ãŸãƒã‚°ã€‚ MySQLã®ãƒ‡ãƒ¼ã‚¿ã‚’ã¡ã‚‡ã£ã¨æ“ä½œã—ãŸã‚Šã€å®Ÿé¨“ã—ãŸã‚Šã™ã‚‹ã®ã«ã€MySQLã‚’ã‚³ãƒ”ãƒ¼ã—ãŸã‚Šã€ã‚‚ã†ä¸€ã¤ã‚µãƒ¼ãƒãƒ¼ä½œã£ãŸã‚Šã—ã¦ãŸã€‚MacOSXã«MySQLå…¥ã‚Œã¦ã‚‚ã‚ˆã‹ã£ãŸã‘ã©ã€ã¡ã‚‡ã£ã¨ã‚¯ã‚¨ãƒªå®Ÿé¨“æ“ä½œã‚’ã‚¢ãƒ¬ã‚³ãƒ¬ã—ãŸã‚Šå…ƒã«æˆ»ã—ãŸã‚Šã€SQLã‚’æ‰‹æ—©ãä½¿ã†ã«ã¯ä¸ä¾¿ã ã£ãŸã€‚ ãã“ã§ã€MySQLâ†’SQLiteã¨ã„ã†ç‰©ã‚’è€ƒãˆã¦ã¿ãŸã€‚ SQLiteã«ãŠã„ã¦ãŠã‘ã°ï¼Ÿ ã‚ªãƒ•ãƒ©ã‚¤ãƒ³ã§ã‚‚ä½¿ãˆã‚‹ã‚ˆã†ãªã‚‹ã‚“ã˜ã‚ƒãªã„ï¼Ÿã˜ã‚ƒãMySQLãƒ‡ãƒ¼ã‚¿ã‚’SQLiteã«ç§»å‹•ã—ãŸã„ã€‚ SQLiteã¸æŒã£ã¦è¡Œãæ‰‹é † ä»Šå›žã®æ‰‹é †ã¯æ¬¡ã®ã‚ˆã†ã«è€ƒãˆãŸã€‚ MySQLã‹ã‚‰ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‚’å‡ºåŠ› æ‰‹ä½œæ¥ã§å¤‰æ› SQLiteã§ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‚’æŒã¡è¾¼ã¿ MySQLã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¤ãƒ³ã‚µãƒ¼ãƒˆæ–‡ã¨ã—ã¦å–ã‚Šå‡ºã— SQLiteã«ã‚¤ãƒ³ã‚µãƒ¼ãƒˆæ–‡ã‚’å®Ÿè¡Œã—ã¦æŒã¡è¾¼ã¿ ã®æ–¹æ³•ã§ã‚„ã£ã¦ã¿ã¾ã™ã€‚ æº–å‚™ï¼›ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å…¨éƒ¨SQLå‡ºåŠ›
inouetakuya 2012/05/12
mysql

sqlite
ãƒªãƒ³ã‚¯
Rails 3ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ãã®2ï¼ˆsqlite3ï¼‰ - hachiNote
ç›®çš„ å¼•ãç¶šã Web+DB Press vol.58ã®ç‰¹é›†è¨˜äº‹ã€Œè©³ç´°Rails 3ã€ã«ã—ãŸãŒã£ã¦ä½œæ¥ã‚’é€²ã‚ã¦ã„ã‚‹ã®ã§ã™ãŒã€è¨˜äº‹ã§ã¯Railsã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦SQLite3ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹ã®ã§ãã‚Œã‚’ä½¿ãˆã‚‹ã‚ˆã†ã«ã—ã¾ã™ã€‚ ç’°å¢ƒã¯CentOS 5.3ã§ã™ã€‚ ã¨ã‚Šã‚ãˆãšãã‚Œã£ã½ã„ã“ã¨ã‚’è©¦ã¿ã‚‹ ã“ã“ã®ã‚µã‚¤ãƒˆã‚’è¦‹ã¦ã„ãŸã‚‰ã€SQLite3ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã¾ã—ãŸã®ã§ã€ã¨ã‚Šã‚ãˆãšã¾ãã£ã“ã€‚Railsã§ä½¿ã†ã®ã¯ã€sqlite3-rubyã£ã¦åå‰ã®ã‚‚ã®ãªã®ã‹ãªï¼Ÿ Linuxã«Ruby1.9.2ã¨Rails3ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - ã‚Šã£ã·ã‚‹é–‹ç™ºè¨˜éŒ² # gem install sqlite3-ruby Building native extensions. This could take a while... ERROR: Error installing sqlite3-ruby: ERROR: Failed
inouetakuya 2012/02/22
rails

sqlite
ãƒªãƒ³ã‚¯
CentOSã«RubyOnRailsã‚’å°Žå…¥ã—ãŸã¨ãã«ãƒãƒžã£ãŸã¨ã“ã‚ã¾ã¨ã‚ â€“ å¯ºåå±‹æœªæº€
é”äººå‡ºç‰ˆä¼šã‹ã‚‰å‡ºã¦ã„ã‚‹ã€Œã¯ã˜ã‚ã‚‹ï¼Rails3ã€ã‚’èªã¿ã¯ã˜ã‚ã¾ã—ãŸã€‚ åŸºæœ¬çš„ã«é–‹ç™ºã¯Macã§è¡Œã†ã®ã ã‘ã©ã€è‡ªé¯–ãŒã‚ã‚‹ã®ã§ç’°å¢ƒæ§‹ç¯‰ã ã‘ã§ã‚‚ã‚„ã£ã¦ã¿ã‚ˆã†ã¨æŒ‘æˆ¦ã—ãŸã¨ã“ã‚ã„ã‚ã„ã‚ãƒãƒžã‚Šã¾ã—ãŸã€‚ï¼ˆã‚ˆã£ã¦ä»Šæ—¥ã¯çœ ã„ï¼‰ ç’°å¢ƒ CentOS release 5.7 (Final) ruby 1.9.3p0 (2011-10-30 revision 33570) [i686-linux]ï¼ˆrvmä½¿ç”¨ï¼‰ ã“ã“ã«ã€Œã¯ã˜ã‚ã‚‹ï¼Rails3ã€é€šã‚Šã«ã‚µãƒ³ãƒ—ãƒ«ãŒå®Ÿè¡Œã§ãã‚‹ã‚ˆã†ç’°å¢ƒã‚’æ•´ãˆã¦ã„ãã¾ã—ãŸã€‚ sqlite ã‚µãƒ³ãƒ—ãƒ«ã‚¢ãƒ—ãƒªç”¨ã®DBã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ã„ããªã‚Šèº“ãã€‚ $ sudo yum install sqlite3-devel Loaded plugins: priorities, security 144 packages excluded due to repository priority protectio
inouetakuya 2012/02/20
rails

sqlite
ãƒªãƒ³ã‚¯
http://hiropo.co.uk/archives/562
inouetakuya 2012/02/19
rails

sqlite
ãƒªãƒ³ã‚¯
Railsã®ãŸã‚ã«CentOS5.5ã«sqlite3ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - pirosikick's diary
ã•ãã‚‰VPSã§Rubyé–‹ç™ºã‚’å§‹ã‚ãŸè¨³ã§ã™ãŒã€railsã«ã¯sqlite3ãŒå¿…è¦ãªã‚ˆã†ãªã®ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ sqlite3-rubyã‚’gemã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« $ sudo gem install sqlite3-ruby Building native extensions. This could take a while... ERROR: Error installing sqlite3-ruby: ERROR: Failed to build gem native extension. /usr/local/bin/ruby extconf.rb checking for sqlite3.h... yes checking for sqlite3_libversion_number() in -lsqlite3... yes checking for rb_proc_arity()
inouetakuya 2011/08/30
rails

sqlite
ãƒªãƒ³ã‚¯
Ruby on Rails 3.0ã§æœ¬ç•ªç’°å¢ƒã¯PostgreSQLã€é–‹ç™ºç’°å¢ƒã¯SQLite3ã‚’ä½¿ã†ã¨ã - ç™ºå£°ç·´ç¿’
2ç³»ãªã‚‰ã°ã€config/database.ymlã®è¨å®šã ã‘ã§å¤‰æ›´å¯èƒ½ã ãŒã€Rails 3.0ã§ã¯Bundleã§gemãƒ©ã‚¤ãƒ–ãƒ©ãƒªãƒ¼ã‚’ç®¡ç†ã™ã‚‹ãŸã‚ã€æœ¬ç•ªç’°å¢ƒã¨é–‹ç™ºç’°å¢ƒã§ã€èªã¿è¾¼ã‚€ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãƒ¼ã‚’å¤‰ãˆã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ Bunlde: Gemfileã«ã‚ˆã‚‹ã¨ã€ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã‚„ç’°å¢ƒã®é•ã„ã«ã‚ˆã‚Šèªã¿è¾¼ã‚€ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãƒ¼ã®å¤‰æ›´ãŒå¯èƒ½ã€‚Gemfileã«ä»¥ä¸‹ã®ã‚ˆã†ã«è¨˜è¼‰ã™ã‚‹ã€‚ group :development do gem 'sqlite3-ruby', :require => 'sqlite3' end group :production do gem 'pg' endGemfile.lockã‚’ç”Ÿæˆã™ã‚‹ã¨ãã«ä»¥ä¸‹ã®ã‚ˆã†ã«å®Ÿè¡Œã™ã‚‹ã€‚ % bundle install --local --without development ï¼ˆæœ¬ç•ªç’°å¢ƒï¼‰ % bundle install --local --without
inouetakuya 2011/07/28
sqlite
ãƒªãƒ³ã‚¯
æœ¬ç•ªç’°å¢ƒã®PostgreSQLã«æ ¼ç´ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’é–‹ç™ºç’°å¢ƒã®SQLite3ã«æŒã£ã¦ãã‚‹ - ç™ºå£°ç·´ç¿’
Ruby on Rails 3.0ã§æœ¬ç•ªç’°å¢ƒã¯PostgreSQLã€é–‹ç™ºç’°å¢ƒã¯SQLite3ã‚’ä½¿ã†ã¨ãã®ã‚ˆã†ã«æœ¬ç•ªç’°å¢ƒã¯PostgreSQLã€é–‹ç™ºç’°å¢ƒã¯SQLite3ã‚’ä½¿ã£ã¦ã„ã‚‹ã€‚ãƒ‡ãƒãƒƒã‚°ãªã©ã®ãŸã‚ã«æœ¬ç•ªç’°å¢ƒã®ãƒ‡ãƒ¼ã‚¿ã‚’é–‹ç™ºç’°å¢ƒã«æŒã£ã¦ããŸã„ã¨ããŒã‚ã‚‹ã€‚ãã“ã§ã€yaml_dbã‚’ç”¨ã„ã¦ãƒ‡ãƒ¼ã‚¿ã‚’ç§»è¡Œã™ã‚‹ã€‚ æœ¬ç•ªç’°å¢ƒã§ã®ä½œæ¥ ã¾ãšã€yaml_dbã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã€‚Gemfileã«ä»¥ä¸‹ã‚’è¿½è¨˜ã™ã‚‹ã€‚ gem 'yaml_db'ãã®å¾Œã€bundleã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚ % bundle install --without developmentæœ¬ç•ªç’°å¢ƒã®ãƒ‡ãƒ¼ã‚¿ã‚’åãå‡ºã™ã€‚åãå‡ºã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã¯ db/data.yml ã«æ ¼ç´ã•ã‚Œã‚‹ï¼ˆæ—¥æœ¬èªžæ–‡å—åˆ—ã¯ãƒã‚¤ãƒŠãƒªãƒ¼ã§æ‰±ã‚ã‚Œã‚‹ã¿ãŸã„ï¼‰ % rake db:data:dump é–‹ç™ºç’°å¢ƒã§ã®ä½œæ¥ ã¾ãšã€yaml_dbã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã€‚Gemfileã«ä»¥ä¸‹ã‚’è¿½è¨˜ã™ã‚‹ã€‚ g
inouetakuya 2011/07/28
sqlite
ãƒªãƒ³ã‚¯
PenguinWanderer.net - [MT4][SQLite][PostgreSQL]ãƒ†ã‚¹ãƒˆã‚µãƒ¼ãƒã¯SQLiteã€æœ¬ç•ªç’°å¢ƒã¯PostgreSQLã€‚
- 1 user
- pg-w.net
- å¦ã³
inouetakuya 2011/07/28
4.ãƒ†ã‚¹ãƒˆç’°å¢ƒã®SQLiteãƒ€ãƒ³ãƒ—ãƒ‡ãƒ¼ã‚¿ã‚’æ‰‹ä½œæ¥ã§ç·¨é›†ã™ã‚‹ã€‚SQLæ–‡ã§å‡ºåŠ›ã•ã‚Œã¦ã„ã‚‹ãƒ€ãƒ³ãƒ—ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ†ã‚ã‚¹ãƒˆã‚¨ãƒ‡ã‚£ã‚¿ã§é–‹ãã€ã€ŒCREATEã€€TABLEã€ç³»ã‚’å‰Šé™¤ã€‚ã‚ã¨ã€ŒCREATEã€€INDEXã€ã‚‚å‰Šé™¤ã—ã¾ã™ã€‚ã€ŒINSERTã€€ï½žã€ã®ã¿æ®‹ã™ã‚ˆã†ãªã‚¤ãƒ¡ãƒ¼ã‚¸ã§ã™

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

sqlite
ãƒªãƒ³ã‚¯
Redmine(Rails) ã® DB ã‚’ SQLite3 ã‹ã‚‰ MySQL ã«ç§»è¡Œã™ã‚‹ - garin.jp
Redmine(Rails) ã® DB ã‚’ SQLite3 ã‹ã‚‰ MySQL ã«ç§»è¡Œã™ã‚‹ - garin.jp ãƒ›ãƒ¼ãƒ | ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ Table of contents: æ¦‚è¦ å¤‰æ›æ–¹æ³• ä»Šå›žã®æ–¹æ³•: SQLite3 => YAML => MySQL SQLite3 => MySQL ã®ãƒ„ãƒ¼ãƒ«ã§ã¯ãƒ€ãƒ¡ãªã®ï¼Ÿ æ›´æ–°å±¥æ´ å‰æç’°å¢ƒ ç§»è¡Œæ‰‹é † æº–å‚™ ãƒ‡ãƒ¼ã‚¿ã®å‡ºåŠ› ãƒ‡ãƒ¼ã‚¿ã®å…¥åŠ› Redmineã‚µãƒ¼ãƒ“ã‚¹ã®å†é–‹ å‚è€ƒURL 1 æ¦‚è¦ Ruby on Railsè£½ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†ãƒ„ãƒ¼ãƒ«ã€ŽRedmineã€ã‚’æœ€åˆã«è¨ç½®ã—ãŸéš›ã€ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½œæˆã™ã‚‹ã ã‘ã¨ã„ã†è¨å®šã®å®¹æ˜“ã•ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ SQLite3 ã‚’æŽ¡ç”¨ã—ã¾ã—ãŸã€‚ ã—ã‹ã—ã€ç®¡ç†ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã®å®¹é‡ãŒå¢—ãˆã¦ãã‚‹ã¨ç›®ã«è¦‹ãˆã¦é€Ÿåº¦ã®é…ã•ãŒæ°—ã«ãªã‚Šã¯ã˜ã‚ã¾ã—ãŸã€‚ ãã“ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ SQLite3 ã‹ã‚‰ MySQL ã¸ã®ç§»è¡Œã™ã‚‹äº‹ã«ãªã‚Šã¾ã—ãŸã€‚
inouetakuya 2011/07/19
sqlite

mysql

rails
ãƒªãƒ³ã‚¯
Railsã§Sqliteã‹ã‚‰Mysqlã«ãƒ‡ãƒ¼ã‚¿ã‚’ç§»è¡Œã™ã‚‹æ–¹æ³•ã®ç¶šã - Life on Rails
Railsã§Sqliteã‹ã‚‰Mysqlã«ãƒ‡ãƒ¼ã‚¿ã‚’ç§»è¡Œã™ã‚‹æ–¹æ³• - Life on Railsã®ç¶šãã€‚ ä¸Šè¨˜ã®ã‚¨ãƒ³ãƒˆãƒªä¸ã®ã‚³ãƒ¼ãƒ‰ã§ã¯ç§»è¡Œã™ã‚‹ã‚³ãƒ¼ãƒ‰ã‚’ãã‚Œãžã‚Œæ‰‹æ›¸ãã§è¨˜è¿°ã—ã¦ã„ãŸãŒã€ãã‚Œã‚’è‡ªå‹•åŒ–ã™ã‚‹ã€‚ module Dev end classes = [] Dir.foreach("app/models") do |file| class_name = if tmp = file.scan(/([a-z]+)\.rb/) if tmp = tmp.first if tmp = tmp.first tmp.capitalize end end end next if class_name.nil? classes << class_name end classes.uniq.each do |class_name| Dev.class_eval <<-EOV class #{class_name
inouetakuya 2011/07/19
sqlite

mysql

rails
ãƒªãƒ³ã‚¯
SQLite3â†’MySQLã¸ãƒ‡ãƒ¼ã‚¿ç§»è¡Œã€€Rails
å‚è€ƒï¼šï¼‘ï¼“ã•ã„ã®å‚™å¿˜éŒ² : SQLite3â†’MySQLã¸ãƒ‡ãƒ¼ã‚¿ç§»è¡Œ. è‡ªåˆ†ã®Ubuntu 11.04ã®ç’°å¢ƒã ã¨MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§æ–‡å—åŒ–ã‘ã‚’èµ·ã“ã—æ—¥æœ¬èªžãŒã™ã¹ã¦ï¼Ÿã«ãªã£ã¦ã„ã¾ã—ãŸã€‚ ã‚ã‚‰ã‹ã˜ã‚æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’æŒ‡å®šã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã—ã¦ãŠãã“ã¨ã§æ£å¸¸ã«ãªã‚Šã¾ã—ãŸã€‚ mysql> create database ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å CHARACTER SET utf8; ã“ã®æ–¹æ³•ã ã¨ã€Œrailsã§DBï¼†ãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆã€ã¨ã„ã†æ‰‹é †ã¯ã„ã‚‰ãªã‹ã£ãŸã‚ˆã†ãªæ°—ãŒã—ã¾ã™ã€‚productionã¨developmentã¨ã§MySQLã¨SQLite3ã‚’ä½¿ã„åˆ†ã‘ã‚‹ã¨ã„ã†ã“ã¨ã‚‚å•é¡Œãªã‹ã£ãŸã®ã§ã€Œ#gem â€˜sqlite3-rubyâ€™, :require => â€˜sqlite3â€™ â†ã‚³ãƒ¡ãƒ³ãƒˆã‚¢ã‚¦ãƒˆã€ã‚‚ã—ãªã‹ã£ãŸã§ã™ã€‚
inouetakuya 2011/07/19
sqlite

mysql

rails
ãƒªãƒ³ã‚¯
ï¼‘ï¼“ã•ã„ã®å‚™å¿˜éŒ² : SQLite3â†’MySQLã¸ãƒ‡ãƒ¼ã‚¿ç§»è¡Œ
2011å¹´05æœˆ28æ—¥20:40 ã‚«ãƒ†ã‚´ãƒªrails mysql SQLite3â†’MySQLã¸ãƒ‡ãƒ¼ã‚¿ç§»è¡Œ Rails3ã®ãƒ‡ãƒ•ã‚©DBã¯SQLite3ãªã‚ã‘ã§ã€ç¢ºã‹ã«æ—©ãã¦æ‰‹è»½ã§ä¾¿åˆ©ãªã‚“ã ã‘ã©ã€1ç‚¹ã ã‘å•é¡ŒãŒã‚ã‚‹ã€‚ ãã‚Œã¯ã€æŽ’ä»–åˆ¶å¾¡ãŒãƒ•ã‚¡ã‚¤ãƒ«ã®ãƒãƒƒã‚¯ã§ã‚ã‚‹ã“ã¨ï¼ ãªã‚“ã ã‚ˆãã‡ã€‚ Railsã ã‘ã§ä½¿ã£ã¦ã„ã‚Œã°å•é¡Œãªã„ã‚“ã ã‘ã©ã€ã©ã†ã—ã¦ã‚‚é‹ç”¨ä¸ã«DBã‚’å¼„ã‚‹ã“ã¨ãŒç™ºç”Ÿã—ã¦ã—ã¾ã†ã€‚ ã£ã¦ã“ã¨ã§Rails3æ—¢å˜ç’°å¢ƒã‚’MySQLã¸ å¤‰æ›´ã—ã¦ã¿ã‚‹ã€‚ ç’°å¢ƒ ubuntu 11.04 Rails(3.0.7) SQLite3 MySQL5 å‚è€ƒ http://d.hatena.ne.jp/arcright/20100725/1279992599 å‚è€ƒã‚µã‚¤ãƒˆæ§˜ã«ã‚ˆã‚‹ã¨ã€ yamlã§ã‚¨ã‚¯ã‚¹ãƒã‚¤ãƒ³ãƒã™ã‚‹ã¨ç°¡å˜ã«ç§»è¡Œã§ãã‚‹ã‚‰ã—ã„ã€‚ ã¨ã‚ã‚Šãˆãšã€MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« $ sudo apt-get install mys
inouetakuya 2011/07/19
sqlite

mysql

rails
ãƒªãƒ³ã‚¯
Redmineã§ä½¿ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¤‰æ›´ã™ã‚‹
Redmine.JP Blog ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢Redmineã«é–¢ã™ã‚‹ãƒ‹ãƒ¥ãƒ¼ã‚¹ã‚„ã€ã‚ˆã‚Šæ´»ç”¨ã™ã‚‹ãŸã‚ã®tipsãªã©ã‚’æŽ²è¼‰ã—ã¾ã™ Redmineã§ä½¿ç”¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯MySQL, SQLite, PostgreSQLã‹ã‚‰é¸æŠžå¯èƒ½ã§ã™ã€‚ã“ã®ã†ã¡SQLiteã¯å°Žå…¥ãŒç°¡å˜ã§æ‰‹è»½ã«ä½¿ã„å§‹ã‚ã‚‹ã“ã¨ãŒã§ãã¾ã™ãŒã€æœ¬æ ¼çš„ãªé‹ç”¨ã‚’å§‹ã‚ã‚‹ã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒå•é¡Œã«ãªã£ã¦ãã¦ã€MySQLç‰ã«ç§»è¡Œã—ãŸããªã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ ã“ã®ã‚ˆã†ãªã¨ãã«åˆ©ç”¨ã§ãã‚‹ã®ãŒ yaml_db ã¨ã„ã†Railsãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã§ã™ã€‚yaml_dbã‚’ä½¿ã†ã¨ã€Redmineãªã©Ruby on Railsãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…å®¹ã‚’YAMLå½¢å¼ã®ãƒ•ã‚¡ã‚¤ãƒ«ã«æ›¸ãå‡ºã™ã“ã¨ã€ãã—ã¦YAMLå½¢å¼ã®ãƒ•ã‚¡ã‚¤ãƒ«ã«æ›¸ãå‡ºã—ãŸå†…å®¹ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å–ã‚Šè¾¼ã‚€ã“ã¨ãŒã§ãã¾ã™ã€‚ç§»è¡Œå…ƒã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…å®¹ã‚’ãƒ•ã‚¡ã‚¤ãƒ«ã«æ›¸ãå‡ºã—ã€ç§»è¡Œå…ˆ
inouetakuya 2011/07/19
sqlite

mysql

rails
ãƒªãƒ³ã‚¯
Railsã§Sqliteã‹ã‚‰Mysqlã«ãƒ‡ãƒ¼ã‚¿ã‚’ç§»è¡Œã™ã‚‹æ–¹æ³• - Life on Rails
æœ€è¿‘ã®Railsã§ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®DBãŒsqliteã«ãªã£ã¦ã„ã‚‹ã€‚ã“ã®sqliteã‚’ä½¿ã„ç¶šã‘ã¦ã„ãã¨ã€Œã‚¬ãƒƒã‚«ãƒªã ã‚ˆï¼ã€ãªçŠ¶æ…‹ã«ãªã‚‹ã€‚ãã“ã§sqliteã‹ã‚‰mysqlã«ç§»è¡Œã—ã‚ˆã†ã¨æ€ã†ã€‚ sqlite2mysqlãªã‚‚ã®ã‚’æŽ¢ã—ã¦ã¿ã‚‹ã¨ä»¥ä¸‹ã®ã‚‚ã®ãŒè¦‹ã¤ã‹ã‚‹ã€‚ æš®ã‚‰ã—ã®æ¥(2006-10-19) http://donrails.araki.net/archives/id/5359 ã©ã¡ã‚‰ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã‚‚ã€sqliteã®.dumpã§ãƒ€ãƒ³ãƒ—ã—ãŸSQLãƒ•ã‚¡ã‚¤ãƒ«ã‚’mysqlå‘ã‘ã«ä¿®æ£ã—ã¦ãã‚Œã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã ã€‚ ä»Šå›žã€ã“ã‚Œã‚‰ã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’åˆ©ç”¨ã—ã‚ˆã†ã¨ã—ãŸãŒã€è‚¥å¤§åŒ–ã—ãŸsqliteãƒ€ãƒ³ãƒ—ã‚’è„†å¼±ãªVPSã§å‡¦ç†ã—ã‚ˆã†ã¨ã—ãŸã‚‰ã€ãƒ¡ãƒ¢ãƒªã‚’å…¨ã¦é£Ÿã„å°½ããã†ã¨ã™ã‚‹å§‹æœ«ã€‚ Railsã§ã¯sqliteã‚‚mysqlã‚‚ç°¡å˜ã«æ‰±ãˆã‚‹ã®ã§ã€Railsä¸Šã§ã‚„ã£ã¦ã¿ãŸã€‚ script/copy.rb module Dev class Entr
inouetakuya 2011/07/19
sqlite

mysql
ãƒªãƒ³ã‚¯
SQLiteã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç§»è¡Œ [ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹] All About
SQLiteã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç§»è¡ŒSQLiteã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’SQLiteManagerã«ã‚ˆã‚Šç§»è¡Œã™ã‚‹å ´åˆã®æ‰‹é †ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ SQLiteã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’SQLiteManagerã«ã‚ˆã‚Šç§»è¡Œã™ã‚‹å ´åˆã®æ‰‹é †ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚SQLiteManagerã®ãƒ¡ãƒ‹ãƒ¥ãƒ¼æ¬„ã«ã¯ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã¯ã‚ã‚Šã¾ã™ãŒã€ã‚¤ãƒ³ãƒãƒ¼ãƒˆãŒãªã„ã®ã§ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã‚ˆã‚Šä½œæˆã—ãŸSQLæ–‡ã‚’å®Ÿè¡Œã™ã‚‹ã“ã¨ã«ã‚ˆã‚Šãƒ‡ãƒ¼ã‚¿ã‚’ç§»è¡Œã—ã¾ã™ã€‚ ï¼Šãƒ†ãƒ¼ãƒ–ãƒ«å˜ä½ã§ç§»è¡Œã™ã‚‹å ´åˆã¯ã“ã¡ã‚‰ã®è¨˜äº‹ã‚’ã”å‚ç…§ãã ã•ã„ã€‚ ç§»è¡Œå…ƒã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆ ç§»è¡Œå…ƒã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã‚’ãŠã“ãªã„ã€SQLæ–‡ã‚’ä½œæˆã—ã¦ä¿å˜ã—ã¾ã™ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆã®SQLã¨ãƒ‡ãƒ¼ã‚¿ã‚’æŒ¿å…¥ã™ã‚‹SQLæ–‡ãŒä½œæˆã•ã‚Œã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã«è¤‡æ•°ã®ãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã‚‹å ´åˆã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã”ã¨ã«ãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆã®SQLã¨ãƒ‡ãƒ¼ã‚¿ã‚’æŒ¿å…¥ã™ã‚‹SQLæ–‡ãŒä½œæˆã•ã‚Œã¾ã™ã€‚ ä¾‹ã¨ã—ã¦ã€ã“ã“ã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€Œtestdbã€ã‚’
inouetakuya 2011/07/19
sqlite
ãƒªãƒ³ã‚¯
Djangoã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’sqlite3ã‹ã‚‰MySQLã«ç§»è¡Œã—ãŸã¨ãã«ãƒãƒžã£ãŸã“ã¨ - saitoâ€™s blog
sqlite3ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒ1ã¤ã®ãƒ•ã‚¡ã‚¤ãƒ«ã§ç°¡æ½”ã™ã‚‹ã®ã§ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãŒãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚³ãƒ”ãƒ¼ã§æ¸ˆã‚€ç‰ã€æ‰±ã„ãŒéžå¸¸ã«ç°¡å˜ã§ã™ã€‚ ãã®ãŸã‚åƒ•ã¯Djangoã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œã‚‹ã¨ãã¯ã€sqlite3ã‚’ä½¿ç”¨ã—ã¦ã„ã¾ã™ã€‚ ã—ã‹ã—ã€sqlite3ã§ã¯ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å®Ÿè¡Œæ™‚ã«ãƒ•ã‚¡ã‚¤ãƒ«å…¨ä½“ãŒãƒãƒƒã‚¯ã•ã‚Œã‚‹ã®ã§ã€è¤‡æ•°ãƒ—ãƒã‚»ã‚¹ãƒ»ã‚¹ãƒ¬ãƒƒãƒ‰ã‹ã‚‰åŒæ™‚ã«æ›¸ãè¾¼ã¿ã‚’è¡Œã†ã‚ˆã†ãªç”¨é€”ã®å ´åˆã€åˆ¥ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ä½¿ç”¨ã—ãŸæ–¹ãŒè‰¯ã„ã¨æ€ã‚ã‚Œã¾ã™ã€‚ åƒ•ã¯ä»Šã€ä¸€å®šæ™‚é–“ã”ã¨ã«webãƒšãƒ¼ã‚¸ã‚’ã‚¯ãƒãƒ¼ãƒªãƒ³ã‚°ã—ã¦ã€å¾—ã‚‰ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ä¿å˜ã™ã‚‹ã‚ˆã†ãªãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ä»Šæ›¸ã„ã¦ã„ã¾ã™ã€‚ cronã§æŒ‡å®šã—ãŸã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒ«ä»¥å†…ã«ãƒ—ãƒã‚°ãƒ©ãƒ ãŒçµ‚äº†ã—ãªã‹ã£ãŸå ´åˆã€å¤ã„ãƒ—ãƒã‚»ã‚¹ã¨æ–°ã—ã„ãƒ—ãƒã‚»ã‚¹ã§åŒæ™‚ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ãŒç™ºç”Ÿã—ã¦ã—ã¾ã„ã€ã†ã¾ããƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®æ›¸ãè¾¼ã¿ãŒå‡ºæ¥ãªã„ã¨ã„ã†è‡ªä½“ã«é™¥ã£ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ ãã“ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã‚’sq
inouetakuya 2011/07/19
django

mysql

sqlite

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
1