Review: SQLite is the latest database to get full review status at theOpenSourcery.com
Feature: As preparation for coverage SQLite documentation has been converted for local use.
SQLite is becoming much more accepted in the broad development community - and why not ? The database is only 750KB in total size yet supports a very broad implementation of SQL while running in the blazing fast category. With the release of versions 2.8 and 3.0 SQLite added more performant locking and full Unicode support giving it more Enterprise capabilities. Finally, the price is right. SQLite is free, open source and available for quick download (remember the full database is only 750KB).
The only missing ingredient I could find was a Help file system that runs in a browser locally. So I took the basic online SQLite documentation and with the help of Adobe RoboHelp 6, changed it into a frame-based WebHelp format that can be run locally. In addition I added 4 small enhancements to the documentation: 1)yellow caution notes and green "nice feature highlights were added throughout; 2)the headers links were made context sensitive in the first column - I chose 4-5 relevant see also links for each topic; 3)some spelling and grammar errors were corrected;
4)the SQLite help topics were grouped into SQLite Overview, SQLite SQL Syntax, and SQLite C APIs.
The resulting SQLite documentation can be accessed here on theOpenSourcery.com:

So the SQLite Help files are available in a simple HTML format or a more powerful, frame-based WebHelp format produced using Adobe's RoboHelp 6.
In the near future I will add more screenshots and examples for the SELECT and some of the other SQL commands as part of the ongoing theOpenSourcery reviews of SQLite. Also if there is interest I will make this later version available as a WinZip file for download. Finally, this exercise also allowed a quicker review of Adobe's Robohelp 6 to be done as well.
Top of Page Home Tutorials
Developers Weblog Graphics Reviews and Tips |