Expo SQLite

[jerone]

Description

It would be nice to have access to SQLite database(s) within Developer Tools.

Particular Expo SQLite: https://docs.expo.dev/versions/latest/sdk/sqlite/

Basic features would be:

• Browse databases.
• Browse tables.
• View data.
• Edit inline data.
• Delete rows.

Advanced features:

• Drop table.
• Delete database.
• Execute queries.
• Export and import database.

Suggested solution

The latest version of expo-sqlite library (55+) includes a built-in DevTools inspector plugin that is automatically enabled in development and requires no extra setup. It lets you browse tables, view and edit rows, run SQL queries, and export databases.

An alternative solution is expo-sqlite-devtools, doing a similar job that works for Expo 54.
It does however have an issue with binary data.

Potential other solutions:

• https://www.npmjs.com/package/expo-sqlite-explorer
• https://www.npmjs.com/package/expo-drizzle-studio-plugin

Additional context

This could be a separate plugin or part of the existing Storage Plugin.

[V3RON]

SQL is a totally different story compared to key-value stores. I'll open a PR later today with a brand-new SQL plugin 🎉

[V3RON]

See #210

[jerone]

Looks awesome, but it's to big and complex for me to review.
I do see references of the features I mentioned, including binary data. 👍
Also great to see pragma with useSQLCipher, a feature I forgot to mention.
🚀

[V3RON]

@jerone I've just published this plugin in the 1.7.0-rc.0 release: https://www.npmjs.com/package/@rozenite/sqlite-plugin
Let me know if it works for you 🤞

[jerone]

@V3RON We were able to try it out today and all basic functionality seem to work. Thanks 👍