Re: [sqlite] Ultimate noob question: What do I do to reference another table?

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

Re: [sqlite] database file size isn't really very small

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

Re: [sqlite] SQLite Test Scripts

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

Re: [sqlite] problem building reduced-size sqlite

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 >

Re: [sqlite] Ultimate noob question: What do I do to reference another table?

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

Re: [sqlite] 64bit Version

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

Re: [sqlite] database file size isn't really very small

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

Re: [sqlite] 64bit Version

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

Re: [sqlite] database file size isn't really very small

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

Re: [sqlite] 64bit Version

> 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 >

Re: [sqlite] database file size isn't really very small

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

[sqlite] database file size isn't really very small

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

Re: [sqlite] 64bit Version

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

Re: [sqlite] problem building reduced-size sqlite

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 \ >>

Re: [sqlite] problem building reduced-size sqlite

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

[sqlite] rtree woes with SQLITE_OMMIT_...

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

[sqlite] Taking precompiled test source files from the online repository

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

[sqlite] SQLite Test Scripts

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

[sqlite] problem building reduced-size sqlite

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

Re: [sqlite] Periodical dump of in-memory database into a disk file

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

Re: [sqlite] A program to load a file to a BLOB field

В сообщении от 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

[sqlite] A program to load a file to a BLOB field

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

Re: [sqlite] Does changing the db change result sets?

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

Re: [sqlite] 64bit Version

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

[sqlite] 64bit Version

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

Re: [sqlite] Ultimate noob question: What do I do to reference another table?

"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

Re: [sqlite] Does changing the db change result sets?

"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 >>

[sqlite] FTS index size

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.

Re: [sqlite] how can i get values from sqlite db?

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

Re: [sqlite] how can i get values from sqlite db?

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:

Re: [sqlite] Ultimate noob question: What do I do to reference another table?

you need several tables, then you can refernce them thru a view to show what is related to what. --- On Fri, 7/18/08, LMcLain <[EMAIL PROTECTED]> wrote: From: LMcLain <[EMAIL PROTECTED]> Subject: [sqlite] Ultimate noob question: What do I do to reference another table? To:

Re: [sqlite] Download 3.5.9 version - how to build the library

Joanne Pham wrote: > Hi All, > Hi there. > Currently we are using 3.5.2 version and I would like to use SQLite 3.5.9 for > our product. Would you please direct me where to find out the release note > for 3.5.9 http://www.sqlite.org/changes.html