Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

comment on

( #3333=superdoc: print w/replies, xml ) Need Help??
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...:)

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


In reply to (pmas) Re: Cross platform perl development by pmas
in thread Cross platform perl development by kapper

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 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? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (2)
As of 2022-01-27 20:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:












    Results (71 votes). Check out past polls.

    Notices?