Shared Verify list on cloud plateform ?

Hello
Feature Request ?

In the same principle that SEO indexing it would be really good if all the verified urls which are currently on all the PCs of all the GSA SER users are accessible via a web platform and downloaded every day. What shares, also receive the list. If we do this, we would eliminate a lot of the problem of proxy, waiting time etc …
But maybe is only a dream… :)

Performance of select from a 3d list – Mathematica slower than Python

I am creating a random 3d data set in Matematica 12.1. Then I am selecting all points that are in a certain range of one axis.

The same I am doing in Python (same computer, Python 3.8.5, numpy 1.19.2)

RESULT: It seems that Python is able to select much faster (1.7 sec) than Mathematica (5.2 sec). What is the reason for that? For selection in Mathematica I used the fastest solution, which is by Carl Woll (see here at bottom).

SeedRandom[1]; coordinates = RandomReal[10, {100000000, 3}];  selectedCoordinates =     Pick[coordinates,      Unitize@Clip[coordinates[[All, 1]], {6, 7}, {0, 0}],      1]; // AbsoluteTiming  {5.16326, Null}  Dimensions[coordinates]  {100000000, 3}  Dimensions[selectedCoordinates]  {10003201, 3} 

PYTHON CODE:

import time import numpy as np   np.random.seed(1) coordinates = np.random.random_sample((100000000,3))*10  start = time.time() selectedCoordinates = coordinates[(coordinates[:,0] > 6) & (coordinates[:,0] < 7)] end = time.time()  print(end-start)  print(coordinates.shape)  print(selectedCoordinates.shape)  1.6979997158050537  (100000000, 3)  (9997954, 3) 

How to list all grants per user/role on PostgreSQL

I’ve run these statements on Postgres CLI (I’m using PostgreSQL v13.1):

CREATE ROLE blog_user; GRANT blog_user TO current_user; 

And I created a function

CREATE FUNCTION SIGNUP(username TEXT, email TEXT, password TEXT) RETURNS jwt_token AS $  $   DECLARE   token_information jwt_token; BEGIN .... END; $  $   LANGUAGE PLPGSQL VOLATILE SECURITY DEFINER; 

Finally I granted a permission:

GRANT EXECUTE ON FUNCTION SIGNUP(username TEXT, email TEXT, password TEXT) TO anonymous; 

I wish to list all grants per user/role in my schema/database. \du and \du+ show basic information, which does not contain info about the grant (execute on function) made recently.

User Permisssions White List vs Black List

I have Applications, Roles, Users, Permissions, Application_Permissions, User_Permissions, Role_Permissions, Application_Roles and Role_Permissions tables. So, permission can be defined at application level, role level and user level. Let’s say User A belongs to Application X and Application X can have XX Permission. So, User A will get XX Permission. Now, I want to give all users of Application B with XX Permission but except User B. How can I fit this with my current design?

