Learn More
Resend Email
6
brunofontes
7y

#Question

I never worked directly developing. All my experience is by myself: I try things, they can work or not. So when I am writing a new site/app, I always have millions of doubts of how should I proceed with X or Y.

EXAMPLE: I am dealing of data from a mySQL in a PHP website right now, so I never know how should I treat it. Should I use a function to get data from database and return an array with all fields? Is there a better way?

So my question is: where can I learn that kind of thing? Is there any specific book you recommend? Is there a website? Another way to learn this?

It is easy to me to learn about commands and the programming language itself. There are plenty of books and websites, but I could never find an answer to these questions I have.

Thank you so much in advance!

undefined

advice

novice

php
Favorite
Ranter
Comments
  • 3
    7y
    The best way is to find a job or a hacker space where you can learn from your seniors. There are so many things someone with years of experience can teach you.

    Most tutorials are revolving around the hello world. In practice, you rarely have problems which are that easy.
  • 1
    7y
    well... each problem requires a different way to handle. For example, in the problem you gave, you have two expensive transactions; db's I/O and sending the database query. Provided the mean frequency of the calls you have to do to the database and the most used fields in each set of records you have to figure out a decent solution. You can read more of those in db technology books ;)
  • 1
    7y
    @kpenc yeah, that is exactly my problem. As I have a full time job, a rent to pay, wife and a daughter, I do not have time or the opportunity to work as an intern or something like that and get these best practices.

    These online tutorials are really basic. Most focus on commands or a really small data (name and age of 2 people), for example.

    Thanks for your help, I will try to find any of these hacker spaces here (Rio/Brazil) and how it work on weekends. :)
  • 0
    7y
    @Litarhis Thank you so much! :) I will try some DB books.

    Yes, for this scenario, I do not want to go back at the database every single time and I will use all data at once, so I want to get them all at once. :)
  • 4
    7y
    @brunofontes without getting involved with real projects (paid or internship work) beyond the standard tutorials, I could only really offer looking at some of the major frameworks and seeing how they handle use cases along the lines your looking for or jumping into some open source projects maybe?

    Big database queries can be tolling as @Litarhis mentioned, finding the right way to handle that data comes from a lot of trial and error.
  • 3
    7y
    @brunofontes it sounds like you want to use mysql’s seek function

    http://php.net/manual/en/...
  • 0
    7y
    @enen yes, I did never develop with other people, so my experience is very limited.

    It's hard to know if what you are doing is a good or terrible things if there are no one to tell you that.

    I've tried to take a look on some open source codes, but I could not find anything close to what I am doing and I had really hard time trying to understand these big project, with lots of files, functions, classes that I am not used to work with.

    I should have to try harder to understand these open source codes, but I asked here on devRant if there is a better way, first. :)
  • 1
    7y
    @jpat82792 That really helps! I will read these books asap.

    Thank you so much! :)
  • 1
    7y
    Maybe using some framework could help. You can learn how other devs work on the same tool and create some confidence.

    I mean, like learning the MVC way of Laravel or something like that, for example.
  • 2
    7y
    I would recommend to try "Head First" books for trying to learn something new. These books don't contain all things in that particular language/technology, but you'll learn some practical aspect of using the language. Then you can check all other possibilities to grow your knowledge base.
  • 0
    7y
    @Superlandero I will try that too! :) Thank you!
  • 0
    7y
    @paKanhu Wow! That might work too! Thank you! :)
  • 2
    7y
    And maybe this will help you as much as it helps me.

    https://github.com/jupeter/...
  • 1
    7y
    @CurseMeSlowly that's just perfect! :) Thank you!
  • 3
    7y
    @CurseMeSlowly after reading this amazing link and after seen another rant here about the clean code book, I tried to read it.

    I just finished and I learn so many things that I would never be able to learn without working in a development company.

    I am creating better code, cleaner, easier and it is helping me at work. Besides I do not work coding, I usually code on free time to help me and my work colleagues. So it is changing my life, as I am coding more and more each day at work and at home.

    So I just wanna say thank you. And that you, @sbin!
Related Rants
devRant © 2021 Hexical Labs LLC
Privacy Policy  |  Terms of Service
Add Comment