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

starsky5 id:starsky5

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

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

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 "
starsky5 2010/12/02
INTEGERã˜ã‚ƒãªã„ã¨ã ã‚

sqlite

programming
ãƒªãƒ³ã‚¯
throw Life - Androidã§SQLiteã‚’åˆ©ç”¨ã—ãŸå®Ÿç”¨çš„ãªå…¥åŠ›è£œå®Œã®å®Ÿè£…
<?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:orientation="vertical" android:layout_width="fill_parent" android:layout_height="fill_parent"> <TextView android:layout_width="fill_parent" android:layout_height="wrap_content" android:text="[Tags DB]" /> <TextView android:id="@+id/saved_text" android:layout_width="fill_parent" a
starsky5 2009/10/19
android

sqlite

programming
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
starsky5 2009/10/10
sql-abstract

sqlite

javascript

library
ãƒªãƒ³ã‚¯
ã“ã®ãƒ–ãƒã‚°ã‹ã‚‰ã‚ˆãä½¿ã†ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã€äººæ°—ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã¾ã¨ã‚ - é›»åè¶£å‘³ã®éƒ¨å±‹
ã“ã®ãƒ–ãƒã‚°ã¯è‡ªåˆ†ã®ãƒ¡ãƒ¢ãŒä¸»ãªç›®çš„ãªã®ã§ã€ã‚ˆãè¦‹è¿”ã—ã¦ã„ã¾ã™ã€‚ç‰¹ã«ä¾‹æ–‡ã¯ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã¨ã—ã¦ä½¿ã†ã“ã¨ãŒå¤šã„ã§ã™ã€‚ ãã®ä¸ã‹ã‚‰ç‰¹ã«è‰¯ãä½¿ã†ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚„äººæ°—ã®ã‚ã‚‹ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‚’ã¾ã¨ã‚ã¾ã™ã€‚ iPhoneSDKã®UIViewã‚¢ãƒ‹ãƒ¡ãƒ¼ã‚·ãƒ§ãƒ³ iPhoneSDKã§ã‚¹ãƒªãƒ¼ãƒ—ã•ã›ãªã„æ–¹æ³• iPhoneSDKã§SQLiteã‚’ä½¿ã†æ–¹æ³• iPhoneSDKã§æœ¬ä½“ã®è¨€èªžè¨å®šã‚’å–å¾—ã™ã‚‹æ–¹æ³• iPhoneSDKã§ä½¿ãˆã‚‹ãƒ•ã‚©ãƒ³ãƒˆï¼ˆç”»åƒä»˜ãï¼ï¼‰ iPhoneSDKã§ã‚¤ãƒ³ã‚¸ã‚±ãƒ¼ã‚¿ï¼ˆå¾…ã¡ç‰ã«è¡¨ç¤ºã™ã‚‹å›žè»¢ç”»åƒï¼‰ã‚’ç°¡å˜ã«è¡¨ç¤ºã™ã‚‹æ–¹æ³• iPhone SDK ç”»é¢æ–¹å‘ã®å¤‰ãˆæ–¹ iPhone SDK ã§UIImageã®ç”»åƒã‚’SQLiteã®DBã«æ ¼ç´ã™ã‚‹æ–¹æ³• iPhoneSDKã§ã‚µã‚¦ãƒ³ãƒ‰ã®ç°¡å˜ãªå†ç”Ÿæ–¹æ³• iPhoneSDKã§åŠ¹æžœéŸ³ã®å†ç”Ÿæ–¹æ³• iPhoneã®åŠ é€Ÿåº¦ã‚»ãƒ³ã‚µã®ä½¿ã„æ–¹ URLã§ä½¿ã†ãŸã‚ã«NSStringã®æ–‡å—åˆ—ã‚’ã‚¨ãƒ³ã‚³ãƒ¼
starsky5 2009/07/30
iphone

ã¾ã¨ã‚

opengl

programming

