Re: [sqlite] How to find the primary key ?

<[EMAIL PROTECTED]> wrote : > Bertrand Mansion wrote: >> Hi, >> >> I have been through the archives on yahoo groups and found a mail that said >> the current way to find the primary key in sqlite is to write your own sql >> parser. This was back in May

Re: [sqlite] UNIQUE vs PRIMARY KEY

primary key consists of columns b and a, > in that order. Richard, Is the order important for sqlite ? What if (a, b) is used instead of (b, a) ? Thanks, Bertrand Mansion Mamasam - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Full text search implementation

ne. That's what Oracle does with Context and last time I have used it, it was working very well (it was with Oracle 9i). But that might also make the engine too heavy. Mysql offers fulltext but it is only available AFAIK on the MyISAM table format. So you can't have foreign key constraints (available on InnoDB format) and full text at the same time. Bertrand Mansion Mamasam - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] Temporary indexes

TEMPORARY. The error I get is : 'near "INDEX": syntax error' The query works fine when I remove TEMP. Is this feature disabled ? Do I have to enable it at compile time ? I am using 2.8.11 on Mac OS X. Thanks for your help, Bert

[sqlite] Primary key and index

generally, does declaring any column primary key implies that this column will be indexed ? I am not sure about that because when I do a PRAGMA index_list(), there is no index shown for the primary key. Thanks for any hints, Bertrand Mansion Mamasam

Re: [sqlite] Primary key and index

wer is totally out of scope. Bertrand Mansion Mamasam - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Primary key and index

l if it could return the exhaustive list of indexes, including the ones created as INTEGER PRIMARY KEY. Bertrand Mansion Mamasam - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Re: [inbox] Re: [sqlite] Primary key and index

resent in PRAGMA index_list(). I can live with that and I guess changing index_list() would be a BC break. But I would be interested to know if there are other more intuitive ways, other than parsing the CREATE TABLE sql query. Bertrand Mansion Mamasam ---

Re: [sqlite] Adding SQL commands

LITE_UTF8, I can't use LIKE et.al. in the > way I want to. It's good to hear that this will be improved in SQLite > 3.0. How will this be improved in sqlite 3.0 ? Bertrand Mansion Mamasam - To unsubscribe, e-mail: [EMAIL P

[sqlite] Encodings question

n. Thanks for any advices, Bertrand Mansion Mamasam - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Encodings question

<[EMAIL PROTECTED]> wrote : > Bertrand Mansion wrote: > >> As far as I understand, UTF-8 will read 8859-1 without problem but >> ISO-8859-1 will not be able to read UTF-8, unless everything in the UTF8 >> string uses only 8859-1 codes. > > You're wrong, I th

Re: [sqlite] ISO 8859

for example). The safe way might be to use UTF-8. But this might make the databases bigger ? And there are apparently problems using the UTF-8 version of sqlite with PHP (although I still don't understand what the prob

Re[2]: [sqlite] PHP 5.0.2 / Win sqlite_query problem

PHP sqlite code, the problem must be in your code or your environment. Are you sure the database is open ? Are you sure it is writable ? Can your webserver user/group write to the directory of your database ? Bertrand Mansion Mamasam

Re: [sqlite] SQLite Book

, practical guide to >using, administering and programming this up-and-coming database. If >you want to learn about SQLite or about its use in conjunction with >PHP this is the book for you. I prefer to wait for DR Hipp's book... :) Bertrand Mansion Mamasam

Re: [sqlite] OS X/PHP5/SQLite Build> fatal error: no input grammar

my development plateform. I never used Fink, nor needed it so your experience may differ. You might also need to install iconv which is straightforward. Good luck, Bertrand Mansion Mamasam

Re: [sqlite] Any way of using an implicit BTree ordering in SQLite?

Andrew Piskorski wrote: >On Sun, Dec 19, 2004 at 12:09:08PM +0100, Bertrand Mansion wrote: > >> For web applications (sqlite being now the default database for PHP5), >> COUNT(*) >> performance is more important than INSERTs and DELETEs performance. The >> obvious

RE: [sqlite] Proposal: limit the number of columns in a table to 2000.

n my Record1 column of the first row, >and so on down the line. That way I could stored all 500,000 of my records >in a 1 row table, What do you guys think? Please wait April 1st for such jokes... Bertrand Mansion Mamasam