btSQL | Decentralised database on BTFS

TRON Hackathon Hackathon Season 7
1

Project Name: btSQL
Project Track: Integration

Team Name: btSQL
Team Member(s): @btSQL

DevPost Project Link: btSQL | Devpost

Project Goal:
btSQL aims to revolutionize database management by integrating blockchain technology with traditional SQL databases. Our goal is to provide a decentralized, secure, and scalable database solution that leverages the strengths of both decentralization and SQL technologies. This integration allows for enhanced data integrity, improved security, and increased transparency while maintaining the familiar SQL interface that developers and businesses rely on.

Project Value:
The integration of btSQL with BTFS brings several key benefits:

  • Decentralized Storage: Data is distributed across multiple nodes in the BitTorrent file storge network, reducing single points of failure and increasing resilience against data loss or corruption and increasing resilience against data loss or corruption.
  • Transparency and Auditability: All database operations are recorded on the btfs, allowing for unprecedented levels of transparency and ease of auditing.
  • Familiar SQL Interface: Despite the advanced distributed storage on backend, users interact with btSQL using standard SQL queries, making adoption seamless for existing database administrators and developers.
  • Cost-Effective: By utilizing the BitTorrent efficient storage structure, btSQL offers a cost-effective solution for secure, decentralized data storage and management.

Project Info:
btSQL.pdf (168.5 KB)

Project Website:
https://btsql-frontend.vercel.app/

Project Test Instructions:
To test btSQL product, follow these steps:

  • Visit the btSQL website https://btsql-frontend.vercel.app and connect your MetaMask wallet to the BitTorrent Chain Testnet. You have to sign a message for signing in, following SIWE login mechanism. Once logged in, you’ll be directed to the dashboard.
  • Create a new database by clicking the “Create New Database” button.
  • Use the Query Engine to interact with your database using standard SQL commands. Try creating tables, inserting data, and querying the data.
  • Navigate to the “Settings” page to view your API key and usage statistics.
  • For programmatic access, use the provided API key with our npm package in your javascript project. Detailed docs can be found in the dashboard

Project Details:
Please go through the video of product walkthrough to understand how it works.

Below are some actual product screenshots.

data explorer
data explorer2880Ă—1554 321 KB

query engine
query engine2880Ă—1556 208 KB

documentation
documentation2880Ă—1554 319 KB

Smart Contract links: Not applicable

Project Milestones:

  • Phase 1:
    • Complete frontend dashboard and basic query functionality
    • Integrate with BTFS for database storage
    • Develop backend API and database operations
    • Finalize documentation and prepare for project submission
  • Phase 2:
    • Integrate query optimization engine
    • Comprehensive testing and bug fixes
    • Develop more detailed library features to allow integrations with prod grade applications
  • Phase 3:
    • Continue development with focus on scalability and additional features
    • Engage with the community for feedback and potential collaborations

btSQL represents a significant step forward in database technology, bridging the gap between traditional SQL databases and decetralized storage. By leveraging the strengths of both, we’re creating a solution that offers the familiarity and power of SQL with the security, transparency, and decentralization. We believe btSQL has the potential to transform how businesses and developers approach data management in the Web3 era.

36 Likes
2

Welcome to the Hackathon of season 7, you’re project name BetSQL sounding like a project from season 6, please tell me is your project brand new, thank you

3

Hello @ines_valerie
I have no knowledge about any such project. Can you please share any reference.

This is a completely new project that I have developed for this hackathon.

5 Likes
4

Welcome to Hackathon Season 7, quite soothing for me to see an entry in the integration track, that’s legit one of the tracks I consider the hardest.
What major challenge did you face leading up to your project submission?

5

Welcome to hackathon season 7
Your approach in addressing critical challenges faced in the data management area is innovating and can foster trust in the data system.
Please explain to me the strategies you have in place to encourage existing SQL users and database administrators to adopt btSQL

6

Sorry for that I think it must to be a mistake from my own end, I am apologizing

1 Like
7

Thanks for the encouraging words @manfred_jr .

The major challenge was definitely to read the data from BTFS and run SQL over it effectively so that even for big amounts of data, the memory doesn’t blow up. Since the data is stored on BTFS in an unstructured data format, it is quite a challenge to manage that

8

@Chukseucharia thanks for the kind words.

As of now, I focussed majorly on the product development. Now I have started focusing on the adoption part as well. I am releasing a library soon, using which dapps can easily interact with any database on btSQL. This will allow an easy transition.
Also planning to run some lucrative offers in terms of pricing to begin with. Currently data upto 500MB is free.

1 Like
9

@ines_valerie no problem. Please do have a look at our project and share your feedback if possible. We are constantly looking to improve the product

1 Like
10

Thanks for the response, keeping fingers crossed :crossed_fingers:t2: as to how this fares as Hackathon progresses, goodluck on everything!

1 Like
11

You are welcome to the hackathon session 7
By integrating SQL database to blockchain technology, I have this question that I need clarity to;

  1. How will you manage sensitive data of the users?
  2. Will you implement a privacy feature such as encryption to ensure that the users data is protected?
1 Like
12

Thanks for your wish. We would definitely be needing the support of you guys and the entire community to keep building and getting motivation and feedback.

We will keeping pushing for more new releases soon

1 Like
13

@Chizz you have raised very valid questions.

So definitely preserving the data privacy is our first goal. We provide the BTFS link the table data to the dapps that use our product (we have shown in the video as well). When you open that link having the table data, you would only see gibberish encrypted data. This proves that our system encrypts all the data before pushing it to BTFS and only the end user can decrypt and access that data

1 Like
14

Thank you for the clear explanation. It’s reassuring to see that data privacy and encryption are top priorities, ensuring that sensitive information remains protected in your platform. More question I need clarity on;

  1. If a user wishes to share their encrypted data with another authorized party, how will your system handle delegation of access rights?
15

Hello @Chizz
The delegation of data is not handled yet. Maybe we can plan that going ahead. But there are some other features in pipeline as of now. Releasing nom package for interaction, working on improving the querying speed further and much more

2 Likes
16

Cross posting this message, because it has answers to some amazing questions asked by @Smart1

2 Likes
17

What kind of data you talking about? Data storage? So basically you re-selling the btfs storage?

18

Hello @btSQL team, we guys are also building tools for developers like you. We surely believe that building a great decentralised infra is the very basis for building great products on-chain. Do checkout our project JustAuth | Social Auth on TRON and let us know if you would like to integrate our auth product in you dapp.

2 Likes
19

It’s the type of project we wanna see in integration track. I appreciate ur work. It is smart how you merge SQL databases and BitTorrent

3 Likes
20

Heads off to you the project is truly remarkable…

KUDOS to you my man…:grin:

7 Likes