Re: [sqlite] Encoding and Collation

2011-09-14 Thread Nuno Lucas
. Regards, ~Nuno Lucas ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Encoding and Collation

2011-09-11 Thread Nuno Lucas
easy way (partial support for just the common western scripts) it's easy. And already done by many, if you search the mailing list. As a final note, SQLite 2 never had any support for ISO-8859-X collations, so you have no reason to believe SQLite 3 would have it. Regards, ~Nuno Lucas > > Thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] c89 (long long) compatibility warning in amalgamation build

2011-09-08 Thread Nuno Lucas
quot;true answer" (TM) exists. If I remember correctly, you can use the header in C89 mode with the Linux libc, so you could workaround with that in mind. Regards, ~Nuno Lucas ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Table info for a particular query

2011-06-09 Thread Nuno Lucas
--- But I'm not sure if it's exactly the same as if from a select. Regards, ~Nuno Lucas ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] .import error: cannot open large file

2011-06-03 Thread Nuno Lucas
If the shell is not compiled for large file access that flag will not be present. The latter is what happens using the pre-compiled sqlite binary. Regards, ~Nuno Lucas ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] .import error: cannot open large file

2011-06-02 Thread Nuno Lucas
gcc -o sqli -O3 -DNDEBUG=1 -D_FILE_OFFSET_BITS=64 sqlite3.c shell.c -ldl -pthread The resulting binary (sqli) will be compiled with large file support (I verified it was using strace). Regards, ~Nuno Lucas P.S.- While this could be considered an Ubuntu bug, the truth is that the linux she

Re: [sqlite] SQLite version 3.6.21

2009-12-12 Thread Nuno Lucas
model: posix gcc version 4.4.1 (Ubuntu 4.4.1-4ubuntu8) It takes 26 minutes to compile the amalgamation source on this device, so it took me 52 minutes of compile time just to confirm this, so I'm not very inclined to do a full "make test", but if there is a real interest I can do

Re: [sqlite] WHERE CLAUSE in UNICODE

2009-11-30 Thread Nuno Lucas
-), etc, is when we decide the order of the items to show (the order the user viewing the data expects). Regards, ~Nuno Lucas ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Tedious CSV import question

2009-10-06 Thread Nuno Lucas
gt; csvfile.o ext_init.o > > Thanks for all your help! Glad you got help from others, as I really have no idea on how to compile things on Mac OS. Regards, ~Nuno Lucas > > --Emyr > ___ > sqlite-users mailing list > sqlite-user

Re: [sqlite] Tedious CSV import question

