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

nilab id:nilab

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

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

Blogger
Google ã®ã‚¦ã‚§ãƒ–ãƒã‚°å…¬é–‹ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦ã€ãƒ†ã‚ã‚¹ãƒˆã€å†™çœŸã€å‹•ç”»ã‚’å…±æœ‰ã§ãã¾ã™ã€‚
nilab 2014/03/30
shiromaru ã—ã‚ã¾ã‚‹: SQliteã§æ—¥ä»˜ã®æ¼”ç®—ãŒã§ãã‚‹ã¿ãŸã„ã : date, time, datetime, julianday, strftime : SQLite ã®é–¢æ•°

datetime

sqlite
ãƒªãƒ³ã‚¯
https://sqlitebrowser.sourceforge.net/
nilab 2010/12/27
SQLite Database Browser

sqlite
ãƒªãƒ³ã‚¯
SQLJetÂ ::Â Pure Java SQLite
What is SQLJet SQLJet is an independent pure Java implementation of a popular SQLite database management system. SQLJet is a software library that provides API that enables Java application to read and modify SQLite databases. SQLJet does not support SQL queries; there is an API to work with the database on a lower level. SQLJet Google Group. SQLJet API Tutorial. SQLJet Sample Application: SQLite
nilab 2009/09/22
SQLJetÂ ::Â Pure Java SQLite : SQLJet is an independent pure Java implementation of a popular SQLite database management system. SQLJet is a software library that provides API that enables Java application to read and modify SQLite databases.

sqlite

java
ãƒªãƒ³ã‚¯
SQLite Java Wrapper
<H2> Frame Alert</H2> <P> This document is designed to be viewed using the frames feature. If you see this message, you are using a non-frame-capable web client. <BR> Link to<A HREF="overview-summary.html">Non-frame version.</A>
nilab 2009/04/17
Overview (SQLite Java Wrapper)

sqlite

java

java_lib
ãƒªãƒ³ã‚¯
SQLiteJDBC
SQLiteJDBC is a Java JDBC driver for SQLite. It runs using either a native code library 100% Pure Java driver based on NestedVM emulation. Both the pure driver and the native binaries for Windows, Mac OS X, and Linux x86 have been combined into a single jar file.
nilab 2009/04/17
SQLiteJDBC

sqlite

java

java_lib

jdbc
ãƒªãƒ³ã‚¯
SQLite3 on windows - ãã ãã æ—¥è¨˜
rails2.0ã‹ã‚‰ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒSQLiteã«å¤‰ã‚ã£ãŸã®ã§ã€ã•ã‚ã‚Šã ã‘ã§ã‚‚è§¦ã£ã¦ãŠã“ã†ã¨æ€ã„ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‹ã‚‰ãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆã¾ã§ã‚„ã£ã¦ã¿ã¾ã—ãŸã€‚windowsç‰ˆã§è©¦ã—ãŸã®ã§macç‰ˆã¯åˆ¥ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§ã€‚ è§¦ã‚‹å‰ã®SQLiteã®ã‚¤ãƒ¡ãƒ¼ã‚¸ è»½é‡dbms=ã‚ã¾ã‚Šä½¿ãˆãªã„dbmsãƒã‚¤ãƒŠãƒªãªã‚‰è¤‡é›‘ãªã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯ãªã—SQL92ã«æº–æ‹ ã—ã¦ã‚‹ã‘ã©ã€æœªå®Ÿè£…ã‚‚ä¸€æ¯SQL2000ã¯æœªå¯¾å¿œ ã¯ã“ã‚“ãªæ„Ÿã˜ã€‚ ã§ã¯å®Ÿéš›ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‹ã‚‰ 1.SQLiteã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« SQLiteã‹ã‚‰Windows Binaryã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯è§£å‡ã™ã‚‹ã ã‘ã€PATHã®é€šã£ã¦ã„ã‚‹æ‰€ã¸ç½®ã‘ã°ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å®Œäº†ã€‚ 2.ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆ SQLiteã¯ç‰¹ã«ã‚µãƒ¼ãƒ“ã‚¹ã¨ã‹ãŒã‚ã‚‹ã‚ã‘ã§ã¯ãªãã€ãƒ•ã‚¡ã‚¤ãƒ«ãƒ™ãƒ¼ã‚¹(Accessã¨ã‹db4oã¨ä¸€ç·’ãªæ„Ÿã˜)ãªã®ã§ãã®ã¾ã¾DBã‚’ã‚³ãƒžãƒ³ãƒ‰ã§æŒ‡å®šã™ã‚‹ã¨ä½œæˆã•ã‚Œã¾ã™ã€‚ sqlite3 ex
nilab 2009/04/15
SQLite3 on windows - ãã ãã æ—¥è¨˜

