greptimedb icon indicating copy to clipboard operation
greptimedb copied to clipboard

Move all admin APIs to information_schema or implement them as SQL function

Open killme2008 opened this issue 2 years ago • 0 comments

What type of enhancement is this?

Tech debt reduction, User experience

What does the enhancement do?

Before we make improvements for information_schema in #2931 , we designed some HTTP APIs under /admin to query table metadata or routes etc.

Some APIs such as /tables,/schemas are already supported by infomration_schema.tables or infomration_schema.schamta virtual tables. Others can be moved into infomration_schema too, for example, the table routes info.

Also, we can implement SQL functions to support some management APIs such as migrating regions.

Implementation challenges

No response

killme2008 avatar Jan 13 '24 08:01 killme2008