2009-10-05 Thread Nuno Lucas
Roger Binns wrote: > Nuno Lucas wrote: >> (in fact, the code doesn't compile using the bundled >> 3.4.2 version on my Ubuntu 8.04 machine). > > Are you sure it is the virtual table api that is the problem and not some > other ones. I haven't changed my virtual table

Re: [sqlite] Tedious CSV import question

2009-10-05 Thread Nuno Lucas
Emyr Thomas wrote: > On Sep 27, 6:35 pm, Nuno Lucas <ntlu...@gmail.com> wrote: >> Some time ago I had to do something similar and decided to write a small >> virtual table implementation to treatCSVfiles as just another table. >> This works for my uses which is to import

Re: [sqlite] building permanently loaded extensions

2009-09-28 Thread Nuno Lucas
vor. I believe you want to look at sqlite3_auto_extension() [1] [1] http://www.sqlite.org/c3ref/auto_extension.html Regards, ~Nuno Lucas ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Tedious CSV import question

2009-09-27 Thread Nuno Lucas
sqlite> .s CREATE VIRTUAL TABLE csv USING csvfile('test.csv'); sqlite> .mode col sqlite> .h 1 sqlite> select * from csv; col1col2col3 -- -- ------ 123324234 124342 342342 232 fsdfsdfsd erwe32 Regards, ~Nuno Lucas > > Than

Re: [sqlite] sort by in Sqlite

2009-08-05 Thread Nuno Lucas
to either use the second or roll their own collating extensions. Note that it's easy enough to roll your own "icu" like extension (for example, if you only use Win32, you could just use the native system collation functions), but then you would need to make sure every access

Re: [sqlite] "Bad CPU type in executable"?

2009-08-05 Thread Nuno Lucas
Jimmy Verner wrote: > Sounds like I'm not welcome on this list. Go hassle someone else. > Goodbye. A bit sensitive, no? I was actually defending you. Regards, ~Nuno Lucas > Jimmy Verner > www.vernerlegal.com ___ sqlite-users mailing

Re: [sqlite] "Bad CPU type in executable"?

2009-08-05 Thread Nuno Lucas
Jean-Denis Muys wrote: > You're top-posting, it's evil, the thread is becoming messy. That said... And you are including everything of the earlier mail, which is even more evil than top-posting by itself. Ok, I'm done with my rant-per-year mails. Regards, ~Nuno Lu

Re: [sqlite] How does SQLite handle newlines in values?

2009-06-13 Thread Nuno Lucas
X'3031320A303132' 3 X'49742773206F6B' So, as you can see, if you insert values as BLOBs it will return BLOBs and if you insert values as TEXT it will return text. Regards, ~Nuno Lucas > >  (I have already found out that newlines stored as blobs are returned >  literally

Re: [sqlite] sqlite3_step performance degredation

2009-06-12 Thread Nuno Lucas
gCursor (and notice the "What not to do" at the end, talking about "LIMIT" and "OFFSET"). If my my psychic abilities are becoming weak, then please supply your exact query that is getting slower (and maybe your database schema) and then someone can give you an exact answer. Re

Re: [sqlite] Terminating a query

2009-06-08 Thread Nuno Lucas
TerminateThread, > but the database cannot be queried after this, and the entire program > has to be aborted and reloaded because (I assume) of some unclosed SQL > handles. > > So is there a way to terminate a query gracefully? http://www.sqlite.org/c3ref/interrupt.html Regards, ~Nu

Re: [sqlite] Getting last inserted rowid?

2009-06-05 Thread Nuno Lucas
cific code being run. If you don't use the same connection handle, then all this is moot, as all synchronization is done at the file level. I didn't try to be exhaustive. That is your job. Now, if you still have doubts after this I don't think I can be of any help, as that makes it obvious my commun

Re: [sqlite] Getting last inserted rowid?

2009-06-04 Thread Nuno Lucas
On Wed, Jun 3, 2009 at 11:22 PM, Nikolaus Rath <nikol...@rath.org> wrote: > Nuno Lucas <ntlu...@gmail.com> writes: >> On Wed, Jun 3, 2009 at 2:41 AM, Nikolaus Rath <nikol...@rath.org> wrote: >>> Nuno Lucas <ntlu...@gmail.com> writes: >>>>

Re: [sqlite] Getting last inserted rowid?

2009-06-03 Thread Nuno Lucas
On Wed, Jun 3, 2009 at 2:41 AM, Nikolaus Rath <nikol...@rath.org> wrote: > Nuno Lucas <ntlu...@gmail.com> writes: >> On Tue, May 26, 2009 at 5:17 PM, Nikolaus Rath <nikol...@rath.org> wrote: >>> Hello, >>> >>> How can I determine the rowi

Re: [sqlite] Slow Transaction Speed?

2009-05-27 Thread Nuno Lucas
imple "BEGIN IMMEDIATE" --> "END" operation). Regards, ~Nuno Lucas [1] http://www.sqlite.org/lang_transaction.html ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Slow Transaction Speed?

2009-05-27 Thread Nuno Lucas
iscourage people from using it until they understand very well what they are doing (it's not easy, and many time impossible, to recover a corrupt SQLite database). If you really want speed, you can try the new async VFS, which will do the atomic writes in a background thread. Regards, ~Nuno Lucas

Re: [sqlite] Slow Transaction Speed?

2009-05-26 Thread Nuno Lucas
On Tue, May 26, 2009 at 9:47 PM, Marcus Grimm <mgr...@medcom-online.de> wrote: [..] > So the question is: > Is it somehow normal to have only 7 transactions per second? Yes [..] > Any comment on this ? http://www.sqlite.org/faq.html#q19 Regar

Re: [sqlite] Getting last inserted rowid?

2009-05-26 Thread Nuno Lucas
ill work if each thread has it's own db handle, but don't know what will happen you use the shared cache feature. Regards, ~Nuno Lucas > > I can't believe that I really have to do a SELECT on the data that I > just INSERTed only to get the rowid... > > > Thanks, > >   -Nikola

Re: [sqlite] SQLite3 support for 64-bit unsigned integers

2009-05-25 Thread Nuno Lucas
are stored as little-endian (the first byte would then be the one less significant). Regards, ~Nuno Lucas ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] error in documentation of SELECT?

2009-05-19 Thread Nuno Lucas
> select "€", length("€"), length(cast("€" as blob)), hex("€"); "€" length("€") length(cast("€" as blob)) hex("€") -- - --- -- € 1 3

Re: [sqlite] error in documentation of SELECT?

2009-05-19 Thread Nuno Lucas
d sync your client application clock. As SQLite is not a server, most pratical examples are for running user defined functions. The documentation could be ommiting this, but it's an esoteric enough feature. Regards, ~Nuno Lucas > -- > >    --- Mitchell L Model

Re: [sqlite] error in documentation of SELECT?

2009-05-18 Thread Nuno Lucas
On Mon, May 18, 2009 at 7:53 PM, Pavel Ivanov <paiva...@gmail.com> wrote: > Actually I wanted to know if it can be useful somewhere. :-) You could have a calculator command on your application and let SQLite parse the result for you ;-) sqlite> SELECT 1+2*(3+4*5); 47 Regards,

