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

sugyan id:sugyan

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

${{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ã§Quineæ›¸ã„ãŸã‹ã‚‰è¦‹ã¦è¦‹ã¦ - ã‚¨ãƒ ã‚¹ãƒªãƒ¼ãƒ†ãƒƒã‚¯ãƒ–ãƒã‚°
ã“ã®ãƒ†ãƒƒã‚¯ãƒ–ãƒã‚°ã‚’ã€Œquineã€ã§æ¤œç´¢ã—ã¦ã„ãŸã ãã¨ã‚ã‹ã‚‹ã‚“ã§ã™ãŒã€ã‚¨ãƒ ã‚¹ãƒªãƒ¼ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¯ã‚ã‚Šã¨Quineå¥½ãã§ã™ã€‚Quineï¼ˆã‚¯ãƒ¯ã‚¤ãƒ³ï¼‰ã¨ã¯ã€æ–‡å—åˆ—ã‚’æ‰“ã¡å‡ºã™ã ã‘ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã§ã‚ã£ã¦ãã®æ‰“ã¡å‡ºã—ãŸæ–‡å—åˆ—ã¨ã„ã†ã®ãŒè‡ªèº«ã®ã‚³ãƒ¼ãƒ‰ãã®ã‚‚ã®ã«ãªã£ã¦ã„ã‚‹ã‚ˆã†ãªã‚‚ã®ã®ã“ã¨ã§ã™ã€‚ Perl, Python, Rubyãªã©ã€æ‰‹ç¶šãåž‹è¨€èªžã§æ›¸ã‹ã‚Œã‚‹ã“ã¨ã®å¤šã„Quineãªã®ã§ã™ãŒã€æ—¥é ƒæ¥å‹™ã§SQLã‚’æ‰±ã†ã“ã¨ã®å¤šã„ç§ã¯æ€ã†ã‚ã‘ã§ã™ã€‚SQLã ã£ã¦æ–‡å—åˆ—ã‚’å‡ºåŠ›ã§ãã‚‹è¨€èªžã ãžã€Quineæ›¸ã‘ã‚‹ã‚“ã˜ã‚ƒã¨ã€‚ã‚¨ãƒ ã‚¹ãƒªãƒ¼ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ã‚°ãƒ«ãƒ¼ãƒ—Unit1ï¼ˆè£½è–¬ãƒ—ãƒãƒ¢ãƒ¼ã‚·ãƒ§ãƒ³ï¼‰ï¼Unit9ï¼ˆæ²»é¨“è‡¨åºŠç ”ç©¶æ”¯æ´ï¼‰ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ä¸‰æµ¦[è¨˜äº‹ä¸€è¦§ ï€‰]ã§ã™ã€‚æ—¥é ƒã®ãŠä»•äº‹ã‹ã‚‰ã¯é›¢ã‚Œã¦SQLã§Quineã‚’æ›¸ã„ã¦éŠã‚“ã§ã¿ã¾ã—ãŸã€‚ åŸºæœ¬æ–¹é‡ ã‚„ã£ã¦ã„ã ã‚³ãƒ¼ãƒ‰å†…ã«ã‚·ãƒ³ã‚°ãƒ«ã‚¯ã‚©ãƒ¼ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æ›¸ã‹ãªã„ ãƒ—ãƒã‚°ãƒ©ãƒ ã®å…ˆé å´ã¨æœ«å°¾å´ã‚’ã²ã¨ã¤ã®æ–‡å—åˆ—ãƒ‡
sugyan 2025/05/08
sql

quine
ãƒªãƒ³ã‚¯
SQL Training 2021
Transcript SQL æ ªå¼ä¼šç¤¾ AI Shift ä¸‰å®… æ‚ å¤ª 1. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ 2. SQL I 3.ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ 4. ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆ 5. ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ 6. å®Ÿè¡Œè¨ˆç”» 7. SQL II ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ â€œA database is an organized collection of inter-related data that models some aspect of the real-world â€œ (CMU) ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ã€å®Ÿä¸–ç•Œã®ã‚ã‚‹å´é¢ã‚’ãƒ¢ãƒ‡ãƒ«åŒ–ã—ãŸã€ç§©åº ã ã£ãŸã€ç›¸äº’ã«é–¢é€£ã—ãŸãƒ‡ãƒ¼ã‚¿ã®é›†ã¾ã‚Š DBMS â€¢ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆDBMSï¼‰ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç®¡ç†ã™ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ â—¦ ä¾‹ï¼šMySQL, Oracle Database, SQLite, Mongo DB â€¢ DBMSã®ç›®çš„ã¯ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒç°¡å˜ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãƒ‡ãƒ¼
sugyan 2021/06/24
sql

database

education
ãƒªãƒ³ã‚¯
scheman diff - âœ˜â•¹â—¡â•¹âœ˜
https://github.com/r7kamura/scheman æ—…è¡Œã‚’å…¼ãã¦æ²–ç¸„ã«é–‹ç™ºåˆå®¿ã«æ¥ã¦ã„ã‚‹ã®ã§ã€1æ—¥ç›®ã®æˆæžœã‚’æ›¸ãå‡ºã—ã¦ãŠãã€‚ ç›®çš„ Webã‚¢ãƒ—ãƒªã®é–‹ç™ºãƒ•ãƒãƒ¼ã§æ¬¡ã®ã‚ˆã†ãªçŠ¶æ…‹ã‚’å®Ÿç¾ã—ãŸã„ã€‚ DBã®å¤‰æ›´ã®ãŸã³ã«å¤‰æ›´ç”¨ã®SQLã‚„Migrationãƒ•ã‚¡ã‚¤ãƒ«ã‚’äººé–“ãŒæ›¸ã‹ãªãã¦è‰¯ã„ migrationãƒ•ã‚¡ã‚¤ãƒ«ã‚’æ›¸ãä»£ã‚ã‚Šã«äººé–“ã¯ã‚¹ã‚ãƒ¼ãƒžã‚’ç·¨é›†ã™ã‚‹ ã‚¹ã‚ãƒ¼ãƒžã¯SQLã§è¨˜è¿°ã§ãã‚‹ (DSLã®ä½¿ç”¨ã‚’å¼·åˆ¶ã•ã‚Œãªã„) SQLä»¥å¤–ã®è¨€èªžã§ã‚‚è¨˜è¿°ã§ãã‚‹ (DSLã‚’ä½¿ç”¨ã—ã¦ã‚‚è‰¯ã„) æ–¹é‡ æ¬¡ã®ã‚ˆã†ãªå®Ÿè£…ã‚’è©¦ã¿ãŸã€‚ SQLã‚’æ§‹æ–‡è§£æžã—ã¦ã‚¹ã‚ãƒ¼ãƒžãƒ‡ãƒ¼ã‚¿ã«å¤‰æ›ã™ã‚‹ (è§£æžå™¨ã¯äº‹å‰ã«å®Ÿè£…æ¸ˆã¿) é©ç”¨ã™ã¹ãSQLã‚’2ã¤ã®ã‚¹ã‚ãƒ¼ãƒžãƒ‡ãƒ¼ã‚¿ã®å·®åˆ†ã‹ã‚‰è‡ªå‹•ã§è¨ˆç®—ã™ã‚‹ SQLä»¥å¤–ã®è§£æžå™¨ã‚‚ä½œæˆå¯èƒ½ã« scheman diff scheman diffã¨ã„ã†ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè£…ã—ãŸã€‚ ã“ã‚Œã¯å¤‰æ›´å‰å¾Œã®äºŒã¤ã®ã‚¹ã‚ãƒ¼ãƒžã®å·®åˆ†ã‚’æ¨™
sugyan 2014/07/15
æ²–ç¸„ã„ããŸã„

sql

diff

ruby

okinawa
ãƒªãƒ³ã‚¯
ãƒ¦ãƒ¼ã‚¶ç”±æ¥ã®æ§‹é€ åŒ–ãƒ‡ãƒ¼ã‚¿ã«ã‚ˆã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ - æ°¾æ¿«åŽŸ
Kazuho's Weblog: The JSON SQL Injection Vulnerability ã«ã¤ã„ã¦ã€‚å…ƒè¨˜äº‹ã‚’ã¯ã£ã¡ã‚ƒã‚ã£ã¡ã‚ƒã«è¦ç´„ã™ã‚‹ã¨ SQL::Maker ã«ãƒ¦ãƒ¼ã‚¶ã‹ã‚‰å—ã‘ã¨ã£ãŸãƒ‡ã‚³ãƒ¼ãƒ‰æ¸ˆã¿ JSON ã‚’ãã®ã¾ã¾çªã£è¾¼ã‚€ã¨ SQL ã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«ãªã‚‹å ´åˆãŒã‚ã‚‹ SQL::Maker å´ã§ãã†ã„ã£ãŸã“ã¨ãŒèµ·ã“ã‚‰ãªã„ã‚ˆã†ã« strict ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ã¤ã‘ãŸã‹ã‚‰ã€ã§ãã‚Œã°ãã£ã¡ä½¿ãˆ åˆ¥ã« SQL::Maker ã«é™ã‚‰ãªã„ã‹ã‚‰æ°—ã‚’ã¤ã‘ã‚ ã¨ã„ã†è©±ã£ã½ã„ã€‚æœ¬æ¥ã§ã‚ã‚Œã°ãƒ¦ãƒ¼ã‚¶å…¥åŠ›ã‚’ã‚¿ã‚¤ãƒ—ãƒã‚§ãƒƒã‚¯ã‚’ã™ã¹ãã ã‘ã©ã€ã‚¯ã‚¨ãƒªãƒ“ãƒ«ãƒ€ãƒ¬ãƒ™ãƒ«ã§ã‚‚ã€è„†å¼±æ€§ã«ãªã‚‰ãªã„ã‚ˆã†ã«ã‚‚ã†ã¡ã‚‡ã£ã¨è€ƒæ…®ã—ã¦ã‚‚ã„ã„ã‚ˆãã¨ã„ã†è¶£æ—¨ã‹ãªâ€¦ strict ãƒ¢ãƒ¼ãƒ‰ã¯éžäº’æ›ãªã®ã§ã€æ—¢å˜ã®ã‚³ãƒ¼ãƒ‰ãŒå‹•ã‹ãªããªã‚‹å¯èƒ½æ€§ãŒã‚ã‚‹ã‚ˆã†ã§ã™ã€‚ Teng ã§ã®å¯¾å¿œ Teng ã‚’ä½¿ã£ã¦ã„ã‚‹ã¨ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ SQL::Maker ãŒã‚¯ã‚¨ãƒªãƒ“
sugyan 2014/07/03
JSON

sql

security

Teng
ãƒªãƒ³ã‚¯
DeNA Engineering - DeNAã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãƒãƒ¼ã‚¿ãƒ«ã‚µã‚¤ãƒˆ
æŠ€è¡“ã‚’æ´»ã‹ã—ã€æ–°ã—ã„ä¾¡å€¤ã‚’å‰µé€ ã™ã‚‹ DeNAã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¯ã€æƒ³åƒã‚’è¶…ãˆã‚‹Delightã‚’å±Šã‘ã‚‹ãŸã‚ã«ä½•ãŒã§ãã‚‹ã‹ã‚’è€ƒãˆã€æŠ€è¡“åŠ›ã¨ç™ºæƒ³åŠ›ã§æ–°ã—ã„ä¾¡å€¤ã‚’ç”Ÿã¿å‡ºã—ã¦ã„ã¾ã™ã€‚ å¤šæ§˜ãªå°‚é–€æ€§ã‚’æŒã£ãŸã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒåˆ‡ç£‹ç¢ç£¨ã—ã€äº’ã„ã«åˆºæ¿€ã—åˆãˆã‚‹ç’°å¢ƒã‚„åˆ¶åº¦ãŒã•ã‚‰ãªã‚‹æˆé•·ã¸ã¨ã¤ãªã’ã¾ã™ã€‚
sugyan 2014/07/03
JSON

sql

security
ãƒªãƒ³ã‚¯
The JSON SQL Injection Vulnerability
tl;dr Many SQL query builders written in Perl do not provide mitigation against JSON SQL injection vulnerability. Developers should not forget to either type-check the input values taken from JSON (or any other hierarchical data structure) before passing them to the query builders, or should better consider migrating to query builders that provide API immune to such vulnerability. Note: å•é¡Œã®ç™ºè¦‹è€…ã«ã‚ˆã‚‹æ—¥
sugyan 2014/07/01
JSON

sql

security
ãƒªãƒ³ã‚¯
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã«ã¤ã„ã¦
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
sugyan 2013/12/16
sql

security
ãƒªãƒ³ã‚¯
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚´ãƒ«ãƒ• - ãªã‚“ã¨3æ–‡å—ã§èªè¨¼å›žé¿ãŒå¯èƒ½ã«
æ˜¨æ—¥ã®ã‚¨ãƒ³ãƒˆãƒªã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚´ãƒ«ãƒ• - èªè¨¼å›žé¿ã®æ”»æ’ƒæ–‡å—åˆ—ã¯ã©ã“ã¾ã§çŸãã§ãã‚‹ã‹?ã€ã«ã¦ã€èªè¨¼å›žé¿ã®æ”»æ’ƒæ–‡å—åˆ—ãŒ5æ–‡å—ã«ã§ãã‚‹ï¼ˆã€Œ'OR'1ã€ï¼‰ã“ã¨ã‚’ç¤ºã—ã¾ã—ãŸãŒã€@masa141421356ã•ã‚“ã¨ã€ã‚„ã¾ã–ãã•ã‚“ï¼ˆãŠäºŒäººã¨ã‚‚æ‹™è‘—ã®ãƒ¬ãƒ“ãƒ¥ã‚¢ãƒ¼ã§ã™ï¼‰ã‹ã‚‰ã€idã¨pwdã«ã¾ãŸãŒã£ãŸæ”»æ’ƒä¾‹ã‚’ç¤ºã—ã¦ã„ãŸã ãã¾ã—ãŸã€‚ã‚„ã¾ã–ãã•ã‚“ã®ä¾‹ã¯ã€MySQLé™å®šãªãŒã‚‰ã€ãªã‚“ã¨3æ–‡å—ã§ã™ã€‚ã“ã‚Œã¯ã™ã”ã„ã€‚ @masa141421356ã•ã‚“ã®æ”»æ’ƒä¾‹ @masa141421356ã•ã‚“ã®ãƒ„ã‚¤ãƒ¼ãƒˆã‚’å¼•ç”¨ã—ã¾ã™ã€‚ @ockeghem å¤§æŠµã®DBã§id=''OR' AND pwd='>' ' ãŒé€šã‚‹ã¨æ€ã„ã¾ã™ï¼ˆidå´ã«ã€Œ'ORã€, pwdå´ã«ã€Œ>' ã€ã§6æ–‡å—ï¼‰ã€‚é•·ã•0ã®æ–‡å—åˆ—ãŒNULLæ‰±ã„ã•ã‚Œãªã„DBãªã‚‰æœ€å¾Œã®ã‚¹ãƒšãƒ¼ã‚¹ã‚’æ¶ˆã—ã¦5æ–‡å—ã§ã™ã€‚ â€” masa141421356 (@masa141421356) June
sugyan 2013/06/25
sql

golf
ãƒªãƒ³ã‚¯
DBIx::QueryLogã‚’ä½¿ã£ã¦ã¡ã‚ƒã‚“ã¨SQLãŒæµã‚Œã¦ã„ã‚‹ã‹ãƒ†ã‚¹ãƒˆã™ã‚‹ - $shibayu36->blog;
DBIã®connectã®Callbacksãªã©ã§SQLã‚’å®Ÿè¡Œã—ã¦ã„ã‚‹æ™‚ã¨ã‹ã«ã€å®Ÿéš›ã«SQLãŒæµã‚Œã¦ã„ã‚‹ã®ã‹ãƒã‚§ãƒƒã‚¯ã—ãŸã„æ™‚ãŒã‚ã‚‹ã€‚ãã†ã„ã†æ™‚ã©ã†ã™ã‚‹ã®ãŒãƒ™ã‚¹ãƒˆãƒ»ãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ãªã®ã‹ã‚ã‹ã‚‰ãªã„ã®ã ã‘ã©ã€DBIx::QueryLogã‚’ä½¿ã£ãŸã‚‰ä¸€å¿œã§ããŸã®ã§ãƒ¡ãƒ¢ã€‚ ãƒ†ã‚¹ãƒˆã—ãŸã„çŠ¶æ³ package My::DBI; use strict; use warnings; use DBI; sub connect { my ($dsn, $username, $password) = @_; my $dbh = DBI->connect($dsn, $username, $password, { Callbacks => { connected => sub { my $dbh = shift; $dbh->do("SET NAMES utf8") or warn $dbh->errstr; retur
sugyan 2013/01/10
perl

DBI

sql

test
ãƒªãƒ³ã‚¯
** YAPC::Asia Tokyo 2011 RejectConf æœ¬å½“ã¯é›£ã—ã„ãƒ•ãƒ¬ãƒ³ãƒ‰ãƒ»ã‚¿ã‚¤ãƒ ãƒ©ã‚¤ãƒ³å‡¦ç†
TopicsPlaceHolder SectionTitlePlaceHolder TIME rest time current/total
sugyan 2011/10/13
yapcasia

kamipo

yapcasia2011

sql
ãƒªãƒ³ã‚¯
ã‚¢ãƒ—ãƒªé–‹ç™ºè€…ã‚ˆã‚Šã®DBå‹‰å¼·ä¼šã‚’ã‚„ã‚ŠãŸã„ã€ã¨ã„ã†ã‹ã‚„ã‚‹ - åˆ†ã‘å…¥ã£ã¦ã‚‚ã‚³ãƒ¼ãƒ‰
çµè«– SQLãŒã©ãƒ¼ã®ãƒ‡ãƒ¼ã‚¿ã®æŒã¡æ–¹ãŒã“ãƒ¼ã®ã¨ã„ã†ã‚¢ãƒ—ãƒªé–‹ç™ºå´ã®è©±é¡ŒãŒãƒ¡ã‚¤ãƒ³ã®DBå‹‰å¼·ä¼šã‚’ã‚„ã‚ŠãŸã„ã‹ã‚‰ã‚„ã‚‹ã‚ˆã¨ã„ã†è©± ä»¥ä¸‹è£œè¶³ ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ ã‚¢ãƒ—ãƒªé–‹ç™ºè€…ãŒDBã‚’æ¡ã‚‰ãªã‘ã‚Œã°ãªã‚‰ãªã„æ™‚ä»£ DBã‚’æ¡ã‚‹ã¨ã„ã†ã“ã¨ å‹‰å¼·ä¼šã«ã¤ã„ã¦ ã‚¢ãƒ—ãƒªé–‹ç™ºè€…ãŒDBã‚’æ¡ã‚‰ãªã‘ã‚Œã°ãªã‚‰ãªã„æ™‚ä»£ ãƒ‡ãƒ¼ã‚¿çˆ†ç™ºã®æ™‚ä»£ ãƒ‡ãƒ¼ã‚¿çˆ†ç™ºã®æ™‚ä»£ãŒãã‚‹ã¨è¨€ã‚ã‚Œã¦ä¹…ã—ã„ã§ã™ã€‚æ‰±ã†ãƒ‡ãƒ¼ã‚¿ã®é‡ãŒå¢—ãˆã¦ãã¦ã„ã‚‹ã ã‘ã§ãªãã€ãƒ‡ãƒ¼ã‚¿ã®æ§‹é€ ã‚‚å¤šç¨®å¤šæ§˜ã«ãªã£ã¦ãã¦ã„ã‚‹ã¨æ„Ÿã˜ã¦ã„ã¾ã™ã€‚ã“ã‚Œã¾ã§ã¯One Size Fits Allã§RDBãŒå¯¾å¿œã—ã¦ããŸã®ãŒã€å¢—åŠ ã—è¤‡é›‘åŒ–ã—ã¦ã„ããƒ‡ãƒ¼ã‚¿ã«RDBã®ã¿ã§ã¯å¯¾å¿œã—ãã‚Œãªããªã£ã¦ãã¦ã„ã‚‹ç‚ºã«NoSQLã®ã‚ˆã†ãªãƒ—ãƒãƒ€ã‚¯ãƒˆãŒç››ã‚“ã«é–‹ç™ºã•ã‚Œåˆ©ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã‚¢ãƒ—ãƒªé–‹ç™ºè€…ã¨ã—ã¦ã‚„ã‚‹ã¹ãã“ã¨ ãã†ã„ã£ãŸæ™‚ä»£ã‚’è¿Žãˆã‚‹ã«ã‚ãŸã£ã¦ã€ã‚¢ãƒ—ãƒªé–‹ç™ºè€…ã¯ä½•ã‚‚å‚™ãˆãªãã¦ã„ã„ã‚“ã§ã—ã‚‡ã†ã‹ï¼ŸDBã¯ã‚¤ãƒ³ãƒ•ãƒ©/ã‚µãƒ¼ãƒãƒ¼ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ã‚‚ã®ï¼Ÿ åƒ•ã¯ã€ŒD
sugyan 2011/06/27
é¢ç™½ãã†ï¼

sql

db

å‹‰å¼·ä¼š
ãƒªãƒ³ã‚¯
SQLã§incrementã—ãŸå€¤ã‚’è¡¨ç¤ºã™ã‚‹ã‚„ã¤ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
MacBook Air 11ã‚¤ãƒ³ãƒæ¬²ã—ã„ï¼ @sugyanã•ã‚“ã®SQLã§incrementã—ãŸå€¤ã‚’è¡¨ç¤ºã™ã‚‹æ–¹æ³•ã‚’è€ƒãˆã‚‹ - ã™ãŽã‚ƒãƒ¼ã‚“ãƒ¡ãƒ¢ã‚’ç”ŸDBIã§ã‚„ã£ã¦ã¿ãŸã®ã¨ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã¨ã£ã¦ã¿ãŸã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãªã— Rate dbic teng dbi1 dbi2 dbic 578/s -- -64% -92% -92% teng 1587/s 175% -- -78% -79% dbi1 7143/s 1136% 350% -- -7% dbi2 7692/s 1231% 385% 8% --ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚ã‚Š Rate dbic teng dbi1 dbi2 dbic 581/s -- -59% -88% -92% teng 1429/s 146% -- -71% -81% dbi1 5000/s 760% 250% -- -35% dbi2 7692/s 1223% 438% 54%
sugyan 2011/01/24
kamipo

dbi

sql

benchmark
ãƒªãƒ³ã‚¯
ã«ã²ã‚Šãšã‚€::ã—ã‚“ã·ã‚‹ - DBI ã§å®Ÿéš›ã«ç™ºè¡Œã•ã‚Œã‚‹ã‚¯ã‚¨ãƒªãƒ¼ã‚’å–å¾—ã™ã‚‹ DBIx::QueryLog ã‚’æ›¸ã„ãŸ
å£ç¯€ãŒå¤‰ã‚ã£ã¦ã€æ—©é€Ÿé¢¨é‚ªã‚’ã²ã„ã¦ã„ã¾ã™ã€‚ ã•ã¦ã€ã‚‚ã†ç§‹ã‚’é€šã‚Šè¶Šã—ã¦å†¬ã®æ§˜ç›¸ã‚’å‘ˆã—ã¦ããŸæ˜¨ä»Šã§ã¯ã‚ã‚Šã¾ã™ãŒã€DBI ã§ã¯ã€æ™®é€šã¯ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã‚’ä½¿ã„ my $stmt = 'SELECT * FROM user WHERE user_id = ?'; my @bind = ($user_id); $dbh->do($stmt, undef, @bind); ã¨ã‹æ›¸ãã¨æ€ã„ã¾ã™ã€‚ ã“ã®ã¨ãã«ã€å®Ÿéš›ã«ãƒã‚¤ãƒ³ãƒ‰ã•ã‚ŒãŸå¾Œã® SQL ã‚’ã¿ãŸã„ãªãƒ¼ã£ã¦è¡å‹•ã«é§†ã‚‰ã‚Œã‚‹ã¨æ€ã„ã¾ã™ãŒ*1ã€ã©ã†é ‘å¼µã£ã¦ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’èªã‚“ã§ã‚‚ã‚ã‹ã‚Šã¾ã›ã‚“ãã€‚ ã“ã†ã„ã†ã¨ãã¯ä»•æ–¹ãªã„ã®ã§ã€$stmt ã¨ @bind ã‚’ä¸¡æ–¹ãƒã‚°ã«å‡ºã—ã¦ãŠèŒ¶ã‚’æ¿ã—ã¦ã„ã¾ã—ãŸã€‚ $self->log->_dump($stmt, @bind); # => SELECT * FROM user WHERE user_id = ?, [1234] ã§ã‚‚ã“ã‚Œã£
sugyan 2010/11/04
perl

DBI

xaicron

sql
ãƒªãƒ³ã‚¯
1