CovenantSQL/CovenantSQL

a Blockchain featured Database

auxten

@auxten

:-) will check pion out

Ghost

@ghost~5508905815522ed4b3dd685d

great !!

The team are really cool there

also on gitter

The equivalent of your DHT tracker is basically a TURN server. No the same but similar.

auxten

@auxten

Yeah, also play a role of DNS

Ghost

@ghost~5508905815522ed4b3dd685d

ah yeah true. Your dependent on DNS, which is probably not what you want right ?

auxten

@auxten

yes, DNS is so easy to manipulate

Ghost

@ghost~5508905815522ed4b3dd685d

so true.

auxten

@auxten

especially in our country

Ghost

@ghost~5508905815522ed4b3dd685d

yeah i forgot that !!! Thats the whole point !

Ok well i will get busy trying out your code, etc. Thanks Auxten for your help and patience. Will be in touch !!!

auxten

@auxten

you are welcome :-)

Ghost

@ghost~5508905815522ed4b3dd685d

Is there a demo app for doing password management yet like mentioned here: https://developers.covenantsql.io/docs/en/usecase_traditional_app

Just want to try things out

auxten

@auxten

sorry, we have not done that. I think it will be something like input your private key, and get thing listed. https://github.com/PhilippC/keepass2android will be a good project to do it on.

Ghost

@ghost~5508905815522ed4b3dd685d

not for me. Its java.

Was looking for just a golang CLI app

nice and simple

Morning btw :)

Am just trying to get anything runnig so i can play with the system. Maybe i should use the Quandi example: https://developers.covenantsql.io/docs/en/usecase_data_analysis

Do you have a github with the quandi example setup for it maybe yet ?

i mean a github repo .

auxten

@auxten

Morning, the quandl stuff, are you familiar with python?

here are 2 examples using cql lib in go https://github.com/CovenantSQL/CovenantSQL/tree/develop/client/_example

auxten

@auxten

The quandl data is contributed by community: https://github.com/melancholiaforever/CQL_Excel
Accessing the quandl data with python is quite easy:

download the certs: https://pan.baidu.com/s/1Xpf6_A849O8t507K0VGQ4w
pip install PyCovenantSQL

connect to the db

import pycovenantsql.cursors 
connection = pycovenantsql.connect (
 host='e.morenodes.com',
 port=11111,
 key="read.data.covenantsql.io.key",
 https_pem ='read.data.covenantsql.io.pem',
 database='057e55460f501ad071383c95f691293f2f0a7895988e22593669ceeb52a6452a'
)

query

with connection.cursor() as cursor:
 cursor.execute("select * from quandl_updateindex where databasecode like 'BIS' group by quandlcode limit 1000")
 cursor.fetchall()

Ghost

@ghost~5508905815522ed4b3dd685d

I am a golang person.

i just found https://github.com/CovenantSQL/CovenantForum

It looks like a good way to get into it

I think i could convert quandl to golang but i doubt you want that actually. Better to have a Pything demo for pything programmers

I am wondering if your SQLite with the crypto plugin will run on Windows. Have you got the Windows version in CI ?

auxten

@auxten

Have not tried on windows, but as it does not depend on any other libs like openssl, it should work.

S3x0r

@S3x0r

bello

can someone send me testnet PTC?

90548f2b23438697877a7ca78a6729f8638a9060b8e99815234ba50280c27938

auxten

@auxten

@S3x0r sorry for late response 100000000 PTC transfered

Tamajit Ghosh

@tamajit_gitlab

Hi Team, I am trying to implement CovenantSQL using private deploy user guide, I am facing some problem and confusions as well -

I have created database using node_c config.yaml but unable to connect through javascript (I am following CovenantSQL javascript user guide)

Tamajit Ghosh

@tamajit_gitlab

"cql": {
```
 "endpoint": "0.0.0.0:11105",
 "database": "0a10b74439f2376d828c9a70fd538dac4b69e0f4065424feebc0f5dbc8b34872"
```
}
I have created a database(id : 0a10b74439f2376d828c9a70fd538dac4b69e0f4065424feebc0f5dbc8b34872) where already I have done some read write operation through the console and those logs can be seen in the explorer.
I am using this config file to connect that database, but cql.createConnection() is returning null connection object.
I have created config.yaml and private key using cql generate but I am failed to create database using those files

auxten

@auxten

the endpoint config should either point to 'https://testnet-proxy.covenantsql.io’ or local proxy set by your self.
in your case which deployed by docker, the endpoint should be "127.0.0.1:11105"

@tamajit_gitlab

sorry for the late response.

Julian Schütte

@julian_schuette_twitter

Hey guys! Are there any rough performance numbers (TX throughput/latency) of Covenant SQL available?

Gopalakrishna Palem

@KrishnaPG

@auxten what is the role of PTC? To add data to the DB, and query the data from DB, is PTC reqired?

Gopalakrishna Palem

@KrishnaPG

@auxten for Testnet it seems PTC are being "donated". How does a user gain these PTC in a real-world scenario (e.g. private deployment in, say, docker)

akjhacse

@akjhacse

@auxten . I am using go-sqlite3-encrypt for encrypting sqllite db in go lang. sql.Open("sqlite3", "file:testDB.db?_crypto_key=KEY123")

But it is not encrypting the DB

Any help will be much appreciated

Thanks

fm-b

@fm-b

I have a fundamental question. I would be thankful if anybody gives me an answer.
I have a SQL database and i want to use ConvenantSQL to make it secure.
I want to know that is it possible to have a private instance of ConvenantSQL or not. And if the answer is yes what would happen to gas and tokens that I should pay?!

Where communities thrive

People

Repo info

Activity