Monday, May 26, 2008

Does Size Matter.....
When it comes to RDBMS it wont any more.....


SQLite is a ACID-compilant Relational Database Management System. The whole package comes up to only 500Kb approximately.  SQLite was created by D. Richard Hipp and the source code of which is in public domain.


The main feature of SQLite is its not a separate process instead SQLite Library is Linked in and hence integrates with the part of the application. It follows 3 out of 4 rules of database transactions that are Atomic, Isolated and Durable. As it has no foreign key attribute hence it doesn't satisfy the consistency requirement. SQLite also supports and triggers the complex queries. Its also a dynamically typed i.e. types are assigned to individual values instead of individual columns. Also several threads and processes can simultaneously access the database. 


SQLite can be used with a large number of programming languages including BASIC, C, C++, Common Lisp, Java, C#, Delphi, Lua, Tcl, R, PHP, Perl, Ruby, Objective-C (on Mac OS X), Python, newLispSmalltalk, using connection engines.


Source: http://www.sqlite.org/,http://en.wikipedia.org/wiki/SQLite

A book for the Not so Dumb..........

If you think you know the basics of programming, and have ample time to learn a new Programming Language then checkout this book.........


Author(s):Francesco Balena (Wintellect) 


With at-least of 1600 pages covers the whole of Visual Basic .net. A good reference book if you are a student or any professional who needs to get the new generation of Microsoft Certification. It takes a Bottom-Up approach, initially dealing with the .Net framework itself, covering the various aspects of a programming language like Variables, Loops, Condition statements, Modules, Control flow and so on.

In the second part Object Oriented Programming (OOP's) concepts are explained in a detailed and in a concise manner, and covers Overloading, Overriding, Events, Constructors and Destructors and similar OOP's concepts . The third part again deals with the .Net framework in a detailed manner covering topics such as Boxing and Un-Boxing, Serialization, Threading and similar topics. Basics of using and developing applications using Windows Form is covered up in the fourth part.

The fifth part is dedicated to Databases i.e. ADO.net and deals with using databases with VB.net in Connected and Disconnected mode and also XML related topics.  And the last part deals with ASP.net programming using VB.net.

Overall this book is a must read for any one who wants to learn VB.net programming from the ground-up to the expert level.

Image Courtesy: Microsoft