Re: Foxpro
От | Grant Johnson |
---|---|
Тема | Re: Foxpro |
Дата | |
Msg-id | 3CD3033C.4000708@amadensor.com обсуждение исходный текст |
Ответ на | Re: Foxpro ("David Siebert" <david@eclipsecat.com>) |
Список | pgsql-general |
David Siebert wrote: >Yea I know I am the boss and I did make the rule. This person is a good >support tech and fancies himself a programer. I am trying to get him to >understand without saying "Because I said so" He is just so sure that he >right and all the other programers here don't know what they are talking >about. Oh well you have to admit that it is a nice change to see the >management of a company telling a wannabe programer "No you will not use >Microsofts program. You will use this opensource server instead." >-----Original Message----- > Foxpro is a successor of the old DBase series. It uses the file structure from DBase and Clipper. This was a fine format, however, it was designed with a different era, and different uses in mind. The format best fits single user systems. The relationships are not binding in the same way, and the metadata is not nearly as integrated. It did not support transactions the last I worked with it. It was designed for putting all of the data in one table, and the relational part was bolted on later, and not all that cleanly. The relation function is klunky at best to work with. As for the Foxpro language, which is VERY similar to Clipper (or at least was in version 2.6) has a very dificult time supporting one to many joins, a fundamental part of normalized relational data. Whatever you do, don't try to understand what it is doing in the case loops it generates for event handling, you will hurt your head. This makes the code unmanageable and unmaintainable. Foxpro tries to be everything. It is a gui designer, an application language, and a database backend all in one package. This can be nice for a small project, but as soon as it grows, and live backups and multiple concurrent users become an issue, it falls down. PostgreSQL is, on the other hand, just the data backend, but rather than being simply a file like Foxpro or Access, it is a service running in a central place to allow concurrent requests, and resolve conflicts. You will still need something else to generate the front end interface and most of the logic. Since this is a newbie, I highly reccomend PHP. It is easy, graphical, and gets results very quickly. It can quickly give a sense of accomplishment, while still being strong enough to develop real applications with later. Then he can learn Java, and start the other applications. Just imagine the joy of being able to program in any one of MANY languages, by MANY users, and get the SAME data from the SAME source at the SAME TIME.
В списке pgsql-general по дате отправления: