[B! SQLite] terurouã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

terurou id:terurou

SQLiteã«é–¢ã™ã‚‹terurouã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (26)

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

JSONã§ç–²å¼Šã—ãŸã‚‰è©¦ã—ãŸã„ã€ã‚¢ãƒ—ãƒªã®ãƒ‡ãƒ¼ã‚¿ã‚’SQLiteã§å—ã‘æ¸¡ã™ã¨ã„ã†é¸æŠžè‚¢ - ã‚¢ãƒ‹ãƒžãƒé–‹ç™ºæ—¥èªŒ
ã‚¢ãƒ‹ãƒžãƒã®å†…éƒ¨ã§ã¯ã‚¢ãƒ—ãƒªã¨ã‚µãƒ¼ãƒãƒ¼é–“ã§ã©ã®ã‚ˆã†ã«ãƒ‡ãƒ¼ã‚¿ã‚’å—ã‘æ¸¡ã—ã—ã¦ã„ã‚‹ã‹ã¨ã„ã†è©±ã‚’ã—ã¦ã¿ã¾ã™ã€‚ ä¸€èˆ¬çš„ã«ã‚¢ãƒ—ãƒªã¨ã‚µãƒ¼ãƒãƒ¼é–“ã®ãƒ‡ãƒ¼ã‚¿ã®å—ã‘æ¸¡ã—ã ã¨JSONã‚„XMLã€YAMLãªã©ãŒå¤šã„ã¨æ€ã„ã¾ã™ã€‚ ã“ã“ã«SQLiteã¨ã„ã†é¸æŠžè‚¢ã‚’å…¥ã‚Œã‚‹ã¨è‰²ã€…å¹¸ã›ã«ãªã‚Œã‚‹ã¨ã„ã†è©±ã§ã™ã€‚ ã‚‚ã¯ã‚„ä½•ã§ä»Šã¾ã§JSONã¨ã„ã†å›ºå®šè¦³å¿µãŒæ¨ã¦ã‚‰ã‚Œãªã‹ã£ãŸã®ã‹ã¨ã„ã†ãã‚‰ã„ã€å€‹äººçš„ã«ã¯ã‚³ãƒãƒ³ãƒ–ã‚¹ã®åµã§ã—ãŸã€‚ ã‚ã¾ã‚Šäº‹ä¾‹ã¯ãªã•ãã†ãªã®ã§ã€ã“ã“ã§ç´¹ä»‹ã—ã¦ã¿ã¾ã™ã€‚ ã‚¢ãƒ‹ãƒžãƒã§ã®å•é¡Œç‚¹ ã‚¢ãƒ‹ãƒ¡ã‚¢ãƒ—ãƒªã®ã‚¢ãƒ‹ãƒžãƒã§ã¯ä¸»ã«ã‚¢ãƒ‹ãƒ¡ã®ç•ªçµ„è¡¨ã‚„ãƒ‹ãƒ¥ãƒ¼ã‚¹ã‚’ã‚µãƒ¼ãƒãƒ¼ã‹ã‚‰å—ã‘å–ã£ã¦è¡¨ç¤ºã—ã¦ã„ã¾ã™ã€‚ éƒ½é“åºœçœŒã«ã‚‚ã‚ˆã‚Šã¾ã™ãŒã€ä¸€ã¤ã®éƒ½é“åºœçœŒã®1é€±é–“åˆ†ã®ç•ªçµ„è¡¨ï¼ˆã‚¢ãƒ‹ãƒ¡ã ã‘ï¼‰ã‚’JSONã«ã™ã‚‹ã¨å¤§ä½“750KBãã‚‰ã„ã«ãªã‚‹ã‚“ã§ã™ãã€‚ ã“ã‚Œã‚’é–‹ç™ºåˆæœŸã§ã¯MessagePackã«ç½®ãæ›ãˆã¦ã¾ã—ãŸã€‚ è©±ã®æœ¬ç‹ã¨ã¯é–¢ä¿‚ãªã„ã§ã™ãŒã€JSONã‚ˆã‚Šã¯MessagePackã®æ–¹
terurou 2015/10/10
ã‚ã¾ã‚Šæ›´æ–°é »åº¦ãŒé«˜ããªã„ï¼äºˆã‚ç”Ÿæˆã—ã¦ãŠãã¨ã„ã†è€ƒãˆæ–¹ãªã‚‰ã‚ã‚Šã ãªãã€‚

