ã“ã›ãã®æŠ€è¡“日記 - Rails + MySQL (+ Mongrel?) ã§DB接続ã®é€šä¿¡ãŒç„¡ã„状態ãŒç¶šãã¨ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã™ã‚‹ã€‚
(追記) ã“ã®å•é¡Œã«ã¤ã„ã¦ã€åŽŸå› ã¯Rubyã®å´ã«ã‚ã‚‹ã®ã§ã¯ãªã„ã‹ã¨è€ƒãˆã¦ã„ã¾ã™ã€‚特定ã®æ¡ä»¶ä¸‹ã§TCPSocket#flushを実行ã™ã‚‹ã¨ã€ã‚¹ãƒ¬ãƒƒãƒ‰ãŒåœæ¢ã—ãŸã¾ã¾å‡¦ç†ãŒæˆ»ã£ã¦ã“ãªããªã‚Šã¾ã™ã€‚以下ã®æŠ•ç¨¿ã§ã€Railsを使ã‚ãšå†ç¾ã™ã‚‹æ–¹æ³•ã‚’説明ã—ã¾ã—ãŸã€‚ http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-list/43356 (追記ãŠã‚ã‚Š) 開発サーãƒãŒç¿Œæ—¥ã«ãªã‚‹ã¨ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã™ã‚‹ã€ã¨ã„ã†ç¾è±¡ãŒç¶šã„ã¦ã„ã¦æ‚©ã¿ã¾ã—ãŸã€‚ 解決方法ã¯ã€Mongrelã®FAQã«ä¸ŠãŒã£ã¦ã„ã¾ã—ãŸã€‚ http://mongrel.rubyforge.org/faq.html Q: Mongrel stops working if it’s left alone for a long time. If you find that Mongrel stops work
suVeneã®ã‚ã‚Œ: PL/SQLç‰ã®ãƒãƒƒãƒå‡¦ç†ã§ãŸã¾ã«è¦‹ã‹ã‘る最悪ãªãƒ—ãƒã‚°ãƒ©ãƒ
2007å¹´01月18æ—¥ PL/SQLç‰ã®ãƒãƒƒãƒå‡¦ç†ã§ãŸã¾ã«è¦‹ã‹ã‘る最悪ãªãƒ—ãƒã‚°ãƒ©ãƒ 今日ã¯ãƒ—ãƒã‚°ãƒ©ãƒ ã®è©± & 愚痴。 DBæ›´æ–°ãªã©ã®ãƒãƒƒãƒå‡¦ç†ã§ Pro*C 使ã£ã¦ãŸã‚Š PL/SQL 使ã£ã¦ãŸã‚Šã™ã‚‹ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã¯çµæ§‹å¤šã„ãŒã€ã‚ã»ã‹ã£ï¼ã¨æ€ã£ã¦ã—ã¾ã†ã“ã¨ãŒã‚る。ソースãŒæ±šã„ã¨ã‹ main() ã‚„ BEGIN END ã®é–“ã«å…¨éƒ¨ã®å‡¦ç†æ›¸ã„ã¦ã‚‹ã¨ã‹ã€ãã†ã„ã†ã®ã¯ã¾ã 我慢ã§ãã‚‹(ã¦ã„ã†ã‹ã€å…¨éƒ¨ç›´ã—ã¦ã‚‹è¨³ã«ã¯ã„ã‹ãªã„ã®ã§)。ã§ã¯ã€ä½•ãŒæ°—ã«é£Ÿã‚ãªã„ã®ã‹ã¨è¨€ã†ã¨ãƒ«ãƒ¼ãƒ—ä¸ã«ãƒ•ã‚¡ã‚¤ãƒ«ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹æ„Ÿè¦šã§ SELECT å¥ç™ºè¡Œã—ã¦ãŸã‚Šã™ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ãŒçµæ§‹å¤šã„ã“ã¨ã€‚ ã¡ã‚‡ã£ã¨è€ƒãˆã‚Œã°ã‚ã‹ã‚‹ã ã‚ã†ï¼ã¨ã‹ã€ä»•æ§˜ã¯ã©ã†ãªã£ã¦ã‚“ã ï¼ã¨ã‹ã€ã‚½ãƒ¼ã‚¹ãƒ¬ãƒ“ューã®æ®µéšŽã§æ°—ã¥ã‹ãªã„ã‹ï¼Ÿã¨ã‹è‰²ã€…æ„見ã¯ã‚ã‚‹ã ã‚ã†ãŒã€ã¡ã‚‡ã£ã¨å¤§ãã‚ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãªã©ã§ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’丸投ã’ã—ãŸã‚Šã€ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«ç«ãŒã¤ã„ã¦ãƒ—ãƒã‚°ãƒ©ãƒžå¤§é‡æŠ•å…¥ã—ã¦è§£æ±ºã€ã¿ãŸã„
83's : MySQL
Gaucheã§MySQL/SQLiteã®å€‹äººçš„ã¾ã¨ã‚ February 05, 2008 21:49 Permalink Comments (0) Trackbacks (0) MySQL, SQLite, Gauche 大体使ã„æ–¹ãŒã‚ã‹ã£ã¦ããŸã€‚Gauche:DBI/DBD見れ㰠ã‚ã‹ã‚‹ã‘ã©ã€ä¸€å¿œæµã‚Œã‚’メモã£ã¦ãŠã。 MySQLã®ãƒ‰ãƒ©ã‚¤ãƒã¯DBI | dev | Kahua Projectã‹ã‚‰ã€SQLite3ã®ã¯ãã®ãƒšãƒ¼ã‚¸ã«è¦‹å½“ãŸã‚‰ãªã„ã®ã§uchizonoã«ã‚ã£ãŸã‚‚ã®ã‚’使ã‚ã›ã¦ã‚‚らãŸã€‚ レッツ・コãƒã‚¯ãƒˆã€‚ (use dbi) (define *mysql-con* (dbi-connect "dbi:mysql:db=test;host=localhost" :username "root" :password "himitsu")) (define *sqlite-con* (dbi-
[pgsql-jp: 29026] Like を使ã£ãŸå‰æ–¹ä¸€è‡´æ¤œç´¢æ™‚ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ä½¿ç”¨æ¡ä»¶ã«ã¤ã„ã¦
Hajime Lucky Okada pgsql[email protected]stgresql.jp Thu, 13 Feb 2003 17:28:33 +0900 å‰ã®è¨˜äº‹: [pgsql-jp: 29022] Re: VBA+ODBCã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’è¡Œã†ã«ã¯ 次ã®è¨˜äº‹: [pgsql-jp: 29027] Re: Like を使ã£ãŸå‰æ–¹ä¸€è‡´æ¤œç´¢æ™‚ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ä½¿ç”¨æ¡ä»¶ã«ã¤ã„㦠目次ã®é †: [ 日付 ] [ スレッド ] [ 件å ] [ 発信者 ] ã“ã‚“ã«ã¡ã¯ã€å²¡ç”°ã¨ç”³ã—ã¾ã™ã€‚ ãŠä¸–話ã«ãªã£ã¦ãŠã‚Šã¾ã™ã€‚ 表題ã®ä»¶ã«é–¢ã—ã€éžå¸¸ã«ã‚·ãƒ³ãƒ—ルãªãƒ†ãƒ¼ãƒ—ル構æˆã«é–¢ã‚ら㚠使用ï¼è¨å®šæ–¹æ³•ãŒæ‚ªã„ã®ã‹ã€äººé–“ã®æœŸå¾…ã—ãŸå‹•ãã‚’ã—ã¦ãã‚Œã¾ã›ã‚“。 ãã‚Œã¯ã€ã‚ã‚‹å˜ä¸€ã‚«ãƒ©ãƒ ã® % を使用ã—ãŸå‰æ–¹ä¸€è‡´ã®æ¤œç´¢ã§ã™ã€‚ 次ã«ç¤ºã™æ¤œç´¢å¯¾è±¡ã‚«ãƒ©ãƒ mitumori ã¯ã€text åž‹ã§å®Ÿè³ª 全㦠6 æ¡ã®è‹±æ–‡å—〠高々 1 万件程度ã§ã™
Tags: Database schemas
An online tech community is the most exciting place for a software developer to spend their time. It not only offers the chance to work and interact remotely, but also helps in honing one’s own skills and becoming a well-rounded programmer. Whether you are a budding software developer or simply passionate about technology, here are the best online software development communities you can join. The
MySQL æ–‡å—化ã‘å•é¡Œã‚’本気ã§ç›´ã™
mysql> status; -------------- mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i386) using readline 4.3 Connection id: 36 Current database: staff2006 Current user: maiha@localhost SSL: Not in use Current pager: lv Using outfile: '' Using delimiter: ; Server version: 4.1.20 Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client char
1
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
http://wota.jp/ac/?date=20070206
{{#tags}}- {{label}}
{{/tags}}