7 replies to this topic

[tinoymalayil]

I think Oracle is one of the best Database Application Package...
MySql is also good.
Microsoft SQl Server Consumes physical memory a lot.It slow downs your computer very much..
Oracle database is more secure than Ms SQLServer..
MySQL is Opensource.I don't have much Experiance with mySQL.If anybody have proper idea about mySQL please reply......

[Alex Cicala]

I agree, and I haven't even used it.

I have recently used Microsoft Access for a school outcome. We had to make a mind boggling database that confused me thoroughly. Then once we finished and got a D+ on it.
Then we watched a video of someone using Oracle.

It was like spreading butter on bread, as easy as that, pardon my expression.
Our school takes in sooooooo much money from fees and other sources, I think they should buy about 30 licenses for Oracle you that we can use it for IT classes.

Also MySQL is the only online database I have used, I use it for my forums, its actually a very straightforward type of database program, so yes it is good too.

[sonesay]

Oracle is very powerful and has many features. I have been using it for a few papers but we have barely touch on some of its features. The only downside to oracle is that it is very expensive and suited to medium or larger organizations. If you are building something small then MySql is probably more suited.

[damoon]

mysql is still the best but i have a question fo you......

can you use Oracle for PHP?

[MiltonFG]

You are right. In my opinion ORACLE is the best database you may use. I’ve worked with many products related to oracle and they all have insuperable quality. Just to mention an example, in all the time that I’ve used this database, I’ve never lost a single record, it’s totally reliable. If you have never used it, you’ll face the need to do of a lot of learning; probably you’ll have to consult an expert.

[Quatrux]

Oracle seems to be one of the best databases, it's very powerful and is usually used for big organizations, big projects.. I work with oracle and pl/sql quite a lot, and it offers a lot. Also sometimes I need to create a report or a form with oracle report/form builder.

MySQL is good for smaller databases, it very well suited for creating websites and storing data into it, but it's also quite powerful for bigger projects too.

SQLite is also good for smaller sites, for which MySQL is to big and when you don't want to use regular files as your database, due to permissions and backup things, sometimes it can be a headache with those permisions on a Linux server, due to different users.. You upload files through PHP or somekind of File manager online, the user is different than creating it with PHP.. you always need to CHMOD files..

Also, yes, Oracle can be used with PHP, PHP can be used with all the Databases I know.

[Nik]

Oracle is the most popular commercial database used with PHP. There are many ways of accessing Oracle databases in PHP. These include:

* The oracle extension
* The oci8 extension
* PEAR DB library
* ADOdb library

[vhortex]

damoon, on 28 September 2009 - 10:02 AM, said:

mysql is still the best but i have a question fo you......

can you use Oracle for PHP?

it is possible to connect to Oracle from PHP and I have an active website that can connect to 6 database at a time with Oracle as the main database.
Oracle have two editions, the enterprise and the free for students. there is no need to buy licenses for the free academic versions and as a programmer, we are using the free one to build and test databases for new programs before purchasing a license.

MS SQL problems was its bad habit of loading all the database locks in the memory, most of its index was also loaded at the memory space. a scheduled job in your Microsoft server that takes a big chunk of memory will cause the locks and index of MS SQL stored at the memory to be flushed and written to the hard drive to conserve memory. This problem with MS SQL is almost similar to a MySQL database which turn all of its database tables into HEAP type.

One of the best thing I love with Oracle is its portability, there is one Oracle server edition that exist for almost any Operating System that exist. Same thing is true for MySQL which makes me think a lot that Oracle and MySQL are two sibling databases. These two database also shared code at a regular interval to improve both ends.