Re: [sqlite] ANN: SQLite 3.6.16.C#

On Sat, Aug 29, 2009 at 9:51 PM, Yves Goergen wrote: > On 01.08.2009 16:19 CE(S)T, Noah Hart wrote: >> This is not a driver, dll, or wrapper.  This is a port of the underlying >> SQLite software. > > Hm, yes, but isn't the other C# SQLite assembly also the entire DB >

Re: [sqlite] ANN: SQLite 3.6.16.C#

On 01.08.2009 16:19 CE(S)T, Noah Hart wrote: > This is not a driver, dll, or wrapper. This is a port of the underlying > SQLite software. Hm, yes, but isn't the other C# SQLite assembly also the entire DB engine? I mean, there's no client/server driver; if you can access SQLite files, you

Re: [sqlite] ANN: SQLite 3.6.16.C#

I need to apologize once again. Slow deletes explained as bug in SQLite tests and flags of Perst compilation. Now they both head to head on basic ops with 2x on Perst selects (can be due to the ADO reader instantiations) http://www.nabble.com/file/p24795746/TestIndex.cs TestIndex.cs SQLITE

Re: [sqlite] ANN: SQLite 3.6.16.C#

I need to apologize once again. Slow deletes explained as bug in SQLite tests and flags of Perst compilation. Now they both head to head on basic ops with 2x on Perst selects (can be due to the ADO reader instantiations) http://www.nabble.com/file/p24795731/TestIndex.cs TestIndex.cs SQLITE

Re: [sqlite] ANN: SQLite 3.6.16.C#

Sorry, test bug in SQLite select test. http://www.nabble.com/file/p24789308/TestIndex.cs TestIndex.cs index searches: 20: SQLITE 8.1635400 PERST 3.3406065 200: SQLITE 1:10.6331745 PERST 54.9915975 - Best Regards. Max Kosenko. -- View this message in context:

Re: [sqlite] ANN: SQLite 3.6.16.C#

Dan Kennedy-4 wrote: > Earlier I just quoted the conclusions of the McObject report. Maybe I > misunderstood. But now that I have read the benchmark code, I'm curious. > Why is the SQL not being recompiled for each query? Is there some kind of > compiled query cache hiding behind the

Re: [sqlite] ANN: SQLite 3.6.16.C#

Dan Kennedy-4 wrote: > Are you by any chance the author of the report I'm reading? I'm not an author of test or McObject staff/representative at all. But I can give a link to this forum to author (still insisting that this is offtopic here) to answer himself. - Best Regards. Max Kosenko. --

Re: [sqlite] ANN: SQLite 3.6.16.C#

On Aug 3, 2009, at 2:06 PM, Kosenko Max wrote: > > > Dan Kennedy-4 wrote: >> McObject CEO Steve Graves points out that because of limits of the >> API >> they were using, SQLite performs each INSERT and DELETE in the test >> in a >> separate transaction. So the reported times for these tests

Re: [sqlite] ANN: SQLite 3.6.16.C#

Dan Kennedy-4 wrote: > McObject CEO Steve Graves points out that because of limits of the API > they were using, SQLite performs each INSERT and DELETE in the test in a > separate transaction. So the reported times for these tests may be more of > a measure of the speed of the media than SQLite

Re: [sqlite] ANN: SQLite 3.6.16.C#

On Aug 2, 2009, at 6:25 PM, Kosenko Max wrote: > > 9/30054 means 99.97% tests are working. > That's a great achievement anyway. > Performance problems can be profiled and optimized simpler than with > native > version. > > That isn't a nature of managed code to be slow. i.e. Perst DB which is

Re: [sqlite] ANN: SQLite 3.6.16.C#

Hi Noah, A name suggestion: "SharpLightSQL" - SLSQL or just SLS. Sunday, August 2, 2009, 10:57:56 PM, you wrote: NH> Richard sent me a gentle reminder that read in part: NH> NH> Please also note that the SQLite source code is in the public domain,