SQLite

webapi

serialize
ãƒªãƒ³ã‚¯
SQLiteã®æ›¸ãè¾¼ã¿é€Ÿåº¦ã‚’ã‚¢ãƒƒãƒ—ã•ã›ã‚‹ (System.Data.SQLite, SyncMode, JournalMode, PRAGMA) - ã„ã‚ã„ã‚å‚™å¿˜éŒ²æ—¥è¨˜
å¿˜ã‚Œãªã„ã‚ˆã†ãƒ¡ãƒ¢ãƒ¡ãƒ¢ã€‚ SQLiteã•ã‚“ã¯ã€ãã‚‚ãã‚‚é€Ÿåº¦ãŒé€Ÿã„ã®ã§ã™ãŒæ›¸ãè¾¼ã¿é€Ÿåº¦ã‚’ã•ã‚‰ã«ã‚¢ãƒƒãƒ—ã•ã›ãŸã„æ™‚ãŒã‚ã‚Šã¾ã™ã€‚ (ãƒ‡ãƒ¼ã‚¿ãŒã‚‚ã®å‡„ã„é€Ÿã•ã§æµã‚Œã¦ãã¦ã€ãã‚Œã‚’å‡ºæ¥ã‚‹ã ã‘é…å»¶ãªãæ›¸ãè¾¼ã¿ã—ãŸã„ã¨ãã¨ã‹) æ›¸ãè¾¼ã¿é€Ÿåº¦ã‚’ã‚¢ãƒƒãƒ—ã•ã›ã‚‹ã®ã«ã€ã™ãé©ç”¨ã§ãã‚‹ã®ãŒPRAGMAã‚’è¨å®šã™ã‚‹ã“ã¨ã§ã™ã€‚ ä»¥ä¸‹ã®PRAGMAã‚’è¨å®šã™ã‚‹ã¨ã‚°ãƒƒã¨é€Ÿåº¦ãŒå¤‰ã‚ã‚Šã¾ã™ã€‚ SyncMode JournalMode ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯ã€System.Data.SQLiteã®å ´åˆ SyncMode=Normal JournalMode=Default ã§ã™ã€‚ã“ã‚Œã‚’ SyncMode=Off JournalMode=Memory ã«ã™ã‚‹ã¨ã€çˆ†é€Ÿã«ãªã‚Šã¾ã™ã€‚ã¾ãŸã¯ SyncMode=Off JournalMode=Wal ã«ã—ã¦ã‚‚åŒã˜ãã‚‰ã„é€Ÿããªã‚Šã¾ã™ã€‚SyncModeã¯Normalã®ã¾ã¾ãŒã„ã„å ´åˆã¯ SyncMode=Normal
terurou 2014/08/27
SQLiteã«ãã‚“ãªè¨å®šãŒã‚ã‚‹ã“ã¨ã‚’çŸ¥ã‚‰ã‚“ã‹ã£ãŸ

SQLite
ãƒªãƒ³ã‚¯
Home
Projects Some of the most popular developer tools, frameworks and experiences in the world are built around open communities. Here are a few featured Microsoft projects of note. Accessibility Insights Accessibility Insights is a suite of open source tools that help developers find and fix accessibility issues in Web, Windows and Android applications.
terurou 2014/02/18
.net

