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

crema id:crema

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

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

mt-db-convert.cgi: MTãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç›¸äº’å¤‰æ›CGIã‚¹ã‚¯ãƒªãƒ—ãƒˆ - Ogawa::Memoranda
Posted by: Hirotaka Ogawa @ July 16, 2005 02:55 AM | Movable Typeã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’DBé–“ã§ç›¸äº’ã«ã‚³ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹CGIã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’å…¬é–‹ã—ã¾ã™ã€‚ MT Database Converter.ja JP - Ogawa Code Movable Typeã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’BerkeleyDBã€MySQLã€PostgreSQLã€SQLiteã®é–“ã§ç›¸äº’ã«å¤‰æ›ã™ã‚‹CGIã‚¹ã‚¯ãƒªãƒ—ãƒˆã§ã™ã€‚ãƒ†ã‚¹ãƒˆç’°å¢ƒã‹ã‚‰æœ¬ç•ªç’°å¢ƒã¸ã®ç§»è¡Œã€ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã®é–‹ç™ºã€ãã—ã¦DBã®ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ãªã©ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä¸€æ–¹ã‹ã‚‰ä»–æ–¹ã«ç§»è¡Œã—ãŸã„å ´åˆã«å½¹ã«ç«‹ã¡ã¾ã™ã€‚DBé–“ã®ç›¸äº’å¤‰æ›ã¯ã€å¾“æ¥ã‹ã‚‰Movable Typeã«ä»˜å±žã—ã¦ã„ã‚‹mt-db2sql.cgiã¨æ‹™ä½œã®mt-sql2db.cgiã‚’çµ„ã¿åˆã‚ã›ã‚Œã°å®Ÿç¾ã§ãã¾ã—ãŸãŒã€ã“ã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆã¯ãã‚Œã‚’å˜ä½“ã§å®Ÿç¾ã—ã¾ã™ã€‚ã¾ãŸã€mt-sql2d
crema 2008/01/10
movabletype

mysql

sqlite
ãƒªãƒ³ã‚¯
http://website.kodakara.com/archives/2006/10/mysqlsqlitedb.php
crema 2007/11/27
movabletype

mysql

sqlite
ãƒªãƒ³ã‚¯
ã‚µã‚¤ã‚ªãƒ³ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚ºæ ªå¼ä¼šç¤¾ â€” æ²–ç¸„çœŒã§ã®ã‚³ãƒ¼ãƒ«ã‚»ãƒ³ã‚¿ãƒ¼ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã€ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º Â» ç¬¬17å›ž Movable Typeã§ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã”ã¨ã®å‡¦ç†é€Ÿåº¦ã¨è² è·ã®é•ã„ã«ã¤ã„ã¦
ï¼“ï¼Žå†æ§‹ç¯‰ ã“ã“ã§ã¯å„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨é€£æºã•ã›ãŸMovable Typeã§ã€1000ä»¶ã®ã‚¨ãƒ³ãƒˆãƒªãŒã‚ã‚‹çŠ¶æ…‹ã§å†æ§‹ç¯‰ã‚’ è¡Œã£ãŸæ™‚ã®è² è·ã¨ã€å†æ§‹ç¯‰ã«ã‹ã‹ã£ãŸæ™‚é–“ã‚’èª¿æŸ»ã—ã¾ã—ãŸã€‚ ï¼“ï¼Žï¼‘ï¼ŽMySQL MySQLã§ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªçµæžœã«ãªã‚Šã¾ã—ãŸã€‚ å†æ§‹ç¯‰ã«è¦ã—ãŸæ™‚é–“:90ç§’ å‡¦ç†ä¸ã®å¹³å‡è² è·:81(%) ï¼“ï¼Žï¼’ï¼ŽBerkeleyDB BerkeleyDBã§ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªçµæžœã«ãªã‚Šã¾ã—ãŸã€‚ å†æ§‹ç¯‰ã«è¦ã—ãŸæ™‚é–“:90ç§’ å‡¦ç†ä¸ã®å¹³å‡è² è·:73(%) ï¼“ï¼Žï¼“ï¼ŽSQLite SQLiteã§ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªçµæžœã«ãªã‚Šã¾ã—ãŸã€‚ å†æ§‹ç¯‰ã«è¦ã—ãŸæ™‚é–“:94ç§’ å‡¦ç†ä¸ã®å¹³å‡è² è·:73(%) ï¼“ï¼Žï¼”ï¼ŽPostgreSQL Postgresqlã§ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªçµæžœã«ãªã‚Šã¾ã—ãŸã€‚ å†æ§‹ç¯‰ã«è¦ã—ãŸæ™‚é–“:118ç§’ å‡¦ç†ä¸ã®å¹³å‡è² è·:73(%) ï¼“ï¼Žï¼•ï¼Žæ¯”è¼ƒ æ¯”è¼ƒã™ã‚‹ã¨ä»¥ä¸‹ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ å‡¦ç†ä¸ã¯ã©ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç”¨ã„ã¦ã‚‚é«˜
crema 2007/11/27
movabletype

