Quote Originally Posted by Schmidt View Post
SQLite *does* have some big advantages over the JET-engine (especially when we talk about "interaction with Web-stuff" - which I find myself incorporating into my VB6-apps more and more).
I don't see a need for shipping whole databases between platforms very often but that could be one use. If somebody gives you a SQLite DB you use the SQLite DB. More often though it only gets used as a datastore within a single application for internal use.

But if you need to write code for varying platforms it offers a consistent target: one SQL dialect to learn and one set of quirks to deal with.


However most people coming here who need any of that are already aware of it.

The rest are still struggling to figure out text file I/O. When they do use a database it is often in the most primitive ways imaginable. Quite often they just cram everything into one table. Thus they have no relations, have never heard of normalization, and may not even have any keys except a PK they only include by rote and don't understand how to use.

There is no single tool for every job, but some are easier for a casual beginner to deal with. For them Jet is easy since it is already there and they can find mountains of books, tutorials, and sample programs in VB6 using it. Most of its limitations will never impact them.

The real red herring is SQL Server, which is far more clumsy to deal with and a poor fit for the sorts of data most casual coders have to store.