Termdbms – A TUI for viewing and editing database files

[dang]

Related:

termdbms: A TUI for viewing and editing database files - https://news.ycombinator.com/item?id=28423075 - Sept 2021 (1 comment)

SQLite-TUI: A TUI for viewing SQLite databases, written in Go - https://news.ycombinator.com/item?id=28408682 - Sept 2021 (42 comments)

[radarsat1]

Nice, a tool like this might actually get my team to finally move from csv to sqlite. I was thinking parquet or feather might be interesting alternatives to csv for us though, any plans to add support?

[atoav]

If you need a GUI version consider checking out sqlitebrowser as well: https://sqlitebrowser.org/

[wormius]

Similarities/differences with this? https://www.visidata.org/

[alberth]

MIT vs GPL3 license.

Some companies prohibit GPL3 touching their environment at all.

[eikenberry]

Maybe the ease of installing it... downloading a single binary vs. Python's mess.

[pdimitar]

Seems unmaintained.

Also visidata and sc-im do a better job with configuring the view. I used all 3 programs.

I like termdbms but the author seems to not have the bandwidth for it.

[mfarstad]

How right you are lol.

I'm the author. I do embedded C and other stuff heavily now that doesn't use SQLite in any way. Was able to write the thing in the first place because we used SQLite everywhere so it made my job easier.

I'm way better at Golang now too so I would really like to do a better job with the project but yeah, no bandwidth.

[nixpulvis]

Looks like it might benefit from having dynamic column widths determined by the content. Lots of wasted space in the IDs.

[mfarstad]

Yup I remember that was a bit annoying and tricky. I had a partial fix but there were edge cases that threw me off so I opted to just save something like that for whenever I do a full rewrite.

[abdusco]

Can you navigate between tables using foreign keys?

[mfarstad]

Nope. Very non-relational. Think of it as a way to easily view and traverse a table - maybe you need to edit a single cell or something quick.

[sroussey]

Would be nice to be able to install via brew.

[mfarstad]

Don't use a Mac, but would add to readme if someone had the wherewithal

https://github.com/mathaou/termdbms/issues/8

[vfclists]

Can we stop this nonsense and bring back dBase, Paradox and Clarion?

[mmgutz]

FoxPro for me :)