Access the NXT / Ardor database console?

2

I want to do some queries on the H2 database. How can I access this console that lets me type in commands.

Patoshi パトシ

Posted 2016-06-30T04:04:20.823

Reputation: 8 911

Answers

2

You can access the NXT's H2 database from the website by going to /dbshell path.

Example: Show top 100 accounts sorted by balance:

select *, BALANCE / 100000000 as NXT from account where latest = true order by balance desc limit 100

Patoshi パトシ

Posted 2016-06-30T04:04:20.823

Reputation: 8 911