Re: [sqlite] Locking in sqlite

2009-05-02 Thread Nuno Lucas
me time on the same database file. Regards, ~Nuno Lucas > > Pavel ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] problem with SQLITE_FULL

2009-02-27 Thread Nuno Lucas
n the table is 700. > I have no idea how to solve it. Maybe what is full is the partition where the temporary files are created? Regards, ~Nuno Lucas > Could anyone help me? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.

Re: [sqlite] sqlite3_open expensive?

2009-02-27 Thread Nuno Lucas
of the databases you will be opening maybe a safe bet is to cache connection handlers. Regards, ~Nuno Lucas > regards, luky > > ps: sqlite3_enable_shared_cache is turned on. > > > > ___ > sqlite-users mailing list > sqlite-u

Re: [sqlite] Question on missing Entry Point for Sqlite 3

2009-02-09 Thread Nuno Lucas
age authors, as all this has nothing to do with SQLite itself (the SQLite "team", has nothing to do with .NET wrappers or how distros package it). Regards, ~Nuno Lucas ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE3_OPEN returns SQLITE_NOMEM

2008-12-22 Thread Nuno Lucas
terest is that Win95 and early Win98 machines also lack this conversion because it's an Internet Explorer upgrade that includes this capability to the system (but as every machine badly needs those IE upgrades, it should not be a problem). If you use only the UTF-16 API then it should work (if it'

Re: [sqlite] Generic speed testing

2008-08-17 Thread Nuno Lucas
ower than the disk based one because it's not optimized for memory use (like using B+ Trees in memory instead of something like RB Trees, as it was on 2.8.x). This is all from memory, so someone correct me if I'm wrong. Regards, ~Nuno Lucas > > Regards -- Noah _

Re: [sqlite] SQL statement to get min/max values

2008-08-14 Thread Nuno Lucas
SELECT max(Data) from test_table WHERE ExternalID=2; 5 sqlite> SELECT min(Data) from test_table WHERE ExternalID=2; -20 ----- Seems to work ok for me. What values were you expecting? Regards, ~Nuno Lucas __

Re: [sqlite] sqlite3_open returns SQLITE_NOMEM

2008-06-26 Thread Nuno Lucas
On Thu, Jun 26, 2008 at 1:38 AM, Ryan Clark <[EMAIL PROTECTED]> wrote: > This is a "known" issue. > http://www.sqlite.org/cvstrac/tktview?tn=2508,6 And I had proposed a patch about a month before: http://www.sqlite.org/cvstrac/tktview?tn=2479 Regards, ~Nuno Lucas >

Re: [sqlite] Return row order

2008-02-25 Thread Nuno Lucas
bset of the second. No, the SQL standard is very explicit about that. The only way to be sure is by using an "ORDER BY" clause, but you can use "ORDER BY rowid" if you really want to sort by the internal b-tree index (but you need to know what

Re: [sqlite] compiling C program to use the shared library

2008-02-24 Thread Nuno Lucas
file. Other compilers have similar systems. I don't recall the exact parameters, so just look at the command help (or google is your friend). Regards, ~Nuno Lucas ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Please test lastest CVS using WinCE

2008-02-22 Thread Nuno Lucas
because the OEM removed the UTF-8 character mapping from the OS build. The ticket has a possible workaround. Regards, ~Nuno Lucas [1] http://www.sqlite.org/cvstrac/tktview?tn=2479 > Cheers, > Dave ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite slow on WindowsXP

2008-02-20 Thread Nuno Lucas
un it > under WndowsXP it takes about 2 hours! > Does anybody know why? Use transactions, that is, start with a "BEGIN" and finish with an "END". You will see that all your inserts will drop to just seconds instead of minutes (in Linux AND Windows). Regards, ~Nuno Lucas ___

Re: [sqlite] what platforms does SQLite run on?

2008-02-19 Thread Nuno Lucas
0 itself it compiles out of the box). Other than that, just use the last SQLite version. Regards, ~Nuno Lucas ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Should the next release be 3.5.4 or 3.6.0?

2007-12-13 Thread Nuno Lucas
ight thing to do, and version numbers are cheap. Regards, ~Nuno Lucas - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] compilation error in sqlite 3.5.3

2007-11-30 Thread Nuno Lucas
warning(s) > > Where i can get this tcl.h file If you don't need TCL support just don't include tclsqlite.c in your project. For you information, TCL is a script language, and SQLite includes "native" support for it. If you don't know about it then I guess you don't need it (it is used

Re: [sqlite] benchmarking UTF8 vs UTF16 encoded databases

2007-11-23 Thread Nuno Lucas
result. The same is true with any other portable file format. Regards, ~Nuno Lucas > > Best regards, > Igor > > > > > -Original Message- > From: Nuno Lucas [mailto:[EMAIL PROTECTED] > Sent: Friday, November 23, 2007 2:01 PM > To: sqlite-users@sqlite.org &g

Re: [sqlite] benchmarking UTF8 vs UTF16 encoded databases

2007-11-23 Thread Nuno Lucas
F-16LE ? If you only speak Japanese and all your characters are 3 bytes or more in UTF-8 and always 2 bytes in UTF-16 which would you tend to choose? About the endieness, you don't need to know if you don't care. SQLite handles it. Reg

Re: [sqlite] Sqlite version for libc 2.1.3

2007-11-23 Thread Nuno Lucas
to the x86 platform, but different library versions). Regards, ~Nuno Lucas On 11/23/07, Tara_Nair <[EMAIL PROTECTED]> wrote: > Thanks for your response, Trevor. > > It is what I had initially thought too, that if I built it with an older > set of libraries it will look for those v

Re: [sqlite] Performance tuning using PRAGMA, other methods

2007-11-20 Thread Nuno Lucas
ntation have more than enough information for the level of detail you want. Regards, ~Nuno Lucas > -Original Message- > From: Tom Briggs [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 20, 2007 1:41 PM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] Performance

Re: [sqlite] Problem creating extension for use with load_extension

2007-11-10 Thread Nuno Lucas
ension('mydblib.dll'); > SQL error: The specified procedure could not be found. > Seems like you didn't enable the extension loading mechanism. It defaults to disabled for security reasons. Check the wiki page about the SQLITE_OMIT_LOAD_EXTENSION define: * http://www.sqlite.org/c

Re: [sqlite] SQLite and Large Databases

2007-11-08 Thread Nuno Lucas
) if you really want to have a meaningful clue on the memory usage of your program. Regards, ~Nuno Lucas - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] extension-functions.tgz for sqlite3 3.4.1 ?

