• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Is postgreSQL any good? or whats some good DB software?

J

JavaMomma

Senior member
Creating a database, the application is going to be written in VB6.
Looks like the DB will contain about 22+ tables probably the largest table wont contain more then a few hundred thousand rows.

Anyways normally I use Oracle but its to blood expensive for a small project like this.
I started converting the DB from its ER diagram to Access which I thought would be good enough...
Anyways the more I use Access the more I think it sucks.

So I started looking around for "Cheap" DB solutions and found posgresql, and mysql.
postgresql looked more familiar to me then mysql (or maybe mysql documentation is just harder to surf through).

So is posgresql any good? Or do you recommend something else?

Thanks for any suggesions.
 
Both MySQL and PostgreSQL are great.

MySQL generally has a reputation for providing very speedy SELECTs, while PostgreSQL supports more features than MySQL does.

Never used them in VB6, but they both have pretty standard SQL, and both work great with PHP under Linux 🙂
 
Yea, I had to research which database in the opensource world would be best, and I found a lot of praisers of Postgre. Either way, mySQL or Postgre should work great for your project, as long as it is developed properly.
 
Take a look at the current features for each. If those features suit your needs then the database program will work just fine. Although this statement may sound obvious, it really isnt. Both PostgresSQL and MySQL are great databases for small projects (and some larger ones) and will handle a fair amount of traffic. It really depends on the features though.
 
Coming from an Oracle background you'll probably want to use PostgreSQL as it supports more ACID functionality and has things that MySQL lacks like Triggers and Stored Procedures.
 
Also, PostgreSQL really seems to have gotten a hold of the speed issue - it's much faster in the latest version, although I think MySQL is still a bit faster.

100,000 rows should be ok for Postgre.
 
Thanks guys for the responses.

Anyone know what sorta system it takes to power postgresql? I can't seem to find the hardware reqs for it.

I don't know much about Access but its been suggested to me that it can do the job, I know VB & Access do work well together. Do you think postgresql is that much better then Access to make it worth the trouble of setting up a Linux/DB server and connecting to it?

There will only be one connection to the Database (although in the future, who knows).

Thanks again, I appreciate the feedback.
 
First of all, Postgre will use less power than Access, and give you more.
Is Access even SQL capable???? I don't think so.

For the database, here's what I think you will want:

a) a decent CPU - Athlon XP or a Tualatin P3... PIV with its long pipeline will do relatively badly at the job. However, it does not have to be that fast, 1 GHz should suffice.
b) RAM - lotsa RAM. Although Postgre is not that hungry, I would suggest that at least 1 Gig would be a good thing. However, I also think that SDRAM should be enough if money is a concern.
c) Finally, a database server thrives on SCSI. Pack the system on an IDE drive if necessary, but put the database on SCSI drive. 10kRPM or 15kRPM...
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top