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 sqlite-3.6.
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_limits
provides another function named infinity() for getting positive
infinity. I believe this value wi
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
Thanks John. After incorporate a few changes, the code can compile and run.
The result seems reasonable, the input infinity
std::numeric_limits::max() is sent to and retrieved from a sqlite3
database correctly.
--terminal output
sqlite3 tempdb
sqlite> select * from tl;
1.1
1.79769313486232e+308
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 from
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 MES
-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 - http://enig
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
Su
-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 M
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
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
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 t>x1 and thttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
You need #include . 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
[mailto:sqlite-u
//Dear there, it seems that I cannot insert
std::numeric_limits::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
#include
#include
#include
using namespace std;
int main(){
double infinity = std::numeric_limit
-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
defi
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 attac
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
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:
-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 cus
> 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 cu
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, 20
>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 simu
On Mon, Oct 19, 2009 at 12:13 PM, Keith Roberts wrote:
> On Mon, 19 Oct 2009, P Kishor wrote:
>
>> To: General Discussion of SQLite Database
>> From: P Kishor
>> Subject: Re: [sqlite] suggestions for avoiding "database locked" on ajax
>>
>> Let me shed a bit more light on this (as I have underst
On Mon, 19 Oct 2009, P Kishor wrote:
To: General Discussion of SQLite Database
From: P Kishor
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 --
What is happening is that I have an onblu
On 19 Oct 2009, at 5:44pm, P Kishor wrote:
> 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 UP
> What happens in that case? If there is an UPDATE/INSERT request while
> a SELECT is happens to be happening, there is going to be a block, no?
No, there's no block unless you've asked it.
> Putting logic in my code to keep retrying till a query (SELECT or
> UPDATE/INSERT) succeeds is going to b
On Sat, Oct 17, 2009 at 1:25 PM, John Crenshaw 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 than they can now.) Sc
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
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 betw
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 cl
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 see
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 eq
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 prod
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
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
BusyE
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 user&password
> auth for
> the SQLite database file to allow/deny acces?
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
BusyE
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
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
n
> 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
> 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, wrote:
> Sorry for the long reply. Been busy with
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?
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 repo
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 clo
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 clo
-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.
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
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 el
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 searc
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:
50 matches
Mail list logo