CREATE TABLE APPLICATION_PERMISIONS (APPLICATION_PERMISION_ID number(15) GENERATED AS IDENTITY, APPLICATION_ID number(15), PERMISION_DEFINITION_ID number(15)CONSTRAINT PK_SEC_APPLICATION_PERMISIONS PRIMARY KEY (APPLICATION_PERMISION_ID)); CREATE TABLE APPLICATION_ROLES (APPLICATION_ROLE_ID number(15) GENERATED AS IDENTITY, APPLICATION_ID number(15), ROLE_ID number(15)CONSTRAINT PK_SEC_APPLICATION_ROLES PRIMARY KEY (APPLICATION_ROLE_ID)); CREATE TABLE APPLICATIONS (APPLICATION_ID number(15) GENERATED AS IDENTITY, CODE varchar2(30), NAME_AR varchar2(255), NAME_EN varchar2(255), START_DATE date, END_DATE date CONSTRAINT PK_SEC_APPLICATIONS PRIMARY KEY (APPLICATION_ID)); CREATE TABLE PERMISION_DEFINITIONS (PERMISION_DEFINITION_ID number(15) GENERATED AS IDENTITY, CODE varchar2(30), NAME_AR varchar2(255), NAME_EN varchar2(255), START_DATE date, END_DATE date CONSTRAINT PK_SEC_PERMISION_DEFITIONS PRIMARY KEY (PERMISION_DEFINITION_ID)); CREATE TABLE ROLE_PERMISSIONS (ROLE_PERMISSION_ID number(15) GENERATED AS IDENTITY, ROLE_ID number(15), PERMISION_DEFINITION_ID number(15), START_DATE date, END_DATE date CONSTRAINT PK_SEC_ROLE_PERMISSIONS PRIMARY KEY (ROLE_PERMISSION_ID)); CREATE TABLE ROLES (ROLE_ID number(15) GENERATED AS IDENTITY, CODE varchar2(30) NOT NULL, NAME_AR varchar2(255), NAME_EN varchar2(255), START_DATE date, END_DATE date CONSTRAINT PK_SEC_ROLES PRIMARY KEY (ROLE_ID)); CREATE TABLE USER_PERMISSIONS (USER_PERMISSION_ID number(15) GENERATED AS IDENTITY, USER_ID number(15), PERMISION_DEFINITION_ID number(15)CONSTRAINT PK_SEC_USER_PERMISSIONS PRIMARY KEY (USER_PERMISSION_ID)); CREATE TABLE USER_ROLES (USER_ROLE_ID number(15) GENERATED AS IDENTITY, USER_ID number(15), ROLE_ID number(15)CONSTRAINT PK_SEC_USER_ROLES PRIMARY KEY (USER_ROLE_ID)); 

Best Link List

Hi all.
Who can recommend a seller with a quality link list? I am specifically interested in quality link list (in your opinion) and link list for gambling niche.
If someone has previously asked for a similar – please send me a link
Thanks! :blush:

Where do I see a full, exhaustive list of the resources a given Google Cloud Platfrorm project uses?

I have just logged in to a Google Cloud Platform account, and it has several old Projects. I’d like to clean up by deleting the ones I don’t need, but for that I need to see a full list of services each Project uses.

I went to the Cloud Resource Manager, and it mentions a Compute Engine Service Agent here and there, but that’s it. I know one of those Projects must have some API Keys that I still need, but neither this page, nor the Billing page tell me which one.

Searching didn’t help. This looks like the closest, but doesn’t make any sense to me and looks overcomplicated for such a simple task.

Is there one single page that will show me everything a given Project uses, so I am informed enough to decide if I still need it? Please help!

How to export full list of outbound clicks

I have Google Analytics with "Outbound click" enhanced measurement enabled. (I also have GTM setup, but it seems to be ignoring this in favor of the built-in enhanced measurement.)

In my Events tab, I can see that clicks are being tracked and it has a counter for each unique outbound link.

How on earth do I export the full list of outbound links?

enter image description here

enter image description here

In Google Data Studio, I connected my Analytics account, but it only gives me the "Event name" as a field. There is no URL field and I can’t find any way to aggregate by URL instead of event name.

Passing list into another list

Suppose I have a zero matrix Amat and a list of values ltest that contains the values of the matrix Amat for the some of its diagonal elements:

L = 10000; Amat = 0. IdentityMatrix[L]; ltest = {{-0.70710, 1329}, {-0.25, 5607}, {-0.3535, 1261}, {-0.25, 4393}, {-0.5, 4358}, {-0.3511, 1009}, {-1., 3815}, {-0.25, 3784}, {-0.133, 3667}, {-0.88, 909}}; 

Now in order to pass the second column of ltest to Amat I can do:

For[i = 1, i <= Length[ltest], i++, Amat[[ltest[[All, 2]][[i]], ltest[[All, 2]][[i]]]] = ltest[[All, 1]][[i]]] 

Is there a shorter way without using For?