surrealdb - 用于查看所有现有命名空间和数据库列表的命令

Question

我最近遇到了SurrealDB ，并安装它。

添加到路径后，我使用surreal start 启动了服务器。

 .d8888b.                                             888 8888888b.  888888b. 
d88P  Y88b                                            888 888  'Y88b 888  '88b
Y88b.                                                 888 888    888 888  .88P
 'Y888b.   888  888 888d888 888d888  .d88b.   8888b.  888 888    888 8888888K.
    'Y88b. 888  888 888P'   888P'   d8P  Y8b     '88b 888 888    888 888  'Y88b
      '888 888  888 888     888     88888888 .d888888 888 888    888 888    888
Y88b  d88P Y88b 888 888     888     Y8b.     888  888 888 888  .d88P 888   d88P
 'Y8888P'   'Y88888 888     888      'Y8888  'Y888888 888 8888888P'  8888888P'


[2022-09-27 14:14:30] INFO  surrealdb::iam Root authentication is disabled
[2022-09-27 14:14:30] INFO  surrealdb::dbs Database strict mode is disabled
[2022-09-27 14:14:30] INFO  surrealdb::kvs Starting kvs store in memory
[2022-09-27 14:14:30] INFO  surrealdb::kvs Started kvs store in memory
[2022-09-27 14:14:30] INFO  surrealdb::net Starting web server on 0.0.0.0:8000
[2022-09-27 14:14:30] INFO  surrealdb::net Started web server on 0.0.0.0:8000

然后我在另一个终端使用surreal sql --conn http://0.0.0.0:8000进入数据库。

如何列出所有命名空间和数据库？

此外，当我使用像 SELECT * FROM buybig 这样的命令时，我得到:

> SELECT * FROM buybig;
There was an error with the remote request: error sending request for url (http://0.0.0.0:8000/sql): error trying to connect: tcp connect error: The requested address is not valid in its context. (os error 10049)   
>

Answer 1

命名空间 可以与 INFO 一起列出查询。

INFO FOR KV;

返回

[
    {
        "time": "19.6µs",
        "status": "OK",
        "result": {
            "ns": {
                "namespace1": "DEFINE NAMESPACE namespace1",
                "namespace2": "DEFINE NAMESPACE namespace2"
            }
        }
    }
]

您可以通过选择带有USE NS的 namespace 来检索 namespace 中的数据库正在运行 INFO FOR NS .

USE NS namespace1;
INFO FOR NS;

这将返回

[
    {
        "time": "21.9µs",
        "status": "OK",
        "result": {
            "db": {
                "database1": "DEFINE DATABASE database1",
                "database2": "DEFINE DATABASE database2"
            },
            "nl": {},
            "nt": {}
        }
    }
]