ye,
at the fifth question of the SQLite FAQ, at
http://www.sqlite.org/faq.html, it is explained why using a sqlite file
by multiple nodes over a network with a NFS filesystem is not a good
idea. I would avoid it although the FAQ does not say 'it does not work',
it only says 'it might not work'
Andrew Gatt wrote:
> I have a table of music artist names which i'd like to output in order.
> Normally i just use:
>
> select * from artists order by artist_name;
>
> What i'd really like to do is order the artists by name but ignore any
> "the" or "the," preceding it.
>
> Any ideas?
>
> Thanks
Cesar David Rodas Maldonado wrote:
> I wanted to ask how can i know if a given text is UTF8 or ISO-8859-1?
Well, there might be a way if you only want to know if the text is UTF-8
or ISO-8859-1 (it means that you already know that is one is the other).
There are some invalid UTF-8 sequences. If yo
Hello people!
First of all:
SQLITE 3.3.6 with Gentoo Linux (updated)
I was trying to understand why would a sqlite3_prepare return
SQLITE_BUSY. I read the code at prepare.c and tokenize.c but I didn't
find anything.
When can a sqlite3_prepare (with a "select * from table where field1=?
and field
f the word...
> understand?. I am sorry for my english...
>
> On 7/21/06, Daniel van Ham Colchete <[EMAIL PROTECTED]> wrote:
>>
>> Cesar David Rodas Maldonado wrote:
>> > Hello to everybody
>> >
>> > If I have a table with 100.000 unique words
Cesar David Rodas Maldonado wrote:
> Hello to everybody
>
> If I have a table with 100.000 unique words I am wondering if SQLite
> select
> if faster an cheaper (RAM, Processor, etc), or If i have to help SQLite
> using a Hash function, and what could be that Hash function?
>
> Thanks.
>
Cesar,
y
Jay Sprenkle wrote:
>> Jay, thank you very much man! That answers a lot. And it showed me that
>> I was not checking the SQLITE_LOCKED case.
>>
>> But, from what I can see, if your database is busy or locked you just
>> stop your program execution, or you will end this function WITHOUT
>> running n
Jay Sprenkle wrote:
> Here's some example code:
>
> sqlite3*db;
>
> // connect to database
> if ( sqlite3_open( "test.db", &db ) )
> throw "Can't open database";
>
> char* sql;
>
> // two forms of the same sql
> sql = "SELECT one.test1, two.test2"
> " FROM one"
> " INNER JOIN tw
Hello everyone,
I'm new on this list and I have only a few months of experience with
SQLITE. I use SQLITE 3.3.6 for Linux with C++.
I'm having a few problems with locking. But before describing the
problem itself, I would like to check if I'm doing something wrong.
That's what I do when I try to
9 matches
Mail list logo