TODO in shiba-0.1.2 vs TODO in shiba-0.2.0

- old
+ new

@@ -1,12 +1,30 @@ === -this query is throwing the optimizer for a serious loop; -it says it can use an index on `ipb_address` but when we force key it -still table scans. Not clear on whether the OR in there is fucking us over or -if it's a test-data issue. +# we screw this up because of the table aliasing +SELECT COUNT(*) AS count_all, group_id AS group_id FROM `users` INNER JOIN `groups_users` `users_groups_users_join` ON `users_groups_users_join`.`user_id` = `users`.`id` INNER JOIN `users` `groups_users` ON `groups_users`.`id` = `users_groups_users_join`.`group_id` AND `groups_users`.`type` IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') WHERE `users`.`type` IN ('User', 'AnonymousUser') GROUP BY group_id -# SELECT ipb_id,ipb_address,ipb_timestamp,ipb_auto,ipb_anon_only,ipb_create_account,ipb_enable_autoblock,ipb_expiry,ipb_deleted,ipb_block_email,ipb_allow_usertalk,ipb_parent_block_id,ipb_sitewide,comment_ipb_reason.comment_text AS `ipb_reason_text`,comment_ipb_reason.comment_data AS `ipb_reason_data`,comment_ipb_reason.comment_id AS `ipb_reason_cid`,ipb_by,ipb_by_text,NULL AS `ipb_by_actor` FROM `ipblocks` FORCE KEY(`ipb_address`) JOIN `comment` `comment_ipb_reason` ON ((comment_ipb_reason.comment_id = ipb_reason_id)) WHERE ipb_address = '127.0.0.1' OR ((ipb_range_start LIKE '7F00%' ESCAPE '`' ) AND (ipb_range_start <= '7F000001') AND (ipb_range_end >= '7F000001')); -=== -need to use format=json and see how much of an index we're using. +# UI + +SQL Query -> where clause +throw tags in + +# Add "ignore me" button next to query to show how to block stuff. + +# Fuzzer + +see how feasible a basic-ass cardinality estimator would be + +# Docs + +- main docs (readme.md) +- link from call to acion about fuzzed data + +# Explain Stuff + +Add index-walk detection +Add filesort badge +Postgres! + +