[htmltmpl] ANNOUNCE: Krang v2.005 Released

2006-06-02 Thread Sam Tregar
Krang v2.005 is now available. Notable changes in this release and in v2.004, which never received a proper announcement: * Added enforcement of permissions at the application and run-mode level rather than just at the UI level. [Michael Peters] * Fixed Xinha link-munging so that you

ANNOUNCE: Krang v2.005 Released

2006-06-02 Thread Sam Tregar
Krang v2.005 is now available. Notable changes in this release and in v2.004, which never received a proper announcement: * Added enforcement of permissions at the application and run-mode level rather than just at the UI level. [Michael Peters] * Fixed Xinha link-munging so that you

Re: [htmltmpl] Parsing bug under Perl 5.6.1, and a fix

2006-05-23 Thread Sam Tregar
On Tue, 23 May 2006, Josh Clark wrote: Here's a strange bug that I encountered while running HTML::Template 2.8 under Perl 5.006001 (doesn't happen in the various flavors of 5.8 that I've tried). Sounds like a good reason to upgrade. The problem appears to be related to the uc function in

Re: [htmltmpl] Small questions.

2006-05-18 Thread Sam Tregar
On Thu, 18 May 2006, Matias Alejo Garcia wrote: Maybe a good option would be to use 'memcached' (Cache::Memcached, which can also be shared in the distributed environment, and is very easy to manage) instead of IPC. What you think? Seems like a fun project, if possibly self-defeating. I

Re: [htmltmpl] Small questions.

2006-05-17 Thread Sam Tregar
On Wed, 17 May 2006, Matias Alejo Garcia wrote: So, some of our pages include 200 templates (we use shared_cached=1). These 'include' strategy helps our designer because its HTML code is reutilized over and over. Would you say this is a correct approach? What about performace? I know be need to

Re: [htmltmpl] Small questions.

2006-05-17 Thread Sam Tregar
On Wed, 17 May 2006, Matias Alejo Garcia wrote: Are you using caching? Are you pre-caching your templates during server startup? If so then you can have as many includes as you want and it won't make a bit of difference at runtime. Yes, we are using shared_cached. We are no precaching, but

[cgiapp] ANNOUNCEMENT: CGI::Application::Plugin::RateLimit v1.0

2006-05-04 Thread Sam Tregar
CHANGES - First release! DESCRIPTION This module provides protection against a user calling a runmode too frequently. A typical use-case might be a contact form that sends email. d like to allow your users to send you messages, but thou- sands of messages from a single

[cgiapp] RFC2: CGI::Application::Plugin::RateLimit

2006-05-03 Thread Sam Tregar
() or protected_modes() for the violated mode/action. =head1 AUTHOR Sam Tregar, [EMAIL PROTECTED] =head1 COPYRIGHT AND LICENSE Copyright (C) 2006 by Sam Tregar This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.6

Re: [cgiapp] RFC2: CGI::Application::Plugin::RateLimit

