[B! sql] nbqx69ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

nbqx69 id:nbqx69

sqlã«é–¢ã™ã‚‹nbqx69ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (9)

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

ã‚¢ãƒŠãƒã‚°ãªSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ‰‹æ³•ãŒã™ã”ã„ä»¶ - YomuKaku Memo
è»Šã®ãƒŠãƒ³ãƒãƒ¼ãƒ—ãƒ¬ãƒ¼ãƒˆã®ä¸Šã‚ãŸã‚Šã«sql injectionç”¨ã®æ–‡å—åˆ—ã‚’è²¼ã£ã¦ã‚¹ãƒ”ãƒ¼ãƒ‰é•åæ¤œå‡ºç”¨ï¼ˆï¼Ÿï¼‰ã®ã‚«ãƒ¡ãƒ©ã«èªã¿è¾¼ã¾ã›ã€é›»å…‰æŽ²ç¤ºæ¿ã«ä»»æ„ï¼ˆã¨æ€ã‚ã‚Œã‚‹ï¼‰æ–‡å—ã‚’å‡ºåŠ›ã™ã‚‹æ”»æ’ƒã‚’ã—ã¦ã„ã‚‹äººãŒã„ãŸã‚ˆã†ã§ã™ã€‚ ç”»åƒã‚’è¦‹ã¦ã„ãŸã ãã“ã¨ãŒæ—©ã„ã§ã™ã€‚ Tumblrã§æµã‚Œã¦ã„ãŸç”»åƒãªã®ã§ã€ã‚½ãƒ¼ã‚¹ãŒã‚ã‹ã‚‰ãªã„ãŸã‚ã€ã²ã¨ã¾ãšãã®ã¾ã¾è»¢è¼‰ã—ã¾ã™ã€‚ å®Ÿéš›ã®å‡ºæ¥äº‹ãªã®ã‹ãƒ•ã‚£ã‚¯ã‚·ãƒ§ãƒ³ãªã®ã‹ã‚ã‹ã‚Šã¾ã›ã‚“ãŒâ€¦ã€‚ æ—¥æœ¬ã®Nã‚·ã‚¹ãƒ†ãƒ ã¨ã‹ã€ã‚„ã¯ã‚Šã“ã†ã„ã†ç©´ã¯ã‚ãƒãƒƒã¨å¡žã„ã§ã‚ã‚‹ã‚“ã§ã—ã‚‡ã†ã‹ã€‚
nbqx69 2011/02/10
ã‹ã£ã‘ãƒ¼

sql
ãƒªãƒ³ã‚¯
Coming soon
Stay tuned.... More clojure stuff coming soon
nbqx69 2009/12/13
clojure

db

