Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer

Re3: Cross platform perl development

by pmas (Hermit)
on Jul 23, 2001 at 17:33 UTC ( #99008=note: print w/replies, xml ) Need Help??

in reply to Re: Re: Cross platform perl development
in thread Cross platform perl development

As a small database on small system:
Do you mean simple PC? I run MS Access with 3GB database, and it survived. MS Access is "free": bundled in MS Office pro, you have MS Office anyway, right? You can access Access database (MS Jet Engine) via ODBC and DBI just fine. Your SQL will be multi-platform as long as you will use only standard SQL and avoid any proprietary extensions - but DBI will wisely guide you to use standard SQL only ;)

To make errors is human. But to make million errors per second, you need a computer.

Replies are listed 'Best First'.
Re: Re3: Cross platform perl development
by kapper (Chaplain) on Jul 23, 2001 at 23:24 UTC

    Do you mean simple PC?

    Hardware wise, yes, but software wise, no... While MS products might seem cheap (Yearh right), to some home users, try equiping even a small organization with around 50 people with Win2K and Office pro licenses.. not a pleasent experience.

    Furthermore... I reeeeally don't like access, for everyday I have used it, I have become more and more sure, that it is actually just minesweeper with a few added lines of code =)

    ...well maybe that was a bit harsh, i find access very adeqate (..hmm.. aparently my english spelling abilities have gone after just two beers) for some smaller jobs, but would rather not use it for anything so serious that I could not just as easily have used text files for the job.


      I am afraid my point - "use Access if you have it already" on your Windows machines was not obvious enough. :(
      I do not agree about Access with you. It is excellent for first-time, inexperienced users, for casual access to data. I am not aware of any other DB interface (for the price) with so easy to use visual query builder, or "query by form". You cannot beat easiness of building SQL table JOINs visually.

      Sure enough, when you need to do more serious development, you are seduced to MS concepts, but can avoid it by using DBI, ODBC and perl. With DBI, perl, and little thinking , I may not care what database I am connected into.

      Access (== MS Jet database engine) has record locking and transactions as real databases have, which I doubt about text files... ;)

      And sure enough, if you do not need PC, and free *NIXish system is acceptable for users, just go ahead.

      Installed OS is not a "religious issue" for me. User needs to be comfortable with the OS selected, and luckily enough I can port my perl on almost any system (there was discussion about porting Perl to Palm PDA- can you believe that?).

      Obviously, if users like to try to equip 50 PCs with Linux and StarOffice, excellent - Micro$oft is rich enough. If I may not care about transactions - so mysql is enough, it's fine. I did not use Postgress DB, so I cannot recomment id. After many years using database PROGRESS and it's clever 4GL language, I am back to plain stupid SQL on ORACLE, and only perl makes this experience bearable... ;)

      And I am sure Access is more than minesweeper: Access can do transactions and rollback, but minesweeper cannot. :)

      Update: Full disclosure: I am using Access/ODBC connection to ORACLE database to check how my CGI scripts are working. I found it easier - because I know it already...:)

      To make errors is human. But to make million errors per second, you need a computer.

        Access can do rollbacks? How? Are you sure you're using the "free" MS Jet dll that comes installed when you install ODBC datasources (i'm pretty sure that one doesn't support rollbacks, or i'm not using it correctly - doubtful;))?

        Hi pmas,
        I did get your point about "use Access if you have it already". My point was just that unfortunatly we can't rely on our budget users allready having access.

        I also totally agree with you about access being a very good choice for inexperienced users. However, being tied into a gui can be quite anoying at times.. just like a unix prompt is so much more powerfull than the windows explorer... if you know what you are doing that is =)

        there was discussion about porting Perl to Palm PDA- can you believe that?

        Yeps... I'm actually running Perl on my Psion 5mx... works very smoothly! =)


Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://99008]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (6)
As of 2023-02-06 21:47 GMT
Find Nodes?
    Voting Booth?
    I prefer not to run the latest version of Perl because:

    Results (37 votes). Check out past polls.