Hello,
Just got this interesting mail from Stefano.
I guess it's better if we discuss that on this list...
I think the idea is fine, but also that we _first_ should
finish the 2.2.0 release before working on any new
(even if cool) feature. Otherwise we will have
rc5, rc6, ... rc99 like the linux kernel :)
Comments welcome!
Swix, going back to school work (preparing exams)
----- Forwarded message from Stefano Locati <locati(a)users.sourceforge.net> -----
Subject: proposal
From: Stefano Locati <locati(a)users.sourceforge.net>
Date: Fri, 10 Aug 2001 04:07:46 -0700
i'm a user of phpMyAdmin since long time and i'm
seeing it improving and getting better and better.
i've an idea about a future feature that i need
and that i would develop myself and also share
with others.
it's about db documentation. i'm working on many
websites projects and keeping an uptodate db
documentation is a problem. i don't want to use
commercial tools like the good power designer.
what i would like is something very simple in
phpmyadmin style.
i would add another link after the common browse -
select - insert. A documentation link that would
allow any person to write information about the
db tables and fields.
the next step would be info about relationship.
this information would be stored in three db
tables. i would add a button to create those
tables in the case they were not detected in the
current db. the metaschema of the db would be
extracted giving the possibility to just click
side of a field / table to document it.
i would work on a cvs copy without committing
until the software isn't good enough for at least
a test drive. i've experience with php and cvs.
the tables i would add would be something like:
sch_table(name, description)
sch_field(name, tablename, description)
sch_relationship(name1, tablename1, name2,
tablename2, description)
what do you think about this? i'm open to start a
discussion phase with members of this project
about the willingness to include such feature,
and how to do it.
bye and keep up with the good work
stefano
----- End forwarded message -----
--
_________________________________________________________________
Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland
qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch
Here is a patch for tuning left.php to be more style and option
friendly...any global variables that you see that are not in the
config.inc.php I have obviously added and you need to to the same if you
want to use this left.php... The easiest and must exciting change is
the addition of a title attribute to the table links (so that the table
name pops up when you fly over the table if you are using even a halfway
decent browser)...helpful for long table names.
If anyone is interested in seeing it all in action, or wants to get some
ideas about what I came up with, check out
http://65.5.154.16/phpMyAdmin/
There is no real data on the site, so just be polite and view only...
p.s. I patched the rc4 version
Enjoy!
Dan
>Anyway, templates like in phpGroupWare would be the best way
>to provide easy customization, but the current design is not
>suitable for that. We should choose between some customization
>with some cfg variables and a better design allowing themes.
For 2.3.0 and not before IMO.
Alain.
_______________________________________________________
Hi Marc & all!
About the binary bug found by steve, Marc wrote:
>Is someone working on this?
Gess what: yes ;)
Indeed the problem exist whathever is the variable type: since
there is no backup of the current value and we have to
replace double quotes by & quot; in html fields values, a
sql field not changed by the user may be seen as changed by
tbl_replace.php3.
I'm also working on enum's problem at the same time.
Greets,
Loïc
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif
> If anyone is interested in seeing it all in action, or wants
> to get some
> ideas about what I came up with, check out
>
> http://65.5.154.16/phpMyAdmin/
Wouch! You don't like original colors and display, do you ? :)
If it were not written, it would be hard to say it's really
phpMyAdmin!
Anyway, templates like in phpGroupWare would be the best way
to provide easy customization, but the current design is not
suitable for that. We should choose between some customization
with some cfg variables and a better design allowing themes.
In defines.inc.php in rc4 it tries to get the mysql version, even if the
$server variable is set to 0, as it is if no default server is set to
start with...simply add an if($server) around this last part of
defines.inc.php
Dan
I really think that phpMyAdmin needs more configuration variables...It
is fine to go ahead and give them defaults which many people will not
change, but if someone does want to tune the look, it is really
difficult now. Here is a general suggestion to start out...
Everytime a table is used with this code
<table border="<?php echo $cfgBorder; ?>">
It should instead be
<table border="<?php echo $cfgBorder; ?>" cellspacing="<?php echo
$cfgSpacing; ?>" cellpadding="<?php echo $cfgPadding; ?>">
Here are my other suggestions:
- Have a variable for font size (and since windows and unix handle font
sizes so differently there should be OS sniffing to scale the size)
- Like W3C recommends, font-sizes should be in em and not in pt
- There should be more color preferences...such as link color
backgrounds for hover and all that
I have patches for most of this stuff, but phpMyAdmin is changing so
fast I just can't get a patch made that will work with the
version...obviously I need to learn CVS, but at least I can make
suggestions while I am learning. Please comment on the ideas.
Dan Allen
Hi!
I've replied to this message in the forum. Please do not post the same
message
on two places, just be patient ;)
Regards,
Loïc
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif
On Thu, Aug 09, 2001 at 01:39:24PM -0700, Dan Allen wrote:
> I hope that you don't mind that I am e-mailing you. I had posted some
no problem. the best for your patches would be that
you upload them on the sourceforge feature or bugs tracker,
and post a short note to the devel-ml.
> patches yesterday and they were from the old version...I didn't even
> think about cvs, but since the new version rc4 just came out, I reedited
> the files and created patches from that version. In addition to the
> patches I listed about socket and permission I also have a NULL patch,
> which, when an number cell has a value of empty string, it shouldn't
> show empty string but NULL, since it is impossible for a number cell to
> just be blank (try it in mysql terminal client). Also, when you entered
> the editor, the fields that were numbers and NULL showed up as blank and
> when you inserted the data, the blanks would fill in as the default
> (either 0 or the value set)...so, if the field is empty when going into
> the editor (when you click on Edit) it auto fills in NULL where the
> number cell is blank. I was also thinking about adding this for new
> cells...so when you go to insert new data, number fields start out as
> either NULL (if the parameter is NULL) or 0 (if the parameter is
> NOT_NULL). If you reply, I will send you those diffs and you can throw
> out what you don't like and keep what you like.
>
> Dan Allen
--
_________________________________________________________________
Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland
qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch
This post is simply a request for clarification. What does the function
out_buffer_pre($ob_mode) do? I am a bit confused, and all I know is
that if I use galeon the main.php is not rendered at all (and the source
is empty). Now, I realize that this is not a phpMyAdmin bug, but
perhaps if I knew what it did, I could go over to the guys and gals at
galeon and let them know what is cause the browser to break. Thanks for
the time!
Dan Allen