[Chicago-talk] Dreamweaver perl and mysql

Wed Jul 29 15:41:26 PDT 2015

Alan,

For this thorough and thoughtful reply. The dancer tutorial looks less intimidating than the catalyst examples I looked at. I will get started by trying to create a simple CRUD page that will allow me to play with a database. 

Thank you

> El jul 29, 2015, a las 4:35 PM, Alan Mead <amead2 at alanmead.org> escribió:
> 
> 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>:
>>> 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>:
>>>>> 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
>>>>>> 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
>>>>> 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
>>> 
>>> _______________________________________________
>>> Chicago-talk mailing list
>>> 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
> _______________________________________________
> Chicago-talk mailing list
> Chicago-talk at pm.org
> http://mail.pm.org/mailman/listinfo/chicago-talk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/chicago-talk/attachments/20150729/1c8b1e2c/attachment-0001.html>