B.Mossavari & F.Sedighian

xampp 1.7.2, oracle configuration

bmossavari — Sun, 24 Jan 2010 14:39:40 +0000

If you need to configure your xampp installation (on winXP) to connect to the oracle

- first you need to download oracle basic instant client for windows

- After unzipping the instant client on a selected directory (i.e. c:/instantclient_11_1) you need to copy all dlls from this directory to “xampp/apache/bin/”

- Add instant client directory to windows system variable’s path : follow Start -> Control Panel -> System -> Advanced -> Environment Variables and edit PATH in the System variables list

- now open up php.ini from “xampp/php” and remove semicolon from this line “;extension=php_oci8.dll”

all you have to do is restarting apache and you’re all set

here is a nice document with more general detail about installing php and the oracle instant client for linux and windows

APC (Alternative PHP Cache)

bmossavari — Tue, 22 Dec 2009 09:12:49 +0000

As of php5.2 you can use APC to create progress bar for your file upload

here is a nice document from IBM:

http://www.ibm.com/developerworks/library/os-php-v525/index.html

and if you are using php on windows environment you can download php_apc.dll from here:

http://downloads.php.net/pierre/

mysql vs oracle?

sedighian — Thu, 18 Sep 2008 13:07:42 +0000

You begin a business on the web, nobody knows in future what is your data growth rate, so think that your idea on the web is successful and you want to expand it but limitation on your database will end your growth and then you are at the end of road. mysql is not for enterprise and critical systems.

if you think that mysql is free so, oracle released express edtion that is free of charge and if your business has expanded you can go to other oracle edition and buy it if your business is successful so you have enough money to pay for standard or enterprise edtion, you must think to unlimited growth, data is mony and more data needs better repository and manager.

If your data is your money no doubt to deliver it to a bank that is more secure and with guard and other tools that save it 100%. oracle can do it for you.

sqlserver vs oracle?

sedighian — Thu, 18 Sep 2008 09:30:10 +0000

My immediate answer without discuss about technical prespective is we d’nt know in the future what is most popular os . oracle can install on any os but sqlserver is only for windows , think if in future linux or other os is the only choice what happend to your business , it is the end of road, terrible!

Get on the road to the success

sedighian — Thu, 18 Sep 2008 09:11:09 +0000

web publishing by using suitable platform is not so difficult.

we suggest tree tier designing: data tier, business role tier, interface tier

on data tier we have table and other objects that is relational design on second tier we define business roles in packages by pl/sql (oracle native procedural language) , java or c language and at third tier is php ,xhtml for presentation, so not any sql is in front end layer and you have very thin client layer, you d’nt need to know anything on the backend (database and packages) you only call package by oci8 and focus on publishing.

this mthod is secure , minimum time effort for developing and best performance.

Choosing Between Oracle Database Editions

sedighian — Wed, 17 Sep 2008 10:01:44 +0000

Oracle Database 10g Release 2 is available in several editions outlined below:

Oracle Database 10g Express Edition—a starter database for DBAs and developers. Being completely free of charge, this no-frills edition of Oracle Database supports up to 4 GB of user data and executes on one processor only. Built on the same core code as Oracle Database 10g Release 2, Express Edition provides the same set of integrated programming interfaces available in the other editions of Oracle Database 10g and can be easily upgraded to Standard or Enterprise Edition.
Oracle Database 10g Standard Edition One—a full-featured Oracle database that is ideal for small- to-medium-sized business environments. Standard Edition One provides the proven performance, ease of use, reliability and security of Oracle Database at a low cost. It can only be licensed on servers supporting up to two CPUs.
Oracle Database 10g Standard Edition—an ideal choice for medium-sized business environments. Unlike Standard Edition One, Standard Edition supports Real Application Clusters, an Oracle technology that enables the clustering of the Oracle Database, comprising several Oracle instances running on multiple clustered computers so that they operate as a single system. Standard Edition can be licensed on single or clustered servers with up to four processors.
Oracle Database 10g Enterprise Edition—ideal for enterprises that have to operate on large amounts of information. Enterprise Edition contains all of the components of the Oracle Database, offering enterprise-class performance as well as reliable and secure data management for mission-critical applications.

You can choose the edition of Oracle Database that best suits your needs and budget. As for the examples provided in this book, they should work with any of the above editions, including Oracle Database Express Edition. Unless otherwise noted, all examples provided in this book will work with Oracle Database 10g Release 2, or higher, irrespective of its edition.

Performance

sedighian — Wed, 17 Sep 2008 10:01:14 +0000

Although you can process your application data on the client side in the case of Oracle database, there are many advantages of processing data inside the database. From a performance standpoint, moving processing to the data allows you to:

Reduce the communication overhead between the web server and the database
Conserve the web server resources
Take advantage of optimizations and indexing techniques provided by the Oracle database

By using triggers and stored procedures, you can develop an application whose business logic resides entirely inside the database. Moving data processing to the database tier is particularly useful if your application is database intensive. This is because your application doesn’t need to transfer a large amount of data between tiers while processing data inside the database; instead, it sends only the final product across the wire.

Robustness

sedighian — Wed, 17 Sep 2008 09:59:12 +0000

Oracle gets high marks when it comes to performance, reliability, and scalability. Building and deploying your PHP applications on Oracle database enables you to combine the power and robustness of Oracle and the ease of use, short development time, and high performance of PHP. By using both of these technologies in a complementary way, you will be able to:

Move key business logic of your application to the data
Protect your application against data loss
Take advantage of Oracle security technologies
Leverage the power of object-oriented technology
Build transactional applications
Develop robust XML-enabled applications

All these capabilities make using PHP in conjunction with Oracle a natural choice when it comes to developing mission-critical, highly secure data-driven web applications.

Why PHP and Oracle?

sedighian — Wed, 17 Sep 2008 09:54:47 +0000

With Oracle as the back-end database, you can develop and deploy data-driven PHP applications with a powerful, proven, and industry-leading infrastructure, while still taking advantage of PHP’s ease of use, short development time, and high performance.