Which one?
I have just started a new job, and i am required to build a database for jobs within the agency i am working for and insert it into their web site.
Can someone please tell me what database i should use?
Or can i use Access? (if so, is Access as good as other Datbases?)
any help would be great thank you!
Andy
anti posted this at 10:29 — 18th July 2000.
They have: 453 posts
Joined: Jan 1999
mysql
And I'll even tell you why.
It's free.
It has loads of documentation.
There are hundreds of applications (including source code) you can use as examples.
It's fast. (Only DB2 is faster, but that's a bit expensive)
It handles gigantic DBs.
It's available on (almost) every platform.
And no I don't get paid for this
ciao
Anti
Ralph Slate posted this at 02:15 — 19th July 2000.
They have: 32 posts
Joined: Mar 2000
I would concur for the most part. However, remember that you are trading a few things away by using mySQL:
1) No rollbacks/commits. So you don't have transactional integrity.
2) Physical data protection. Compared to Oracle, which has lots of safeguards, mySQL is very lightweight in this manner.
3) Referential integrity.
You may not need all that, but if someone asks you how safe and secure your database is, it's no more safe and secure than if it was in Microsoft Access. Which isn't necessarily bad -- I love mySQL. But just remember, don't rely on it for mission-critical data that you can't stand to have corrupted or lost, because there is a *slight* chance it could happen.
Ralph
http://www.hockeydb.com
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.