Thursday, March 4, 2010

Beat The Ankle House Arrest

SQLite3 database PostgreSQL DB


Continuing with the analysis of data base management I found this unique handle that in their particular highlights being 100% portable. Since Delphi applications only need a small dll to include the database engine in the application. components to access information from Delphi are the arch-known Zeoslib ( http://sourceforge.net/projects/zeoslib/ free components) that it works with firebird, PostgreSQL, DB2, MySQL can also be used by Sqlite . Among its special features (From Wikipedia ):
"The library implements most SQL-92 standard, including transactions atomic database, database consistency, isolation, and durability (ACID), triggers and most of complex queries.

SQLite ( http://www.sqlite.org/ ) uses an unusual type system. Instead of assigning a type to a column as in most systems SQL databases The rates are assigned to individual values. For example, you can insert a string in an integer column (although SQLite will try in the first instance to convert the string into an integer). Some users regard this as an innovation makes the database much more useful, especially when used from a scripting language for dynamic types. Others see it as a major drawback, since the technique is not portable to other SQL databases. SQLite was not trying to transform the data type of the column until version 3.

Several processes or threads can access the same database without problems. Several read accesses can be served in parallel. A write access can only be served if it is not serving any other access concurrently. Otherwise, the write access fails by returning an error code (or can automatically be retried until the configured timeout expires). This concurrent access situation would change when working with temporary tables. However, it could cause a deadlock due to multithread. [1] This point was addressed in version 3.3.4, developed on February 11, 2006.

There is a separate program named sqlite that can be used to view and manage files SQLite database. It also serves as an example for writing applications using the SQLite library. "
Here I leave a job in itself interesting about this database manager's friend Ignacio Andres Soto Martinez, hope you find it useful.

Eng Greetings Victor J. Acosta L.
SQLite3

0 comments:

Post a Comment