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

xaicron id:xaicron

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

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

(DBD::)SQLiteã«ãŠã‘ã‚‹ORDER BYã®æœ€é©åŒ–ã¨æ¤œç´¢çµæžœã®ä¸¦ã³é †ã«ã¤ã„ã¦ - Charsbar::Note
æœ€åˆã«çµè«–ã‚’æ›¸ã„ã¦ãŠãã¾ã™ãŒã€ã“ã‚Œã¯æ£ã—ã„ä½¿ã„æ–¹ã‚’ã§ãã¦ã„ã‚‹æ–¹ãªã‚‰ã¾ã£ãŸãæ°—ã«ã™ã‚‹å¿…è¦ãŒãªã„è¨˜äº‹ã§ã™ã€‚è¦ã™ã‚‹ã«ã€ŒORDER BYã‚’æŒ‡å®šã—ã¦ã„ãªã„ã®ã«SELECTæ–‡ã®è¿”å€¤ã«ä¸€å®šã®ä¸¦ã³é †ã‚’æœŸå¾…ã™ã‚‹æ–¹ãŒé–“é•ã„ã€ã¨ã„ã†ã ã‘ã®è©±ãªã‚“ã§ã™ãŒã€å…ˆæ—¥ã®QA Hackathonã§æ½œåœ¨çš„ãªå•é¡ŒãŒå˜åœ¨ã—ã¦ã„ã‚‹ã“ã¨ãŒæµ®ãå½«ã‚Šã«ãªã£ãŸã®ã§ã€å¿µã®ãŸã‚å…±æœ‰ã—ã¦ãŠãã¾ã™ã€‚ ã•ã¦ã€SQLiteã¯2012å¹´12æœˆ12æ—¥ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³3.7.15ã§ã‚¯ã‚¨ãƒªã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã‚’å¼·åŒ–ã—ã€ãã®çµæžœã€ORDER BYãŒã‚ˆã‚Šç©æ¥µçš„ã«æœ€é©åŒ–ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ ãŸã ã€DBD::SQLiteã¯ã—ã°ã‚‰ããƒªãƒªãƒ¼ã‚¹ã‹ã‚‰é ã–ã‹ã£ã¦ã„ãŸãŸã‚ã€ã“ã®å¤‰æ›´ãŒPerlç•Œéšˆã®é–‹ç™ºè€…ã®ç›®ã«è§¦ã‚Œã‚‹ã‚ˆã†ã«ãªã£ãŸã®ã¯ã¤ã„æœ€è¿‘ã€2013å¹´4æœˆ4æ—¥ã«1.38_02ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã¨ãã®ã“ã¨ã§ã—ãŸã€‚ ã“ã®ã¨ãã©ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®ã©ã®ãƒ†ã‚¹ãƒˆãŒã“ã‘ã‚‹ã‚ˆã†ã«ãªã£ãŸã®ã‹ã¯ã¾ã
xaicron 2013/04/30
ã“ã‚Œã¯ãƒãƒžã‚ŠãŒã¡

sqlite

perl
ãƒªãƒ³ã‚¯
ã“ã“ã¾ã§ã‚„ã‚‹ã‹ã€‚SQLiteã‚’JavaScriptã«å¤‰æ›Â·SQL.js MOONGIFT
SQL.jsã¯SQLiteã‚’Emscriptenã‚’ä½¿ã£ã¦JavaScriptåŒ–ã—ãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ SQL.jsã¯Webãƒ–ãƒ©ã‚¦ã‚¶ä¸Šã§ä½¿ãˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ã€‚Emscriptenã‚’ä½¿ã£ã¦SQLiteã‚’JavaScriptã«å¤‰æ›ã—ãŸé¢ç™½ã„ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ ãƒ‡ãƒ¢ã§ã™ã€‚ãƒ†ã‚ã‚¹ãƒˆã‚¨ãƒªã‚¢ã«æ›¸ã‹ã‚ŒãŸSQLã‚’å®Ÿè¡Œã§ãã¾ã™ã€‚ å®Ÿè¡Œã—ãŸçµæžœã§ã™ã€‚æœ€çµ‚çš„ãªçµæžœã ã‘ãŒå‡ºåŠ›ã•ã‚Œã¦ã„ã¾ã™ã€‚SELECTã®çµæžœã¯JSONãƒ‡ãƒ¼ã‚¿ã¨ã—ã¦å–å¾—ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã‚‚ã¡ã‚ã‚“æ™®é€šã«SQLãŒä½¿ãˆã¾ã™ã€‚ æ—¥æœ¬èªžã¯å‡ºåŠ›æ™‚ã¯åŒ–ã‘ã¦ã—ã¾ã„ã¾ã—ãŸãŒãƒ‡ãƒ¼ã‚¿ä¸Šã¯å•é¡Œãªã„ã¨æ€ã‚ã‚Œã¾ã™ã€‚ SQL.jsã¯SQLiteãŒãã®ã¾ã¾JavaScriptã«ãªã£ã¦ã—ã¾ã£ãŸã‚ˆã†ãªã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚æ…£ã‚ŒãŸä½¿ã„å‹æ‰‹ã§SQLã‚’å®Ÿè¡Œã—ãŸã‚Šã€ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã§ãã¦ã—ã¾ã†ã®ã¯é¢ç™½ãã†ã§ã™ã€‚ãªãŠç¾çŠ¶Google Chromeã‚„Firefoxã«ã—ã‹æœ€é©åŒ–ã•ã‚Œã¦ã„ã¾ã›ã‚“ã€‚ SQL.jsã¯
xaicron 2012/03/31
javascript

