Replies: 3 comments
-
I would be interested in such a tool -- it would be helpful for the community. You can get the information you need, look how the CLI does it: https://github.com/rqlite/rqlite/blob/master/cmd/rqlite/main.go#L132 So, you'd do it like this: $ curl -G 'localhost:4001/db/query?pretty&timings' --data-urlencode 'q=SELECT * FROM sqlite_master'
{
"results": [
{
"columns": [
"type",
"name",
"tbl_name",
"rootpage",
"sql"
],
"types": [
"text",
"text",
"text",
"int",
"text"
],
"values": [
[
"table",
"foo",
"foo",
2,
"CREATE TABLE foo (id INTEGER NOT NULL PRIMARY KEY, name TEXT)"
]
],
"time": 0.000247127
}
],
"time": 0.000289804
} and so on for tables and indexes, as shown in the CLI source code |
Beta Was this translation helpful? Give feedback.
-
Hey - thanks for supporting the concept. Kind of like the naked objects manifesto if your curious, but applied to the DB layer. I will try to allocate some time to give this a go on a repo and let others know. If anyone else takes a crack at this let me know. It would be beneficial that any rqlite node can incorporate the GUI, rather than introduce another server and hence SPOF, etc ? |
Beta Was this translation helpful? Give feedback.
-
Yes, I would be open to building this directly into the rqlite system itself for the reasons you say. Something like rqlite could serve a single-page web app on a new API we would create, for example. I'd need to be your implementation, to be sure though. |
Beta Was this translation helpful? Give feedback.
-
I would like to build a basic GUI on top of rqlite that allows the user to easily see the data and navigate between the data.
Its inspired by https://blog.cloudflare.com/introducing-d1/
to do that i need a http api call that returns the schema via GET.
Beta Was this translation helpful? Give feedback.
All reactions