2007-09-11 Thread Nuno Lucas
your module? Don't know current compiler standard compliance, but maybe including the "new" header file and using uint8_t, uint16_t, etc. could be better yet (instead of every library having it's own typedef section for basic types). Regards, ~Nuno Lucas ---

Re: [sqlite] SQLite or MS Access

2007-09-07 Thread Nuno Lucas
tude slower on SQLite (because it waits for the data to get to the disk controller) than for Access (which just gives the data to the OS, not caring if it goes to disk or not). In a nutshell, benchmarks are not easy...

Re: [sqlite] Re: select round(98926650.50001, 1) ?

2007-09-05 Thread Nuno Lucas
On 9/5/07, Cory Nelson <[EMAIL PROTECTED]> wrote: > On 9/5/07, Nuno Lucas <[EMAIL PROTECTED]> wrote: > > What about defining __STD_IEC_559 before the compilation? > > Acording to this: > > > >http://david.tribble.com/text/cdiffs.htm#C99-iec60559 >

Re: [sqlite] Re: select round(98926650.50001, 1) ?

2007-09-05 Thread Nuno Lucas
o maybe libc does it by default, but the official sqlite compiled version (which IIRC is linked with the old Microsoft C runtime DLL) doesn't. Regards, ~Nuno Lucas > > Rgds, > Simon - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: select round(98926650.50001, 1) ?

2007-09-03 Thread Nuno Lucas
seems SQLite is already doing the right job. Maybe some OS specific error? Wasn't there some discussion earlier about the Microsoft compiler not using the full double precision by default? Regards, ~Nuno Lucas > e > > -- > Doug Currie > Londonderry, NH, USA - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: select round(98926650.50001, 1) ?

2007-09-03 Thread Nuno Lucas
ound() is implemented. Regards, ~Nuno Lucas [1] http://www.sqlite.org/cvstrac/fileview?f=sqlite/src/func.c=1.174 > > thanks, Serena. - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Problem opening a new SQLite3 database file

2007-08-25 Thread Nuno Lucas
ure there are good ones that deserve the money one pays for them, but it's stupid to pay before you know the limitations of the free alternatives). The reason I don't explain why your way doesn't work is because if you don't know what a PATH

Re: [sqlite] Aggregate and query limit

2007-08-18 Thread Nuno Lucas
void reading full rows if you don't need to (like having an index - or an autogenerated temporary index - you can use) when sqlite does the initial "skip" part. Regards, ~Nuno Lucas > > Thanks, > Mina. - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Odd error on "BEGIN IMMEDIATE"

2007-08-17 Thread Nuno Lucas
on, don't you think? > Why does the engine think I'm still in a transaction? You didn't end the transaction with either "COMMIT"/"END" or "ROLLBACK". Regards, ~Nuno Lucas > thanks, > > Scott - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] SELECT INTO ... not supported?

2007-08-17 Thread Nuno Lucas
help with a workaround that doesn't need an explict (and > rather long) list of fields in the 3-table join that is my real > non-simple requirement? http://www.sqlite.org/lang_insert.html Regards, ~Nuno Lucas > Thanks in advance, > > John - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: Re: Re: Re: Re: Re: Re: How does SQLite choose the index?

2007-08-06 Thread Nuno Lucas
esources by having the bridge built in a special way, like in an U shape to increase strength against the current. Regards, ~Nuno Lucas > > RBS > > > > Absolutely. Big bridge or small bridge, if it fails you fall in the > > water. > > > > It looks as if the bridge

[sqlite] [RFC] About the sqlite3 collation needed callbacks: design flaw?

