核心内容摘要
冠希实干张9分37秒：不止于数字，更是热爱与坚持的注解
前文介绍了连接GizmoSQL数据库服务器的几种方法其中最简单的就是用客户端二进制文件但是这个客户端有诸多限制不太好用所幸GizmoData还给出了GizmoSQL UI组件用它可以用web页面笔记本方式访问。
试用步骤下载GizmoSQL服务端和客户端二进制文件。
解压缩到gzm目录。
wget https://github.com/gizmodata/gizmosql/releases/download/v
1.
1
0/gizmosql_cli_linux_amd
zip下载GizmoSQL UI组件二进制文件。
解压缩到gzmui目录。
wget https://github.com/gizmodata/gizmosql-ui/releases/download/v
2.
1/gizmosql-ui-linux-x64启动服务端ls gizmosql_client gizmosql_server GIZMOSQL_PASSWORDgizmosql_password ./gizmosql_server --database-filename ./data.db --print-queries
T10:05:
3
921Z INFO pid1344 tid140088588014528 componentgizmosql_server - GizmoSQL - Copyright © 2026 GizmoData LLC Licensed under the Apache License, Version
0 https://www.apache.org/licenses/LICENSE-
0
T10:05:
3
928Z INFO pid1344 tid140088588014528 componentgizmosql_server - ----------------------------------------------
T10:05:
3
928Z INFO pid1344 tid140088588014528 componentgizmosql_server - Apache Arrow version:
21.
0
T10:05:
3
945Z INFO pid1344 tid140088588014528 componentgizmosql_server - WARNING - TLS is disabled for the GizmoSQL server - this is NOT secure.
T10:05:
3
946Z INFO pid1344 tid140088588014528 componentgizmosql_server - Access logging disabled
T10:05:
3
959Z INFO pid1344 tid140088588014528 componentgizmosql_server - DuckDB version: v
1.
0
T10:05:
3
606Z INFO pid1344 tid140088588014528 componentgizmosql_server - Running Init SQL command: SET autoinstall_known_extensions true;
T10:05:
3
610Z INFO pid1344 tid140088588014528 componentgizmosql_server - Running Init SQL command: SET autoload_known_extensions true;
T10:05:
3
611Z INFO pid1344 tid140088588014528 componentgizmosql_server - Using database file: /mnt/c/d/gzm/./data.db
T10:05:
3
611Z INFO pid1344 tid140088588014528 componentgizmosql_server - Print Queries option is set to: true
T10:05:
3
707Z INFO pid1344 tid140088588014528 componentgizmosql_server - GizmoSQL server version: v
1.
1
0 - with engine: DuckDB - will listen on grpctcp://
0.
0.
0:31337
T10:05:
3
707Z INFO pid1344 tid140088588014528 componentgizmosql_server - GizmoSQL server - started可以用客户端验证服务端正常./gizmosql_client --command Execute --host localhost --port 31337 --username gizmosql_username --password gizmosql_password --query SELECT version() --tls-skip-verify Results from endpoint 1 of 1 Schema: version(): string Results: version(): [ v
1.
0 ] Total: 1启动GizmoSQL UI后台服务cd gzmui rootDESKTOP-59T6U68:/mnt/c/d/gzmui# chmod x g* rootDESKTOP-59T6U68:/mnt/c/d/gzmui# ./gizmosql-ui-linux-x64 ╔══════════════════════════════════════════════════════════════════════════╗ ║ ║ ║ ██████╗ ██╗███████╗███╗ ███╗ ██████╗ ███████╗ ██████╗ ██╗ ║ ║ ██╔════╝ ██║╚══███╔╝████╗ ████║██╔═══██╗██╔════╝██╔═══██╗██║ ║ ║ ██║ ███╗██║ ███╔╝ ██╔████╔██║██║ ██║███████╗██║ ██║██║ ║ ║ ██║ ██║██║ ███╔╝ ██║╚██╔╝██║██║ ██║╚════██║██║▄▄ ██║██║ ║ ║ ╚██████╔╝██║███████╗██║ ╚═╝ ██║╚██████╔╝███████║╚██████╔╝███████╗ ║ ║ ╚═════╝ ╚═╝╚══════╝╚═╝ ╚═╝ ╚═════╝ ╚══════╝ ╚══▀▀═╝ ╚══════╝ ║ ║ ║ ║ GizmoSQL UI v
2.
0 ║ ║ ║ ╚══════════════════════════════════════════════════════════════════════════╝ Server running at: http://localhost:3000 Opening browser... ▲ Next.js
14.
35 - Local: http://localhost:3000 - Network: http://
0.
0.
0:3000 ✓ Starting... ✓ Ready in 150ms Could not open browser automatically. Please open http://localhost:3000 in your browser. E Connection to dns:localhost:31337 at
127.
0.
1:31337 rejected by server because of excess pings. Increasing ping interval to 60000 ms
用浏览器访问GizmoSQL UI页面在地址栏输入http://localhost:3000, 然后点击Connect to GizmoSQL Server按钮输入用户名和口令。
就在左侧生成了目录树在NoteBook1中选NoteBook1就可以在笔记本中输入SQL语句。
如下面图片所示。
在目录树上选择要浏览的表当表中插入数据后左下角浏览窗口自动显示表中的数据。