What does HackerNews think of sqlite-android?

SQLite Functions for Working with JSON | Aug 2023

I've been using the JSON1 extension on Android with the Android SQLite support library [0] for a couple of years now.

According to this article, `Prior to version 3.38.0, the JSON functions were an extension that would only be included in builds if the -DSQLITE_ENABLE_JSON1 compile-time option was included.` So from the looks of it it is now compiled in by default for about 1.5 years.

Does anyone know if Android's SQLite now includes JSON1 capabilities out of the box, and if so, since which Android version?

[0] https://github.com/requery/sqlite-android

New JSON query operators in SQLite 3.38.0 | Feb 2022

Expand Context ↕

I've been using it successfully for years on Android with sqlite-android [0] and the flexibility it has given me was quite a relief. It's great to see that it is now included by default.

[0] https://github.com/requery/sqlite-android

JSON with Sqlite | Mar 2019

The JSON1 extension can be used in Android with the sqlite-android library

https://github.com/requery/sqlite-android

SQLite and Android N (2016) | Jan 2017

Kind of related: There is an outstanding request [0] on the Android issue tracker to offer an official support/compat library for Android's sqlite bindings, that would bridge Android's API (in a different java package) to a sqlite binary that you provide.

There are already implementations [1][2] of this, but because it is not provided by the Android team it is hardly supported by ORMs, libraries, etc.

[0] https://code.google.com/p/android/issues/detail?id=202658

[1] https://www.sqlite.org/android/doc/trunk/www/index.wiki

[2] https://github.com/requery/sqlite-android

When should you store serialized objects in the database? (2010) | Jun 2016

Expand Context ↕

That's with a loadable JSON1 extension, which one won't find e.g. in Android.

Though checking now for this, someone has packaged a later version of SQLite with this extension [1]. I wonder if there is any possible performance advantage when using a system provided SQLite vs. one installed with the application?

[1] https://github.com/requery/sqlite-android