銆�銆�鑷�骞惧崄骞村墠鍑虹��(xi脿n)鐨勫晢妤�(y猫)鎳�(y墨ng)鐢ㄧ▼搴忎互渚�锛屾暩(sh霉)鎿�(j霉)搴�灏辨垚鐐鸿粺浠舵��(y墨ng)鐢ㄧ▼搴忕殑涓昏�佺祫鎴愰儴鍒�銆傛�ｈ垏鏁�(sh霉)鎿�(j霉)搴�绠＄悊绯荤��(t菕ng)闈炲父闂�(gu膩n)閸典竴妯�锛屽畠鍊戜篃璁婂緱闈炲父榫愬ぇ锛屽苟鍗犵敤浜嗙浉鐣�(d膩ng)澶氱殑绯荤当(t菕ng)璩囨簮锛屽�炲姞浜嗙�＄悊鐨勫京(f霉)闆滄�с�傞毃钁楄粺浠舵噳(y墨ng)鐢ㄧ▼搴忛�愭几妯″�婃ā濉婂��锛屼竴绋�鏂板瀷鏁�(sh霉)鎿�(j霉)搴�鏈�(hu矛)姣斿ぇ鍨嬪京(f霉)闆滅殑鍌崇当(t菕ng)鏁�(sh霉)鎿�(j霉)搴�绠＄悊绯荤��(t菕ng)鏇撮仼鎳�(y墨ng)銆傚祵鍏ュ紡鏁�(sh霉)鎿�(j霉)搴�鐩存帴鍦ㄦ��(y墨ng)鐢ㄧ▼搴忛��(j矛n)绋嬩腑閬�(y霉n)琛岋紝鎻愪緵浜嗛浂閰嶇疆锛坺ero-configuration锛夐亱(y霉n)琛屾ā寮�锛屽苟涓旇硣婧愬崰鐢ㄩ潪甯稿皯銆�

銆�銆�SQLite鏄�涓�鍊�(g猫)闁嬫簮鐨勫祵鍏ュ紡闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴�锛屽畠鍦�2000骞寸敱D. Richard Hipp鐧�(f膩)甯�锛屽畠鐨勬笡灏戞噳(y墨ng)鐢ㄧ▼搴忕�＄悊鏁�(sh霉)鎿�(j霉)鐨勯枊閵�锛孲QLite鍙�绉绘�嶆�уソ锛屽緢瀹规槗浣跨敤锛屽緢灏�锛岄珮鏁堣�屼笖鍙�闈�銆�

銆�銆�SQLite宓屽叆鍒颁娇鐢ㄥ畠鐨勬噳(y墨ng)鐢ㄧ▼搴忎腑锛屽畠鍊戝叡鐢ㄧ浉鍚岀殑閫�(j矛n)绋嬬┖闁擄紝鑰屼笉鏄�鍠�鐛�(d煤)鐨勪竴鍊�(g猫)閫�(j矛n)绋�銆傚緸澶栭儴鐪嬶紝瀹冨苟涓嶅儚涓�鍊�(g猫)RDBMS锛屼絾鍦ㄩ��(j矛n)绋嬪収(n猫i)閮�锛屽畠鍗绘槸瀹屾暣鐨�锛岃嚜鍖呭惈鐨勬暩(sh霉)鎿�(j霉)搴�寮曟搸銆�

銆�銆�宓屽叆寮忔暩(sh霉)鎿�(j霉)搴�鐨勪竴澶уソ铏曞氨鏄�鍦ㄤ綘鐨勭▼搴忓��(n猫i)閮ㄤ笉闇�瑕佺恫(w菐ng)绲�(lu貌)閰嶇疆锛屼篃涓嶉渶瑕佺�＄悊銆傚洜?y脿n)姒�铔昏埑鎾曞ご睢�?w霉)鍣ㄥ湪鍚屼竴閫�(j矛n)绋嬬┖闁撻亱(y霉n)琛�銆係QLite 鐨勬暩(sh霉)鎿�(j霉)搴�娆�(qu谩n)闄愬彧渚濊炒浜庢枃浠剁郴绲�(t菕ng)锛屾矑鏈夌敤鎴跺赋鎴剁殑姒傚康銆係QLite 鏈夋暩(sh霉)鎿�(j霉)搴�绱�(j铆)閹栧畾锛屾矑鏈夌恫(w菐ng)绲�(lu貌)鏈嶅嫏(w霉)鍣�銆傚畠闇�瑕佺殑鍏�(n猫i)瀛橈紝鍏跺畠闁嬮姺寰堝皬锛岄仼鍚堢敤浜庡祵鍏ュ紡瑷�(sh猫)鍌�銆備綘闇�瑕佸仛鐨勫儏鍍呮槸鎶婂畠姝ｇ⒑鐨勭法璀�鍒颁綘鐨勭▼搴�銆�

