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
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
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
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
, 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
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
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
vance,
Bertrand Mansion
Mamasam
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
---
<[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,
to MacRoman.
Thanks for any advices,
Bertrand Mansion
Mamasam
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
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
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
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
-
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]
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]
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
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
.
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]
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]
<[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
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]
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
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]
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'))
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
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
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
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
29 matches
Mail list logo