Page 1 of 1
PHP implementation of SQL
Posted: Thu Mar 30, 2006 10:19 pm
by alex.barylski
Anyone know if anyone has attepted this or not?
Not incredibly useful, but it would be a neat project...
And really cool in scenerios where an app used AdoDB and determined SQL wasn't available and your app could default to PHP SQL...
Just curious

Posted: Thu Mar 30, 2006 10:21 pm
by Roja
sqlite is close.
Posted: Thu Mar 30, 2006 11:44 pm
by alex.barylski
Roja wrote:sqlite is close.
It's also implemented in C
Porting is out of the question...I've looked at the code for SQLite numerous times...it would be anything but trivial...
I wanted something in native PHP, just because the number and variation of hosts out there whom support MySQL, PostGre or both or none...
At least when you search for PHP hosting...you know at the very least you'll likely get PHP installed as a minimum...
SQLite would be an excellent guideline though...if one were interested writing a PHP SQL engine.
Cheers

Posted: Fri Mar 31, 2006 7:50 am
by Roja
Hockey wrote:I wanted something in native PHP, just because the number and variation of hosts out there whom support MySQL, PostGre or both or none...
My point was that the challenge you are looking to acheive is going to be solved in time.
PHP5 comes with sqlite included by default. As a result, if mysql/postgresql isn't available, sqlite will be.
Hockey wrote:At least when you search for PHP hosting...you know at the very least you'll likely get PHP installed as a minimum...
Which is why I brought up SQLite. If you have PHP5+, you have SQLite.
Since it is extremely unlikely that someone would complete a workable SQL replacement before PHP5+ is widely deployed, doesn't seem worthwhile when SQLite is available.
Interesting technical challenge, perhaps, but the (very) small niche it would be useful for is already going to be solved "any day now".
Posted: Fri Mar 31, 2006 10:43 am
by alex.barylski
Included by default eh? Interesting...
However, doesn't this mean, a host could disable SQLite?
The beauty of PHP code is that it'll always be available and likely run any most machines...
how I see it anyways
