From: Jason R. <ja...@ar...> - 2000-11-09 19:33:02
|
My company runs several sites based on the slashdot code. We find it very useful. However, we would find it more useful if we could have the sites share the same users (and user-related) tables. I was thinking of changing the code to support such a thing by adding another slashdotrc.pl type file (maybe tablesrc.pl) that maps table handles to table names, then changing the rest of the code to reference table handles instead of the hard-coding that is used now. I don't know if this would be something that you feel would be a nice "feature" for the slashcode or not, but I would be willing to make a patch that does it if you guys express some interest. Let me know if I am way off base here. -- "Jason C. Richey" <ja...@ar...> |
From: Brian A. <br...@ta...> - 2000-11-09 19:43:29
|
Jason Richey wrote: > > My company runs several sites based on the slashdot code. We find it > very useful. However, we would find it more useful if we could have > the sites share the same users (and user-related) tables. I was > thinking of changing the code to support such a thing by adding > another slashdotrc.pl type file (maybe tablesrc.pl) that maps table > handles to table names, then changing the rest of the code to > reference table handles instead of the hard-coding that is used now. > > I don't know if this would be something that you feel would be a nice > "feature" for the slashcode or not, but I would be willing to make a > patch that does it if you guys express some interest. Let me know if > I am way off base here. Its an excelent patch, but it would get lost in the conversion to Bender. Support for this type of Module in Bender would be welcomed though. -Brian |
From: Jason R. <ja...@ar...> - 2000-11-09 21:23:22
|
I appreciate the response... I'll look into writing such a thing for Bender. Jason C. Richey Brian Aker wrote: > Its an excelent patch, but it would get lost in the conversion to > Bender. Support for this type of Module in Bender would be welcomed > though. > > -Brian > _______________________________________________ > Slashcode-development mailing list > Sla...@li... > http://lists.sourceforge.net/mailman/listinfo/slashcode-development |
From: Eric D. <eri...@ja...> - 2000-11-09 20:23:20
|
Um, thats a great idea. I too would be interested in such a thing. But, maybe there is an easier way? Two ideas. 1. Have one user database's users table be the main userbase, and change the other sites SQL stuff to reference slash.users instead of their internal users table. That might work...... 2. Perhaps modify the users.pl so when you make changes and stuff, it updates all the related sites's databases (ie: you have users table in all the sites, and have the code update the user info across the board.) Ideas just off the top of my head. But I think a Bender module would be better and hopefully we all can start using Bender instead of Slash 1.0.9 real soon? ;-) Jason Richey wrote: > My company runs several sites based on the slashdot code. We find it > very useful. However, we would find it more useful if we could have > the sites share the same users (and user-related) tables. I was > thinking of changing the code to support such a thing by adding > another slashdotrc.pl type file (maybe tablesrc.pl) that maps table > handles to table names, then changing the rest of the code to > reference table handles instead of the hard-coding that is used now. > > I don't know if this would be something that you feel would be a nice > "feature" for the slashcode or not, but I would be willing to make a > patch that does it if you guys express some interest. Let me know if > I am way off base here. > > -- > "Jason C. Richey" <ja...@ar...> > > _______________________________________________ > Slashcode-development mailing list > Sla...@li... > http://lists.sourceforge.net/mailman/listinfo/slashcode-development -- <version 2.0.0> <tag> Not tonight, dear. I have a modem. </tag> |
From: Jason R. <ja...@ar...> - 2000-11-11 00:12:17
|
I hate to sound like an idiot, but... I'm a little confused about where site configuration information is being kept in Bender. Would somebody please point me in the right direction? I'm walking through the code, trying to figure the best way to implement such a thing. Unfortunately, I have very little experience with mod_perl, so I get confused too quickly. Jason Richey Jason Richey wrote: > I appreciate the response... I'll look into writing such a thing for Bender. > > Jason C. Richey > > Brian Aker wrote: > > > Its an excelent patch, but it would get lost in the conversion to > > Bender. Support for this type of Module in Bender would be welcomed > > though. > > > > -Brian > > _______________________________________________ > > Slashcode-development mailing list > > Sla...@li... > > http://lists.sourceforge.net/mailman/listinfo/slashcode-development > > _______________________________________________ > Slashcode-development mailing list > Sla...@li... > http://lists.sourceforge.net/mailman/listinfo/slashcode-development -- "Jason C. Richey" <ja...@ar...> |
From: Chris N. <pu...@po...> - 2000-11-20 16:47:57
|
At 19:04 -0600 2000.11.10, Jason Richey wrote: >I'm a little confused about where site configuration information is >being kept in Bender. Would somebody please point me in the right >direction? The vars table. -- Chris Nandor pu...@po... http://pudge.net/ Open Source Development Network pu...@os... http://osdn.com/ |
From: Jason R. <ja...@ar...> - 2000-11-20 23:16:11
|
I've been looking into writing a module for Bender that would allow table names to be specified by the site admin. I think that the following would be a usable setup for such a thing: add a table "tables" to the sql database of the slashsite this table would be the only table that is required to exist within this database. It would contain mappings from table names to actual table locations. Hypothetically, all other tables could be moved to different databases. add a module that exports a lookup function for the tables replace all (EEK!) occurrences of explicit table names with lookups within the Bender code. From what I can tell, all occurences are within the Slash/DB subtree (Are there any hidden elsewhere?). add functionality to edit values inside the "tables" table (something like what has been done with the "vars" table) ------ Any Input? I don't know if specifying a full table name (database.table) is a problem for any of the perl database handling routines. I know that it works in MySQL from command-line. Is there any performance loss for operating on multiple databases from within the same script? I don't see why there would be. I'm looking for some criticism here, please. Thanks in advance, Jason Richey Brian Aker wrote: > Jason Richey wrote: > > > > My company runs several sites based on the slashdot code. We find it > > very useful. However, we would find it more useful if we could have > > the sites share the same users (and user-related) tables. I was > > thinking of changing the code to support such a thing by adding > > another slashdotrc.pl type file (maybe tablesrc.pl) that maps table > > handles to table names, then changing the rest of the code to > > reference table handles instead of the hard-coding that is used now. > > > > I don't know if this would be something that you feel would be a nice > > "feature" for the slashcode or not, but I would be willing to make a > > patch that does it if you guys express some interest. Let me know if > > I am way off base here. > Its an excelent patch, but it would get lost in the conversion to > Bender. Support for this type of Module in Bender would be welcomed > though. > > -Brian > _______________________________________________ > Slashcode-development mailing list > Sla...@li... > http://lists.sourceforge.net/mailman/listinfo/slashcode-development -- "Jason C. Richey" <ja...@ar...> |
From: Chris N. <pu...@po...> - 2000-11-21 13:31:51
|
At 18:09 -0600 2000.11.20, Jason Richey wrote: >replace all (EEK!) occurrences of explicit table names with lookups > within the Bender code. From what I can tell, all occurences > are within the Slash/DB subtree (Are there any hidden > elsewhere?). No. All are in Slash::DB. I don't know if this would be a good idea or not, but it is certainly something to consider. I suppose if this table were read in at the beginning and the mappings cached, the overhead shouldn't be too significant, except on startup. -- Chris Nandor pu...@po... http://pudge.net/ Open Source Development Network pu...@os... http://osdn.com/ |