銆�銆�SQLite瀵�(sh铆)鐝�(xi脿n)浜嗗�氭��(sh霉)鐨凷QL-92妯�(bi膩o)婧�(zh菙n)锛屽寘鎷�浜嬪��(w霉)锛屽氨鏄�浠ｈ〃鍘熷瓙鎬с�佷竴鑷存��銆侀殧闆㈡�у拰鎸佷箙鎬х殑锛圓CID锛夛紝瑙哥櫦(f膩)鍣ㄥ拰澶氭暩(sh霉)鐨勫京(f霉)闆滄煡瑭�銆備笉閫�(j矛n)琛岄�炲瀷妾㈡煡銆備綘鍙�浠ユ妸瀛楃�︿覆鎻掑叆鍒版暣鏁�(sh霉)鍒椾腑銆備緥濡�锛屾煇浜涚敤鎴剁櫦(f膩)鐝�(xi脿n)閫欐槸浣挎暩(sh霉)鎿�(j霉)搴�鏇村姞鏈夌敤鐨勫��(chu脿ng)鏂�锛岀壒鍒ユ槸鑸囩劇椤炲瀷鐨勮叧鏈�瑾炶█涓�璧蜂娇鐢ㄧ殑鏅�(sh铆)鍊欍�傚叾浠栫敤鎴惰獚(r猫n)鐐洪�欐槸涓昏�佺殑缂洪��(di菐n)銆�

銆�銆�澶氬��(g猫)閫�(j矛n)绋嬫垨绶氱▼鍙�浠ヨí鍟忓悓涓�鍊�(g猫)鏁�(sh霉)鎿�(j霉)鑰屾矑鏈夊晱椤�銆傚彲浠ュ苟琛岀殑婊胯冻澶氬��(g猫)璁�瑷�鍟�銆傚彧鏈夊湪鍏朵粬瑷�鍟忕��(d膩ng)鍓嶄笉琚�鏈嶅��(w霉)鐨勬檪(sh铆)鍊欐墠鑳芥豢瓒冲��瑷�鍟忥紱鍚﹀墖瀵�瑷�鍟忓け鏁楀苟甯舵湁涓�鍊�(g猫)閷�(cu貌)瑾や唬纰硷紙涔熷彲浠ュ湪鍙�閰嶇疆鐨勮秴鏅�(sh铆)閬庢湡涔嬪悗鑷�鍕�(d貌ng)鐨勯噸瑭︼級銆�

銆�銆�鎻愪緵浜嗗彨鍋歴qlite鐨勪竴鍊�(g猫)鐛�(d煤)绔嬬▼搴忕敤渚嗘煡瑭㈠拰绠＄悊SQLite鏁�(sh霉)鎿�(j霉)搴�鏂囦��銆� 瀹冧篃鍏呯暥(d膩ng)瀵�浣跨敤SQLite搴�鐨勬��(y墨ng)鐢ㄧ殑涓�鍊�(g猫)渚嬪瓙銆�

銆�銆�SQLite閲囩敤浜嗘ā濉婄殑瑷�(sh猫)瑷�(j矛)锛屽畠鐢变笁鍊�(g猫)瀛愮郴绲�(t菕ng)锛屽寘鎷�8鍊�(g猫)鐛�(d煤)绔嬬殑妯″�婃��(g貌u)鎴�銆�

銆�銆�1銆佹帴鍙�(Interface)

銆�銆�鎺ュ彛鐢盨QLite C API绲勬垚锛屼篃灏辨槸瑾�涓嶇�℃槸绋嬪簭銆佽叧鏈�瑾炶█閭勬槸搴�鏂囦��锛屾渶绲傞兘鏄�閫氶亷瀹冭垏SQLite浜や簰鐨�(鎴戝�戦�氬父鐢ㄥ緱杓冨�氱殑ODBC/JDBC涔熸渻(hu矛)杞�(zhu菐n)鍖栫偤鐩告噳(y墨ng)C API鐨勮��(di脿o)鐢�)銆�

銆�銆�2銆佺法璀�鍣�(Compiler)

銆�銆�鍦ㄧ法璀�鍣ㄤ��锛屽垎瑭炲櫒锛圱okenizer锛夊拰鍒嗘瀽鍣�(Parser)灏�(du矛)SQL閫�(j矛n)琛岃獮娉曟�㈡��锛岀劧鍚庢妸瀹冭綁(zhu菐n)鍖栫偤搴曞堡鑳芥洿鏂逛究铏曠悊鐨勫垎灞ょ殑鏁�(sh霉)鎿�(j霉)绲�(ji茅)妲�(g貌u)---瑾炴硶妯�锛岀劧鍚庢妸瑾炴硶妯瑰偝绲︿唬纰肩敓鎴愬櫒(code generator)閫�(j矛n)琛岃檿鐞�銆傝�屼唬纰肩敓鎴愬櫒鏍规摎(j霉)瀹冪敓鎴愪竴绋�閲濆��(du矛)SQLite鐨勫尟绶ㄤ唬纰硷紝鐢辫櫅鎿�姗�(j墨)(Virtual Machine)鍩�(zh铆)琛�銆�

