It’d probably cost a lot as he’d code it- each time a tweet is pulled up there’d be a full search to see which users have the tweet author blocked. If the returned list has the viewer’s ID included then set the style for the tweet to not be visible.
Check is done by querying the list of users and running a for loop to see if any user names match the user name of blocked users. This is all handled on the client side and optimised by exposing the SQL server. Security is maintained by banning anyone who uses the word “drop” in any query (after the query goes through).
It’d probably cost a lot as he’d code it- each time a tweet is pulled up there’d be a full search to see which users have the tweet author blocked. If the returned list has the viewer’s ID included then set the style for the tweet to not be visible.
Check is done by querying the list of users and running a for loop to see if any user names match the user name of blocked users. This is all handled on the client side and optimised by exposing the SQL server. Security is maintained by banning anyone who uses the word “drop” in any query (after the query goes through).