Home > Article > Backend Development > Comparison between adodb and adodb_lite_PHP Tutorial
Comparison between adodb and adodb_lite
Author: Xinran Suifeng
adodb has been affirmed and supported by many PHPers since its birth. I don’t know when adodb_lite came out, which is said to be a shrinking of adodb. version, and claims that it does not affect the basic functions of the original version. Out of N impulses, some simple comparisons were made between the two, and the results were ridiculous. The following are the comparison results:
adodb_lite lacks:
1. FetchNextObject(); // This impact is not very big.
2. DBDate();
3. CacheSelectLimit(); // Surprisingly, this is not supported, and even commonly used MSSQL cannot be supported!
4. RecordCount() and RowCount() // are synonymous functions but only the former is supported;
5. Caching is not supported;
6. Transaction processing is not supported.
Summary: adodb_lite is at best a database operation class, portability is empty talk, and having N types of database operation files in the folder is simply a waste of space. Advanced functions have been castrated!
Today I downloaded the latest version 1.12 from the official adodb_lite website and tested it. Unexpectedly, the ones I tested above still failed, and there is a new problem. SetFetchMode is not supported. () , forcing only subscripts to be used to obtain values, and field names cannot be used as subscripts. So disappointing.
SetFetchMode() To open the pear Module, remove the last line of comments in the module config file.
It is also possible not to call the pear Module, but set the global variable to ADODB_FETCH_ASSOC