I have created a view for the ipblocks table. This view hides private data related to autoblocks.
There were two possible ways that I could have created this view. I could have created so that it hides all autoblocks, or I could have created it so that it only hides the private data in autoblocks.
The second choice is obviously more flexible, but it prevents the use of indexes on the ip address columns (ipb_address, ipb_range_start, ipb_range_end).
Because the ipblocks tables are fairly small (even on large projects like enwiki) and because some tools already do things with autoblocks, I have decided to choose this slower option.
If we have performance problems related to this view, I will change the it to the first type without any autoblocks, and potentially provide a second autoblocks only view for tools that need to see the autoblocks.
Don't forget ipb_deleted. Eventually that should require Oversight access to view things flagged with that.
-Aaron Schulz
Date: Mon, 5 Nov 2007 16:57:13 -0500 From: gmaxwell@gmail.com To: toolserver-l@lists.wikimedia.org Subject: [Toolserver-l] ipblocks table available
I have created a view for the ipblocks table. This view hides private data related to autoblocks.
There were two possible ways that I could have created this view. I could have created so that it hides all autoblocks, or I could have created it so that it only hides the private data in autoblocks.
The second choice is obviously more flexible, but it prevents the use of indexes on the ip address columns (ipb_address, ipb_range_start, ipb_range_end).
Because the ipblocks tables are fairly small (even on large projects like enwiki) and because some tools already do things with autoblocks, I have decided to choose this slower option.
If we have performance problems related to this view, I will change the it to the first type without any autoblocks, and potentially provide a second autoblocks only view for tools that need to see the autoblocks.
Toolserver-l mailing list Toolserver-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l
_________________________________________________________________ Boo! Scare away worms, viruses and so much more! Try Windows Live OneCare! http://onecare.live.com/standard/en-us/purchase/trial.aspx?s_cid=wl_hotmailn...
On Nov 5, 2007 5:35 PM, Aaron Schulz jschulz_4587@msn.com wrote:
Don't forget ipb_deleted. Eventually that should require Oversight access to view things flagged with that.
Yep. I exclude any rows where ipb_deleted!=0.
(it's currently unused so, I'm *assuming* that my behavior is conservative)
toolserver-l@lists.wikimedia.org