DataBasing

[i.candide]

Good Afternoon,

I am trying to write a direct access database without resorting to SQL or any of the other canned servers or clients.

I understand the 'how' for creating, modifying, editing, and deleting, the steps needed to perform these tasks, and the 'why' the steps are done.

I also understand the need for locks, access control, encryption, and packing, but am at a loss for the 'how' and 'why' to do the steps that allow locking, access control, encryption, and packing.

I guess what I am looking for is a good book or tutorial. Can anyone help?

Thank you and enjoy the day,
Earl

[blueb]

Boy that's a huge area to undertake at once.

Have you considered some freeware engines that work with PureBasic such as: Cheetah (a dBase compatible program) or SQLite?

By the way both of the above are open source so you can see what's going on under the hood. In fact... the SourceForge website has many database projects.

But... to build your own is more than possible. I'd start of with a good book on basic database design such as: "Database Design For Mere Mortals" ISBN 0-201-69471-9 or "Data & Databases: Concepts in Practice" ISBN 1-55860-432-4

--blueb

[i.candide]

Good Morning,

Thank you, blueb, for the information. The Cheetah database gave me some idea of what I am looking for. After study and trial, I may be able to progress with my "hobby code'.

Enjoy the day,
Earl

[Slyvnr]

i.candide,

Here we are 6 months later, just wondering if you got Cheetah working for you?

I just started with Purebasic a couple of weeks ago (old QBasic, FoxBase+ programmer) and am using Cheetah.dll extensively in several projects. Works very well. Very Quick. A lot faster than the old FoxBase ever was.

Anyway, if you have any questions please feel free to PM me and maybe I can help out and learn more together.

Slyvnr

[pdwyer]

Start here:
http://en.wikipedia.org/wiki/Database

And it links through to

http://en.wikipedia.org/wiki/Database_s ... structures
and
http://en.wikipedia.org/wiki/Flat_file_database

This moves on to details of technologies like

http://en.wikipedia.org/wiki/Hash_tables
http://en.wikipedia.org/wiki/B%2Btree

etc

Wikipedia has become a goldmine for technical details and explanations recently