I don't want to use access anymore or depend on FileMaker to make my databases. I would just like some info if anyone has some good choices on which database program would be good.
Usages are for massive amounts of text data, retreiveing and searching through it alot.
And also if I'm able to place photos and media files in there and be able to search through it...I am knew to this so please give me some ideas all input is appreciated.
Agree with the previous answer. I use MySQL myself and its a great open source package. Easy to use and learn. Great tools available to give you more control through a gui.
One thing to bear in mind is that the version you download should be the same or at least very close in version numbers to the one run by your web host or you may find that any databases you have created may not run on your web hosts servers as they are using a different version which may not support certain features which you are making use off.
It is possible to run to versions of mysql under the same pc that way you can get start to learn the newer features of the database so that you will be ready to take advantage as and when any upgrade takes place on your hosts web servers.
There are other alternatives out there such as:
to name but a few.
I think MySQL is popular databasing software in the world. All of the paid service using MySQL for users. Also, all of the web programmes like Joomla!, phpbb etc. use MySQL for the databases.
howver switching to mysql will not be so easy because you are used to access where in everything is done using the GUI.
And if you intend to use it with VB , your lfe will be more difficult.
I would suggest you MS-SQL if you can buy it.
Else also try posgress or firebird.
Most database Systems come in two parts: the database SERVER and the front end. For the database server, there are a number or quality free options. Several people have already mentioned mysql and while it's quite good, there are other options you should consider. IBM makes a free version of their DB2 software and will even send it to you for free on physical media. (http://www-306.ibm.com/software/data/db2/express/getstarted.html) Oracle and M$ also have free versions of their SQL servers, but they have more limits than DB2. If you need something smaller, Firebird (http://www.firebirdsql.org/) has a very small footprint, yet still has good features. PostgresSQL (http://www.postgresql.org/) also has fans.
The frontend is a harder topic. *nix users with KDE have Kexi and Knoda, both of which are quite good clones of the M$ Access system. Gnome users are less lucky, they only have Glom, which while quite nice, works only with PostgresSQL. OpenOffice also has a decent database module that can work either which OO's own (rather crappy and slow) internal DB engine or with just about any other on the planet.
My own current set up is OO Database + InterBase, a commercial version of Firebird.
Thanks For All The Replies I will carefully look into all that was mentioned.
If you want free database use mySQL (considered very stable and very popular amongs free software users). But if you have money to spend try Microsoft SQL Server, you cant go wrong with that.
Will Look Into Both, Thanks
MySQL is a good choice. But the one compared with Oracle is PostgreSQL. You can think which one is better.
I think MySQL is the best database software. Most of the webhosts use this software. I use it to make a forum and a blog.
I use mysql as well. I hear Postgres is actually really good as well.