Jump to content



Welcome to AstaHost - Dear Guest , Please Register here to get Your own website. - Ask a Question / Express Opinion / Reply w/o Sign-Up!

Toggle shoutbox Shoutbox Open the Shoutbox in a popup

@  styleseye : (24 April 2014 - 02:29 PM) Https://www.facebook.com/l.php?u=Https://www.youtube.com/watch?v=Geh4Rs-Boh8&feature=Youtu.be&h=Taqexxpem
@  styleseye : (24 April 2014 - 02:28 PM) Https://www.facebook.com/l.php?u=Https://www.youtube.com/watch?v=Geh4Rs-Boh8&feature=Youtu.be&h=Taqexxpem
@  yordan : (21 April 2014 - 09:11 PM) Hey, Ritesh, Did You Hear Me?
@  yordan : (14 April 2014 - 05:28 PM) By The Way, This Could Be An Interesting Subject For A Topic, What About Posting This Question? Let's See If Other People Have The Same Feeling Concerning Bootlists!
@  yordan : (13 April 2014 - 09:36 AM) Boot Order : Cd, [Usb,] Hard Drive :D
@  yordan : (11 April 2014 - 07:23 PM) I Simply Let The Bios Do That
@  Ritesh : (11 April 2014 - 10:23 AM) Is It Possible To Launch Fedora Live Cd Or Installation Disk From Hard Drive On Windows Platform Using Grub Mbr File.
@  Ritesh : (11 April 2014 - 10:21 AM) No U Are Not.. Btw.. I Have Question For You.
@  yordan : (10 April 2014 - 08:02 AM) You Are Partially Right.
I Was Not.
Nevertheless, I Am Again :)
@  Ritesh : (09 April 2014 - 07:33 PM) :P
@  Ritesh : (09 April 2014 - 07:33 PM) I Think U R Not..
@  yordan : (09 April 2014 - 09:28 AM) I'm The Master Of The Shoutbox!
@  yordan : (05 April 2014 - 10:32 PM) He-He
@  Ritesh : (04 April 2014 - 06:59 PM) Ha Ha Ha ....
@  yordan : (04 April 2014 - 11:15 AM) Welcome Back, Starscream!
@  yordan : (03 April 2014 - 02:31 PM) And I Hope That He Will Come Back Soon :)
@  yordan : (01 April 2014 - 02:53 PM) Nice, Ritesh Came, I'm Not Home Alone Today.
@  Ritesh : (01 April 2014 - 08:51 AM) Oh!!! Poor Dear Yordan..
@  yordan : (31 March 2014 - 10:02 AM) I'm A Poor Lonesome Cow-Boy
@  yordan : (27 March 2014 - 02:22 PM) He Is Unpatient Due To His Patients!

Replying to Tell Us Which Database You Use Mostly which one you prefer


Post Options

    • Can't make it out? Click here to generate a new image

  or Cancel


Topic Summary

infotornix

Posted 17 February 2011 - 12:52 PM

Free is the best and when it comes with open source its the best .
So mysql is best for me.
Lots of developer and usud in most server the mssql is wins all the way.
well if you see others they are so costly and when comes to using with cantos os its the one that anybody can go for.

nirvaman

Posted 24 January 2011 - 11:51 PM

I use and prefer Mysql because it helps me a lot with PHP development , and because i don't have an idea about other databases working.
Why change something that works?

labstuffs

Posted 24 January 2011 - 06:53 PM

I've been using Oracle for too long.

starscream

Posted 24 January 2011 - 03:01 PM

Only thing i didn't managed to do with SQLite is the connecting database to ironpython program. I would like to learn that and want to create some small programs that can run on multiple platforms. I know there is administrator for SQLite but i have no idea how to work with flat files for the desktop and how to attach the program with that file and ship it. If i get any idea of doing that then i'm going to be on spree of small programs that do minimalistic to-do tasks. :-)

Atomic0

Posted 24 January 2011 - 10:56 AM