SQLite
ãƒªãƒ³ã‚¯
SQLite + Pythonãƒ¦ãƒ¼ã‚¶å®šç¾©é–¢æ•°çµ„è¾¼ã§é€²æ—ãƒ€ãƒ¡ã˜ã‚ƒãªã„ã§ã™ã«ãªã‚Šã¾ã—ãŸ - ã‚ã‚“ã¡ã¹ï¼
æ¦‚è¦ ã“ã‚Œã¾ã§ã€ŒHiveã‹ã‚‰ãƒ‡ãƒ¼ã‚¿å–å¾—ãƒ»ç°¡å˜ãªåŠ å·¥â†’Pythonã§åŠ å·¥ãƒ»åˆ†æžã€ ã¨ã„ã†æµã‚Œã§ä½œæ¥ã—ã¦ã„ãŸã®ã§ã™ãŒã€ Hiveâ†’SQLiteâ†’Pythonã¨ã„ã†æµã‚Œã«ã—ãŸã¨ã“ã‚é€²æ—ãŒæ”¹å–„ã•ã‚ŒãŸã®ã§ã€ SQLiteã®ç°¡å˜ãªä½¿ã„æ–¹ã¨Pythonã«ã‚ˆã‚‹SQLãƒ¦ãƒ¼ã‚¶å®šç¾©é–¢æ•°ã®çµ„è¾¼æ–¹æ³• ã«ã¤ã„ã¦ãƒ¡ãƒ¢ã‚’æ®‹ã—ã¦ãŠãã¾ã™ã€‚ ç‰¹ã«ãƒ¦ãƒ¼ã‚¶å®šç¾©é–¢æ•°ã®çµ„è¾¼ã‚’è‡ªç”±ã«å‡ºæ¥ã‚‹ã¨ã€ åˆ†æžã™ã‚‹éš›ã€ç›¸å½“æ¥½ã«ãªã‚‹ã¨ã„ã†ã“ã¨ã«æ°—ä»˜ãã¾ã—ãŸã€‚ SQLiteæŒŸã‚€ã“ã¨ã§ä½•ãŒã©ã†æ”¹å–„ã•ã‚ŒãŸã®ï¼Ÿ Hiveã¯ãƒ‡ã‚«ã„ãƒ‡ãƒ¼ã‚¿ã‚’ã‚´ãƒªã‚´ãƒªå–ã£ã¦ãã‚‹åˆ†ã«ã¯ SQLã¡ã‚‡ã£ã¨æ›¸ãã ã‘ã§æ¸ˆã‚€ã®ã§å¤§å¤‰ä¾¿åˆ©ã§ã™ãŒã€ åˆå‹•é…ã„ãŸã‚ã¡ã‚‡ã“ã¡ã‚‡ã“å°ã•ã„ãƒ‡ãƒ¼ã‚¿ã‚’ä½•åº¦ã‚‚å–ã‚ã†ã¨ã™ã‚‹ã¨ã‚¹ãƒˆãƒ¬ã‚¹æºœã¾ã‚Šã¾ã™ã€‚ ãã®ãŸã‚ã€ã“ã‚Œã¾ã§ã¯ã‚ã‚‹ç¨‹åº¦ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã¾ã¨ã‚ã¦Hiveã§è½ã¨ã—ã¦ãã¦ Pythonã§åŠ å·¥ã—ã¦ã‹ã‚‰åˆ†æžã™ã‚‹ã¨ã„ã†æµã‚Œã‚’å–ã£ã¦ã„ã¾ã—ãŸã€‚ ãŸã åŠ å·¥ã™ã‚‹ãŸã‚ã«ä¼¼ãŸã‚ˆã†ãªã‚³ãƒ¼ãƒ‰ä½•
terurou 2013/12/18
numpyã™ã”ã„äº‹æ¡ˆã

python

SQLite

Hive
ãƒªãƒ³ã‚¯
GitHub - kripken/sql.js
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
terurou 2013/04/04
SQLiteã‚’Emscriptenã§JavaScriptã«ãƒãƒ¼ãƒˆ

JavaScript

node.js

SQLite

SQL

RDBMS
ãƒªãƒ³ã‚¯
Using SQLite in a Metro style app
Thanks for visiting! Just a fair warning this post is fairly 'old' in tech terms and may contain outdated information and/or broken links or pictures. Please verify info and feel free to contact me if questions! At the â€œDeveloping Windows 8 Metro style apps with C++â€ event that happened on 18-May-2012, we saw and heard some very interesting things.Â If you were watching live then hopefully you did
terurou 2012/05/29
ã“ã‚“ãªã‚“ã‚ã‚‹ã®ã‹

WinRT

