RE: [PHP-DB] which DB to use?
Matthew, Take a close look at Sybase 12.5.2 Express Edition - http://www.sybase.com/linuxpromo They have released the latest version of their flagship database as a royalty free Linux implementation. There are constraints being 1 CPU*, 2 Gb RAM and 5 Gb Data. If your application can live within these limitations you can use it in production for free. You can even purchase support on it (not cheap though)! IMO the only serious constraint is the 5 Gb Data limit. You would need a very busy TP or DSS system to push beyond the other limits, by which time you should be able to fund the licencing of the full product. I am using Sybase Developer Edition (same code base) with the ct libraries and PHP 4.3.8 no problems. The only downside at the moment is the version of Linux - at the moment it is only certified for RH AS 2 and 3, SuSE ES 9.0 (plus a few others) but there appears to be ways of running it on Fedora Core. I am using RH 7.3 because 7.2 was the last free distro identified and I had it handy. Zap me a mail if you need more info - news sites etc. Cheers, Frank. * 1 CPU for the dataserver - you can run it on a multi cpu system with more than 2 Gb RAM. In a dual CPU host use 1 CPU for Data and one for Apache/PHP. -Original Message- From: Matthew Perry [mailto:[EMAIL PROTECTED] Sent: Saturday, 2 October 2004 12:08 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] which DB to use? Thank you very much for your help. If I had to choose between MS SQL Server or or mysql, which would you recommend? I prefer nested subqueries, triggers, procedures etc supported by SQL Server but am completely unfamiliar with any problems that may be accociated with using Microsoft's product and PHP. Ideally, I would use Oracle but it is probably outside of our budget. - matt Bastien Koert wrote: Here is a basic connect script. I would stringly recommend against using access, use mysql instead. HTML HEAD /HEAD BODY ?php // Program to test connecting to a Microsoft Access ODBC Data Source $connection = odbc_connect(postcard, , ); print Connected to datasourceBRBR; if ($result = odbc_exec($connection, SELECT * FROM postcard)) print Command executed successfullyBRBR; else print Error while executing commandBRBR; // Print results while(odbc_fetch_row($result)) print odbc_result($result, 1) . . odbc_result($result, 2) . . odbc_result($result, 3) . . odbc_result($result, 4) . . odbc_result($result, 5) . BR; odbc_close($connection); print BRConnection closed.; ? /BODY /HTML bastien From: Matthew Perry [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] microsoft access Date: Thu, 30 Sep 2004 21:28:48 -0500 Does anyone know of a good online source for using php and microsoft access. I don't want to have to use asp. Thank you for your time. Matthew Perry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ MSN® Calendar keeps you organized and takes the effort out of scheduling get-togethers. http://join.msn.com/?pgmarket=en-capage=byoa/premxAPID=1994DI=1034SU=htt p://hotmail.com/encaHL=Market_MSNIS_Taglines Start enjoying all the benefits of MSN® Premium right now and get the first two months FREE*. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] which DB to use?
I'd say never be subjective n say i'm not a fan of MS. Choose what works the best for you. Check ur budget... ur time ur method of programming and ur DB knowlede. And ofcorse the size of your project. For website(not web applications) i'd prefer mySQL For webapps I'd preffer MSSQL. For intranet use I'd preffer Oracle. M.Saleh.EG +971 50 4779817 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] which DB to use?
Thank you very much for your help. If I had to choose between MS SQL Server or or mysql, which would you recommend? I prefer nested subqueries, triggers, procedures etc supported by SQL Server but am completely unfamiliar with any problems that may be accociated with using Microsoft's product and PHP. Ideally, I would use Oracle but it is probably outside of our budget. - matt Bastien Koert wrote: Here is a basic connect script. I would stringly recommend against using access, use mysql instead. HTML HEAD /HEAD BODY ?php // Program to test connecting to a Microsoft Access ODBC Data Source $connection = odbc_connect(postcard, , ); print Connected to datasourceBRBR; if ($result = odbc_exec($connection, SELECT * FROM postcard)) print Command executed successfullyBRBR; else print Error while executing commandBRBR; // Print results while(odbc_fetch_row($result)) print odbc_result($result, 1) . . odbc_result($result, 2) . . odbc_result($result, 3) . . odbc_result($result, 4) . . odbc_result($result, 5) . BR; odbc_close($connection); print BRConnection closed.; ? /BODY /HTML bastien From: Matthew Perry [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] microsoft access Date: Thu, 30 Sep 2004 21:28:48 -0500 Does anyone know of a good online source for using php and microsoft access. I don't want to have to use asp. Thank you for your time. Matthew Perry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ MSN® Calendar keeps you organized and takes the effort out of scheduling get-togethers. http://join.msn.com/?pgmarket=en-capage=byoa/premxAPID=1994DI=1034SU=http://hotmail.com/encaHL=Market_MSNIS_Taglines Start enjoying all the benefits of MSN® Premium right now and get the first two months FREE*. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] which DB to use?
i am not a fan of microsoft go with mysql :) -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] which DB to use?
Check the MySQL docs - I *think* subqueries are supported in the latest version, but not triggers or stored procedures. But as I say, check. Alternatives? PostgreSQL or Firebird. HTH - Miles Thompson At 11:07 AM 10/1/2004, Matthew Perry wrote: Thank you very much for your help. If I had to choose between MS SQL Server or or mysql, which would you recommend? I prefer nested subqueries, triggers, procedures etc supported by SQL Server but am completely unfamiliar with any problems that may be accociated with using Microsoft's product and PHP. Ideally, I would use Oracle but it is probably outside of our budget. - matt previous message snipped - looked like thread hijacked. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] which DB to use?
On Fri, 01 Oct 2004 11:24:10 -0500, Matthew Perry [EMAIL PROTECTED] wrote: The latest version is still only alfa. Miles Thompson wrote: Check the MySQL docs - I *think* subqueries are supported in the latest version, but not triggers or stored procedures. But as I say, check. Alternatives? PostgreSQL or Firebird. HTH - Miles Thompson At 11:07 AM 10/1/2004, Matthew Perry wrote: Thank you very much for your help. If I had to choose between MS SQL Server or or mysql, which would you recommend? I prefer nested subqueries, triggers, procedures etc supported by SQL Server but am completely unfamiliar with any problems that may be accociated with using Microsoft's product and PHP. Ideally, I would use Oracle but it is probably outside of our budget. - matt Though I think you would be better to use postgres, as if you use the native tools you will get pretty good performance from php (instead of using an abstraction layer, I saw some nasty stats for pear db and postgres/mysql), don't dismiss oracle off-hand... I don't know what your price range is but my understanding is that their prices have dropped considerably in the last wee while. Otherwise use postgres, it has everything but a coffee-maker, which oracle is offering now, but is not really required. Cheers Antoine -- G System, The Evolving GUniverse - http://www.g-system.at -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php