Bubble is a powerful "no-code" tool that allows people to build complex web applications without writing any code. In this tutorial we will use Bubble to connect to the HiveSQL database, retrieve information from it, and display that information on a webpage.

There seems to be a big gap between the few people who understand the complexity of blockchain/dApp development and the consumers who use the technology that they develop. I was inspired by a video @taskmaster4450 recently uploaded to 3speak (this one) in which he talked about how the industry is still too technical and there's a large barrier to entry. I agree with this and decided to share what I have been playing around with in hopes of inspiring others to try building something. I'm not a professional developer and you don't have to be one to follow this tutorial.

Let's Get Started!

• First you'll need to sign up for a free account on Bubble. If you build something worth releasing to the public, you'll probably want to upgrade to a paid plan, but that's not necessary for our experiments today.

• You'll also need to register for a HiveSQL account by following the instructions here. The cost is currently just a one-time fee of 1 HBD. The login credentials that you receive after registering will be needed in a future step.

• Now log into Bubble and click on the "New app" button under "My apps". Fill out the popup box with a name for this app and the other details. Leave the template option blank. Something like this will work:

[IMAGE: https://images.ecency.com/DQmVqecbudrYP8GrEktb63f4JiK2TmzjvF2QVHx9ujwbXEt/screenshot_from_2021_11_12_21_18_45.png]

• Next you should be in the Bubble editor. There are other tutorials online that teach you how to use all the features so I'm going to focus purely on how to use it with Hive. Click on the "Plugins" icon on the left side and then click on the "+ Add plugins" button on the top right corner. A popup box like the one below will open. You can use the search box to find the "SQL Database Connector" app and install it.

[IMAGE: https://images.ecency.com/DQmb7kQTWre5sKMMUpsbdFKfh5XUosj9feCKh3S1qvKLKQG/screenshot_from_2021_11_12_21_28_50.png]

• Click on SQL Database Connector on your Plugins page on Bubble and we will enter the database connection information. You can type anything you want for the Connection name and select "Microsoft SQL" for the database type.
  Now is when we'll need your HiveSQL login details from earlier. The transaction memo should tell you the Server, Database, Login, and Password. The connection string you need to type in will contain all of those items in the following format (with no brackets):

mysql://[Login]:[Password]@[Server]:1433/[Database]

[IMAGE: https://images.ecency.com/DQmdPTA12MxtirfeGswu1WuGEANKsTT6T7ZG91hoHfGTRC4/screenshot_from_2021_11_12_21_36_32.png]

• After you have clicked the "Test connection" button and had no problems, we will add a query. For this tutorial we will use the Comments table from the database to retrieve the last 50 comments, but once you figure out how to do this, you can experiment with all kinds of things.
  You can name the query anything, but I suggest you just name it "comment". Choose the connection you created in the last step and choose "Data" from the "Use as" dropdown. In the query box, we can do a lot of things with SQL, but to keep things fairly simple in this example we're going to use the following query:

SELECT TOP 50 * FROM Comments ORDER BY ID DESC;

[IMAGE: https://images.ecency.com/DQmQezr7s3T7dX2LXuqRuGSDRGP2LG8phAuoDSTT7FVfH8Q/screenshot_from_2021_11_12_21_59_37.png]

• Click on "Initialize this query" and you should get a popup box like the one below. This shows all of the data values returned from the database. Bubble was able to correctly detect all the data types for me so I didn't have to change any of them. You can click "Save" on this popup.

[IMAGE: https://images.ecency.com/DQmU7sTV5YTUByf3fg6QbEpL2wkjKWqaHtxJfJ3baYkZWCy/screenshot_from_2021_11_12_22_13_11.png]

• Now we have the database connection set up and can experiment with displaying those values on the page. Click on the "Design" button on the left menu. If you started this app with no template then you should have a blank page. Click on the "Repeating Group" under "Containers" on the left menu. Click and drag on the page to create a big square. If you mess up, you can drag the corners of the box to look similar to mine:

[IMAGE: https://images.ecency.com/DQmdAPEYaaW9qCZEj9uefSi29ZEqtnadbMJchEPmNPsivDa/screenshot_from_2021_11_12_22_21_09.png]

• Double click on the Repeating group that you put on your page. In the popup box that appears, we need to choose the name of our query as the "Type of content". Sine I named mine "comment", that's what I'll pick:

[IMAGE: https://images.ecency.com/DQmWCiSMpiuChnguZgMdEisXXXZvarF5s35Ev24vDBbTfoZ/screenshot_from_2021_11_12_22_24_11.png]

• Click on "Data source" and select "Get data from an external API". This brings up another box asking for the API provider. From the dropdown, select "comment" or whatever you named yours and then click the "Close button". We can then close the box for the Repeating group as well.

[IMAGE: https://images.ecency.com/DQmWd4rwaeRzc68yTcEMiek43ACADExvX6ycmwtefAN6LgQ/screenshot_from_2021_11_12_22_28_57.png]

• Click on "Text" on the left menu under "Visual elements". Then click and drag a rectangle in the top section of the Repeating group. You'll see that the text repeats in each section like this:

[IMAGE: https://images.ecency.com/DQmPZ4WMNWmBo3bPxWx7PWA3Zf2L6dmZFQV2WhGwLuAkFgJ/screenshot_from_2021_11_12_22_34_05.png]

• Double click on the Text box and it will open a similar popup to edit it. Click on the "...edit me..." words, type "Username: ", and then click on the blue box that says "> Insert dynamic data".

[IMAGE: https://images.ecency.com/DQmZYKRY78e4TupnrdjUYYpSLeJenSfcH7fZ94KNJjMyBFR/screenshot_from_2021_11_12_22_41_54.png]

• Select "Current cell's comment" and in the following box select "'s Author". Then you can close the Text edit box.

[IMAGE: https://images.ecency.com/DQmb16SLBPqVWgjob1JDaKekU3yJuw3g75pKstVFVEZa15E/screenshot_from_2021_11_12_22_42_43.png]

• Let's repeat the last few steps to create another text box next to that one, but this time we'll type "Comment: " into it and choose "Current cell's comment" and "'s Body" from the dropdowns so our page looks like this:

[IMAGE: https://images.ecency.com/DQmQNvbBMvKDdCxvHsNJXQwP8ieEGqwK6f1syZ8QFhEFcFV/screenshot_from_2021_11_12_22_52_42.png]

• Now we can finally test this out and see what happens!! Click on the "Preview" link on the right side of the top menu and it should open a new window. It might take a second to load the data, but then if we did everything correctly it should look similar to this with the ability to scroll through the last few dozen posts/comments from the Hive blockchain:

[IMAGE: https://images.ecency.com/DQmRFtRc7XrPTum7gN4WgDaunhvLDkLybFNCH9NGAVH9eix/screenshot_from_2021_11_12_22_55_48.png]

WE DID IT!!

If you followed this tutorial, you've now opened the door to being able to build all kinds of web apps that use data from the Hive blockchain without writing any code! You could create a personal website that shows statistics about your account along with a feed of your most recent posts. You could build an app that lists the largest Hive transactions of the day. The possibilities are endless!

What's Next?

Of course, there's still more learning to do. The app created in this tutorial is not pretty and it only uses a couple of the pieces of data we can access with HiveSQL. If you want to build a real app using these tools, the following resources will come in handy:

• HiveSQL Documentation
• W3Schools SQL Tutorial
• Bubble Academy
• Bubble Manual

I put a lot of effort into this tutorial so I'd love to get your opinion and feedback in the comments! Let me know if you try following it and run into a problem or if you build something cool that you want to share!