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

syou6162 id:syou6162

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

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

C/C++ã‹ã‚‰SQLiteã‚’ä½¿ã† - PukiWiki
C++>C/C++ã‹ã‚‰SQLiteã‚’ä½¿ã† æ¦‚è¦ â€ SQLiteã‚’C++ã‹ã‚‰ä½¿ãŠã†ã¨æ€ã£ãŸã®ã§ã™ãŒã€ã‚ã¾ã‚Šå…¥é–€è€…å‘ã‘ã®ãƒšãƒ¼ã‚¸ãŒãªã„ã“ã¨ã‹ã‚‰ã„ã‚ã„ã‚å‹‰å¼·ã—ã¤ã¤è¦šæ›¸ã¨ã—ã¦ã¾ã¨ã‚ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ç’°å¢ƒã¯WindowsXPã€VC++2008 Express Editionã§ã™ã€‚ â†‘ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰æ‰‹é † â€ http://www.sqlite.org/ã¸ã„ã â†“ Downloadã‚’é¸æŠž â†“ sqlitedll-3_6_11.zip(dllã¨defãŒå…¥ã£ã¦ã„ã‚‹) sqlite-source-3_6_11.zip(SQLiteã®ã‚½ãƒ¼ã‚¹ãŒå…¥ã£ã¦ã„ã‚‹) ä»¥ä¸Šã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦è§£å‡ï¼ˆãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒç•°ãªã£ã¦ã‚‚ã„ã„ã¨æ€ã†ï¼‰ ã‚ã¨sqlite-3_6_11.zipã‚‚ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ãŠãã¨ã„ã„ã€‚ ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³æ“ä½œã™ã‚‹ã¨ãã«ä½¿ã†ã€‚ â†‘ LIBï¼ˆã‚¤ãƒ³ãƒãƒ¼ãƒˆãƒ©ã‚¤ãƒ–ãƒ©ãƒªï¼‰ã®ä½œæˆ â€ Visual Stadioã®
syou6162 2010/02/19
c++

sqlite
ãƒªãƒ³ã‚¯
SQLiteã§vacuum - Junk Blog
ã“ã“ã®MTã§ã¯SQLiteã‚’ä½¿ã£ã¦ã„ã‚‹ã€‚SQLiteã§DBã®å†æ§‹æˆ(vacuum)ã‚’ã™ã‚‹äº‹ã§ä¸è¦ãªé ˜åŸŸã‚’é–‹æ”¾ã§ãã‚‹ã€‚ã‚„ã‚‹äº‹ã¯ä»¥ä¸‹ã®ã¨ãŠã‚Šã€‚sqlite3 ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«å sqlite> vacuum sqlite> .quitå¿µã®ãŸã‚ã€è¡Œã†å‰ã«backupã‚’ã—ã¦ãŠãã€‚ã¡ãªã¿ã«2.5MB-> 2.2MBã¨1å‰²å‰Šæ¸›ã§ãã¾ã—ãŸã€‚
syou6162 2010/02/19
db

SQLite
ãƒªãƒ³ã‚¯
Google Code Archive - Long-term storage for Google Code Project Hosting.
Code Archive Skip to content Google About Google Privacy Terms
syou6162 2010/01/30
sqlite

c++

google
ãƒªãƒ³ã‚¯
ã´ã‚‡ã´ã‚‡ã´ã‚‡ï¼Ÿ - Linuxã¨ã‹ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®è¦šãˆæ›¸ã - - c/c++ã§sqliteã‚’ä½¿ã†æ–¹æ³•
sqlite3ã‚’c/c++ã§ä½¿ã†æ–¹æ³•ã«ã¤ã„ã¦ãƒ¡ãƒ¢ã€‚ ä»¥å‰ruby ã§ sqlite ã‚’ä½¿ã†æ–¹æ³• - ã´ã‚‡ã´ã‚‡ã´ã‚‡ï¼Ÿ - Linuxã¨ã‹ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®è¦šãˆæ›¸ã -ã§ã‚‚æ›¸ã„ãŸã‚ˆã†ã«ã€DBã‚’ä½¿ã†ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã€é€šå¸¸ã¯rubyãªã©ã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆè¨€èªžã§è¨˜è¿°ã—ãŸã»ã†ãŒæ¥½ã§ã™ã€‚ ã§ã‚‚c/c++ã‹ã‚‰ã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ãˆã‚‹ã¨éžå¸¸ã«ä¾¿åˆ©ã§ã™ã€‚ å…¬å¼ãªãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« http://www.sqlite.org/capi3ref.html å…¨APIã®ä¸€è¦§ãŒã‚ã‚Šã¾ã™ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« debian ã§ã‚ã‚Œã° libsqlite3-dev ã‚’å…¥ã‚Œã‚‹ã ã‘ã§ã™ï¼Ž $ sudo apt-get update $ sudo apt-get install libsqlite3-dev sqlite3 ã®API ã‚ˆãä½¿ã†APIã‚’åˆ—æŒ™ã—ã¦ã„ãã¾ã™ Database ã¸ã®æŽ¥ç¶š ãƒ‡ãƒ¼ã‚¿ãƒ¼ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã€ hogehoge.db
syou6162 2010/01/30
c++

