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

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] Any way of using an implicit BTree ordering in SQLite?

t display too many results, so you have to divide the result sets into pages. In order to prodide links to those pages, you need to constantly know how many pages there are. Big INSERTs in web applications are very rare. Bertrand Mansion Mamasam

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

er. That's 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

, 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

with 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] Database locked

table, it has only 9000 entries... >I would like to know how can I import this csv file to sqlite, either w/ php >or command line. If thru command line is the only way, some explanation on >what should I get to have it working on my debian is welcome. Make sure you do your inserts in a tra

[sqlite] UTF-8 and ISO-8859-1 in the same library

vance, Bertrand Mansion Mamasam

Re: [sqlite] ISO 8859

nces 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 problems can be ???). Bertrand Mansion Mamasam ---

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,

[sqlite] Encodings question

to MacRoman. 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

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

Re: [sqlite] Select statements returned column names

anged. SQLite is being adopted by ever > larger numbers of new users, and this will probably continue into the > foreseeable future. Aggravating all these new users to avoid annoying the > much smaller number of existing users who rely on the current n

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

t is not present 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

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

I am afraid your answer 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

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

RARY. 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 h

Re: [sqlite] Full text search implementation

. The best solution would be IMO to have all this optionally integrated into the database engine. 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

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

<[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] How to find the primary key ?

consideration. Any pointers or sample code would be appreciated. :) Thanks, Bertrand Mansion Mamasam - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] Wiki is down

Hi, It seems that the sqlite wiki is down at the moment. Here is the sqlite db error returned: Can't open database Unable to open the database named "sqlite.db". Reason: unable to open a temporary database file for storing temporary tables Bertrand

[sqlite] Finding the primary key

that have multiple keys used for the primary key : PRIMARY KEY (field_a, field_b). Thanks for your suggestions, Bertrand Mansion Mamasam - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Can't get to work w/ PHP

ed question, you might get more comments on the PECL mailing list. Anyway, here is what you can do: # pear download http://pecl.php.net/get/SQLite-1.0.tgz # pear install SQLite-1.0.tgz Then, in your php scripts, use : if (!extension_loaded('sqlite'))

Re: [sqlite] Sqlite databases file extension

In a desktop environment, an extension is useful for opening files with the proper application and for displaying a specific icon for that files. A recommendation would be nice IMO. -- Bertrand Mansion Mamasam - To unsubscribe

[sqlite] Sqlite databases file extension

Hi, Is there a recommended file extension for sqlite database files ? If not, are there any suggestions or a commonly used extension ? What about .sqlite or .db ? Thanks, Bertrand Mansion Mamasam - To unsubscribe, e-mail

Re: [sqlite] Alter Table?!

P [COLUMN] col_name > tell me. Hi Andrea, I would interested to see what you came up with. Do you have any url where the code is available ? Thanks, Bertrand Mansion Mamasam - To unsubscribe, e-mail: [EMAIL PROTECTED] Fo

[sqlite] PRAGMA for index info

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