Re: a web interface to visualize tables
I need a tool to interactively visualize DB tables from a web interface. Ideally this tool would let me: - rename column headers, - set cell alignments, widths, background colors, - reorder columns, - save all these visualisation settings in a DB, - it would be written in perl (even better: mod_perl), I have written a tool that let you view/browse/search/edit database tables or single rows. It's a Perl modules and it's based on HTML::Embperl (therefore it runs under mod_perl) and DBIx::Recordset. I have used it sucessfully with mysql, Oracle, PostgreSQL and MSAccess, but it should also work for other databaseses for which a DBD driver exists. You can use it as standlone tool for maintaining a database or embedd it's (configurable) views inside of other webpages. The configurations is currently stored in a text file, but it should be very easy to put it into a DB. A large set of configuration options exists to adapt the look and feel. The only reason, why I didn't released it to CPAN yet is, that I don't have the time to write some more docs for it (basic docs are available). If anybody wants to take a look at it, drop me a not and I send you a copy. Gerald
Re: a web interface to visualize tables
On Nov 1, 4:57pm, Louis-David Mitterrand wrote:
I need a tool to interactively visualize DB tables from a web interface.
Ideally this tool would let me:
- rename column headers,
- set cell alignments, widths, background colors,
- reorder columns,
- save all these visualisation settings in a DB,
- it would be written in perl (even better: mod_perl),
Have a look at the Template Toolkit, and in particular the DBI and Table
plugins.
The DBI plugin does pretty much what you would expect. The Table plugin
takes some data (including the data iterator returned by the DBI plugin)
and allows you to format it in a virtual table. How you present the
data is then entirely up to you, and is controlled by templates.
Here's an example adapted from the manpage for the Table plugin.
[% USE DBI(dsn,user,pass) -%]
# query() returns an iterator
[% results = DBI.query('SELECT * FROM alphabet ORDER BY letter') %]
# pass result set into Table plugin
[% USE table(results, rows=8, overlap=1, pad=0) -%]
table
[% FOREACH row = table.rows -%]
tr
td[% row.first.letter %] - [% row.last.letter %]/td
[% FOREACH item = row %]
td[% item %]/td
[% END %]
/tr
[% END %]
/table
The key concept is that the Table plugin does nothing more than order
your data into virtual rows and/or columns. You can then iterate through
the data by row, column, or any combination of the two, and present it
any way you wish, by use of templates (*real* templates, not the embedded
Perl variety). In other words, it gives you a clear separation between
data, logic and presentation.
For different presentation styles, you can simply create different
template components to display the data, e.g.
[% USE DBI(dsn,user,pass) -%]
[% results = DBI.query('SELECT * FROM alphabet ORDER BY letter') %]
[% INCLUDE fancy_table %]
[% INCLUDE plain_table %]
[% INCLUDE boring_table %]
See http://www.template-toolkit.org/
or http://www.cpan.org/modules/by-module/Template/
HTH
A
--
Andy Wardley [EMAIL PROTECTED] Signature regenerating. Please remain seated.
[EMAIL PROTECTED] For a good time: http://www.kfs.org/~abw/
Re: a web interface to visualize tables
I need a tool to interactively visualize DB tables from a web interface. Ideally this tool would let me: - rename column headers, - set cell alignments, widths, background colors, - reorder columns, - save all these visualisation settings in a DB, - it would be written in perl (even better: mod_perl), I have written a tool that let you view/browse/search/edit database tables or single rows. It's a Perl modules and it's based on HTML::Embperl (therefore it runs under mod_perl) and DBIx::Recordset. I have used it sucessfully with mysql, Oracle, PostgreSQL and MSAccess, but it should also work for other databaseses for which a DBD driver exists. You can use it as standlone tool for maintaining a database or embedd it's (configurable) views inside of other webpages. The configurations is currently stored in a text file, but it should be very easy to put it into a DB. A large set of configuration options exists to adapt the look and feel. The only reason, why I didn't released it to CPAN yet is, that I don't have the time to write some more docs for it (basic docs are available). If anybody wants to take a look at it, drop me a not and I send you a copy. Gerald
Re: a web interface to visualize tables
Thomas von Elling Skifter Eibner wrote: On Wed, Nov 01, 2000 at 04:57:59PM +0100, Louis-David Mitterrand wrote: Hello, I need a tool to interactively visualize DB tables from a web interface. Ideally this tool would let me: - rename column headers, - set cell alignments, widths, background colors, - reorder columns, - save all these visualisation settings in a DB, - it would be written in perl (even better: mod_perl), Does such a beast exist? I am in the process of writing one, so I thought I'd check first... Which Database are you thinking of? DBM files? SQL database? For SQL databases there is phpMyAdmin (for MySQL) and phpPgAdmin (Postgresql), but those are written in PHP. The functionality should be pretty easy to transfer if you look at php**Admin as an example. Maybe it could even be a whole lot better by allowing 'plugins' like the way DBI has database drivers.. I would be able to spend some time help testing/developing on a project like this, so if you want help just email me. This is something, a long time ago, that I tried to find time to begin work on (with no real succes, alas.). I'm willing to spend some time testing and developping on a project like this... The idea of having it be "database-portable" could be really cool to do! -- Benoit Caron Analyste-Programmeur Netgraphe - Webfin.com - Le Web Financier [EMAIL PROTECTED] (514)847-9155 poste 3151 - - - - - - - - - - - - - - - - - - - - - - - - "The number of Unix installations has grown to 10, with more expected." -- The Unix Programmer's Manual, 2nd edition, June '72
RE: a web interface to visualize tables
That's really a good idea. I would even go a step further. what's about to create a web interface that does not know what DB is underneath. So once we have such an interface one has 'only' to change the DB specific functions like search , get , delete , update it may even work for the LDAP protocol I would have some time to spend on this idea. cheers Reinhard -Original Message- From: Thomas von Elling Skifter Eibner [SMTP:[EMAIL PROTECTED]] Sent: mercoledì 1 novembre 2000 17:18 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: a web interface to visualize tables On Wed, Nov 01, 2000 at 04:57:59PM +0100, Louis-David Mitterrand wrote: Hello, I need a tool to interactively visualize DB tables from a web interface. Ideally this tool would let me: - rename column headers, - set cell alignments, widths, background colors, - reorder columns, - save all these visualisation settings in a DB, - it would be written in perl (even better: mod_perl), Does such a beast exist? I am in the process of writing one, so I thought I'd check first... Which Database are you thinking of? DBM files? SQL database? For SQL databases there is phpMyAdmin (for MySQL) and phpPgAdmin (Postgresql), but those are written in PHP. The functionality should be pretty easy to transfer if you look at php**Admin as an example. Maybe it could even be a whole lot better by allowing 'plugins' like the way DBI has database drivers.. I would be able to spend some time help testing/developing on a project like this, so if you want help just email me. regards, -- Thomas Eibner
Re: a web interface to visualize tables = DIGEST
Hi Geoff, I hope you're getting all this down... On Wed, 1 Nov 2000, Andy Duncan wrote: = http://www.oracletool.com/ = http://phpwizard.net/projects/phpMyAdmin/index.html = http://kenny.itlab.musc.edu/phpSybaseAdmin/ = http://www.php.net/manual/ref.oracle.php 73, Ged.
Re: a web interface to visualize tables
On Wed, 1 Nov 2000, Louis-David Mitterrand wrote: I need a tool to interactively visualize DB tables from a web interface. Ideally this tool would let me: - rename column headers, - set cell alignments, widths, background colors, - reorder columns, - save all these visualisation settings in a DB, - it would be written in perl (even better: mod_perl), Does such a beast exist? I am in the process of writing one, so I thought I'd check first... My Alzabo project includes a (fairly lame right now) data browser that is a set of Mason components. Alzabo right now only supports MySQL but I'm going to start working on Postgres support sometime 'real soon now' (i.e. I'm real busy so I don't know when). The data browser does at least some of what you want, though its not nearly as customizable as what you mentioned above. Alzabo is at alzabo.sourceforge.net -dave /*== www.urth.org We await the New Sun ==*/
Re: a web interface to visualize tables
Hi all, On Wed, 1 Nov 2000, Thomas von Elling Skifter Eibner wrote: I need a tool to interactively visualize DB tables from a web interface. Which Database are you thinking of? DBM files? SQL database? For SQL databases there is phpMyAdmin (for MySQL) and phpPgAdmin (Postgresql), but those are written in PHP. The functionality should be pretty easy to transfer if you look at php**Admin as an example. Maybe it could even be a whole lot better by allowing 'plugins' like the way DBI has database drivers.. I would be able to spend some time help testing/developing on a project like this, so if you want help just email me. You might want to have a look at ViLib (www.vilib.utac.net) which doesn't do quite what you want but it will give you a flying start. It uses mod_perl, works with MySQL for sure and maybe Oracle. 73, Ged.
RE: a web interface to visualize tables
As a part of further research into this area I am going to seriously look into Oracle WebDB. Other users in my shop have had great success with it. And the output is *very* high quality. I would appreciate hearing more about it from any users here that have experience with it. Also there is a product that seems to be a cross platform version of what you want called "DatiLink". It hooks up natively to all the major databases. It's a bit pricy but the output seems to be high quality. http://datigen.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Louis-David Mitterrand Sent: Wednesday, November 01, 2000 7:58 AM To: dbi-users; [EMAIL PROTECTED] Subject: a web interface to visualize tables Hello, I need a tool to interactively visualize DB tables from a web interface. Ideally this tool would let me: - rename column headers, - set cell alignments, widths, background colors, - reorder columns, - save all these visualisation settings in a DB, - it would be written in perl (even better: mod_perl), Does such a beast exist? I am in the process of writing one, so I thought I'd check first... Thanks in advance, -- Louis-David Mitterrand - [EMAIL PROTECTED] - http://www.apartia.org "Kill a man, and you are an assassin. Kill millions of men, and you are a conqueror. Kill everyone, and you are a god." -- Jean Rostand -- DBI HOME PAGE AND ARCHIVES: http://www.symbolstone.org/technology/perl/DBI/ To unsubscribe from this list, please visit: http://www.isc.org/dbi-lists.html If you are without web access, or if you are having trouble with the web page, please send mail to [EMAIL PROTECTED] with the subject line of: 'unsubscribe'. --
Re: a web interface to visualize tables
I would try Data-Table-1.16.tar.gz from CPAN... I'm not sure it's the right thing but I remember reading something like you want to do about that package. Thanks, MC Louis-David Mitterrand wrote: Hello, I need a tool to interactively visualize DB tables from a web interface. Ideally this tool would let me: - rename column headers, - set cell alignments, widths, background colors, - reorder columns, - save all these visualisation settings in a DB, - it would be written in perl (even better: mod_perl), Does such a beast exist? I am in the process of writing one, so I thought I'd check first... Thanks in advance, -- Louis-David Mitterrand - [EMAIL PROTECTED] - http://www.apartia.org "Kill a man, and you are an assassin. Kill millions of men, and you are a conqueror. Kill everyone, and you are a god." -- Jean Rostand -- DBI HOME PAGE AND ARCHIVES: http://www.symbolstone.org/technology/perl/DBI/ To unsubscribe from this list, please visit: http://www.isc.org/dbi-lists.html If you are without web access, or if you are having trouble with the web page, please send mail to [EMAIL PROTECTED] with the subject line of: 'unsubscribe'. -- -- Martin Charbonneau [EMAIL PROTECTED] E-Commerce system analyst (514) 356-1611 x 2176
Re: a web interface to visualize tables
Hi Louis-David, I need a tool to interactively visualize DB tables from a web interface. Ideally this tool would let me: - rename column headers, - set cell alignments, widths, background colors, - reorder columns, - save all these visualisation settings in a DB, - it would be written in perl (even better: mod_perl), Does such a beast exist? I am in the process of writing one, so I thought I'd check first... You might want to take a look at OracleTool for some ideas, particularly if you're working with Oracle: = http://www.oracletool.com/ Alternatively Thomas Eibner's idea of adapting PhpMyAdmin sounds good. You can find out more about that here: = http://phpwizard.net/projects/phpMyAdmin/index.html There is a Sybase version too, here: = http://kenny.itlab.musc.edu/phpSybaseAdmin/ If you do write an Oracle driver and create phpOracleAdmin, can you let me know! :-) You can find some interesting stuff on connecting php to Oracle here: = http://www.php.net/manual/ref.oracle.php HTH a bit 8-) Rgds, AndyD __ Do You Yahoo!? From homework help to love advice, Yahoo! Experts has your answer. http://experts.yahoo.com/
Re: a web interface to visualize tables
On Wed, Nov 01, 2000 at 04:57:59PM +0100, Louis-David Mitterrand wrote: Hello, I need a tool to interactively visualize DB tables from a web interface. Ideally this tool would let me: - rename column headers, - set cell alignments, widths, background colors, - reorder columns, - save all these visualisation settings in a DB, - it would be written in perl (even better: mod_perl), Does such a beast exist? I am in the process of writing one, so I thought I'd check first... Which Database are you thinking of? DBM files? SQL database? For SQL databases there is phpMyAdmin (for MySQL) and phpPgAdmin (Postgresql), but those are written in PHP. The functionality should be pretty easy to transfer if you look at php**Admin as an example. Maybe it could even be a whole lot better by allowing 'plugins' like the way DBI has database drivers.. I would be able to spend some time help testing/developing on a project like this, so if you want help just email me. regards, -- Thomas Eibner
Re: a web interface to visualize tables
Hi Guys, The technology called Datilink has just been bought out by a new company called Inshift Technologies. If you are interested I can get you a killer price on a copy right now since I have connections with both companies. We have been using it for several years now and really like its flexibility and ease of use. Let me know and I will send you a win32 demo version. Steve Lloyd 801 318-0591 Tim Harsch wrote: As a part of further research into this area I am going to seriously look into Oracle WebDB. Other users in my shop have had great success with it. And the output is *very* high quality. I would appreciate hearing more about it from any users here that have experience with it. Also there is a product that seems to be a cross platform version of what you want called "DatiLink". It hooks up natively to all the major databases. It's a bit pricy but the output seems to be high quality. http://datigen.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Louis-David Mitterrand Sent: Wednesday, November 01, 2000 7:58 AM To: dbi-users; [EMAIL PROTECTED] Subject: a web interface to visualize tables Hello, I need a tool to interactively visualize DB tables from a web interface. Ideally this tool would let me: - rename column headers, - set cell alignments, widths, background colors, - reorder columns, - save all these visualisation settings in a DB, - it would be written in perl (even better: mod_perl), Does such a beast exist? I am in the process of writing one, so I thought I'd check first... Thanks in advance, -- Louis-David Mitterrand - [EMAIL PROTECTED] - http://www.apartia.org "Kill a man, and you are an assassin. Kill millions of men, and you are a conqueror. Kill everyone, and you are a god." -- Jean Rostand -- DBI HOME PAGE AND ARCHIVES: http://www.symbolstone.org/technology/perl/DBI/ To unsubscribe from this list, please visit: http://www.isc.org/dbi-lists.html If you are without web access, or if you are having trouble with the web page, please send mail to [EMAIL PROTECTED] with the subject line of: 'unsubscribe'. -- -- DBI HOME PAGE AND ARCHIVES: http://www.symbolstone.org/technology/perl/DBI/ To unsubscribe from this list, please visit: http://www.isc.org/dbi-lists.html If you are without web access, or if you are having trouble with the web page, please send mail to [EMAIL PROTECTED] with the subject line of: 'unsubscribe'. --
