sfwiki-devel Mailing List for SourceForge Wiki (Page 5)

sfwiki-devel

You can subscribe to this list here.

2000	_Jan	_Feb	_Mar	_Apr	_May (36)	_Jun (5)	_Jul (5)	_Aug	_Sep (6)	_Oct	_Nov (20)	_Dec (12)
2001	_Jan (7)	_Feb (5)	_Mar (25)	_Apr (18)	_May (2)	_Jun (8)	_Jul (2)	_Aug (2)	_Sep	_Oct	_Nov (3)	_Dec (1)
2002	_Jan	_Feb	_Mar (1)	_Apr	_May	_Jun	_Jul	_Aug	_Sep (1)	_Oct	_Nov	_Dec
2003	_Jan	_Feb (1)	_Mar	_Apr	_May (2)	_Jun (5)	_Jul (3)	_Aug (9)	_Sep	_Oct (1)	_Nov (5)	_Dec
2007	_Jan	_Feb	_Mar	_Apr	_May (2)	_Jun	_Jul	_Aug	_Sep	_Oct	_Nov	_Dec

Flat | Threaded

<< < 1 .. 3 4 5 6 7 > >> (Page 5 of 7)

[sfWiki-devel] MySQL vs PHP speed

From: Todd L. M. <tm...@ha...> - 2000-12-02 00:16:59

	Should this query jump mysqld's CPU usage to 99% on a celeron 400,
and cause the page to to take ten minutes to generate when run on all the
pages from the JOSwiki (archive from jos.org)?

  $result = mysql_query( "SELECT topic,web,summary FROM" . $_SITE["dbtable"] .
                " WHERE web=\"" . $web . "\" ORDER BY lastedit DESC;" );

	Or do I need to figure out a more efficient way to generate the
table in the subsequent PHP code?  (in TopicBody.ihtml, at

http://cvs.sourceforge.net/cgi-bin/cvsweb.cgi/sfWiki/portal/htdocs/wiki/TopicBody.ihtml?cvsroot=sfwiki

)

	Thanks.  (In either case, it looks like I should be pre-rendering
the topic page!)

-jQuinn

[sfWiki-devel] potential fix

From: Todd L. M. <tm...@ha...> - 2000-12-01 04:54:28

	After staring at the perl regexp for a while, I divined a
a simple potential solution to the problem of matching attributes in the
embedded HTML.  All the HTML I've seen has the tags either in all lower
case or all upper case, not ever WikiStyled.  This means if we turn off
the code to link acronyms, the problem goes away for the vast majority of
cases.  (And %TLA% will force a link.)  Is this an acceptable
solution?  The alternative -- checking to make sure that a WikiWord is not
inside an HTML tag -- could get really painful.  (Though, if you happen to
have the perl regexp for it, I'd be happy to try it.)  This fix, and the
others I've made, are at sfwiki.sf now.

	I still don't have lists, and the node-detection code is still
broken, but that should cover it in terms of what's working and what
isn't.  %RobertFitzsimons% (*) has a few good questions about 'style'
issues.  (Spaces inside a table for proper formatting, <URL:*> linking,
and Web:Topic implicit links.)  Discuss. :)

-jQuinn

*: A forced link to make it clear I'm referring to the topic...

Re: [sfWiki-devel] new WikiMarkup code

From: Iain S. <iai...@ya...> - 2000-11-30 15:57:39

At 11:21 PM 11/29/00 -0500, Todd L. Miller wrote:

>         I think the major barrier to moving the current JOSwiki over is
>the mark-up of WikiStyled attributes in the HTML markup, and then
>lists.  Is there some other feature that's missing or broken that's as
>important as these two?  (Well, we'd lose user auth and versioning, but I
>meant from a data-only perspective.)

No.  I think those two are it.  Actually, lists I feel are most 
important.  I'd be happy with that alone if the WikiStyled attributes in 
html proves to be a problem.

-iain

Re: [sfWiki-devel] new WikiMarkup code

From: Todd L. M. <tm...@ha...> - 2000-11-30 04:17:45

> I've added some more tests to my test page, if you want to take a look.

	I looked at it.  I think most of the problems will fall out when I
fix the ones mentioned in WebHome, but I'll be sure to check back when I
do.  Thanks for the help, BTW.

> In previewing mode it seems that formated text isn't being displayed
> right "Italics Bold<\/EM><\/STRONG>".

	Previewing mode is broken in general, I think.  I'll look into
this.  My guess is that it's something simple I'm forgetting to do from
not having looked at it.

> Also one thing I like about the current JOS wiki is that the "changes
> page" also includes when a page was changed and by who.  Maybe we can
> add a new entry field for the name to be entered?

	I could do that, I suppose.  Releases 3 and 4 are when I had
scheduled user authentication for, but voluntary identification shouldn't
be too hard.  We'll see :)

	I think the major barrier to moving the current JOSwiki over is
the mark-up of WikiStyled attributes in the HTML markup, and then
lists.  Is there some other feature that's missing or broken that's as
important as these two?  (Well, we'd lose user auth and versioning, but I
meant from a data-only perspective.)

