cloudbeaver
litexplore
cloudbeaver | litexplore | |
---|---|---|
10 | 2 | |
3,075 | 38 | |
2.0% | - | |
9.8 | 4.4 | |
4 days ago | almost 2 years ago | |
TypeScript | JavaScript | |
Apache License 2.0 | 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.
cloudbeaver
- Do you use pgAdmin? Why?
- looking for modern alternative to phpmyadmin?
-
WAL Mode in LiteFS
Hi, author of litexplore here!
I agree remote management is the "least convenient" aspect of SQLite. If you have control over the remote VM where the DB is hosted, you can also run something like ClouDBeaver[0], Datasette[1] or sqlite-web[2] as a Docker container, then connect to it from your laptop.
The reason I wrote litexplore was that those approaches require exposing extra ports, managing authentication, etc. With litexplore, you just need the sqlite3 CLI (compiled with the JSON1 extension) installed in the VM and a way to access it over SSH.
litexplore is still in early stages and I have some updates planned in the following 2 months, but the basics are working.
[0]: https://github.com/dbeaver/cloudbeaver
-
webgui for mariadb, postgresql and sqlite databases?
CloudBeaver
-
Top 5 MySQL GUI tools in 2021
CloudBeaver's integrated schema diagrams\ Released around the same time as Beekeeper Studio, CloudBeaver is a smaller, open-source project supported by a stable of thirteen contributors. Because of this, development schedules are a little more deliberate, but that hasn't stopped CloudBeaver from fine-tuning its lightweight, user-friendly GUI. The interface is clean and has both dark and light modes. CloudBeaver also presents users with informative visualizations, keeping you engaged and organized as databases scale. Being a web application, this tool is accessible to a larger subset of users without consuming too many resources or disk space.
-
CloudBeaver – Database Management from Browser
Yes, this is from the same group https://github.com/dbeaver/cloudbeaver
-
CloudBeaver - A Self hosted Database Browser
Now, if only they would stop trying to be cute and give their releases actual version names instead of castor and pollux. There's also a version 20.0.6, but the latest release on GitHub is 1.2.0, but the changelog in the README says 20.0.6 is the latest.
litexplore
-
WAL Mode in LiteFS
Currently, you need to SSH in and use the sqlite3 CLI on the server. There has been some work in this area but it's all still rough around the edges. I wrote a server called Postlite[1] that exposes remote SQLite databases over the Postgres wire protocol but it's very alpha. :)
I'd love to see more work in this area. Ricardo Ander-Egg wrote a remote management tool called litexplore[2] that connects over SSH to the SQLite CLI behind the scenes. I haven't used it but I think there's a lot of potential with that approach.
[1]: https://github.com/benbjohnson/postlite
[2]: https://github.com/litements/litexplore
-
Show HN: Explore remote SQLite databases over SSH
Hi! As a big fan of SQLite, I always found the tooling to explore remote databases a bit lacking. Current solutions involve running an extra service in the remote host and exposing a port to access it. I built a small web app that can explore remote SQLite databases without having to run any service on the remote, you just need SSH.
It works by sending sqlite3 CLI commands over a multiplexed SSH connection. The commands use the "-json" flag from the sqlite3 CLI. This basically turns the SSH connection into an JSON API for the remote SQLite database. The project is hosted on GitHub[0] and I wrote a blog post with more details about the project and how it works[1].
I'm still exploring multiple ideas and implementations details, but feedback is more than welcome.
[0]: https://ricardoanderegg.com/posts/sqlite-remote-explorer-gui/
[1]: https://github.com/litements/litexplore
What are some alternatives?
Adminer - Database management in a single PHP file
sqlite-web - Web-based SQLite database browser written in Python
beekeeper-studio - Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
pocketbase-framework-litestr
phpMyAdmin - A web interface for MySQL and MariaDB
sqlite-zstd - Transparent dictionary-based row-level compression for SQLite
mysql-workbench - MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more.
pocketbase-framework-litestream - A small example using PocketBase as a Go Framework with replication/restoration of SQLite DB with Litestream
crisp-bigquery - Starter project with full stack BigQuery. Allows to overcome customisation restrictions imposed by pre-built dashboards and control data usage. Deploy your own cloud website hydrated by sample BigQuery data in 15 min without installing any development software.
datasette - An open source multi-tool for exploring and publishing data
node-starter-kit - Node.js / GraphQL project template pre-configured with TypeScript, PostgreSQL, login flow, transactional emails, unit tests, CI/CD workflow.
litefs - FUSE-based file system for replicating SQLite databases across a cluster of machines