Database Server and Client in VB using SQLite

[yogiyang]

Hi,

My friend Olaf Schmidt has sent me a complete Client Server based VB (source code) solution that is really worth studying. You people will really appreciate it and also use it. I have used the older and less stable version in one of my software but at that time I could not release it as he did not permit me to release it. Now that he has permitted me to release to it the community...

Here I go.....

This solution support RichClient fundamentals like those supported by modern frame works like AIR, Goolge Gear, Morfik, Silverlight, etc. but in a very lite and easy way.

This solution contains the following

• dhRichClient - Rich Client for build Rich client apps without extra overheads
• dhSQLite - an ADO-Replacement based on the great sqlite-engine (www.sqlite.org)
• dhSimpleXML - an unicode-aware XML-Parser with DOM and SAX-Support
• dhSortedDictionary - superfast alternative to VB-Collection and Scripting.Dictionary
• dhReport - an enhanced-metafile-based WYSIWYG-Reporting-engine
• dhSocket - TCP-Server and -Client-Classes (an alternative to the winsock.ocx)
• dhCrypt - encryption-, hashing- and compression-stuff
• dhControlLoader - registryless instancing for OCXes (COM-Dlls can be handled with DirectCOM.dll)
• dhEventCollection - Eventsupport for COM-LateBound-Objects in a centralized sink
• dhOpenOfficeEmbed - embed OpenOffice-Documents into your VB-Forms
• dhFormula - a Formula-Evaluator, which support Variables, Arrays and Objects in the Eval-Term
• dhRPC - the Client- *and* Serverpart (including the ThreadPool) for a fast DCOM-alternative

As the ZIP file is bigger than what is permissible on this forum I have uploaded it to a file server.
Here is the Link for Download
The download is approximately 3 MB.

Some notes:
With builtin dhRPC this Dll can act easily as a true DB-/Application-Server with blazing performance (especially if combined with the SQLite-Classes, but ADO would also work).

Implementing the serverpart in your own VB-Solution can be done with a
single line of code.

All Classes were tested intensively also on Linux/Wine and work without any problem in this environment (this is currently interesting especially with regards to the dhRPC-Serverpart). So you can now develope a multi OS based software

I am making it very clear again that this is not my code I am just posting it for the community to benefit from it as the original author has allowed me to.....

Please don't forget to give your feedbacks and success stories with this.

Regards,

Yogi Yang

[Eliminator2009]

dhReport can not be found.

[yogiyang]

dhReport can not be found.

Olaf has updated dhSQLite. Please check the following link

http://www.thecommon.net/3.html

and download latest version from there.

Newer version has integrated Cairo 2D lib also so now it becomes more easier to build image processing and graphic oriented apps in VB6.

HTH