On Thursday 09 Jan 2003 12:18 am, Adolfo Bello wrote: > I came from a Borland's Paradox world and after that moved to Access > 95-97-2000-2002. > > However, most of my work as a developer has been done with Sybase, SQL > Anywhere and right now I am working with MySQL. > > I know nothing about Lotus Approach or FileMaker. > > I am still working some stuffs with Access, like travel expenses for my > own firm, and sometimes for creating quick reports with data extracted > from of a DB server. > > Access/Paradox (I don't know about Approach/FileMaker, but I guess these > belong to this category too) and MySQL/PostgreSQL/Sybase/SQL > Server/Oracle/DB2 are in different ball games. For the first category, > most of the work is done by the client while in the second one the > workload is carried by the server. > I understand this difference Adolfo, which is why I began by questioning the use of MySQL and PostgreSQL. However, since this box will be both client and server, I'm not sure whether there is an issue here.
> Selecting a db from a group or the other is a matter of what your > application will do. If your expected use of the DB points to a small > databases on a fast network you can go with the first group. For heavy > load, large databases, large number of users or slow connections (like > the Internet) goes with the second category. Security also defines the > group to pick from. > > In other words, if we are looking for a personal database, > MySQL/Sybase/Oracle/SQL Server/PostgreSQL/DB2 might not be the best > choices unless there are no more choices. In this later case, chose > between MySQL and PostgreSQL. > Although I believe both kde and gnome are working on one, there is to my knowledge no 'personal' small database program. The only other possibility is to use the database productivity built into Star Office. This is spreadsheet centred, so it's my guess that it will be only partial database implementation, as these usually are. I will look a little more into this, but I'm not too hopeful for it. > Personal databases should be easy to use in the sense of creating > tables, queries, reports and data entry forms. As I am new to Linux I > don't know any nice front-end for these tasks. I will take a look at > pgaccess. > I agree - although I often want to simply extract information to be displayed as a table, on other occasions I want a good gui display so that other members of the family can see somthing they understand. However, it is still, essentially a single user application that I need. It's just that if I can only get the functionality by using a more advanced product, then so be it. I will learn. I have done just a little work with Oracle, and enjoyed the challenge, so I'm not afraid of learning a new package. Thanks for your reply - if you do find anything more in your explorations I would be glad to hear it. Anne
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