2006-05-03 Thread Sam Tregar
On Wed, 3 May 2006, Cees Hek wrote: Nothing that is needed for a first version, but as an alternative to 'protected_modes' it might be nice to also allow that info to be provided in an attribute. It keeps the information close to where it is actually applied: sub send :RateLimit(max_hits=5,

[cgiapp] RFC: CGI::Application::Plugin::RateLimit

2006-05-02 Thread Sam Tregar
creation. =head1 INTERFACE To be filled in before coding. For now, read the SYNOPSIS. =head1 AUTHOR Sam Tregar, [EMAIL PROTECTED] =head1 COPYRIGHT AND LICENSE Copyright (C) 2006 by Sam Tregar This library is free software; you can redistribute it and/or modify it under the same terms as Perl

Re: [cgiapp] RFC: CGI::Application::Plugin::RateLimit

2006-05-02 Thread Sam Tregar
On Tue, 2 May 2006, Michael Peters wrote: # set the table name to use for storing hits $rate_limit-table('rate_limit_hits'); It might be nice if there was a reasonable default for this table name. Apache::Session and CGI::Session both default to 'sessions' but can be changed. Sure,

Re: [cgiapp] RFC: CGI::Application::Plugin::RateLimit

2006-05-02 Thread Sam Tregar
On Tue, 2 May 2006, Michael Peters wrote: Hmmm. How would that method indicate a violation? It's not obvious to me how that would interact with 'violation_mode', for example. Good point. Maybe a check_violation() companion to record_hit()? my %limit_args = ( user = $user_id, action =

Re: [htmltmpl] ESCAPE=XML

2006-04-26 Thread Sam Tregar
On Wed, 26 Apr 2006, Jim Spath wrote: Just joined the list... excuse me if this has been posted before, but I didn't find a good way to search the mailing list archives. I use HTML::Template for XML templates frequently, and think that ESCAPE=XML would be a useful addition. So far as I know

Re: [htmltmpl] H::T::Expr and escape

2006-04-18 Thread Sam Tregar
On Fri, 14 Apr 2006, Michael Peters wrote: I'll try my simple approach and see how that works first. This is a very simple (naive?) approach, so I may have missed something, but it seems to work. Thanks, applied! -sam --- This SF.Net

[htmltmpl] ANNOUNCE: HTML::Template::Expr v0.07

2006-04-18 Thread Sam Tregar
CHANGES - Added support for ESCAPE attribute in combination with EXPR. (Michael Peters) - Fixed a bug where functions which returned 0 or more than one return value would cause a stack under or overflow. Functions are now called in scalar context, eliminating the

Re: [htmltmpl] H::T::Expr and escape

2006-04-14 Thread Sam Tregar
On Fri, 14 Apr 2006, Michael Peters wrote: So by making the parser smart enough do you mean copying that huge regex from H::T and modifying it with the expr regex? Yeah, or using Parse::RecDescent. H::T::E already uses it for expressions, so using it for parsing the template itself might not

Re: [htmltmpl] H::T::Expr and escape

2006-04-14 Thread Sam Tregar
On Fri, 14 Apr 2006, Michael Peters wrote: Yeah, that makes sense, I guess I didn't really think it through. Would it make sense though to allow it to be used if the entire expression returned false? No, I don't. Default for normal variables is only used when a value isn't set, false or

Re: [htmltmpl] H::T::Expr and escape

2006-04-13 Thread Sam Tregar
On Thu, 13 Apr 2006, Michael Peters wrote: Is it possible to combine the 'escape' attribute of H::T with H::T::Expr? No, I don't think so. I don't think it would be too hard to add support for it though. HTML::Template supports combining escape and code-ref params, so it'd just be a matter

Re: [htmltmpl] Request/question

2006-03-21 Thread Sam Tregar
On Tue, 21 Mar 2006, Eric Frazier wrote: Is there any way you could change this line in Template.pm from croak to confess? No need to change Template.pm. Just tell Carp you want verbose reports: use Carp qw(verbose); Now all croak()s will have stack traces. -sam

[cgiapp] Re: HTMLTemplate::Expr consumes huge amounts of memory

2006-03-11 Thread Sam Tregar
On Sat, 11 Mar 2006, Dan Horne wrote: I'm using CGI::Application::Plugin::Anytemplate with HTML::Template::Expr for an application, and it uses a heck of a lot of memory. What version of HTML::Template::Expr? Do you have caching turned on? Can you reproduce this problem with a small test

Re: [htmltmpl] Usage question

2006-03-05 Thread Sam Tregar
On Sun, 5 Mar 2006, Matias Alejo Garcia wrote: Is there any way to, once the $template is filled, to dump the variables to a file? Sure. The full parameter set is available via param(): my %data = map { ($_, $template-param($_) } $template-param(); You can dump that hash to a file with

Re: DBI - AnnoCPAN note added

2006-03-05 Thread Sam Tregar
On Fri, 4 Mar 2006, AnnoCPAN notification service wrote: If you got this message, it was because you opted in. Seriously! If you would like to stop receiving notifications, just follow this link: http://annocpan.org/~TIMB/unsubscribe?key=62224112e29622942849a27f77cf8eff Sigh. I just

Possible bug: do() ignores extra bind params

2006-03-05 Thread Sam Tregar
Hey guys. This one has bitten me one too many times. Given this table: CREATE TABLE foo ( foo_id INT, barVARCHAR(255) ); This prepare() and execute() produces a very helpful warning: my $sth = $dbh-prepare(INSERT INTO foo VALUES (?,?)); $sth-execute(1, test 1, too

[htmltmpl] ANNOUNCE: HTML::Template::Expr v0.06

2006-03-03 Thread Sam Tregar
ANNOUNCEMENT: HTML::Template::Expr v0.06 CHANGES - Rewrote grammar to support expressions with less parenthesis. For example, foo || bar || baz now works. DESCRIPTION This module provides an extension to HTML::Template which allows expressions in the template syntax. This is purely

[htmltmpl] Switching to Subversion

2006-02-27 Thread Sam Tregar
I'm switching the HTML::Template CVS repository at SourceForge over to Subversion. You can find access information here: http://sourceforge.net/svn/?group_id=1075 Let me know if you have any problems. -sam --- This SF.Net email is

Re: [htmltmpl] Request for more contextual data to filters and coderef vars

2006-02-27 Thread Sam Tregar
On Sat, 25 Feb 2006, Brad Choate wrote: Hi all-- brand new to the list, but I've been using HTML::Template for some time. Just to quickly introduce myself... I work at Six Apart as one of the engineers of Movable Type. MT uses HTML::Template for all of its application UI. Hey Brad, good to

Why is err_header_out needed to set cookies when redirecting?

2006-02-15 Thread Sam Tregar
Hello all. Check out this bug: my $r = Apache-request; $r-header_out(Set-Cookie = '...cookie here...' ); $r-header_out(Location = '...url here...'); return REDIRECT; Now, we all know that second line has to be err_header_out not header_out, or Apache will silently ignore

Re: Why is err_header_out needed to set cookies when redirecting?

2006-02-15 Thread Sam Tregar
On Wed, 15 Feb 2006, Michael Peters wrote: Now, we all know that second line has to be err_header_out not header_out, or Apache will silently ignore the Set-Cookie directive. I knew it as soon as I saw it, although I couldn't explain why and thus didn't trust my intuition. I looked through the

Re: Why is err_header_out needed to set cookies when redirecting?

2006-02-15 Thread Sam Tregar
On Wed, 15 Feb 2006, Geoffrey Young wrote: in short, because anything other than 200 is considered an error. so REDIRECT (302) forces apache to use the err_headers_out table instead of the headers_out table. why does Location work in headers_out, then, you ask? well, it's an exception to the

Re: [htmltmpl] option to turn ESCAPE=HTML on by default

2005-12-22 Thread Sam Tregar
On Thu, 22 Dec 2005, Alex Kapranoff wrote: Too bad I was late to send additional ESCAPE=none (as a synonym for ESCAPE=0) patch for completeness. It was sleeping time over here between your two mails -- this and release announcement :) Yeah, I wondered if that would be required by

ANNOUNCE: HTML::Template::JIT v0.05

2005-12-22 Thread Sam Tregar
. NOTE This module is not feature-complete. Be sure to read the CAVEATS section in the documentation before using! AVAILABILITY The module is available on CPAN. You can get it using CPAN.pm or go to: http://www.cpan.org/authors/id/S/SA/SAMTREGAR/ CONTACT INFO This module was written by Sam

Re: [htmltmpl] option to turn ESCAPE=HTML on by default

2005-12-21 Thread Sam Tregar
On Tue, 18 Oct 2005, Alex Kapranoff wrote: I added tests for loops and includes, they seem to succeed. Updated patch below. Applied for 2.8, which is coming soon by the way! Thanks, -sam --- This SF.net email is sponsored by: Splunk Inc.

[htmltmpl] ANNOUNCE: HTML::Template::Expr v0.05

2005-12-21 Thread Sam Tregar
CHANGES - Added a compatibility fix required by HTML::Template v2.8. DESCRIPTION This module provides an extension to HTML::Template which allows expressions in the template syntax. This is purely an addition - all the normal HTML::Template options, syntax and behaviors will still work.

ANNOUNCE: HTML::Template v2.8

2005-12-21 Thread Sam Tregar
was written by Sam Tregar ([EMAIL PROTECTED]). You can join the HTML::Template mailing-list by visiting: http://lists.sourceforge.net/lists/listinfo/html-template-users --- This SF.net email is sponsored by: Splunk Inc. Do you grep

[htmltmpl] Re: HTML::Template bug report: Problems using cache

2005-11-29 Thread Sam Tregar
On Tue, 29 Nov 2005, Jozef Kosoru wrote: Since there wasn't any new release for more than one year I would also like to ask you whether this package is still maintanted. It's still maintained, although I'm too busy to spend a lot of time on it right now. Maybe next year... Regarding this

Re: problem with Class-dbi set_up_table function(no primary key error)

2005-10-31 Thread Sam Tregar
On Mon, 31 Oct 2005 [EMAIL PROTECTED] wrote: Hi, sorry to bother you again. I am still trying to load data in my db2 database using class-dbi in a perl script. I am blocked on the dbi set_up_table function called in my script: Chado::Tableinfo-set_up_table('tableinfo'); There are the wrong

Re: [htmltmpl] option to turn ESCAPE=HTML on by default

2005-10-17 Thread Sam Tregar
On Mon, 17 Oct 2005, Alex Kapranoff wrote: One name, one function, please :) default_escape = 'html'. Patch below, with tests. Very cool. diff -ruN /tmp/HTML-Template-2.7/Template.pm HTML-Template-2.7/Template.pm --- /tmp/HTML-Template-2.7/Template.pmFri Jun 18 21:42:06 2004 +++

Re: [htmltmpl] option to turn ESCAPE=HTML on by default

2005-10-14 Thread Sam Tregar
On Fri, 14 Oct 2005, Mark Stosberg wrote: I'm curious about what other people think about an option to turn ESCAPE=HTML on default, to protect against cross script scripting practices by default. Sure, sounds reasonable to me. -sam ---

Re: [htmltmpl] Bug in HTML::Template::Compiled?

2005-10-11 Thread Sam Tregar
On Mon, 10 Oct 2005, Octavian Rasnita wrote: I have noticed that the module HTML::Template::Compiled stores the vars in memory when using mod_perl, and possibly displays them for the next visitor. HTML::Template::Compiled is not generally supported on this list. I don't mind if people talk

Re: Offering a standard set of datetime formats

2005-09-23 Thread Sam Tregar
On Fri, 23 Sep 2005, Dave Rolsky wrote: I don't know of any list, and I'm not sure what type of standard you want. There's standards for computers and standards for humans ;) Both, I suppose. I was looking for an 80% solution to get the ball rolling by allowing the user to pick from a list of

Re: Offering a standard set of datetime formats

2005-09-23 Thread Sam Tregar
On Sat, 24 Sep 2005, Rick Measham wrote: Have a look at the cell formats for dates available in Excel or OOo .. that's probably a fair list of the most common human-dates. That's a good idea. Now if they only came with strptime strings! -sam

Re: [cgiapp] ANNOUNCE: CGI::Application::Plugin::DevPopup 0.01

2005-09-22 Thread Sam Tregar
On Wed, 21 Sep 2005, Michael Peters wrote: I'll poke Sam Tregar to get his DB profiler pop up thingy working with new DevPopup too. http://use.perl.org/~samtregar/journal/25051 Ouch. Now I'll poke Tim Bunce to release a new DBI, which will include a patch needed by the profiler. -sam

Offering a standard set of datetime formats

2005-09-22 Thread Sam Tregar
Hello all. I'm working on an application which will provide a flexible data upload system. Users will upload CSV files containing data from other systems and they'll provide meta-data which will allow the application to load that data into the system. One of the kinds of data I need to support

Re: [htmltmpl] H::T ported to C?

2005-09-14 Thread Sam Tregar
On Wed, 14 Sep 2005, David Kaufman wrote: Has anyone tried this XS implementation of HTML::Template? http://search.cpan.org/~viy/HTML-Template-Pro-0.50/ I'm interested to hear whether it is really 10-25 times faster than pure-perl HTML::Template and/or really 1-3 times faster than H::T with

Re: [cgiapp] RFC: CGI::Application::Plugin::XSV

2005-09-14 Thread Sam Tregar
On Wed, 14 Sep 2005, Evan A. Zacks wrote: I'd like to request some comments/criticism for a new module I'm working on, CGI::Application::Plugin::XSV. This module provides a simple method for producing csv output via Text::CSV_XS. This looks quite useful to me. This will send csv output to

Re: Lost connection error with prepare_cached

2005-09-11 Thread Sam Tregar
On Sun, 11 Sep 2005, Tim Bunce wrote: Child process will inherit the parents db connection and $dbh. When the child process exits perl will DESTROY all objects, included the inherited $dbh. That will disconnect the mysql socket connection 'behind the back' of the parent. You must set

Lost connection error with prepare_cached

2005-09-10 Thread Sam Tregar
Hello all. I'm trying to solve a bug in a daemon which uses multiple processes to handle jobs in a queue. The code is bound up in a rather large Class::DBI app which makes posting a sample difficult. The error I'm getting is this: DBD::mysql::st execute failed: Lost connection to MySQL

Re: [cgiapp] RFC: synopsis for CGI::App book

2005-09-04 Thread Sam Tregar
On Sun, 4 Sep 2005, Jaldhar H. Vyas wrote: Ch 1: Common Gateway Interface What is CGI? Perl good language for CGI. CGI not dead yet. (Advantages over proprietary methods like java, .net) CGI.pm standard for perl CGI programming (with example.) Make sure you know your stuff when you

Re: [htmltmpl] error using HTML::Template::Compiled

2005-08-30 Thread Sam Tregar
On Tue, 30 Aug 2005, Octavian Rasnita wrote: I have started to use the fast template HTML::Template::Compiled, but it gives errors. Here is a test: HTML::Template::Compiled is not supported on this list, as far as I know. I'm not opposed to discussion of the module here but I thought you

Re: HTML::Template::Compiled

2005-08-30 Thread Sam Tregar
On Tue, 30 Aug 2005, jonathan vanasco wrote: 2- even the slowest templating option - petal - was a fraction of the speed of my business logic and db connectivity This is an important point, and it's the main reason I've never actually used HTML::Template::JIT. My ego demanded that I create

Re: HTML::Template::Compiled

2005-08-30 Thread Sam Tregar
On Tue, 30 Aug 2005, Jonathan Vanasco wrote: are there any worries for security overflows / memory leaks, having compiled that stuff into c or xs (its one of those, right?) under mod_perl Sure, it's worth worrying about. Anything written in C can potentially have a buffer-overflow bug or a

Re: [PATCH] DBI::ProfileDumper::Apache ported to mp2 RC5+

2005-08-21 Thread Sam Tregar
On Sun, 21 Aug 2005, Philip M. Gollucci wrote: Hi all, Nuff said! Very cool! One comment: don't bother with 'use constant' here. The tiny amount of time saved by using a constant will be overwhelmed by the time used loading constant.pm and calling import(). P.S. I believe its a side

Re: [PATCH] DBI::ProfileDumper::Apache ported to mp2 RC5+

2005-08-21 Thread Sam Tregar
On Sun, 21 Aug 2005, Philip M. Gollucci wrote: I wasn't doing it for speed, more of consitency's sake with perl.apache.org docs and other modules like Apache::DBI, Apache::DB (+friends), and etc. I have however changed it to a user var ($MP2) per you request. Cool, thanks. One question

Re: [htmltmpl] Re: ELSE bug

2005-08-11 Thread Sam Tregar
On Thu, 11 Aug 2005, Mitar wrote: On 8/11/05, Mark Stosberg [EMAIL PROTECTED] wrote: I've now submitted a patch with a test, code and docs to resolve this. It's available through rt.cpan.org: Oho, that was really fast. And when can we expect this in the official release, Sam? I'd like

Re: [htmltmpl] ELSE bug

2005-08-10 Thread Sam Tregar
On Wed, 10 Aug 2005, Mitar wrote: I think that HTML::Template should report this. Or is there some reason for it? I use the 2.7 version and Perl 5.8.4. Nope, that's a bug. Could you report it on rt.cpan.org? That will ensure that I don't forget to fix it for the next release. Thanks, -sam

Re: [cgiapp] Portably getting $ENV{QUERY_STRING}

2005-08-10 Thread Sam Tregar
On Tue, 9 Aug 2005, Michael Graham wrote: I could do that, but then after I've extracted the checksum, I need to match it to the rest of the URL (including the other parameters). In other words, for the URL /account.cgi?rm=show_balanceacct_id=73_checksum=0xdeadbeef I have to make

Re: [cgiapp] Portably getting $ENV{QUERY_STRING}

2005-08-09 Thread Sam Tregar
On Tue, 9 Aug 2005, Michael Graham wrote: The module works by stamping the URL with an HMAC checksum: /account.cgi?rm=show_balanceacct_id=73_checksum=0xdeadbeef The module will be a heck of a lot simpler and less error-prone if I can just treat the entire URL (including the query) as

Re: [htmltmpl] Re: wish: tmpl_dump

2005-08-07 Thread Sam Tregar
On Mon, 8 Aug 2005, Mark Stosberg wrote: Interesting. I hadn't heard of that technique being used before. I do recall that this feature could be accomplished somewhat automatically if code refs were used for values-- the code refs would only be executed if they were used. I have rarely needed

Re: [htmltmpl] Loop Quirk??

2005-07-21 Thread Sam Tregar
On Thu, 21 Jul 2005, Leander Gillard wrote: Hello, I'm developing a web application using a combination of CGI::App, CGI::Template, xmlHTTPreq. I don't see HTML::Template in that list. Are you on the wrong mailing-list? -sam --- SF.Net

Re: False Positives from Automated Testing at testers.cpan.org

2005-07-20 Thread Sam Tregar
On Wed, 20 Jul 2005, Michael G Schwern wrote: Also, it eliminates one of the valuable parts of CPAN testers: testing in the wild. If you create an artificially clean environment (the clean image), then install all the latest versions of dependent modules into it and then run the tests you'll

Re: False Positives from Automated Testing at testers.cpan.org

2005-07-20 Thread Sam Tregar
On Wed, 20 Jul 2005, Michael G Schwern wrote: Also, it eliminates one of the valuable parts of CPAN testers: testing in the wild. If you create an artificially clean environment (the clean image), then install all the latest versions of dependent modules into it and then run the tests you'll

Re: [htmltmpl] TT's support for methods and complex structures. Why not?

2005-07-18 Thread Sam Tregar
On Mon, 18 Jul 2005, Mark Stosberg wrote: #1 I can get behind. #2 makes me itch. There's a high potential for abuse here since methods can have side-effects which would break the straight data-path from code to template to output. I'm also more interested in number 1 than number 2. Do

Re: [htmltmpl] TT's support for methods and complex structures. Why not?

2005-07-18 Thread Sam Tregar
On Mon, 18 Jul 2005, Mark Stosberg wrote: There are a couple features of TT that seem reasonable to support, and seem at first glance like things that an be added while maintaining compatibility. 1. Support for complex data structures. 2. Method calls. Isn't there something on CPAN to

Re: [cgiapp] RFD: Developer mailing list?

2005-07-16 Thread Sam Tregar
On Sat, 16 Jul 2005, Ron Savage wrote: On Fri, 15 Jul 2005 11:27:05 -0400, Andrew Brosnan wrote: Hi Andrew I think having both a 'users' and 'dev' list would be a good idea. My vote is against. The negatives, as I see them, are: Leaving aside the pressing issue of how many lists to

Re: [htmltmpl] (no subject) [Patch]

2005-07-13 Thread Sam Tregar
On Wed, 13 Jul 2005, Emanuele Zeppieri wrote: Here it is Sam. Awesome! I'll take a closer look soon. If you don't hear from me in a few days please feel free to nag. -sam --- This SF.Net email is sponsored by the 'Do More With Dual!'

Re: [htmltmpl] Bug in die_on_bad_params handling

2005-07-07 Thread Sam Tregar
On Thu, 7 Jul 2005, Matija Grabnar wrote: And die_on_bad_params is usualy a very usefull debugging tool, which is why I need it. At least, if it dies in the loop, HTML::Template should tell you WHICH loop it died in (in which line the loop began). Now that's a patch I'd take! Warning - it

RE: DBI v2 - The Plan and How You Can Help [DRAFT]

2005-07-05 Thread Sam Tregar
On Tue, 5 Jul 2005, Ronald J Kimball wrote: Total Contributions: $1320.25 I suggest you go back and reread Tim's email. What he said was that he donated a little over $500 himself, not that the total raised was $500. That's good to know. It doesn't really alter my assessment though - the

RE: DBI v2 - The Plan and How You Can Help [DRAFT]

2005-07-05 Thread Sam Tregar
On Tue, 5 Jul 2005, Ronald J Kimball wrote: Total Contributions: $1320.25 I suggest you go back and reread Tim's email. What he said was that he donated a little over $500 himself, not that the total raised was $500. That's good to know. It doesn't really alter my assessment though - the

Re: DBI v2 - The Plan and How You Can Help [DRAFT]

2005-07-02 Thread Sam Tregar
On Fri, 1 Jul 2005, Tim Bunce wrote: Once upon a time I said: http://groups-beta.google.com/group/perl.dbi.users/msg/caf189d7b404a003?dmode=sourcehl=en Minor note: these URLs are too long to easily copy and paste. Maybe use a URL shortening sevrice like tinyurl.com. I've not drawn

Re: DBI v2 - The Plan and How You Can Help [DRAFT]

2005-07-02 Thread Sam Tregar
On Sat, 2 Jul 2005, Dean Arnold wrote: Er, marketting in what way ? I see the email as an attempt to attract new developers to the project. Hence it is, in some respects, an attempt to market DBI v2 to developers. Developing DBI/DBDs costs time resources. Many major for-profit orgs are

Re: DBI v2 - The Plan and How You Can Help [DRAFT]

2005-07-02 Thread Sam Tregar
On Sat, 2 Jul 2005, Dean Arnold wrote: Relax. I'm just suggesting that Tim not talk about a fund drive that more-or-less failed when trying to drum up volunteers for the new project. It will be obvious to everyone who reads this that $500 isn't enough to help in a significant way.

Re: DBI v2 - The Plan and How You Can Help [DRAFT]

2005-07-02 Thread Sam Tregar
On Fri, 1 Jul 2005, Tim Bunce wrote: Once upon a time I said: http://groups-beta.google.com/group/perl.dbi.users/msg/caf189d7b404a003?dmode=sourcehl=en Minor note: these URLs are too long to easily copy and paste. Maybe use a URL shortening sevrice like tinyurl.com. I've not drawn

Re: DBI v2 - The Plan and How You Can Help [DRAFT]

2005-07-02 Thread Sam Tregar
On Sat, 2 Jul 2005, Dean Arnold wrote: Er, marketting in what way ? I see the email as an attempt to attract new developers to the project. Hence it is, in some respects, an attempt to market DBI v2 to developers. Developing DBI/DBDs costs time resources. Many major for-profit orgs are

Re: DBI v2 - The Plan and How You Can Help [DRAFT]

2005-07-02 Thread Sam Tregar
On Sat, 2 Jul 2005, Dean Arnold wrote: Relax. I'm just suggesting that Tim not talk about a fund drive that more-or-less failed when trying to drum up volunteers for the new project. It will be obvious to everyone who reads this that $500 isn't enough to help in a significant way.

Re: [cgiapp] BREAD (or CRUD) Project

2005-06-30 Thread Sam Tregar
On Thu, 30 Jun 2005, Jason Purdy wrote: One of the things we talked about in our BOF (I will be sending minutes out as soon as I get them composed! :)), was creating a BREAD (or CRUD) type of plugin, where someone could install it and then simply create a package that uses cgiapp the plugin

