-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Mon, Oct 01, 2001 at 07:31:35PM +1200, Dan Horne wrote:
> I'm currently writing a db application based on Oracle with Perl batch
> processing, and am intending to implement a GUI front end. Perl/Tk looks
> like a possible option. I'm reasonably new to Perl but feel confident enough
> in it to create a functional app, even if the code is not written in an
> optimal manner. I have no experience in Tk. Is this combination satisfactory
> for db apps? Is there a lot of hand-coding that is taken forgranted by
> Java's swing/awt.

It's satisfactory for any app :)  Perl/Tk should be able to do anything you 
want, database-related or non.

>                    Is there a good Tk reference? O'Reilly's "Learning
> Perl/Tk: Graphical User Interfaces with Perl" get mixed reviews on Amazon.
> Andrew Page's "Programming Perl/TK" has no reviews at all. Would I be better
> off with a Tcl/Tk book, and to ignore the Tcl part?

There are a lot of idiots on Amazon, you know.  You can always ship the book 
back if it sucks.  As it stands, I have yet to be dissatisfied with an O'Reilly 
book on Perl.

FWIW, `perldoc Tk::UserGuide` is a decent 5-minute crash course.  You might just 
browse the perldocs and see if you get it.  Additionally, the latter pages of 
Perl Cookbook chapter 15 have some concise but thorough Tk examples.  (You 
should already have a copy of the Cookbook anyway :)

> Also, I am considering porting the app to an opensource db. Because MySQL
> does not support transactions, it is out of the running. PostGres supposedly
> supports stored procedures and triggers, two features that I use in the
> Oracle version. I'd appreciate hearing some feed back from people's
> experiences, partiularly in the areas of: integration with dbi, installation
> issues, reliability etc. If anyone has two cents to offer, perhaps they can
> backchannel me as this is slightly OT.

PG has become the poor man's Oracle, IMO.  If you don't require Oracle's more 
advanced features, but need something more than an unreliable flatfile system 
(read: MySQL), it's a great choice.  It's practically neck and neck with Oracle 
featurewise.  However, Oracle still scales far better.  Of course, it's not 
terribly hard to migrate from PG to Oracle should the need ever arise (try 
saying that about MySQL to Oracle *shudder*).

> Plus: have people written commercial packages with dbi? Can you point me to
> web pages that either contain reviews, issues or any other kings of info.

Funny you should ask :)  Our two flagship products (IQ Coordinator and IQ
Developer) are built entirely on DBI, Oracle, and Apache/mod_perl.  It's an
awesome combination.  Unfortunately the marketdroids seem to have taken over our 
Web site and divested it of all useful information, but I can share more if 
you're interested.

- -- 
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQA/AwUBO7gs2wOGqGs0PadnEQIxswCePNYcB4kDbcDvJDWueHf0aC6tn90Anj4F
wNNV4MIXEXdT61Bd3KUri7fx
=BRL+
-----END PGP SIGNATURE-----

Reply via email to