SQLite
ãƒªãƒ³ã‚¯
SDã‚«ãƒ¼ãƒ‰ã«SQLiteDatabaseã‚’æ§‹ç¯‰ã™ã‚‹æ–¹æ³•
WeatherNowã§ã¯æ¬¡ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚¢ãƒ¡ãƒ€ã‚¹ãƒ»å¤©æ°—æƒ…å ±ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åŒ–ã—ã¾ã™ã€‚ å®Ÿéš›ã«ä½œã£ã¦è©¦ã—ã¦ã¿ãŸã¨ã“ã‚ã‚¢ãƒ¡ãƒ€ã‚¹æƒ…å ±79ãƒ¬ã‚³ãƒ¼ãƒ‰ã§16KBã¨ãªã‚Šã€å°†æ¥çš„ã«å†…éƒ¨ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã«ä¿å˜ã™ã‚‹ã«ã¯ã¡ã‚‡ã£ã¨åŽ³ã—ããªã‚‹ã€‚ãªã®ã§SDã‚«ãƒ¼ãƒ‰ä¸Šã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã£ã¦ã¿ã¾ã—ãŸã€‚ ï¼Šã“ã“ã«è¼‰ã›ã¦ã„ã‚‹ã‚³ãƒ¼ãƒ‰ã¯å®Ÿéš›ã®ã‚³ãƒ¼ãƒ‰ã§ã¯ãªããƒ–ãƒã‚°ç”¨ã«æ‰‹æ‰“ã¡ã—ã¦ã„ã¾ã™ã€‚ãƒŸã‚¹ãŒã‚ã‚‹ã‹ã‚‚çŸ¥ã‚Œã¾ã›ã‚“ãŒæ‚ªã—ã‹ã‚‰ãšã€‚ å…ˆã«ã“ã¡ã‚‰ã®è¨˜äº‹ã‹ã‚‰èªã‚“ã§ä¸‹ã•ã„ãªã€‚ ã¾ãšã¯å¤±æ•—ã‚³ãƒ¼ãƒ‰ã€‚ ã“ã®ã‚µã‚¤ãƒˆæ§˜ã‚’å‚è€ƒã«ä½œã£ãŸã®ã§ã™ãŒã€ã“ã‚Œã‚’å®Ÿéš›ã«ä½¿ã£ã¦ã¿ã‚‹ã¨ java.lang.IllegalArgumentException: File /sdcard/weathernow/database/weathernow_database.db contains a path separator ã¨æ€’ã‚‰ã‚Œã¦ã—ã¾ã„ã¾ã—ãŸã€‚ã¡ãªã¿ã«TargetAPIã¯7ã§ã™ï¼ˆAndro
terurou 2011/08/24
Android2.1ã§ã¯SQLiteOpenHelperã§SDã‚«ãƒ¼ãƒ‰ã®ãƒ‘ã‚¹ï¼ˆã¨ã„ã†ã‹path separatorã‚’å«ã‚€ãƒ‘ã‚¹ï¼‰ã‚’æŒ‡å®šã§ããªã„

Android

SQLite
ãƒªãƒ³ã‚¯
LevelDB Benchmarks
Google, July 2011 In order to test LevelDB's performance, we benchmark it against other well-established database implementations. We compare LevelDB (revision 39) against SQLite3 (version 3.7.6.3) and Kyoto Cabinet's (version 1.2.67) TreeDB (a B+Tree based key-value store). We would like to acknowledge Scott Hess and Mikio Hirabayashi for their suggestions and contributions to the SQLite3 and Kyo
terurou 2011/07/29
ã“ã‚Œã€KyotoCabinet+Snappyã‚’å®Ÿè£…ã—ãŸã‚‰ã©ã†ãªã‚‹ã‚“ã ã‚ã†ãªã€‚å¤§ããã¯å¤‰ã‚ã‚‰ãªã„ã¨ã¯æ€ã†ã‘ã©ã€‚ã€‚ã€‚

LevelDB

SQLite

KyotoCabinet

benchmark
ãƒªãƒ³ã‚¯
Web SQL Database
W3C Working Group Note 18 November 2010 This Version: http://www.w3.org/TR/2010/NOTE-webdatabase-20101118/ Latest Published Version: http://www.w3.org/TR/webdatabase/ Latest Editor's Draft: http://dev.w3.org/html5/webdatabase/ Previous Versions: http://www.w3.org/TR/2009/WD-webdatabase-20091222/ http://www.w3.org/TR/2009/WD-webdatabase-20091029/ http://www.w3.org/TR/2009/WD-webstorage-20090423/ Ed
terurou 2010/11/22
Web SQL Databaseã¯å»ƒæ¡ˆã«ãªã£ã¦ãŸä»¶

html5

SQL

