Changes

Jump to: navigation, search

Relational database comparison

1,363 bytes added, 17:51, 26 March 2009
Advantages: adding transportable trees
*single file
*good support.
 
=== Transportable Trees ===
 
From http://www.sqlite.org/onefile.html:
 
'''Single-file Cross-platform Database'''
 
''A database in SQLite is a single disk file. Furthermore, the file format is cross-platform. A database that is created on one machine can be copied and used on a different machine with a different architecture. SQLite databases are portable across 32-bit and 64-bit machines and between big-endian and little-endian architectures.''
 
''The SQLite database file format is also stable. All releases of of SQLite version 3 can read and write database files created by the very first SQLite 3 release (version 3.0.0) going back to 2004-06-18. This is "backwards compatibility". The developers promise to maintain backwards compatibility of the database file format for all future releases of SQLite 3. "Forwards compatiblity" means that older releases of SQLite can also read and write databases created by newer releases. SQLite is usually, but not completely forwards compatible.''
 
''The stability of the SQLite database file format and the fact that the file format is cross-platform combine to make SQLite database files an excellent choice as an Application File Format.''
 
<pre>
The Single disk file of sqlite db would be a major selling point for sqlite
for genealogy software since users share and compare db's all the time.
--Aarons
</pre>
==Disadvantages==
76
edits

Navigation menu