2007-07-31 Thread Nuno Lucas
t the code is because I believe it's trivial enough, and if I did then it would have to wait until the legal bureaucracy of copyright assignment was done before being merged into the tree. Best regards, ~Nuno Lucas [1] http://www.sqlite.org/capi3ref.html#sqlite3_collat

Re: [sqlite] Unicode Again... Still Stuck... A Challenge... Store and retrieve the word résumé without using a unicode string literal

2007-07-31 Thread Nuno Lucas
rds which you need to read, but Outlook is famous for not following those standards, so it means a lot of hacks to to have it right. This are just notes for you. I'm not even an expert on this. Regards, ~Nuno Lucas > f = cgi.FieldStorage() > cur.execute("insert into test values (?,?

Re: [sqlite] Changing Database Encoding

2007-07-30 Thread Nuno Lucas
inserting the data into a 3.x database. That can be more difficult than you think in case of mismatched use of library versions. Regards, ~Nuno Lucas > > Any help is appreciated! Thanks! > > -- > - Mitchell Vincent - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: Re: [sqlite] sqlite3_open() fails on WinCE due to utf8ToUnicode / unicode

2007-06-29 Thread Nuno Lucas
On 6/12/07, Nuno Lucas <[EMAIL PROTECTED]> wrote: On 6/7/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > It really looks like this UTF-8 codepage is not avaiable. Is there > any WinCE developer that uses SQLite newer than version 3.3.9 on this > list? -> Did you have

Re: [sqlite] Question about triggers

2007-06-28 Thread Nuno Lucas
ment. Example: CREATE TABLE x ( a, b DEFAULT CURRENT_TIMESTAMP ); INSERT INTO TABLE x (a) VALUES (12345); b has an automatic timestamp. Regards, ~Nuno Lucas - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: Unicode collation

2007-06-28 Thread Nuno Lucas
eave the decision of the name convention for the last part of the job. Regards, ~Nuno Lucas - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Unicode collation

2007-06-28 Thread Nuno Lucas
On 6/28/07, Trevor Talbot <[EMAIL PROTECTED]> wrote: On 6/28/07, Nuno Lucas <[EMAIL PROTECTED]> wrote: > One thing I noticed is that "collations" != "case change". This will > not make it possible to use UPPER/LOWER with the same data on the >

Re: [sqlite] Unicode collation

2007-06-28 Thread Nuno Lucas
he usual "pt_PT" and "pt_BR" for Portuguese/Portugal culture and Portuguese/Brazil culture) , but I'm open to suggestions when that problem arise, and I'm sure there are already standards we can follow in relation to that. Well, I will probably only have time to actually put words into

Re: [sqlite] Unicode collation

2007-06-28 Thread Nuno Lucas
on the table, but maybe we can work on something in that respect, also. Regards, ~Nuno Lucas [1] http://developer.mimer.com/collations/charts/index.tml [2] http://www.unicode.org/reports/tr10/ [3] http://en.wikipedia.org/wiki/European_Ordering_Rules Jiri

Re: [sqlite] Unicode collation

2007-06-27 Thread Nuno Lucas
ut you are forgetting you can have a database in a shared network folder, used by PC's in different parts of the world and even different OSs (with samba/cifs). That's why I like Trevor's idea so much. Best regards, ~Nuno Lucas

Re: [sqlite] Unicode collation

2007-06-27 Thread Nuno Lucas
n a single locale, and can have only the locale data they need. Best regards, ~Nuno Lucas - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Help with compiling 3.3.17 version for WinCE

2007-06-18 Thread Nuno Lucas
.0, you may want to look at the old sqlite-wince.sf.net code, which include compatibility headers for assert.h and time.h (and support for WinCE 2.x using the legacy 2.8.x branch). Regards, ~Nuno Lucas - To unsubsc

Re: Re: [sqlite] sqlite3_open() fails on WinCE due to utf8ToUnicode / unicode

2007-06-12 Thread Nuno Lucas
de should have a fallback to the earlier behaviour if CP_UTF8 is not supported on the device (as it happens with most WinCE 4.x and older devices). Did you open a ticket for this? Regards, ~Nuno Lucas - To unsubscribe, s

