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

2005-03-17 Thread Bertrand Mansion
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

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

2004-12-28 Thread Bertrand Mansion
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] OS X/PHP5/SQLite Build> fatal error: no input grammar

2004-12-17 Thread Bertrand Mansion
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] SQLite Book

2004-11-13 Thread Bertrand Mansion
, 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[2]: [sqlite] PHP 5.0.2 / Win sqlite_query problem

2004-10-23 Thread Bertrand Mansion
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] ISO 8859

2004-06-17 Thread Bertrand Mansion
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: [sqlite] Encodings question

2004-04-19 Thread Bertrand Mansion
<[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

[sqlite] Encodings question

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

Re: [sqlite] Adding SQL commands

2004-04-15 Thread Bertrand Mansion
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

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

2004-02-10 Thread Bertrand Mansion
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] Primary key and index

2004-02-08 Thread Bertrand Mansion
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] Primary key and index

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

[sqlite] Primary key and index

2004-02-08 Thread Bertrand Mansion
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

[sqlite] Temporary indexes

2004-02-06 Thread Bertrand Mansion
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

Re: [sqlite] Full text search implementation

2004-01-16 Thread Bertrand Mansion
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]

Re: [sqlite] UNIQUE vs PRIMARY KEY

2003-12-31 Thread Bertrand Mansion
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] How to find the primary key ?

2003-12-29 Thread Bertrand Mansion
<[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

[sqlite] PRAGMA for index info

2003-10-21 Thread Bertrand Mansion
Hi, I am trying to get info about the indexes present in my database. By using PRAGMA index_list(tablename) I have been able to get a list of indexes. What confuses me is that some index names are like these: (tablename autoindex 1), (tablename autoindex 2), etc. It looks like these indexes are