microsoft / microsoft/semantic-kernel

.Net MEVD: Support array fields in SQLite

Open
#10,343 2 comments 0 reactions 1 assignee View on GitHub

@westey-m is already working on this.

Since Jan 30, 2025.

.NET sk team issue stale
Dominant language
C#
Stars
28.6k
Forks
4.8k
Avg merge
14h 13m
Merged PRs (30d)
18

Description

Most NEVM providers support array fields, including filtering on whether they contain something (e.g. r => r.Keywords.Contains("foo")). However, SQLite does not support this; it could be made to work by leveraging SQLite's JSON capabilities, storing a JSON list as a string and using json_each (docs) - this is what EF does.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.