Databases of Choice

What's your preferred database?

  • msSQL

    Votes: 6 14.3%

  • mySQL

    Votes: 23 54.8%

  • MS Access

    Votes: 5 11.9%

  • Postgres

    Votes: 1 2.4%

  • Excel (Moederloos's request)

    Votes: 2 4.8%

  • Firebird

    Votes: 2 4.8%

  • PostgreSQL

    Votes: 0 0.0%

  • SQL Server 2005

    Votes: 2 4.8%

  • Other

    Votes: 1 2.4%
  • Total voters
    42
Hi.

Personally, I prefer postgres. Open source, easy to use with PgAdmin and I have not had any problems with mass amounts of data. MySQL is another option. I guess it just comes down to personal preference.

Note: Do not underestimate the popularity of postgres. Just because its not popular in SA does not mean its not popular. Put postgres on the poll.
 
bwana said:
mySQL

EDIT - poll added - let me know if you have additional options to add.
Click to expand...

Personally I like Pervasive.SQL
Dont know what it costs though. Next Choice for me is MS SQL.

MS-ACCESS should not be an optional, very unstable in a multi-user environment.

If they think Exel is an option, then they have been imbibing on the happy juice too much. A better free option than this is a simple flat file then.
 
hehehehe
I HATE pervasive sql. Have stuff running on it (not my choice) and will never be I think, but are having endless troubles with it. I do not like it at ALL!!!
 
Merrigan said:
hehehehe
I HATE pervasive sql. Have stuff running on it (not my choice) and will never be I think, but are having endless troubles with it. I do not like it at ALL!!!
Click to expand...

:)
Different strokes for different folks. Just make sure you have the latest version though, earlier versions were a bit shaky in some areas.
Also, depending on your environment and number of users, you need to tweak its settings a bit, then it flies.

I compared a database with a table of just under a million records in it between MS-SQL and Pvsv.SQL.
Ran the same queries on both etc and PVSV came out tops.
(MS-SQL handles very fancy queries though - joins, inserts, updates etc. If you go back to basics though with multiple sequential loops doing the same job, sometimes it makes a world of difference in performance.)

Once again though, this is all applicable to my line of work etc.
 
Wino said:
:)
Different strokes for different folks. Just make sure you have the latest version though, earlier versions were a bit shaky in some areas.
Also, depending on your environment and number of users, you need to tweak its settings a bit, then it flies.

I compared a database with a table of just under a million records in it between MS-SQL and Pvsv.SQL.
Ran the same queries on both etc and PVSV came out tops.
(MS-SQL handles very fancy queries though - joins, inserts, updates etc. If you go back to basics though with multiple sequential loops doing the same job, sometimes it makes a world of difference in performance.)

Once again though, this is all applicable to my line of work etc.
Click to expand...

granted, and as you say, different strokes for different folks. Thanks a lot for your input, it REALLY helps me :)
 
Theres that app you can download called WAMP. Last I used was WAMP5. Its free and packages Apache/PHP/mySQL in one. If I remember correctly it even has a GUI for mySQL making it far far easier to design your database and control tables/passwords etc.

Otherwise stick to the old fashioned way and do it in the mySQL command prompt style. If you are using Linux download LAMP and not WAMP :D
 
Jonny Two Shoes said:
Theres that app you can download called WAMP. Last I used was WAMP5. Its free and packages Apache/PHP/mySQL in one. If I remember correctly it even has a GUI for mySQL making it far far easier to design your database and control tables/passwords etc.

Otherwise stick to the old fashioned way and do it in the mySQL command prompt style. If you are using Linux download LAMP and not WAMP :D
Click to expand...

The version with IIS is called WIMP.
:D:D
 
We just migrated a Access "application" to MySQL. Only in the backend, but we would like to take it slow. Next is to create the frontend in PHP. Then, no more Access troubles.
 
"coding" in Access is like nailing one foot to the floor before starting the comrades.
 
Jonny Two Shoes said:
Theres that app you can download called WAMP. Last I used was WAMP5. Its free and packages Apache/PHP/mySQL in one. If I remember correctly it even has a GUI for mySQL making it far far easier to design your database and control tables/passwords etc.

Otherwise stick to the old fashioned way and do it in the mySQL command prompt style. If you are using Linux download LAMP and not WAMP :D
Click to expand...

Yeah, I know that. Veddy nice. another one is Webserv - I use that and it's also brilliant.

I Use EMS Mysql Manager along with PHP MyAdmin for most of the DB work, but I love my linux console as well ;)
 
SQL Server 2005. Its just an amazing DB, and fast as hell, currently building a DW on one. But most people do not want to pay, then you will have to go with mySQL (but between you and me...sql server 2005)
 
Gothan said:
SQL Server 2005. Its just an amazing DB, and fast as hell, currently building a DW on one. But most people do not want to pay, then you will have to go with mySQL (but between you and me...sql server 2005)
Click to expand...


Have to agree. SQL2000 was a lame horse. 2005 is a goddamn F1 vehicle.
 
Moederloos said:
Have to agree. SQL2000 was a lame horse. 2005 is a goddamn F1 vehicle.
Click to expand...

I could not believe the speed when we started working on it. But if you want speed, there is no db on this planet that is faster then AS IQ.
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X