termdbms
visidata
| termdbms | visidata | |
|---|---|---|
| 18 | 37 | |
| 1,684 | 7,775 | |
| - | - | |
| 0.0 | 9.7 | |
| over 2 years ago | 5 days ago | |
| Go | Python | |
| MIT License | GNU General Public License v3.0 only |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
termdbms
-
Termdbms – A TUI for viewing and editing database files
Don't use a Mac, but would add to readme if someone had the wherewithal
https://github.com/mathaou/termdbms/issues/8
-
Why SQLite may become foundational for digital progress
https://github.com/mathaou/termdbms
Granted I'm the author, but until I get around to rewriting it from the ground up, I really think it saves a lot of time for editing single cells, querying, and viewing in a headless environment.
- mathaou/termdbms: A TUI for viewing and editing database files.
- A TUI for viewing and editing database files
- Termdbms: A TUI for viewing and editing SQLite and CSV
-
Bubble Tea: fun, functional and stateful way to build terminal apps
One of my favorite TUI frameworks. I made https://github.com/mathaou/termdbms with it. A very pleasant experience.
- Ask HN: Have you used SQLite as a primary database?
- TUI in webapp design language(CSS) and pattern(check the demo, it’s next level)
-
Ask HN: Have you created programs for only your personal use?
I made a headless sqlite dbms (not nearly as feature rich as the real thing) for my own embedded development. It can show the values of any table, view specific cells, update cells with a text editor interface, beautifies json, and takes in SQL queries as well.
Got some bugs with formatting complex lines of text, but it works well enough for me. I plan on porting to Rust one of these days.
https://github.com/mathaou/termdbms
visidata
-
Data Science at the Command Line, 2nd Edition (2021)
I'd like to call out one of my favorite pieces of software from the past 10 years: VisiData [1] has completely changed the way I do ad-hoc data processing, and is now my go-to for pretty much all use cases that I previously used spreadsheets for, and about half of those I previously used databases for.
It's a TUI application, not strictly CLI, but scriptable, and I figure anyone building pipelines using tools like jq, q, awk, grep, etc. to process tabular data will find it extremely useful.
----
[1]: https://visidata.org
-
Fx – Terminal JSON Viewer
[4] "Is it possible to "flatten" structured data (like JSON?)": https://github.com/saulpw/visidata/discussions/1605
- jq 1.7 Released
-
Mapping LA's Soft-Story Building Earthquake Retrofit Program [OC]
Visidata - https://visidata.org
-
SQLite interface(s) for creating complex queries with a table that has 68 million rows?
You can try Visidata
-
Terminal Based Programs?
VisiData is an awesome terminal spreadsheet tool. edbrowse for internet browsing.
-
Plugin for pretty rendering of data?
Have you ever tried out visidata? It's not vim, but it's a terminal app with vim-like keybindings for visualizing tabular data (and it can convert from other types like json). Not quite a neovim buffer, but you could always open visidata in a new terminal buffer.
-
Ask HN: I'm looking for some new spreadsheet software what are people using?
If you are a command-line user, try visidata[0]
[0] https://github.com/saulpw/visidata
-
Hanukkah of Data: Advent of Code for Data Nerds
The datasets will be available as SQLite, JSONL, and CSV. This will be great for sharpening your SQL/Python/VisiData skills.
-
Hanukkah of Data: Advent of Code for Data Enthusiasts
Help Sarah find the family holiday tapestry before her father notices it's missing! Sharpen your SQL/Python/VisiData skills with Hanukkah of Data.
What are some alternatives?
sqlite-tui - A TUI for viewing and editing database files. [Moved to: https://github.com/mathaou/termdbms]
sc-im - sc-im - Spreadsheet Calculator Improvised -- An ncurses spreadsheet program for terminal
vim-dadbod - dadbod.vim: Modern database interface for Vim
miller - Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON
catcli - The command line catalog tool for your offline data
gobang - A cross-platform TUI database management tool written in Rust
tidy-viewer - 📺(tv) Tidy Viewer is a cross-platform CLI csv pretty printer that uses column styling to maximize viewer enjoyment.
vim-dadbod-ui - Simple UI for https://github.com/tpope/vim-dadbod
OpenRefine - OpenRefine is a free, open source power tool for working with messy data and improving it
vatcomply - VATcomply is a free API service for vat number validation, user ip geolocation and foreign exchange rates.
hledger - Robust, fast, intuitive plain text accounting tool with CLI, TUI and web interfaces.