bskotu555 Active Member Oct 15, 2024 #1 I have a cloud server with SQLserver database installed on it, and I want to connect to the database for adding, deleting, modifying, and querying purposes. As a beginner, I need to learn from the case study. Thank you
I have a cloud server with SQLserver database installed on it, and I want to connect to the database for adding, deleting, modifying, and querying purposes. As a beginner, I need to learn from the case study. Thank you
Lucas Siqueira Active Member Licensed User Longtime User Oct 22, 2024 #2 use jdbc https://www.b4x.com/android/forum/t...ly-connect-to-remote-databases.84016/#content download in drives: MySQL: https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-using-ssl.html PostgeSQL: https://www.postgresql.org/docs/current/static/ssl-tcp.html MSSQL: https://docs.microsoft.com/en-us/sql/connect/jdbc/using-ssl-encryption but I wouldn't use jdbc, I would create an api using some tool that I know like PHP, B4J or node.js to create a REST API, with that my app, both android and ios and java, could consume the data via http (GET, POST, PUT, PATCH) Last edited: Oct 22, 2024 Upvote 0
use jdbc https://www.b4x.com/android/forum/t...ly-connect-to-remote-databases.84016/#content download in drives: MySQL: https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-using-ssl.html PostgeSQL: https://www.postgresql.org/docs/current/static/ssl-tcp.html MSSQL: https://docs.microsoft.com/en-us/sql/connect/jdbc/using-ssl-encryption but I wouldn't use jdbc, I would create an api using some tool that I know like PHP, B4J or node.js to create a REST API, with that my app, both android and ios and java, could consume the data via http (GET, POST, PUT, PATCH)
Erel B4X founder Staff member Licensed User Longtime User Oct 23, 2024 #3 Lucas Siqueira said: but I wouldn't use jdbc, I would create an api using some tool that I know like PHP, B4J or node.js to create a REST API, with that my app, both android and ios and java, could consume the data via http (GET, POST, PUT, PATCH) Click to expand... [B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector) Upvote 0
Lucas Siqueira said: but I wouldn't use jdbc, I would create an api using some tool that I know like PHP, B4J or node.js to create a REST API, with that my app, both android and ios and java, could consume the data via http (GET, POST, PUT, PATCH) Click to expand... [B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)
amorosik Expert Licensed User Longtime User Oct 23, 2024 #4 bskotu555 said: I have a cloud server with SQLserver database installed on it, and I want to connect to the database for adding, deleting, modifying, and querying purposes. As a beginner, I need to learn from the case study. Thank you Click to expand... But do you mean to query the db directly from the outside (and therefore the provider should allow access on a certain address/port), or can you install something on the db server side? And if you could do it, what programming environment are you allowed to use? Usually there is always a php interpreter available, but it would be interesting to understand if you can install some of your own programs or not Upvote 0
bskotu555 said: I have a cloud server with SQLserver database installed on it, and I want to connect to the database for adding, deleting, modifying, and querying purposes. As a beginner, I need to learn from the case study. Thank you Click to expand... But do you mean to query the db directly from the outside (and therefore the provider should allow access on a certain address/port), or can you install something on the db server side? And if you could do it, what programming environment are you allowed to use? Usually there is always a php interpreter available, but it would be interesting to understand if you can install some of your own programs or not
bskotu555 Active Member Oct 23, 2024 #5 amorosik said: But do you mean to query the db directly from the outside (and therefore the provider should allow access on a certain address/port), or can you install something on the db server side? And if you could do it, what programming environment are you allowed to use? Usually there is always a php interpreter available, but it would be interesting to understand if you can install some of your own programs or not Click to expand... I installed MySQL database on Tencent Cloud server, opened port 3306, set the command to allow remote access, and created a data table in the database. This way, I can remotely access the database using an online app and perform operations such as adding and deleting data Upvote 0
amorosik said: But do you mean to query the db directly from the outside (and therefore the provider should allow access on a certain address/port), or can you install something on the db server side? And if you could do it, what programming environment are you allowed to use? Usually there is always a php interpreter available, but it would be interesting to understand if you can install some of your own programs or not Click to expand... I installed MySQL database on Tencent Cloud server, opened port 3306, set the command to allow remote access, and created a data table in the database. This way, I can remotely access the database using an online app and perform operations such as adding and deleting data
udg Expert Licensed User Longtime User Oct 24, 2024 #6 Beware that disassembling your app, anyone will have the credentials and the ip/server to connect to your db. That means the same level of access of yours. Upvote 0
Beware that disassembling your app, anyone will have the credentials and the ip/server to connect to your db. That means the same level of access of yours.
josejad Expert Licensed User Longtime User Oct 24, 2024 #7 bskotu555 said: I installed MySQL database on Tencent Cloud server Click to expand... [B4XPages] jRDC2 + MySql CRUD + Login Hi all: I'm starting (at last) to work with B4XPages, so I've started to adapt the B4XPages + B4XDrawer example. I think I’ve seen more examples with php + mysql, but no projects with Jrdc2. Maybe the dummy data and the UI are too basic, but you can get some ideas. What do we need? - A... www.b4x.com bskotu555 said: opened port 3306 Click to expand... Close it, it's not secure. Or at least restrict its use to a single IP address with the firewall, in order to be able to do maintenance work with HeidiSQL or similar. Upvote 0
bskotu555 said: I installed MySQL database on Tencent Cloud server Click to expand... [B4XPages] jRDC2 + MySql CRUD + Login Hi all: I'm starting (at last) to work with B4XPages, so I've started to adapt the B4XPages + B4XDrawer example. I think I’ve seen more examples with php + mysql, but no projects with Jrdc2. Maybe the dummy data and the UI are too basic, but you can get some ideas. What do we need? - A... www.b4x.com bskotu555 said: opened port 3306 Click to expand... Close it, it's not secure. Or at least restrict its use to a single IP address with the firewall, in order to be able to do maintenance work with HeidiSQL or similar.
bskotu555 Active Member Oct 24, 2024 #8 udg said: Beware that disassembling your app, anyone will have the credentials and the ip/server to connect to your db. That means the same level of access of yours. Click to expand... Yes, data security is very important. The APP will eventually run within the local area network, and security will be guaranteed. Upvote 0
udg said: Beware that disassembling your app, anyone will have the credentials and the ip/server to connect to your db. That means the same level of access of yours. Click to expand... Yes, data security is very important. The APP will eventually run within the local area network, and security will be guaranteed.
bskotu555 Active Member Oct 24, 2024 #9 josejad said: [B4XPages] jRDC2 + MySql CRUD + Login Hi all: I'm starting (at last) to work with B4XPages, so I've started to adapt the B4XPages + B4XDrawer example. I think I’ve seen more examples with php + mysql, but no projects with Jrdc2. Maybe the dummy data and the UI are too basic, but you can get some ideas. What do we need? - A... www.b4x.com Close it, it's not secure. Or at least restrict its use to a single IP address with the firewall, in order to be able to do maintenance work with HeidiSQL or similar. Click to expand... Okay, we will set up the firewall today Upvote 0
josejad said: [B4XPages] jRDC2 + MySql CRUD + Login Hi all: I'm starting (at last) to work with B4XPages, so I've started to adapt the B4XPages + B4XDrawer example. I think I’ve seen more examples with php + mysql, but no projects with Jrdc2. Maybe the dummy data and the UI are too basic, but you can get some ideas. What do we need? - A... www.b4x.com Close it, it's not secure. Or at least restrict its use to a single IP address with the firewall, in order to be able to do maintenance work with HeidiSQL or similar. Click to expand... Okay, we will set up the firewall today
