Kwil-db v0.10 changes

[KwilLuke]

Immediate Changes

These need to be implemented by the time kwil-db v0.10 reaches final release.

• Move Firebird to be the first item in the nav bar list

• On the database tab, if a user is not connected to an instance, prompt them to deploy one in firebird.

• On firebird deployment page, change Kwil Version to 0.10.0

• Change Kwil CLI sample code to:

  • 1. Install instructions:

  kwil-cli version

  • 2. Connect to provider:

  kwil-cli utils ping

  • 3. Interact with Database. Use an Ethereum Private Key at <your-private-key>.
  • Create a table:

  kwil-cli database execute -s "CREATE TABLE users (id uuid primary key, name text notnull);" \n
  --provider=<provider-address> \n
  --chain-id=<chain-id> \n
  --private-key=<your-private-key>

  • Insert data:

  kwil-cli database execute -s "INSERT INTO users (id, name) VALUES (<generate-uuid>, 'Bob');" \n
  --provider=<provider-address> \n
  --chain-id=<chain-id> \n
  --private-key=<your-private-key>

  NOTE: The DB admin should auto-generate a uuid at <generate-uuid>

• Change JavaScript sample code to match behavior in kwil cli.

• When clicking Connect to Provider change the two options to:

  • Execute SQL (link to IDE page)
  • View Data (link to Databases page)

• On IDE page, change each file to be a .sql file, and apply SQL validation logic (if simple, if not, SQL validation can be a future item).

• On the databases page, show all schemas, including schemas that start with _kwild (@brennanjl - can you give your opinion on this? should all schemas be visible through the db admin?)

  • 

• Update how the schema information is retrieved (e.g., actions, schemas, tables, etc.). See this document for reference: https://docs.google.com/document/d/1NfOicqc4WE5SEVNzxYkFrGwj6qn_Cid1GKe7C2kFxec/edit?usp=drive_link

• Remove Other Database

• Change Pinned Databases and My Databases to Pinned Schemas and My Schemas

Future Changes

These can be implemented after the release.

• Add a terminal-like interface/modal to the databases page that allows people to execute ad-hoc SQL. This interface should be able to expand and contract.
• Add a similar terminal-like interface to the deployments page on the firebird section, allowing users to execute queries immediately after they deploy (decrease the amount of navigation the user needs to do to start using the DB)
  • There should be a section that gives similar tips to the kwil-cli and Javascrip section; however, a user should be able to hide the tips if they wish.
  • E.g,.

[KwilLuke]

• Allow deployer to set a DB owner address

[KwilLuke]

On this item:

On IDE page, change each file to be a .sql file, and apply SQL validation logic (if simple, if not, SQL validation can be a future item).

Most IDEs do not support SQL validation, so I decided to backburner it for now. This library may be helpful if we want to implement SQL validation in the future: https://github.com/DTStack/monaco-sql-languages