SQLite
ãƒªãƒ³ã‚¯
DBIx::Classãƒ¡ãƒ¢ - ç™ºå£°ç·´ç¿’
Nekokak's core dumpï¼šPerl/DBICï¼šãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ« 101å·å®¤ï¼šDBIx::Classã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ï¼šãƒ†ãƒ¼ãƒ–ãƒ«é–“ã®é–¢ä¿‚ã‚’å›³ã§èª¬æ˜Ž PeroDocå’Œè¨³ï¼šDBIx::Class PeroDocå’Œè¨³ï¼šDBIx::Class::Manual::DocMap - ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«ã¯ä½•ãŒã‚ã‚Šã¾ã™ã‹ï¼Ÿ ä»Šæ—¥ã®CPANãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ï¼šuse DBIx::Class; æœ¬ç•ªã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å‹•ã‹ã™ã®ã¯MySQLã‹PostgreSQLã ã‘ã©ã€ãƒ†ã‚¹ãƒˆã¯SQLiteã§ã‚„ã‚ŠãŸã„ã€‚ ã¾ãšã¯ã€SQLiteã§ãƒ†ã‚¹ãƒˆãŒã§ãã‚‹ç’°å¢ƒã‚’Debian GNU/Linux Lennyä¸Šã«ç”¨æ„ã€‚ % sudo aptitude install libdbix-class-perl sqlite3 libdbd-sqlite3-perlæ¬¡ã«Nekokak's core dumpï¼šPerl/DBICã«ã—ãŸãŒã„ç·´ç¿’ã—ã¦ã¿
syou6162 2009/07/14
sqlite

perl

dbix-class
ãƒªãƒ³ã‚¯
https://www.sqlite.org/sqlite.html
syou6162 2008/06/02
sqlite

sql
ãƒªãƒ³ã‚¯
sqlite3 ã§ãƒ‡ãƒ¼ã‚¿ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆï¼†ã‚¤ãƒ³ãƒãƒ¼ãƒˆ - elm200 ã®æ—¥è¨˜(æ—§ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼)
sqlite3 ã§ ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆï¼†ã‚¤ãƒ³ãƒãƒ¼ãƒˆã—ã‚ˆã†ã¨ã—ãŸãŒã€æ„å¤–ã¨æƒ…å ±ãŒå°‘ãªãã¦é›£æ¸‹ã—ãŸã€‚ãã“ã§ã“ã“ã«ãƒ¡ãƒ¢ã™ã‚‹ã€‚ æƒ…å ±ã‚½ãƒ¼ã‚¹ SQLiteã®ãƒ‰ãƒƒãƒˆã‚³ãƒžãƒ³ãƒ‰ .help ã‚„ .schema ç‰ "." ã§ã¯ã˜ã¾ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã®ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€‚ ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆ ãŸã¨ãˆã°ã‚¿ãƒ–åŒºåˆ‡ã‚Šã§ãƒ†ãƒ¼ãƒ–ãƒ« foobar ã®å†…å®¹ã‚’ãƒ•ã‚¡ã‚¤ãƒ«ã«ä¿å˜ã—ãŸã„å ´åˆã¯æ¬¡ã®ã‚ˆã†ã«ã™ã‚‹ã€‚ % sqlite3 mydb.sqlite3 SQLite version 3.3.8 Enter ".help" for instructions sqlite> .mode tabs foobar # å‡ºåŠ›ã‚’ã‚¿ãƒ–åŒºåˆ‡ã‚Šè¡¨ç¤ºã«å¤‰æ›´ sqlite> .output foobar.txt # å‡ºåŠ›å…ˆã‚’ "foobar.txt" ãƒ•ã‚¡ã‚¤ãƒ«ã«å¤‰æ›´ sqlite> select * from foobar; # ãƒ‡ãƒ¼ã‚¿å‡ºåŠ›ã®ã‚ˆã†ã«è¡Œã†ã€‚ ã‚¤ãƒ³ãƒãƒ¼ãƒˆ
syou6162 2008/06/02
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ã‚’ãƒ‘ã‚¹ã®é€šã£ãŸãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ã‚³ãƒ”
syou6162 2008/05/31
db

