Manual talk:Cur table

why is comment tinyblob?


 * Why not? --Brion VIBBER 23:10, 10 Sep 2004 (UTC)

Now recentchanges?
Is the cur table now named recentchanges (rc_)?


 * No. That's a different table. --brion 21:11, 1 Apr 2005 (UTC)

Directly replacing text in the DB?
If I want to customize MW, can I alter system messages across the board by running a replace query on the cur table?

i.e.

UPDATE cur SET cur_text = replace(cur_text, 'x', 'y');

This seems logical to me, but in practice the changes to do not seem to take effect until each message is individually edited through the Wiki itself.


 * Because loading each individual message from the database is expensive, they are cached in a single blob. If you're not using memcached or another cache backend, this will be in the objectcache table with a key of 'dbname:messages' where dbname is your database name. You'd need to manually clear that when making changes.


 * You should also take care to update cur_timestamp and cur_touched to avoid other potential cache oddities. --brion 01:43, 23 May 2005 (UTC)

Thanks Brion. ^_^ Where you say "You'd need to manually clear that when making changes", is this simply a matter of deleting that row from the objectcache table? And cur_timestamp and cur_touched are only important for rolling back changes through the Wiki front end aren't they? If I want my changes to be permanent it won't matter will it?

1.5
Where do I find the current article text in MediaWiki 1.5?

where to find articles in 1.5 schema
nobody knows. this documentation is outdated. im sorry im complaining so much but its true. the meta-wiki needs a Major reorganization. it would be a great-exercise in chaos management that im sure would be useful in herding the Wikipedians as well.

The database
At Wikipedia, we say "the database", and we say "the revisions database". These are just tables, and that's fine for my purposes of documenting Page name. But I'd just like to know something please, (for the Page name edit I want to verify): Does one text table hold both current and past wikitext for a page? I'm used to hearing, as is written here, that the revisions are a different entity than the current pages. But here it sounds like both the page table and the revisions table key into one and the same "text" table, so that in reality a wiki is just one database, with one (unique) page_id for all versions, past and current. Is that right? Thanks. Cpiral (talk) 06:03, 8 April 2013 (UTC)