in reply to Re^2: What Do Monks Think of SQL Query Builders?
in thread What Do Monks Think of SQL Query Builders?

"I grow tired of learning it one year and then relearning it the next."

You would feel the same about Perl if you treated it the same way.

"And I'm particularly intrigued by the idea of being able to write a simple line of Perl code and have all the heavy lifting done for me."

Generating SQL is not heavy lifting. Generating a robust schema that modules your entities and their relationships is the key here, and there is no substitution for learning this.

Go get some education! Search for "Intro to SQL: Querying and managing data" over at Kahn.

  • Comment on Re^3: What Do Monks Think of SQL Query Builders?

Replies are listed 'Best First'.
Re^4: What Do Monks Think of SQL Query Builders?
by nysus (Parson) on Feb 08, 2017 at 22:49 UTC

    I do kind of feel the same way about Perl. However, I've used it much more frequently than SQL. But I do find that it gets easier and easier to get back on the Perl horse each time I come back to it. I love using it.

    I've read a book or two or three or four (ok, not cover to cover, admittedly) over the years on databases. For the kind of basic applications I write and with the dabbling I've done over the years, and with some help of existing websites, I can probably get by with the knowledge I have retained and create a decent schema; probably not the ideal one, but one that works good enough. Writing a perfect one can only come with lots and lots of practice.

    Unfortunately, I have only limited time. So I'm just looking for some advice and learn from far more experienced programmers to help me to avoid unnecessary pain. I've found PerlMonks to be very beneficial in that respect. For example, I first learned about Moose last year here on PerlMonks and I am blown away by it. I love programming with it. So I greatly appreciate hearing these kinds of thoughts on best way to implement SQL. It all gives me food for thought. Thanks.

    $PM = "Perl Monk's";
    $MCF = "Most Clueless Friar Abbot Bishop Pontiff Deacon Curate";
    $nysus = $PM . ' ' . $MCF;
    Click here if you love Perl Monks

[reply]

In Section Seekers of Perl Wisdom