Re: [sqlite] ANN: SQLite 3.6.16.C#

P Kishor wrote: > On Sun, Aug 2, 2009 at 7:57 AM, Noah Hart wrote: >> Richard sent me a gentle reminder that read in part: >> >> >> Please also note that the SQLite source code is in the public domain, but >> the "SQLite" name is

Re: [sqlite] ANN: SQLite 3.6.16.C#

John Stanton-3 wrote: > > Maybe the author could explain the reason for C# translation. Surely a > better approach if the JIT is required would be to use something like > gcc and change the code generator to the C# metacode. Such a product > may already exist. > > A translated program is

Re: [sqlite] ANN: SQLite 3.6.16.C#

Maybe the author could explain the reason for C# translation. Surely a better approach if the JIT is required would be to use something like gcc and change the code generator to the C# metacode. Such a product may already exist. A translated program is rev locked. Kosenko Max wrote: > Seems

Re: [sqlite] ANN: SQLite 3.6.16.C#

Noah Hart wrote: > The license is the same as SQLite, I'm waiting on google to change the > project to PD since that is not one of the canned choices. Thank you very much. Can't disagree with Miguel that this is "A godsend gift to developers". Keep us informed about name change (in case Dr.

Re: [sqlite] ANN: SQLite 3.6.16.C#

And in the Window's there are ... For example: System.Data.SQLite An open source ADO.NET provider for the SQLite database engine http://sqlite.phxsoftware.com/ http://code.google.com/p/sqlite-ng/ sqlite-ng A fork of SQLite with more community involvement SQLite-ng is a fork of SQLite with the

Re: [sqlite] ANN: SQLite 3.6.16.C#

The license is the same as SQLite, I'm waiting on google to change the project to PD since that is not one of the canned choices. Noah It's a pity news. I hoped Dr. can think about even somehow supporting your project. I don't know why he insists on that (he actually can answer for himself

Re: [sqlite] ANN: SQLite 3.6.16.C#

forums/t/1642.aspx > > - Original Message - From: "Konrad J Hambrick" <kon...@payplus.com> > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Sent: Sunday, August 02, 2009 12:19 PM > Subject: Re: [sqlite] ANN: SQLite 3.6.1

Re: [sqlite] ANN: SQLite 3.6.16.C#

quot; <kon...@payplus.com> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Sunday, August 02, 2009 12:19 PM Subject: Re: [sqlite] ANN: SQLite 3.6.16.C# > > Noah -- > > This is a wonderful accomplishment ! > > However, I have a questio

Re: [sqlite] ANN: SQLite 3.6.16.C#

Noah -- This is a wonderful accomplishment ! However, I have a question ... Doesn't C# support native function calls ? If so, other than scratching an itch, what does a native port to C# do ? Thanks. -- kjh Noah Hart wrote: > Richard sent me a gentle reminder that read in part: > >

Re: [sqlite] ANN: SQLite 3.6.16.C#

Seems like I've missed something... Well, if there would be a team dedicated to supporting managed implementation of SQLite which can be at any time quickly updated to reflect all changes of SQLite native - anyone can always transfer such requests to that team. Same happens i.e. with SQLite.NET

Re: [sqlite] ANN: SQLite 3.6.16.C#

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Kosenko Max > Sent: 02 August 2009 19:40 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] ANN: SQLite 3.6.16.C# > I don't know why he insists on

Re: [sqlite] ANN: SQLite 3.6.16.C#

Sunday, August 02, 2009 11:23 AM Subject: Re: [sqlite] ANN: SQLite 3.6.16.C# >I have at least a screwdriver and monkey wrench to go with my hammer >in my > computer software tool bag. Observing the fastener at hand allows > me to > pick the proper tool. Then if that doesn't work,

Re: [sqlite] ANN: SQLite 3.6.16.C#

