Recent

Author Topic: Build of SQLite3 for WINCE ARM4  (Read 33157 times)

bambamns

  • Full Member
  • ***
  • Posts: 223
Re: Build of SQLite3 for WINCE ARM4
« Reply #15 on: January 27, 2013, 06:25:02 am »
Hi Zaher,

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

Thx
Lazarus 1.8.4 + FPC 2.6.4 x86 (rebuild) and Lazarus 2.0, Windows 7 x64, unless otherwise specified


bambamns

  • Full Member
  • ***
  • Posts: 223
Re: Build of SQLite3 for WINCE ARM4
« Reply #17 on: April 12, 2013, 11:35:58 am »
Thx for latest build SQLite (3.7.16.1).
Lazarus 1.8.4 + FPC 2.6.4 x86 (rebuild) and Lazarus 2.0, Windows 7 x64, unless otherwise specified

bambamns

  • Full Member
  • ***
  • Posts: 223
Re: Build of SQLite3 for WINCE ARM4
« Reply #18 on: April 12, 2013, 07:16:27 pm »
I have problems using 3.7.16.1 - did you tried ?
Lazarus 1.8.4 + FPC 2.6.4 x86 (rebuild) and Lazarus 2.0, Windows 7 x64, unless otherwise specified

Zaher

  • Hero Member
  • *****
  • Posts: 593
    • parmaja.com
Re: Build of SQLite3 for WINCE ARM4
« Reply #19 on: April 12, 2013, 08:51:01 pm »
no yet, what problems?

Zaher

  • Hero Member
  • *****
  • Posts: 593
    • parmaja.com
Re: Build of SQLite3 for WINCE ARM4
« Reply #20 on: April 12, 2013, 09:04:25 pm »
i have tested it with Windows mobile 6 in SQLViewer only "select" statments.
Maybe more details can help me.

bambamns

  • Full Member
  • ***
  • Posts: 223
Re: Build of SQLite3 for WINCE ARM4
« Reply #21 on: April 13, 2013, 01:49:15 pm »
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.
Lazarus 1.8.4 + FPC 2.6.4 x86 (rebuild) and Lazarus 2.0, Windows 7 x64, unless otherwise specified

Zaher

  • Hero Member
  • *****
  • Posts: 593
    • parmaja.com
Re: Build of SQLite3 for WINCE ARM4
« Reply #22 on: April 13, 2013, 02:01:58 pm »
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

  • Full Member
  • ***
  • Posts: 223
Re: Build of SQLite3 for WINCE ARM4
« Reply #23 on: April 14, 2013, 10:14:48 pm »
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).
Lazarus 1.8.4 + FPC 2.6.4 x86 (rebuild) and Lazarus 2.0, Windows 7 x64, unless otherwise specified

bambamns

  • Full Member
  • ***
  • Posts: 223
Re: Build of SQLite3 for WINCE ARM4
« Reply #24 on: July 05, 2013, 09:49:34 pm »
Zaher,

Any chance to compile new 3.7.17 version ?

Thank you
Lazarus 1.8.4 + FPC 2.6.4 x86 (rebuild) and Lazarus 2.0, Windows 7 x64, unless otherwise specified


bambamns

  • Full Member
  • ***
  • Posts: 223
Re: Build of SQLite3 for WINCE ARM4
« Reply #26 on: July 12, 2013, 05:02:28 am »
@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

Lazarus 1.8.4 + FPC 2.6.4 x86 (rebuild) and Lazarus 2.0, Windows 7 x64, unless otherwise specified

swierzbicki

  • Full Member
  • ***
  • Posts: 177
Re: Build of SQLite3 for WINCE ARM4
« Reply #27 on: August 12, 2013, 09:00:54 am »
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
Lazarus 1.6.2
fpc 3.0.0
wince/win32/win64
delphi berlin

Zaher

  • Hero Member
  • *****
  • Posts: 593
    • parmaja.com
Re: Build of SQLite3 for WINCE ARM4
« Reply #28 on: August 12, 2013, 03:40:27 pm »
I think "No" the answer :(
Please check it by call sqlite3_threadsafe()

Quote
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

  • Full Member
  • ***
  • Posts: 177
Re: Build of SQLite3 for WINCE ARM4
« Reply #29 on: August 12, 2013, 08:01:37 pm »
Thank you for this really fast answer ;)
I'll test your DLL tomorrow afternoon and I'll give you some feedbacks. Thank you again !!!
Lazarus 1.6.2
fpc 3.0.0
wince/win32/win64
delphi berlin

 

TinyPortal © 2005-2018