sqlite
ãƒªãƒ³ã‚¯
ã„ã„ã‚ã‚‚ãŠã“ã¥ã‹ã„å¸³ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®åˆ·æ–° - ã‚‚ãŽã‚ƒã‚ã
nilab 2009/04/15
ã„ã„ã‚ã‚‚ãŠã“ã¥ã‹ã„å¸³ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®åˆ·æ–° - ã‚‚ãŽã‚ƒã‚ã:sqlite2ã¯ãƒ‡ãƒ¼ã‚¿ã‚’éžåœ§ç¸®ã§æ ¼ç´:ãƒ‡ãƒ¼ã‚¿ãŒå¢—ãˆã‚‹ã¨ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºãŒç·šå½¢ã«å¢—ãˆ:ãŸã¾ã«insertã«100ç§’:DBãƒ•ã‚¡ã‚¤ãƒ«49MBã‚’è¶…ãˆã‚‹:1å¹´ä»¥ä¸Šä½¿ã£ã¦ã„ãªã„æ–¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’å‰Šé™¤

sqlite
ãƒªãƒ³ã‚¯
[SQLite JDBC] Javaã§å§‹ã‚ã‚‹SQLiteãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å…¥é–€
SQLiteãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€Cã§æ›¸ã‹ã‚ŒãŸè»½é‡ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ã€‚ã€Œè»½é‡ã€ã¨ã„ã†ã®ã¯2ã¤ã®æ„å‘³ãŒã‚ã£ã¦ã€å…¨ä½“ã®ã‚³ãƒ¼ãƒ‰æ•°ãŒ10ä¸‡è¡Œç¨‹åº¦ã¨ã„ã†ç‚¹ï¼ˆPostgreSQLã¯100ä¸‡è¡Œã«è¿‘ã¥ã„ã¦ã„ã¾ã™ï¼‰ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä¿å˜ã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ãŒ1ã¤ã«ç´ã¾ã£ã¦ã„ã‚‹ã®ãŒSQLiteã®ç‰¹å¾´ã§ã™ã€‚ä»–ã®ã‚·ã‚¹ãƒ†ãƒ ã ã¨ã€è¤‡æ•°ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç”¨ã®ãƒ•ã‚¡ã‚¤ãƒ«ãŒã‚ã£ã¦ç®¡ç†ãŒé¢å€’ãªã®ã§ã™ãŒã€SQLiteã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ãƒ•ã‚¡ã‚¤ãƒ«1ã¤ã§ã€ã—ã‹ã‚‚OSäº’æ›ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã§ä¿å˜ã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ç°¡å˜ã«OSã‚’ã¾ãŸãŒã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚³ãƒ”ãƒ¼ã‚’ä½œæˆã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ãã‚‚ãã‚‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆæ—¥æœ¬èªžã§ã¯é–¢ä¿‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨è¨³ã™ã“ã¨ãŒå¤šã„ã§ã™ï¼‰ã£ã¦ä½•ï¼Ÿã¨ã„ã†æ–¹ã¯ã€åˆå¿ƒè€…å‘ã‘ã«ç”¨æ„ã—ãŸä»¥ä¸‹ã®è¬›ç¾©è³‡æ–™ã‚’å‚è€ƒã«ã—ã¦ãã ã•ã„ã€‚ Javaã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œæˆã™ã‚‹ã«ã¯ã€JDBC (Java Database Connection)ã¨ã„ã†API
nilab 2008/12/02
Leo's Chronicle: [SQLite JDBC] Javaã§å§‹ã‚ã‚‹SQLiteãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å…¥é–€

sqlite

java_lib
ãƒªãƒ³ã‚¯
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ã‚’ãƒ‘ã‚¹ã®é€šã£ãŸãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ã‚³ãƒ”
nilab 2008/12/02
SQLite/Ruby

sqlite

ruby_lib
ãƒªãƒ³ã‚¯
1