> -Original Message-
> From: Mrs. Brisby [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 22, 2005 3:07 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Multi-threading.
>
> > However the need for multi-threads is compelling.
> Especially in a GUI
> > environment. For instance
s going to make
> a difference, but you never know. I just download the dll and
> run lib against it to get the lib and such. Then soft link to
> it that way.
>
> I would not be surprised to find out that it has something to
> do with the gcc build...
>
> ~derek.
>
&
> -Original Message-
> From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 12, 2005 1:20 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] sqlite 3.x and Win Server 2003 SP1 not working
>
> On Tue, 2005-07-12 at 11:01 -0700, Derek Shaw wrote:
> > SQLite 3
> -Original Message-
> From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
> Sent: Sunday, July 10, 2005 6:01 PM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] Binding a column name?
>
> On Sun, 2005-07-10 at 15:34 -0700, Tim McDaniel wrote:
> > >
>
> -Original Message-
> From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
> Sent: Sunday, July 10, 2005 6:12 AM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] Binding a column name?
>
> On Sun, 2005-07-10 at 00:23 -0700, Brown, Dave wrote:
> > That is what I do. But that also means I
Question...
Two database files, say A & B.
Open A.
Attach B.
Write to a table in A.
Write to a table in B.
During the writes, is the file not being written to locked?
Thanks,
Tim
> -Original Message-
> From: Tito Ciuro [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 20, 2005 1:07 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Is 'full_column_names' still broken?
>
> Hello Tiago,
>
> On 20/05/2005, at 7:08, Tiago Dionizio wrote:
>
> > On 5/20/05, Tito
This question is probably better asked on the SQLite.NET sourceforge
forum.
By the way, I don't know the answer.
Tim
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 28, 2005 10:22 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite]
> -Original Message-
> From: Darren Duncan [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 28, 2005 10:29 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] new API for query column sources (was Re:
> ticket 1147)
>
> Here are some alternate API naming suggestions, that I have
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 28, 2005 12:43 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Good Graphical Tool for 3.x
>
> Is there a good enterprise manager like tool for SQLite 3.0?
> I'm a windows guy and
> I'll third Dr. Hipp's statement.
>
> I have my own wrappers (in Perl), made for public
> consumption, and never had problems with returned column names.
>
> Simply put, the elegant solution for wrapper authors is to
> always use 'as' to explicitly define the column names you
> want. You
> -Original Message-
> From: Robert Simpson [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 28, 2005 12:55 PM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] ticket 1147
>
> > -Original Message-
> > From: Andrew Piskorski [mailto:[EMAIL PROTECTED]
> > Sent: Monday,
:
Given a specific SELECT statement, ADO.NET has the capability to
automatically build the corresponding INSERT, UPDATE, and DELETE
statements, so the user can insert/update/delete values/rows in the
resultset and have those modifications sent back to the database. But
in order to facilitate this,
y thoughts on the matter, or any plans to address the
issue.
Regards,
Tim McDaniel
Sorry if this has been answered previously, but I couldn't find the
answer searching the mailing list archive...
What are the implemented syntax for specifying parameters in an SQL
statement for sqlite3_prepare? Apparently the sqlite3.h header file and
the online documentation are out of sync,
Dennis Cote came up with this, which I think will work...
select t.* from t join (select max(a) as a, b from t group by b) as key
where t.a=key.a and t.b=key.b;
Thanks for all the suggestions.
Tim
> The statement proposed by Lawrence (copied below) will work
> if your table has only these two columns, A and B.
>
> SELECT MAX(A) AS A , B
> FROM T
> GROUP BY B
>
> From your question I got the imprssion you may have other
> columns as well.
>
> For a table t like this;
>
> a|b|c
> 1|5|6
>
> > Given a table T like this:
>
> > A B
> > -
> > 1 5
> > 2 5
> > 3 5
> >
> > I need a query to give me just the row with the largest A
> value, within
> > a group defined by B. In this case, it would be the row with A = 3.
>
> SELECT MAX(A) AS A , B
> FROM T
>
like:
SELECT * FROM T
GROUP BY B
ORDER BY A;
It doesn't seem to matter if I use ASC or DESC for the ordering, it
always gives me the row with A = 1.
Any ideas?
Thanks,
Tim McDaniel
citly. That way, if a statement has 10 parameters,
> and you want to execute it 10 times, and only one parameter
> changes between each run, you do not have to reinitialize the
> other 9 every time.
>
You could add an option to the reset function to specify wh
The code example you give does not look like managed code, if by "managed code" you
mean .NET code.
Your example looks like plain Windows C++ code.
> -Original Message-
> From: Kayhan Yuksel [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 19, 2003 10:33 AM
> To: '[EMAIL PROTECTED]'
>
Maybe there needs to be some clarification here. All the sqlite
functions take const char* for string parameters. What I'm not
clear on is the intended effect of the SQLITE_UTF8 macro. Which
string parameters of which functions are intended to be UTF-8 encoded
if the SQLITE_UTF8 macro is
Arthur,
Full source and a small test app are at
http://sourceforge.net/projects/adodotnetsqlite
> -Original Message-
> From: Arthur C. Hsu [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 18, 2003 2:22 AM
> To: Tim McDaniel; [EMAIL PROTECTED]
> Subject: RE: [sqlit
Arthur,
I've just done some performance tests using our ADO.NET provider for
SQLite. On a 2GHz P4 system, we get about 35000 inserts/sec and 175000
reads/sec. This is with a file db using a transaction, or an in-memory
db without transaction, they both perform the same. The performance is
It isn't clear what you are trying to determine.
What provider are you using for ADO.NET (eg Jet, SQL Server, etc)?
Are your inserts for SQLite inside a transaction? This makes a huge
difference.
If you are using ADO.NET, you might look at
http://sourceforge.net/projects/adodotnetsqlite
>
Arthur,
sqlite_bind and sqlite_reset are part of an "experimental" API in the
latest SQLite source code in CVS, but it isn't part of an official
release yet. However, I use them, and they work very well.
Tim
> -Original Message-
> From: Arthur Hsu [mailto:[EMAIL PROTECTED]
> Sent:
tion? Any advice?
Thanks,
Tim McDaniel
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
27 matches
Mail list logo
