[Chicago-talk] Dreamweaver perl and mysql

Thu Jul 30 07:47:55 PDT 2015

Installed as root. Forgot to go back to user. Same happens when I execute
as $.

2015-07-30 9:39 GMT-05:00 Joel Limardo <joel.limardo at forwardphase.com>:

> 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
>>
>
>
>
>
>
> _______________________________________________
> 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/4575b17f/attachment-0001.html>