[Chicago-talk] Dreamweaver perl and mysql

Thu Jul 30 07:39:16 PDT 2015

Why are you logged in as root?

On Thu, Jul 30, 2015 at 9:14 AM, Richard Reina <gatorreina at gmail.com> wrote:

> When I try:
>
> #!/usr/bin/perl
>
> # In your Dancer app,
> use Dancer::Plugin::SimpleCRUD;
>
> # Simple example:
> simple_crud(
>     record_title => 'Widget',
>     prefix => '/widgets',
>     db_table => 'widgets',
>     editable => 1,
> );
>
> I get:
>
> root at gemini:/home/richard/dancer# perl simple_CRUD.pl
> Use of uninitialized value in concatenation (.) or string at
> /usr/local/share/perl/5.14.2/Dancer/Plugin/Database/Core.pm line 199.
>
> Any idea what I am doing wrong?
>
>
>
>
> 2015-07-29 20:00 GMT-05:00 Doug Bell <madcityzen at gmail.com>:
>
>> Similar to the Dancer tutorial, here's a Mojolicious tutorial:
>> http://mojolicio.us/perldoc/Mojolicious/Guides/Tutorial#Hello-World
>>
>> If you have questions and want real-time help, the Chicago.PM has an IRC
>> channel as well on irc.perl.org #chicago.pm (
>> http://mibbit.com/?channel=%23chicago.pm&server=irc.perl.org
>> <http://mibbit.com/?channel=#chicago.pm&server=irc.perl.org>), though it
>> is kind of slow (I'm preaction). There are Catalyst (#catalyst), Dancer
>> (#dancer), and Mojolicious (#mojo) help channels on irc.perl.org as
>> well, and mailing lists for both if e-mail is better.
>>
>> Doug Bell
>> madcityzen at gmail.com
>>
>>
>>
>> On Jul 29, 2015, at 5:41 PM, Richard Reina <gatorreina at gmail.com> wrote:
>>
>> 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 listChicago-talk at pm.orghttp://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 listChicago-talk at pm.orghttp://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 listChicago-talk at pm.orghttp://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
>>
>>
>>
>> _______________________________________________
>> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/chicago-talk/attachments/20150730/2dfbd8ee/attachment-0001.html>