Re: [cgiapp] BREAD (or CRUD) Project

2005-06-30 Thread Sam Tregar
On Thu, 30 Jun 2005, Jason Purdy wrote: Or maybe an arrayref of Class::DBI classes, which map to the table and would also define the relationships between the tables? That sounds reasonable to me. For Class::DBI::Loader you could allow the caller to set the constraint and exclude regexes.

Re: Dbi question?

2005-06-29 Thread Sam Tregar
On Tue, 28 Jun 2005 [EMAIL PROTECTED] wrote: Does dbi provide asynchronous calls? No, it doesn't. If not, what perl module is there that supports asynchronous sql query calls to the database - meaning, I don't have to wait for the call to return. I am using mysql. I don't know of any. You

Re: [PATCH] ChildHandles and installed_drivers()

2005-06-27 Thread Sam Tregar
On Mon, 27 Jun 2005, Tim Bunce wrote: Idea: I was wrong :) Adding ChildHandles to the list of attributes in the attribute get code in DBI.xs is the right thing to do. Ok. Did my one-liner not work? @$ch = grep { $_ } @$ch if @$ch % 120 == 0 @$ch; It's much

[PATCH] Revised ChildHandles patch

2005-06-27 Thread Sam Tregar
Here's a revised version of the ChildHandles patch. I think I've implemented all the requested changes. I also added an implementation of Type for DBI::PurePerl which was missing. -samdiff -Naur DBI-1.48.orig/DBI.pm DBI-1.48/DBI.pm --- DBI-1.48.orig/DBI.pm2005-03-14 11:45:38.0

