Recent

Author Topic: SQLite3 + encryption for WinCE (arm4i)  (Read 24986 times)

vincococka

  • Full Member
  • ***
  • Posts: 101
Re: SQLite3 3.8.7.1 for WinCE (arm4i)
« Reply #15 on: November 10, 2014, 05:31:59 pm »
Hi,

link is in the first post... sorry for not mentioning this 8-).

But just in case:
http://www.filedropper.com/sqlite3ce_1
---
  Guide me God and I`ll find you

swierzbicki

  • Full Member
  • ***
  • Posts: 177
Re: SQLite3 3.8.7.1 for WinCE (arm4i)
« Reply #16 on: November 17, 2014, 03:57:29 pm »
Hello,

It look like the file is no more available for downloading.

Thanks
Lazarus 1.6.2
fpc 3.0.0
wince/win32/win64
delphi berlin

vincococka

  • Full Member
  • ***
  • Posts: 101
Re: SQLite3 3.8.7.1 for WinCE (arm4i)
« Reply #17 on: November 18, 2014, 03:39:10 pm »
---
  Guide me God and I`ll find you

Never

  • Sr. Member
  • ****
  • Posts: 409
  • OS:Win7 64bit / Lazarus 1.4
Re: SQLite3 3.8.7.1 for WinCE (arm4i)
« Reply #18 on: November 18, 2014, 03:52:17 pm »
nod32 reported a virus
« Last Edit: November 18, 2014, 03:57:20 pm by Never »
Νέπε Λάζαρε λάγγεψων οξωκά ο φίλοσ'ς αραεύσε

vincococka

  • Full Member
  • ***
  • Posts: 101
Re: SQLite3 3.8.7.1 for WinCE (arm4i)
« Reply #19 on: November 18, 2014, 03:56:52 pm »
sorry for that but seems to be false positive, please check MD5 checksum (made with total commander 8.01):
9afaf80f4f805aecc6d733bb77b8a0c0 *sqlite3ce.dll

Just another mirror:
sqlite3ce.dll
---
  Guide me God and I`ll find you

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: SQLite3 3.8.7.1 for WinCE (arm4i)
« Reply #20 on: November 18, 2014, 03:59:10 pm »
nod32 reported a virus
FYI: you can use e.g. http://virusscan.jotti.org/en to let multiple virus scanners scan for viruses. Often you do see false positives for some scanners...
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

Never

  • Sr. Member
  • ****
  • Posts: 409
  • OS:Win7 64bit / Lazarus 1.4
Re: SQLite3 3.8.7.1 for WinCE (arm4i)
« Reply #21 on: November 18, 2014, 04:02:00 pm »
the second link is ok
the file is ok from the second link
but something is wrong with tinyupload

Edit***@ BigChimp
Quote
FYI: you can use e.g. http://virusscan.jotti.org/en to let multiple virus scanners scan for viruses. Often you do see false positives for some scanners...
i prefer virus@total
« Last Edit: November 18, 2014, 04:20:29 pm by Never »
Νέπε Λάζαρε λάγγεψων οξωκά ο φίλοσ'ς αραεύσε

vincococka

  • Full Member
  • ***
  • Posts: 101
Re: SQLite3 3.8.7.2 for WinCE (arm4i)
« Reply #22 on: November 28, 2014, 01:54:44 pm »
Hello,

if anybody`s interested, I`ve compiled version 3.8.7.2 for Windows CE.

Enjoy!

---
  Guide me God and I`ll find you

swierzbicki

  • Full Member
  • ***
  • Posts: 177
Re: SQLite3 3.8.7.2 for WinCE (arm4i)
« Reply #23 on: November 28, 2014, 02:27:03 pm »
Yes, am I :D
Lazarus 1.6.2
fpc 3.0.0
wince/win32/win64
delphi berlin

vincococka

  • Full Member
  • ***
  • Posts: 101
Re: SQLite3 3.8.7.2 for WinCE (arm4i)
« Reply #24 on: November 28, 2014, 03:32:06 pm »
Hi,

I`m glad that somebody finds it useful for his work, and the effort put inside was worth of it.
Keep in mind that both versions (3.8.7.1 & 3.8.7.2) were compiled with following DEFINEs:
  • UNICODE
  • NO_TCL
  • SQLITE_DEFAULT_FOREIGN_KEYS=1
  • SQLITE_DEFAULT_MMAP_SIZE=2097152
  • SQLITE_DISABLE_LFS
  • SQLITE_OMIT_TCL_VARIABLE
  • SQLITE_OMIT_TRACE
---
  Guide me God and I`ll find you

swierzbicki

  • Full Member
  • ***
  • Posts: 177
Re: SQLite3 3.8.7.2 for WinCE (arm4i)
« Reply #25 on: December 01, 2014, 10:59:18 am »
I really appreciate your efforts.
I have one question, is SQLITE compile with SQLITE_THREADSAFE=1 (1 is the default value ?)
Lazarus 1.6.2
fpc 3.0.0
wince/win32/win64
delphi berlin

vincococka

  • Full Member
  • ***
  • Posts: 101
Re: SQLite3 3.8.7.2 for WinCE (arm4i)
« Reply #26 on: December 01, 2014, 09:19:22 pm »
Hi,

only flags that I`ve mentioned in previuos post were used.
Everything else was left in its default value.

Anyway, you can test it with following library call:
  https://www.sqlite.org/c3ref/threadsafe.html
---
  Guide me God and I`ll find you

bambamns

  • Full Member
  • ***
  • Posts: 223
Re: SQLite3 3.8.7.2 for WinCE (arm4i)
« Reply #27 on: January 03, 2015, 06:39:15 am »
Hi,

As you can see this thread has been read almost 2000 times, so there are people who are interested for this.

I have tried all the link to download 3.8.7.2 but they are dead or my antivirus block access.
Lazarus 1.8.4 + FPC 2.6.4 x86 (rebuild) and Lazarus 2.0, Windows 7 x64, unless otherwise specified

vincococka

  • Full Member
  • ***
  • Posts: 101
Re: SQLite3 3.8.7.2 for WinCE (arm4i)
« Reply #28 on: January 03, 2015, 02:14:11 pm »
Hi all,

here we have new version available:
SQLite 3.8.7.4 for Windows CE : http://www.datafilehost.com/d/2ed275a9

@bambamns: thanks for replying - your post forced me to recompile new version and publish it :).
---
  Guide me God and I`ll find you

vincococka

  • Full Member
  • ***
  • Posts: 101
Re: SQLite3 3.8.8.1 for WinCE (arm4i)
« Reply #29 on: January 30, 2015, 10:53:24 am »
Hi all,

I`ve compiled version 3.8.8.1 of SQLite for WinCE... see first post with details.
Tested with emulator and Trimble Recon device (WinCE6).
---
  Guide me God and I`ll find you