dotnet / dotnet/efcore

Support SQLite jsonb

Open
#34,073 9 comments 23 reactions 0 assignees View on GitHub
area-json area-sqlite customer-reported
Dominant language
C#
Stars
14.8k
Forks
3.4k
PR merge metrics
PR metrics pending

Description

SQLite version 3.45.0 (2024-01-15) introduced support for stored JSON data in its internal representation format, as a BLOB ([docs](https://www.sqlite.org/json1.html#jsonb)), similar to PG jsonb or the new SQL Azure JSON type. We should make sure to support this:

* Understand how a client encodes JSON (string) data to write it into a SQLite JSON BLOB column. Since there's no column type (like in PG, SQL Server), I'm assuming some function call converts the string data into the internal binary format. This function call would need to be integrated into our update pipeline, etc.
* Make sure we allow users to map primitive collections and JSON-mapped complex/owned entity types to BLOB.
* Include partial update support in the update pipeline
* Include partial update support in ExecuteUpdate

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.