Re: [cgiapp] CAF : Exceptions

2005-06-23 Thread Sam Tregar
On Wed, 22 Jun 2005, Jeff MacDonald wrote: Wondering if there are plans for some type of error handling into CAF. I don't know about CAF but I have plans to put together something based on Krang::Message as a CGI::App plugin: http://krang.sourceforge.net/docs/krang_message.html I've been

Re: [PATCH] ActiveHandles attribute

2005-06-23 Thread Sam Tregar
On Thu, 23 Jun 2005, Tim Bunce wrote: For a driver handle the children are the database handles. For a database handle the children are the statement handles. $h-{ChildHandles} gives you the children of that handle. Does that make sense? Yes it does. Sorry, I should have removed that

[PATCH] ActiveHandles attribute

2005-06-22 Thread Sam Tregar
Here's my first pass at an ActiveHandles attribute. With this patch this code prints all live handles: foreach my $handle (@{$dbh-{ActiveHandles}}) { next unless defined $handle; print $handle, \n; } I'd like to take the next step and add a DBI-ActiveHandles call to do it

Re: [PATCH] ActiveHandles attribute

2005-06-22 Thread Sam Tregar
On Wed, 22 Jun 2005, Tim Bunce wrote: I'd rather go with ChildHandles as per the outline in my previous email. If you insist. I don't understand the use of child here. What is the parent? Your patch uses a global $DBI::active_handles which will grow without bound. It is bounded by the

