Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Suggestion] New Function "About" for DBHub.io metadata #237

Open
PJOttCanHome opened this issue Dec 21, 2023 · 1 comment
Open

[Suggestion] New Function "About" for DBHub.io metadata #237

PJOttCanHome opened this issue Dec 21, 2023 · 1 comment

Comments

@PJOttCanHome
Copy link

PJOttCanHome commented Dec 21, 2023

It might be useful for applications to request the current state of DBHub.io, itself.
I was thinking it could return something like this:

{
    "SQLiteVersion" : "3.x",
    "APIVersion" : ""v1",
    "Build" : "1.56.3",
    "Parameters" : [ 
        {"Name" : "dbname", "Type" : "String"},
        {"Name" : "table", "Type" : "String"},
        {"Name" : "live", "Type" : "Boolean"},
        {"Name" : "sql", "Type": "Base64"} /* etc */
    ],
    "Functions" : [
        {"Name" : "About", "ParamNames": [] },
        {"Name" : "Databases", "ParamNames": [] },
        {"Name" : "Tables", "ParamNames": ["dbname"] },
        {"Name" : "Query", "ParamNames": ["dbname","sql"] } /* etc */
    ],
    "ChangeHistory" : [
        {"Build" : "1.56", "Date" : "2023-12-20", "Info" : "We fixed more things"},
        {"Build" : "1.53", "Date" : "2023-12-15", "Info" : "We fixed a lot of things"},
        {"Build" : "1.50", "Date" : "2023-12-10", "Info" : "We fixed things"}
    ]
}

And it might be best to restrict the extra info based on a Boolean "verbose" parameter.
Using the verbose results from this function people could create/run their own tests.

@justinclift
Copy link
Member

Interesting idea, could be useful.

Probably not super hard to implement either. Let me think it over a bit. 😄

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants