Re: [sqlite] Introducing... ManagedSQLite

2007-06-27 Thread Yves Goergen
On 27.06.2007 02:27 CE(S)T, Robert Simpson wrote:
> If you'd rather communicate directly with the database and process
> per-row as quickly as possible, you can use the
> DbCommand/DbDataReader model.

Hm, okay, that's what I referred to that I am using.

> While some may argue whether or not 592k is "lightweight", it's
> definitely not in the heavyweight category either.

Sure, I don't have any special problem with it. 7zip compresses it down
to 250 kB and that's what often goes over the internet. Disk space and
memory bandwidth really aren't a problem in that scale. :)

-- 
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
Visit my web laboratory at http://beta.unclassified.de

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



RE: [sqlite] Introducing... ManagedSQLite

2007-06-26 Thread Robert Simpson
> -Original Message-
> From: Yves Goergen [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, June 26, 2007 4:55 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Introducing... ManagedSQLite
> 
> On 26.06.2007 00:24 CE(S)T, WHITE, DANIEL wrote:
> > The main advantage of mine is that it is lightweight and easy to use
> > without using ADO.NET.
> 
> Okay, the other SQLite.NET DLL has 592 kB, that's not necessarily
> "lightweight". I'd like to be able to include the SQLite library into
> the main assembly so that I won't need a separate DLL anymore. I'm not
> sure though how good that works with each solution or whether it's a
> good idea for other reasons.
> 
> But I'm quite happy with it without using ADO.NET. In fact, I 
> don't like
> the idea of copying each and every record into memory and having it
> sorted and filtered there (which ADO.NET propagates) instead of having
> that done directly in the source database engine...

The nice thing about ADO.NET (other than all the bells and whistles built on
top of it) is that you can decide where you want to process things.  If
you're using a client/server model and want to process on the client-side,
you can use the disconnected model that behaves as you've described.  If
you'd rather communicate directly with the database and process per-row as
quickly as possible, you can use the DbCommand/DbDataReader model.  The
Command/DataReader model conforms very nicely with SQLite's
sqlite3_prepare/sqlite3_step model and is a relatively thin layer on top of
it.

The 592k desktop version of the library is built for performance using PGO
(profile guided optimizations) and includes both FTS1 and FTS2 modules (for
now) as well as the ADO.NET wrapper assembly.  While some may argue whether
or not 592k is "lightweight", it's definitely not in the heavyweight
category either.  On the desktop, 592k is really considered a pittance.

When built to minimize size on the Compact Framework w/o FTS1, the library
is only 476kb.  Considering the alternative databases available for the
Compact Framework, that's roughly 1/3rd the nearest competitor's size.

Robert



-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Introducing... ManagedSQLite

2007-06-26 Thread Yves Goergen
On 26.06.2007 00:24 CE(S)T, WHITE, DANIEL wrote:
> The main advantage of mine is that it is lightweight and easy to use
> without using ADO.NET.

Okay, the other SQLite.NET DLL has 592 kB, that's not necessarily
"lightweight". I'd like to be able to include the SQLite library into
the main assembly so that I won't need a separate DLL anymore. I'm not
sure though how good that works with each solution or whether it's a
good idea for other reasons.

But I'm quite happy with it without using ADO.NET. In fact, I don't like
the idea of copying each and every record into memory and having it
sorted and filtered there (which ADO.NET propagates) instead of having
that done directly in the source database engine...

-- 
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
Visit my web laboratory at http://beta.unclassified.de

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



RE: [sqlite] Introducing... ManagedSQLite

2007-06-25 Thread WHITE, DANIEL
Sam:

The main advantage of mine is that it is lightweight and easy to use
without using ADO.NET.


Daniel A. White 
{ Kent State University: Computer Science major }
{ JMC TechHelp: Taylor Hall, server techie }
{ E-mail: [EMAIL PROTECTED] }
{ Colossians 3:17 }

-Original Message-
From: Samuel R. Neff [mailto:[EMAIL PROTECTED] 
Sent: Monday, June 25, 2007 10:51 AM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Introducing... ManagedSQLite

Daniel,

We already have an excellent ADO.NET compliant provider for SQLite that
Robert mentioned.  What advantages does your wrapper provide of the
existing one?  SQLite.NET already provides full ADO.NET support
including custom functions and collation sequences written in any .NET
languages and built-in encryption.

Thanks,

Sam
 


---
We're Hiring! Seeking a passionate developer to join our team building
products. Position is in the Washington D.C. metro area. If interested
contact [EMAIL PROTECTED]
 
-Original Message-
From: WHITE, DANIEL [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 23, 2007 10:29 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Introducing... ManagedSQLite

Howdy all!

I am just writing tonight to let you know that a project of mine has
opened up to being open source -- ManagedSQLite.  It is a light wrapper
around SQLite 3.4.0 that was originally written by Rob Groves.  I have
added support for Unicode to his wrapper, then added my Managed (.NET)
port to the mix.  One DLL file unlike others out there.  Supports FTS1
and FTS2 out of the box!!!

I am looking for help with this little project.  I think we could
eventually make an entire ADO.NET wrapper with this thing.  Thanks.

http://code.google.com/p/managed-sqlite/

Thanks for reading.

Daniel A. White
{ Kent State University: Computer Science major } { JMC TechHelp: Taylor
Hall, server techie } { E-mail: [EMAIL PROTECTED] } { Colossians 3:17 }




-
To unsubscribe, send email to [EMAIL PROTECTED]

-


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



RE: [sqlite] Introducing... ManagedSQLite

2007-06-25 Thread Samuel R. Neff
Daniel,

We already have an excellent ADO.NET compliant provider for SQLite that
Robert mentioned.  What advantages does your wrapper provide of the existing
one?  SQLite.NET already provides full ADO.NET support including custom
functions and collation sequences written in any .NET languages and built-in
encryption.

Thanks,

Sam
 


---
We're Hiring! Seeking a passionate developer to join our team building
products. Position is in the Washington D.C. metro area. If interested
contact [EMAIL PROTECTED]
 
-Original Message-
From: WHITE, DANIEL [mailto:[EMAIL PROTECTED] 
Sent: Saturday, June 23, 2007 10:29 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Introducing... ManagedSQLite

Howdy all!

I am just writing tonight to let you know that a project of mine has
opened up to being open source -- ManagedSQLite.  It is a light wrapper
around SQLite 3.4.0 that was originally written by Rob Groves.  I have
added support for Unicode to his wrapper, then added my Managed (.NET)
port to the mix.  One DLL file unlike others out there.  Supports FTS1
and FTS2 out of the box!!!

I am looking for help with this little project.  I think we could
eventually make an entire ADO.NET wrapper with this thing.  Thanks.

http://code.google.com/p/managed-sqlite/

Thanks for reading.

Daniel A. White 
{ Kent State University: Computer Science major }
{ JMC TechHelp: Taylor Hall, server techie }
{ E-mail: [EMAIL PROTECTED] }
{ Colossians 3:17 }



-
To unsubscribe, send email to [EMAIL PROTECTED]
-



RE: [sqlite] Introducing... ManagedSQLite

2007-06-24 Thread WHITE, DANIEL
Hi Sam!

1. I don't have any samples.  If you would like to write some that would
be great!  Rob's article at Code Project
<http://www.codeproject.com/database/CppSQLite.asp> Has some of his
samples.  Most of the functions are still the same function-wise as his.
I have cleaned up the naming, added managed exceptions, and added
Unicode support.

2. I don't think so.  This is a small part of a bigger project I am
working on so I don't have the time to focus much on it.  Anysway, its
not feature complete and it has the SQLite code in it -- NATIVELY -- no
changes.

Best of luck!

Daniel A. White 
{ Kent State University: Computer Science major }
{ JMC TechHelp: Taylor Hall, server techie }
{ E-mail: [EMAIL PROTECTED] }
{ Colossians 3:17 }

-Original Message-
From: sqlite [mailto:[EMAIL PROTECTED] 
Sent: Sunday, June 24, 2007 2:33 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Introducing... ManagedSQLite

Hello. 

Thanks for doing this.  I have two questions: 

1.  is there sample code that uses the library in your svn?  [i just
scanned quickly, but there didn't seem to be] 

2.  do you have plans to port the test suite so they can be run against
this library? 

Thanks! 

  - sam - 

WHITE, DANIEL writes: 

> Howdy all! 
> 
> I am just writing tonight to let you know that a project of mine has 
> opened up to being open source -- ManagedSQLite.  It is a light 
> wrapper around SQLite 3.4.0 that was originally written by Rob Groves.

> I have added support for Unicode to his wrapper, then added my Managed

> (.NET) port to the mix.  One DLL file unlike others out there.  
> Supports FTS1 and FTS2 out of the box!!!
> 
> I am looking for help with this little project.  I think we could 
> eventually make an entire ADO.NET wrapper with this thing.  Thanks.
> 
> http://code.google.com/p/managed-sqlite/
> 
> Thanks for reading. 
> 
> Daniel A. White
> { Kent State University: Computer Science major } { JMC TechHelp: 
> Taylor Hall, server techie } { E-mail: [EMAIL PROTECTED] } { 
> Colossians 3:17 }
> 


-
To unsubscribe, send email to [EMAIL PROTECTED]

-


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Introducing... ManagedSQLite

2007-06-23 Thread sqlite
Hello. 

Thanks for doing this.  I have two questions: 

1.  is there sample code that uses the library in your svn?  [i just scanned 
quickly, but there didn't seem to be] 

2.  do you have plans to port the test suite so they can be run against this 
library? 

Thanks! 

 - sam - 

WHITE, DANIEL writes: 

Howdy all! 


I am just writing tonight to let you know that a project of mine has
opened up to being open source -- ManagedSQLite.  It is a light wrapper
around SQLite 3.4.0 that was originally written by Rob Groves.  I have
added support for Unicode to his wrapper, then added my Managed (.NET)
port to the mix.  One DLL file unlike others out there.  Supports FTS1
and FTS2 out of the box!!! 


I am looking for help with this little project.  I think we could
eventually make an entire ADO.NET wrapper with this thing.  Thanks. 

http://code.google.com/p/managed-sqlite/ 

Thanks for reading. 

Daniel A. White 
{ Kent State University: Computer Science major }

{ JMC TechHelp: Taylor Hall, server techie }
{ E-mail: [EMAIL PROTECTED] }
{ Colossians 3:17 } 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-



RE: [sqlite] Introducing... ManagedSQLite

2007-06-23 Thread Robert Simpson
> -Original Message-
> From: WHITE, DANIEL [mailto:[EMAIL PROTECTED] 
> Sent: Saturday, June 23, 2007 7:29 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Introducing... ManagedSQLite
> 
> Howdy all!
> 
> I am just writing tonight to let you know that a project of mine has
> opened up to being open source -- ManagedSQLite.  It is a 
> light wrapper
> around SQLite 3.4.0 that was originally written by Rob Groves.  I have
> added support for Unicode to his wrapper, then added my Managed (.NET)
> port to the mix.  One DLL file unlike others out there.  Supports FTS1
> and FTS2 out of the box!!!
> 
> I am looking for help with this little project.  I think we could
> eventually make an entire ADO.NET wrapper with this thing.  Thanks.
> 
> http://code.google.com/p/managed-sqlite/


Actually I've already gone and written an ADO.NET 2.0 wrapper for SQLite
more than 2 years ago.  It's even a single-file binary :)

http://sqlite.phxsoftware.com

Robert



-
To unsubscribe, send email to [EMAIL PROTECTED]
-