On Tue, Nov 9, 2010 at 9:14 PM, Charles Pritchard wrote:
> Postgres is more stable than Sqlite for "enterprise-level" activity,
> hardened/enterprise
> browser distributions would choose Postgres over Sqlite for Web SQL
> implementations.
I find that very unlikely. Web SQL is to be an upgrade from cookies as
the client storage mechanism, it is not meant to be store a few TB in
GIS data. Implementors will choose based on much more practical
concerns such as portability (SQLite is not just available for Android
and iOS, it is included), filesystem layout (put the databases in one
folder for each domain just like Flash lays out its offline storage),
embeddability (5 processes just to start a DB), recovery speed (when a
mobile browser gets pushed from RAM and later fear back in, it has to
replay a 16 MB WAL file) and even just convenience (how many browsers
already use SQLite for bookmark storage?) will weight far heavier then
some perceived enterprise readiness,
Jochem
--
Jochem van Dieten
http://jochem.vandieten.net/