LB Booster
General >> Suggestion Box >> Indexed File System
http://lbb.conforums.com/index.cgi?board=suggestions&action=display&num=1427941519

Indexed File System
Post by Mystic on Apr 2nd, 2015, 02:25am

Would love to see the indexed file system that is in BBC BASIC added to LBB.
Re: Indexed File System
Post by CryptoMan on Apr 3rd, 2015, 09:44am

Why don't you rather use SQL with Access, MS SQL or MySQL, etc?
Re: Indexed File System
Post by Mystic on Apr 3rd, 2015, 2:55pm

on Apr 3rd, 2015, 09:44am, CryptoMan wrote:
Why don't you rather use SQL with Access, MS SQL or MySQL, etc?


Is there an easy way to access My SQL or Access files available? Searching this board for "database" yields zero results.
Re: Indexed File System
Post by CryptoMan on Apr 4th, 2015, 3:27pm

You can do almost anything you want with LBB including SQL.

If you can tell us what you want to do maybe we can Show you a prototype SQL example for you.

Best.

CryptoMan
Re: Indexed File System
Post by Mystic on Apr 14th, 2015, 7:07pm

on Apr 4th, 2015, 3:27pm, CryptoMan wrote:
If you can tell us what you want to do maybe we can Show you a prototype SQL example for you.


How about just a simple address book example utilizing MySQL. Might be the easiest for most people to understand as a tutorial.

Thanks,
Re: Indexed File System
Post by metro on Sep 14th, 2016, 04:01am

Quote:
How about just a simple address book example utilizing MySQL. Might be the easiest for most people to understand as a tutorial.

Thanks,

If you have the time Cryptoman I'm keen to see an example too
Re: Indexed File System
Post by Jack Kelly on Sep 14th, 2016, 07:43am

Cheetah also provides an indexed file system. I have two example programs posted on this forum. Remember-It and DBMS, both in the Showcase section. But I too would be pleased to see an SQL example, CryptoMan.
Re: Indexed File System
Post by Richard Russell on Sep 14th, 2016, 08:28am

on Apr 2nd, 2015, 02:25am, Mystic wrote:
Would love to see the indexed file system that is in BBC BASIC added to LBB.

BBC BASIC doesn't have any built-in "indexed file system" capability; it doesn't even have the functionality of Liberty BASIC's put and get statements! There's certainly nothing that BBC BASIC's file-handling capabilities can do that LBB's cannot do (indeed I had to enhance BBC BASIC for Windows in order to support LBB in this regard).

The only "indexed file system" that I can guess you may be referring to is an example program (it must have been written in the 1980s) listed in the BBC BASIC help manual. That uses two files - an index file and a data file - to implement a simple random-access database. But it's just a regular BASIC program, and one that could be straightforwardly translated to Liberty BASIC.

Richard.