[Chicago-talk] Dreamweaver perl and mysql

Thu Jul 30 07:14:49 PDT 2015

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/chicago-talk/attachments/20150730/346554f2/attachment-0001.html>