ws4sqlite
termdbms
ws4sqlite | termdbms | |
---|---|---|
7 | 18 | |
390 | 1,628 | |
- | - | |
7.3 | 0.0 | |
2 days ago | almost 2 years ago | |
Go | Go | |
ISC License | MIT License |
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.
ws4sqlite
-
ws4sqlite v0.12.1 released - connect to sqlite via HTTP/"REST"
If you are interested, feel free to browse the git repo, read the documentation (with a tutorial) or connect to the discord channel.
-
Ask HN: Have you used SQLite as a primary database?
I am using sqlite where a simple persistence layer is needed, both as the sole in the project or along with a full-fledged database. There are many such projects, once you realize that a database is just an abstraction; for example, for caching in a larger project, or to store results for a subsection of the project. But of course also for smaller, standalone projects.
Also, take a look at ws4sqlite (https://germ.gitbook.io/ws4sqlite/) for a middle ground between SQLite (embedded) and rqlite/dqlite: it's "normal" sqlite addressable via web services. May be useful in some scenarios.
-
Hacker News top posts: Mar 11, 2022
Ws4sqlite: Query SQLite via HTTP\ (30 comments)
- Ws4sqlite: Query SQLite via HTTP
-
A remote JSON interface for SQLite, in Go
ws4sqlite is a web service layer on one (or more) SQLite databases. It’s written in Go, over mattn's go-sqlite3, and allows to use HTTP POST requests to submit SQL statements to a database, in a transaction. It can “serve” multiple databases at once, supports authentication, “stored queries”, in-memory databases, maintenance (vacuum/backups), batching and several other security features and configurations.
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
What are some alternatives?
tuql - Automatically create a GraphQL server from a SQLite database or a SQL file
sqlite-tui - A TUI for viewing and editing database files. [Moved to: https://github.com/mathaou/termdbms]
dashera - DasherA is a Data General DASHER D200/D210 terminal emulator
vim-dadbod - dadbod.vim: Modern database interface for Vim
Sqinn-Go - Golang SQLite without cgo
catcli - The command line catalog tool for your offline data
sqlite-s3-query - Python functions to query SQLite files stored on S3
vim-dadbod-ui - Simple UI for https://github.com/tpope/vim-dadbod
barrier - Open-source KVM software
gobang - A cross-platform TUI database management tool written in Rust
sqlite3vfshttp - Go sqlite3 http vfs: query sqlite databases over http with range headers
vatcomply - VATcomply is a free API service for vat number validation, user ip geolocation and foreign exchange rates.