[Chicago-talk] Dreamweaver perl and mysql

Alan Mead amead2 at alanmead.org
Wed Jul 29 14:35:19 PDT 2015


Web development is quite different from an app running on a server or
desktop. Part of the reason that frameworks seem different is driven by
this environmental difference which is inevitable.

I can see why someone who knows well Perl might not like the idea of
using a framework, because learning the framework is almost like
learning to code a new language (in a way).  But consider that if you
were to re-invent the same wheel, you would make a number of mistakes
that the framework builders have already mastered. Also, the frameworks
will already have a number of features that you can just mix in. If you
re-invent the wheel, you'll have to re-invent each feature that you want
to add.  For example, authentication isn't a trivial issue. You haven't
mentioned authentication, but I assume you don't want everyone on the
Internet to be able to edit your clients' records. Any framework is
likely to have authentication built in.  Another example: a CRUD website
is really, really common so you should find it very easy... I found this
page that describes a sample Dancer app that seems to do at least some
of what you want:

http://advent.perldancer.org/2011/2

Another emphasis of modern frameworks is making it really easy to use. 
The page above shows you how to run the Dancer app using an embedded
webserver.  So, you don't need to learn about web servers, etc.; you can
dive right in.

Dreamweaver is fine for creating the HTML but any approach to building a
dynamic website is going to require that you learn enough HTML to create
templates. In the example app described above, the templates are in the
/view folder.  If you've mastered Perl and SQL, HTML isn't going to be a
big problem, but there's no avoiding it.

-Alan


On 7/29/2015 3:48 PM, Richard Reina wrote:
> Your response if good. It's that I don't really understand what a
> framework is. I've built a website with dreamweaver (without knowing
> any html). Now I would just like to build another small site that
> links to a MySQL database. I see a lot of people use php but since I
> already know perl and DBI I figured I could go that route. I'm just
> confused about what these frameworks are (catalyst, mojolicious,
> dancer) and how they fit in. Maybe I can hire a reasonably priced tutor ;)
>
>
> 2015-07-29 15:34 GMT-05:00 Alan Mead <amead2 at alanmead.org
> <mailto:amead2 at alanmead.org>>:
>
>     Well, I don't want to discourage you (or be a jerk) but when you
>     state that you "don't know HTML" it seems like any web-based
>     project is going to be way, way, way over your head.
>
>     There are a million ways to accomplish the site you want.  Using a
>     framework would be better for many people, but you'd have to learn
>     the framework.  If you want to learn as little as possible, then
>     you might want to make some simple CGI scripts but that approach
>     will require learning about how Apache works (at least a bit). You
>     could also use PHP.
>
>     -Alan
>
>
>
>     On 7/29/2015 3:14 PM, Richard Reina wrote:
>>     Wow just took a look at catalyst. Seems easier to just stick with
>>     Dreamweaver and access my MySQL tables with php -- if you are
>>     saying I can't do so with perl.
>>
>>
>>
>>     2015-07-29 12:52 GMT-05:00 Alan Mead <amead2 at alanmead.org
>>     <mailto:amead2 at alanmead.org>>:
>>
>>         Richard,
>>
>>         You'll need to learn enough HTML to transform your
>>         Dreamweaver output files into templates. There are many ways
>>         to do this but you probably want a framework like Mojolicious
>>         or Catalyst.  I see that the Catalyst tutorial includes the
>>         kind of website you want to build (as "CRUD"):
>>
>>         https://metacpan.org/pod/Catalyst::Manual::Tutorial
>>         https://metacpan.org/pod/Catalyst::Manual::Tutorial::04_BasicCRUD
>>
>>         I'm also sure you could do this using Mojolicious.  But,
>>         again, you're SOL unless you're willing to learn how to work
>>         with these technologies.
>>
>>         -Alan
>>
>>
>>
>>
>>         On 7/29/2015 11:55 AM, Richard Reina wrote:
>>>         I do not know HTML. I have created a website with
>>>         dreamweaver that mostly just looks pretty and and jumps to
>>>         different pages on a site. I have also written a database
>>>         app with perl->MySQL that users on a small LAN can use to
>>>         enter and query data. However, it is displayed on linux
>>>         consoles using rudimentary menu apps based on curses. I
>>>         would like to create a website that would allow users to
>>>         enter and query data from MySQL databases and carry out
>>>         functions such as updating users via email when changes are
>>>         made. Since I don't know HTML or Apache can I just use
>>>         dreamweaver and somehow enter perl code to talk to MySQL? Or
>>>         is there a better and easier way for me to go about this?
>>>
>>>         Thanks for any ideas.
>>>
>>>         Richard 
>>>
>>>
>>>         _______________________________________________
>>>         Chicago-talk mailing list
>>>         Chicago-talk at pm.org <mailto:Chicago-talk at pm.org>
>>>         http://mail.pm.org/mailman/listinfo/chicago-talk
>>
>>         -- 
>>
>>         Alan D. Mead, Ph.D.
>>         President, Talent Algorithms Inc.
>>
>>         science + technology = better workers
>>
>>         +815.588.3846 (Office)
>>         +267.334.4143 (Mobile)
>>
>>         http://www.alanmead.org
>>
>>         Announcing the Journal of Computerized Adaptive Testing (JCAT), a
>>         peer-reviewed electronic journal designed to advance the science and
>>         practice of computerized adaptive testing: http://www.iacat.org/jcat
>>
>>
>>         _______________________________________________
>>         Chicago-talk mailing list
>>         Chicago-talk at pm.org <mailto:Chicago-talk at pm.org>
>>         http://mail.pm.org/mailman/listinfo/chicago-talk
>>
>>
>>
>>
>>     _______________________________________________
>>     Chicago-talk mailing list
>>     Chicago-talk at pm.org <mailto:Chicago-talk at pm.org>
>>     http://mail.pm.org/mailman/listinfo/chicago-talk
>
>     -- 
>
>     Alan D. Mead, Ph.D.
>     President, Talent Algorithms Inc.
>
>     science + technology = better workers
>
>     +815.588.3846 (Office)
>     +267.334.4143 (Mobile)
>
>     http://www.alanmead.org
>
>     Announcing the Journal of Computerized Adaptive Testing (JCAT), a
>     peer-reviewed electronic journal designed to advance the science and
>     practice of computerized adaptive testing: http://www.iacat.org/jcat
>
>
>     _______________________________________________
>     Chicago-talk mailing list
>     Chicago-talk at pm.org <mailto:Chicago-talk at pm.org>
>     http://mail.pm.org/mailman/listinfo/chicago-talk
>
>
>
>
> _______________________________________________
> Chicago-talk mailing list
> Chicago-talk at pm.org
> http://mail.pm.org/mailman/listinfo/chicago-talk

-- 

Alan D. Mead, Ph.D.
President, Talent Algorithms Inc.

science + technology = better workers

+815.588.3846 (Office)
+267.334.4143 (Mobile)

http://www.alanmead.org

Announcing the Journal of Computerized Adaptive Testing (JCAT), a
peer-reviewed electronic journal designed to advance the science and
practice of computerized adaptive testing: http://www.iacat.org/jcat

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/chicago-talk/attachments/20150729/0f59f1ac/attachment-0001.html>


More information about the Chicago-talk mailing list