I've always been a fan of INI files and never felt much attraction for databases such as MySQL as they only seem to add dependencies and over-complicate what should be simple to start with.
I guess this has been seen in projects like winbuilder and ninja where customized INI files are used to pass information from one side to another.
A lot of data needed to be indexed and text files were becoming problematic for two reasons:
- To save time I need to keep data in memory
- To save memory I need to keep data on files
A database seemed the only way to go and I really hated the need to keep multiple programs depending on a single place where things could go wrong. (guess I learned the hard way after all the issues we've felt on this site while using the old server).
While looking around I've found SQLite.
It doesn't require to install a service on the host computer like MySQL does. The databases are static files that we can move around with the program, it can index millions of data records and retrieve them very fast while using little RAM - I'm a happy coder.
Over these past few months I've been learning more and more about it, guess I've become a fan and since there was no forum for SQLite, then why not making one?
And the result is here - http://sqliteforum.com
It is running on myBB software and guess what type of database it is using..
You're all welcome to visit and chat if you ever see interest in moving onto this type of DB. Very cool stuff.