銆�銆�3銆佽櫅鎿�姗�(j墨)(Virtual Machine)

銆�銆�鏋舵��(g貌u)涓�鏈�鏍稿績鐨勯儴鍒嗘槸铏涙摤姗�(j墨)锛屾垨鑰呭彨鍋氳櫅鎿�鏁�(sh霉)鎿�(j霉)搴�寮曟��(Virtual Database Engine,VDBE)銆傚畠鍜孞ava铏涙摤姗�(j墨)鐩镐技锛岃В閲嬪煼(zh铆)琛屽瓧绡�(ji茅)浠ｇ⒓銆俈DBE鐨勫瓧绡�(ji茅)浠ｇ⒓鐢�128鍊�(g猫)鎿嶄綔纰�(opcodes)妲�(g貌u)鎴愶紝瀹冨�戜富瑕侀泦涓�鍦ㄦ��(sh霉)鎿�(j霉)搴�鎿嶄��銆傚畠鐨勬瘡涓�姊濇寚浠ら兘鐢ㄤ締瀹屾垚鐗瑰畾鐨勬暩(sh霉)鎿�(j霉)搴�鎿嶄��(姣斿�傛墦闁嬩竴鍊�(g猫)琛ㄧ殑娓告��(bi膩o))鎴栬�呯偤閫欎簺鎿嶄綔妫х┖闁撶殑婧�(zh菙n)鍌�(姣斿�傚�撳叆?y煤n)顣�?sh霉))銆傜附涔�锛屾墍鏈夌殑閫欎簺鎸囦护閮芥槸鐐轰簡婊胯冻SQL鍛戒护鐨勮�佹��(闂�(gu膩n)浜嶸M锛屽悗闈㈡渻(hu矛)鍋氳┏绱�(x矛)浠嬬垂)銆�

銆�銆�4銆佸悗绔�(Back-End)

銆�銆�鍚庣��鐢盉-妯�(B-tree)锛岄爜绶╁瓨(page cache锛宲ager)鍜屾搷浣滅郴绲�(t菕ng)鎺ュ彛(鍗崇郴绲�(t菕ng)瑾�(di脿o)鐢�)妲�(g貌u)鎴�銆侭-tree鍜宲age cache鍏卞悓灏�(du矛)鏁�(sh霉)鎿�(j霉)閫�(j矛n)琛岀�＄悊銆侭-tree鐨勪富瑕佸姛鑳藉氨鏄�绱㈠��锛屽畠缍�璀�(h霉)钁楀悇鍊�(g猫)闋侀潰涔嬮枔鐨勫京(f霉)闆滅殑闂�(gu膩n)绯伙紝渚夸簬蹇�閫熸壘鍒版墍闇�鏁�(sh霉)鎿�(j霉)銆傝�宲ager鐨勪富瑕佷綔鐢ㄥ氨鏄�閫氶亷OS鎺ュ彛鍦˙-tree鍜孌isk涔嬮枔鍌抽仦闋侀潰銆�

銆�銆�1銆侀浂閰嶇疆(Zero Configuration)

銆�銆�2銆佸彲绉绘��(Portability)锛�

銆�銆�瀹冩槸閬�(y霉n)琛屽湪Windows,Linux,BSD,Mac OS X鍜屼竴浜涘晢鐢║nix绯荤当(t菕ng)锛屾瘮濡係un鐨凷olaris,IBM鐨凙IX锛屽悓妯ｏ紝瀹冧篃鍙�浠ュ伐浣滃湪瑷卞�氬祵鍏ュ紡鎿嶄綔绯荤当(t菕ng)涓�锛屾瘮濡俀NX,VxWorks,Palm OS, Symbin鍜學indows CE銆�

銆�銆�3銆丆ompactness锛�

銆�銆�SQLite鏄�琚�瑷�(sh猫)瑷�(j矛)鎴愯紩閲忕礆(j铆)锛岃嚜鍖呭惈鐨�銆俹ne header file, one library, and you鈥檙e relational, no external database server required

銆�銆�4銆佺啊(ji菐n)鍠�(Simplicity)

銆�銆�5銆侀潏娲�(Flexibility)

銆�銆�6銆佸彲闈�(Reliability)锛�

銆�銆�SQLite鐨勬牳蹇冨ぇ绱勬湁3钀�琛屾��(bi膩o)婧�(zh菙n)C浠ｇ⒓锛岄�欎簺浠ｇ⒓閮芥槸妯″�婂寲鐨�锛屽緢瀹规槗闁辫畝銆