Which database???????

[buju]

I am about to install a database at home, and I would like a little feedback as to which database I should use. My choices are between MySql and Postgresql, if there's anyone who used both, would like your opinion as to wich one I should use.
Looking at a few job postings I noticed that MySql is mentioned a lot. Which do you guys think I should use?

[Any]

I guess it depends on what you are wanting to use it for.

[Choozo]

MySQL - Really fast, and a good allround RDBMS.
PostgreSQL - Fast too, but better transactional support and have subselects.

If you want to use this as a means to a career change, why not go for 'the real thing' and download Oracle. Freely available from oracle.com.

[Stuka]

If you're DB is going to be mission critical, or have multiple writers modifying it, choose PosgtgreSQL. If it's read only (or is for 99.9% of the clients) and speed is more important, go with MySQL. Your data is safer with PostgreSQL, but you lose a bit of speed.

[buju]

Actually, I had installed PostGresql when I installed the OS (RedHat 7.3). But, I haven't set it up and created any databases as yet. I wanted to use Oracle, because I have experience with Oracle from client side using forms, reports and Pl/Sql. I am using a Pentium 166MMX with 64MB of ram. I don't think it would run smoothly with Oracle with regards to resources.
I'll be rgaduating soon from College and have beel looking at job postings, and a few of them they have mentioned MySql. From the research I did, PostgreSql seems better.
I think I will stick with PostGresql as I don't think it would be difficult to work with MySql if I have to.
I want to play around with some java applications using a database and also some web stuff also.

[Stuka]

MySQL is easy to work with - but you don't have stored procedures, subqueries, or transactions (yet).

[ardenk]

The more i read the clearer it becomes that postgres is the better way to go because it offers more robust features and is more scalable under moderate to heavy loads.

i found some good info at http://www.linuxplanet.com/linuxplanet/tutorials/

[buju]

Actually, that's the one I used. I am using it for my website with JSP. The gui admin tool pgAdmin is great. So far, I'm satisfied with it.

[ardenk]

great to hear you got everything working!

i started programming with c++ then vb which almost writes itself. I've never programed with jsp but i guess it can't be that hard. could you suggest some books?

also what hardware are you using? i have to build a box for this project.

thanks
:D

[buju]

I'm using a 166MMX with 64MB of ram, and running the server in text mode. I used soem resources I found on the net, and two books I got from the library; Professional JSP by Wrox and Instant JavaServer Pages by Paul Tremblet. They have a lot of examples and it's like java really and java is almost like C++. It's pretty interesting, I haven't got time to go looking for some text as yet.

[ardenk]

Check this out, http://www.phpbuilder.com/columns/smith20010821.php3?page=2 ya might be able to get it to run faster if you change memory allocation. pretty cool !!