First of all, we should be pretty upfront about computer technology: its always changing and usually not to something new.

What I mean is just about everything we deal with is at some point in a cycle. We've gone through the cycle of Centralized and Distributed computing several times very recently. We've gone through the cycle of Open Source to Proprietary and now it looks like we might be going back to Open Source for bit, of course only to go back to Proprietary at some later date.

What about database technology? Server-based databases have done quite a bit for databases in the climate of PC hardware and software during the 90's. But does it still have the edge? Will file-based databases come back?

I think so.

Perhaps only for the reason that they'll be far more portable than there service-style counterparts; perhaps even more reasons exist. I think the maintance and creation of file databases is also far simpler than server based data. And the other interesting fact is if you have a file based database, which is just some file manipulating code, you could easily build a server ontop of that. Meaning that file databases can be File based or Server based. Server based can only be server based.

I know "live backups" is used as a good reason to use something like SQL Server over something like VFP DBFs but my applications run all on DBFs and I can back them up live. I just use DyanZip to zip up the data directory while processes are running on it and it seems to work just fine. Security? Secure the file system and your file based database is secure. Its really quite simple.

So, will be go back to file-based data stores? Let me know what you think, and why one paradigm has an advantage over another.