Re: Cycling through open handles

2005-06-20 Thread Sam Tregar
On Mon, 20 Jun 2005, Tim Bunce wrote: Can you suggest a good place to put the code to collect open handles? Knowing nothing about the internals I'm guessing connect() is the right spot. Actually _new_handle() in DBI.pm But first we need an API. A reasonable first draft would be to

Re: Cycling through open handles

2005-06-20 Thread Sam Tregar
On Tue, 21 Jun 2005, Tim Bunce wrote: $handles = DBI-ChildHandles(); $drh = DBI-install_driver('mysql'); $all_mysql_dbh = $drh-{ChildHandles}; (install_driver doesn't reinstall the driver if it's already loaded) Can I do that if I don't know which driver is already loaded?

Re: [cgiapp] RFC: DBI::Session proposed docs

2005-06-18 Thread Sam Tregar
On Sat, 18 Jun 2005, Mark Stosberg wrote: As a design goal, no database driver layer should be needed. How will you handle locking? This seems to be the hardest thing to do in a database agnostic fashion. -sam - Web

Cycling through open handles

2005-06-15 Thread Sam Tregar
Hello all. Is there a simple way to cycle through all open database handles, without needing to know anything about them before-hand? Something like: foreach my $dbh (DBI-all_open_database_handles()) { ... } I looked through the documentation but I couldn't find anything that worked.

