SQLite and multiuser

[Ruslan Zasukhin]

On 31/1/07 11:23 AM, "Joel Guillod" <joel.guillod at net2000.ch> wrote:

Hi Joel,

> Of course the question was not targeted to a DBMS vendor.

Agree, on the other hand who else can give you the most detailed answer?
Developer of photoshop or sound-app? :-)

> And dont be  too presomptive because if you search the web on "SQLite server"
> you  find that there are solutions on the way.

Yes I know of course.

And in REALbasic world exists REAL SQL Server around SqlLite.
I believe it have take at least 30-36 developer/months.
But if you look little deep -- it is e.g. single thread. Nice?
Price $1500 like a big mature cool featured multi-user DBMS...

One developer have spend with it few months but return to Valentina,
Because for his 1Gb db it did queries up to 2 minutes, which Valentina eat
in < 1 second. 

So be sure -- I know what is possible and how it will work for this or that
task. At least because I do communicate each day with many developers who
use now or have used different dbs of the world on different platforms with
different languages.

> Ruslan, I can also return you the question: why did you reinvent the
> bike? I know one answer: Oracle, MySQL, PostgreSQL are ACID compliant
> but dont have direct object link... Depending on the trip I prefer to
> ride a racing bike or a moutain bike! ;-)

Easy. 

Because I do not developer end-user PROJECT which need a db.
Instead my project IS a DBMS. You see difference? :-)
I do love develop database engine, data models, ...
and this is my job last 10+ years.

Somebody love develop weapon, somebody love use it.

But if tomorrow I will must develop some project, and if I will see that
this project cannot use Valentina then I will go to Sybase, MS, ...
Or we will improve Valentina...

So you are right, Joel, own bike for each trip. :-)

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]