camelCase 220 Share Posted October 2, 2021 Last week i built a class to use in my scripts to send in game info to a psql database then have that database displayed on a heroku free webapp so i could monitor my bots from anywhere in the world this is the class i made, note method sendLog() has alot of values hard coded and will likely need to be modified / removed if you're to use this for yourself https://github.com/Amoz3/DatabaseDB3/blob/master/src/main/java/classes/Database.java this is the PERN app i made to display my data, this should be ready to go to deploy to heroku w/ heroku postgres https://github.com/Amoz3/botting-logs-PERN-app heres an example script i made showing how i use the class https://github.com/Amoz3/Sardine-buyer-DatabaseDB3-example couple screenshots the gold atop the table is total gold, task is just like status for onpaint, age was grabbed using https://github.com/Amoz3/AgeDB3/blob/master/src/classes/Age.java this is pretty unorganised so if you have any questions or want help setting this up yourself dm me on here or @ Austin! (Smart!) (Cute!)#3057 on discord Link to comment Share on other sites More sharing options...
Neffarion 485 Share Posted October 2, 2021 Please don't store your db credentials in your script. This will go wrong if you do Link to comment Share on other sites More sharing options...
camelCase 220 Author Share Posted October 2, 2021 1 hour ago, Neffarion said: Please don't store your db credentials in your script. This will go wrong if you do not really concerned about it, database just stores same information thats on script paint not alot anyone could with it Link to comment Share on other sites More sharing options...
camelCase 220 Author Share Posted October 2, 2021 Just now, camalCase said: not really concerned about it, database just stores same information thats on script paint not alot anyone could with it & resetting heroku postgres creds is 1 button press on control panel Link to comment Share on other sites More sharing options...
TheCloakdOne 389 Share Posted October 2, 2021 Rather than running inserts direct to DB your better off parsing the logfiles when scaling and using something like elasticsearch Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.