Okay, I think I figured out one piece that I was forgetting Check
me on this:
SQLite locks the DB during the Open only so long as it takes to read
through the DB file. I seem to recall running across that fact
somewhere in the FAQs or on this user list
I know the general SQL theory on
Vania,
Vania Smrkovski <[EMAIL PROTECTED]>
15/01/2004 12:14 PM
Please respond to vania
To: "SQLite-Users (E-mail)" <[EMAIL PROTECTED]>
cc:
Subject:[sqlite] Clarification on file locking in web-served apps
> Why the heck would anyone even need
[EMAIL PROTECTED] wrote:
...on Mac OS 10.3?
What error you get?
None. That's what's strange about it. It won't even launch. It starts in
the dock but dies one second (literally) later.
I can run it on MacOSX 10.3.2. However the version of Qt used to compile
the binaries does not support
Hello,
Been reading through the Wiki and FAQ documentation on the SQLite site, and I have
one point of confusion
In an earlier email, I was given some great numbers indicating that, although SQLite
locks an entire DB file, the speeds were pretty impressive (given my read of the
numbers
Has anyone implemented compression for sqlite? If so
can you give me some tips on where/how?
At this point I am guessing it would need to be done at the
page level - but other than that - I am sort of lost.
-David
-
To
At 12:27 PM -0700 1/14/04, Wade Preston Shearer wrote:
>Yes... in OS X, everything that happens is written on in an app called Console. I
>write the author a while back too and he asked that I attempt to launch it again with
>Console running and then send him whatever errors/messages appear,
After the 2.8.10 release ...
"This version fixes a critical locking bug in Unix. It turns out
that any call to close() clears all locks on file that was closed
(who knew?) which then left the database vulnerable to corruption
from other processes. That bug has been cleared by embargoing
all
Hi,
I've done one in VB.NET and it's here
http://sourceforge.net/projects/dotnetsqliteadm/
Regards
Greg
-Original Message-
From: Wade Preston Shearer [mailto:[EMAIL PROTECTED]
Sent: Thursday, 15 January 2004 6:01 AM
To: [EMAIL PROTECTED]
Subject: [sqlite] web-based admin utilities
Jon, you're awesome. Thank you!
Wade, although your question isn't phrased like this, it seems to be
"Where
can I find good documentation on using SQL?" Whether you use the
command-line, or are connecting to SQLite through PHP is irrelevant.
The
syntax for adding, deleting, modifying and
> Yes... in OS X, everything that happens is written on in an
> app called Console. I write the author a while back too and he
> asked that I attempt to launch it again with Console running
> and then send him whatever errors/messages appear, but...
> strangely... I am still getting nothing in the
See: http://sqlzoo.net/
A Gentle Introduction to SQL
e
Wednesday, January 14, 2004, 2:22:23 PM, you wrote:
> Been all through the wiki and didn't find any
> first-time-get-you-started-basic-how-to. Thanks though.
-
To
Are there any manuals or further documentation for SQLite than
what is found on sqlite.org?
I assume that most the database interaction stuff is pretty
straight forward for individuals with database administration
experience, but SQLite is my first database. Most of the
documentation is for
> None. That's what's strange about it. It won't even launch. It
> starts in the dock but dies one second (literally) later.
I am not really familar with Macstuff.
In Qt there is something like qDebug. QDebug sends Debugmessages
to stderr. Perhaps you start sqlitebrowser from the commandline
Has anyone successfully run SQLite Browser...
http://sqlitebrowser.sourceforge.net
...on Mac OS 10.3?
What error you get?
None. That's what's strange about it. It won't even launch. It starts
in the dock but dies one second (literally) later.
> Are there any manuals or further documentation for SQLite than
> what is found on sqlite.org?
>
> I assume that most the database interaction stuff is pretty
> straight forward for individuals with database administration
> experience, but SQLite is my first database. Most of the
>
If you haven't already, go to the bottom of the main
page at sqlite.org and click on the link to the wiki;
then click on contents.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
> Has anyone successfully run SQLite Browser...
>
> http://sqlitebrowser.sourceforge.net
>
>
> ...on Mac OS 10.3?
Hi,
not but you could ask there:
www.qtforum.org.
SqliteBrowser is written with the Qt toolkit. So the people there
will help you.
There are also a few guys from the
correct example:
##
F::FSqlite sql;
sql.sqliteConnect( "testdb" );
sql.sqliteQuery( "SELECT * FROM table" );
while( mySqlObject.dataSetIsLeft( ) ) {
cout << sql.result[ "col_1" ]
cout << sql.result[ "col_2" ]
}
Is anyone aware of a web-based admin utility for SQLite similar to
phpMyAdmin? I found one...
.http://sqlitemanager.sourceforge.net/
...but it is not in English and doesn't look very impressive.
wade
-
To unsubscribe,
Has anyone successfully run SQLite Browser...
http://sqlitebrowser.sourceforge.net
...on Mac OS 10.3?
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Hello,
perhaps you know: At the moment I am developing a CGI framework
with C++. Now I have implemented a sqlite class. You can do
something like this:
##
F::FSqlite sql;
sql.sqliteConnect( "testdb" );
sql.sqliteQuery( "SELECT * FROM table" );
On Wednesday 14 January 2004 09:32 am, Caleb Groom wrote:
> Does sqlite have some way to fetch a random record? I'm looking for
> something similar to MySQL's 'select * from tbl order by rand() limit
> 1'.
Same thing:
SELECT * FROM tbl ORDER BY random() LIMIT 1;
works for me.
Hi all,
I am a quite new user of SQLite; I liked it
since the first day that I tryed some examples,
and after reading the documentation about it;
The reason why I'm asking for help is the following:
I am getting learning C++ step by step, because
that is the language that I will use in the
Michael Hunley wrote:
At 11:12 AM 1/14/2004 -0500, D. Richard Hipp wrote:
SELECT count(*) FROM table WHERE col1>'abc' AND col1<'xyz';
In the original query, the result was indeed a count(*) so no
access to the data we required there. But access to the data
was required in order to evaluate
At 11:12 AM 1/14/2004 -0500, D. Richard Hipp wrote:
SELECT count(*) FROM table WHERE col1>'abc' AND col1<'xyz';
In the original query, the result was indeed a count(*) so no
access to the data we required there. But access to the data
was required in order to evaluate the WHERE clause. So it
Michael Hunley wrote:
At 10:37 AM 1/14/2004 -0500, D. Richard Hipp wrote:
In some cases you can avoid the O(logN) lookup of the
main table entry and just use the index. For example:
SELECT count(*) FROM table WHERE col1>'abc' AND col1<'xyz';
Wasn't that the original question, Ken? Except
At 10:37 AM 1/14/2004 -0500, D. Richard Hipp wrote:
In some cases you can avoid the O(logN) lookup of the
main table entry and just use the index. For example:
SELECT count(*) FROM table WHERE col1>'abc' AND col1<'xyz';
Wasn't that the original question, Ken? Except it was a count(*) on a
Williams, Ken wrote:
So, no way to make it O(N)? If the two indexes could be
Retrieving a single record from a BTree is an O(logN) operation.
Doing so N times gives O(NlogN).
Oh, I thought it was also possible to step straight through an index,
You can step straight through the index in
> -Original Message-
> From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 14, 2004 9:22 AM
> To: Williams, Ken
> Cc: [EMAIL PROTECTED]
> Subject: Re: [sqlite] Optimizing a query
>
>
> Williams, Ken wrote:
> >
> > So, no way to make it O(N)? If the two indexes
Williams, Ken wrote:
CREATE INDEX whatever ON output(verb_id,tag);
That will make it O(NlogN) instead of O(N**2).
So, no way to make it O(N)? If the two indexes could be iterated together,
as in the following pseudocode, it would seem to be an O(N) operation.
Retrieving a single record from a
> -Original Message-
> From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 13, 2004 6:17 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [sqlite] Optimizing a query
>
>
> > Can anyone suggest a good way to optimize the following query?
> >
> > SELECT count(*) FROM
31 matches
Mail list logo