SQLite-TUI: A TUI for viewing SQLite databases, written in Go

by gjvc • 5 years ago

180 42 5 years ago

mathaou14• 5 years ago

Hey thanks for posting this! This is my project I started and the goal is to have it be an eventually database agnostic terminal spreadsheet kind of program. Lots planned for the future!

throwawaybutwhy• 5 years ago

Please add instructions on how to build it. Looking forward to trying it out!

mathaou14• 5 years ago

I absolutely will as soon as I can! I just started it two days ago and was kind of blown away by the response, so the readme definitely didn't get a lot of attention.

I'll remedy that!

GrayShade2• 5 years ago

Cloning to `~/go` and running `go build` worked for me. But I can never remember how to build Go projects, so adding more details in the README would be nice.

unixsheikh• 5 years ago

Very well done! Great project!

faizshah• 5 years ago

Really cool, I’m a big user of SQLite. Reminds me of visidata but for SQLite: https://github.com/saulpw/visidata

antattack• 5 years ago

Visidata can view SQLite too: https://www.visidata.org/docs/formats/

Crontab• 5 years ago

Very nice!

mathaou14• 5 years ago

Thank you!

thristian• 5 years ago

NOTE: Mouse controls don't work for remote sessions like serial or SSH.

That's weird. I'm having a hard time imagining how it would be possible to break mouse controls over SSH, since the escape sequences used to signal mouse events are transport-agnostic.

enduku• 5 years ago

Me too. Maybe it is the latency that affected this decision. If the cause for ignoring mouse events is latency, Mosh may be a bit better.

https://mosh.org/

mathaou14• 5 years ago

I haven't looked into that one too much, I'll thoroughly test it soon.

For whatever reason I only tested Windows ssh, since it's what I use for work. I'll test Linux soon.

GrayShade2• 5 years ago

I just tested it. Mouse works in Linux over SSH, but I'm not really sure how to use the app otherwise (:.

And yeah, it crashes on larger databases:

  panic: runtime error: slice bounds out of range [:-1]                                                                                                                                                                                                                                                                                                                                                                             
  
  goroutine 54 [running]:
  sqlite3-viewer/viewer.TruncateIfApplicable(0xc02037ef70, {0xc000126038, 0x7})
   ~/go/tuitty/viewer/util.go:99 +0x192
  sqlite3-viewer/viewer.TuiModel.View.func2(0xc000818f60)
   ~/go/tuitty/viewer/viewer.go:121 +0xae5
  created by sqlite3-viewer/viewer.TuiModel.View
   ~/go/tuitty/viewer/viewer.go:106 +0x272

Aeolun2• 5 years ago

Large databases are thousands of rows? My small database already has a few tens of thousands.

Who considers a few thousand rows large?

hanche• 5 years ago

One person’s small is another person’s large. It all comes down to your typical use cases; no surprise there. I have lots of tiny sqlite databases myself, so for me, a few tens of thousands rows is large. But at least I am well aware that multi-gigabyte sqlite databases can and do exist.

mathaou14• 5 years ago

Optimizations like that will be part of the next alpha release after the one I'm working on.

Aeolun2• 5 years ago

I just honestly cannot imagine how it could start to be slow at a few thousand rows. Calling it an optimization feels wrong somehow.

Glad you hear you are planning to look at it though :)

zerr• 5 years ago

For SQLite seems reasonable? I remember it advertised as ini file replacement as well :)

laumars3• 5 years ago

Sqlite easily manages millions of rows. I’ve used it in the past as part of a lazier implementation of an ELK-like stack and it worked fine.

tanin• 5 years ago

I've built a similar project (backed by Sqlite), though it's full GUI.

At work, I work with a lot of CSVs. I often hit the limit of Excel and Google Sheets. Plus, using formula is difficult. The ergonomics around it is also not great (e.g. am I suppose to write long formula in a one-line box at the top?)

Eventually, I've decided to create Superintendent that enables me to write SQL on CSVs.

I'm working on optimizing it to be faster and faster. Currently, it can load 1GB CSV on Mac Pro 2020 within 10 seconds because it basically goes to C code.

I'm looking to make it feel more and more like a spreadsheet (e.g. click to sort, copy row, copy column, edit it directly) while giving focus to SQL writing. I'm loving it so far, but there are still a lot of improvements to be made.

If you are interested, please check it out: https://superintendent.app

trevyn• 5 years ago

Not open source? Hard pass. Welcome to 2021.

pjmlp2• 5 years ago

The supermarket down the street is now taking Git Pull Requests for grocery.

mathaou14• 5 years ago

Hey everyone! Author here. In order to better reflect my future plans for the project, I have rebranded of sorts. It is now called termdbms (suggestions on a better name welcome), because eventually I would like to become database agnostic. MySQL support is planned for the alpha 1.0 release!

mathaou14• 5 years ago

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

mathaou14• 5 years ago

You will eventually be able to run SQL queries on the database within the application. I hope to blend that with spreadsheet-like user interface so its easy to add or remove rows, columns, values, rename, etc...

photojosh• 5 years ago

a vote for Postgres here!

mathaou14• 5 years ago

Added to the list!

eeiac928• 5 years ago

mySQLite ; name suggestion

mukundesh• 5 years ago

Very nice ! Wish I could build the schema, then this would be Microsoft Access in a terminal !

mathaou14• 5 years ago

I have lots of plans including database creation. It's in its infancy now but 2-3 months from now that should be possible.

say_it_as_it_is• 5 years ago

That it was written at all is what matters. Mentioning that it was written in Go simply tells us that it's fast enough for a cli and is a single binary. Yet, many existing python utilities in this class are also fast enough and not backed by a single binary.

SQLite-TUI: A TUI for viewing SQLite databases, written in Go

Related Stories