Basing the ripple's source code, we add chainsql's own database modules. The DB operating log will be stored in the ripple chain, then you can acquire the visual data in traditional DB.
By setting the sync_tables, sync_db and auto_sync, you will restore the real DB tables you wanted from block chain. You can set the DB type arbitrarily, includeing mysql, sqlite, oracle and so on.
Defined three new transaction types for the DB operation, named sqlStatement, tableListSet and sqlTransaction. sqlStatement is used to insert, update or delete records, tableListSet is used to create a table and other operations to the table-self, sqlTransaction is used to operator a set of DB sql clause in one blockchain's transaction.
You can operate the DB or send DB operations to the block chain by the fowlling foue ways.
- RPC API , supplied by the RPC modules.
- Web sockets API, developed in javascript and java. Refer API in javascript and API in java .
- Commandline, access to the node directly.
- By kingshrad, using db's primitive sql clause. Refer Access by sql.
The table module send data request to other nodes and sort the tx datas from other nodes, then give the right transaction data to the misc modules. This module also seeks every ledger in local block chain to get the compatible table data to send back to the required nodes.
The misc module analysis transaction data to get the real sql, then operator the DB ussing these real sql sentences.
Further more, storage modules make you check the DB before sending tx data to the block chain, this makes it possible if we can operate DB timely.
If you want to get more infomation about this productioon ,please access the site www.chainsql.net.
On updating our version or releasing new functions, the RELEASENOTES will be updated for the detail description.
Refer the Setup for details.
Refer the Builds directory for details, we introduce the detail compiling steps in several OS systems.
ChainSQL is under the GNU General Public License v3.0. See the LICENSE directory for details.
Email: [email protected]
Wechat: scan the QR below to follow PeerSafe, and then send chainsql, you will receive the QR image for ChainSQL community.
PeerSafe Wechat QR code：