SQLite
ãƒªãƒ³ã‚¯
SQLiteã‚’ä½¿ã†å ´åˆã®æ³¨æ„ç‚¹ - ä¸€æ©ãšã¤ã‚³ãƒ„ã‚³ãƒ„ã¨
ã•ã¦ã€é•·ã„ã“ã¨æ”¾ç½®ã—ã¦ã„ãŸã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼ã®æ–¹ã§ã™ãŒã€ã¾ã¨ã‚æ›¸ãã—ãŸæ–¹ãŒã„ã„ã‚‚ã®ã¯ã€ã‚„ã£ã±ã‚Šã“ã¡ã‚‰ã«æ›¸ãã¨ã„ã†ã“ã¨ã§ã€‚ Androidã§SQLiteã‚’ä½¿ã†ã‚±ãƒ¼ã‚¹ã¯å¤šã€…ã‚ã‚‹ã¨æ€ã„ã¾ã™ãŒã€æ˜Žè¨€ã•ã‚Œã¦ã„ãªã„æ³¨æ„ç‚¹ãŒã‚ã‚‹ã®ã§å¿˜å‚™éŒ²ãŒã¦ã‚‰ã€‚ SQLite Database#closeã¯æ˜Žç¤ºã§å‘¼ã¶ãªã€Cursor#closeã¯æ˜Žç¤ºã§å‘¼ã¹ ã“ã‚Œã¯SQLiteã®ä½œã‚Šã®è©±ã§ã™ãŒã€SQLiteã§ã¯ãƒžãƒ«ãƒã‚¹ãƒ¬ãƒƒãƒ‰ã«å¯¾ã—ã¦ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã‚ªãƒ¼ãƒ—ãƒ³ã‹ã‚‰ã‚¯ãƒãƒ¼ã‚ºã¾ã§ã¯ä¿éšœã™ã‚‹ã€ã¨ã„ã†ä½œã‚Šã«ãªã£ã¦ã„ã¾ã™ã€‚ è¦ã¯ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³å˜ä½ã§ã‚¹ãƒ¬ãƒƒãƒ‰ã‚»ãƒ¼ãƒ•ã§ã™ã‚ˆã€ã¨ã„ã†ã“ã¨ã€‚ Androidã§SQLiteã‚’ä½¿ã£ã¦æ¤œç´¢ç³»ã®å‡¦ç†ã‚’ã™ã‚‹ã®ã«ã€ã„ã‚ã‚†ã‚‹Webã‚¢ãƒ—ãƒªçš„ãªä½œã‚Šã§è€ƒãˆã‚‹ã¨ã€æ›´æ–°ç³»å‡¦ç†ã§ã¯CUDå‡¦ç†ã®ã‚ã¨ã«SQLite Database#closeã¨ã—ãŒã¡ã§ã™ãŒã€android.database.sqlite.SQLiteException
terurou 2010/05/24
ã€ŒSQLiteDatabase#closeã¯æ˜Žç¤ºã§å‘¼ã¶ãªã€Cursor#closeã¯æ˜Žç¤ºã§å‘¼ã¹ã€

SQLite

Android
ãƒªãƒ³ã‚¯
Proof of concept: C#-SQLite running in Silverlight | Tim Anderson's IT Writing
Noah Hart has ported SQLite to C#. I was intrigued to see whether the code could be adapted to run in Silverlight, which has a cut-down .NET Framework and prohibits platform invoke to native code. I hacked away at his code until it ran in Silverlight: Note that the sole purpose of the exercise was to see if SQLite could be made to run, not to prepare a port that is production-ready or even code th
terurou 2010/03/20
csharp-sqliteã‚’ç„¡ç†ã‚„ã‚ŠSilverlightã§å‹•ãã‚ˆã†ã«ã—ãŸã‚‚ã®ã€‚

SQLite

silverlight

database

hack
ãƒªãƒ³ã‚¯
csharp-sqlite - Project Hosting on Google Code
Code Archive Skip to content Google About Google Privacy Terms
terurou 2010/03/20
File I/Oã‚’IsolatedStoregeä½¿ã†ã‚ˆã†ã«æ›¸ãæ›ãˆãŸã‚‰Silverlightã§ã‚‚å‹•ã

SQLite

.net

library

