Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: Re: Single file RDBMS w/o system install

by RhetTbull (Curate)
on Nov 13, 2001 at 17:46 UTC ( [id://125040]=note: print w/replies, xml ) Need Help??


in reply to Re: Single file RDBMS w/o system install
in thread Single file RDBMS w/o system install

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.

  • Comment on Re: Re: Single file RDBMS w/o system install

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (5)
As of 2024-04-19 22:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found