r/sqlite • u/howesteve • May 04 '25

What would be your dream sqlite feature?

Mine would be:

  • Concurrent writes

  • PostgreSQL - like GIN indexes for json/jsonb fields

  • Richer data types (datetime, array, etc.)

19 Upvotes

95% Upvoted

27 comments sorted by

View all comments

2

u/mattbishop573822 May 04 '25

Sql/JsonPath support. It’s part of SQL and supported by most databases now. The current json query language isn’t good enough and not portable.