Re: [sqlite] sqlite3_create_function function name when called?

2007-06-12 Thread Nuno Lucas
method (maybe in conjunction with the experimental sqlite3_overload_function method to assure an empty function exists). Regards, ~Nuno Lucas Thanks. - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Stack usage

2007-06-05 Thread Nuno Lucas
from unions where deep recursion may be used? I believe your question is more for other places where you can avoid the deep recursion (as the deep recursion will always lead to the same problem). Best regards, ~Nuno Lucas -- Ka

Re: Re: [sqlite] Stack usage

2007-06-05 Thread Nuno Lucas
pinion, your case doesn't "deserve" to be fixed. You can make the generator create a temporary table, insert the data on it, make the select and then drop the table, even if that would involve more coding (at least to handle the final table drop after geting

Re: [sqlite] Stack usage

2007-06-05 Thread Nuno Lucas
out sqlite stack usage if that was true. Regards, ~Nuno Lucas - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] No space left on device?

2007-06-04 Thread Nuno Lucas
space left. It's up to your application to handle the error gracefully. I'm asking this because I have a process dying (being killed) because it exauted main memory. That is probably a memory leak in you application (maybe some bug in the error path). Regards. ~Nuno Lucas Cheers Alberto -- A

Re: [sqlite] ALTER TABLE ADD COLUMN - strange behaviour....Mac OSX

2007-06-03 Thread Nuno Lucas
On 6/3/07, Mark Gilbert <[EMAIL PROTECTED]> wrote: Anyone have *any* idea what is happening ? I don't know nothing about MacOS, but you may want to check the result of sqlite3_close. It's possible it's not closing the database [1]. Regards, ~Nuno Lucas [1] http://www.sqlite.org/capi3re

Re: [sqlite] sqlite internal structs don't make use of C bitfields?

2007-06-02 Thread Nuno Lucas
problems when porting x86 code to other platforms). The subject is a bit more complex than this, because to really talk about it we would also need to talk about what the C standard says about the volatile keyword and how different compilers treat it. But it's becoming off-topic. Regards, ~Nuno Lucas - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: Re: [sqlite] sqlite3_open() fails on WinCE due to utf8ToUnicode / unicodeToU

2007-06-01 Thread Nuno Lucas
I can enable UTF-8 support. (hope this is not to offtopic). Sorry but never used the WinCE builder tool. Maybe someone here knows better. Regards, ~Nuno Lucas Regards, Daniel - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] sqlite3_open() fails on WinCE due to utf8ToUnicode / unicodeToUtf8

2007-06-01 Thread Nuno Lucas
n: Is this a bug or is something wrong with my WinCE-Image? It probably means your WinCE OS image doesn't have UTF-8 support built-in, so you either have to make your own character set conversions or rebuild the OS image with that support (if you can change the image, that is). Regards, ~Nuno

Re: [sqlite] sqlite internal structs don't make use of C bitfields?

2007-05-31 Thread Nuno Lucas
quot;set bit"), and also compilers typically don't optimize well with that (so before >> applying this patch, I would test on other platforms than gcc linux x86). is not true. It's true not all CPUs hav

Re: [sqlite] SQL error: disk I/O error

2007-05-23 Thread Nuno Lucas
or so (is usually configurable by a kernel parameter), but has the drawback of messing with the ACID nature of SQLite. Regards, ~Nuno Lucas Somehow I don't have a problem in a tmpfs. The strace showed no diff between tmpfs and this directory where it is giving I/O error. Thanks On 5/22/07, Joe Wilson &

Re: [sqlite] file structure issue

2007-05-23 Thread Nuno Lucas
ke linux, cygwin or MSYS). After that is done, you should have all preprocessed files generated, so you can just copy them to where you want. Regards, ~Nuno Lucas [1] http://www.sqlite.org/sqlite-3.3.17.tar.gz wang - To u

Re: [sqlite] Re: How to sort not binary?

