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

kamipo id:kamipo

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

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

SQLite3ã§datetimeãªTEXTã‚’ãªã‚‹ã¹ãé«˜é€Ÿã«æŽ¢ã™ - ãƒã‚¯ãƒã‚¯
ç ”ç©¶ã§SQLiteã‚’ä½¿ã£ã¦ã‚‹ã€‚ãƒ•ã‚¡ã‚¤ãƒ«1ã¤ã§ãƒãƒ¼ã‚¿ãƒ–ãƒ«ã€å—ã‘æ¸¡ã—ã‚‚æ¥½ã ã—ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã‚‚ã§ãã‚‹ã—å‰²ã‚Šã¨æ°—ã«å…¥ã£ã¦ã‚‹ã€‚ æ—¥ä»˜ã®ãƒ‡ãƒ¼ã‚¿ã‚’å¤§é‡ã«æ‰±ã†ã®ãŒé…ãã¦å›°ã£ãŸã®ã§é€Ÿãã™ã‚‹æ–¹æ³•ã‚’èª¿ã¹ãŸã€‚ã¡ã‚ƒã‚“ã¨ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒåŠ¹ãã‚ˆã†ã«ã—ãŸã„ã€‚ SQLite3 ã«ã¯ã€SQL99 ã® DATE ã‚„ DATETIME ã«å¯¾å¿œã™ã‚‹æ—¥æ™‚ã‚’è¡¨ã™åž‹ã¯å˜åœ¨ã—ã¾ã›ã‚“ã€‚SQLite3 ã§æ—¥æ™‚ã‚’æ‰±ã†å ´åˆã€Date And Time Functions ã§èª¬æ˜Žã•ã‚Œã¦ã„ã‚‹æ—¥ä»˜å‡¦ç†é–¢æ•°ã‚’ä½¿ç”¨ã—ã€TEXT åž‹ã‚„ NUMERIC åž‹ã®åˆ—ã«æ—¥ä»˜ãƒ‡ãƒ¼ã‚¿ã‚’ä½œæˆã—ã¾ã™ã€‚ http://www.tamandua-webtools.net/sqlite3-date.html TEXTã‚’ä½¿ã†å ´åˆã§ã¯ã€YYYY-MM-DD HH:MM:SSã¿ãŸã„ãªæ›¸å¼ã®æ–‡å—åˆ—ã‚’æ—¥ä»˜ã¨ã¿ãªã™ã€‚ NUMERIC(INTEGER or REAL)ã¯ã‚ˆãã‚ã‚‹Unixã‚¨ãƒãƒƒã‚¯ã‹ã‚‰
kamipo 2013/05/27
sqlite

