-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dennis Cote wrote:
> It is probably a bug (or a design decision) in the apsw wrapper.
The cursor object in apsw wraps a prepared statement. Since the cursor
gets reused the earlier results are no longer available:
cursor.execute("select * from nu
LMcLain wrote:
> Thanks for the replay Igor!
>
> I would heartily agree about getting a textbook. Do you have one that you
> could recommend?
I like "The definitive Guide to SQLite" by Michael Owens, it is
excellent, except the index which sucks. It is a very good read and
covers a lot of the
Try making your date a REAL and using the Sqlite date and time
functions. You will use extra space for the rowid, the key of the row
and for the b-tree index.
You would expect the indexed rows to be about double the raw text data
since the numbers are 64 bit FP.
Corey Nelson wrote:
> I'm deve
Alex Katebi wrote:
> How can I run the SQLite TCL test scripts?
>
You need a unix like build environment and TCL installed. Then simply
use configure and make
../sqlite/configure
make test
This will build the test fixture program and run the test suite. To run
tests manually you need to start
Steve Friedman wrote:
> libtool: compile: gcc -g -O3 -DSQLITE_ENABLE_RTREE=1 -DTEMP_STORE=2
> -DSQLITE_DEFAULT_CACHE_SIZE=100 -DSQLITE_DEFAULT_PAGE_SIZE=32768
> -DSQLITE_OMIT_ALTERTABLE=1 -DSQLITE_OMIT_ANALYZE=1
> -DSQLITE_OMIT_ATTACH=1 -DSQLITE_OMIT_AUTHORIZATION=1
> -DSQLITE_OMIT_AUTOVAC
Thanks for the replay Igor!
I would heartily agree about getting a textbook. Do you have one that you
could recommend?
Thanks again,
Lee
Igor Tandetnik wrote:
>
> "LMcLain" <[EMAIL PROTECTED]> wrote in
> message news:[EMAIL PROTECTED]
>> Yes, this is quite the noob question: I want to hav
Hello Doug,
Friday, July 18, 2008, 4:23:15 PM, you wrote:
D> Isn't 2008 the same as Vista? In that case, are you sure you have
D> administrative rights? I'm betting user account control is limiting them at
D> the moment. Run cmd.exe as an administrator (right click on a shortcut and
D> choose
Not really two copies as the integer could be primary key ...
something along the lines of
CREATE TABLE StockName (date INTEGER PRIMARY KEY, price REAL);
Regards,
F.
On Fri, Jul 18, 2008 at 10:03 PM, Jay A. Kreibich <[EMAIL PROTECTED]> wrote:
> On Fri, Jul 18, 2008 at 11:58:16AM -0700, Corey Nel
Isn't 2008 the same as Vista? In that case, are you sure you have
administrative rights? I'm betting user account control is limiting them at
the moment. Run cmd.exe as an administrator (right click on a shortcut and
choose Run As Administrator) and then see if it works. If you don't see the
UA
On Fri, Jul 18, 2008 at 11:58:16AM -0700, Corey Nelson scratched on the wall:
> > sqlite3 Ticks.db ".dump"
> BEGIN TRANSACTION;
> CREATE TABLE StockName (date TEXT UNIQUE ON CONFLICT REPLACE, price REAL);
> I would expect the database file to store a bit of "extra" data but it's
> 2.17 times bigge
> Hi Brad
> Thanks for the prompt reply the error I am getting is that the sqlite files
> (see below) could not be copied to the system32 folder? I have tried all
> sorts,
> I do have administrative rights but just have no luck with this...
>
> Sqliteodbc.dll
> Sqliteodbcu.dll
> Sqlite3.odbc.dll
Corey Nelson <[EMAIL PROTECTED]>
wrote:
> It didn't take me long to get some test data into an SQLite3 database
> file. But there's a problem, the database file is almost three times
> bigger than storing the information in text files the way I had
> planned.
Well, you can't get something for noth
I'm developing some software that helps with day trading. I need to store
years worth of tick prices. At first I was going to write a library that
would write and read this information to and from files. Then I thought
"don't be silly", this is the sort of thing databases were made for. I have
litt
Hi Brad
Thanks for the prompt reply the error I am getting is that the sqlite files
(see below) could not be copied to the system32 folder? I have tried all sorts,
I do have administrative rights but just have no luck with this...
Sqliteodbc.dll
Sqliteodbcu.dll
Sqlite3.odbc.dll
Any Ideas
Best R
Ralf Junker wrote:
> Steve Friedman wrote:
>
>> When trying to build sqlite (latest cvs update) with the following:
>>
>> ../sqlite-latest/configure --disable-threadsafe --enable-tempstore=always \
>> --disable-tcl --enable-extensions \
>> CFLAGS="-g -O3 -DSQLITE_ENABLE_RTREE=1 \
>>
Steve Friedman wrote:
>When trying to build sqlite (latest cvs update) with the following:
>
>../sqlite-latest/configure --disable-threadsafe --enable-tempstore=always \
> --disable-tcl --enable-extensions \
> CFLAGS="-g -O3 -DSQLITE_ENABLE_RTREE=1 \
> -DTEMP_STORE=2 -DSQLIT
I am running the rtree module against an SQLite build which has lots of
functionality SQLITE_OMIT_...ed.
Surprisingly, I receive strange errors like SQLITE_NOMEM for simple statements
like
CREATE VIRTUAL TABLE t6 USING rtree(ii, x1, x2);
or
SELECT ii FROM t6 WHERE x1>2;
Question: Does t
Morning List,
As I mentioned yesterday our local build system doesn't support TCL, so
I've been taking the appropriate versions of files (we're on 3.5.1
currently) from the online repository for things like the SQLite3
console. I'd quite like to get as many of the original c tests as
possible run
How can I run the SQLite TCL test scripts?
Thanks,
-Alex
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
When trying to build sqlite (latest cvs update) with the following:
../sqlite-latest/configure --disable-threadsafe --enable-tempstore=always \
--disable-tcl --enable-extensions \
CFLAGS="-g -O3 -DSQLITE_ENABLE_RTREE=1 \
-DTEMP_STORE=2 -DSQLITE_DEFAULT_CACHE_SIZE=100
I tried this and it did not seem to make any difference.
Basically, I open my main database :memory: first and then set "PRAGMA
synchronous = OFF". After I "ATTACH diskfile AS external", I just periodically
do
"BEGIN; DELETE FROM external.tables; INSERT INTO external.tables SELECT * FROM
tabl
В сообщении от Friday 18 July 2008 18:34:01 Fabio Ceconello написал(а):
> Hello,
>
> I just needed to write this little utility to load a regular file to a
> BLOB in a SQLite database, and I thought it may be useful to someone
> else, so I'm posting it here.
I think, you may add this to page
http:
Hello,
I just needed to write this little utility to load a regular file to a
BLOB in a SQLite database, and I thought it may be useful to someone
else, so I'm posting it here.
Best regards,
Fabio Ceconello
Iapyx
/*
Written by Fabio Ceconello ([EMAIL PROTECTED]), 2008-07-18
This is Public Dom
Nikolaus Rath wrote:
>
> So as soon as I make a change in the database, I do not get any more
> results. If I understood you correctly, I should have gotten (4,)
> instead.
>
> Is this a bug?
>
It is probably a bug (or a design decision) in the apsw wrapper. The
following program produces the
Yes, we utilize 64bit versions of SQLite on:
Linux (x86_64)
FreeBSD (x86_64)
Windows (x64 -- XP, Vista -- should also work on 2008)
Solaris (sparc64)
AIX (ppc64)
All work fine.
-Brad
Nic wrote:
> Hi All
>
> Has anyone got Sqlite to run on a 64bit Operating System ? I am having issues
> with se
Hi All
Has anyone got Sqlite to run on a 64bit Operating System ? I am having issues
with server 2008
Regards
Nic
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
"LMcLain" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> Yes, this is quite the noob question: I want to have one fields
> reference another table, how do I do that?
> Here's what I am trying to do. I have a bunch of fields(or columns)
> Item, UPC, Manufacturer, MSRP for example
"Igor Tandetnik" <[EMAIL PROTECTED]> writes:
> "Nikolaus Rath" <[EMAIL PROTECTED]> wrote in
> message news:[EMAIL PROTECTED]
>> What happens if
>>
>> 1. I prepare and execute a select statement
>> 2. I retrieve a couple of rows
>> 3. I execute a new query that would change the result of the
>>q
Hello,
from what I have read about FTS3, it stores the original data as well as the
index needed for fast full-text access. Therefore, in several posts here it
was recommended to use two tables joined one-to-one in case it's needed to
store both text data and some other, possibly numeric data. Let
kriscbe wrote:
> Thanks Mihai for u r response.
>
> with the help of sqlite3_prepare,sqlite3_step,sqlite3_column_int() functions
> i am getting the values in my c++ program.
> i will try u r way also(for the time being not executed it now)after trying
> that i will send my response
>
If you're u
Thanks Mihai for u r response.
with the help of sqlite3_prepare,sqlite3_step,sqlite3_column_int() functions
i am getting the values in my c++ program.
i will try u r way also(for the time being not executed it now)after trying
that i will send my response
thanks
krishcbe
Mihai Limbasan wrote:
31 matches
Mail list logo