It's a pity news. I hoped Dr. can think about even somehow supporting your project. I don't know why he insists on that (he actually can answer for himself here) while there are a lot of SQLite based projects with that name usage. May be that's because of your license? Max. Noah Hart wrote: >

Re: [sqlite] ANN: SQLite 3.6.16.C#

arketed." Fred -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Noah Hart Sent: Sunday, August 02, 2009 7:58 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] ANN: SQLite 3.6.16.C# Richard sent me a gentle remind

Re: [sqlite] ANN: SQLite 3.6.16.C#

[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Kosenko Max Sent: Sunday, August 02, 2009 6:32 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] ANN: SQLite 3.6.16.C# I don't know why you have decided that C# or Java isn't competitive to native compiled code. After JIT there is no VM between

Re: [sqlite] ANN: SQLite 3.6.16.C#

On Sun, Aug 2, 2009 at 7:57 AM, Noah Hart wrote: > > Richard sent me a gentle reminder that read in part: > > > Please also note that the SQLite source code is in the public domain, but > the "SQLite" name is not.  SQLite is a

Re: [sqlite] ANN: SQLite 3.6.16.C#

What about SqlSharp? Tim > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Noah Hart > Sent: 02 August 2009 13:58 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] ANN: SQLite 3.6.16.C# >

Re: [sqlite] ANN: SQLite 3.6.16.C#

Richard sent me a gentle reminder that read in part: Please also note that the SQLite source code is in the public domain, but the "SQLite" name is not. SQLite is a registered trade mark. If I don't defend the trademark, then I could lose it. So, I

Re: [sqlite] ANN: SQLite 3.6.16.C#

9/30054 means 99.97% tests are working. That's a great achievement anyway. Performance problems can be profiled and optimized simpler than with native version. That isn't a nature of managed code to be slow. i.e. Perst DB which is managed from scratch is same speed or faster than SQLite

Re: [sqlite] ANN: SQLite 3.6.16.C#

Original Message - > From: "Fred Williams" <f.willi...@verizon.net> > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Sent: Saturday, August 01, 2009 6:08 AM > Subject: Re: [sqlite] ANN: SQLite 3.6.16.C# >

Re: [sqlite] ANN: SQLite 3.6.16.C#

* Noah Hart: > I am pleased to announce that the C# port is done to the point where others > can look at it. Congratulations! (Is there something similar for Java, not using JNI nor NestedVM? 8-) ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] ANN: SQLite 3.6.16.C#

On 1 Aug 2009, at 11:07pm, Fred Williams wrote: > SQLite was and has always been designed to be extremely cross platform > portable, bare bones in both footprint and implementation. It is, and > should remain so. If someone wants to take the open source and > implement it > in something like

Re: [sqlite] ANN: SQLite 3.6.16.C#

place, so to speak. Fred -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Jim Showalter Sent: Saturday, August 01, 2009 1:06 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] ANN: SQLite 3.6.16.C# Could we

Re: [sqlite] ANN: SQLite 3.6.16.C#

On Sat, Aug 1, 2009 at 1:05 PM, Jim Showalter wrote: > I don't know the background of why this programmer did a port directly > to C# instead of binding C# to the existing C library, but I assume he > had his reasons. He says very clearly on the code website, he did so to

Re: [sqlite] ANN: SQLite 3.6.16.C#

gt; To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Saturday, August 01, 2009 6:08 AM Subject: Re: [sqlite] ANN: SQLite 3.6.16.C# > > Hummm... Guess there is a reason there are no implementations of C# > external > to the Mickeysoft world :-) >

Re: [sqlite] ANN: SQLite 3.6.16.C#

This is not a driver, dll, or wrapper. This is a port of the underlying SQLite software. Noah Yves Goergen wrote: > > On 01.08.2009 02:14 CE(S)T, Noah Hart wrote: >> I am pleased to announce that the C# port is done to the point where >> others >> can look at it. >> >> The project is located

Re: [sqlite] ANN: SQLite 3.6.16.C#

