This project is read-only.
DbLite is a port of a very light weight relational database management system from Java to J#. It has a SQL-like syntax and uses serialization to manage tables. It is not meant to compete with real-world relational database management systems, rather provide simple, stand-alone, single user, relational database features that do not have to be installed seperatly and can be used without requiring a separate, complex RDBMS.

DbLite is a J# port of jordb. jordb was written back in 1999 to fill the gap between coding custom persistence mechanisms for stand-alone single user applications and applications reliant on large powerful relational database management systems. It allows a developer to manipulate tables consisting of rows that are serialized vectors of objects. A developer can design the tables in an administrative application, use them in a desktop application and query them in the administrative application or any combination thereof. The system supports the concepts of pre-complied statements, and transactions with rollback.

Advantages:
No Separate RDBMS Install (Distribute With Your Application)
RDBMS Features for Single User Applications
Binary Data File Compatibility Between Applications

Management System Screen Shot
jordb_ms_sm.jpg
jordb_ms.jpg

Features:
SQL-like Syntax
GUI Administration Application
GUI Table Design / Alter
Test Suite
Pre-compiled Statements (see: Setting Parameter Values on a Built (Compiled) Statement)
Transactions

Weaknesses:
The SQL is Very Basic
No Sorting Capabilities
No Grouping Capabilities
No Aggregations
Problematic Syntax Parser
Management GUI Database Browse

Disclaimer:
The use of the term SQL is general. The Structured Query Language supported by DbLite is not ANSI SQL.

Last edited Sep 4, 2006 at 10:27 PM by rhenry74, version 13