Termdbms – A TUI for viewing and editing database files | Hacker News Reader

Termdbms – A TUI for viewing and editing database files

github.com

95 pointssieste24 comments

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)

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?

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

Use that all the time actually! But the main argument for CSV that I most often hear is "at least I can just load it into any text editor.." I figured having a pretty good TUI program might be just as good as using a text editor, but we'll see.

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

MIT vs GPL3 license.

Some companies prohibit GPL3 touching their environment at all.

Even if it’s just an installed program?

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

Pure Golang as well, so there's no CGO. Can just make a binary for whatever target Golang supports which is the bees knees.

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.

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.

That's fine man, life and work happens.

Still, your project shows up in search engines. Maybe you should consider handing it off to someone?

But I'll understand if not. Scratching our own itch and moving on, and all that. :)

I mean if anyone wants to take over feel free in a fork and I'll archive my repo.

I've seen a rust database tui that looks nuts. Was developed around the same time I made mine.

But if people still like benefits of Go then yeah honestly a rewrite from scratch might be better. Its not that hard just takes a while - query entire DB into data structure and then write serialization routines. The UI portion is just bubbletea and gum.

> I've seen a rust database tui that looks nuts. Was developed around the same time I made mine.

Which one is that?

https://github.com/TaKO8Ki/gobang

It doesn't have my favorite feature from mine which is "yo lemme just quick update this one field without writing SQL" I don't think but still pretty and powerful

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

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.

Can you navigate between tables using foreign keys?

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.

Would be nice to be able to install via brew.

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

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

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

FoxPro for me :)

Yes!! Foxpro!! I knew I had omitted something but couldn't recollect what it was.

Reply on news.ycombinator.com