Samy Elashmawy wrote:
>
> What do you use for the front end of your apps ??
>
> Also , you mentioned the tcl ? Can you give more ionfo ?
> Can it be used to create a dtata base application ??
> What programing languege does it use ?
Samy,
If you are running SuSE then all you need is on the distro CDs. More
than likely PostgreSQL is already installed (by default, unless you
uninstalled it), so all you need to do is look for pg_iface and pgaccess
and the other pg* database stuff. Install them, then create a desktop
icon for them. PostgreSQL also includes a console program to manipulate
the db engine called 'psql'. The package called 'pgaccess' is written
in tcl and is very similar to, but not as extensive as MS Access. The
queries tab display a designer window almost indentical to Access, whith
the tables shown graphically and lines connecting the indexed fields.
*VERY* nice. It connects via socket# 5432 and uses TCP/IP if you use
the -i switch. It is much more powerful than the other Xwindow
interfact program to PostgreSQL called mpsql. But, play with them
both. I know you will like pgaccess.
The tcl language, using the 'wish' shell, is very powerful and easy to
use. There are books available from amazon.com or O'Rielly that teach
how to use it.
>
> >>
> >
> >I would suggest PostgreSQL because of what mysql lacks. MySQL is only
> >about 10% faster than PostgreSQL but the latter is more compliant to
> >ANSI SQL92 standards. PostgreSQL offers classes, inheritance, types,
> >functions, contraints, triggers, rules and transaction integrity. The
> >last feature is one that MySQL will never have. PostgreSQL comes with
> >pgaccess, a tcl application also available for windows that looks and
> >runs similar to MSAccess, but not as extensive is MSAccess. PostgreSQL
> >is free (you can purchase support), MySQL costs if you are selling it or
> >selling a product which includes it (or you run it on Win95 or NT),
> >although the client code is GPL. MySQL won't do sub-selects, selects
> >into tables, transactions, triggers, foreign keys (but you get a
> >philosophical reason why you should not use foreign keys) and views.
> >"GROUP BY" on text fields only work if they are fixed length. ALTER
> >TABLE is used for creating and dropping indicies. GRANT is sldo
> >non-functional, MySQL has it's own non-standard security features. I
> >used MySQL and liked it. I found PostgreSQL more similar to the
> >commerical SQL engines I have used and found MySQL more limiting. I
> >switched from MySQL to PostgreSQL and am glad I did. I am looking
> >forward to version 6.5: http://postgresql.nextpath.com/ which will
> >feature multi-version concurency control, a locking scheme which allows
> >reading of locked rows without access errors.
> >
> >--
> >
> >JLK
> >Linux, because it's STABLE, the source code is included, the price is
> >right.
> >
> >
--
JLK
Linux, because it's STABLE, the source code is included, the price is
right.
--
To get out of this list, please send email to [EMAIL PROTECTED] with
this text in its body: unsubscribe suse-linux-e
Check out the SuSE-FAQ at http://www.suse.com/Support/Doku/FAQ/ and the
archive at http://www.suse.com/Mailinglists/suse-linux-e/index.html