mysql

sqlite
ãƒªãƒ³ã‚¯
ã€ç‰¹é›†ã€‘ç”Ÿã¾ã‚Œå¤‰ã‚ã‚‹PHP - Zend Engine 2ã€SQLiteã®å®ŸåŠ›ã¯? (8) MySQLã¨SQLiteã®æ¯”è¼ƒ - å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã®æ›¸è¾¼ã¿ã§ã¯? | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
ã•ã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒä½œæˆã§ããŸã®ã§PHPã‹ã‚‰MySQLã€SQLiteãã‚Œãžã‚Œã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ“ä½œã—ã¦ã¿ã‚ˆã†ã€‚ã¾ãšã€å¤§é‡ãƒ‡ãƒ¼ã‚¿ã®æŒ¿å…¥ã‚’è¡Œã£ãŸå ´åˆã€ã©ã¡ã‚‰ãŒé€Ÿã„ã ã‚ã†ã€‚ä»¥ä¸‹ã®ã‚ˆã†ãªã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’æ›¸ã„ã¦æ¤œè¨¼ã—ã¦ã¿ã‚‹ã€‚ MySQLç”¨ <?php function getmicrotime(){ list($usec, $sec) = explode(" ",microtime()); return ((float)$sec + (float)$usec); } $lines = 1000; $con = mysql_connect("localhost", "root", ""); mysql_select_db("phptest"); $start = getmicrotime(); for ($i=0; $i<$lines; $i++) { $sql = sprintf("in
crema 2007/11/27
sqlite

mysql
ãƒªãƒ³ã‚¯
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ã£ã¦ã„ã†ã®ã¯ä½•ãªã®ã‹ã¨ã„ã†ã“
crema 2007/11/27
movabletype

sqlite

mysql
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (2)

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

ãŠçŸ¥ã‚‰ã›

ã€Œã‚ã¨ã§èªã‚€ã€ã‚¿ã‚°ã§æŒ¯ã‚Šè¿”ã‚‹2024å¹´ ã€œä»Šå¹´ã®ã€Œã‚ã¨ã§èªã‚€ã€ã€ä»Šå¹´ã®ã†ã¡ã«ã€œ

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (2)

sqliteã«é–¢ã™ã‚‹cremaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

mt-db-convert.cgi: MTãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç›¸äº’å¤‰æ›CGIã‚¹ã‚¯ãƒªãƒ—ãƒˆ - Ogawa::Memoranda

http://website.kodakara.com/archives/2006/10/mysqlsqlitedb.php

SQLiteã‚’Movable Typeã§ä½¿ã£ã¦ã¿ã‚‹ - Ogawa::Memoranda

ãŠçŸ¥ã‚‰ã›

ã€Œã‚ã¨ã§èª­ã‚€ã€ã‚¿ã‚°ã§æŒ¯ã‚Šè¿”ã‚‹2024å¹´ ã€œä»Šå¹´ã®ã€Œã‚ã¨ã§èª­ã‚€ã€ã€ä»Šå¹´ã®ã†ã¡ã«ã€œ

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (2)

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

mt-db-convert.cgi: MTãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç›¸äº’å¤‰æ›CGIã‚¹ã‚¯ãƒªãƒ—ãƒˆ - Ogawa::Memoranda

SQLiteã‚’Movable Typeã§ä½¿ã£ã¦ã¿ã‚‹ - Ogawa::Memoranda

ãŠçŸ¥ã‚‰ã›

ã€Œã‚ã¨ã§èªã‚€ã€ã‚¿ã‚°ã§æŒ¯ã‚Šè¿”ã‚‹2024å¹´ ã€œä»Šå¹´ã®ã€Œã‚ã¨ã§èªã‚€ã€ã€ä»Šå¹´ã®ã†ã¡ã«ã€œ

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