Max, I missed posting the remaining errors Current results ... 9 errors out of 30054 tests Still skipping about 9 additional tests Noah Kosenko Max wrote: > > Wow, that's impressive. > > And very interesting that you've gained 3x-5x performance gain. > Don't make this project educational

Re: [sqlite] ANN: SQLite 3.6.16.C#

..@sqlite.org]on Behalf Of Kosenko Max > Sent: Saturday, August 01, 2009 6:22 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] ANN: SQLite 3.6.16.C# > > > > Seems like I've misunderstood your performance results. And they are > 3-5times > slower than origin

Re: [sqlite] ANN: SQLite 3.6.16.C#

Yes, but still decent speed All Results are in Rows per Second TestSQLite3C# SQLite3 Inserts 300K1300K Selects 1500K 8450K Updates 60K 300K Deletes 250K700K Noah Kosenko Max wrote: > > Seems like I've misunderstood your performance results. And they are > 3-5times

Re: [sqlite] ANN: SQLite 3.6.16.C#

Cory, There was no attempt at optimization in this initial port. SQLite does a lot of char/byte/string manipulation as well as and passing parameters by address in the middle of an array. But I ended up having to do a lot of byte buffer copying. MY guess is that is where most of the time is

Re: [sqlite] ANN: SQLite 3.6.16.C#

On 01.08.2009 02:14 CE(S)T, Noah Hart wrote: > I am pleased to announce that the C# port is done to the point where others > can look at it. > > The project is located at http://code.google.com/p/sqlitecs Excuse me, but what's the difference of this to SQLite ADO.NET at

Re: [sqlite] ANN: SQLite 3.6.16.C#

Fred Williams wrote: > Hummm... Guess there is a reason there are no implementations of C# > external to the Mickeysoft world :-) One of the reason is true multiplatform support with Mono for managed world. Another one is Silverlight DB. - Best Regards. Max Kosenko. -- View this

Re: [sqlite] ANN: SQLite 3.6.16.C#

Only 10 DllImport (files and performance), most can be moved to managed version. goto isn't something slow with C# - so it can't be a bottleneck. But it would be interesting to study this with profiler and see what is the real reason. I believe it shouldn't be that different in performance.

Re: [sqlite] ANN: SQLite 3.6.16.C#

-users-boun...@sqlite.org]on Behalf Of Kosenko Max Sent: Saturday, August 01, 2009 6:22 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] ANN: SQLite 3.6.16.C# Seems like I've misunderstood your performance results. And they are 3-5times slower than original... - Best Regards. Max Kosenko

Re: [sqlite] ANN: SQLite 3.6.16.C#

On Sat, Aug 1, 2009 at 4:21 AM, Kosenko Max wrote: > > Seems like I've misunderstood your performance results. And they are 3-5times > slower than original... > This could be for a number of reasons. For one, it uses p/invoke for a number of things, which can be pretty slow

Re: [sqlite] ANN: SQLite 3.6.16.C#

Seems like I've misunderstood your performance results. And they are 3-5times slower than original... - Best Regards. Max Kosenko. -- View this message in context: http://www.nabble.com/ANN%3A--SQLite-3.6.16.C--tp24764742p24768252.html Sent from the SQLite mailing list archive at

Re: [sqlite] ANN: SQLite 3.6.16.C#

Wow, that's impressive. And very interesting that you've gained 3x-5x performance gain. Don't make this project educational only. I'm sure you'll find additional contributors. Just recently Miguel de Icaza was asking for line by line port of SQLite to C#. Great achievement that all tests are

[sqlite] ANN: SQLite 3.6.16.C#

I am pleased to announce that the C# port is done to the point where others can look at it. The project is located at http://code.google.com/p/sqlitecs Enjoy, Noah Hart -- View this message in context: http://www.nabble.com/ANN%3A--SQLite-3.6.16.C--tp24764742p24764742.html Sent from the