Re: SQLs Servers in Debian
On Tue, Jan 12, 1999 at 09:34:41PM -0800, Pann McCuaig wrote: Does it make much sense to have a generic gui frontend to an SQL db? Usually you would want something specific to your database/application. Ah, here's a difference between the Pee-Cee world and the *nix world where there's something to be said for the other place. It's really handy to be able to take a quick look at a database to see what the structure is like, how many tables, how many records, etc., etc. [6:26pm] [EMAIL PROTECTED]:/usr/doc/mysql-manual/html mysql rising Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2863 to server version: 3.21.31 Type 'help' for help. mysql describe releases; +-+--+--+-++---+ | Field | Type | Null | Key | Default| Extra | +-+--+--+-++---+ | version | char(50) | | || | | releasedate | date | | | -00-00 | | | program | char(50) | | || | +-+--+--+-++---+ 3 rows in set (0.00 sec) mysql quit Bye So I had to look it up, but that's because I do SQL work a few times a year at most. A GUI might be nice occasionally but is only (to me) useful for bootstrapping a custom interface, which is what should really be deployed. That's something like 90% of the audience for Delphi and Visual Basic -- quick and dirty DB frontends. Hamish -- Hamish Moffatt VK3TYD [EMAIL PROTECTED], [EMAIL PROTECTED] Latest Debian packages at ftp://ftp.rising.com.au/pub/hamish. PGP#EFA6B9D5 CCs of replies from mailing lists are welcome. http://hamish.home.ml.org
Re: SQLs Servers in Debian
On Mon, Jan 11, 1999 at 04:27:30PM -0400, Paulo Henrique Baptista de Oliveira wrote: I have some questions: 1) Is there any frontend gui to postgres in Debian Hamm or Slink or Pota to? 2) Is there any frontend gui to mysql in Debian Hamm or Slink or Potato? Does it make much sense to have a generic gui frontend to an SQL db? Usually you would want something specific to your database/application. You can build web based front-ends with www-mysql/www-pgsql or php3 quite easily. Hamish -- Hamish Moffatt VK3TYD [EMAIL PROTECTED], [EMAIL PROTECTED] Latest Debian packages at ftp://ftp.rising.com.au/pub/hamish. PGP#EFA6B9D5 CCs of replies from mailing lists are welcome. http://hamish.home.ml.org
Re: SQLs Servers in Debian
On Wed, Jan 13, 1999 at 02:52:49PM +1100, Hamish Moffatt wrote: On Mon, Jan 11, 1999 at 04:27:30PM -0400, Paulo Henrique Baptista de Oliveira wrote: I have some questions: 1) Is there any frontend gui to postgres in Debian Hamm or Slink or Pota to? 2) Is there any frontend gui to mysql in Debian Hamm or Slink or Potato? Does it make much sense to have a generic gui frontend to an SQL db? Usually you would want something specific to your database/application. Ah, here's a difference between the Pee-Cee world and the *nix world where there's something to be said for the other place. It's really handy to be able to take a quick look at a database to see what the structure is like, how many tables, how many records, etc., etc. You can certainly do that with SQL (I do it regularly), but I do find myself remembering fondly how much easier it was to do in Paradox for DOS. Note that I'm not talking about an application-specific front end, that's an entirely different kettle of fish. -- your man pann
Re: SQLs Servers in Debian
On Wed, Jan 13, 1999 at 02:52:49PM +1100, Hamish Moffatt wrote: On Mon, Jan 11, 1999 at 04:27:30PM -0400, Paulo Henrique Baptista de Oliveira wrote: I have some questions: 1) Is there any frontend gui to postgres in Debian Hamm or Slink or Pota to? 2) Is there any frontend gui to mysql in Debian Hamm or Slink or Potato? If you've got the correct requirements installed, give a try to phpMyAdmin (for MySQL) Does it make much sense to have a generic gui frontend to an SQL db? Usually you would want something specific to your database/application. It does to me. Ask yourself, does it makes much sense to have a generic SQL language, usually, you would want something specific for your database/application... ;) To me, it's just a different approach than command-line SQL statements. Christian Lavoie [EMAIL PROTECTED]
RE: SQLs Servers in Debian
1) Is there any frontend gui to postgres in Debian Hamm or Slink or Pota to? Install the tcl postgres package and you will get a tcl/tk pased frontend caled pgaccess. It is rather nice.
Re: SQLs Servers in Debian
PHBdO == Paulo Henrique Baptista de Oliveira [EMAIL PROTECTED] writes: PHBdO 2) Is there any frontend gui to mysql in Debian Hamm or Slink PHBdO or Potato? xmysql and xmysqladmin PHBdO 3) Browsing documentation of mysql (mysql manual), I tried to PHBdO start mysq l and connect to mysql database as a normal user, PHBdO but the following error occurs: PHBdO [13:52:[EMAIL PROTECTED]:~$mysql mysql PHBdO ERROR 1044: Access denied for user: '@localhost' to database PHBdO 'mysql' Your user doesn't have permission to access the database from this host. You know the username and password for the administrative account? If not, You will have to delete the mysql database to clear al entries and define a new administrative account. The permission system used by mysql is rather delicate. Try xmysqladmin and respect the comments in the Grant rights dialogs. Ciao, Martin
Re: SQLs Servers in Debian
Shaleh wrote: 1) Is there any frontend gui to postgres in Debian Hamm or Slink or Pota to? Install the tcl postgres package and you will get a tcl/tk pased frontend ca led pgaccess. It is rather nice. This package is called libpgtcl. -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver PGP key from public servers; key ID 32B8FAA1 Enter into his gates with thanksgiving, and into his courts with praise. Be thankful unto him, and bless his name. Psalms 100:4