Developing a blockchain SQL database named CovenantSQL

[CovenantSQL]

Guys, I'm developing a blockchain SQL database named CovenantSQL.

Our website: http://covenantsql.io
GitHub: https://github.com/CovenantSQL/CovenantSQL

so, any question?

[1715474434]

1715474434

[Patatas]

Guys, I'm developing a blockchain SQL database named CovenantSQL.

https://github.com/CovenantSQL/CovenantSQL

so, any question?

Beautiful! Which is the core language of the entire project? By putting it on blockchain, do you remove the central authority completely? I know BigChainDb does it to a certain extent by your architecture seems more complicated. Would a developer have to learn an additional language to use this or the syntax remains the same as conventional SQL?

[Barcoded]

Can u please tell what use cases fits best for this database?

[Patatas]

Can u please tell what use cases fits best for this database?

A lot of them depending on the problem you're trying to solve...Some of them could be
 - A public data-base where data can't be altered (immutability)
 - Some records which store history like medical records which can only be updated by not overwritten.

On the technical end, it's decentralised and hence there is no central authority over the database.

[Barcoded]

Can u please tell what use cases fits best for this database?

A lot of them depending on the problem you're trying to solve...Some of them could be
 - A public data-base where data can't be altered (immutability)
 - Some records which store history like medical records which can only be updated by not overwritten.

On the technical end, it's decentralised and hence there is no central authority over the database.

So, this database allows only INSERT and SELECT WHERE id=? and UPDATE ... WHERE id=? or it also allows more complex queries?

[CovenantSQL]

Guys, I'm developing a blockchain SQL database named CovenantSQL.

https://github.com/CovenantSQL/CovenantSQL

so, any question?

Beautiful! Which is the core language of the entire project? By putting it on blockchain, do you remove the central authority completely? I know BigChainDb does it to a certain extent by your architecture seems more complicated. Would a developer have to learn an additional language to use this or the syntax remains the same as conventional SQL?

We developing it in golang and c. Sure, it's completely decentralized, so we have wrote 50k lines of golang to implement it.
currently, we have java and golang driver, the usage is just same like a traditional database.
the test net will be on by Oct. 2018

[CovenantSQL]

Can u please tell what use cases fits best for this database?

A lot of them depending on the problem you're trying to solve...Some of them could be
 - A public data-base where data can't be altered (immutability)
 - Some records which store history like medical records which can only be updated by not overwritten.

On the technical end, it's decentralised and hence there is no central authority over the database.

thx for explaining, some more
1. For traditional App using SQL, you can adapt it onto Blockchain by little change on DB-type and DB-uri.
2. For ĐApp it can be a large and cheap(comparing to storage on Bitcoin or Ethereum) rational database.

[CovenantSQL]

Can u please tell what use cases fits best for this database?

A lot of them depending on the problem you're trying to solve...Some of them could be
 - A public data-base where data can't be altered (immutability)
 - Some records which store history like medical records which can only be updated by not overwritten.

On the technical end, it's decentralised and hence there is no central authority over the database.

So, this database allows only INSERT and SELECT WHERE id=? and UPDATE ... WHERE id=? or it also allows more complex queries?

most SQL-92 standard is supported. that is you can even write SQL like this:

Code:

SELECT urls.url
  FROM urls
  LEFT JOIN
    (SELECT *
      FROM (SELECT url_id AS uid, max(retrieval_time) AS rtime
              FROM lookups GROUP BY 1 ORDER BY 1)
      WHERE uid IN (358341,358341,358341)
    ) recent
    ON u.source_seed_id = recent.xyz OR u.url_id = recent.xyz
 WHERE
     DATETIME(recent.rtime) > DATETIME('now', '-5 days');