Android Question Compilation of B4A, and MySQL WorkBench

[Jaderson Viana]

What's up guys.

I came here today with a question. For some time I've been trying to create a database (I started using B4A on Wednesday, 9/19/09) and since I'm very new, I did not see any tutorial from 0 to the professional. I do not know how to speak fluent English (and right now I'm using google, sorry for not being 100% compatible).
I found a tutorial in my language, where the teacher teaches how to make a database from 0% to 100%. However, it is using the program "MySQL WorkBanche" and I do not know if it has how to integrate the database that I am doing (I am creating a table in which I need to put basic things like: "Name, address, rg, cpf, etc ") and I find this program very fluid! But if there is no way to integrate the SQL database with B4A, I'm just wasting time !! So I wanted to know if any wonderful gods were here, could you tell me if there's any way I can use the B4A workbenche database, because if it does, it will make my life a lot easier.

 

[Erel]

You can use jRDC2 or JdbcSQL to connect to remote databases.

https://www.b4x.com/search?query=jRDC2

 

[Jaderson Viana]

Omg, I'm so happy with this answer!
Knowing that there is a way to connect the databases, I can continue studying! Thank you so much Erel!

 

[KMatle]

Knowing that there is a way to connect the databases, I can continue studying!

Wellcome to the forum We have an excellent search function.. You can do a search for "MySql" or "Database" and find a lot of examples (even if you haven't heard about "jRDC2"). Another idea is to search for SQlite. Very powerful. I use it as inhouse solutions via AsyncStreams (= network connection to e.g. a B4J app as a server using SQLite). If you like you can use php via OkHttpUtils to use a MySQL db on a remote server, too.

 

[Jaderson Viana]

Thank you KMatle!
I'm doing an application that needs an internal database, and for that I'm using the workbach (I tried everything to set up internal SQLite, but I just can not !!!) So I'm trying to use a more "external" program ". But I do not know if an external database would be the best option. Can this option via AsyncStreams work for me? (to put you in the context of the situation, I'm creating a registration application, in which I put, example: "name, address, rg, cpf, etc" .I have to put product codes as well. However, whoever is going to use the application, often may not be in places that have an internet connection.)