Re: [sqlite] basic question about sqlite

2005-11-02 Thread Edward Wilson
What is the best approach to concurrency in this scenario? --- Clay Dowling <[EMAIL PROTECTED]> wrote: > > Dave Dyer said: > > > > If I designed a sqlite database to be used by a bunch of independent > > applications, for example a bunch of CGI scripts each of which > > opened the database, did

Re: [sqlite] Thanks for making my product possible

2005-11-01 Thread Edward Wilson
Ditto - sqlite is pure beauty - thanks. --- Clay Dowling <[EMAIL PROTECTED]> wrote: > Amid all the wailing and gnashing of teeth I thought that I'd just say > thanks for making a great embeddable database that puts a very minimal > burden on the developer. My product, at least, would never

Re: [sqlite] Re: Number of rows in a query result

2005-11-01 Thread Edward Wilson
--- Puneet Kishor <[EMAIL PROTECTED]> wrote: > > On Oct 31, 2005, at 7:54 PM, Edward Wilson wrote: > > >> I simply count the number of elements in my record set > >> thereby avoiding a double query to the database. > > > > Yes, exactly, I take

Re: [sqlite] Re: Number of rows in a query result

2005-10-31 Thread Edward Wilson
> > On Oct 28, 2005, at 7:20 PM, SRS wrote: > > > Edward Wilson wrote: > > > >> The idea of issuing two selects is, well, a hack, and knowing how > >> many records one has in a > >> result-set is a powerful feature > >> > > > >

Re: [sqlite] Re: Number of rows in a query result

2005-10-28 Thread Edward Wilson
Sqlite-Kernel-Hackers: This is really an important feature to have, I am surprised it's not already there. I too have had the same question but have just never asked. btw, is this by any chance on the feature road-map? The idea of issuing two selects is, well, a hack, and knowing how many

Re: [sqlite] Dotnet C# support

2005-10-28 Thread Edward Wilson
I think you are looking for this http://adodotnetsqlite.sourceforge.net/ I wrote my own driver in C++ (boy, that was a lot of work) then discovered the above. - ed --- Wilfried Mestdagh <[EMAIL PROTECTED]> wrote: > Hi Darren, > > > Is there a version which will work for dotnot? > > If not

Re: [sqlite] SQLite is Awesome

2005-10-12 Thread Edward Wilson
Ditto [almost] Anyone who blesses the world with such a great gift can spell however they want ... Sqlite is a 'weapon of the warriors' -- it completely changes the game. Thanks Mr. Hipp, and congrats on your well deserved award. - e --- Chris Gurtler <[EMAIL PROTECTED]> wrote: > Hi, > >

Re: [sqlite] Richard Hipp Awarded Google-O'Reilly Open Source Award at OSCON 2005

2005-08-05 Thread Edward Wilson
Ditto, I can't imagine how the industry as a whole has done without something like Sqlite for so long. I plan to use Sqlite in almost everything I build going forward--it's so much better than XML files or plan text. Congratulations! and Thanks for sharing such a powerful and useful