Hi Ruslan,
I think you've glossed over the technical issues with the SQLite engine
simply to imply that "professionals" don't use sqlite. So to that end
here's a list of projects using sqlite:
<http://www.sqlite.org/cvstrac/wiki?p=SqliteUsers>
and for users who truly are interested in when to use SQLite in their
projects i recommend
<http://www.sqlite.org/whentouse.html>
Is sqlite perfect for everything, *no*. Its strengths are similar to
RunRevs. It is best used for embedded cross-platform applications
where traditional client-server solutions are not available and in
instances where simple administration, low maintenance and zero setup
are a requirement. Real world performance measures are no secret
they're posted on the sqlite website at http://www.sqlite.org as well as
techniques for optimizing sqlite specific issues and general bad schema
design. Its also a phenomenal tool for new users just getting their
feet wet with SQL and interested in strong community support.
Where SQLite truly shines though is in the portability of data and the
vast language support. The altSqlite plugin may only work on PC/Mac/
and Linux, but the actual sqlite database file is completely
independent. It can be created on any of the vast number of platforms
that support sqlite and transferred to a mac or pc and read without a
problem. It supports sundry languages from Ada to REXX and SmallTalk.
Heck, RealBasic liked it so much they made it their default database and
bought a company specializing in it.
To me, this is the definition of a professional enterprise tool;
something I can use in an extremely heterogenous envirnoment to perform
a task or solve a problem without fear that I've locked my customer into
the migrational whims of a single vendor.
all the best
Chris Bohnert
Altuit, Inc.
Ruslan Zasukhin wrote:
On 10/18/05 12:05 PM, "Marielle Lange" <[EMAIL PROTECTED]> wrote:
... At least, that's fine for personal use (that's early code, it
works, but not really seriously tested). For professional projects,
to guarantee perfect cross-platform compatibility, best is to use
Chipp's solution (altSQLlite - http://www.altuit.com/webs/altuit2/
altSQLiteCover/default.htm).
Are other persons on this list interested in this kind of problem/
solution?
Just technical note:
For professional solutions SQl Lite is NOT good. Point.
You can easy see that some queries even on db in 100-200 MB
Can take 30+ seconds...
And you want put such speed on WEB ???
Where you site can access 5-10+ users in the same time?
And what about then db in 1-10-20 Gb ?
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