ruby

sqlite
ãƒªãƒ³ã‚¯
sqlite3-ruby | ã ã‚ãªå
æ˜”ã®ãŠã„ã‚‰ã ã£ãŸã‚‰1ãƒ•ã‚¡ã‚¤ãƒ«1ãƒ¬ã‚³ãƒ¼ãƒ‰ã§ãƒ‡ãƒ¼ã‚¿ã‚’ã¨ã£ã¨ã„ãŸã‚Šã—ã¦ãŸã‚ã‘ã§ã™ãŒDBã®ä½¿ã„æ–¹ã‚’è¦šãˆã¦ã‹ã‚‰ã¯ãã‚“ãªã‚ã‚“ã©ãã•ã„ã“ã¨ã‚„ã£ã¦ã‚‰ã‚Œãªããªã‚Šã¾ã—ãŸ ã§ã‚‚ã€äººã«é…ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã§MySQLã¨ã‹ä½¿ã£ã¡ã‚ƒã†ã¨ã€æ˜Žã‚‰ã‹ã«ä½¿ã£ã¦ã‚‚ã‚‰ãˆãªã„ã‚³ãƒ¼ã‚¹ãªã®ã§ã€ãªã‚“ã‹ã„ã„æ–¹æ³•ããƒ¼ã‹ãªã¨æ€æ¡ˆã«æš®ã‚Œã¦ã„ãŸã‚‰SQLiteã®å˜åœ¨ã‚’æ€ã„å‡ºã—ã¾ã—ãŸ ã§ã€ã¡ã‚ƒã‚“ã¨èª¿ã¹ã¦ã¿ã‚‹ã¨ãƒ•ã‚¡ã‚¤ãƒ«ãƒ™ãƒ¼ã‚¹ã®DBã§ã€DLLã•ãˆã‚ã‚Œã°ã„ã„ï¼ï¼ã‚‰ã—ã„ ã™ã”ã„ï¼ ãƒ‘ãƒ–ãƒªãƒƒã‚¯ãƒ‰ãƒ¡ã‚¤ãƒ³ãªã‚“ã ã£ã¦ï¼ ã™ã”ã„ï¼ ã§ã€ä½¿ã£ã¦ã¿ãŸ å…¬å¼ã‹ã‚‰DLLè²°ã£ã¦ãã¦rubyã®binã«DLLç½®ã„ã¦gemã§é©å½“ã«ãƒ©ã‚¤ãƒ–ãƒ©ãƒªå¼•ã£å¼µã£ã¦ãã¦
syou6162 2008/05/31
ruby

db

sqlite
ãƒªãƒ³ã‚¯
SQLite - ãƒ‰ãƒƒãƒˆã‚³ãƒžãƒ³ãƒ‰
ã‚¹ãƒãƒ³ã‚µãƒ¼ãƒ‰ãƒªãƒ³ã‚¯ SQLiteã®ãƒ‰ãƒƒãƒˆã‚³ãƒžãƒ³ãƒ‰ .help ".help" ã¨å©ãã¨è‰²ã€…ãªã‚³ãƒžãƒ³ãƒ‰ãŒã‚ã‚‹ã“ã¨ãŒã‚ã‹ã‚‹ã®ã§ä¸€ã¤ä¸€ã¤è¦‹ã¦ã¿ã‚‹ã€‚ $ sqlite3 test.db SQLite version 3.3.6 Enter ".help" for instructions sqlite> .help .databases List names and files of attached databases .dump ?TABLE? ... Dump the database in an SQL text format .echo ON|OFF Turn command echo on or off .exit Exit this program .explain ON|OFF Turn output mode suitable for EXPLAIN on or off. .he
syou6162 2008/05/31
sqlite

db
ãƒªãƒ³ã‚¯
1