I know it's possible to play around with Access files on UNIX systems, but you have to install/config some kind of ODBC enviornment.

You're correct. A quick search on Google turned up several possible ODBC drivers for Unix. On Windows this is a great solution because the Jet engine works quite well and you have the "one file" convenience of the MDB (Access) file. Keep in mind that even on Windows, your program isn't talking to the file directly, it's talking to a full-featured data base server (Jet or MSDE) via ODBC. However, with this solution on Unix, you'd still need a Windows server to host the Jet engine and the Access/MDB file. Probably not what you want. As mentioned here, I think AnyData or XBase would be your best bet. If your data set is going to be large and search time is important then you may need to bite the bullet and go with a "real" DB server to get the performance you need.

In reply to Re: Re: Single file RDBMS w/o system install by RhetTbull
in thread Single file RDBMS w/o system install by gryphon

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


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.