RE: ISAM

2005-08-22 Thread Scott Kane
Have you tried ODBC access to dBase files? There are some weirdnesses with the Paradox driver depending on which version you're using, but ODBC should work to get to dBase files. Yep. I can do it in Windows (XP comes with ODBC configured by default) - but I can't find anything for OSX or

Re: ISAM

2005-08-22 Thread Jesse Sng
Unfortunately I don't know where to find such things. I spend a fair part of my life sucessfully avoiding database work, and would hate to break that record now. :) Hopefully someone here who's worked with ODBC will be able to help out Man after my own heart Jesse

Re: ISAM

2005-08-22 Thread Mark Wieder
Scott- Sunday, August 21, 2005, 5:38:31 PM, you wrote: Any idea where I can find them for Windows and Mac? I've been looking evrywhere for them ODBC drivers in OSX require a Microsoft product to be installed (on Windows they are installed by default). Any ideas appreciated Since you

Re: ISAM

2005-08-22 Thread Stephen Barncard
Long long ago I looked at a dBase file and it looked like tab delimited texthave you checked in a text editor? Since you were talking about dBase and Paradox, I assumed you meant Windoze... In that case, the dBase file format is *very* well defined and documented. Why not just treat the

Re: ISAM

2005-08-22 Thread Dan Shafer
There are a lot of programs around for converting DBF files to other formats. A Google search is quite fruitful. On Aug 22, 2005, at 10:36 AM, Stephen Barncard wrote: Long long ago I looked at a dBase file and it looked like tab delimited texthave you checked in a text editor?

Re: ISAM

2005-08-21 Thread Mark Wieder
Scott- Saturday, August 20, 2005, 5:55:34 PM, you wrote: I need an ISAM methodology to pull it off cleanly. Man - wish I could acees just dBase or Pardox. g Have you tried ODBC access to dBase files? There are some weirdnesses with the Paradox driver depending on which version you're using,

Re: ISAM

2005-08-21 Thread Richard Gaskin
Scott Kane wrote: If your product is on the net anyway... Create as many MySQL databases you need from a full service web host such as Dreamhost for $10/month. No maintenance, no fees, dead simple management. Thanks for the reply, but it's a desktop application. I need an ISAM methodology

RE: ISAM

2005-08-21 Thread Scott Kane
Hi Sichard, I believe both of them offer an ODBM interface, as does Rev. Any idea where I can find them for Windows and Mac? I've been looking evrywhere for them ODBC drivers in OSX require a Microsoft product to be installed (on Windows they are installed by default). Any ideas

RE: ISAM