database
ãƒªãƒ³ã‚¯
SQLiteã‹ã‚ã„ã„ã‚ˆSQLiteï¼ˆâ€»ãŸã ã—limitã«é™ã‚‹ï¼‰ - Android Zaurusã®æ—¥è¨˜
id:minghaiã•ã‚“ãŒLIMITã—ãŸã‚‰ã©ã†ã‚ˆï¼Ÿã¨ãŠã£ã—ã‚ƒã£ã¦ãŸã®ã§ã€ã‚„ã£ã¦ã¿ãŸã€‚ã¾ãšLIMITã£ã…ã®ã®ä½¿ã„æ–¹ãŒã‚ã‹ã‚‰ã„ãªã„ï¼ˆãƒ¬ãƒ™ãƒ«ä½Žã£ï¼›ï¼žï¼œï¼‰ãªã®ã§ã€Ubuntuã§æ™®é€šã«è©¦ã—ãŸã€‚ $ time sqlite3 skk_dict.db "select * from dictionary where key like 'a%';" > /dev/null real 0m0.409s user 0m0.280s sys 0m0.076s $ time sqlite3 skk_dict.db "select * from dictionary where key like 'a%' limit 1000;" > /dev/null real 0m0.083s user 0m0.036s sys 0m0.016s ï¼ˆï¼ ï¼¿ï¼ ï¼›ï¼‰ãªã«ã“ã‚Œï¼ŸLIMITãªã—ã ã¨280msecã€LIMIT 1000ã§36
terurou 2010/02/26
limitä»˜ã‘ã‚‹ã¨ä½•æ•…ã‹ã‚¯ã‚¨ãƒªãŒé€Ÿããªã‚‹ã‚‰ã—ã„

Android

SQLite

performance
ãƒªãƒ³ã‚¯
Androidã§SQLiteã®DBæ“ä½œã‚’ã™ã‚‹ãŸã‚ã®åŸºç¤ŽçŸ¥è˜ (1/3) - ï¼ IT
Androidã§SQLiteã®DBæ“ä½œã‚’ã™ã‚‹ãŸã‚ã®åŸºç¤ŽçŸ¥è˜ï¼šAndroidã§å‹•ãæºå¸¯Javaã‚¢ãƒ—ãƒªä½œæˆå…¥é–€ï¼ˆ6ï¼‰ï¼ˆ1/3 ãƒšãƒ¼ã‚¸ï¼‰ æœ¬é€£è¼‰ã§ã€SDKã¨Eclipseã‚’ä½¿ã£ã¦Androidã®æºå¸¯ç«¯æœ«ã§å‹•ãJavaã‚¢ãƒ—ãƒªã‚’ä½œæˆã—ã€Android Marketé…å¸ƒã‚’ç›®æŒ‡ã—ã¾ã—ã‚‡ã† Androidã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚‚ã€ã„ã¾æµè¡Œä¸ã®ã€ŒSQLiteã€ Javaãƒ—ãƒã‚°ãƒ©ãƒžã¯ã€å¤§ããåˆ†ã‘ã‚‹ã¨2ç¨®é¡žã«åˆ†é¡žã•ã‚Œã¾ã™ã€‚ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºãƒ»ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ç³»Javaãƒ—ãƒã‚°ãƒ©ãƒžã¨ã€çµ„ã¿è¾¼ã¿ç³»Javaãƒ—ãƒã‚°ãƒ©ãƒžã§ã™ã€‚ ç†è€…ã¯çµ„ã¿è¾¼ã¿ç³»ã§ã™ãŒã€Javaã‚’å§‹ã‚ãŸãã£ã‹ã‘ã¯ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ç³»ï¼ˆæ£ç¢ºã«ã¯ã€Javaã‚¢ãƒ—ãƒ¬ãƒƒãƒˆï¼‰ã§ã™ã€‚ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ç³»ã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯å¿…é ˆã€ã¨ã„ã†ã‚ˆã‚Šã‚€ã—ã‚æœ€é‡è¦ã®ã‚·ã‚¹ãƒ†ãƒ ã§ã™ãŒã€çµ„ã¿è¾¼ã¿ç³»ã§ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ã¯ã»ã¨ã‚“ã©ã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸã€‚ãŸã ã—ã€ã€Œã“ã‚Œã¾ã§ã¯ã€ã§ã™ã€‚ ä»Šå›žã¯Androidã«æ¨™æº–ã§çµ„ã¿è¾¼ã¾
terurou 2010/02/24
Android

SQLite
ãƒªãƒ³ã‚¯
The Gaia-SINS federated project home-page
Spatial Is Not Special Spatial data processing simply is a branch in computing between many others: and spatial data are too much strategic and pervasive to be confined to niche applications
terurou 2010/01/07
SQLite