explain
ãƒªãƒ³ã‚¯
SQLite 3 ã® AUTOINCREMENT
SQLite 3 ã§ã‚ªãƒ¼ãƒˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆãªã‚«ãƒ©ãƒ ã‚’ä½œã‚ŠãŸã‹ã£ãŸã‚‰ã€ CREATE TABLE my_diary ( diary_id INTEGER PRIMARY KEY, subject TEXT, body TEXT, create_dt TEXT ); ã¨ä¸»ã‚ãƒ¼ã‚’ INTEGER ã«ã—ã¦ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚Œã°ã€ãã®ã‚«ãƒ©ãƒ ã¯è‡ªå‹•çš„ã«ã‚ªãƒ¼ãƒˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆã«ãªã‚‹ã€ã¨ã„ã†ã®ã¯ä»Šã‚„å¸¸è˜çš„ã€‚ ä¸»ã‚ãƒ¼ã«ã—ãŸããªã„å ´åˆã¯ INSERT INTO my_diary VALUES((SELECT max(diary_id) FROM my_diary) + 1, 'ã‚¿ã‚¤ãƒˆãƒ«', 'æœ¬æ–‡', '2009-01-29'); ãªã©ã¨æ›´æ–°æ™‚ã® SQL æ–‡ã‚’å·¥å¤«ã™ã‚‹ã¨ã‹ã€‚ ãŸã AUTOINCREMENT ã¨ã„ã†ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã‚‚ã‚ã£ã¦ã€"PRIMARY KEY" ã®å¾Œã‚ã«ã“ã‚Œã‚’ä»˜ã‘ã‚‹ã‹ä»˜ã‘ãªã„ã‹ã§æŒ¯ã‚‹èˆžã„ãŒé•ã£ã¦ãã‚‹ã€‚
kamipo 2012/09/18
sqlite
ãƒªãƒ³ã‚¯
Datatypes In SQLite
1. Datatypes In SQLite Most SQL database engines (every SQL database engine other than SQLite, as far as we know) uses static, rigid typing. With static typing, the datatype of a value is determined by its container - the particular column in which the value is stored. SQLite uses a more general dynamic type system. In SQLite, the datatype of a value is associated with the value itself, not with i
kamipo 2012/09/18
sqlite
ãƒªãƒ³ã‚¯
CREATE TABLE
A table created using CREATE TABLE AS has no PRIMARY KEY and no constraints of any kind. The default value of each column is NULL. The default collation sequence for each column of the new table is BINARY. Tables created using CREATE TABLE AS are initially populated with the rows of data returned by the SELECT statement. Rows are assigned contiguously ascending rowid values, starting with 1, in th
kamipo 2012/09/18
sqlite
ãƒªãƒ³ã‚¯
SQLite ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ã¾ãŸã¯ DBIx::Sunny 0.16 ã®è©± - blog.nomadscafe.jp
GrowthForecastãŒMySQLå¯¾å¿œã—ãŸãã£ã‹ã‘ã¨ã—ã¦SQLiteã®dead lockå•é¡ŒãŒã‚ã£ãŸã®ã§ã™ãŒã€PRAGMAã§ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒçµæ§‹å¤‰ã‚ã‚‹ã“ã¨ãŒã‚ã‹ã£ãŸã®ã§ãƒ¡ãƒ¢ã€‚ ã‚„ã£ãŸã®ã¯ã€journal_mode ã¨ synchronous ã®å¤‰æ›´ã€‚ãã‚Œãžã‚Œ > PRAGMA journal_mode = DELETE | TRUNCATE | PERSIST | MEMORY | WAL | OFF > PRAGMA synchronous = 0 | OFF | 1 | NORMAL | 2 | FULL ã®ã‚ˆã†ãªæ„Ÿã˜ã§å¤‰æ›´ã§ãã‚‹ã€‚ ãã‚Œãžã‚Œã®è¨å®šã¯ã€ PRAGMA Statements - synchronous PRAGMA Statements - journal_mode ã‚’ã¿ã‚‹ã®ãŒè‰¯ã„ã¨æ€ã†ã€‚journal_mode ã«æŒ‡å®šã§ãã‚‹WALã«ã¤ã„ã¦ã¯æ¬¡ã®ãƒš
kamipo 2012/06/11
sqlite
ãƒªãƒ³ã‚¯
Big Sky :: ã‚„ã£ãŸãƒ¼JavaScriptã®å‹•ãSQLiteã§ããŸã‚ˆãƒ¼
æ£èª¤è¡¨ã‚’æ›¸ãã®ã«ã—ã°ã‚‰ãã“ã®æœ¬ã‚’ã¡ã‚‡ã£ã¨çœºã‚ã¦ã¿ãŸã‚‰ã€SQLiteã®UDFã£ã¦ç°¡å˜ã«ä½œã‚Œã‚‹ã‚“ã ãªãƒ¼ã€ã¨æ€ã£ãŸ && ãã†ã„ã‚„V8ã£ã¦ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¨ã—ã¦ç°¡å˜ã«ãƒªãƒ³ã‚¯ã§ãã‚‹ã¯ãšã ãªã€ã¨æ€ã„å‡ºã—ãŸ ã®ã§ã€ã¤ã„ã‚«ãƒƒã¨ãªã£ã¦ä½œã£ãŸã€‚ sqlite3udf-jseval - GitHub http://github.com/mattn/sqlite3udf-jseval UDFã†ã‚“ã¬ï½Ž ã»ã¨ã‚“ã©â†‘ã®æœ¬ã€å…¨ç„¶é–¢ä¿‚ãªã„ã¨æ€ã£ã¦ãŸã‘ã©ã€ã‚„ã£ã±ã‚ŠSQLiteã®UDFã«ã¤ã„ã¦å…¨ç„¶æ›¸ã„ã¦ãªã‹ã£ãŸã€‚ã—ã‚‡ã†ãŒãªã„ã®ã§è»½ãç´¹ä»‹ã—ã¦ãŠãã¨ UDFã‚’è¿½åŠ ã™ã‚‹å ´åˆã€SQLiteã®å†ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã¯å¿…è¦ãªã„ (ã—ã‹ã‚‹ã¹ãæ‰€ã«.soãŒãŠã„ã¦ã‚ã‚Œã°ã„ã„ï¼‰ UDFã¯ã“ã®è¾ºèªã‚“ã©ã‘ã°ã ã„ãŸã„åˆ†ã‹ã‚‹ã€‚ ä¾‹ãˆã°æ–‡å—åˆ—ã£ã½ã„ã‚‚ã®ã‚’è¿”ã™myfuncã£ã¦ã„ã†UDFã‚’ä½œã‚ŠãŸã„å ´åˆ SQLITE_EXTENSION_INIT1Â staticÂ voidÂ j
kamipo 2011/09/26
sqlite
ãƒªãƒ³ã‚¯
SQLite Full Text Search with MeCab - mynote
ã¯ã˜ã‚ã«â€ SQLiteã®å…¨æ–‡æ¤œç´¢ã®æ‹¡å¼µFTSã¯ã€ã¾ã å®Ÿé¨“çš„ãªæ®µéšŽã§fts1, fts2ã¨ä½œã£ã¦ã¯ç ´æ£„ï¼ˆï¼Ÿï¼‰ã—ã¦ãã¦ã€ä»Šã¯fts3ãŒæœ€æ–°ã®ã‚ˆã†ã§ã™ã€‚(sqlite3.5.1ï¼‰ã€‚ãŸã ã—ã€ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«æ¸ˆã¿ãƒã‚¤ãƒŠãƒªã®é…å¸ƒã¯æ¢ã‚ã¦ã—ã¾ã£ãŸã‚ˆã†ã§ã™ã€‚å®Ÿé¨“æ®µéšŽãªã®ã§æ¬²ã—ã„äººã¯è‡ªåˆ†ã§ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã—ã¦ãâ™¥ã¿ãŸã„ãªã€‚ã“ã®ftsã§æ—¥æœ¬èªžãŒä½¿ãˆãªã„ã¨ã‹è‰²ã€…è¨€ã‚ã‚Œã¦ã„ã‚‹ã®ã«åŠ ãˆã¦ã€ã¡ã‚‡ã£ã¨ãƒ—ãƒãƒˆã‚¿ã‚¤ãƒ—ã‚’ã§ã£ã¡ä¸Šã’ã‚‹ã®ã«å¿…è¦ã«ãªã‚Šãã†ãªé›°å›²æ°—ãªã®ã§ã€æ—¥æœ¬èªžã§ã‚‚ftsãŒä½¿ãˆã‚‹ã‚ˆã†ã«ã—ã¦ã¿ã¾ã—ãŸã€‚ â†‘ ãã‚‚ãã‚‚ã®å‹•æ©Ÿâ€ ã€ŽSQLite ã®å…¨æ–‡æ¤œç´¢ã‚’ Python ã‹ã‚‰ä½¿ã£ã¦ã¿ã‚‹ (3)ã€ã‚’èªã‚“ã ã€‚ã“ã“ã§ftsã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®è‹±æ–‡ç”¨ã®tokenizerï¼ˆç©ºç™½ã§å˜èªžã‚’åŒºåˆ‡ã‚‹ï¼‰ã§æ—¥æœ¬èªžã‚’ç„¡ç†ã‚„ã‚Šä½¿ã†ãŸã‚ã«MeCabã‚’ä½¿ã£ã¦åˆ†ã‹ã¡æ›¸ãã‚’ã—ã¦ã€ãã®æ–‡å—åˆ—ã‚’æŒ¿å…¥ã—ã€å–ã‚Šå‡ºã—ãŸã‚ã¨ã«é€£çµã¨ã‹ã—ã¦ãŸãƒ»ãƒ»ãƒ»ã€‚èª°ã‚‚çŸ¥ã‚‰ãªã„ã‚ˆã†ã ãŒã€å®Ÿã¯fts2
kamipo 2010/11/08
sqlite
ãƒªãƒ³ã‚¯
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ã‚’ãƒ‘ã‚¹ã®é€šã£ãŸãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ã‚³ãƒ”
kamipo 2010/02/10
ruby

sqlite
ãƒªãƒ³ã‚¯
ç¬¬3å›ž SQLite3
å‰å›žã€æ–°è¦ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œæˆã—ã¾ã—ãŸã€‚ã¾ã ã€ã¾ã£ãŸãæ©Ÿèƒ½ã¯ã‚ã‚Šã¾ã›ã‚“ãŒã€ã¨ã«ã‹ãã‚µãƒ¼ãƒã‚’èµ·å‹•ã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ > script/server ç„¡äº‹ã€èµ·å‹•ã—ãŸã‚ˆã†ã§ã™ã€‚ãƒ–ãƒ©ã‚¦ã‚¶ã§ã€Œhttp://localhost:3000/ã€ã‚’é–‹ãã¨ã€è¦‹æ…£ã‚ŒãŸã€ŒWelcome aboardã€ã®ãƒšãƒ¼ã‚¸ãŒè¡¨ç¤ºã•ã‚Œã¾ã—ãŸã€‚ ç•°å¤‰ãŒèµ·ããŸã®ã¯ã¯æ¬¡ã®çž¬é–“ã§ã™ã€‚ã„ã¤ã‚‚ã®ã‚ˆã†ã«ã€ŒAbout your application's environmentã€ã®ãƒªãƒ³ã‚¯ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¾ã—ãŸã€‚ã™ã‚‹ã¨ã€ãã“ã«ç¾ã‚ŒãŸã®ã¯ã€ŒMissingSourceFile in Rails/infoController#propertiesã€ã¨ã„ã†æ€ªã—ã’ãªæ–‡å—åˆ—ã€‚ã‚ˆãè¦‹ã‚‹ã¨ã€Œno such file to load -- sqlite3ã€ã¨ã„ã†ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚‚ï¼Rails 2.0 ã®æ´—ç¤¼ã§ã™ã€‚æ£ç¢ºã«è¨€ã†ã¨ã€Rails 2.0.2 ã®æ´—ç¤¼ã€‚ Rail
kamipo 2010/02/10
ruby

sqlite
ãƒªãƒ³ã‚¯
Query Language Understood by SQLite
SQL As Understood By SQLite SQLite understands most of the standard SQL language. But it does omit some features while at the same time adding a few features of its own. This document attempts to describe precisely what parts of the SQL language SQLite does and does not support. A list of SQL keywords is also provided. The SQL language syntax is described by syntax diagrams. The following syntax d
kamipo 2009/12/07
sqlite
ãƒªãƒ³ã‚¯
SQLite ã§ auto-increment ãªãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’ä½œæˆã™ã‚‹æ–¹æ³•
SQLite ã§ auto-increment ãªãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’ä½œæˆã™ã‚‹æ–¹æ³• 2006-02-12-1: [SQLite][PHP][MySQL] PHP ã®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã® sqlite_last_insert_rowid ã®é …ç›®ã‚’è¦‹ã¦ã„ãŸã‚‰ Tip: You can create auto-increment fields in SQLite by declaring them as INTEGER PRIMARY KEY in your table schema. ã¤ã¾ã‚Šï¼ŒSQLite ã§ auto-increment ãªãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’ä½œã‚ŠãŸã‘ã‚Œã°ï¼Œ INTEGER PRIMARY KEY ã‚’æŒ‡å®šã—ã¦ã‚ã’ã‚Œã°ã„ã„ã‚‰ã—ã„ï¼Ž ã“ã®ã‚ˆã†ãªè¨˜è¿°ã‚’è¦‹ã¤ã‘ãŸã®ã§ãƒ†ã‚¹ãƒˆã—ã¦ã¿ãŸï¼Ž - SQLite 2.x ã®å ´åˆ $ sqlite test.db SQLite version 2.8.16 Enter "
kamipo 2009/11/13
sqlite
ãƒªãƒ³ã‚¯
SQLiteã¨ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ - ã¨ã»ã»ã®N88-BASICæ—¥è¨˜
SQLiteã®è¿½åŠ /æ›´æ–°ã¯ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä½¿ã†ã¨é«˜é€ŸåŒ–ã«åŠ¹æžœãŒã‚ã‚‹ã¨ã„ã†ã®ã¯ã‚ˆãåŠ¹ãã®ã§å®Ÿéš›è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ use strict; use warnings; use DBI; use Benchmark qw(:all); my $count = 100; my $loop = 100; cmpthese( $count, { commit_each_insert => \&commit_each_insert, commit_bulk_insert => \&commit_bulk_insert, } ); sub commit_each_insert { unlink('test1.db'); my $dbh = DBI->connect('dbi:SQLite:dbname=test1.db'); $dbh->do( "CREATE TABLE test (id int not
kamipo 2009/07/01
SQLiteã®è¿½åŠ /æ›´æ–°ã¯ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä½¿ã†ã¨é«˜é€ŸåŒ–ã«åŠ¹æžœãŒã‚ã‚‹

perl

sqlite
ãƒªãƒ³ã‚¯
Firefoxã®SQLiteDBã®å†ç·¨æˆã«ã¤ã„ã¦ï¼ˆã™ã“ã—è©³ç´°ã«ï¼‰ - hogehoge @teramako
http://www.sio.no-ip.com/mt/shio/archives/2008/10/firefox-3-sql it.html ç‰©å‡„ã„äººæ°—ã§ã™ãã€‚ ã“ã‚Œã«ã¤ã„ã¦ã¡ã‚‡ã£ã¨è©³ã—ãæ›¸ã„ã¦ã¿ã‚ˆã†ã¨æ€ã†ã€‚ DBãƒ•ã‚¡ã‚¤ãƒ«ã®æ–ç‰‡åŒ– Windowsã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã‚’ãƒ‡ãƒ•ãƒ©ã‚°ã—ã¾ã—ã‚‡ã£ã¦ã‚„ã¤ã¯DBãƒ•ã‚¡ã‚¤ãƒ«ã«ã‚‚è¨€ãˆã‚‹ã“ã¨ã ã€‚ ä»•çµ„ã¿ã‚’Leo's Chronicle: ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ å…¥é–€ï¼šã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ä½“è‚²ä¼šç³»å›³æ›¸é¤¨ï¼Ÿã€ã«ç¿’ã£ã¦ã€Œå›³æ›¸é¤¨ã€ã«ä¾‹ãˆã¦ã¿ã‚‹ã€‚ å›³æ›¸é¤¨ DBãƒ•ã‚¡ã‚¤ãƒ« æœ¬ ä¸èº«ã®ãƒ‡ãƒ¼ã‚¿ä¸€è¡Œ ã¨ã„ãˆã‚‹ã ã‚ã†ã€‚ å˜ç´”ã«ãƒ‡ãƒ¼ã‚¿ãŒè¿½åŠ ã•ã‚Œã¦ã„ãã ã‘ãªã‚‰ã€æœ¬ã‚’æœ¬æ£šã®æœ«å°¾ã«è¿½åŠ ã™ã‚‹ã ã‘ãªã®ã§ãƒ‡ãƒ¼ã‚¿ã¯è©°ã¾ã£ãŸã¾ã¾ã ã—æ¥½ãƒãƒ³ã *1ã€‚ é€”ä¸ãƒ‡ãƒ¼ã‚¿ã®å‰Šé™¤(æœ¬ã‚’æŠœãå–ã‚‹)ã‚’è€ƒãˆã¦ã¿ã‚‹ã€‚æŠœãå–ã£ãŸå¾Œæœ¬ã‚’è©°ã‚ãªã„ã¨ç©ºç™½ãŒã§ãã‚‹ã€‚ ã¾ãŸã€ãƒ‡ãƒ¼ã‚¿æ›´æ–°ï¼ˆæœ¬ã®äº¤æ›ï¼‰ã‚’è€ƒãˆã¦ã¿ã‚‹ã€‚åŒã˜å¤§ãã•ãªã‚‰è‰¯ã„ãŒã€‚å¤§ãã‹ã£ãŸã‚Šã€
kamipo 2009/05/29
firefox

sqlite
ãƒªãƒ³ã‚¯
tokuhirom blog
Blog Search when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: ${entry.path} [in template "__entry.ftlh" at line 3, column 25] - Reached through: #include "__entry.ftlh" [in template "entry.ftlh" at
kamipo 2009/04/16
perl

sqlite
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
kamipo 2009/04/09
DBD::SQLite ã§ $dbh->{unicode} ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ã¤ã‘ãŸã¨ãã€UTF-8 ãªæ–‡å—åˆ—ã‚’æ¸¡ã™ã¨ãã¯decode ã—ãŸçŠ¶æ…‹ã§ã‚ãŸã›ã€ã•ã‚‚ãªãã°äºŒé‡ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‰ã«ãªã£ã¦æ–‡å—åŒ–ã‘ã™ã‚‹ã‚ˆã€ã¨ã„ã†ã“ã¨ã§ã™ã€‚

perl

sqlite
ãƒªãƒ³ã‚¯
sqliteãŒãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã®æ™‚ã®TracReportã‚’æ›¸ãtips â€” ã‚ã‚Šãˆã‚‹ãˆã‚Šã‚
sqliteãŒãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã®æ™‚ã®TracReportã‚’æ›¸ãtips sqliteãŒãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã®æ™‚ã®TracReportã®SQLã‚’æ›¸ãtipsã§ã™ã€‚ ä¸»ãªãƒ†ãƒ¼ãƒ–ãƒ«æ§‹é€ (ticket) CREATE TABLE ticket ( id integer PRIMARY KEY, type text, time integer, changetime integer, component text, severity text, priority text, owner text, reporter text, cc text, version text, milestone text, status text, resolution text, summary text, description text, keywords text ); CREATE TABLE ticket_custom
kamipo 2009/03/06
trac

sqlite
ãƒªãƒ³ã‚¯
ã‚¦ã‚§ãƒ–ãƒªãƒ–ãƒã‚°ï¼šã‚µãƒ¼ãƒ“ã‚¹ã¯çµ‚äº†ã—ã¾ã—ãŸã€‚
ã€Œã‚¦ã‚§ãƒ–ãƒªãƒ–ãƒã‚°ã€ã¯ 2023å¹´1æœˆ31æ—¥ ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹æä¾›ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ 2004å¹´3æœˆã®ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹ã‚ˆã‚Š19å¹´è¿‘ãã‚‚ã®é–“ã€æ²¢å±±ã®çš†ã•ã¾ã«ã”æ„›ç”¨ã„ãŸã ãã¾ã—ãŸã“ã¨ã‚’å¿ƒã‚ˆã‚ŠãŠç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ä»Šå¾Œã¨ã‚‚ã€BIGLOBEã‚’ã”æ„›é¡§è³œã‚Šã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ç”³ã—ä¸Šã’ã¾ã™ã€‚ â€»å¼•ã£è¶Šã—å…ˆãƒ–ãƒã‚°ã¸ã®ãƒªãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆã‚µãƒ¼ãƒ“ã‚¹ã¯2024å¹´1æœˆ31æ—¥ã§çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ BIGLOBEã®ã‚µãƒ¼ãƒ“ã‚¹ä¸€è¦§
kamipo 2009/02/06
firefox

sqlite
ãƒªãƒ³ã‚¯
SQLiteã‚’ä½¿ã£ãŸãƒ†ã‚¹ãƒˆã®tips
DBå‘¨ã‚Šã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’é–‹ç™ºã—ã¦ã„ã‚‹å ´åˆã€ãƒ†ã‚¹ãƒˆDBã«SQLiteã‚’ä½¿ã†äº‹ãŒè‰¯ãã‚ã‚Šã¾ã™ã€‚ ãã®éš›ã€æ™®é€šã§ã‚ã‚Œã°ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ†ã‚¹ãƒˆã‚³ãƒ¼ãƒ‰ã‚’æ›¸ãã¨æ€ã„ã¾ã™ use Test::More tests => 1; use DBI; do { # SQLiteã§ä½¿ã†ãƒ•ã‚¡ã‚¤ãƒ«ã‚’æŒ‡å®š my $dbh = DBI->connect('dbi:SQLite:./test.db','',''); $dbh->do(q{CREATE TABLE foo (id INT, name TEXT)}); $dbh->do(q{INSERT INTO foo (id, name) VALUES (10,'nekokak')}); my $sth = $dbh->prepare('SELECT * FROM foo'); $sth->execute; my $row = $sth->fetchrow_hashref();
kamipo 2008/12/14
SQLiteã§ã¯ãƒ•ã‚¡ã‚¤ãƒ«åã‚’æŒ‡å®šã—ãªã„å ´åˆã€ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½œã‚‰ãšã‚ªãƒ³ãƒ¡ãƒ¢ãƒªã§å‡¦ç†ã§ãã‚‹

perl

test

sqlite
ãƒªãƒ³ã‚¯
çª“ã®æœ - ã€REVIEWã€‘ã€ŒSQLiteã€ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’GUIã§æ“ä½œã§ãã‚‹é«˜æ©Ÿèƒ½ç®¡ç†ã‚½ãƒ•ãƒˆã€ŒPupSQLiteã€
ã€ŒPupSQLiteã€ã¯ã€ãƒ•ãƒªãƒ¼ã§åˆ©ç”¨ã§ãã‚‹è»½é‡ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã€ŒSQLiteã€ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’GUIã§ç®¡ç†ã§ãã‚‹ã‚½ãƒ•ãƒˆã€‚Windows XP/Vistaã«å¯¾å¿œã™ã‚‹å¯„ä»˜æ“è¿Žã®ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã§ã€ä½œè€…ã®Webã‚µã‚¤ãƒˆã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã€‚ãªãŠã€å‹•ä½œã«ã¯.NET Framework 2.0ä»¥é™ãŒå¿…è¦ã€‚ æœ¬ã‚½ãƒ•ãƒˆã«ã¯ã€ŒSQLiteã€ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªâ€œsqlite3.dllâ€ãŒåŒæ¢±ã•ã‚Œã¦ãŠã‚Šã€ç’°å¢ƒã®æ§‹ç¯‰ä½œæ¥ãªã©ãŒå¿…è¦ãªããã®ã¾ã¾åˆ©ç”¨å¯èƒ½ã€‚ç”»é¢ã¯MDIæ–¹å¼ã«ãªã£ã¦ãŠã‚Šã€è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãã‚Œãžã‚ŒåŒæ™‚ã«åã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã¨ã—ã¦é–‹ãã“ã¨ãŒã§ãã‚‹ã€‚å„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦å†…ã«ã‚¿ãƒ–åˆ‡ã‚Šæ›¿ãˆåž‹ã®ã‚°ãƒªãƒƒãƒ‰ãƒ“ãƒ¥ãƒ¼ã¨ã—ã¦è¡¨ç¤ºã•ã‚Œã‚‹ä»•çµ„ã¿ã€‚ æ©Ÿèƒ½ã‚‚å……å®Ÿã—ã¦ãŠã‚Šã€ãƒ†ãƒ¼ãƒ–ãƒ«å†…ãƒ‡ãƒ¼ã‚¿ã®é–²è¦§ãƒ»ç·¨é›†ã¯ã‚‚ã¡ã‚ã‚“ã€SQLæ–‡ã‚’ç™ºè¡Œã—ã¦çµæžœã‚’è¡¨å½¢å¼ã§é–²è¦§ã§ãã‚‹æ©Ÿèƒ½ã€ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ–‡ã‚’å‡ºåŠ›ã™ã‚‹æ©Ÿèƒ½ã€2ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’æ¯”
kamipo 2008/09/05
sqlite
ãƒªãƒ³ã‚¯
tokuhirom blog
Blog Search when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: ${entry.path} [in template "__entry.ftlh" at line 3, column 25] - Reached through: #include "__entry.ftlh" [in template "entry.ftlh" at
kamipo 2008/07/27
perl

sqlite
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