2005-08-21 Thread Scott Kane
Hi Sichard, Sorry - I meant Richard, not Sichard. :-( Scott ___ use-revolution mailing list [EMAIL PROTECTED] Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

Re: ISAM

2005-08-21 Thread Richard Gaskin
Scott Kane wrote: Hi Sichard, Sorry - I meant Richard, not Sichard. :-( That's okay, I meant OBDC and not OBDM. :) Any idea where I can find them for Windows and Mac? I've been looking evrywhere for them ODBC drivers in OSX require a Microsoft product to be installed (on Windows

RE: ISAM

2005-08-20 Thread Scott Kane
In a single-user application where Valentina is out of price range, you should check out altSQLite from Altuit Software: Lools very cool, but sadly I'm on a zero budget (I'm on a disability pension and trying to program my way off it). There was a ISAM library (by Chipp ???) that looked good

Re: ISAM

2005-08-20 Thread Ruslan Zasukhin
On 8/20/05 10:00 AM, Scott Kane [EMAIL PROTECTED] wrote: In a single-user application where Valentina is out of price range, you should check out altSQLite from Altuit Software: Lools very cool, but sadly I'm on a zero budget (I'm on a disability pension and trying to program my way off

RE: ISAM

2005-08-20 Thread Scott Kane
If you going develop app which you will distribute in many copies to clients, then you must pay for mySQL. A lots of people think that mySQL is free. This is not true in a lots of cases. Read this: Ouch! I didn't realize that! I wonder how many ISP's (or web hosts rather) realize or

RE: ISAM

2005-08-20 Thread Scott Kane
option now. If I could just find that ISAM library (open source) for Rev I'd be set. OK. Found it. Serendipidy. I'm not sure about it at all yet. It seems a rather bitsy. I think I'll look at saving stacks containing cards to an external file instead. Thanks for your help people. Scott

Re: ISAM

2005-08-20 Thread Ruslan Zasukhin
On 8/20/05 10:26 AM, Scott Kane [EMAIL PROTECTED] wrote: If you going develop app which you will distribute in many copies to clients, then you must pay for mySQL. A lots of people think that mySQL is free. This is not true in a lots of cases. Read this: Ouch! I didn't realize that! I

Re: ISAM

2005-08-20 Thread Richard Gaskin
Scott Kane wrote: I think I'll look at saving stacks containing cards to an external file instead. For very small data sets it's hard to beat the convenience of using cards. But for anything above a few thousand records it can be cumbersome. As with HyperCard, the inventor of this engine

Re: ISAM

2005-08-20 Thread Dan Shafer
A minor (and probably unimportant in the contex) clarification: MySQL charges for distribution of the *server*. If you provide an app as, e.g., an ASP that runs on a MySQL server on a hosting service where the end user is only *using* that database and never installing the server, usage is

Re: ISAM

2005-08-20 Thread Stephen Barncard
If your product is on the net anyway... Create as many MySQL databases you need from a full service web host such as Dreamhost for $10/month. No maintenance, no fees, dead simple management. On 8/20/05 10:26 AM, Scott Kane [EMAIL PROTECTED] wrote: If you going develop app which you will

RE: ISAM

2005-08-20 Thread Scott Kane
If your product is on the net anyway... Create as many MySQL databases you need from a full service web host such as Dreamhost for $10/month. No maintenance, no fees, dead simple management. Thanks for the reply, but it's a desktop application. I need an ISAM methodology to pull it off

RE: ISAM

2005-08-20 Thread Scott Kane
Hi Don, A minor (and probably unimportant in the contex) clarification: MySQL charges for distribution of the *server*. If you provide an app as, e.g., an ASP that runs on a MySQL server on a hosting service where the end user is only *using* that database and never installing

Re: ISAM

2005-08-20 Thread Dan Shafer
As far as I know, it's living software. You can download it from what I think is its new home at: http://wecode.org/serendipity/ At least I just did so successfully. (The site was pretty slow tonight but I think it varies a lot.) (Also note that i haven't actually tried to use this stuff.

Re: ISAM

2005-08-19 Thread Richard Gaskin
Scott Kane wrote: Hi, Somone told be a while back aout a Revolution tool that was an ISAM style table system. I've mamanged to lose the link... Apart from saving cards (which is on my list) are there any other options for single user acces. MYAQL etc are to much for my users to deal with.

RE: ISAM

2005-08-19 Thread Scott Kane
Hi Richard, Depending on your indexing needs, if your data set is small enough to be used in RAM you might consider storing your data in custom properties. They are pretty light actually.Just a lot of tables. Random access of properties through array notation is lightning fast, and

Re: ISAM

2005-08-19 Thread Richard Gaskin
Scott Kane wrote: Random access of properties through array notation is lightning fast, and sequential access is suitable. Surprisingly, sequential access of a simple line-delimited list is about 15-20% faster, and may also provide a reasonable solution for tables. Cany chance of some

Re: ISAM

2005-08-19 Thread Dan Shafer
In a single-user application where Valentina is out of price range, you should check out altSQLite from Altuit Software: http://www.altuit.com/webs/altuit2/altSQLiteCover/default.htm Fast, easy to use, well documented and affordable. On Aug 19, 2005, at 1:35 PM, Scott Kane wrote: Hi,