Re: Cycling through open handles

2005-06-15 Thread Sam Tregar
On Wed, 15 Jun 2005, Tim Bunce wrote: Not currently. It would require the use of weak-refs to avoid reference loops. (Patches welcome etc etc.) Alright, perhaps I'll take a swing at it. Can you suggest a good place to put the code to collect open handles? Knowing nothing about the internals

RFC: New methods for DBI::ProfileDumper - reset() and File()

2005-06-15 Thread Sam Tregar
Hello all. I'm working on a project to produce a graphical frontend for DBI::ProfileDumper for use with CGI::Application called CGI::Application::Plugin::DBIProfile. (Preview here: http://sam.tregar.com/dbiprof_progress.png) Things are working fine in mod_cgi but mod_perl is another story. The

Re: RFC: New methods for DBI::ProfileDumper - reset() and File()

2005-06-15 Thread Sam Tregar
On Wed, 15 Jun 2005, Tim Bunce wrote: Doesn't this work already: $dbh-{Profile} = DBI::ProfileDumper-new( File = 'dbi.prof' ); Assigning a new value to $dbh-{Profile} would DESTROY the old one (flushing it to disk in the process). Yes, I think it would. However, I only have a

Re: Problem with Profile: invalid data leaf

2005-06-12 Thread Sam Tregar
On Tue, 7 Jun 2005, Tim Bunce wrote: No bells here. Keep digging! I feel like I'm getting closer. It's not actually the case that $dbh-{Profile}-{Data} contains a rogue empty hash, it's that $dbh-{Profile}-{Path} gets assigned a ref to an empty array. This causes the code in dbi_profile to

