I've been asking myself this question for a few days, ever since I started developing an interface for SQLite. What are the benefits of maintain TextDB over other DB products, such as SQLite.
I ask this question, because since PHP5, a version of SQLite is available in the PHP API without any special flags or installation onto PHP. I haven't performed benchmarking tests, but I don't have a doubt that SQLite runs faster. It's written in a superior language (C or C++ VS PHP), with superior algorithms for storing data (binary trees VS linear).
10 years ago, when TextDB and MyUPB started, there wasn't an integrated DB solution with PHP. You NEEDED to pay for access to a SQL server if you wanted a forum. That's where MyUPB stood out from the rest. TextDB made sense with PHP3 and PHP4. By now, most apache servers should be patched up to PHP5, if they're not, it's kind of a security risk. We can still support TextDB for the PHP4s out there, but the number of PHP4 servers is on a downward slope as they upgrade to PHP5, if they haven't already.
Now that SQLite is offered, one of MyUPB's selling points vanished. What's more, SQLite and PHP5 has been available for a number of years, so we've lost an edge with stagnant development.
So I write here, to ask the following:
1. what viability does the MyUPB Developers see in TextDB?
2. How can we innovate to provide a new edge?
For number #2, I propose we support a multitude of Database the user can choose from during installation. SQLite is perfect for low and medium traffic servers (and servers w/o MySQL). Offering a MySQL or MsSQL solution, and I think we can see a high traffic website adopt MyUPB, which would be really awesome.
What do the developers think?