software
ãƒªãƒ³ã‚¯
GitHub - DbLinq/dblinq2007: LINQ provider for Oracle, PostgreSQL, MySQL, Ingres, SQLite, Firebird and ... SQL Server
Archived project: this project is not maintained anymore. #Welcome to DbLinq ##LINQ provider for Oracle, PostgreSQL, MySQL, Ingres, SQLite, Firebird and ... SQL Server (C# 3.0) DbLinq is THE LINQ provider that allows to use common databases with an API close to Linq to SQL. It currently supports (by order of appearance): MySQL, Oracle, PostgreSQL, SQLite, Ingres, Firebird... And still SQL Server.
terurou 2008/12/14
SQL Serverä»¥å¤–ã®DBç”¨ã®LINQãƒ‰ãƒ©ã‚¤ãƒ

.net

LINQ

database

C#

oracle

postgresql

SQLite

mysql

Firebird
ãƒªãƒ³ã‚¯
SQL Server Compact Edition 3.5ã®ä½¿ã„æ–¹ - ã‚„ãã†ã‚‰ãŠãƒ–ãƒã‚°(ç§»è»¢ã—ã¾ã—ãŸ)
Windowsã‚¢ãƒ—ãƒªã§ã‚‚ã¡ã‚‡ã£ã¨ã—ãŸãƒ‡ãƒ¼ã‚¿ã®æ ¼ç´ã®ãŸã‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ãˆã‚‹ã¨ä¾¿åˆ©ã§ã‚ã‚‹ã€‚å¾“æ¥ã¯ã€SQLiteãªã‚“ã‹ã‚’ä½¿ã£ã¦ã„ãŸã¨æ€ã†ã®ã ãŒã€SQL Server Compact Edition 3.5(ä»¥ä¸‹SQLSCe)ã¨ã„ã†ä¾¿åˆ©ãªã‚‚ã®ãŒã‚ã‚‹ã®ã§ã€ä»Šå›žã¯ã“ã‚Œã®ä½¿ã„æ–¹ã‚’è§£èª¬ã™ã‚‹ã€‚ ä¸»ãªåˆ©ç‚¹ã¯ ãƒ»LINQã§æ›¸ã‘ã‚‹ ãƒ»ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’VisualStudioã‹ã‚‰ç°¡å˜ã«ç·¨é›†ã§ãã‚‹ ãƒ»SQLiteã¨é•ã£ã¦åž‹ãŒã—ã£ã‹ã‚Šã—ã¦ã„ã‚‹ ãªã©ã€‚ å®Ÿè¡Œé€Ÿåº¦çš„ã«ã¯ã€SQLiteã¨ãã‚“ãªã«å¤‰ã‚ã‚‰ãªã„ã€‚ã‚‚ã®ã«ã‚ˆã£ã¦ã¯SQLiteã®ã»ã†ãŒé€Ÿã„ã—ã€ã‚‚ã®ã«ã‚ˆã£ã¦ã¯SQLSCeã®ã»ã†ãŒé€Ÿã„ã€‚ ä¸»ãªãƒ‡ãƒ¡ãƒªãƒƒãƒˆã¯ ãƒ»èª°ã‚‚ä½¿ã£ã¦ãªã„ã®ã§è³‡æ–™ã«ä¹ã—ã„ ãƒ»åˆ¶é™ãŒçµæ§‹ã‚ã‚‹ ãƒ»ä½œã‚Šè¾¼ã¿ãŒè¶³ã‚Šãªã„ ãªã©ã€‚ SQLSCeã¯å¤§å¤‰ä¾¿åˆ©ãªã‚·ãƒãƒ¢ãƒŽã§ã€Windowsã‚¢ãƒ—ãƒªé–‹ç™ºã«ãŠã„ã¦ã¯ä»Šå¾Œã‹ãªã‚Šé‡è¦ãªä½ç½®ã«æ¥ã‚‹ã‚‚ã®ã ã¨æ€ã†ã®ã ãŒã€ã ã¶ã‚“ã€å¤šãã®äººã¯ä½•ã‚’ã©ã†ã—
terurou 2008/11/24
SQLiteçš„ãªä½¿ã„æ–¹ãŒã§ãã‚‹SQL Server Compact Editionã«ã¤ã„ã¦ã€‚

database

SQLServer

SQLSCE

.net

C#

SQLite
ãƒªãƒ³ã‚¯
ADO.NET SQLite
SQLite ADO.NET 2.0 ProviderAn open source ADO.NET provider for the SQLite database engine System.Data.SQLiteÂ isÂ the original SQLite database engine and a complete ADO.NET 2.0 provider all rolled into a single mixed mode assem bly.Â It is a complete drop-in replacement for the original sqlite3.dll (you can even rename it to sqlite3.dll).Â Unlike normal mixed assem blies, it has no linker dependency o
terurou 2008/09/12
SQLiteã®.NETå®Ÿè£…

