Hello Max,
> 1. Are there any real reasons for having dual-licensed commercial
> partial reimplementation of SQLite in Java? Any examples?
We're following licensing policy of another project we're working on
(SVNKit), plus BDB JE was an example for us in that area, ever since
SleepyCat times.
The reason for reimplementation itself is that in another project we
have (SVNKit) we need to work with SQLite databases with maximum
portability (which excludes JNI), relatively good performance (which
excludes NestedVM) and, preferably, with means to control the code.
Another reason is that having this project (SQLJet) opens us ways for
other projects that are not that tightly connected to SQLite and not
just to have sort of SQLite 'replacement'.
> 2. When do you expecting to have SQL API?
Now we face two options for the next major version: first one is to work
on and open BTree-level API (i.e. add custom comparators support, like
in BDB, provide examples, etc) and second one is SQL queries support.
I hope we'll find enough resources to work in both directions, but first
one (low level BTree API) has higher priority at the moment. I expect
next major version to be published early next year.
> 3. Are you targeting for having 100% SQLite unit-tests passes?
Yes, we'd like to be able to run SQLite tests and of course get 100%
coverage, but, as you know, to do that we need first to have SQL support.
> 4. Have you ever thought about collaborating with and contributing to
> http://code.google.com/p/csharp-sqlite/ since it's easier to port
> C#->Java than C->Java?
We wasn't aware of C# version at the moment we've started SQLJet -
otherwise you're right, it could save time. As for contributing - we're
not experts in C#, but in general we're open for collaboration :)
> 5. Any benchmarks comparing to native?
So far SQLJet is slower than JNI-based JDBC, but faster than
NestedVM-based version (more than twice). To run benchmarks one should
do the following:
$ svn export http://svn.sqljet.com/repos/sqljet/trunk sqljet
$ cd sqljet
$ ant benchmarks
On my Linux box output is:
[junit] Testsuite: org.tmatesoft.sqljet.benchmarks.SqlJetBenchmark
[junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 18.621 sec
[junit]
[junit] Testcase: clear took 1.505 sec
[junit] Testcase: nothing took 0.009 sec
[junit] Testcase: selectAll took 1.573 sec
[junit] Testcase: updateAll took 3.938 sec
[junit] Testcase: deleteAll took 0.846 sec
[junit] Testcase: insertRandoms took 4.278 sec
[junit] Testcase: locate took 6.322 sec
[junit] Testsuite: org.tmatesoft.sqljet.benchmarks.NestedVmBenchmark
[junit] Tests run: 7, Failures: 0, Errors: 0, Time elapsed: 44.009 sec
[junit]
[junit] Testcase: clear took 2.991 sec
[junit] Testcase: nothing took 0.011 sec
[junit] Testcase: selectAll took 6.362 sec
[junit] Testcase: updateAll took 7.96 sec
[junit] Testcase: deleteAll took 1.492 sec
[junit] Testcase: insertRandoms took 9.183 sec
[junit] Testcase: locate took 15.908 sec
This comparison is not of course absolutely 'fair', as for NEstedVM we
use SQL queries, while SQLJet is measured using API. Also, while SQLJet
outperform NestedVM it is still slower than native and performance
optimization is another task for the next major version of SQLJet.
Alexander Kitaev,
TMate Software,
http://svnkit.com/ - Java [Sub]Versioning Library!
http://sqljet.com/ - Java SQLite Library!
Kosenko Max wrote:
>
> Alexander Kitaev-3 wrote:
>> We're glad to announce that SQLJet 1.0.0 has been released and available
>> for download at http://sqljet.com/ web site.
>>
>
> Hi.
>
> Several questions:
> 1. Are there any real reasons for having dual-licensed commercial partial
> reimplementation of SQLite in Java? Any examples?
> 2. When do you expecting to have SQL API?
> 3. Are you targeting for having 100% SQLite unit-tests passes?
> 4. Have you ever thought about collaborating with and contributing to
> http://code.google.com/p/csharp-sqlite/ since it's easier to port C#->Java
> than C->Java?
> 5. Any benchmarks comparing to native?
>
> Thanks.
>
> Max.
>
> -
> Best Regards.
> Max Kosenko.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
