Ninjastic
Search content
Sort by
Showing 5 of 5 results by CovenantSQL
Post
Topic
Board Project Development
Re: Developing a blockchain SQL database named CovenantSQL
by
CovenantSQL
on 14/09/2018, 09:11:39 UTC
Quote from: Barcoded on September 13, 2018, 01:32:20 PM
Quote from: Patatas on September 13, 2018, 01:09:18 PM
Quote from: Barcoded on September 13, 2018, 12:58:38 PM
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');
Post
Topic
Board Project Development
Re: Developing a blockchain SQL database named CovenantSQL
by
CovenantSQL
on 14/09/2018, 08:57:31 UTC
Quote from: Patatas on September 13, 2018, 01:09:18 PM
Quote from: Barcoded on September 13, 2018, 12:58:38 PM
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.
Post
Topic
Board Project Development
Re: Developing a blockchain SQL database named CovenantSQL
by
CovenantSQL
on 14/09/2018, 08:44:20 UTC
Quote from: Patatas on September 13, 2018, 12:58:30 PM
Quote from: CovenantSQL on September 13, 2018, 12:16:29 PM
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
Post
Topic
Board Project Development
Re: Looking for interesting projects
by
CovenantSQL
on 13/09/2018, 12:27:11 UTC
CovenantSQL is a decentralized, crowdsourcing SQL database on blockchain. with Features:

  • SQL: most SQL-92 support.
  • Decentralize: decentralize with our consensus algorithm DH-RPC & Kayak.
  • Privacy: access with granted permission and Encryption Pass.
  • Immutable: query history in CovenantSQL is immutable and trackable.


One Line Makes Data on Blockchain

    sql.Open("CovenantSQL", dbURI)

https://github.com/CovenantSQL/CovenantSQL
Post
Topic
Board Project Development
Merits 1 from 1 user
Developing a blockchain SQL database named CovenantSQL
by
CovenantSQL
on 13/09/2018, 12:16:29 UTC
⭐ Merited by NeuroticFish (1)
Guys, I'm developing a blockchain SQL database named CovenantSQL.

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

so, any question?