I can't get my hands on MS access ( was given filemaker Pro this morning, what a waste of space that is. ) , so i'm thinking of using pure ASP to create a database in a text file.
I will have seperate text files for tables, use my own set syntax for fields and records, and using cheaty style ASP to create relations, has anyone had any experience of creating a DB like this?
any major problems? Gems of wisdom?
Text stream magic?
Is it do-able with just a simple DB and ASP...?
Firstly, why reinvent the wheel? Secondly, why not try something like MySQL (which is free) and MyODBC from ASP if you're going to try something like that?
Whilst writing a database from scratch is a pretty cool hack, you're likely to run into all sorts of problems. Support, extensibility and the fact it sounds incredibly proprietary being the three that spring to mind.
I know. ASP has some great methods for handling text streams and files. I'm just saying, you're probably making a lot of hard work for yourself. It sounds like you've already worked out your answer anyway And MySQL does run under Win32, so no need for a *NIX host.