SQLite Optimization FAQ
Jim Lyon (jplyon@attglobal.net) 10-Sep-2003 Compiled from sqlite docs, source, and yahoo postings This document is current for SQLite 2.8.6 1. Introduction 1.1. About this FAQ This FAQ is an incomplete summary of my experiences with speed-optimizing an application that uses the SQLite library. It will be of most use to people who are already familiar with using SQLite. Feel free to send any que
columnã®drop - rayfillã®ãƒ—ãƒã‚°ãƒ©ãƒ ãƒã‚¿å¸³
sqlã§é¢ç™½ãã†ãªã“ã¨ã‚„ã£ã¦ãŸã®ã§ãƒ„ッã“ã‚“ã§ã¿ã‚‹ çµæžœã¤ã‘ãŸã‚‰çµæ§‹ã§ã‹ããªã£ãŸã®ã§ã“ã£ã¡ã§ã€‚ ã¾ãšã¯ãƒ†ã‚¹ãƒˆãƒ†ãƒ¼ãƒ–ルã®ä½œæˆ sqlite> .explain on sqlite> create table test ( ...> id integer, ...> field1 text ...> ); カラムã®è¿½åŠ sqlite> alter table test add column field2 text; sqlite> insert into test values (1, 'field1', 'field2'); sqlite> select * from test; id field1 field2 ---- -------------- ---------- 1 field1 field2 カラムã®å‰Šé™¤ sqlite> alter table test drop column
ORマッパーã€20070628 - FAX
JavaScriptFirefoxã€Storageã€SQLite用。Firefoxã«å¯¾è±¡ã‚’絞りã€ã‚¢ã‚¯ã‚»ã‚µã‚„å˜åœ¨ã—ãªã„メソッド呼ã³å‡ºã—ã®æ•æ‰ãªã©ã‚’使ã£ã¦ã„る分ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãŒã™ã£ãり書ã‘る。E4Xをヒアドã‚ュメント+テンプレートã¨ã—ã¦åˆ©ç”¨ã€‚XMLã¨Stringã®å¼•æ•°ã¯ã€arg+='';ã§æ–‡å—列ã¸æƒãˆã‚‹ã€‚ 日付型ã®ã‚µãƒãƒ¼ãƒˆ__noSuchMethod__を使ã£ãŸfindBy/countByã®å–り扱ã„SQLã®ãƒ‘ラメーター値をオブジェクト以外ã«é…列ã§ã‚‚渡ã›ã‚‹ã‚ˆã†ã«(一ã¤ã®å ´åˆã«{id:id}ã®ã‚ˆã†ã«å†—é•·ãªè¡¨ç¾ã«ãªã‚‹ãŸã‚) mozIStorageStatementWrapperã¯ã€ãªã‚“ã‹ãƒã‚®ãƒ¼ã€‚無言ã§è½ã¡ã‚‹ã€‚ クライアントコードã¯ä»¥ä¸‹ã€‚ var db = new Database(file); var Video = Entity({ name : 'video', fields : { id :
Storage - Mozilla | MDN
Storage is a SQLite database API. It is available to trusted callers, meaning extensions and Firefox components only. The API is currently "unfrozen", which means it is subject to change at any time; in fact, it has changed somewhat with each release of Firefox since it was introduced, and will likely continue to do so for a while. Note: Storage is not the same as the DOM:Storage feature which can
Collection & Copy - Firefox 2.0ã€Storage(SQLite)ã€ãƒã‚¤ãƒ³ãƒˆ
JavaScriptMDC - Storage ã“れをèªã‚“ã§ã€åƒ•ãŒæ€ã£ãŸãƒã‚¤ãƒ³ãƒˆã€‚ Firefox 2.0ã«ã¯ã€SQLiteãŒçµ„ã¿è¾¼ã¾ã‚Œã¦ã„る。åŒã˜ãFirefox 2.0ã§å°Žå…¥ã•ã‚ŒãŸã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚µã‚¤ãƒ‰ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸(sessionStorage/globalStorage)ã¨ã¯ç•°ãªã‚‹ã‚‚ã®ã€‚ (クライアントサイドストレージã®ä¸ã§ã¯ã€ã“ã®SQLiteãŒåˆ©ç”¨ã•ã‚Œã¦ã„る。)基本的ã«chrome URLã‚„æ‹¡å¼µã‹ã‚‰ã®åˆ©ç”¨ã‚’想定ã—ã€ã‚¦ã‚§ãƒ–ページã‹ã‚‰ã¯åˆ©ç”¨ã§ããªã„。システムや拡張ã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã¯ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒ«*1ã«ã€æ‹¡å¼µåsqliteã§ä¿å˜ã•ã‚Œã¦ã„る。mozIStorageConnection#executeSimpleSQLã¯ã€å€¤ã‚’è¿”ã•ãªã„。 テーブルã®ä½œæˆã‚„削除ã€ãƒ‡ãƒ¼ã‚¿è¿½åŠ ãªã©ã«åˆ©ç”¨ã™ã‚‹ã€‚ã‚»ã‚ュリティ的ã«ã‚‚パフォーマンス的ã«ã‚‚mozIStorageConnection#createStatementã‚’
Cygwinã§sqlite3-ruby - monthly gimite
ã‚¹ã‚«ãƒ³ã‚¯æ—¥è¨˜ï¼’ï¼Žï¼ | Ruby on Rails 㨠MySQL ã˜ã‚ƒãªã㦠SQLite を見ãªãŒã‚‰ä½œæ¥ã—ã¦ãŸã‚“ã§ã™ãŒã€çµè«–ã¨ã—ã¦ã¯ã€ä¸€ç•ªä¸‹ã®ã‚³ãƒ¡ãƒ³ãƒˆã®é€šã‚Šã« lib/sqlite3/driver/dl/api.rb ã®45行目付近ã«ã‚ã‚‹ when /win32/ã‚’ when /win32/, /i386-cygwin/ã«å¤‰ãˆã‚‹ã ã‘ã§ã€SQLite自身ã¯ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ãƒšãƒ¼ã‚¸ã®Precompiled Binaries For Windows（ã®ã€sqlitedll-3*.zip）ãŒãã®ã¾ã¾ä½¿ãˆã‚‹ã‚ˆã†ã§ã™ã€‚ã¤ã¾ã‚Šã€sqlitedll-3*.zipを解å‡ã—ã¦å‡ºã¦ããŸsqlite3.dllã‚’C:\Windows\System32ãªã©ã®ãƒ‘スã®é€šã£ãŸãƒ•ã‚©ãƒ«ãƒ€ã«ç½®ã„ã¦ãŠã‘ã°OK。 …苦労ã—ã¦Cygwin上ã§SQLiteをソースã‹ã‚‰ã‚³ãƒ³ãƒ‘イルã—ãŸæ„味無ã„ã˜ã‚ƒã‚“。 2007/11/11追記: ã“ã‚ŒãŒã†ã¾ã
1
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
Help
SQLite ドã‚ュメント - Third impact (翻訳文書)
http://www.wpdev.org/wiki/index.php/Convert_sqlite2_to_sqlite3_format
{{#tags}}- {{label}}
{{/tags}}