Build of SQLite3 for WINCE ARM4

[bambamns]

Hi Zaher,

When you manage to spare some time, it will be very nice to build latest SQLite (3.7.15.2).

Thx

[Zaher]

Why not

Try it
http://www.parmaja.com/downloads/sqlite3/

[bambamns]

Thx for latest build SQLite (3.7.16.1).

[bambamns]

I have problems using 3.7.16.1 - did you tried ?

[Zaher]

no yet, what problems?

[Zaher]

i have tested it with Windows mobile 6 in SQLViewer only "select" statments.
Maybe more details can help me.

[bambamns]

I have problems with SQL update - same exe work with SQLIte 3.7.15.2.

Do you use locate to find data in SQLQuery ?
I've noticed there is a problem with it on WInCE.

[Zaher]

try it in Win32, use last SQLITE dll
and u can send me your SQL statment and your data to procdure it,
From my side, i just compiled it to WINCE nothing else, but let us find where the problem.

[bambamns]

I know you just compiled it - Thank you.

I'll debug it and report what is the problem (maybe I have bug in my code and it works with old sqlite versions).

Major thing I have noticed till today, is if you use Locate method on SQLQuery  with PacketRecords property set to default (10) it sometimes have problems to locate data.
Workaround is to change PacketRecords property to -1 (load all data).

[bambamns]

Zaher,

Any chance to compile new 3.7.17 version ?

Thank you

[Zaher]

Yes, check it here
http://sourceforge.net/projects/minilib/files/miniSQLViewer/

[bambamns]

@Zaher,

Please, make a note about builds - what is the version difference :
sqlite3-3.7.17-arm.dll
sqlite3-3.7.17-arm4i.dll

Thx

[swierzbicki]

Hello Zaher,

First, thank you for your work and thank you for sharing your compiled DLLs.

I've a question : multiple TSQlite3Connection has to connect to my SQLite Database (1 connection in my main thread), the other connection from a worker thread.
I tried to use the WAL mode but still get "Database is locked" error.

Is your library compiled to be thread safe ? : http://www.sqlite.org/threadsafe.html

Thank you for your answer

[Zaher]

I think "No" the answer
Please check it by call sqlite3_threadsafe()

Start-time selection of threading mode

Assuming that the compile-time threading mode is not single-thread, then the threading mode can be changed during initialization using the sqlite3_config() interface. The SQLITE_CONFIG_SINGLETHREAD verb puts SQLite into single-thread mode, the SQLITE_CONFIG_MULTITHREAD verb sets multi-thread mode, and the SQLITE_CONFIG_SERIALIZED verb sets serialized mode.

Than mean i must compile it with threadsafe, but what must i choose
SQLITE_THREADSAFE=1 or 2?

for testing i compiled it with SQLITE_THREADSAFE=1 try it
download "sqlite3-3.7.17-arm-wince-ts.zip" from
http://sourceforge.net/projects/minilib/files/miniSQLViewer/

[swierzbicki]

Thank you for this really fast answer
I'll test your DLL tomorrow afternoon and I'll give you some feedbacks. Thank you again !!!