Which database software should I use?

P

pat127

Registered User
Messages
386
I've been trying to set up data in a Lotus Notes DB but am unable to figure out how to do so. Is there a better alternative? What about MySQL? Is it within the capability of someone with no real experience with DBs?
 
It really depends on the amount of data and how you want to use it.
Microsoft Access is handy for small databases. Pivot tables in excel do quite a good job of simple analysis. Once your data sets start getting bigger, something like Microsoft SQL Server may be the job.
 
It depends. What is the data, what is the volume, what sort of questions to you want to ask about the data?

MySQL and SQL Server on their own are probably too advanced and low-level for your situation.
 
What MugsGame said, Lotus Notes is not for the uninitated and not really suitable as a database (it's better at groupware-type stuff); you'd be better off with something like MS Access as you have no real experience with DBs. Access provides some good wizards to setup most of the basic/standard stuff that people need.

If you like to post some more details on what you're planning on doing, then we may be able to offer further advice
 
Thanks all.

I need to store and access information (name/address/phone/opening hours etc) about facilities and services in the South Dublin area, (churches, creches, schools, GPs, TDs, PCs, Active Retirement Groups, voluntary organisations, etc etc). The data is maintained currently on a set of cards and in a folder. Perhaps 200 hundred items in all.

I propose to set up and maintain the base myself (am computer-literate but have no experience with DBs). A number of people willl require to access the data so that the DB should be simple to use.
 
I'm pretty certain you could set up the info in a spreadsheet like excel, one row shows all the details of a particulat group with all the details spread out in columns. You could then use the data filter function to access the row(s) you require by function area etc.
 
asdfg and Beefy.

Many thanks for replies. Looks as though I have the basis for a solution.
 
First thing is to understand your data and fully work out what your requirements are. Learn how to design a database from from first principles using industry standards. For instance look up what is called designing to third normal form (3NF)... it means you will prevent repeating elements, identify unique keys etc.

Next choose a database suitable for the job. If you have multiple concurrent users then do not use Access as it has major problems where users lock each other out of tables. Most professional db developers have a healthy disregard for Access but for ease of use it probably won't be beaten if you are looking for a single user system or for a very small group of users. I understand the top free databases are mySQL or postgresSQL but Microsoft SQLServer express sounds interesting as well. I must admit I'm in the database side of development for years, but I've never heard of Filemaker or the other choice referenced.

Best of luck.
 
gearoid said:
I must admit I'm in the database side of development for years, but I've never heard of Filemaker or the other choice referenced.
.
Click to expand...


Filemaker was developed for the mac first- you may find it in mac houses like small print shops , galleries etc!
jd
 
Anything other than Excel is a massive overkill for a "database" with a single table of 200 records.
 
darag said:
Anything other than Excel is a massive overkill for a "database" with a single table of 200 records.
Click to expand...

I agree completely.

Databases are made for large amounts of information which need to be easily accessible (easy to find a particular row or field of information) and easy to index.

200~ records are easily manageable in excel...
 
Agree - a single table of c. 200 rows/records is unlikely to need more than something like MS Excel or OpenOffice Calc.
 
I'd tend to use a simple contact management system for that kind of data. Download.com even has some free ones.
 
Oops - It pays to read the whole post... I must admit I didn't see the bit about 200 records... Please ignore my post as yes a spreadsheet sounds perfectly suitable under the circumstances.
 
Try this;
[broken link removed]

It allows you to set up custom fields. (It's free)
 
No offence but a declaration of vested interest might be in order even if it is free (albeit associated with a commercial product).
 
There are absolutely no associations with our commercial products. It's a handy utility that we developed, and I just decided to make it available purely for altruistic reasons

[I am associated with Payback.ie, the site hosting the utility]
 
umop3p!sdn said:
[I am associated with Payback.ie, the site hosting the utility]
Click to expand...
That's all that I meant. Also - while the software may be free to download it is governed by the following click through license agreement which doesn't necessarily mean that it's truly free and some of the terms & conditions may not apply or be acceptable to some users.
 
You must log in or register to reply here.
Menu
Log in
Register