1. Beatrix Willius
  2. as SQLite DB Server
  3. Tuesday, July 26 2016, 10:47 AM
  4.  Subscribe via email
Hi,

is there any documentation on the features of the SQLite Server? Can it do Unicode and FTS?

Mit freundlichen Grüßen/Regards

Beatrix Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals
Comment
There are no comments made yet.
Ruslan Zasukhin Accepted Answer
Hi Beatrix,

Valentina SQLite Server support 100% Xojo API to work with Local SQLite DB.
Totally 100% including binding.

So Unicode - yes.

Guys say FTS also yes.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 1
Ruslan Zasukhin Accepted Answer
First article to read about
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 2
Sergey Pashkov Accepted Answer
Following options are used to compile SQLite engine for Server/Local access,
it can be checked with 'PRAGMA compile_options' query:
ENABLE_COLUMN_METADATA
ENABLE_FTS3
ENABLE_FTS4
ENABLE_ICU
ENABLE_JSON1
ENABLE_RTREE
ENABLE_STAT4
OMIT_TRACE
SOUNDEX
SYSTEM_MALLOC
THREADSAFE=1
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 3
Beatrix Willius Accepted Answer
Thanks for the info!

Is there anything that I need to install? I'm getting "Can't find a type with this name" in the SQLite example at the line

app.db = new VSqliteDataBase

Mit freundlichen Grüßen/Regards

Beatrix Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 4
Sergey Pashkov Accepted Answer
Looks like V4RB 6.5.8 is partially broken on OS X - some classes are missing.
6.5.9 will be available in the nearest time.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 5
Beatrix Willius Accepted Answer
;) Looking forward to the next release.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 6
Sergey Pashkov Accepted Answer
It has just been uploaded.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 7
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories