You are viewing a plain text version of this content. The canonical link for it is here.
Posted to modperl@perl.apache.org by Louis-David Mitterrand <cu...@apartia.ch> on 2000/11/01 16:57:59 UTC
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 - ldm@apartia.org - 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
Re: a web interface to visualize tables
Posted by "G.Richter" <ri...@dev.ecos.de>.
> > 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
Posted by Andy Wardley <ab...@cre.canon.co.uk>.
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 <ab...@kfs.org> Signature regenerating. Please remain seated.
<ab...@cre.canon.co.uk> For a good time: http://www.kfs.org/~abw/
Re: a web interface to visualize tables
Posted by Benoit Caron <be...@netgraphe.com>.
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
benoit.caron@netgraphe.com
(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
Posted by "G.W. Haywood" <ge...@www.jubileegroup.co.uk>.
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
Posted by Thomas von Elling Skifter Eibner <th...@io.stderr.net>.
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
Posted by Martin Charbonneau <ma...@cgi.ca>.
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 - ldm@apartia.org - 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 dbi-users-request@isc.org with the subject line of:
> 'unsubscribe'.
> ------------------------------------------------------------------------------
--
Martin Charbonneau
martin.p.charbonneau@cgi.ca
E-Commerce system analyst
(514) 356-1611 x 2176
Re: a web interface to visualize tables
Posted by Steve Lloyd <sl...@datigen.com>.
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: dbi-users-bounce@isc.org [mailto:dbi-users-bounce@isc.org]On
> > Behalf Of Louis-David Mitterrand
> > Sent: Wednesday, November 01, 2000 7:58 AM
> > To: dbi-users; modperl@apache.org
> > 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 - ldm@apartia.org - 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 dbi-users-request@isc.org 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 dbi-users-request@isc.org with the subject line of:
> 'unsubscribe'.
> ------------------------------------------------------------------------------
RE: a web interface to visualize tables
Posted by Tim Harsch <ha...@llnl.gov>.
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: dbi-users-bounce@isc.org [mailto:dbi-users-bounce@isc.org]On
> Behalf Of Louis-David Mitterrand
> Sent: Wednesday, November 01, 2000 7:58 AM
> To: dbi-users; modperl@apache.org
> 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 - ldm@apartia.org - 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 dbi-users-request@isc.org with the subject line of:
'unsubscribe'.
----------------------------------------------------------------------------
--
Re: a web interface to visualize tables
Posted by Dave Rolsky <au...@urth.org>.
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
==================*/