- Connections per project in .jumphp/databases.json (never a password: kept in ~/.jumphp/ide-db-secrets.json 0600 when asked, else asked), found in one click from .env DATABASE_URL, Laravel DB_*, Docker Compose services and the JumPHP web site. - Tree: databases > tables / views / routines > columns, indexes, foreign keys. - SQL consoles (.jumphp/consoles, out of git) in the editor: Ctrl+Enter runs the selection or the statement under the cursor, completion from the live schema, explain, history; any .sql file can be attached to a connection. - SQL Results: pages, sort, filter, export CSV / JSON / SQL; a table's rows edited in place, UPDATE / DELETE / INSERT shown then run in one transaction; structure. - SSH tunnels through the SSH window's servers (jump hosts included). - Production connections: red bars, and the PHP side refuses any write without the confirmation the dialog asks. - jumphpsql's pure-PHP MySQL protocol copied into ide/src/Database/Mysql (only the namespace changed), polled by the IDE's frame: never blocks. - Tests: DatabaseTest (config, detection, statements, guard, edits, SQLite) and DatabaseMariadbTest (throwaway mariadb:11.4); games/ide/tools/ui-db-check.sh. Co-Authored-By: Claude Opus 5.5 <[email protected]> Claude-Session: https://claude.ai/code/session_01JkYTqsvYu6AYr9yQ3Q4Nt6
7 lines
298 B
Text
7 lines
298 B
Text
parameters:
|
|
level: 5
|
|
paths: [src]
|
|
ignoreErrors:
|
|
# jumphpsql's protocol, copied as it is (docs/ide.md, Database): its wait() loop for scripts re-checks a promise settled by poll()
|
|
- identifier: booleanNot.alwaysTrue
|
|
path: src/Database/Mysql/MysqlConnection.php
|