Lazarus

Announcements => Third party => Topic started by: Zaher on August 25, 2010, 03:31:36 am

Title: Build of SQLite3 for WINCE ARM4
Post by: Zaher on August 25, 2010, 03:31:36 am
We uploaded a Dll build of SQLite3 for WINCE ARM4

sqlite3-3.6.23.1-wince-arm.zip
sqlite3-3.7.0.1-wince-arm.zip

http://www.parmaja.com/pages/31
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: bambamns on April 12, 2012, 02:48:18 pm
Is there any chance to build sqlite 3.7.11 for WinCE ?

Thank You
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: Zaher on April 12, 2012, 09:54:27 pm
Check
http://www.parmaja.com/downloads/sqlite3/

Oh, 11, there has been new version recently!, I will try to build it soon.

Check also
http://www.parmaja.com/pages/31
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: Zaher on April 12, 2012, 10:26:59 pm
New file uploaded, I have not tested it, please download and test.
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: bambamns on April 14, 2012, 06:26:23 am
A lot of thanks - I'll try it.
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: bambamns on May 21, 2012, 12:09:01 am
Hi Zaher,

I'd tested latest build (3.7.11) you make and it is working ok - thx, again.

Is there any chance to build sqlite 3.7.12 for WinCE ?

Thank You
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: Zaher on May 21, 2012, 04:25:29 pm
Sure :)

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

Test it please.

Title: Re: Build of SQLite3 for WINCE ARM4
Post by: Zaher on May 23, 2012, 08:00:07 pm
I also uploaded new file sqlite3.7.12.1-arm-wince.zip check it.
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: bambamns on May 27, 2012, 02:41:07 pm
Thank you a lot - keep good work.
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: bambamns on June 23, 2012, 02:06:19 am
Hi Zaher,

I'm using latest build you posted 3.7.12.1 and it is working ok.

Is there any chance to build latest sqlite 3.7.13 for WinCE ?

Thank You
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: Zaher on June 23, 2012, 10:01:16 am
Done, please test it.

Quote from: bambamns
I'm using latest build you posted 3.7.12.1 and it is working ok.
Good to hear that  :D, because i my customers not upgraded yet, so i cant test it, i will do that soon.

sqlite3.7.13-arm-wince.zip (http://www.parmaja.com/downloads/sqlite3/)
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: bambamns on October 13, 2012, 07:59:17 pm
Hi Zaher,

You can guess  ;)

Can you upload a 3.7.14.1 version ?

Thank you
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: Zaher on October 18, 2012, 08:50:50 pm
Yep, but i have some troubles to connect my PC to the internet this days, you can wait ;-)
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: Zaher on November 09, 2012, 07:07:20 pm
Please test the new version in the same download directory, have fun :)
http://www.parmaja.com/downloads/sqlite3/
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: bambamns on November 10, 2012, 08:05:53 am
Thank you Zaher,

I've already put it on test on few devices and it working just fine.

Keep good work.
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: bambamns 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
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: Zaher on January 27, 2013, 05:00:12 pm
Why not :D

Try it
http://www.parmaja.com/downloads/sqlite3/
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: bambamns on April 12, 2013, 11:35:58 am
Thx for latest build SQLite (3.7.16.1).
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: bambamns on April 12, 2013, 07:16:27 pm
I have problems using 3.7.16.1 - did you tried ?
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: Zaher on April 12, 2013, 08:51:01 pm
no yet, what problems?
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: Zaher 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.
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: bambamns 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.
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: Zaher 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.
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: bambamns 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).
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: bambamns on July 05, 2013, 09:49:34 pm
Zaher,

Any chance to compile new 3.7.17 version ?

Thank you
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: Zaher on July 05, 2013, 09:57:06 pm
Yes, check it here
http://sourceforge.net/projects/minilib/files/miniSQLViewer/
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: bambamns 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

Title: Re: Build of SQLite3 for WINCE ARM4
Post by: swierzbicki 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
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: Zaher 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/
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: swierzbicki 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 !!!
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: bambamns on November 12, 2013, 05:28:33 am
Zaher,

