Current Events > ProgrammingGeneral++

(+) Yeah! (+)

1337toothbrush posted...

If you want to get experience with databases, I suggest starting with a relational database (e.g. Postgres, MySQL, etc) rather than a NoSQL database like MongoDB.

I've always wanted to learn MySQL, but not sure how to relate it or hook it into anything I'm doing. I took a veeeery basic class on database design and own another course on Udemy. Is there a decent way to get started?
I would love to, for instance, organize some of my gacha drops in some games. Or have a database of enemies and skills I can pull into my game, though I'm not sure how.

1337toothbrush posted...

If you want to get experience with databases, I suggest starting with a relational database (e.g. Postgres, MySQL, etc) rather than a NoSQL database like MongoDB.

I definitely want to learn MySQL. I'm just following this course, for now.

SomeLikeItHoth posted...

I definitely want to learn MySQL.

I could teach you the guts of mysql in a day.
The relationships are dead simple. The queries are not.

I've been doing various flavors of SQL for fifteen or twenty years now, and you're better off punting it to multiple server-side queries than trying to compose a great query all at once.

Questionmarktarius posted...

I could teach you the guts of mysql in a day.

I may take you up on that some day.

Right now I'm trying to break into the programming career world. Started learning Python but recently made the switch to front end development. I've been following this bootcamp series on Udemy which has taught me a lot of stuff, but I feel like I'm lacking actual guidance. I don't know exactly what I should be studying, I'm just following along. I'll be done with this course by the end of the month, but I don't know where to go from there. I know I'll need to continue learning, but that learning mainly consists of me googling what I should be doing next.

SomeLikeItHoth posted...

I may take you up on that some day.

Just ask.

Right now I'm trying to break into the programming career world.

I cut my teeth on Pascal when it was already irrelevant, went on to C++ and java. Somehow picked up cobol and fortran along the way.
I make my living coding php in LAMP environments.

Bump.
Working on MySQL and A+ classes. Probably going to code tomorrow.

I've just started learning Java for school, and I'm also getting into Python on my own time for data analytics. It's more fun than I expected it to be which is nice. I don't have any personal projects in mind yet though
@SomeLikeItHoth you mentioned books earlier in the thread. Would you have any recommendations for me?

@Harpie

Im sick, so when I can Ill recommend you more, but start with Python Crash Course. Its an amazing book. I think its $20 on Amazon which is a total steal. I read through it once last year, and I may do so again as a refresher.

ChocoboMog123 posted...

I've always wanted to learn MySQL, but not sure how to relate it or hook it into anything I'm doing. I took a veeeery basic class on database design and own another course on Udemy. Is there a decent way to get started?
I would love to, for instance, organize some of my gacha drops in some games. Or have a database of enemies and skills I can pull into my game, though I'm not sure how.

To be fair, a relational database can be overkill for that. I typically go for a custom file-based format for simple data persistence.

i've been professionally using Java for 16 years. feel free to ask me stuff

1337toothbrush posted...

To be fair, a relational database can be overkill for that. I typically go for a custom file-based format for simple data persistence.

So I have this data I've been storing in a google sheet: https://docs.google.com/spreadsheets/d/1xx-n3TFnBE4Ha8rhYo0YXUT7yRyJSUU44dEOMzB2Dm0/edit?usp=sharing
If you navigate to the "Owned Relics" tab, you'll see most of the grunt work. Is there a better, more accessible, more easily updated way to store that data?

ChocoboMog123 posted...

So I have this data I've been storing in a google sheet: https://docs.google.com/spreadsheets/d/1xx-n3TFnBE4Ha8rhYo0YXUT7yRyJSUU44dEOMzB2Dm0/edit?usp=sharing
If you navigate to the "Owned Relics" tab, you'll see most of the grunt work. Is there a better, more accessible, more easily updated way to store that data?

Are you running into any problems with your current setup? If you wanted to use this data programmatically, you could always access this data through Google's API: https://developers.google.com/sheets/api

The limitation would be that you'd need to be connected to the internet. If you wanted to migrate this data offline, you could do so in a number of ways, but it really depends on how you're planning on organizing and accessing this data.

1337toothbrush posted...

Are you running into any problems with your current setup? If you wanted to use this data programmatically, you could always access this data through Google's API: https://developers.google.com/sheets/api

The limitation would be that you'd need to be connected to the internet. If you wanted to migrate this data offline, you could do so in a number of ways, but it really depends on how you're planning on organizing and accessing this data.

Yeah, it's all sorted in a rather specific order and if I want to add an entry I have to drag all the entries below it, crtl+x, crtl+v. I guess I could create a sheet for each column and then create a way to view what I want...

I've been working all day on little bits of my Java game. Having big issues pushing(?) it to GitHub. Here's a gist: https://gist.github.com/TurquoisePenguin/743473ea715cbae3b66cef3f29c560f7
Changelog:
Tested and finished (fight method):
- display enemies
- display actions
- select actions (input)
- determine turn order

Partially implemented:
- perform actions

TODO: Have each class read in actions and proceed accordingly.

Sorry for the triple post. How do I select an action based on input?

I was planning on making methods for every character's action. Depending on what you do, the code would run Player.attack(), or Player.castFireball(), or maybe Player.cast(fireball). I really don't want to make a switch-case for every single action, especially since those choices can change as you progress. What's a clean way to do this?

ChocoboMog123 posted...

Yeah, it's all sorted in a rather specific order and if I want to add an entry I have to drag all the entries below it, crtl+x, crtl+v. I guess I could create a sheet for each column and then create a way to view what I want...

Couldn't you sort the columns by this specific order? At the very least you could assign a number and then sort by that number.

You could also move the data to a relational database and run sorts and queries that way.

ChocoboMog123 posted...

Sorry for the triple post. How do I select an action based on input?

I was planning on making methods for every character's action. Depending on what you do, the code would run Player.attack(), or Player.castFireball(), or maybe Player.cast(fireball). I really don't want to make a switch-case for every single action, especially since those choices can change as you progress. What's a clean way to do this?

You could have an array of actions that you can slot actions into. You'll have to structure it such that each action is the same type.