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
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
---
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
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
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
.
Regards,
~Nuno Lucas
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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]
-
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]
-
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
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]
-
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
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
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
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
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
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
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 &
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
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
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]
-
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]
-
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
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
out sqlite stack usage if that was true.
Regards,
~Nuno Lucas
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
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
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
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]
-
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
.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
n a single locale, and can have only the locale data they need.
Best regards,
~Nuno Lucas
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
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
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
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
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
>
eave the decision of the name convention for the last part of the job.
Regards,
~Nuno Lucas
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
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]
-
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
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]
-
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 (?,?
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
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
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]
-
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]
-
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]
-
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
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]
-
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]
-
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]
-
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
>
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...
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
---
) 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]
-
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
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
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
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
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
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
ight thing to do, and
version numbers are cheap.
Regards,
~Nuno Lucas
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
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
.h etc.
The port includes dummy assert.h and time.h files exactly because of this.
I am unable to use the dll as it requires msvcrt which is not available
on it.
You can't use a windows DLL on CE, even if msvcrt was available. You
will need to compile your own.
Best regards,
~Nuno Lucas
Thanks
nicode.
C:\Windows CE Tools\wce211\PDT7200\Samples\sqlite\vdbe.c(4140) : warning
C4047: '=' : 'void *' differs in levels of indirection from 'int '
This are the "normal" sqlite warnings ;-)
I don't have Windows to test this, but you should now know what to do.
Best regards,
~Nuno Lucas
Please don't feed the troll...
~Nuno Lucas
ectory to make
sure it's writable by the cgi user.
Just my .02 cents, as don't know much about perl.
Regards,
~Nuno Lucas
.
When you use pre-compiled SQL statements you get that info for free,
that is, whitout actually needing to run the query. Look the
sqlite3_column_name function:
* http://sqlite.org/capi3ref.html#sqlite3_column_name
Regards,
~Nuno Lucas
Many thanks
John
d think in using another sqlite wrapper
that allows it...
Regards,
~Nuno Lucas
doing
a COMMIT after every modification of the DB.
Any chance of being the OS file system that "rollbacked" the files
after the crash?
I've seen this before after a Windows CE based machine (with flash
memory as disk) crashed. I would assume NTFS on Windows machines can
do the same.
Regards,
~Nuno Lucas
Just "bind" your data using prepared statements.
You can pass null characters inside.
Another option is to use the X'0011223344' syntax to insert binary
data in hexadecimal format (you can retrieve it in the same format by
using the "quote" function).
Regards,
~Nuno Luca
On 7/25/06, Fred Williams <[EMAIL PROTECTED]> wrote:
Good Grief! Everybody knows CRUD is what you clean off on US Navy ships
at least once a week.
Nice to know it only affects US Navy ships ;-)
(couldn't resist)
e wrapper around the sqlite API that is missing this?
Regards,
~Nuno Lucas
-Ralf
r than a cache hit and can also imply scheduling
decisions against the process/thread).
Regards,
~Nuno Lucas
n look into the shell.c source and just copy the code you want
into your own functions.
The sqlite shell is all implemented in this file, so it's not too hard
to look how it's done there and use in your code.
Regards,
~Nuno Lucas
Any help would be greatly appreciated
Many thanks
John
p your performance.
FileMon from sysinternals (bought recently by Microsoft) is very good
at showing what processes are doing with what files during some time.
Regards,
~Nuno Lucas
recompile.
Best regards,
~Nuno Lucas
Thanks.
Michael
esults with UTF-8 were bugs in
my program (like passing non-UTF-8 string).
Any other unexpected result should be considered a bug in SQLite and
reported as such.
Regards,
~Nuno Lucas
--
Cory Nelson
http://www.int64.org
ficult (remember sqlite is
an embeded SQL engine, which aims for a small size and low memory
footprint).
You can always add a ticket for it, as a new feature, and see how it goes ;-)
Regards,
~Nuno Lucas
estion (it would
probably need a library as big as SQLite itself), so it's up to the
user to define it's own localization funtions and integrate them with
sqlite (there are all the necessary hooks ready for that).
Regards,
~Nuno Lucas
On 8/5/06, Cory Nelson <[EMAIL PROTECTED]> wrote:
On 8/4/06, Nuno Lucas <[EMAIL PROTECTED]> wrote:
> On 8/4/06, Cory Nelson <[EMAIL PROTECTED]> wrote:
> > IE, using memcmp() to compare strings. I've been bitten by this
> > before, with SQLite producing un
I don't mind receiving occasional announcements on new programs using
SQLite (even if I'll never use them), but don't you think one per day
is just too much?
Regards,
~Nuno Lucas
On 8/8/06, Me <[EMAIL PROTECTED]> wrote:
FREE - SQLtNoCase - convert TEXT columns to TEXT COLLATE NOCASE
decide to use different low-level
implementations that
can clash with your hardcoded functions (this is the same as
statically linking
the sqlite library with your application).
Just my .02 cents...
Regards,
~Nuno Lucas
w the problem so just kept away from
collate), but if it seems to work with some corrupted databases it
should work here too.
Regards,
~Nuno Lucas
jp.
re that last '\n'...
Regards,
~Nuno Lucas
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
the reason).
Regards,
~Nuno Lucas
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
[forgot to reply to the list]
-- Forwarded message --
From: Nuno Lucas <[EMAIL PROTECTED]>
Date: Sep 11, 2006 9:07 PM
Subject: Re: Re: [sqlite] met "ARM7TDMI raised an exception,data
abort" when executing sqlite3Parser() in ARM environment
To: [EMAIL PROTECT
st it is if you feed UTF-8 data via an UTF-8 encoded file
instead of using the keyboard. It should work with the file (because
the input is as it should be).
If you only use the C interface to access the database then I only
found UTF-8 support to be wrong when there was a bug in my own code
(as is the case with many sqlite "browsers").
Regards,
~Nuno Lucas
T rows FROM rowcount WHERE name = 'myTable';
Hope this helps,
~Nuno Lucas
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
On 10/25/06, Dennis Cote <[EMAIL PROTECTED]> wrote:
Nuno Lucas wrote:
>
> There is another alternative if you don't mind to have the overhead of
> having an automatic row count (which sqlite avoids by design). It's by
> having a trigger that will update the table row coun
Run some memory leak
tool (e.g. valgrind).
May I ask if this is what would be expected, and whether there is
anything I can do to lower this loading?
Unless you decided to mess with sqlite internals, it's not expected in any way.
Thanks for your help,
Ben.
Best rega
before for internal buffers (to speed up your
I/O).
RSS (the Resident Set Size), is the important one here (unless your
program had parts of it swaped out, which would make it less usefull
for what we want).
Regards,
~Nuno
nguage you are using
and what libraries you are linking to. You may want to investigate
this further.
Regards,
~Nuno Lucas
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
tions and forget about all this. As an advantage, windows
NT internals uses Unicode, so you may have some performance gains in
some places (even if negligible most of the time).
Regards,
~Nuno Lucas
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
aracter
encodings" built-in).
Regards,
~Nuno Lucas
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Unfortunately can't test it because I don't have Windows anymore (and
the gnu-wince toolchain is still too recent to be an authoritative
source).
Best regards,
~Nuno Lucas
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
luding the Borland C++
Builder 5.0 IDE.
Regards,
~Nuno Lucas
see 6.0 Custom Modifications
http://www.hwaci.com/sw/sqlite/prosupport.html
--- panslaw <[EMAIL PROTECTED]> wrote:
> I know that SQLite was written in C and I'm sure it's possible to port
> it for Symbian OS. Bu
actually
does this (but an open source one will be easy to recompile that way).
Regards,
~Nuno Lucas
On 12/21/06, Jeff Godfrey <[EMAIL PROTECTED]> wrote:
All,
Thanks for the interesting responses. I think I now have a clear
understanding of my options, and while not exactly what I was l
ilable for download on the sqlite.org download page.
Well, then you just need to modify src/func.c [1] so that it also
"loads" your power function on startup. Maybe looking into how round()
is implemented will help you start.
Regards,
~Nuno Lucas
[1] http://www.sqlite.org/cvstrac/fileview?f=s
have to
be compatible with older clients (Win9X), a lot of hacks need to be
done (not forgetting it was done in a time Microsoft didn't believe in
the future of TCP/IP).
For better or worse, is still the major network file system for small
networks (and I don't see an
nstead of /dev/random, then I would
think CeGenRandom may be enough for the Windows CE implementation (the
current sqlite port only compiles out of the box for WinCE 4.x+,
anyway).
Regards,
~Nuno Lucas
-
To unsubscribe
y your databases, though.
Regards,
~Nuno Lucas
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
On 2/28/07, Pavan <[EMAIL PROTECTED]> wrote:
Hi,
When i tried to create the db file using API sqlite3_open16("test.db",)
it creats the file name with some junk
characters.
Shouldn't it be "sqlite3_open16(L"test.db",)" ?
Regards,
~Nuno Lucas
The file n
1 - 100 of 219 matches
Mail list logo
