How to Describe a Table in Sqlite Database?
To describe a table in SQLite, you can use the following SQL command: PRAGMA table_info(table_name); Replace table_name with the name of the table you want to describe. This command …
Tag: sqlite database
Improve Multithreading Performance of Sqlite Database by WAL (Write Ahead Logging)
By Default, the SQLite locks the database when there are simutanenous reading and writing. SQlite stores data in a file. For example we can use the following command to …
Using ADODB to Query SQLite in VBScript
Querying SQLite Database via VBScript can be done via the ADODB.Connection Object. We use the Open to specify the connection String, and the Execute method to run a SQL …
How Many Blocks and Total Rewards for a Steem Witness in the Past 24 Hours?
The blockchain is a public database, this shouldn’t be hard to find out. In this post we know how to call the Steem API to find out the witness …
SQLite Explan: Why the Most Popular Accounts Query is Slow compared to Most Blocked Accounts Query?
Similarly to Most Blocks Accounts on Steem Blockchain I was going to have a page that lists the most popular accounts (most followed). However, after analysis, I decide to …
