I did provide a sample with test data in my original post. However, I posted it
here too:
http://www.sqlite.org/cvstrac/tktview?tn=4043
The tracker is obviously closed, but still, there it is :P. Don't know where
else to post it.
/Chris
Date: Sun, 18 Oct 2009 16:25:48 -0700
From:
Before the timeline was migrated to fossil, I was able to search for
tickets.
In the current sqlite.org website, I can no longer search for tickets
- I can only show all tickets, all closed tickets or all open tickets,
but I can't search for keywords any more...
Is there still a way to
On Oct 19, 2009, at 2:05 PM, Kristoffer Danielsson wrote:
I did provide a sample with test data in my original post. However,
I posted it here too:
http://www.sqlite.org/cvstrac/tktview?tn=4043
The tracker is obviously closed, but still, there it is :P. Don't
know where else to
On Oct 19, 2009, at 2:36 PM, Jens Miltner wrote:
Before the timeline was migrated to fossil, I was able to search for
tickets.
In the current sqlite.org website, I can no longer search for tickets
- I can only show all tickets, all closed tickets or all open tickets,
but I can't search for
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jens Miltner wrote:
In the current sqlite.org website, I can no longer search for tickets
- I can only show all tickets, all closed tickets or all open tickets,
but I can't search for keywords any more...
Yes I whined to DRH about that too.
Am 19.10.2009 um 09:47 schrieb Dan Kennedy:
On Oct 19, 2009, at 2:36 PM, Jens Miltner wrote:
Before the timeline was migrated to fossil, I was able to search for
tickets.
In the current sqlite.org website, I can no longer search for tickets
- I can only show all tickets, all closed
Am 19.10.2009 um 09:47 schrieb Dan Kennedy:
On Oct 19, 2009, at 2:36 PM, Jens Miltner wrote:
Before the timeline was migrated to fossil, I was able to search for
tickets.
In the current sqlite.org website, I can no longer search for tickets
- I can only show all tickets, all closed
Jens Miltner wrote:
it's still a bit annoying, since I
can't search for existing reports efficiently
You are preaching to the choir :-) You can create a bug report about
this at http://www.fossil-scm.org (Fossil is being used by SQLite).
You can also run fossil yourself and clone the
Hi,
Great to hear. I was starting to think my code was damaged. Anyway, please
beware of cases such as this:
SELECT * FROM X NATURAL JOIN (X NATURAL JOIN Y);
This yields the same error. Probably the same bug, but you never know.
When can we expect a bug fix? Days, weeks, months?
Any idea to trace this bug? Anything would be appreciated because I don't
have a clue whatsoever. Thanks.
To have any idea on our side we should see your code and better a
stacktrace of the crash too.
Pavel
On Sun, Oct 18, 2009 at 11:34 PM, ben...@cs.its.ac.id wrote:
Sorry for the long
Currently this means adding
the new columns to my C-structures, writing access functions, and
recompiling. I don't want to do that, because this means my appl *must*
be replaced on every database change, and I'd like to be able to
run different versions of it in the wild. I was hoping to make
One can use a 3rd party tool such as a Alladdin HASP key. This encrypts the
application, and optionally the database file too. The drivers for the
program won't execute a program if it detects a debugger. This solution is
of course limited to operating systems with the available drivers. Once
Hmm, well the thing is I am building an app that runs on Adobe AIR which has
native support for SQLite.
Involving third-party software would probably involve having to install it
on the computers of various users of the application which would complicate
things a bit too much.
I am looking for an
Hello,
I wonder if an automatic rollback, as described in
//www.sqlite.org/c3ref/busy_handler.html, is more powerful than a rollback
programmed in SQL. Particularly if it is able to rollback pending queries from
other cursors in the same connection. The programmed rollback fails here with
On Oct 19, 2009, at 9:49 AM, Francisc Romano wrote:
Hmm, well the thing is I am building an app that runs on Adobe AIR
which has
native support for SQLite.
I am looking for an internal solution. Like setting a userpassword
auth for
the SQLite database file to allow/deny acces?
I
Hello,
I wonder if an automatic rollback, as described in
//www.sqlite.org/c3ref/busy_handler.html, is more powerful than a rollback
programmed in SQL. Particularly if it is able to rollback pending queries from
other cursors in the same connection. The programmed rollback fails here with
I didn't think it did, I will search for this.
Thank you!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Sun, Oct 18, 2009 at 03:54:11PM -0700, Darren Duncan scratched on the wall:
Jay A. Kreibich wrote:
On Sun, Oct 18, 2009 at 02:17:42PM +0200, Kristoffer Danielsson scratched
on the wall:
Clearly, SQLite executes a cartesian product!
Look at the output. It does not produce a
Hello!
See the test:
$ cat /tmp/test
package require sqlite3
sqlite3 db :memory:
db eval {create table test(a int);insert into test values (1);}
proc test {label sql result} {
global i j
puts -nonewline $label\t
set _result [db eval $sql]
if { $_result
Am 18.10.2009 um 18:55 schrieb Roger Binns:
Wanadoo Hartwig wrote:
Slightly different question but related to FTS3. Does anybody know
why
this fails using FTS3?
It isn't failing. Behind the scenes FTS3 is implemented using 3 other
tables (try .dump to see). You are indeed seeing the
Here's a long-ago thread on this:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg30540.html
Looks like it hasn't been addressed, and I've yet to come up for air on it.
There's a ticket out there which looks like the same thing:
http://www.sqlite.org/cvstrac/tktview?tn=3338
which is
While the idea of uniquely identifying a user is interesting, the assumption
that there is only one user for each IP address is questionable at best -
Consider assigning a 'session id' of some kind instead. In *theory* (and yes,
I've seen it happen in reality) the source address can change
Let me shed a bit more light on this (as I have understood). Top
posting follows --
What is happening is that I have an onblur() action on a field which
sends off a request to check the validity of the entered text. Then,
of course, I have the submit button which also sends off the entire
form to
On Sat, Oct 17, 2009 at 1:25 PM, John Crenshaw johncrens...@priacta.com wrote:
Agreed, HUGE thanks for FTS. Hopefully my original post didn't
come off ungrateful. I was just confused by limitations that
looked like they could have been removed during the initial
design (at least more easily
On Mon, 19 Oct 2009, P Kishor wrote:
To: General Discussion of SQLite Database sqlite-users@sqlite.org
From: P Kishor punk.k...@gmail.com
Subject: Re: [sqlite] suggestions for avoiding database locked on ajax
Let me shed a bit more light on this (as I have understood). Top
posting follows --
On Mon, Oct 19, 2009 at 12:13 PM, Keith Roberts ke...@karsites.net wrote:
On Mon, 19 Oct 2009, P Kishor wrote:
To: General Discussion of SQLite Database sqlite-users@sqlite.org
From: P Kishor punk.k...@gmail.com
Subject: Re: [sqlite] suggestions for avoiding database locked on ajax
Let me
But, if I enter something in the field, and, instead of tabbing out of
it, if I click on the submit button, two events fire simultaneously.
There is the onblur() from the field (this is a SELECT query), and the
submit from the form (this is an UPDATE/INSERT query). The events
reach sqlite
Conclusion: onblur() is an error prone strategy. I am going to look
into changing my approach that doesn't involve onblur().
I will research into busy_timeout() settings that might contribute to
more reliability from the point of view of sqlite.
Thanks you all who helped out.
On Mon, Oct 19,
Doing an fts index which can handle subset scans efficiently is going
to be hard.
I noticed. After some thought, here's what I've come up with:
We'll call nT the number of terms and nD the number of docids in a given
term. nTD is the number of rows in a natural join of terms and docids.
The
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kristoffer Danielsson wrote:
When can we expect a bug fix? Days, weeks, months?
Go to http://www.sqlite.org/src/reportlist and you can see all open tickets.
(Currently there is no report in priority order). SQLite consortium
members and paying
It makes sense.
I'll investigate this bug later. I'm quite sure it's no more than a couple of
months old, since I only got these crazy performance hits just after the summer
(I upgrade regularly, but haven't tested my software thoroughly - until now :P).
Thanks for your info.
Date:
On Mon, Oct 19, 2009 at 09:28:35PM +0200, Kristoffer Danielsson scratched on
the wall:
I'll investigate this bug later. I'm quite sure it's no more than a
couple of months old,
Just tested in 3.4.0 (June 2007) and it does the exact same thing.
-j
--
Jay A. Kreibich J A Y @ K R E
Hello list
I'm posting here as my ticket was recently closed. The race condition described
in http://www.sqlite.org/cvstrac/tktview?tn=3810 is still present in SQLite
3.6.19 (amalgamation version running on Linux) - the source code used to
reproduce this issue has not changed and is still
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dave Toll wrote:
The race condition described in http://www.sqlite.org/cvstrac/tktview?tn=3810
is
still present in SQLite 3.6.19 (amalgamation version running on Linux)
My biggest problem with the ticket is the huge list of omits and other
//Dear there, it seems that I cannot insert
std::numeric_limitsdouble::max(). I am on Mac Osx 10.5
//anybody can take a look at the code? I am new to sqlite3. comments on
coding also welcome.
#include string
#include iostream
#include cassert
#include sqlite3.h
using namespace std;
int main(){
You need #include limits. Other than that, I don't know. I code on
Windows, not Mac, but the code looks right.
WARNING: min() != -infinity. For doubles, min is the smallest number
greater than 0. -infinity == -max()
John
-Original Message-
From: sqlite-users-boun...@sqlite.org
hello,
I have a table T (a,b,c,d,t)
where c is a value
a,b,c some dimensions
and t the time
I need to make a subset with a group by
like
select a,b,c,sum(d)
from T
where tx1 and tx2
group by a,b,c
I created an index on a,b,c
but this table is large and the index creation is time consuming (few
8GB is workable. Make sure you use prepared statements to avoid recompiling you
insert 500 million times. Also with this much data, it would probably be a very
good idea to compile SQLite with a much larger memory cache. Don't expect a
miracle either. 500 million is a very large number, any way
Can someone point me to the information on using Java with SQLite?
Thanks,
J. R.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
J. R. Westmoreland wrote:
Can someone point me to the information on using Java with SQLite?
What was not useful in the Google search results you got?
Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with
I looked on the site and didn't find anything. I didn't try Google. My bad.
J. R.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Roger Binns
Sent: Monday, October 19, 2009 6:43 PM
To: General Discussion of SQLite Database
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
J. R. Westmoreland wrote:
I looked on the site and didn't find anything.
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers :-)
Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla -
Great, Thanks.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Roger Binns
Sent: Monday, October 19, 2009 7:42 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Using SQLite from Java
-BEGIN PGP SIGNED
What information are you looking for?
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of J. R. Westmoreland
Sent: Monday, October 19, 2009 9:59 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] Using SQLite
Thanks John. After incorporate a few changes, the code can compile and run.
The result seems reasonable, the input infinity
std::numeric_limitsdouble::max() is sent to and retrieved from a sqlite3
database correctly.
--terminal output
sqlite3 tempdb
sqlite select * from tl;
1.1
I wanted to find the right .jar files to get access.
I'm working on an application that will read a bunch of csv files, using a
special package that will allow them to be accessed as a database, then
generate a SQLite database to be used elsewhere.
I found a pointer to a driver for Java on Google
Sorry, I think I gave you slightly buggy instructions. I just realized
that max() should be the max true value capable of being stored, which
should be less than the infinity value. std::numeric_limitsdouble
provides another function named infinity() for getting positive
infinity. I believe this
Hi
When I ran make test, some errors were shown.
Is it meaning that SQLite has bugs?
$ uname -a
Linux localhost.localdomain 2.6.27-43vl5 #1 SMP Sat Aug 15 22:17:55 JST
2009 i686 i686 i386 GNU/Linux
$ wget http://www.sqlite.org/sqlite-3.6.19.tar.gz
$ tar zxf sqlite-3.6.19.tar.gz
$ cd
48 matches
Mail list logo