Database Connections

[someguy567]

For those of you that have used a Database for your bots, how have you dealt with having lots of connections to your database? Did you use a database pool? Because I tried using one and OSBot just denies me from using it in the script

[KEVzilla]

Why would you need to use a database?

[Tom]

14 minutes ago, someguy567 said:

For those of you that have used a Database for your bots, how have you dealt with having lots of connections to your database? Did you use a database pool? Because I tried using one and OSBot just denies me from using it in the script

Scripters host a PHP file on their webserver and submit data through that

 

	URL submit = new URL(http://yoururl.com/uploaddata.php?name=dog&expgained=1");
				
				URLConnection con = submit.openConnection();
				con.setDoInput(true);
				con.setDoOutput(true);
				con.setUseCaches(false);
				final BufferedReader rd = new BufferedReader(
						new InputStreamReader(con.getInputStream()));
				rd.close();

You would then take that data, connect to SQL or w.e and process it on the server side

Edited November 13, 2018 by Tom

[Medusa]

39 minutes ago, Tom said:

Scripters host a PHP file on their webserver and submit data through that

 

	URL submit = new URL(http://yoururl.com/uploaddata.php?name=dog&expgained=1");
				
				URLConnection con = submit.openConnection();
				con.setDoInput(true);
				con.setDoOutput(true);
				con.setUseCaches(false);
				final BufferedReader rd = new BufferedReader(
						new InputStreamReader(con.getInputStream()));
				rd.close();

You would then take that data, connect to SQL or w.e and process it on the server side

What he said. Just make an API using whatever web-development languages you know, and use that to do whatever you need.

53 minutes ago, KEVzilla said:

Why would you need to use a database?

Also, databases are used for a lot of stuff. Automatic account switching, muling, statistics of your botting etc.

[KEVzilla]

8 minutes ago, Medusaa said:

What he said. Just make an API using whatever web-development languages you know, and use that to do whatever you need.

Also, databases are used for a lot of stuff. Automatic account switching, muling, statistics of your botting etc.

I am very aware, lol. Figured he wanted to run his database locally

[someguy567]

No, I want to stick with just using the DB

[KEVzilla]

32 minutes ago, someguy567 said:

No, I want to stick with just using the DB

What do you want to save? Is it user specific?

[someguy567]

I already have the DB and i'm using it. I just want to be able to handle connections more efficiently. But I can't use any libraries for connection pooling since OSBot blocks the use of other libraries

 

[liverare]