Jump to content
xisto Community
Sign in to follow this  
tinoymalayil

Oracle Is The Best Database Application Comparison of database aplication like Oracle,mySQL,Ms SQLServer etc

Recommended Posts

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......

Share this post


Link to post
Share on other sites

I agree, and I haven't even used it. :PI 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. B)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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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. :P

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.