full-featured online database apps
Does anyone know of a good customizable, user-friendly, online database application, preferably mod_perl-based? I want to migrate a small Access database to MySQL with a web interface, for added features and room for growth. Has anyone come across a good open source project or toolkit that would make this job really easy? TIA, -Adi
[Q maybe OT] forward
Hi all, maybe this is going to be a little off topic, but it won't take you much time: I am quite certain that recently I saw a server response code concerning forwarding. It may have looked like HTTP_DOCUMENT_FORWARDED or anything alike. Silly enough I can't recall where I saw it (or whether I even just dreamt it), so my questions are: 1. Has anyone ever seen that ghost before? 2. If I'm right, what is the correct memnonic, what's its code - and: where an I find it? perl5.6.1-Apache::Constants::Exports.pm doesn't mention it. Hope it wasn't all just a dream... thx M -- http://www.meome.de --- Martin Haase-Thomas |Tel.: +49 30 43730-558 meOme AG|Fax.: +49 30 43730-555 Software Development| [EMAIL PROTECTED] ---
Re: full-featured online database apps
I've actually USED Ms Access for just this purpose on a few occasions... It's a lot easier to do using the GUI... Issac Adi Fairbank wrote: Does anyone know of a good customizable, user-friendly, online database application, preferably mod_perl-based? I want to migrate a small Access database to MySQL with a web interface, for added features and room for growth. Has anyone come across a good open source project or toolkit that would make this job really easy? TIA, -Adi
Re: startup for Apache 2.0/mod_perl 1.99
At 05:55 24.04.2002, Stas Bekman wrote: Chuck Goehring wrote: Stas/Everyone, To follow up. With the starting and stopping of Apache and looking at the log, I see entries like Child 1032: Waiting for 250 worker threads to exit. I was gettiong Low virtual memory errors from Win/2000, so I added ThreadsPerChild 24 to the http.conf. This makes it stop quicker and use a whole lot less memory. Also, the error at the browser comes back faster. Why did you have it set to 250 in first place? For testing set it to just a few to have the minimal overhead. The default (on Win32 Apache anyways) is 250. So it's what people will usually keep if they don't know about it. Maybe a note in the docs? -- Per Einar Ellefsen [EMAIL PROTECTED]
Re: [Q maybe OT] forward
At 07:44 24.04.2002, Martin Haase-Thomas wrote: Hi all, maybe this is going to be a little off topic, but it won't take you much time: I am quite certain that recently I saw a server response code concerning forwarding. It may have looked like HTTP_DOCUMENT_FORWARDED or anything alike. Silly enough I can't recall where I saw it (or whether I even just dreamt it), so my questions are: 1. Has anyone ever seen that ghost before? 2. If I'm right, what is the correct memnonic, what's its code - and: where an I find it? perl5.6.1-Apache::Constants::Exports.pm doesn't mention it. Hope it wasn't all just a dream... Must have been :) Apache::Constants doesn't mention anything about FORWARD, neither does httpd.h. There is DOCUMENT_FOLLOWS, but that's got nothing to do with it. What do you mean by forwarding anyway? Like redirect? -- Per Einar Ellefsen [EMAIL PROTECTED]
-help
Title: Nachricht
Re: [Q maybe OT] forward
Martin Haase-Thomas wrote: I am quite certain that recently I saw a server response code concerning forwarding. It may have looked like HTTP_DOCUMENT_FORWARDED or anything alike. Hi Martin, just a guess: Do you mean the header entry 'X-Forwarded-For' ? See http://take23.org/docs/guide/scenario.xml/8 Ernest -- * * VIRTUALITAS Inc. * * ** * * European Consultant Office * http://www.virtualitas.net * * Internationales Handelszentrum * contact:Ernest Lergon * * Friedrichstraße 95 *mailto:[EMAIL PROTECTED] * * 10117 Berlin / Germany * ums:+49180528132130266 * * PGP-Key http://www.virtualitas.net/Ernest_Lergon.asc
Re: [Q maybe OT] forward
;) you're right. meanwhile i found out that it seems to have something to do with proxies. forwarding is a term that i borrowed from the JSP concept - which i'm currently trying to implement in perl. it means nearly the same as redirect, but without telling the client. (as far as i've understood it do far. maybe it's just luxury and i'm going to leave it out.) thank you both for your clues and guesses. i think the best idea will lie in informing the programmer that there has been some sort of an 'event' while processing the page - and leave the uncomfortable decision what do to with this 'event' up to him... ... whistling ... :) M Per Einar Ellefsen wrote: At 07:44 24.04.2002, Martin Haase-Thomas wrote: Hi all, maybe this is going to be a little off topic, but it won't take you much time: I am quite certain that recently I saw a server response code concerning forwarding. It may have looked like HTTP_DOCUMENT_FORWARDED or anything alike. Silly enough I can't recall where I saw it (or whether I even just dreamt it), so my questions are: 1. Has anyone ever seen that ghost before? 2. If I'm right, what is the correct memnonic, what's its code - and: where an I find it? perl5.6.1-Apache::Constants::Exports.pm doesn't mention it. Hope it wasn't all just a dream... Must have been :) Apache::Constants doesn't mention anything about FORWARD, neither does httpd.h. There is DOCUMENT_FOLLOWS, but that's got nothing to do with it. What do you mean by forwarding anyway? Like redirect? -- http://www.meome.de --- Martin Haase-Thomas |Tel.: +49 30 43730-558 meOme AG|Fax.: +49 30 43730-555 Software Development| [EMAIL PROTECTED] ---
Apache2/mod_perl2 an order of magnitude more powerful?
Hi, I haven't installed Apache 2.0 yet but I like the sound of 250 worker threads set as the default! I would love to run 250 Apache children on my linux server but I just don't have enough memory (50 children max). 250 http server threads running concurrently would be an order of magnitude more powerful than my current set up. Have I got this right? or am I missing a big catch? NIge -- Nigel Hamilton Turbo10 Metasearch Engine email: [EMAIL PROTECTED] tel:+44 (0) 207 987 5460 fax:+44 (0) 207 987 5468 http://turbo10.com Search Deeper. Browse Faster.
Re: Apache2/mod_perl2 an order of magnitude more powerful?
Hi there, On Wed, 24 Apr 2002, Nigel Hamilton wrote: 250 http server threads running concurrently would be an order of magnitude more powerful than my current set up. Have I got this right? or am I missing a big catch? No and yes in that order. Your computer won't be any more powerful, no matter how many threads you run... 73, Ged.
Re: [Q maybe OT] forward
* Martin Haase-Thomas [EMAIL PROTECTED] [2002-04-24 08:19]: forwarding is a term that i borrowed from the JSP concept - which i'm currently trying to implement in perl. it means nearly the same as redirect, but without telling the client. (as far as i've understood it do far. maybe it's just luxury and i'm going to leave it out.) That sounds exactly like internal_redirect. (darren) -- Help! I'm a rock!
Re: Apache2/mod_perl2 an order of magnitude more powerful?
250 http server threads running concurrently would be an order of magnitude more powerful than my current set up. Have I got this right? or am I missing a big catch? No and yes in that order. Your computer won't be any more powerful, no matter how many threads you run... Yes. OK. But having 250 worker threads instantiated in memory and ready to use the CPU is surely still better than 50 pre-forked servers? -- Nigel Hamilton Turbo10 Metasearch Engine email: [EMAIL PROTECTED] tel:+44 (0) 207 987 5460 fax:+44 (0) 207 987 5468 http://turbo10.com Search Deeper. Browse Faster.
Re: full-featured online database apps
It was my understanding that there are numerous tools for converting tables like this at the mysql.com site. Some will even access the Access tables via ODBC and create a set of tables directly for you, or just make dumps that can be read into MySQL. Once made, Webmin does a good job of administering mysql databases. www.webmin.com --Jon Robison Adi Fairbank wrote: Does anyone know of a good customizable, user-friendly, online database application, preferably mod_perl-based? I want to migrate a small Access database to MySQL with a web interface, for added features and room for growth. Has anyone come across a good open source project or toolkit that would make this job really easy? TIA, -Adi
Re: [Q maybe OT] forward
Martin Haase-Thomas wrote: forwarding is a term that i borrowed from the JSP concept - which i'm currently trying to implement in perl. JSP forward is directly equivalent to an internal redirect. It's just an include that doesn't return. In short, it's a GOTO statement. Thank you Sun. - Perrin
ANNOUNCE: AxKit 1.5.2
AxKit 1.5.2 is out. Minor bug fixes and small feature changes. http://axkit.org/ - Allow AxKit to handle directory requests. - Fixed all Language modules to return 200/OK - Added AxIgnoreStylePI directive - Ported AxPoint to use XML::Handler::AxPoint - TaglibHelper taglibs no longer need to have parse_* subs - Added HtmlDoc language module - Fixed strange bug in cached LibXSLT stylesheets -- !-- Matt -- :-Get a smart net/:-
Re: Apache2/mod_perl2 an order of magnitude more powerful?
Nigel Hamilton wrote: I would love to run 250 Apache children on my linux server but I just don't have enough memory (50 children max). thread still needs its own perl interpreter.Then you probably won't have enough memory with Apache 2 either. There is some additional memory savings from sharing the opcode tree, but each Expect it to be better, but you don't get something (unlimited parallelism) for nothing (limited RAM). - Perrin
Re: [Q maybe OT] forward
Hello, MHTforwarding is a term that i borrowed from the JSP concept - which i'm MHTcurrently trying to implement in perl. PHJSP forward is directly equivalent to an internal redirect. It's just PHan include that doesn't return. In short, it's a GOTO statement. Thank PHyou Sun. This concept is supported better in Apache::ASP, where you can just pass arguments directly to the target page. If you use the internal_redirect() method, you have to use notes(), pnotes(), globals, or some other cumbersome method to pass arguments. Humbly, Andrew -- Andrew Ho http://www.tellme.com/ [EMAIL PROTECTED] Engineer [EMAIL PROTECTED] Voice 650-930-9062 Tellme Networks, Inc. 1-800-555-TELLFax 650-930-9101 --
Re: startup for Apache 2.0/mod_perl 1.99
Stas,
That made it work! Your my hero!. That also made the script that accesses
Oracle work as well. We've staved off the IIS beast for another day!
I'm not familiar with the testing stuff except when Doug had me run the
t/report thing.. I'm a CGI guy rather that an apache handler/C language
type.
The 250 was the built-in default value. I hadn't set anything related to
threads because I haven't read any of that yet. Just trying to get things
basically working. The high memory consumption and sluggish response may
have been aggravated by the missing directive and this machine only has
128MB memory. It's running on my workstation that has many applications
open all the time.
Thanks for the help.
Chuck
- Original Message -
From: Stas Bekman [EMAIL PROTECTED]
To: Chuck Goehring [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, April 23, 2002 8:53 PM
Subject: Re: startup for Apache 2.0/mod_perl 1.99
Chuck Goehring wrote:
You're right. I'm getting impatient and jumping ahead. Pasted directly
from your post, restarted Apache and get same thing
[Tue Apr 23 12:16:54 2002] [notice] Parent: Created child process 2560
[Tue Apr 23 12:16:58 2002] [notice] Child 2560: Child process is running
[Tue Apr 23 12:16:58 2002] [notice] Child 2560: Acquired the start
mutex.
[Tue Apr 23 12:16:58 2002] [notice] Child 2560: Starting 250 worker
threads.
[Tue Apr 23 12:17:46 2002] [error] 2560: ModPerl::Registry: `Can't call
method args on an undefined value at c:/perl/5.6.1/lib/CGI.pm line
433.
It is referring to the IF statement:
if ($MOD_PERL) {
$query_string = Apache-request-args;
} else {
$query_string = $ENV{'QUERY_STRING'} if defined
$ENV{'QUERY_STRING'};
$query_string ||= $ENV{'REDIRECT_QUERY_STRING'} if defined
$ENV{'REDIRECT_QUERY_STRING'};
}
I know what was missing.
add 'PerlOptions +GlobalRequest', like so:
Location /perl
SetHandler perl-script
PerlResponseHandler ModPerl::Registry
Options ExecCGI
PerlSendHeader On
PerlOptions +GlobalRequest
/Location
http://perl.apache.org/preview/modperl-docs/dst_html/docs/2.0/user/config/co
nfig.html#PerlOptions_Directive
# GlobalRequest
Setup the global request_rec for use with Apache-request
Sorry for missing this one, I'm not used to it yet :)
Also I'd like to repeat that the 2.0 test suite is the best place to
learn how, before the docs will be completed.
__
Stas BekmanJAm_pH -- Just Another mod_perl Hacker
http://stason.org/ mod_perl Guide --- http://perl.apache.org
mailto:[EMAIL PROTECTED] http://use.perl.org http://apacheweek.com
http://modperlbook.org http://apache.org http://ticketmaster.com
Re: startup for Apache 2.0/mod_perl 1.99
At 19:31 24.04.2002, Chuck Goehring wrote: That made it work! Your my hero!. That also made the script that accesses Oracle work as well. We've staved off the IIS beast for another day! Great! I'm not familiar with the testing stuff except when Doug had me run the t/report thing.. I'm a CGI guy rather that an apache handler/C language type. What he meant is that the test scripts in t/ contain many examples of mod_perl 2.0 configuration and use. Look at the *.pm files which show various handlers being used. That should give you an idea of what to do. -- Per Einar Ellefsen [EMAIL PROTECTED]
Re: full-featured online database apps
For example, what I'm looking for are other projects similar to Gedafe: http://isg.ee.ethz.ch/tools/gedafe/ but maybe with a more customizable front-end. -Adi
Re: full-featured online database apps
On Wed, 24 Apr 2002, Adi Fairbank wrote: Date: Wed, 24 Apr 2002 13:27:11 -0700 From: Adi Fairbank [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: full-featured online database apps For example, what I'm looking for are other projects similar to Gedafe: http://isg.ee.ethz.ch/tools/gedafe/ but maybe with a more customizable front-end. -Adi Adi, I've written so many on-line database apps in mod_perl/MySQL/Oracle that I think I'll go crazy sometimes. They all have so much in common, esp. the typical administrative interface where you have to show all, show one, edit, create, [confirm] delete, etc. Everytime I find myself following the same basic formula, but they're all so significantly different that I can't really see reusing much code. I guess you could abstract things to such a degree that lots of directives could be passed to extremely generic methods, but that actually has always seemed more trouble to me than it's worth. I guess my bit of insight I'm trying to share is that you should probably just write your own from scratch. It sounds like you're somewhat new to this, anyway, so the experience will do you good. :) I guess I just don't think you're going to find anything that will ever be as flexible and powerful as something you write yourself. You'd likely spend as much time trying to grok someone else's code so you could modify it as you'd spend hacking your own. If you'd like examples of how to go about this, write me off-list and I'll send you a lot of nasty code. ky
Re: full-featured online database apps
Since the excellent HTML::Template, the codes becomes more re-usable... Peter - Original Message - From: Ken Y. Clark [EMAIL PROTECTED] To: Adi Fairbank [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 1:23 PM Subject: Re: full-featured online database apps I've written so many on-line database apps in mod_perl/MySQL/Oracle that I think I'll go crazy sometimes. They all have so much in common, esp. the typical administrative interface where you have to show all, show one, edit, create, [confirm] delete, etc. Everytime I find myself following the same basic formula, but they're all so significantly different that I can't really see reusing much code. I guess you could abstract things to such a degree that lots of directives could be passed to extremely generic methods, but that actually has always seemed more trouble to me than it's worth.
Re: full-featured online database apps
Since the excellent Embperl::Object, the code becomes more re-usable... Sorry, had to be said. My point is that there are many templating systems to choose from. With a bit of fore thought, the Show, List, Delete, Add, etc buttons can be moved into different objects/methods/templates, so that it's easier to pick and choose your interface components. Wim On 24-Apr-2002 Peter Bi wrote: Since the excellent HTML::Template, the codes becomes more re-usable... Peter - Original Message - From: Ken Y. Clark [EMAIL PROTECTED] To: Adi Fairbank [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 1:23 PM Subject: Re: full-featured online database apps I've written so many on-line database apps in mod_perl/MySQL/Oracle that I think I'll go crazy sometimes. They all have so much in common, esp. the typical administrative interface where you have to show all, show one, edit, create, [confirm] delete, etc. Everytime I find myself following the same basic formula, but they're all so significantly different that I can't really see reusing much code. I guess you could abstract things to such a degree that lots of directives could be passed to extremely generic methods, but that actually has always seemed more trouble to me than it's worth.
Re: full-featured online database apps
Well, I changed it back to HTML::Template . It takes relatively less time to work it out with graphic designers. Peter - Original Message - From: Wim Kerkhoff [EMAIL PROTECTED] To: Peter Bi [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; Ken Y. Clark [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 1:50 PM Subject: Re: full-featured online database apps Since the excellent HTML::Template, the code becomes more re-usable... Sorry, had to be said. My point is that there are many templating systems to choose from. With a bit of fore thought, the Show, List, Delete, Add, etc buttons can be moved into different objects/methods/templates, so that it's easier to pick and choose your interface components. Wim On 24-Apr-2002 Peter Bi wrote: Since the excellent HTML::Template, the codes becomes more re-usable... Peter - Original Message - From: Ken Y. Clark [EMAIL PROTECTED] To: Adi Fairbank [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 1:23 PM Subject: Re: full-featured online database apps I've written so many on-line database apps in mod_perl/MySQL/Oracle that I think I'll go crazy sometimes. They all have so much in common, esp. the typical administrative interface where you have to show all, show one, edit, create, [confirm] delete, etc. Everytime I find myself following the same basic formula, but they're all so significantly different that I can't really see reusing much code. I guess you could abstract things to such a degree that lots of directives could be passed to extremely generic methods, but that actually has always seemed more trouble to me than it's worth.
RE: full-featured online database apps
Arghhh! Enough! Enough! Enough!. The question of which Template/App/Embed technique is best has been discussed to death. Please don't start a new round of 'beat the dead horse'. Links to a list of Application Servers/Toolkits/Embedded Perl see the url: http://perl.apache.org/#appservers or see the website for the mod_perl Cookbook which can be found at: http://www.modperlcookbook.org/ Joe -Original Message- From: Peter Bi [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 4:06 PM To: Wim Kerkhoff Cc: [EMAIL PROTECTED]; Ken Y. Clark Subject: Re: full-featured online database apps Well, I changed it back to HTML::Template . It takes relatively less time to work it out with graphic designers. Peter - Original Message - From: Wim Kerkhoff [EMAIL PROTECTED] To: Peter Bi [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; Ken Y. Clark [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 1:50 PM Subject: Re: full-featured online database apps Since the excellent HTML::Template, the code becomes more re-usable... Sorry, had to be said. My point is that there are many templating systems to choose from. With a bit of fore thought, the Show, List, Delete, Add, etc buttons can be moved into different objects/methods/templates, so that it's easier to pick and choose your interface components. Wim On 24-Apr-2002 Peter Bi wrote: Since the excellent HTML::Template, the codes becomes more re-usable... Peter - Original Message - From: Ken Y. Clark [EMAIL PROTECTED] To: Adi Fairbank [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 1:23 PM Subject: Re: full-featured online database apps I've written so many on-line database apps in mod_perl/MySQL/Oracle that I think I'll go crazy sometimes. They all have so much in common, esp. the typical administrative interface where you have to show all, show one, edit, create, [confirm] delete, etc. Everytime I find myself following the same basic formula, but they're all so significantly different that I can't really see reusing much code. I guess you could abstract things to such a degree that lots of directives could be passed to extremely generic methods, but that actually has always seemed more trouble to me than it's worth.
Re: full-featured online database apps
Peter Bi wrote: Well, I changed it back to HTML::Template. No template flame wars, please. HTML::Template is not unique (it has much in common with Template Toolkit and dozens of other less famous modules from CPAN), and Embperl::Object is really pretty cool. Your original point about separating presentation out into templates helping with code reusability is a good one, so let's just leave it at that. - Perrin
[OT] Re: full-featured online database apps
At Wed, 24 Apr 2002 14:05:38 -0700, Peter Bi wrote: Well, I changed it back to HTML::Template . It takes relatively less time to work it out with graphic designers. plug I've made simple utilities (fot TT and H::T) to help perl developers having a nightmare with co-work with designers. See http://perlmonks.org/index.pl?node_id=161595 for details. /plug -- Tatsuhiko Miyagawa [EMAIL PROTECTED]
Re: full-featured online database apps
(agreed. let's stop talking on specific templates.) As to the reusability, form actions can actually be put in an abstract class, so a particular application can subclass it by implement of action methods with an optional xml control. But I have the same feeling as in Ken Clark's original post, one could not go too far beyond that, or not worth of doing that. Using an existing tool may solve one problem but it usually takes as much time to add or modify something later. On the other hand, the typical size of web projects nowadays is still well within our ability of write-from-scratch. Peter - Original Message - From: Perrin Harkins [EMAIL PROTECTED] To: Peter Bi [EMAIL PROTECTED] Cc: Wim Kerkhoff [EMAIL PROTECTED]; [EMAIL PROTECTED]; Ken Y. Clark [EMAIL PROTECTED] Sent: Wednesday, April 24, 2002 2:08 PM Subject: Re: full-featured online database apps Peter Bi wrote: Well, I changed it back to HTML::Template. No template flame wars, please. HTML::Template is not unique (it has much in common with Template Toolkit and dozens of other less famous modules from CPAN), and Embperl::Object is really pretty cool. Your original point about separating presentation out into templates helping with code reusability is a good one, so let's just leave it at that. - Perrin
[SOLVED] Re: Redhat 7.2 glibc update causes problems with Apache::Cookie?
FYI, I finally got my problems with Apache::Cookie (part of libapreq) solved. Much thanks to Stas for advice on solving this problem. Here's what I found: 1) Installing the glibc 2.2.4-24 updates borked the RPM installed perl 5.6.1. Building 5.6.1 from source fixed this problem. 2) libapreq 1.0 installs the libapreq.* files into /usr/local/lib. I ended up adding the path to ld.conf. Not sure if this was necessary.