2007-05-13 Thread Nuno Lucas
It's up to you to feed with a collation that does natural sort. A few thousand rows are not much in modern computer terms, but I have no idea on the impact in terms of performance the .NET wrapper has. Test it and you'll kn

Re: [sqlite] porting sqlite3 to embeded os-----lock question

2007-05-11 Thread Nuno Lucas
ctions that always succeed. another question: There is also a little difficult to realize the sqlite3WinThreadSpecificData function to get the thread information, Is this also must realize ? If you use threads, then that would depend on your use of sqlite. Regards, ~Nuno Lucas thanks

Re: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

2007-05-04 Thread Nuno Lucas
On 5/4/07, Ken <[EMAIL PROTECTED]> wrote: 100% concur with Dennis. Thanks again for a great product! +1 I couldn't said it better, maybe even in my native language ;-) Best regards, ~Nuno Lucas Dennis Cote <[EMAIL PROTECTED]> wrote: [EMAIL PROTECTED] wrote: > > C

Re: [sqlite] Sqlite 14 (cant open database)

2007-05-04 Thread Nuno Lucas
files on FAT32 (some disk utilities could even trash your drive). I don't know if the recent vfat drivers were fixed to handle more than 2 GB files, though. Maybe no one considered it important until recently (only now you have FAT32 USB disks with more than 4GB space free). Best regards, ~Nuno

Re: [sqlite] Odd performance issue under Windows

2007-04-26 Thread Nuno Lucas
ve noticed this link: http://www.microsoft.com/technet/prodtechnol/windows2000serv/maintain/optimize/wperfch7.mspx Regards, ~Nuno Lucas 3. Settings which cause Media Center to be more aggressive about flushing its cache than Pro or Home. If this hypothesis is correct, Pro or Home would be putting a higher

Re: [sqlite] Reducing memory usage when reading a blob

2007-04-19 Thread Nuno Lucas
lob_id=:ID: ORDER BY blob_seq; Disclaimer: I haven't tested the SQL, but you should get the idea. Regards, ~Nuno Lucas Thanks, -Stan - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] SQLite and memory usage

2007-04-18 Thread Nuno Lucas
using the lowest levels routines, nor counting the right high level ones. Also, SQLite has it's own memory leak detector, which you can enable to make sure there are no memory leaks (but off course slowing down your program a lot) Look at the file util.c. It should give you an idea. Regards, ~Nuno

Re: [sqlite] Performance analysis of SQLite statements

2007-04-13 Thread Nuno Lucas
requency scaling) and could give different results on different CPUs (the motherboard can include a high-res time source, but many don't, and some are just too slow to fetch a value). Regards, ~Nuno Lucas Regards Nick - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Performance analysis of SQLite statements

2007-04-12 Thread Nuno Lucas
Other than that, as long as the code works on a "single-core" CPU, it should work on newer ones. Off course, there is that word: "should" ;-) Regards, ~Nuno Lucas - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] PHP5 and SQLite3.3.13

2007-04-05 Thread Nuno Lucas
parate packages, so if you get 2.8.x you have the wrong source. Regards, ~ Nuno Lucas Is there anybody in the know? Thanks Ulrich - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Sorting with latin1 characters

2007-03-31 Thread Nuno Lucas
create_collation Regards, ~Nuno Lucas I am using DBD::SQLite, so I am not sure if I tested correctly the change of environment variables to see if sqlite reacts to that changes. Thanks in advance for any help Cheers -

Re: [sqlite] what's the fastest way to get the record count of a table?

2007-03-28 Thread Nuno Lucas
Using a trigger to maintain a table count on an auxiliary table after every insert/delete is the prefered way. This was discussed before on the list and i believe there is an example on how to do this. Regards, ~Nuno

Re: [sqlite] Difference in these indices?

2007-03-27 Thread Nuno Lucas
pretty good generic (and fast) ones. My guess is that it should be an hash function that spreads the calculated hash in an ordered way, so one could walk the hash table in a similar way than an ordered directory. Regards, ~Nuno

  1   2   3   >