Android Question SQLite Android Bindings

[mw71]

Hi

i found this:https://sqlite.org/android/
is it possible to do that with/in B4A?

- I want to use Regex with SQLite (and Case Insensivie-> GLOB works is Case Sensitive, LIKE finds too much in some cases)
- use new SQL on older Android

 

[Erel]

Should be possible if you build the required library. Not sure that it is worth the efforts.

I want to use Regex with SQLite

What is the table size?

 

[mw71]

Should be possible if you build the required library. Not sure that it is worth the efforts.

o.k., it would be (very) nice, but to "high" for me.

What is the table size?

you mean the size of the SQL Table?

it contains 11 Columns and up to 6000 Rows (in my Case, depends on user activity/work). 2 Columns contains Strings i would like search with RegEx (some special situations with special german Letters and there alternative, e.g. ß->ss,ö->oe,ä->ae....)

 

[Erel]

Create a list based on the relevant field and do it in your code. It will be not be slower than doing it in SQLite directly.