# DETS Editor - looking for something similar to DB Browser for SQLite

**URL:** <https://erlangforums.com/t/dets-editor-looking-for-something-similar-to-db-browser-for-sqlite/1484>\
**Category:** Questions / Help\
**Tags:** erlang, beginner, dets\
**Created:** [May 26, 2022, 2:33pm UTC](https://erlangforums.com/t/dets-editor-looking-for-something-similar-to-db-browser-for-sqlite/1484 "2022-05-26T14:33:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ookma-Kyi](https://erlangforums.com/user_avatar/erlangforums.com/ookma-kyi/32/1207_2.png) [@Ookma-Kyi](https://erlangforums.com/u/Ookma-Kyi)\
**Post date:** [May 26, 2022, 2:33pm UTC](https://erlangforums.com/t/dets-editor-looking-for-something-similar-to-db-browser-for-sqlite/1484/1 "2022-05-26T14:33:50Z")

</div>

Hello,

Does anyone know if there is a DETS editor to edit DETS data files? I am looking for something similar to [DB Browser for SQLite](https://sqlitebrowser.org).

Thanks

---

<div class="post-metadata">

**Author:** ![Ookma-Kyi](https://erlangforums.com/user_avatar/erlangforums.com/ookma-kyi/32/1207_2.png) [@Ookma-Kyi](https://erlangforums.com/u/Ookma-Kyi)\
**Post date:** [May 31, 2022, 5:36am UTC](https://erlangforums.com/t/dets-editor-looking-for-something-similar-to-db-browser-for-sqlite/1484/2 "2022-05-31T05:36:17Z")

</div>

Hi,

It’s been a week since I’ve posted this and am still interested in getting a response. As of now the only thing I could come up with is building an administration panel that allows you to view and edit the records. The problem with that is it would be custom to the application and I was hoping for a universal solution.

---

<div class="post-metadata">

**Author:** ![sg2342](https://erlangforums.com/user_avatar/erlangforums.com/sg2342/32/1233_2.png) [@sg2342](https://erlangforums.com/u/sg2342)\
**Post date:** [June 1, 2022, 8:49am UTC](https://erlangforums.com/t/dets-editor-looking-for-something-similar-to-db-browser-for-sqlite/1484/3 "2022-06-01T08:49:07Z")

</div>

[The Table Viewer Tab in Observer](https://www.erlang.org/doc/apps/observer/observer_ug.html#table-viewer-tab) allows you to view and edit (if the table access is `public`) ETS tables. It does not allow insertion.

The obvious difference to an SQLite Browsers is that ETS (and DETS) tables do not have meta-information (besides `keypos` and `type`) and one is left to editing tuples. Where a SQLite table has a fixed number of columns and these columns have types.

So while it is very easy to make a DETS editor (just take the code from `observer_tv*` and use `dets:to_ets/2` and `dets_from:ets/2`), its usefulness is IMHO very limited.