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...> |