OurSQL Demo Database

If you are interested to see how OurSQL works, you can do it right now if you have some basic experience with docker usage. (https://www.docker.com/)

We created demo database called “OurSQL Demo DB”.

On of DB nodes is 109.251.62.4:8765 . For now network is not big, if there are more nodes later we will list them.

Run docker container and connect to mysql proxy.

docker run --name oursql -p 8765:8765 -p 8766:8766 -d -it oursql/oursql-server importandstart -port 8765 -nodeaddress 109.251.62.4:8765

This connects to existent decentralized database and starts new node. The node listens on the port 8765 and DB proxy server listens on the port 8766.

Connect to your local copy of this database. Database bane is BC, user credentials are blockchain/blockchain .

mysql -h 127.0.0.1 -P 8766 -u blockchain -pblockchain BC

You can see list of current DB tables. Ignore tables with the “bc_” prefix. This are special tables where blockchain info is stored. Work only with tables without this prefix.

Try to insert something in tables. Most probably, you will get an error like “No enough funds for requested transaction”.

In this database we set all SQL updates to be “paid” to prevent unlimited data inserts or so.

When you just started your node, you will get new created wallet which doesn’t have any funds (in internal cryptocurrency used in this database).

To continue your tests, you can ask us to send some funds for you. We are not stingy 🙂 . We will send you enough coins to do your tests of this demo database.

Firstly, you need to know your wallet address. Execute the command. There will be only 1 address if you didn’t create more yet.

docker exec -it oursql2 /node listaddresses

Email your address to oursql.project@gmail.com or to roman@gelembjuk.com and notice you would like to get funds to test the DB. After you get your funds, you will be able to execute SQL updates on this DB.

For example, add some message to the chat table.

mysql -h 127.0.0.1 -P 8766 -u blockchain -pblockchain BC

mysql> INSERT INTO chat SET username="visitor", message="Hi,All, i am here with you", addtime='2018-11-28 22:00';
Query OK, 1 row affected (0,12 sec)

After short period of time, you update will be visible on all other nodes.

 

Leave a Reply

Your email address will not be published. Required fields are marked *