Re: Problem with Profile: invalid data leaf

2005-06-12 Thread Sam Tregar
On Sun, 12 Jun 2005, Sam Tregar wrote: So the question is, what is assigning an empty array to {Path}? Of course right after sending the message I figured it out. DBI::ProfileDumper was assuming that $profile-{Path} would always contain an array-ref and it was auto-vivifying that hash when

Re: Problem with Profile: invalid data leaf

2005-06-12 Thread Sam Tregar
On Sun, 12 Jun 2005, Tim Bunce wrote: Thanks, applied. Change 1079. Any chance you could patch a test into t/41prof_dump.t? Done. Without the prior patch the new test causes: Invalid Profile data leaf element at depth 1: HASH (type 11) at t/41prof_dump.t line 45. # Looks like you

Re: tamino drivers for Perl-DBI

2005-06-11 Thread Sam Tregar
On Fri, 10 Jun 2005, Christian Stalp wrote: Im involved in a project to setup a tamino -XML-Database for the web. My problem is now, that I cannot find any Tamino-Driver for DBI. Is there any workarround or solution I can use for this? Looking around Tamino's website I don't see any mention

Problem with Profile: invalid data leaf

2005-06-07 Thread Sam Tregar
Hello all. I've been playing with DBI::ProfileDumper again and I've been experiencing an odd error. At first I thought it was something happening in my application but then I got the same error from a very different app (one uses Class::DBI and lots of magic, the other is a straight-forward DBI

[JOB] Perl Programmer for large-scale Apache/mod_perl development

2005-06-06 Thread Sam Tregar
NEW YORK CITY AREA ONLY Plus Three is looking for an experienced Perl programmer to join our team. You will join a large-scale, high-visibility project with the potential to positively affect the future of the Democratic party during the next election cycle. We're looking for someone who enjoys

Re: [cgiapp] CGI::App 4.0 release pending (was: Re: remove duplicate callbacks?)

2005-06-05 Thread Sam Tregar
On Fri, 3 Jun 2005, Sam Tregar wrote: I'm planning to give it a test drive this weekend. I've got an idea for a database profiling plugin potentially called CGI::Application::Plugin::DBIProfile. It would setup DBI::ProfileDumper to capture DBI profiling stats for a single request then pop

Re: [cgiapp] CGI::App 4.0 release pending (was: Re: remove duplicate callbacks?)

2005-06-04 Thread Sam Tregar
On Sat, 4 Jun 2005, Cees Hek wrote: You don't need $self to setup callbacks or add new hooks. You can call them as class methods. So you could put this in your 'import' subroutine: sub import { my $pkg = shift; my $callpkg = caller; $callpkg-add_callback('cgiapp_init' =

Re: [cgiapp] DB profiling tips (was: Re: CGI::App 4.0 release pending (was: Re: remove duplicate callbacks?))

2005-06-04 Thread Sam Tregar
On Sat, 4 Jun 2005, Mark Stosberg wrote: There is a tool just for this: PQA, written in ruby. It's easy to install and use, and runs surprisingly fast on large logs. http://pqa.projects.postgresql.org/ Looks a lot like the profiling stuff that comes with DBI (which I wrote) -

Re: [cgiapp] CGI::App 4.0 release pending (was: Re: remove duplicate callbacks?)

2005-06-04 Thread Sam Tregar
On Sat, 4 Jun 2005, Michael Graham wrote: I think you're using version 4.0_2, which didn't support the class-based syntax. There's a draft of 4.0.3 here: http://occamstoothbrush.com/downloads/perl/CGI-Application-4.0_3-positionless-class-callbacks-patch3.tar.gz Right you are. Is

<    1   2   3   4   5   6   7   8   >