Readme

pchemguy · pchemguy · commit 20b00d1e0a84 · 2021-12-08T15:00:10.000+03:00
diff --git a/README.md b/README.md
@@ -1,12 +1,22 @@
-SQLiteDB VBA library is a set of VBA helper functions for the SQLite engine. The primary motivation behind this project is to provide convenient access to extended introspection features. Because of its generality, ADODB/ADOX libraries provide only limited metadata information. Furthermore, this information is only available if the underlying driver implements the relevant functionality. The *Introspection* subpackage of this library, on the other hand, relies on the generic SQL querying mechanism and specialized SQL queries. It facilitates access to complete information about both the features of the active engine used and objects/attributes of the attached database.
+I started this project as the [SQLiteDB VBA][] class, wrapping the ADODB library to facilitate introspection of the SQLite engine and databases. Later, I refactored the SQLiteDB class and several supporting class modules into the SQLiteADO subpackage shown on the left in [Fig. 1](#LibraryStructure). SQLiteADO incorporates a set of class modules with a shared prefix *Lite-*. Shown on the right, the other core subpackage SQLiteC uses SQLite C-API directly (and the *SQLiteC-* prefix).
+
+<a name="LibraryStructure"></a>  
+<div align="center"><img src="https://raw.githubusercontent.com/pchemguy/SQLiteC-for-VBA/develop/Assets/Diagrams/Major%20Componenets.svg" alt="Library structure" /></div>
+<p align="center"><b>Fig. 1. Library structure</b></p>  
+
+While I significantly refactored the code and added some features, the package is still focused on
+
+* database connectivity
+	* SQLiteADO - ADO/SQLiteODBC connection string helpers and limited ADODB wrappers,
+	* SQLiteC - alternative connectivity approach bypassing ADO/SQLiteODBC,
+* validation/integrity, and
+* metadata (SQL-based SQLite introspection).
 
-<a name="FigClassDiagram"></a>  
-<img src="https://raw.githubusercontent.com/pchemguy/SQLiteDB-VBA-Library/develop/Assets/Diagrams/Class Diagram.svg" alt="Class Diagram" width="100%" />  
-<p align="center"><b>Figure 1. Class diagram</b></p>  
 
 See [docs][] for further details.
 
 
 <!-- References -->
 
-[docs]: https://pchemguy.github.io/SQLiteDB-VBA-Library/
+[SQLiteDB VBA]: https://pchemguy.github.io/SQLiteDB-VBA-Library/
+[docs]: https://pchemguy.github.io/SQLiteC-for-VBA/
