termdbms
sqlitestudio
Our great sponsors
| termdbms | sqlitestudio | |
|---|---|---|
| 16 | 35 | |
| 1,234 | 3,345 | |
| - | - | |
| 2.8 | 6.6 | |
| 9 months ago | about 2 months ago | |
| Go | C | |
| MIT License | GNU General Public License v3.0 or later |
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
-
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.
-
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.
-
Terminal cataloging/database application
Ok I thought some programming could be done. Clipper is very very high level, so extremely easy to use! What about this then? Still very low level tough!
- Gobang – Cross-platform TUI database management tool written in Rust
- SQLite-TUI: A TUI for viewing SQLite databases, written in Go
sqlitestudio
- Is there a way to update sqlite3 version within python? (windows)
- Python projects with best practices on Github?
-
No/Low Code sqlite Front End GUI/Forms
DB Browser for SQLite and SQLiteStudio both exists, not sure if this is what you are looking for.
-
Is there a way to backup the cookies and site data exceptions list?
They're database files that you can inspect with a program like DB Browser or SQLiteStudio. You should be able to import permissions.sqlite to different Firefox profiles by just copying it to the right profile directory.
-
Working with more than 10gb csv
https://sqlitestudio.pl is awesome, super easy to set up and pull in CSVs
-
SQLite has pretty limited builtin functions
SQLiteStudio (sqlitestudio.pl) is a GUI frontend (Win and Linux) that lets you define functions (such as StdDev) when needed. You might want to give that a try.
-
Sensitive data
Popular SQLite editors e.g. DB4S (supports only SQL Cipher) and SQLiteStudio (SQLCipher and perhaps anothers via plugin) can work with encrypted databases. My sqlite-gui support 5 ciphers through SQLite3 Multiple Ciphers.
-
Awesome SQLite
SQLiteStudio - Create, edit, browse SQLite databases
- Why SQLite may become foundational for digital progress
- Looking for a very simple GUI for a beginner
What are some alternatives?
sqlitebrowser - Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:
Sequel-Ace - MySQL/MariaDB database management for macOS
beekeeper-studio - Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
sqlite-tui - A TUI for viewing and editing database files. [Moved to: https://github.com/mathaou/termdbms]
sqlite-gui - Lightweight SQLite editor for Windows
dbgate - Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application
vim-dadbod - dadbod.vim: Modern database interface for Vim
sqlite - A simple sqlite3 library for Haskell
litecli - CLI for SQLite Databases with auto-completion and syntax highlighting
vim-dadbod-ui - Simple UI for https://github.com/tpope/vim-dadbod
remote-software - 💎 YIO Remote Software repository
lsqlite - lua sqlite module