Hi Here is the latest update with respect to additional database support. 1) Because of license restrictions , I am afraid that Oracle Instant client will not get bundled within OpenSolaris
2) Database folks within Sun seem to feel that unixODBC and Free TDS products are sort of beta quality . However, I have not heard a refusal to bundle these libraries yet. So, I am still waiting for a final answer on this topic. If in case, these client libraries are not bundled within OpenSolaris, then we might have to explore the possibility of having these as separate repositories that users can download on demand and then install the appropriate PHP module using PECL. For example, if a customer can do something like below to get MSSQL support within PHP on Open Solais that would be great. /usr/bin/pkg install http://<repository>/freetsd.pkg /usr/php5/5.2.4/bin/pecl install mssql But, we are some ways off from here and this will probably not happen before Dec'07. Now, while we wait for some decision to be made with respect to bundling database client libraries like Free TSD or unixODBC, I would like to move forward and get community feedback on the following extensions that we are planning to integrate Also, I would like to get the user community's opinion with respect to Memcached for PHP - ( http://us2.php.net/memcache ) . Should we integrate this module as well ? These are the extensions that I have identified right now - - inifile -> Ability to read PHP INI file programmatically - cgi / fastcgi -> Support PHP to run in CGI or FastCI environment. For example, this could allow Apache Worker MPM to execute PHP in FastCGI environment. - dbase -> Adds support for leveraging the bundled DBase library - flatfile -> Adds support for different file based databases - ndb / cdb -> Abstraction layer for leveraging the bundled database libraries. - SQLite -> Adds support for SQLite database. SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine. - mysql - MySQL support . This can be added as soon as MySQL support gets integrated within SXDE - xdebug -> Adds debugging support through IDE like Netbeans - pdo / pdo-sqlite -> Enable PHP data objects support. Also enables SQLite database to be accessed as PHP objects. - pear -> Allows PHP programmers to dynamically download and install 3rd party PHP extensions that are available from either pecl.php.net or pear.php.net - ldap / kerberos -> Authentication support for php programmers. Uses Sun's LDAP and Kerberbos libraries here. - pspell -> Dictionary support for programmers - snmp - Add snmp support for PHP programmers Thanks Sriram Tracy, John wrote: > You are correct regarding the Oracle drivers--I had to download the > "Oracle Instant Client" to add the support to PHP. I have been using the > MSSQL drivers in light production with no issues. It took me a few days > of bumbling around to get the support for MSSQL and Oracle added, so if > we could add these features right of the box, I'm sure it would help a > few folks. > > Once I got it all working, the first thing I did was send example > connect strings (for each DB type) and such to all of our web > programmers (for which they were immensely grateful). I think it might > be helpful to include these example connect strings in any > documentation. What does the group think? > > -John > > -----Original Message----- > From: Sriram.Natarajan at Sun.COM [mailto:Sriram.Natarajan at Sun.COM] > Sent: Thursday, October 25, 2007 4:23 PM > To: Tracy, John > Cc: webstack-discuss at opensolaris.org > Subject: Re: [webstack-discuss] Additional PHP extensions for SXDE > > Hi John > Thanks for your response. It is nice to know that customers are indeed > interested in MSSQL server support. I will start looking into the cost > of integrating this extension . With respect MySQL and LDAP , these > extensions will definitely be added in the upcoming integration. With > respect to Oracle database support - If I am not mistaken, one will need > > to have Oracle client libraries installed on the system to add support > for Oracle database. I will need to find out the licensing requirements. > > Now, if integrate support for unixODBC or iODBC - then one should be > able to use the ODBC driver manager and talk to these databases. I am > not sure on the performance and stability aspect of these ODBC driver > manager - I will definitely investigate on this as well. > > Our current integration already has support for GD libraries in > 2007/168 ARC case. > > thanks > sriram > > Tracy, John wrote: > >> Hello Sriram- >> >> We are using Ldap, Mysql, and MSSQL (through FreeTDS). It would be >> > nice, > >> although I believe impossible, if Oracle extensions were added (don't >> know about licensing and all that...). We seem to like our many >> different DB platforms around here... >> >> Are the GD libraries included in the existing ARC case? >> >> Thanks for asking- >> John >> >> -----Original Message----- >> From: webstack-discuss-bounces at opensolaris.org >> [mailto:webstack-discuss-bounces at opensolaris.org] On Behalf Of Sriram >> Natarajan >> Sent: Thursday, October 25, 2007 4:58 AM >> To: Webstack Discuss >> Subject: [webstack-discuss] Additional PHP extensions for SXDE >> >> HI >> As we all know, PHP 5.2.4 has been integrated within SXDE build 73 >> onwards. This integration is based on previously approved ARC case : >> PSARC/2007/552 >> and PSARC/2007/168. Some very useful PHP extensions like CGI / >> FastCGI, LDAP, Kerberos, MySQL, Pear etc are not included within our >> current integration. So, I am hoping that we can file additional ARC >> case to track these new extensions. So, here are the additional >> extensions that I am considering to add support for. Please take a >> > look > >> at the below list and let us know your thoughts. >> >> - inifile -> Ability to read PHP INI file programmatically >> >> - cgi / fastcgi -> Support PHP to run in CGI or FastCI environment. >> For example, this could allow Apache Worker MPM to execute PHP in >> FastCGI environment. >> >> - dbase -> Adds support for leveraging the bundled DBase library >> >> - flatfile -> Adds support for different file based databases >> >> - ndb / cdb -> Abstraction layer for leveraging the bundled database >> libraries. >> >> - SQLite -> Adds support for SQLite database. SQLite is a small C >> library that implements a self-contained, embeddable, >> > zero-configuration > >> SQL database engine. >> >> - mysql - MySQL support . This can be added as soon as MySQL support >> gets integrated within SXDE >> >> - xdebug -> Adds debugging support through IDE like Netbeans >> >> - pdo / pdo-sqlite -> Enable PHP data objects support. Also enables >> SQLite database to be accessed as PHP objects. >> >> - pear -> Allows PHP programmers to dynamically download and install >> 3rd party PHP extensions that are available from either pecl.php.net >> > or > >> pear.php.net >> >> - ldap / kerberos -> Authentication support for php programmers. Uses >> > > >> Sun's LDAP and Kerberbos libraries here. >> >> - pspell -> Dictionary support for programmers >> >> - snmp - Add snmp support for PHP programmers >> >> Here are the other popular extensions that we cannot still add support >> > > >> at this time because of missing 3rd party library dependency >> >> - unixODBC - Need unixODBC libraries >> >> - gdbm / qdbm -> Need external native database library that is not >> bundled within PHP. >> >> - ncurses -> Need ncurses library in /usr/sfw >> >> - readline -> Need readline library in /usr/gnu >> >> - imap -> Need IMAP library in /usr/sfw >> >> - gmp -> Needs GNU MP library in /usr/gnu >> >> - mssql[=DIR] Includes support for Microsoft SQL Server. >> Unfortunately, this requires FreeTDS libraries to be installed in >> /usr/sfw >> >> - unixODBC/ iODBC -> support for ODBC Driver Manager. Again, this >> requires appropriate native libraries to be installed within Solars. >> >> If you happen to know any popular extension that is not captured in >> > the > >> above list, please please let us know. This information could be >> > useful > >> in determining what other extensions to include so that PHP developers >> > > >> can comfortably develop and deploy PHP based web applications on >> Solaris. >> >> thanks >> sriram >> _______________________________________________ >> webstack-discuss mailing list >> webstack-discuss at opensolaris.org >> http://mail.opensolaris.org/mailman/listinfo/webstack-discuss >> _______________________________________________ >> webstack-discuss mailing list >> webstack-discuss at opensolaris.org >> http://mail.opensolaris.org/mailman/listinfo/webstack-discuss >> >> > _______________________________________________ > webstack-discuss mailing list > webstack-discuss at opensolaris.org > http://mail.opensolaris.org/mailman/listinfo/webstack-discuss > -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://mail.opensolaris.org/pipermail/webstack-discuss/attachments/20071029/3eb6d306/attachment.html>
