On 21/12/14 09:47, big stone wrote:

that I hope may help end-user/students popularity [2]
[2] http://db-engines.com/en/ranking_trend

The methodology used by that site is tilted in favour of big data, and
complex databases. Consequently, even if there are ten million SQLite
databases for every non-SQLite database, SQLite won't rank very high.

SQLite shines something that is created for a one time use, and then can
be deleted, because it is no longer needed. Which is not to say that
SQLite is not a good database engine. But for quick and dirty and work,
SQLite is more suitable than Oracle, MySQL, Microsoft SQL Server, or
PostgreSQL. (Most databases are created for a one time use, where quick
and dirty is the most important criterion. Then, because of their
usefulness, they are re-used, and made even more complex, and relied
upon for more things. Until the original database has become "mission
critical", without anybody noticing it. Fortunately for all, SQLite can
scale to that usage, without undue damage.)

sqlite4 is dead because sqlite3 did progress quicker than expected ?

From reading the blogs, etc, SQLite4 is "experimental" and to be used
only when you don't object to losing everything --- OS, database,
applications, hardware --- on your system, and everything that is
networked to it, and all backups made since the dawn of the computer age.

Those same sources imply that things that work, are useful, and _will
not break_ existing setups, will be migrated to SQLite 3.x.

jonathon




_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to