:fox_face: sqlite in the browser

[jadudm]

At a glance

In order to browse work products as a developer I want sqlite in the browser

Acceptance Criteria

We use DRY behavior-driven development wherever possible.

### then... 
- [ ] [a thing happens]

Shepherd

• UX shepherd:
• Design shepherd:
• Engineering shepherd:

Background

1. https://sqlite.org/fiddle/
2. https://github.com/coleifer/sqlite-web
3. https://chromewebstore.google.com/detail/sqlite-browser/iclckldkfemlnecocpphinnplnmijkol?hl=en
4. https://sqliteviewer.app/
5. https://sqlite.org/wasm/doc/trunk/demo-123.md
6. https://sqlime.org/
7. https://alpha.sqliteviewer.app/Northwind_small.sqlite/table/Category
8. https://github.com/nalgeon/codapi
9. https://github.com/nalgeon/sqlean.js
10. https://github.com/outerbase/studio

• (1) is simple, and if it has source, has promise
• (5) is... easy to do. However, it offers very little in the way of support
• (4) is closed-source
• (2) is a server
• (6) is SQL-only, but light
• (7) is whizzy
• (10) is also whizzy

Security Considerations

Required per CM-4.

This is a research ticket; no implementation planned at this time.

---

Process checklist

- [ ] Has a clear story statement - [ ] Can reasonably be done in a few days (otherwise, split this up!) - [ ] Shepherds have been identified - [ ] UX youexes all the things - [ ] Design designs all the things - [ ] Engineering engineers all the things - [ ] Meets acceptance criteria - [ ] Meets [QASP conditions](https://derisking-guide.18f.gov/qasp/) - [ ] Presented in a review - [ ] Includes screenshots or references to artifacts - [ ] Tagged with the sprint where it was finished - [ ] Archived ### If there's UI... - [ ] Screen reader - Listen to the experience with a screen reader extension, ensure the information presented in order - [ ] Keyboard navigation - Run through acceptance criteria with keyboard tabs, ensure it works. - [ ] Text scaling - Adjust viewport to 1280 pixels wide and zoom to 200%, ensure everything renders as expected. Document 400% zoom issues with USWDS if appropriate.

[jadudm]

This doesn't solve anything anytime soon. Going to close as not planned.