I am currently using SQLite for databases since I have been learning and working at the same time with iiPhone development, in addition to the programming language Objective-C. Although I have accessed and modified SQLite databases directly from the programming code in my applications, I have more recently been using the Core Data framework, which stores its data in a SQLite database (technically, access to the underlying database of the Core Data framework is discouraged by Apple, since any changes can impact the integrity of the data stored in the framework system). As a result, I don't really get to do much SQL statement programming. However, having worked with lots of applications on the iPhone, it seems that SQLite was the right database for use in embedded systems due to its lightweight size and portability without having to host a dedicated SQL database server.

vistz

Posted 18 January 2011 - 09:55 PM

You can interchange MySQL and Oracle but still it depends on how much feature you used. It is also possible to write a generic or abstract driver for your database needs which will render your Java application immune to the differences in the flavors/variant of database softwares but this will restrict you to use the commonly available commands and feature.

Since Java was now owned by Oracle, expect that connecting to Oracle will be much easier as time progress.

The difference between Oracle and MySQL is huge on high volume data access and multi user concurrent transactions but this advantage also comes with a high difference of fee. MySQL professional can handle 1/4 - 1/2 of what power that oracle can do at high load. Most system can get away with this restriction but on inventory systems that was being used 24 hours of the day and 7 days a week with a high traffic/user rate, you will end up finding out that your MySQL starts to lag out.

When using your database on purely web purposes, an Oracle server is an overkill unless you are having more than 5000-10000 or even more concurrent connections at a time, MySQL will choke up.

What you say is true. However, the company that I am getting hosting from has MySQL databases. Also, as you said about the concurrent connections, I don't plan on having more than 5,000 connections at the same time.

vhortex

Posted 14 October 2010 - 10:34 PM

I primarily program in Java and I'm trying to integrate Java with databases. Most of the examples I've seen use MySQL databases but I've seen some instances where an oracle database is used.


You can interchange MySQL and Oracle but still it depends on how much feature you used. It is also possible to write a generic or abstract driver for your database needs which will render your Java application immune to the differences in the flavors/variant of database softwares but this will restrict you to use the commonly available commands and feature.

Since Java was now owned by Oracle, expect that connecting to Oracle will be much easier as time progress.

The difference between Oracle and MySQL is huge on high volume data access and multi user concurrent transactions but this advantage also comes with a high difference of fee. MySQL professional can handle 1/4 - 1/2 of what power that oracle can do at high load. Most system can get away with this restriction but on inventory systems that was being used 24 hours of the day and 7 days a week with a high traffic/user rate, you will end up finding out that your MySQL starts to lag out.

When using your database on purely web purposes, an Oracle server is an overkill unless you are having more than 5000-10000 or even more concurrent connections at a time, MySQL will choke up.

vistz

Posted 10 October 2010 - 08:47 PM

I primarily program in Java and I'm trying to integrate Java with databases. Most of the examples I've seen use MySQL databases but I've seen some instances where an oracle database is used.

vhortex

Posted 25 August 2010 - 05:58 PM

I like to use Mysql just i seems easiest for use and i find the best and i didn't really know there were others out there it seems Mysql is the most used of them all in websites so i have to use it lol but i do prefer it, i have tried the others and don't really like them and like 8ennett said PHP=mysql they go hand in hand really most Php scripters use it


On some..

PHP = Oracle, MySQL and Postgre..

I think postgre is on a development end since it was having less and less exposure and use. For ordinary websites and hostings, you will always get MySQL since it was free but you can always have the hosting install Oracle which operates faster but have more rigid locking and multi user mechanism or you can just set it up to run like a clone MySQL server.

Oracle is not free and cost a huge amount of money for the license. Using it requires adding a few library files for Oracle to your PHP installation. This libraries will enable you to access Oracle on a manner similar to accessing MySQL server. The library is free but the database server software was not.

frazz86

Posted 25 August 2010 - 05:25 PM

I like to use Mysql just i seems easiest for use and i find the best and i didn't really know there were others out there it seems Mysql is the most used of them all in websites so i have to use it lol but i do prefer it, i have tried the others and don't really like them and like 8ennett said PHP=mysql they go hand in hand really most Php scripters use it

Review the complete topic (launches new window)