database software

[stavefan]

Hi all,

i'm looking for an easy-to-use gui database program (similar to ms access). It doesn't have to do anything spectacular, just hold info about my cd collection, recipes, etc...

I would greatly appreciate any and all suggestions for software

thanks
stavefan

[Marcel2008]

Postgresql is a good one.
Also try MySQL.
Ok, it's not as easy as access, but then again ms access sucks.
Both linux apps come with large docs!

[stavefan]

does mysql have to be hooked up to a network, or can it be set up on a stand alone machine?

--stavefan

[Choozo]

I'm not sure if I understand your last question (or why you asked it); but yes, it runs perfectly on a standalone machine as does just about _any_ RDBMS that I know of.

As for a GUI, Mandrake 7.2 (KDE 2.x) comes with PostgreSQL Access ready installed (look under Office applications). All you have to do there is to initiate a database (don't ask me how, since I only have used Oracle and a little bit of MySQL).

Cheers! :)

[stavefan]

greetings,

Choozo-i asked the question because all the screenshots at the mysql site that i saw had some sort of newtork ip addess somewhere in the pic, so i wasn't sure if it was designed with the home, single pc user in mind...

Thanks for the tip in drake..i have 7.2 installed...I will take a look at it as soon as I can

Thanks!
stavefan

[usr3]

Greets,
There are two fundementally differnet 'types' of database's. Standalone 'desktop' (access is an example of a desktop db) and 'client server' databases. Examples of client server db's are mySQL ; postgreSQL ; and on windows SQL Server 7. A client Server database (say postgreSQL) allows folks on other machines to connect to it's databases from the network (Yes you can have multiple databases). However you can also connect to it from the machine it is on. It is a much more powerfull Database system. That doesn't mean you can't 'just' store recipes in it however. It will work just fine being accessed from the machine that it is running on.