Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

comment on

( [id://3333]=superdoc: print w/replies, xml ) Need Help??
TacoVendor,

I saw 10 replies to your queastion and was tempted not to weigh in on this one. But having read them, well I just cannot help myself!

Firstly, by moving to a DBD/DBI driven framework your application will not only become moreportable across differing platforms, but also between solutions on a single platform.

I have Perl 5.6/5.8 scripts (some are complete GUI programmes!) that can move from MS-Access on Win32, MS-SQL server, and MySQL on Win32. Then I can run the same thing on Linux with PostGres or MySQL (I prefer the latter).

Even though you dont 'need' MySQL or something similar, it wont do you any harm either!

As someone else said, you have chosen a partable programming platform, now you should choose a portable database solution. I develop on WindowsXP using ActiveState 5.8.0 with MySQL installed on the same machine for both GUI applications and CGI scripts. My GUI apps end up running 75% on Windows and 25% Linux, the CGI is almost universally running under Apache on Linux. It is a framework that has worked very well for me.

Currently I am working on a 'small' GUI product, It is around 1000 lines of code in Perl, with about 2 million records in a MySQL database. Works like a charm on a simple entry level Celeron machine we use for testing. In fact it runs very well on a Pentium III machine which is about 6 years old too!

Good luck! jdtoronto


In reply to Re: Selecting the right database for perl by jdtoronto
in thread Selecting the right database for perl by TacoVendor

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":



  • Are you posting in the right place? Check out Where do I post X? to know for sure.
  • Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
    <code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
  • Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
  • Want more info? How to link or How to display code and escape characters are good places to start.
Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others lurking in the Monastery: (1)
As of 2024-04-25 00:14 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found