sql
ãƒªãƒ³ã‚¯
Even More Ambitious â€” err.the_blog
Things are really looking up for Ambition. Itâ€™s been almost two weeks since the initial release and I thought I would catch yâ€™all up on the progress weâ€™ve made. The current version is 0.2.2, so grab that while you can and follow along. Supplies are limited. $ sudo gem install ambition -y Databaseinâ€™ Ambition has gone from generating generic SQL to respecting your database of choice (as long as itâ€™
nbqx69 2007/12/04
ruby

sql

database

gem

plugin
ãƒªãƒ³ã‚¯
Full of Ambition â€” err.the_blog
This idea has been kicked around a whole lot, I know. In IRC. Dark alleyways. Sweaty dance halls. Courts of law. Itâ€™s this: instead of writing SQL, write Ruby. Generate the SQL behind the curtain. Something like this: User.detect { |u| u.name == 'Jericho' && u.age == 22 } Or this: User.select { |u| [1, 2, 3, 4].include? u.id } Or even this: User.select { |u| u.name =~ 'rick' }.sort_by(&:age) Itâ€™d
nbqx69 2007/08/31
ruby

dsl

sql

gem
ãƒªãƒ³ã‚¯
my I/O: Archive
Published sporadically by Patrick Quinn-Graham
nbqx69 2007/06/08
google

javascript

sql

gears
ãƒªãƒ³ã‚¯
ãã‚ŒAutomatorã§ã§ãã‚‹ã‚ˆ - NullPointer's
http://www.hawkwings.net/2007/03/01/a-faster-way-to-speed-up-mailapp/ ã‚ã¡ã“ã¡ã®ãƒ–ãƒã‚°ã§ç´¹ä»‹ã•ã‚Œã¦ã„ã¾ã™ãŒã€Mail.appãŒä½¿ç”¨ã—ã¦ã„ã‚‹SQLiteã«å¯¾ã—ã¦VACUUMã‚’ç™ºè¡Œã—ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ•´ç†ã—ã¦Mailã‚’é«˜é€ŸåŒ–ã™ã‚‹ã¨ã„ã†Tipsã€‚ã“ã‚Œã‚’Automatorã«ã‚„ã‚‰ã›ã¦ã¿ã¾ã—ãŸã€‚ Automatorã«ã¯SQLiteã®ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã™ã‚‹ã‚¢ã‚¯ã‚·ãƒ§ãƒ³ãŒã‚ã‚‹ï¼ˆè¦XCodeã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ï¼‰ã®ã§ã€ãƒ¯ãƒ¼ã‚¯ãƒ•ãƒãƒ¼ã«ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã—ã‹ã—ã€ã“ã‚“ãªäº‹ã‚„ã‚ã†ã¨æ€ã†äººãªã‚‰Terminalã§ã‚³ãƒžãƒ³ãƒ‰æ‰“ã£ãŸã»ã†ãŒæ¥½ã§ã—ã‚‡ã†ã—ã€ç¹°ã‚Šè¿”ã—è¡Œã†ä½œæ¥ã§ã¯ãªã„ã®ã§Automatorã§ã‚„ã‚‹æ„å‘³ãªã„ã§ã™ã‚ˆã€‚çªã£è¾¼ã¾ã‚Œã‚‹å‰ã«å¿µã®ãŸã‚ã€‚ ã€ŒæŒ‡å®šã•ã‚ŒãŸFinderé …ç›®ã‚’å–å¾—ã€ã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã«ã€/Users/your account/Library/Mail/Envelo
nbqx69 2007/03/06
Mail.appãŒä½¿ç”¨ã—ã¦ã„ã‚‹SQLiteã«å¯¾ã—ã¦VACUUMã‚’ç™ºè¡Œã—ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ•´ç†ã—ã¦Mailã‚’é«˜é€ŸåŒ–ã™ã‚‹ã¨ã„ã†Tipsã€‚ã“ã‚Œã‚’Automatorã«ã‚„ã‚‰ã›ã¦ã¿ã¾ã—ãŸã€‚

automator

osx

mail

sql
ãƒªãƒ³ã‚¯
SQLite/Ruby - Ruby
è»½é‡ãƒ»é«˜é€Ÿãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹SQLiteã‚’Rubyã‹ã‚‰æ‰±ã†ãŸã‚ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« Windowsã®å ´åˆ RubyForgeã‹ã‚‰ã€ sqlite3-ruby(sqlite3-ruby-x.x.x.zip)ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸãƒ•ã‚¡ã‚¤ãƒ«ã‚’å±•é–‹ã™ã‚‹ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’å®Ÿè¡Œã™ã‚‹ã€‚ ruby setup.rb config ruby setup.rb setup ruby setup.rb install RubyGemsã‚’ä½¿ã†å ´åˆ RubyGemsã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸå¾Œã€ æ¬¡ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã™ã‚‹ã€‚ gem install sqlite3-ruby SQLiteã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« SQLite Download Pageã‹ã‚‰ã€ sqlitedll-3_x_x.zipã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸãƒ•ã‚¡ã‚¤ãƒ«ã‚’å±•é–‹ã™ã‚‹ã€‚ sqlite.dllã‚’ãƒ‘ã‚¹ã®é€šã£ãŸãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ã‚³ãƒ”
nbqx69 2006/02/24
ä¸€å¿œä»•äº‹ãƒ¡ãƒ¢ã€‚

ruby

sql

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

ä»•äº‹
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
nbqx69 2006/02/24
ç ”ä¿®ç”¨ãƒã‚¿ã€‚

RDB

sql

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

ä»•äº‹
ãƒªãƒ³ã‚¯
çŸ³æ²³åå¸‚åŽæ´‹ç½‘ç»œæœ‰é™å…¬å¸
ï¼œdiv class="fr tt_word yah" module-fid="topnews" zy-fid="zy"ï¼ž ï¼œdiv class="fr wl-live-r"ï¼ž ï¼œdiv class="fr"ï¼ž ï¼œdiv class="frame"ï¼ž ï¼œdiv class="friendlink_bd"ï¼ž ï¼œdiv class="ftglist"ï¼ž ï¼œdiv class="fundIqeClist tlfdM pcNone"ï¼ž ï¼œdiv class="fundselect"ï¼ž ï¼œdiv class="funlist"ï¼ž ï¼œdiv class="g-15"ï¼ž ï¼œdiv class="g-18"ï¼ž é‡åº†èŠ±è‰ºå¦æ ¡ æ–°è¾‰æ•™è‚²åŸ¹è®ä¸å¿ƒ é‡åº†é’ˆç¸å¦æ ¡ å¹¿ä¸œçœäººåŠ›èµ„æºåŸ¹è® æ˜Žæ˜Ÿå©åå¦æ ¡ ä»²æ˜Žæ²™ç”»åŸ¹è®ç é’å²›é›…æ€åŸ¹è®æœºæž„æŽ’å é»„çŸ³plcåŸ¹è® æ°‘åŠžå¦æ ¡äº¤ç¨Žå— å¦æ ¡ç”¨é—®å· å¦æ ¡ä¸å±‚å¹²éƒ¨ç®¡ç† äº®åæ²³å¦æ ¡ è¥¿å®‰è›‹
nbqx69 2006/02/24
ä»•äº‹ç”¨ã€‚

java

sql

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

ä»•äº‹
ãƒªãƒ³ã‚¯
1