== ¼Ò°³ == * À̸§: ½Å±â¹è * ȨÆäÀÌÁö: http://sota.nonun.com/ == °ü½É»ç == 1. PostgreSQL 1. SQLite 1. JavaScript 1. PHP == ¿ÀǼҽº == 1. SQLiteDBMS * BSD ¶óÀ̼¾½º * ±â´É * SQLite 3.x Áö¿ø * TCP/IP ¼­¹ö µ¥¸ó * HTTP ¿äû, XML ÀÀ´ä * °¡º­¿î À¥¼­¹ö ³»Àå(WebDAV Áö¿ø) * SSL, HTTP ±â¹Ý ÀÎÁõ * Multi slave ¸®Çø®ÄÉÀÌ¼Ç Áö¿ø * Prepared statement Áö¿ø * Äõ¸®Ä³½¬ Áö¿ø * ´Ù¾çÇÑ È®Àå SQL 1. SHOW { TABLE [ tablename | viewname ] | INDEX [ tablename ] | TRIGGER [ tablename ] | STATUS | DATABASE | USER } 1. DESC { tablename | viewname } 1. CREATE DATABASE { dbname } 1. DROP DATABASE { dbname } 1. CREATE USER id password [ SUPERUSER ] 1. DROP USER id 1. ALTER USER id SET { PASSWORD newpassword | [ NO ]SUPERUSER } 1. GRANT { ALL | SELECT | INSERT | UPDATE | DELETE | ALTER | TRIGGER | SHOW } ON { dbname.tablename | dbname.* | *.* | * } TO { username | PUBLIC } 1. GRANT CREATE { ALL | TABLE | VIEW | INDEX | TRIGGER } ON { dbname | * } TO { username | PUBLIC } 1. REVOKE { ALL | SELECT | INSERT | UPDATE | DELETE | ALTER | TRIGGER | SHOW } ON { dbname.tablename | dbname.* | *.* | * } TO { username | PUBLIC } 1. REVOKE CREATE { ALL | TABLE | VIEW | INDEX | TRIGGER } ON { dbname | * } TO { username | PUBLIC } * DB, Å×ÀÌºí ´ÜÀ§ »ç¿ëÀÚ Á¢±Ù Á¦¾î * libsqlited(C/C++ Ŭ¶óÀ̾ðÆ® API) * Ŭ¶óÀ̾ðÆ® Åø Æ÷ÇÔ [http://sqlitedbms.sourceforge.net/ko/feature.htm ½ºÅ©¸°¼¦] * ¸®Çø®ÄÉÀ̼Ç, ¹Ì·¯¸µ Áö¿ø ¿¹Á¤ * ´Ù¾çÇÑ Ç÷§Æû Áö¿ø 1. ¸®´ª½º 1. MacOS X * ȨÆäÀÌÁö * http://www.sqlitedbms.org/ * http://sqlitedbms.sourceforge.net/ * http://sourceforge.net/projects/sqlitedbms * http://kldp.net/projects/sqlite/ 1. nhttpd (ÁÁÀº À¥¼­¹öµéÀÌ ³Ê¹« ¸¹¾Æ ½¬´Â Áß..) * BSD ¶óÀ̼¾½º * ȨÆäÀÌÁö * http://kldp.net/projects/nhttpd/