sqlite
ãƒªãƒ³ã‚¯
iPhone SDK ã§UIImageã®ç”»åƒã‚’SQLiteã®DBã«æ ¼ç´ã™ã‚‹æ–¹æ³• - é›»åè¶£å‘³ã®éƒ¨å±‹
UIImageã«æ ¼ç´ã•ã‚ŒãŸç”»åƒã®ãƒã‚¤ãƒŠãƒªã‚¤ãƒ¡ãƒ¼ã‚¸ã‚’SQLiteã®DBã«ä¿å˜ã‚’ã™ã‚‹æ–¹æ³• SQLiteã®ä½¿ã„æ–¹ã¯iPhoneSDKã§SQLiteã‚’ä½¿ã†æ–¹æ³•ã«æ›¸ã„ã¦ã‚ã‚Šã¾ã™ã€‚ ã‚µãƒ³ãƒ—ãƒ«ã¨ã—ã¦ä½¿ã†ãƒ†ãƒ¼ãƒ–ãƒ« ã‚µãƒ³ãƒ—ãƒ«ã¨ã—ã¦ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å®šç¾©ã—ã¦ã€æ ¼ç´ã—ã¾ã™ã€‚ ãƒã‚¤ãƒŠãƒªãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã™ã‚‹é …ç›®ã¯blobã§å®šç¾©ã—ã¾ã™ã€‚ create table IMAGETABLE ( id integer, // ãªã‚“ã¨ãªãID size integer, // ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚º data blob // ãƒã‚¤ãƒŠãƒªãƒ‡ãƒ¼ã‚¿ ); ç”»åƒãƒ‡ãƒ¼ã‚¿ã®æ ¼ç´ UIImageã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ãƒ¡ã‚½ãƒƒãƒ‰ã®UIImagePNGRepresentationã‚’ä½¿ã£ã¦NSDataã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã«å¤‰æ›ã—ã¦ã‹ã‚‰ã€ãƒã‚¤ãƒˆé…åˆ—ã¨ã—ã¦ãƒ†ãƒ¼ãƒ–ãƒ«ã«æ›¸ãè¾¼ã¿ã¾ã™ã€‚ ç”»è³ªã‚ˆã‚Šã‚µã‚¤ã‚ºã‚’å„ªå…ˆã™ã‚‹ãªã‚‰ã°ã€UIImageJPEGRepresentationã§ã‚‚ã‹ã¾ã„ã¾ã›ã‚“
starsky5 2009/07/30
development

image

iphone

programming

sqlite
ãƒªãƒ³ã‚¯
[remedie][perl] remedie ã§ Rose::DB ã®ã‚¨ãƒ©ãƒ¼ãŒå‡ºã‚‹ä»¶, ä»Šæ—¥ã®(ry, [PC][Logcool] Logicool ã® SetPoint 4.7 ã¯åœ°é›· - HsbtDiary(2008-12-13)
â– [remedie][perl] remedie ã§ Rose::DB ã®ã‚¨ãƒ©ãƒ¼ãŒå‡ºã‚‹ä»¶ remedie ã§ä¸€æ‹¬æ›´æ–°ã—ãŸã‚Šã€é•·æ™‚é–“æ”¾ç½®ã—ã¦ã„ãŸã‚Šã™ã‚‹ã¨ Rose::DB ãŒã†ã’ã»ãŒã¨ã‚¨ãƒ©ãƒ¼ãŒå‡ºã¦ã—ã¾ã£ã¦ã€SQLite ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ãŒãƒãƒƒã‚¯ã•ã‚Œã¦ã—ã¾ã†ã‚ˆã†ãªç¾è±¡ãŒç™ºç”Ÿã—ã¦ã„ãŸã®ã§ #remedie ã§ç›¸è«‡ã—ã¦ã¿ãŸã€‚ æ—©é€Ÿã€miyagawa ã•ã‚“ã‹ã‚‰ DBD::SQLite ã‚’ http://svn.coderepos.org/share/lang/perl/DBD-YASQLite/trunk/ ã«å…¥ã‚Œæ›¿ãˆã¦ã¿ã¦ã¯ã©ã†ã‹ã¨æ•™ãˆã¦ã‚‚ã‚‰ã£ãŸã®ã§ã€ã•ãã£ã¨ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’å…¥ã‚Œæ›¿ãˆãŸã‚‰ã€Rose::DBãªã‚“ã ã‹ã‚“ã ã¨ã„ã†ã‚¨ãƒ©ãƒ¼ã¯ã¨ã‚Šã‚ãˆãšå‡ºãªããªã£ãŸã£ã½ã„ã€‚ â– ä»Šæ—¥ã®(ry å½¼å¥³ãŒå¤•æ–¹ã‹ã‚‰å¤–å‡ºã™ã‚‹ç”¨äº‹ãŒã‚ã‚‹ã¨ã„ã†ã“ã¨ãªã®ã§ä¹…ã—ã¶ã‚Šã®å¤–ãƒ‡ãƒ¼ãƒˆã€‚ ä»Šæ—¥ã¯æ•´ä½“ã«è¡Œã£ã¦ãƒã‚ãƒã‚æ²»ç™‚ã—ã¦ã‹ã‚‰ã€æ¯Žåº¦ãŠ
starsky5 2009/03/08
remedie

perl

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
starsky5 2009/02/13
sqlite

perl

cpan
ãƒªãƒ³ã‚¯
DBMã«ã‚ˆã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ãã®å¼ - mixi engineer blog
ã‚¤ãƒ³ãƒ•ãƒ«ã‚¨ãƒ³ã‚¶ã§ä¼‘ã‚“ã å½±éŸ¿ã§ä»•äº‹ãŒé¬¼ã®ã‚ˆã†ã«æºœã¾ã£ã¦æ¶ˆåŒ–ä¸è‰¯ã®mikioã§ã™ï¼ˆã“ã‚“ãªè¨˜äº‹ã‚’æ›¸ã„ã¦ã„ã‚‹å ´åˆã˜ã‚ƒãªã„ï¼‰ã€‚ã•ã¦ä»Šå›žã¯ã€Tokyo Cabinetã§ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«é¢¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å®Ÿç¾ã—ãŸãƒ†ãƒ¼ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆTCTDBï¼‰ã®å®Ÿè£…ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ SQLiteã¨ã®é•ã„ã¯ï¼Ÿ SQLiteã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³çµ„ã¿è¾¼ã¿åž‹ã®SQLå¯¾å¿œãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã™ã€‚TCã®ãƒ†ãƒ¼ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚ˆã‚Šã‚‚ã¯ã‚‹ã‹ã«é«˜æ©Ÿèƒ½ã§ã€ãã‚Œã§ã„ã¦æ€§èƒ½ã‚‚å¤§å¤‰å„ªã‚Œã¦ã„ã¾ã™ã€‚ã„ã‚ã‚†ã‚‹ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ—ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«çµ„ã¿è¾¼ã‚€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãŠæŽ¢ã—ã§ã‚ã‚Œã°ã€TCãªã‚“ã‹ã§ã¯ãªãã€æ–ç„¶SQLiteãŒãŠã™ã™ã‚ã§ã™ã€‚ ä¸€æ–¹ã§ã€TCãªã©ã®DBMã¯ã€ã‚ˆã‚Šå˜ç´”ãªãƒ‡ãƒ¼ã‚¿æ“ä½œã‚’ã‚ˆã‚Šé«˜é€Ÿã«å®Ÿè¡Œã§ãã‚‹ã‚ˆã†ã«è¨è¨ˆãŠã‚ˆã³å®Ÿè£…ã•ã‚Œã¦ã„ã¾ã™ã€‚å…¸åž‹çš„ãªãƒ¦ãƒ¼ã‚¹ã‚±ãƒ¼ã‚¹ã¨ã—ã¦ã€å¤§è¦æ¨¡Webã‚µã‚¤ãƒˆã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆç®¡ç†ã‚„ã€ãƒ‡ãƒ¼ã‚¿ãƒžã‚¤ãƒ‹ãƒ³ã‚°ã«ä¼´ã†é›†è¨ˆæ“ä½œãŒæŒ™ã’ã‚‰
starsky5 2009/01/27
database

sqlite

mixi

tokyocabinet

algorithm
ãƒªãƒ³ã‚¯
Mailing List Archive: Cannot install pysqlite on Cygwin
starsky5 2008/10/26
python

sqlite

cygwin
ãƒªãƒ³ã‚¯
cygwinã§SQLite3 - ãƒˆã‚¦ãƒ•æ—¥è¨˜
è¿‘é ƒã¯coLinuxãªã®ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€ãƒ¡ãƒ³ãƒ‰ãƒ¼ãªã‚“ã§cygwinã§ã€‚ 1.sqlite3ã®ã‚½ãƒ¼ã‚¹ã‚’ã¨ã£ã¦ãã‚‹ã€‚(ä»Šå›žã¯sqlite-3.2.7ã‚’ä½¿ç”¨) 2.è§£å‡ã—ã¦READMEã®é€šã‚Šã«configure,makeã€‚ 3.make installã™ã‚‹å‰ã«ã€tclinstller.tclã‚’ä¿®æ£ã€‚ã¡ãªã¿ã«tclã®ã“ã¨ã¯ä½•ã«ã‚‚ã‚ã‹ã£ã¦ã¾ã›ã‚“ã®ã§ã€ã‚ã—ã‹ã‚‰ãšã€‚ å…ƒãƒ•ã‚¡ã‚¤ãƒ«ã¨diffã—ãŸçµæžœã€‚ --- tclinstaller.tcl.orig 2005-11-25 11:12:46.772580800 +0900 +++ tclinstaller.tcl 2005-11-25 11:15:42.905848000 +0900 @@ -5,9 +5,9 @@ # tclsh tclinstaller.tcl 3.0 # set VERSION [lindex $argv 0] -set LIBFI
starsky5 2008/10/26
cygwin

sqlite
ãƒªãƒ³ã‚¯
#4929 (Persistent 'database is locked' error) â€“ The Trac Project
starsky5 2008/08/06
database is lockedå•é¡Œã®è§£æ±ºç–

trac

sqlite
ãƒªãƒ³ã‚¯
Webåˆ©ç”¨ã¯ã‚ªãƒ•ãƒ©ã‚¤ãƒ³ã«æ‹¡å¤§ã¸ï¼Œä¼æ¥ã‚¢ãƒ—ãƒªã‚‚å¤‰ã‚ã‚‹ï¼Ÿ
ã‚ªãƒ•ãƒ©ã‚¤ãƒ³æ©Ÿèƒ½ã¯ï¼Œãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã«ã¤ãªãŒã£ã¦ã„ãªã„çŠ¶æ…‹ã§ã‚‚Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½¿ãˆã‚‹ã‚ˆã†ã«ã™ã‚‹ä»•çµ„ã¿ã ã€‚å¤§ã¾ã‹ã«ã¯ï¼ŒWebã‚µãƒ¼ãƒãƒ¼å´ã§ã¯ãªããƒ‘ã‚½ã‚³ãƒ³å´ã«Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ã¦åˆ©ç”¨ã—ï¼Œãã“ã§å…¥åŠ›ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚‚ãƒãƒƒãƒˆã«ã¤ãªãŒã‚‹ã¾ã§ã¯ãƒ‘ã‚½ã‚³ãƒ³å´ã«è“„ç©ã™ã‚‹ã€‚ ã‚ªãƒ•ãƒ©ã‚¤ãƒ³ã§ã®Webåˆ©ç”¨ã¯ï¼Œç±³ã‚°ãƒ¼ã‚°ãƒ«ãŒ2007å¹´ã«ã€ŒGoogle Gearsã€ã‚’å…¬é–‹ã—ãŸã“ã¨ã§è„šå…‰ã‚’æµ´ã³ã‚‹ã‚ˆã†ã«ãªã£ãŸã€‚Google Gearsã¯ï¼ŒWebãƒ–ãƒ©ã‚¦ã‚¶ã¨é€£æºã—ã¦å‹•ãå˜ä½“ã®ãƒ„ãƒ¼ãƒ«ã€‚ãƒ‘ã‚½ã‚³ãƒ³ã¸ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒå¿…è¦ã§ï¼Œã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã¯ã“ã®ãƒ„ãƒ¼ãƒ«ã«å¯¾å¿œã—ãŸWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã‚ªãƒ•ãƒ©ã‚¤ãƒ³ç’°å¢ƒã§ä½¿ãˆã‚‹ã€‚ä¾‹ãˆã°ã‚°ãƒ¼ã‚°ãƒ«ãŒæä¾›ã™ã‚‹æ–‡æ›¸ä½œæˆãƒ»å…±æœ‰ã®Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ»ã‚µãƒ¼ãƒ“ã‚¹ã€ŒGoogleãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã€ãŒå¯¾å¿œã—ã¦ã„ã‚‹ã€‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯ã©ã‚“ãªçŠ¶æ³ã§ã‚‚ï¼ŒGoogleãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’ä¸€èˆ¬çš„ãªãƒ¯ãƒ¼ãƒ—ãƒãƒ»ã‚½ãƒ•ãƒˆã¨åŒã˜æ„Ÿè¦šã§ä½¿ãˆã‚‹ã€‚ ãƒ–ãƒ©ã‚¦ã‚¶
starsky5 2008/07/08
ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚‚å•é¡Œã‚ã‚Šã€‚

gears

sqlite
ãƒªãƒ³ã‚¯
SqliteToPgScript â€“ Trac Hacks - Plugins Macros etc.
The page Sqlite ToPgScript does not exist. You can create it here.
starsky5 2008/07/03
trac

postgresql

sqlite
ãƒªãƒ³ã‚¯
Mac(Panther)+MAMP+Xcode+DBD SQLite+DBI+MovableType4ãƒ»ãã®1
Mac(Panther)+MAMP+Xcode+DBD SQLite+DBI+MovableType4 å‚è€ƒï¼š >> MAMP1.41+Movable Type3.34ãƒ»ãã®1 å½“ãƒ–ãƒã‚°ã§ã®è§£èª¬ç’°å¢ƒã¯MacOS X10.3ï¼ˆPantherï¼‰ ã¨ãªã£ã¦ãŠã‚Šãƒžã‚¹ã€‚ Movable Type4ã‹ã‚‰ã¯åˆ©ç”¨ã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒ MySQLã€PostgreSQLã€SQLiteã®ï¼“ã¤ã¨ãªã‚Š ä»Šã¾ã§å½“ãƒ–ãƒã‚°ã®è§£èª¬ã§ã¯BerkeleyDBåˆ©ç”¨ã—ã¦ã„ãŸã®ã§ è¨å®šã‚’å¤‰æ›´ã™ã‚‹å¿…è¦ãŒã‚ã‚Šãƒžã‚¹ã€‚ ä»Šå›žã¯MAMPã§åˆ©ç”¨ã§ãã‚‹SQLiteã‚’ä½¿ç”¨ã€‚ ä¸‹è¨˜ã®è§£èª¬ã¯MAMPã¨Movable Type4ãŒ ã™ã§ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹çŠ¶æ…‹ã‚’å‰æã«è§£èª¬ã‚’ã—ã¦ãŠã‚Šãƒžã‚¹ã€‚ MAMPã¨Movable Type4ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒæ¸ˆã‚“ã§ã„ãªã„å ´åˆã¯ >> MAMP1.41+Movable Type3.34ãƒ»ãã®1 ã®è§£èª¬ã‚’ã¾ãšã”è¦§ãã ã•ã„ã€‚
starsky5 2008/06/18
mac

mt

blog

sqlite
ãƒªãƒ³ã‚¯
SQLiteã‚’Movable Typeã§ä½¿ã£ã¦ã¿ã‚‹ - Ogawa::Memoranda
Posted by: Hirotaka Ogawa @ August 26, 2004 06:21 PM | ã€ŒMovable Typeã®ãƒžã‚¤ãƒŠãƒ¼æ©Ÿèƒ½ã‚’ä½¿ã£ã¦ã¿ã‚‹ã€ã‚·ãƒªãƒ¼ã‚ºç¬¬äºŒå¼¾ã€‚ç¬¬ä¸€å¼¾ã¯ã€ŒOgawa::Memoranda: mt-view.cgiã‚’ä½¿ã£ã¦ã¿ã‚‹ã€ã€‚ ã‚ã¾ã‚ŠçŸ¥ã‚‰ã‚Œã¦ã„ãªã„ã“ã¨ã§ã™ãŒã€MT3.1ã®ã€Œãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã”ã¨ã«ç®¡ç†å¯èƒ½ãªãƒ€ã‚¤ãƒŠãƒŸãƒƒã‚¯PHPãƒšãƒ¼ã‚¸ç”Ÿæˆã€æ©Ÿèƒ½ã¯BerkeleyDBã§ã¯å‹•ä½œã—ã¾ã›ã‚“ã€‚3.1ã§ã“ã®æ©Ÿèƒ½ã‚’ä½¿ã„ãŸã„äººã¯MySQLã‹PostgreSQLã‹SQLiteã«ã¨ã£ã¨ã¨ç§»è¡Œã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ã“ã®ã†ã¡ã€MySQLã€PostgreSQLã¯ä¸‰å±¤Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ§‹ç¯‰ã«ãŠã„ã¦ã¯ã”ããƒ¡ã‚¸ãƒ£ãƒ¼(ã‹ã¤å®‰ä¾¡)ãªã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã§ã‚ã‚‹ä¸€æ–¹ã€è¨ˆç®—æ©Ÿã«è¦ªã—ã¿åˆ‡ã‚Œã¦ã„ãªã„äººã€…ã«ã¨ã£ã¦ã¯å–ã£ä»˜ãã®æ‚ªã„ã®ã‚‚äº‹å®Ÿã§ã™ã€‚ãã“ã§è€ƒãˆã¦ã¿ãŸã„ã®ã¯ã€ã‚„ã¯ã‚ŠSQLiteã£ã¦ã„ã†ã®ã¯ä½•ãªã®ã‹ã¨ã„ã†ã“
starsky5 2008/06/18
mt

sqlite

database

performance
ãƒªãƒ³ã‚¯
http://www.machu.jp/posts/20061002/
starsky5 2008/03/15
rails

ruby

sqlite
ãƒªãƒ³ã‚¯
http://www.machu.jp/posts/20070117/p01/
starsky5 2008/03/15
sqlite

rails
ãƒªãƒ³ã‚¯
Mac OSXå‘ã‘SQLiteãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰Â·SqliteQuery MOONGIFT
Rails2.0ã‹ã‚‰ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒSQLite3ã«ãªã£ãŸã€‚MySQLã®ã‚ˆã†ã«åˆ¥é€”ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒä¸è¦ãªåˆ†ã€é–‹ç™ºãŒã•ã‚‰ã«å®¹æ˜“ã«ãªã£ãŸã¨è¨€ãˆã‚‹ã€‚SQLã‚’ã»ã¨ã‚“ã©åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒãªã„ãŒã€ãã‚Œã§ã‚‚ä½•ã‚‚ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ãŒãªã„ã®ã¯å¯‚ã—ã„ã€‚ ãã“ã§SQLã‚’å®Ÿè¡Œã™ã‚‹ã®ã¿ã§ã¯ã‚ã‚‹ãŒã€ã“ã‚Œã‚’ä½¿ã£ã¦ã¿ã‚‹ã®ã¯ã©ã†ã ã‚ã†ã‹ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯SqliteQueryã€SQLite3ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã ã€‚ SqliteQueryã¯Mac OSXå‘ã‘ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã€SQLã‚’å®Ÿè¡Œã—ã€ãã®çµæžœã‚’è¡¨ç¤ºã™ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚SQLite3è‡ªä½“ã¯ç®¡ç†æ©Ÿèƒ½ãªã©ã¯æŒã¡åˆã‚ã›ãªã„ã®ã§ã€ååˆ†ã¨è¨€ãˆã°ååˆ†ãã†ã ã€‚ãŸã ã—ãƒ†ãƒ¼ãƒ–ãƒ«ä¸€è¦§ãªã©ãŒã¨ã‚Œãªã„ã®ãŒè¾›ã„ã€‚ åŸºæœ¬çš„ã«ã¯ä½•ã‚‰ã‹ã®SQLã‚’å®Ÿè¡Œã—ã¦ã€ãã®çµæžœã‚’è¡¨ç¤ºã™ã‚‹ã¨è¨€ã†ã“ã¨ã«ãªã‚‹ã€‚CREATE TABLEã€INSERTã€SELECTãªã©ã€å„ç¨®SQLã¯ãã®ã¾ã¾åˆ©ç”¨ã§ãã‚‹
starsky5 2008/02/26
mac

sqlite

rails
ãƒªãƒ³ã‚¯
Firefox 3 ã¯SQLiteã§ã‚ªãƒ•ãƒ©ã‚¤ãƒ³ä¿å˜é ˜åŸŸã‚’ã‚µãƒãƒ¼ãƒˆ : ã‚‰ã°Q
Firefox 3 ã¯SQLiteã§ã‚ªãƒ•ãƒ©ã‚¤ãƒ³ä¿å˜é ˜åŸŸã‚’ã‚µãƒãƒ¼ãƒˆ Firefox 3ãŒã‚ªãƒ•ãƒ©ã‚¤ãƒ³ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ç”¨ã«SQLiteã‚’ã‚µãƒãƒ¼ãƒˆã¨ã„ã†è¨˜äº‹ãŒè©±é¡Œã«ãªã£ã¦ã„ã‚‹ã€‚ SQLiteã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ ã®ä¸€ç¨®ã ãŒã€æ™®é€šã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨é•ã£ã¦ã€ãƒ—ãƒã‚°ãƒ©ãƒ å†…éƒ¨ã«çµ„ã¿è¾¼ã‚“ã§ä½¿ã†ã®ãŒç‰¹å¾´ã€‚ ã“ã‚Œã§ä½•ãŒã§ãã‚‹ã‹ã¨ã„ã†ã¨ã€ç°¡å˜ã«è¨€ãˆã°ã€ã‚¦ã‚§ãƒ–ãƒ–ãƒ©ã‚¦ã‚¶ã§å‹•ããƒ—ãƒã‚°ãƒ©ãƒ ã§ã‚ã‚‹JavaScriptã§æ‰‹å…ƒã®ãƒ‘ã‚½ã‚³ãƒ³ã«ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ãŠã‘ã‚‹ã‚ˆã†ã«ãªã‚‹ã€‚ç¾çŠ¶ã®JavaScriptã¯ãƒ‡ãƒ¼ã‚¿ã®ä¿å˜æ‰‹æ®µãŒAjaxã¨å‘¼ã°ã‚Œã‚‹ã‚µãƒ¼ãƒã¨é€šä¿¡ã—ã¦ãƒ‡ãƒ¼ã‚¿ã‚’é€ã£ã¦ã‚‚ã‚‰ã†ä»•çµ„ã¿ã—ã‹ç„¡ã„ã€‚ãã®ãŸã‚ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã«ç¹‹ãŒã£ã¦ãªã‘ã‚Œã°ãƒ‡ãƒ¼ã‚¿ã‚’å‘¼ã³å‡ºã™ã“ã¨ã‚‚ã§ããªã‹ã£ãŸã®ã ãŒã€Firefoxã«å†…è”µã•ã‚Œã‚‹SQLiteã«ãƒ‡ãƒ¼ã‚¿ã‚’ã‚³ãƒ”ãƒ¼ã—ã¦ä¿å˜ã—ã¦ãŠã‘ã°ã€å›žç·šã‚’åˆ‡ã£ã¦ã‚‚ãƒ‡ãƒ¼ã‚¿ãŒå‘¼ã³å‡ºã›ã‚‹ã¨ã„ã†ã‚ã‘ã ã€‚ ã“ã‚Œã«ã‚ˆã£ã¦ã€Gmailãªã©ã®ã‚¦ã‚§ãƒ–ãƒ¡ãƒ¼ãƒ©ãƒ¼ã‚’ã‚ªãƒ•
starsky5 2008/01/17
safariã˜ã‚ƒã ã‚ã§ã™ã‹ã€ãã†ã§ã™ã‹

firefox

sqlite

database
ãƒªãƒ³ã‚¯
debian ã§ mod_python ã¨ sqlite3 ã§ django - mitszoã®æ—¥è¨˜
â– [ãƒ¡ãƒ¢][Django][Linux]debian ã§ mod_python ã¨ sqlite3 ã§ django 11:22 åˆé–“ã«mod_python ã§ Django ã‚’å‹•ã‹ã™ã‚’è¦‹ãªãŒã‚‰ Debianï¼ˆå®Ÿã¯çŽ„ç®±ï¼‰ã§è©¦ã—ã«å‹•ã‹ãã†ã¨ã—ã¦ã¿ãŸã‚‰ãã®ã¾ã¾ã ã¨å‹•ã‹ãªã‹ã£ãŸã€‚ ã€Œunable to open database fileã€ã£ã¦è¡¨ç¤ºã•ã‚Œã‚‹ã®ã§ã€ãªã‚“ã ã€œï¼Ÿã¨æ€ã£ã¦ã‚¢ã‚¯ã‚»ã‚¹æ¨©ã¨ã‹å¤‰ãˆã¦ã¿ãŸã‚Šã—ãŸã‘ã©å‹•ã‹ãªã„ã€‚ çµå±€ settings.py ã® DATABASE_NAME = 'data.db' ã¨æ›¸ã„ã¦ãŸéƒ¨åˆ†ã‚’ãƒ•ãƒ«ãƒ‘ã‚¹ã§ DATABASE_NAME = '/var/xxx/yyy/data.db' BASE_PATH = os.path.dirname(__file__) ... DATABASE_NAME = os.path.join(BASE_PATH, 'data.db')
starsky5 2007/12/03
django

python

sqlite

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