.net

C#

database

SQLite

library
ãƒªãƒ³ã‚¯
çª“ã®æœ - ã€REVIEWã€‘ã€ŒSQLiteã€ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’GUIã§æ“ä½œã§ãã‚‹é«˜æ©Ÿèƒ½ç®¡ç†ã‚½ãƒ•ãƒˆã€ŒPupSQLiteã€
ã€ŒPupSQLiteã€ã¯ã€ãƒ•ãƒªãƒ¼ã§åˆ©ç”¨ã§ãã‚‹è»½é‡ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã€ŒSQLiteã€ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’GUIã§ç®¡ç†ã§ãã‚‹ã‚½ãƒ•ãƒˆã€‚Windows XP/Vistaã«å¯¾å¿œã™ã‚‹å¯„ä»˜æ“è¿Žã®ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã§ã€ä½œè€…ã®Webã‚µã‚¤ãƒˆã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã€‚ãªãŠã€å‹•ä½œã«ã¯.NET Framework 2.0ä»¥é™ãŒå¿…è¦ã€‚ æœ¬ã‚½ãƒ•ãƒˆã«ã¯ã€ŒSQLiteã€ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªâ€œsqlite3.dllâ€ãŒåŒæ¢±ã•ã‚Œã¦ãŠã‚Šã€ç’°å¢ƒã®æ§‹ç¯‰ä½œæ¥ãªã©ãŒå¿…è¦ãªããã®ã¾ã¾åˆ©ç”¨å¯èƒ½ã€‚ç”»é¢ã¯MDIæ–¹å¼ã«ãªã£ã¦ãŠã‚Šã€è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãã‚Œãžã‚ŒåŒæ™‚ã«åã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã¨ã—ã¦é–‹ãã“ã¨ãŒã§ãã‚‹ã€‚å„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦å†…ã«ã‚¿ãƒ–åˆ‡ã‚Šæ›¿ãˆåž‹ã®ã‚°ãƒªãƒƒãƒ‰ãƒ“ãƒ¥ãƒ¼ã¨ã—ã¦è¡¨ç¤ºã•ã‚Œã‚‹ä»•çµ„ã¿ã€‚ æ©Ÿèƒ½ã‚‚å……å®Ÿã—ã¦ãŠã‚Šã€ãƒ†ãƒ¼ãƒ–ãƒ«å†…ãƒ‡ãƒ¼ã‚¿ã®é–²è¦§ãƒ»ç·¨é›†ã¯ã‚‚ã¡ã‚ã‚“ã€SQLæ–‡ã‚’ç™ºè¡Œã—ã¦çµæžœã‚’è¡¨å½¢å¼ã§é–²è¦§ã§ãã‚‹æ©Ÿèƒ½ã€ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ–‡ã‚’å‡ºåŠ›ã™ã‚‹æ©Ÿèƒ½ã€2ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’æ¯”
terurou 2008/09/05
Windowsä»¥å¤–ã§ã‚‚å‹•ãåŒç³»ã‚½ãƒ•ãƒˆã€‚http://reddog.s35.xrea.com/wiki/TkSQLite.html

windows

software

SQLite

é–‹ç™ºç’°å¢ƒ
ãƒªãƒ³ã‚¯
Wiki | CodeIgniter
Category:Core | Category:Core -> Community | Category:Core -> Database Introduction PHP5 core now includes the SQLite (file-based) database and PDO (PHP Data Objects) database interface layer. SQLite is an open-source, embedded, relational database.Â SQLite is written in C and is less than 1/4 Meg in size (the whole SQLite RDBMS â€˜engineâ€™ fits nicely in memory).Â SQLite is bullet fast (yes, faster
terurou 2008/06/19
CodeIgniter1.6.0-1.6.2ã§SQLite3ã‚’ä½¿ã†æ–¹æ³•ã€‚sqlite driverã®å†…éƒ¨ã§ä½¿ã‚ã‚Œã¦ã„ã‚‹sqlite_openãŒSQLite2ã«ã—ã‹å¯¾å¿œã—ã¦ãªã„ã®ã§ã€PDOã§æŽ¥ç¶šã—ãªã„ã¨ãƒ€ãƒ¡ã§ã™ã‚ˆã€ã¨ã€‚

php

framework

CodeIgniter

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