SQLite技術筆記_使用VB.NET_跨平台輕量級DB_讀取操作可多工、可動態連結_Serverless_實際操作
SQLite不是一個用戶端/伺服器結構的資料庫引擎，而是被整合在用戶程式中。 也可視為一種Library 當中有可以調用一些常見資料庫操作的方法。 不僅遵守 ACID 性質 單元性 (Atomicity) 一致性 (Consistency) 隔離性 (Isolation) 持續性 (Durability) 作為嵌入式資料庫，是應用程式、網頁瀏覽器於本地/用戶端儲存資料的常見選擇。 SQLite之設計: 主要優勢: 不像常見的 用戶端/伺服器結構資料庫管理系統(多需要跨process做溝通處裡) SQLite引擎並非緊緊為一個應用程式與之通訊的獨立行程。 又被稱為具有Serverless性質，所以更不需要去擔心Server維護等瑣事。 無論是位在開發上還是部署上都是以 一個function(函式)作為基本單位。 Most SQL database engines are implemented as a separate server process. Programs that want to access the database communicate with the server using some kind of interprocess communication (typically TCP/IP) to send requests to the server and to receive back results. SQLite does not work this way. With SQLite, the process that wants to access the database reads and writes directly from the database files on disk. There is no intermediary server process. There are advantages and disadvantages to being serverless. The main advantage is that there is no separate server process to install, setup, conf...