For those interested...
Using the emulators:
- Android 1.5 (Cupcake): 3.5.9
- Android 1.6 (Donut): 3.5.9
- Android 2.1 (Eclair): 3.5.9
- Android 2.2 (Froyo): 3.6.22
- Android 2.3 (Gingerbread): 3.6.22
- Android 3.0 (Honeycomb): 3.7.4
--
You received this message because you
Is there any way to (programmatically) check what version of SQLite is
installed?
On Jun 24, 1:09 pm, Mark Carter mjc1...@googlemail.com wrote:
Hmmm - this is a bit worrying, isn't it? How to possibly test SQL which can
potentially run so differently on different devices?
One starting point
Think I have found one ... will upload a test app (if it works) later
this afternoon and post here when it is available.
--
Richard
On Jul 11, 9:21 am, Mark Carter mjc1...@googlemail.com wrote:
Is there any way to (programmatically) check what version of SQLite is
installed?
On Jun 24, 1:09
I have written a quick and dirty test program (see below) and tested
it using different build options against 4 different emulator
versions.
The tests were repeated building different build options of the same
program:
build 1
android:minSdkVersion=3
android:targetSdkVersion=4
build
Thanks very much Richard - very useful!
Worth checking out: http://www.sqlite.org/changes.html to see what problems
the version differences could cause.
On 11 July 2010 15:34, RichardC richard.crit...@googlemail.com wrote:
I have written a quick and dirty test program (see below) and tested
Thanks for the tip Richard.
I added SQLite version display in the two apps:
)s) Internals for Android 1.5+
)s) Internals for Android 1.6+
They show SQLite 3.6.22 on my 2.2 N1.
The info is about 1/4 down the text view.
Btw, I also tried to select sqlite_source_id() but this returned an
That function is only in SQLite 3.6.18+ (see link in my last comment), so
will only work on 2.2+.
On 11 July 2010 18:31, sm1 sergemas...@gmail.com wrote:
Thanks for the tip Richard.
I added SQLite version display in the two apps:
)s) Internals for Android 1.5+
)s) Internals for Android
got it. Thanks Mark.
On Jul 11, 12:38 pm, Mark Carter mjc1...@googlemail.com wrote:
That function is only in SQLite 3.6.18+ (see link in my last comment), so
will only work on 2.2+.
On 11 July 2010 18:31, sm1 sergemas...@gmail.com wrote:
Thanks for the tip Richard.
I added SQLite
)s) Internals for Android 1.6+ version 2010.7.11b will now also
display the source_id when running on android v. 2.2+.
On my N1, it showed 2010-03-22 followed by a time and a long generated
unique id.
serge
On Jul 11, 1:44 pm, sm1 sergemas...@gmail.com wrote:
got it. Thanks Mark.
On Jul 11,
I also moved the SQLite info upward a little in the text view for the
1.6+ app. It is now between sections Settings.Secure and
Configuration. This is at about 1/6 of the view.
On Jul 11, 2:28 pm, sm1 sergemas...@gmail.com wrote:
)s) Internals for Android 1.6+ version 2010.7.11b will now also
Would be great if you had some kind of menu/index/jump-to-system to make the
different sections easily locatable!
On 11 July 2010 20:36, sm1 sergemas...@gmail.com wrote:
I also moved the SQLite info upward a little in the text view for the
1.6+ app. It is now between sections Settings.Secure
Maybe full SQL would give more clue...
Tom
On 24 čvn, 10:13, Mark Carter mjc1...@googlemail.com wrote:
Same data, same code, but different results on these two devices.
On the Nexus One, the (INNER JOIN) query runs (first call to
Cursor.moveToNext()) after a fraction of a second but on the
True - though the SQL is a little complex and I'd like to simplify it before
posting.
However, whatever the SQL is, there has to be an explanation for the
different outcome.
2010/6/24 Tomáš Hubálek tom.huba...@gmail.com
Maybe full SQL would give more clue...
Tom
On 24 čvn, 10:13, Mark
SQL Lite is definitely simpler but in Oracle it sometimes happens that the
same SQL has very different performance on different versions because of
different explain plan.
Tom
On Thu, Jun 24, 2010 at 12:48 PM, Mark Carter mjc1...@googlemail.comwrote:
True - though the SQL is a little complex
Hmmm - this is a bit worrying, isn't it? How to possibly test SQL which can
potentially run so differently on different devices?
One starting point would be get a list of SQLite version numbers on each
device available...
2010/6/24 Tomáš Hubálek tom.huba...@gmail.com
SQL Lite is definitely
15 matches
Mail list logo