sqlite
ãƒªãƒ³ã‚¯
Big Sky :: ã‚„ã£ãŸãƒ¼JavaScriptã®å‹•ãSQLiteã§ããŸã‚ˆãƒ¼
â€»ãƒã‚¿ã§ã™ â€»UDFã§ã™ æ£èª¤è¡¨ã‚’æ›¸ãã®ã«ã—ã°ã‚‰ãã“ã®æœ¬ã‚’ã¡ã‚‡ã£ã¨çœºã‚ã¦ã¿ãŸã‚‰ã€SQLiteã®UDFã£ã¦ç°¡å˜ã«ä½œã‚Œã‚‹ã‚“ã ãªãƒ¼ã€ã¨æ€ã£ãŸ && ãã†ã„ã‚„V8ã£ã¦ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¨ã—ã¦ç°¡å˜ã«ãƒªãƒ³ã‚¯ã§ãã‚‹ã¯ãšã ãªã€ã¨æ€ã„å‡ºã—ãŸ ã®ã§ã€ã¤ã„ã‚«ãƒƒã¨ãªã£ã¦ä½œã£ãŸã€‚ sqlite3udf-jseval - GitHub http://github.com/mattn/sqlite3udf-jseval UDFã†ã‚“ã¬ï½Ž ã»ã¨ã‚“ã©â†‘ã®æœ¬ã€å…¨ç„¶é–¢ä¿‚ãªã„ã¨æ€ã£ã¦ãŸã‘ã©ã€ã‚„ã£ã±ã‚ŠSQLiteã®UDFã«ã¤ã„ã¦å…¨ç„¶æ›¸ã„ã¦ãªã‹ã£ãŸã€‚ã—ã‚‡ã†ãŒãªã„ã®ã§è»½ãç´¹ä»‹ã—ã¦ãŠãã¨ UDFã‚’è¿½åŠ ã™ã‚‹å ´åˆã€SQLiteã®å†ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã¯å¿…è¦ãªã„ (ã—ã‹ã‚‹ã¹ãæ‰€ã«.soãŒãŠã„ã¦ã‚ã‚Œã°ã„ã„ï¼‰ UDFã¯ã“ã®è¾ºèªã‚“ã©ã‘ã°ã ã„ãŸã„åˆ†ã‹ã‚‹ã€‚ ä¾‹ãˆã°æ–‡å—åˆ—ã£ã½ã„ã‚‚ã®ã‚’è¿”ã™myfuncã£ã¦ã„ã†UDFã‚’ä½œã‚ŠãŸã„å ´åˆ SQLITE_EXTENSION_INIT1Â
xaicron 2011/09/26
sqlite

udf

javascript
ãƒªãƒ³ã‚¯
DBD::SQLite 1.30_04/05 - Charsbar::Note
é…ã‚Œã°ã›ãªãŒã‚‰DBD::SQLiteã®æ–°ã—ã„é–‹ç™ºç‰ˆãŒå‡ºã¾ã—ãŸã€‚ä»Šå›žã®ç›®çŽ‰ã¯Laurent Damiæ°ãŒå®Ÿè£…ã—ã¦ãã ã•ã£ãŸFTS3ã®æ‹¡å¼µæ©Ÿèƒ½ã€‚ã“ã‚Œã‚’ä½¿ã†ã¨DBD::SQLiteã§ã‚‚ç°¡å˜ã«æ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ãŒã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ ä½¿ã„æ–¹ã¯ã“ã‚“ãªæ„Ÿã˜ã€‚ use strict; use warnings; use DBI; use Text::MeCab; my $mecab = Text::MeCab->new; my $dbh = DBI->connect('dbi:SQLite::memory:'); $dbh->do('create virtual table foo using fts3 (content, tokenize=perl "main::tokenizer")'); my $sth = $dbh->prepare('insert into foo values (?)'); $
xaicron 2010/08/28
perl

sqlite
ãƒªãƒ³ã‚¯
DBD::SQLite 1.30_02 - Charsbar::Note
ã‚ã¨ã€å…ˆæ—¥ãƒªãƒªãƒ¼ã‚¹ã—ãŸDBD::SQLite 1.30_02ã®å¤‰æ›´ç‚¹ã«ã¤ã„ã¦ã€‚ DBD::SQLiteã¯ã“ã‚Œã¾ã§ DBIãŒç”¨æ„ã—ãŸæž çµ„ã¿ã®ç¯„å›²å†…ã§ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹(AutoCommit/begin_work) fork()ãªã©ã‚’åˆ©ç”¨ã—ã¦ä¸¦åˆ—æ€§ã‚’é«˜ã‚ã¦ã„ã‚‹ èªã¿æ›¸ãã‚’å¹³è¡Œã—ã¦è¡Œã£ã¦ã„ã‚‹ ã¨ã„ã£ãŸæ¡ä»¶ãŒé‡ãªã£ãŸã¨ãã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã™ã‚‹ã“ã¨ãŒã‚ã‚‹ã€ã¨ã„ã†å•é¡Œã‚’æŠ±ãˆã¦ã„ã¾ã—ãŸã€‚æœ€å°é™ã®å†ç¾ã‚³ãƒ¼ãƒ‰ã¯ã“ã‚“ãªæ„Ÿã˜ã«ãªã‚Šã¾ã™ã€‚ use strict; use warnings; use DBI; my $pid = fork(); if ($pid) { do_transaction(); } else { sleep 1; do_transaction(); exit; } unlink 'test.db'; sub do_transaction { my $dbh =
xaicron 2010/04/07
DBI

sqlite
ãƒªãƒ³ã‚¯
1