Re: [sqlite] Loading a Nested Set?

Sqlite Fool wrote: > In a previous life, I was able to get the stuff into a MS SQL Server > adjancency model table using TSQL constructs like WHILE and FOR to iterate > over parts of strings, use temp-holder variables, and then perform inserts. > From what I understand about SQLite, only CASE is

[sqlite] Loading a Nested Set?

Hey all. Very happy to have found this e'list. I have worked with a few other DB (and DB-ish) systems in the past but am only now taking a deep-dive into SQLite. I am attempting to load a delimited text file into a Celko-style nested-set model table. In a previous life, I was able to get the

[sqlite] Testfixture test file may be misnamed

Was it deliberate that the following file was created with a .txt rather than .test extension? test/tkt-d82e3f3721.txt Regards, Noah Hart -- View this message in context: http://old.nabble.com/Testfixture-test-file-may-be-misnamed-tp26752815p26752815.html Sent from the SQLite mailing list

Re: [sqlite] ynVar

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Lauren Foutz wrote: > The code and the comments seem to imply that ynVar should be i16 instead > of i64. Is this a mistake? Yes, it was a bug in 3.6.20 and was fixed for 3.6.21. Note that the effect of the bug was merely to use more storage space

Re: [sqlite] ynVar

The source from 12/7 do show #if SQLITE_MAX_VARIABLE_NUMBER<=32767 typedef i16 ynVar; #else typedef int ynVar; #endif Regards, Noah -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Lauren Foutz Sent: Friday, December 11, 2009

[sqlite] ynVar

In src/sqliteInt.h there is the following code fragment: /* ** The datatype ynVar is a signed integer, either 16-bit or 32-bit. ** Usually it is 16-bits. But if SQLITE_MAX_VARIABLE_NUMBER is greater ** than 32767 we have to make it 32-bit. 16-bit is preferred because ** it uses less memory in

Re: [sqlite] apple-osx branch

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Garry Watkins wrote: > What is the apple-osx branch? Is it usable on the iphone? The iPhone already comes with SQLite as does OSX which you can use directly, or a higher level wrapper (look for CoreData). Apple contributed changes to deal with

[sqlite] apple-osx branch

What is the apple-osx branch? Is it usable on the iphone? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL question

If I understand your question correctly, Florian, you want the most recent Value for each entity represented by the composite primary key {oper, product, category, name}. To find the rows that contain the most recent values (although not yet the values themselves) you first need to aggregate

Re: [sqlite] SQL question

On 11 Dec 2009, at 1:13pm, Florian Schricker wrote: > - CreateTS (Timestamp) No such type in SQLite. Take a look at http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions http://www.sqlite.org/lang_datefunc.html I'd recommend you store your time/date data either as strings (which would be

Re: [sqlite] SQL question

Florian Schricker wrote: > Schema of DB (simplified): > - Oper (string) > - Product (string) > - Category (string) > - Name (string) > - CreateTS (Timestamp) > - Value (Double) > > Primary keys are Oper, Product, Category, Name and CreateTS > > What I could not figure

Re: [sqlite] sqlite, php, and Mac OS X 10.6.1

On Fri, 11 Dec 2009 09:13:33 -0500, Simon Slavin wrote: > Run the PHP INFO routine: > > phpinfo(); > > and search for the word 'sqlite' in it. You should fine it listed in > the PDO section. You should also see the following sections: > 'pdo_sqlite', 'SQLite' and

Re: [sqlite] SQL question

On Fri, 11 Dec 2009, Florian Schricker wrote: > Schema of DB (simplified): > - Oper (string) > - Product (string) > - Category (string) > - Name (string) > - CreateTS (Timestamp) > - Value (Double) Florian, The schema refers to the set of tables, and the attributes within each table. Is the

Re: [sqlite] SQL question

> So for a set of measurements identified by everything but their name > select the latest rows as defined by the timestamp. > > Can I do that in SQL in one query? Maybe this is what you want: select Name, Value, CreateTS from TableName where Oper = 'op' and Category = 'cat' and Product =

Re: [sqlite] Feature request: compile-time foreign keys setting (patch attached)

On Fri, 11 Dec 2009 05:05:49 -0500, wrote: > I hope I'm not duplicating a request already made by someone, but it'd be > great if the foreign keys flag can be set as a compile option (like the > recursive triggers flag). At the least, it is a request that someone has been

[sqlite] SQL question

Hi everyone! I'm a starter on SQL / SQLite and there is some problem I'd solve in software but I have the feeling this can be done using a query. If somebody can help me out I'd be glad - I have the feeling there is something to learn for me here. Here goes: Schema of DB (simplified): - Oper

Re: [sqlite] sqlite, php, and Mac OS X 10.6.1

On 11 Dec 2009, at 1:58pm, reiser.p...@gmail.com wrote: > I have enabled web sharing, so I guess Apache is up and running. I have > un-commented out the line in /etc/apache2/httpd.conf which reads > > LoadModule php5_modulelibexec/apache2/libphp5.so > > I have written a program called

Re: [sqlite] sqlite, php, and Mac OS X 10.6.1

Hello PR try { PR $dbHandle = new PDO('/Users/mymachine/sqlite:'."$user_db"); PR } How about: $dbHandle = new PDO('sqlite:/Users/mymachine/'."$user_db"); The sqlite: should be at the beginning of the DSN (Data Source Name), so that PDO can recognise the name of the driver to use. Swithun.

[sqlite] sqlite, php, and Mac OS X 10.6.1

Trying to write a test web page using php and sqlite. I have a Mac with OS X 10.6.1 (Snow Leopard). Maybe this is a php problem, Im not sure. I have enabled web sharing, so I guess Apache is up and running. I have un-commented out the line in /etc/apache2/httpd.conf which reads LoadModule

[sqlite] Documentation correction

vdbe.c line 3217 /* The input value in P3 might be of any type: integer, real, string, ** blob, or NULL. But it needs to be an integer before we can do ** the seek, so covert it. */ == s/b convert Regards, Noah Hart ___