-jQuinn

Re: [sfWiki-devel] new WikiMarkup code

From: Robert F. <ro...@27...> - 2000-11-30 04:06:10

Hi Todd

I've added some more tests to my test page, if you want to take a look.

In previewing mode it seems that formated text isn't being displayed
right "Italics Bold<\/EM><\/STRONG>".

Also one thing I like about the current JOS wiki is that the "changes
page" also includes when a page was changed and by who.  Maybe we can
add a new entry field for the name to be entered?

Robert Fitzsimons
rfi...@el...

On Wed, Nov 29, 2000 at 05:02:31PM -0500, Todd L. Miller wrote:
> 	I rather shamelessly stole code from TWiki to completely rewrite
> sfWiki's wiki rendering in PHP.  The whole job is done, with one exception
> and one caveat.  First, I haven't ported over the list handling.  I need
> to learn a little more perl before I can figure out how, exactly, they're
> being handled.  Second, I changed the TWiki's markup to be the usual (for
> us) _/* for italic/underline and combinations, using what they coded up
> for their example custom renderer, from which I also included all the
> JOSwiki backward-compatability stuph.  I've tested locally, and thought I
> caught everything, but that (clearly) didn't happen the last time.  The
> database is acting up at SF again, but once it clears up, please abuse
> sfWiki some more.  Below is my most recent effort to break the new
> rendering code; I'm sure you can do better.
> 
> -jQuinn
> 
> mailto:em...@ma...
> |cell|cell|
> blah de blach MoWikiMarkup OtherWikiMarkup [[imnotawikiname]]
> [[Main.neitherami]]
> %Main:WikiTopic%
> %nonwikitopic% YoWiki Numerical1 NumericalWiki1
> text something %Main.SomethingEvil% something text
> %Main.nonwikitopic% test
> %Main:notawikitopic% some random
> <PRE>	Do something useful.</PRE>
> MoWikiMarkup
> | cell! |
> <B> HAHA! </B>
> 
> > This is a test<BR> mailto:em...@em...
> *afasdf* http://sourceforge.net<BR>
> _underline_ *bold* *_boldunderline_* _*underlinebold*_
> ><&&&&
> ----
> Why----
> | cell | mailto:me...@mi... | <B> GOOD </B> | WikiName |
> | cell |
> Why----
> |cell|cell|
> 
> _______________________________________________
> sfWiki-devel mailing list
> sfW...@li...
> http://lists.sourceforge.net/mailman/listinfo/sfwiki-devel

Re: [sfWiki-devel] new WikiMarkup code

From: Iain S. <iai...@ya...> - 2000-11-30 02:38:24

At 05:02 PM 11/29/00 -0500, Todd L. Miller wrote:
>         I rather shamelessly stole code from TWiki to completely rewrite
>sfWiki's wiki rendering in PHP.  The whole job is done, with one exception
>and one caveat.  First, I haven't ported over the list handling.  I need
>to learn a little more perl before I can figure out how, exactly, they're
>being handled.  Second, I changed the TWiki's markup to be the usual (for
>us) _/* for italic/underline and combinations, using what they coded up
>for their example custom renderer, from which I also included all the
>JOSwiki backward-compatability stuph.  I've tested locally, and thought I
>caught everything, but that (clearly) didn't happen the last time.  The

Very cool.

>database is acting up at SF again, but once it clears up, please abuse
>sfWiki some more.  Below is my most recent effort to break the new
>rendering code; I'm sure you can do better.

Will do.  Can you ping me when you think sf is stable...  Thanks.

-iain

[sfWiki-devel] new WikiMarkup code

From: Todd L. M. <tm...@ha...> - 2000-11-29 21:58:37

	I rather shamelessly stole code from TWiki to completely rewrite
sfWiki's wiki rendering in PHP.  The whole job is done, with one exception
and one caveat.  First, I haven't ported over the list handling.  I need
to learn a little more perl before I can figure out how, exactly, they're
being handled.  Second, I changed the TWiki's markup to be the usual (for
us) _/* for italic/underline and combinations, using what they coded up
for their example custom renderer, from which I also included all the
JOSwiki backward-compatability stuph.  I've tested locally, and thought I
caught everything, but that (clearly) didn't happen the last time.  The
database is acting up at SF again, but once it clears up, please abuse
sfWiki some more.  Below is my most recent effort to break the new
rendering code; I'm sure you can do better.

-jQuinn

mailto:em...@ma...
|cell|cell|
blah de blach MoWikiMarkup OtherWikiMarkup [[imnotawikiname]]
[[Main.neitherami]]
%Main:WikiTopic%
%nonwikitopic% YoWiki Numerical1 NumericalWiki1
text something %Main.SomethingEvil% something text
%Main.nonwikitopic% test
%Main:notawikitopic% some random
<PRE>	Do something useful.</PRE>
MoWikiMarkup
| cell! |
<B> HAHA! </B>

> This is a test<BR> mailto:em...@em...
*afasdf* http://sourceforge.net<BR>
_underline_ *bold* *_boldunderline_* _*underlinebold*_
><&&&&
----
Why----
| cell | mailto:me...@mi... | <B> GOOD </B> | WikiName |
| cell |
Why----
|cell|cell|

Re: [sfWiki-devel] alphabetize topic list?

From: Iain S. <iai...@ya...> - 2000-11-27 17:16:26

At 08:34 PM 11/26/00 -0500, Todd L. Miller wrote:
>         Should the topic list be sorted by last edit, as now, or in
>alphabetical order?  (Or should there be some option -- and if so, what's
>a good way to do it on the page -- to pick which?)

Both options would be nice but for now I'd just go for reverse 
chronological order (latest edit on top).  It's what most people are 
interested (IMHO) and the choice will only be confusing until we can 
provide portal-like customization.

-iain

[sfWiki-devel] alphabetize topic list?

From: Todd L. M. <tm...@ha...> - 2000-11-27 01:30:15

	Should the topic list be sorted by last edit, as now, or in
alphabetical order?  (Or should there be some option -- and if so, what's
a good way to do it on the page -- to pick which?)

-jQuinn

Re: [sfWiki-devel] progress report

From: Iain S. <iai...@ya...> - 2000-11-22 23:36:04

At 06:13 PM 11/22/00 -0500, Todd L. Miller wrote:

>         At any rate, I'm looking at RobertFitzsimons and WikiBugs and I'm
>wondering -- after having discovered that PHP supports perl regular
>expressions -- if it wouldn't be easier just to move the joswiki
>formatting code over.  This also removes the irritating need for a
>temporary file and a CGI binary other than php itself.  (BTW, thanks to
>Robert and the author(s) of WikiBugs for the help!)

Yeah.  I think that's the easiest (moving the joswiki perl regex's 
over).  I had thought you had your lex thing setup to your liking though 
and didn't want to suggest changes to things that seemed to be 
working.  Pure php does seem much cleaner and more portable.

-iain

[sfWiki-devel] progress report

From: Todd L. M. <tm...@ha...> - 2000-11-22 23:10:07

	I just realized that what I put in to do nodes won't have the
correct count until the linked-to page is save again, so never
mind.  (This is the bit that gets truly ugly.)  I've already u/l'd to sf,
though.  Oh well.  (Actually, I may be able to cheat and do something
simple, if immensely wasteful -- subtract one from the ltcount of every
topic in links_from of the topic to be saved, and then add one to the
ltcount of every topic in the links_from after the save.  If you've got a
better idea, please let me know.)

	At any rate, I'm looking at RobertFitzsimons and WikiBugs and I'm
wondering -- after having discovered that PHP supports perl regular
expressions -- if it wouldn't be easier just to move the joswiki
formatting code over.  This also removes the irritating need for a
temporary file and a CGI binary other than php itself.  (BTW, thanks to
Robert and the author(s) of WikiBugs for the help!)

-_Quinn

Re: [sfWiki-devel] nodes

From: Iain S. <iai...@ya...> - 2000-11-22 20:13:11

At 11:20 PM 11/21/00 -0500, Todd L. Miller wrote:

>         Anyway, any ideas on this?  The other idea I had was to
>more-or-less brute-force it in PHP -- on every save, use the above query
>to count incoming links.  If it's in the top ten, store it into a
>top-ten table and drop the lowest.

Unfortunately, mysql is pretty weak.  The best solution is as you stated, 
to do it in the database.  However, I don't think mysql supports nested 
queries and definitely doesn't do stored procedures which is really what 
you want.  So, at least with that database, you're pretty much stuck doing 
it brute force in php.

-iain

[sfWiki-devel] nodes

From: Todd L. M. <tm...@ha...> - 2000-11-22 04:17:54

	I'd prefer not to generate the nodes list every time the hubs and
nodes page is visited, because right now it would involve doing a lot of
work in PHP.  The last time I tried to code something where the incoming
links would be cached was an utter disaster.  So -- do you have any ideas
for nifty database tricks to make the job easier/faster?

	The basic problem is counting how many rows in the 'links from'
column have a topic in them, for every page in the wiki.  I'd like to do
this entirely in the database, if possible.  At first I thought nested
queries might do the trick, but it looks like MySQL doesn't support them
yet, and that they may not be recursive/iterative.  I have figured out how
to make the database count the number of links into a specific topic, but
not how to make entering that into the row a single query, which would be
nice.  It would be even nicer if there were some way to tell it to peform
that query on every update to the table.

	Anyway, any ideas on this?  The other idea I had was to
more-or-less brute-force it in PHP -- on every save, use the above query
to count incoming links.  If it's in the top ten, store it into a
top-ten table and drop the lowest.

	Thanks for any help.

-jQuinn

[sfWiki-devel] wtf?

From: Todd L. M. <tm...@ha...> - 2000-11-20 05:13:25

	http://sourceforge.net

	Wonder how sfWiki got to the front page? :)

-jQuinn