cloudbeaver
pev2
cloudbeaver | pev2 | |
---|---|---|
10 | 40 | |
3,075 | 2,368 | |
2.0% | 2.2% | |
9.8 | 7.9 | |
5 days ago | 16 days ago | |
TypeScript | TypeScript | |
Apache License 2.0 | PostgreSQL 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.
pev2
-
Retrieving the latest row per group from PostgreSQL
This runs in about 250ms. Let's have a look at the explain plan to understand it better. To visualise it, I am using the excellent visualisation tool from Dalibo.
-
Pg_hint_plan: Force PostgreSQL to execute query plans how you want
The PEV2 is open source and give you a good visualization. I never used this pgmustard to compare.
https://explain.dalibo.com/
-
Efficient Database Queries in Rails: A Practical Approach
Visualize Your Plan: Visit explain.dalibo.com and paste the generated plan text and query. Then, hit Submit. The tool will generate a visualization of your query plan. Here's an example of the visualization for the fifth attempt version of the query from this post. It shows the different types of scans that were used and how the data gets combined. The duration of each operation is also shown:
-
What's new in the Postgres 16 query planner (a.k.a. optimizer)
You can download the whole analyzer as a simple html file and use it this way. No need to obfuscate or sanitize anything at all.
https://github.com/dalibo/pev2
- Visualizing and understanding PostgreSQL EXPLAIN plans made easy
- Don't use DISTINCT as a "join-fixer"
-
When should you use the IN instead of the OR operator in Postgres queries?
You might be interested in sites like https://explain.dalibo.com/ which make the output a bit nicer to read. I use these quite often to quickly identify bottlenecks.
-
200 Web-Based, Must-Try Web Design and Development Tools
PostgreSQL Query Plan Analyzer and Visualizer
-
Do you use pgAdmin? Why?
I didn’t know about pev2, interesting, checking it now. Did you integrate the component yourself or are you using this hosted page by them: https://explain.dalibo.com/?
-
Tuning DB
IMO it‘s important to get started with indexing. Grab your most frequently used queries and run an EXPLAIN ANALYZE to identify the problems. This tool might help you to understand your execution plans. Once you identified your problems, you can build indexes and check again. Then you should regularly check if your indexes are used.
What are some alternatives?
Adminer - Database management in a single PHP file
TypeORM - ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
beekeeper-studio - Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
awesome-db-tools - Everything that makes working with databases easier
phpMyAdmin - A web interface for MySQL and MariaDB
hypopg - Hypothetical Indexes for PostgreSQL
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.
pev - Postgres Explain Visualizer
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.
sysbench - Scriptable database and system performance benchmark
node-starter-kit - Node.js / GraphQL project template pre-configured with TypeScript, PostgreSQL, login flow, transactional emails, unit tests, CI/CD workflow.
yugabyte-db - YugabyteDB - the cloud native distributed SQL database for mission-critical applications.