Any chance to compile new 3.8.1 version ?

Thank you
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: Zaher on November 12, 2013, 09:37:51 am
Done :)
http://sourceforge.net/projects/minilib/files/miniSQLViewer/

But without testing, it is your responsibility.
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: swierzbicki on November 12, 2013, 06:32:16 pm
Thank you !
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: bambamns on November 17, 2013, 07:15:08 am
Hi,

My testing shows that every version since 3.7.16.1 have problem with TDataSet.Edit and TDataSet.Locate - latest test with 3.8.1 shows that it have it, too.

Version 3.7.15.2 and priors does not have this issue.

Any clue ?
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: Zaher on November 17, 2013, 07:55:00 am
Is the problem exists in win32 too, please try it, if yes i think it is bug in Lazarus, if not send me an example to reproduce it.
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: bambamns on November 19, 2013, 12:48:59 am
Zaher,

Problem is not in Lazarus win32 applications (I test it), it is only present in wince applications and it is with TCustomBufDataSet.Locate (eg. SQLQuery1.Locate).
If you have any database with few thousand records try to do locate specific record with any new sqlite dll (any from 3.7.16.1) - it just don't work - it works with small amount of records.
If you try with 3.7.15.2 or any older version, locate works with any number of records.


Problem is that until version 3.7.15.2 SQLQuery works without update sql query, but new version need it.
I changed it and now it works.
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: Zaher on November 19, 2013, 03:00:12 pm
Not understand? Please give us more explain for who have the same problem (who find this topic by search).

Thanks :)
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: bambamns on November 22, 2013, 05:29:56 am
OK,

If you use  TSQLQuery on WinCE with Edit and Post to update data with SQLite dll versions older then 3.7.16.1 , you can use them without writing an TSQLQuery.UpdateSQL.Text property.

If you wont to use on WinCE newer SQLite dll versions since 3.7.16.1 you have to write TSQLquery.Update.Text property.

It is interesting that TSQLQuery.Insert.Text still can remain empty and TSQLQuery with Insert and Post works with no problem.
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: Zaher on November 22, 2013, 04:30:25 pm
That is strange, i am not used TSQLQuery, I tho you need to fill al UPdate and Insert to get work, it may have a bug in SQLQuery, would you ask Lazaurs/fpc developers.
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: bambamns on November 23, 2013, 03:55:43 am
I'll report bug.
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: bambamns on April 09, 2014, 07:32:46 pm
Zaher,

Any chance to compile new 3.8.4.3 version ?

Thank you
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: Zaher on April 09, 2014, 07:44:27 pm
Yes, and Done, please test it :)
Version 3.8.4.3
https://sourceforge.net/projects/minilib/files/miniSQLViewer/
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: bambamns on April 09, 2014, 08:05:43 pm
Zaher,

WOW - this was very fast.

Could you , please explain difference in versions :
sqlite3.8.4.3-arm4i-ts.dll
sqlite3.8.4.3-arm4-ts.dll

Thx
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: Zaher on April 09, 2014, 08:31:19 pm
Your welcome :)

For Arm4i

https://groups.google.com/forum/#!topic/microsoft.public.windowsce.platbuilder/RZP49NmlRmo
http://www.parmaja.com/pages/31
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: swierzbicki on March 12, 2015, 07:19:49 am
Hello Zaher,

Do you plan to update your SQlite wince library ?
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: vincococka on March 12, 2015, 10:40:25 am
Hi,

@swierzbicki: if you want you can use my version that I`m building occasionaly.. in case of special requirements I can compile special edition for you :D (e.g. if U need thread safety, some specific IFDEFs during compile time etc).

Please see: http://itm8.sk/sqlite3ce/
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: Zaher on March 15, 2015, 09:41:27 pm
Oh yes, I will do it, tomorrow.
Title: Re: Build of SQLite3 for WINCE ARM4
Post by: Zaher on March 15, 2015, 11:08:56 pm
check it, and confirm if it is work fine, because i have not tested it.
https://sourceforge.net/projects/minilib/files/miniSQLViewer/