Inviting all devs to build on decentralised DB

TRON Discussion
1

Hi everyone, we are inviting all developers in Tron Forum to try out our project btsql - btSQL | Decentralised database on BTFS

We are building a decentralised database over BTFS. We have ourselves built the entire database query engine that allow us to query data that has been persisted in btfs. Also we ensure that the data uploaded by our clients is always encrypted before uploading to btfs. We also provide all the metadata and actual data links on btfs, and users can verify that their data is encrypted as well as transparent.

We invite developers to test out our platform and leave feedback for us to improve.

11 Likes
2

Do you have speed comparison?

3

Hi dear @btSQL
Here are some questions related to your decentralized database on BTFS:
Plz :pray: Reply thease questions .i am wanting for answers :confused:

  1. How does your database query engine optimize performance when querying data stored on BTFS?

  2. What encryption methods are used to ensure that client data is securely uploaded to BTFS, and how can users verify this?

  3. Can you explain the process for developers to test the platform and provide feedback? What specific areas are you looking for input on?

  4. How do you handle data integrity and availability on BTFS, especially in a decentralized environment?

  5. What tools or resources are available for developers to integrate your decentralized database into their own applications?

2 Likes
4

Hello @Genz210 , you can checkout our platform and more details at btSQL | Decentralised database on BTFS

You can visit our site and signup for the account and do some testing

Although we do not have valid stats for performance, we would prepare a report soon and share the stats here

2 Likes
5

Hello @Smart1 sorry for delayed response but your questions are spot on and will actually help me resolve doubts of the majority of developer community.

  1. We utilise file based DB to load the data on server and optimise the speed while querying the data regularly, which ensure that the speed is on par with regular database.
  2. The data is encrypted using the client’s secret key that is available to only that client, making sure that the data on BTFS is fully protected. Users can for sure verify this. We provide link to the btfs file for all the tables, and users can open the link and verify the encrypted data. The metadata link however shows the list of table names in the selected Database, it is public and just shows table names to make sure that the correct underlying database is selected
  3. Please visit our website and connect wallet to get started. The demo video shows it all. Looking for feedback on how can we increase the usability and any initial usecases where developers can start testing the project
  4. This is an important point, which becomes a bottleneck of a decentralised distributed storage, due to which we have a backup of the database, in an archived s3 storage, which is maintained only in case there is any data loss
  5. There is an npm package we are going to publish soon to interact with the service from your applications itself. The documentation for it is always live on the project dashboard. Please check it out and share feedback.

Hope I could answer your questions well, let me know if there are any concerns yet

3 Likes
6

Hi dear @btSQL
Thanks for replying detailed …

1 Like
7

hi. it’s something like relational SQL database, but with all data stored on BTFS ?

1 Like
8

Yes @elwords right. Using btsql, you can create databases, tables, add data. At the same time we ensure that all the data reside on BTFS

1 Like
9

is the data stored forever on BTFS, or for a certain period, say 1 month ?

1 Like