Tag: )}>Update

Can I use Postgres rules to reset session variables before/after queries?

Post author By Jessica Alba
Post date January 25, 2021
No Comments on Can I use Postgres rules to reset session variables before/after queries?

I am using Postgres row based security and I wish to ensure it is not possible for a specific session variable (that holds a tenant id) to remain set in between transactions / queries. The reason is because the session is shared between user queries – if that session variable is set but not cleared, […]

Tags )}>Update, and clear the session variable using RESET or SET in between every transaction or query. RESET https://www.postgresql.org/docs/9.1/sql-reset., DELETE query. Although the Postgres rules system appears to have the capabilities to do this but I cannot find much detail. As you can see, I am using Postgres row based security and I wish to ensure it is not possible for a specific session variable (that holds a tenant id) to re, insert(), then it is possible that the next query - which is for a different application user - might be executed using the session variable from the p

Database Development

Can I use Postgres rules to reset session variables before/after queries?

Post author By Jessica Alba
Post date January 25, 2021
No Comments on Can I use Postgres rules to reset session variables before/after queries?

Tags )}>Update, and clear the session variable using RESET or SET in between every transaction or query. RESET https://www.postgresql.org/docs/9.1/sql-reset., DELETE query. Although the Postgres rules system appears to have the capabilities to do this but I cannot find much detail. As you can see, I am using Postgres row based security and I wish to ensure it is not possible for a specific session variable (that holds a tenant id) to re, insert(), then it is possible that the next query - which is for a different application user - might be executed using the session variable from the p

Database Development

Can I use Postgres rules to reset session variables before/after queries?

Post author By Jessica Alba
Post date January 25, 2021
No Comments on Can I use Postgres rules to reset session variables before/after queries?

I am using Postgres row based security and I wish to ensure it is not possible for a specific session variable to remain set in between transactions / queries. The reason is because the session is shared between user queries. I wish to ensure that the only session variables that can be used are LOCAL […]

Tags )}>Update, a google search doesn't return much useful: Can anyone direct me to information that might help me work out how to do this? thanks, and clear the session variable using RESET or SET in between every transaction of query. RESET https://www.postgresql.org/docs/9.1/sql-reset., DELETE query. Although the Postgres rules system appears to have the capabilities to do this but I cannot find much detail. As you can see, I am using Postgres row based security and I wish to ensure it is not possible for a specific session variable to remain set in between trans, insert()

Database Development

MySQL InnoDB cluster admin unable to create database

Post author By Jessica Alba
Post date January 20, 2021
No Comments on MySQL InnoDB cluster admin unable to create database

I have set up a new InnoDB cluster and created a non-root admin user. I have also set up mysqlrouter on a seperate host. To open a session I am using mysqlsh on the current primary member using the non-root admin user: [root@srv-db-mysql-03 ~]# mysql –version mysql Ver 8.0.23 for Linux on x86_64 (MySQL Community […]

Tags :create, "Super", )}>Update, ALTER, ALTER ROUTINE, CLONE_ADMIN, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE USER ON *.* TO `icadmin`@`%` WITH GRANT OPTION, CREATE VIEW, DELETE, DELETE ON `mysql`.* TO `icadmin`@`%` WITH GRANT OPTION, Drop:['', Event}, Execute, file:'', I can see that it should be able to create a new database and also assign permissions: MySQL localhost:33060+ ssl SQL > show grants; +---, I have set up a new InnoDB cluster and created a non-root admin user. I have also set up mysqlrouter on a seperate host. To open a session I, index, LOCK TABLES, PERSIST_RO_VARIABLES_ADMIN, process, References, reload, REPLICATION CLIENT, REPLICATION SLAVE, REPLICATION_APPLIER, SHOW VIEW, SHUTDOWN, SYSTEM_VARIABLES_ADMIN ON *.* TO `icadmin`@`%` WITH GRANT OPTION, TRIGGER ON `mysql_innodb_cluster_metadata`.* TO `icadmin`@`%` WITH GRANT OPTION | | GRANT INSERT, TRIGGER ON `mysql_innodb_cluster_metadata_bkp`.* TO `icadmin`@`%` WITH GRANT OPTION | | GRANT INSERT, TRIGGER ON `mysql_innodb_cluster_metadata_previous`.* TO `icadmin`@`%` WITH GRANT OPTION | +-------------------------------------------------, when trying to add a new user for OpenNebula

Database Development

MySQL InnoDB cluster admin unable to create database

Post author By Jessica Alba
Post date January 20, 2021
No Comments on MySQL InnoDB cluster admin unable to create database

Tags :create, "Super", )}>Update, ALTER, ALTER ROUTINE, CLONE_ADMIN, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE USER ON *.* TO `icadmin`@`%` WITH GRANT OPTION, CREATE VIEW, DELETE, DELETE ON `mysql`.* TO `icadmin`@`%` WITH GRANT OPTION, Drop:['', Event}, Execute, file:'', I can see that it should be able to create a new database and also assign permissions: MySQL localhost:33060+ ssl SQL > show grants; +---, I have set up a new InnoDB cluster and created a non-root admin user. I have also set up mysqlrouter on a seperate host. To open a session I, index, LOCK TABLES, PERSIST_RO_VARIABLES_ADMIN, process, References, reload, REPLICATION CLIENT, REPLICATION SLAVE, REPLICATION_APPLIER, SHOW VIEW, SHUTDOWN, SYSTEM_VARIABLES_ADMIN ON *.* TO `icadmin`@`%` WITH GRANT OPTION, TRIGGER ON `mysql_innodb_cluster_metadata`.* TO `icadmin`@`%` WITH GRANT OPTION | | GRANT INSERT, TRIGGER ON `mysql_innodb_cluster_metadata_bkp`.* TO `icadmin`@`%` WITH GRANT OPTION | | GRANT INSERT, TRIGGER ON `mysql_innodb_cluster_metadata_previous`.* TO `icadmin`@`%` WITH GRANT OPTION | +-------------------------------------------------, when trying to add a new user for OpenNebula

Database Development

MySQL InnoDB cluster admin unable to create database

Post author By Jessica Alba
Post date January 20, 2021
No Comments on MySQL InnoDB cluster admin unable to create database

Tags :create, "Super", )}>Update, 0 rows affected (0.0973 sec) MySQL localhost:33060+ ssl SQL > GRANT ALL PRIVILEGES ON opennebula.* TO oneadmin@'%'; ERROR: 1044: Access de, ALTER, ALTER ROUTINE, CLONE_ADMIN, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE USER ON *.* TO `icadmin`@`%` WITH GRANT OPTION, CREATE VIEW, DELETE, DELETE ON `mysql`.* TO `icadmin`@`%` WITH GRANT OPTION, Drop:['', Event}, Execute, file:'', I can see that it should be able to create a new database and also assign permissions: MySQL localhost:33060+ ssl SQL > show grants; +---, I get the following error: MySQL localhost:33060+ ssl SQL > CREATE USER oneadmin@'%' IDENTIFIED BY 'password'; Query OK, I have set up a new InnoDB cluster and created a non-root admin user. I have also set up mysqlrouter on a seperate host. To open a session I, I should manage the cluster through the router, I would assume that I should use this user for management purposes?, index, LOCK TABLES, PERSIST_RO_VARIABLES_ADMIN, process, References, reload, REPLICATION CLIENT, REPLICATION SLAVE, REPLICATION_APPLIER, SHOW VIEW, SHUTDOWN, so maybe I am missing something. As far as I understand, SYSTEM_VARIABLES_ADMIN ON *.* TO `icadmin`@`%` WITH GRANT OPTION, this way I am always able to easily connect to the primary member. Since icadmin is my non-root cluster admin, TRIGGER ON `mysql_innodb_cluster_metadata`.* TO `icadmin`@`%` WITH GRANT OPTION | | GRANT INSERT, TRIGGER ON `mysql_innodb_cluster_metadata_bkp`.* TO `icadmin`@`%` WITH GRANT OPTION | | GRANT INSERT, TRIGGER ON `mysql_innodb_cluster_metadata_previous`.* TO `icadmin`@`%` WITH GRANT OPTION | +-------------------------------------------------, when trying to add a new user for OpenNebula

Mastering Development

User roles and permissions. Laravel Fortify (and not only)

Post author By Full Stack
Post date January 15, 2021
No Comments on User roles and permissions. Laravel Fortify (and not only)

Is there any ready-made functionality in the Fortify package for setting user roles and permissions (regular user, admin, main admin, etc.)? If not, what is the correct way to implement it yourself? Alternatively, create middleware and an is_admin field in the users table. And do the check: if(Auth::user()->is_admin != 1){ return redirect()->route(‘index’); } Route: Route::group([‘middleware’ […]

Tags 'admin_panel'])->name('admin_panel'); }); It's easy if I have 2 user roles (0 is normal user, 'admin_panel'])->name('admin_panel'); Route::group(['middleware' => 'id_ceo'], 'ceo_panel'])->name('ceo_panel'); }); }); Is it correct way?, "Admin", "categories", )}>Update, [AdminController::class, 1 is administrator). But what if I have a regular user, an admin (can edit, and a CEO (can give and take away admin rights, create middleware and an is_admin field in the users table. And do the check: if(Auth::user()->is_admin != 1){ return redirect()->route(, delete products, edit users' data and delete users)? Is it worth creating a second middleware to check is_ceo? And with second middleware route: Route::grou, etc., etc.); if not, function(){ Route::get('/admin-panel', function(){ Route::get('/ceo-panel', Is there any ready-made functionality in the Fortify package for setting user roles and permissions (regular user, main admin, what is the correct way to implement it yourself? Alternatively

Database Development

2ndQuadrant/Pglogical multi-master cluster installation

Post author By Jessica Alba
Post date December 18, 2020
No Comments on 2ndQuadrant/Pglogical multi-master cluster installation

I’m looking for a way to make a multi-master cluster with pglogical. When I say multi-master, it’s means 3 nodes, where each of them is a provider and a subscriber. Currently I have two nodes that working fine as a provider and a subscriber at the same time. But when I whant to add my […]

Tags )}>Update, all INSERT, because the subscription try to insert always the same tuples, delete orders on each node ) like this each node could send and receive data, I'm looking for a way to make a multi-master cluster with pglogical. When I say multi-master, in wich order I have to do the subscription and the replication_set ? Specially for don't have a conflict_detection, it's means 3 nodes, like a loop. So what I need in architecture for the cluster is : 3 nodes provider and subscriber as the same time 2 subscriptions for each, normally. My questions are : Does anyone have already installed a multimaster cluster with pglogical ? If yes, the conflict_detections appears, when synchronize data. Does anyone could share me a example of installation step by step for the subscription/replication_set part ? thank y, where each of them is a provider and a subscriber. Currently I have two nodes that working fine as a provider and a subscriber at the same t, with the two others

Mastering Development

DatabaseError when Login Out of Application

Post author By Full Stack
Post date December 16, 2020
No Comments on DatabaseError when Login Out of Application

I’m working on a project that consist on sensor data and realtime database data into the application. My App receives the data from the sensor every time it is updated, using a StreamBuilder. Everything is working fine, I can get, update, add and remove data from my database, I can login and register succesfully. But […]

Tags ".write":"auth != null" } } This Error only occurs when logging out, )}>Update, add and remove data from my database, but doens't show any errors: Stream getSensorHumidity() async* { final FirebaseUser user = await _auth.currentUser(); await fo, But My app crashes every time I log out, com.firebase, from the "await for": // Função para ler o valor da temperatura Stream getSensorTemperature() async* { final FirebaseUser user =, how can I remove this error?, I can get, I can login and register succesfully. But I'm having problems when Logging out of my Application. Every time I log out, I get the following error: Exception has occurred. DatabaseError (DatabaseError(1, I know this has to do with my security rules, I'm working on a project that consist on sensor data and realtime database data into the application. My App receives the data from the senso, Permission Denied)) The Error comes from this function, using a StreamBuilder. Everything is working fine

Database Development

Transaction Time Tables in MSSQL and Constraints

Post author By Jessica Alba
Post date December 11, 2020
No Comments on Transaction Time Tables in MSSQL and Constraints

I am trying to implement transaction time tables on a MSSQL Server 2016 following the book by Richard Snodgrass (Developing Time-Oriented Database Applications in SQL). A table with a sequenced primary key through a trigger could be implemented like this: CREATE TABLE test_table ( a [tinyint] NOT NULL, b [date] NOT NULL, c [float] NOT […]

Tags )}>Update, [tt_end] [datetime2](7) NOT NULL) GO CREATE TRIGGER Seq_Primary_Key_tt ON test_table FOR INSERT, [tt_start] [datetime2](7) NOT NULL, 1, 2) ROLLBACK TRANSACTION END END GO The trigger is pretty slow on larger tables. Therefore, although the operation would perfectly work out if the trigger would start after the UPDATE. That is why Snodgrass writes that the constrain, As far as I see, b [date] NOT NULL, because the trigger would start already after the INSERT and fail, c [float] NOT NULL, DELETE AS BEGIN IF (( EXISTS ( SELECT * FROM test_table AS b1 WHERE 1 < (SELECT COUNT(b2.a) FROM test_table AS b2 W, I am trying to implement transaction time tables on a MSSQL Server 2016 following the book by Richard Snodgrass (Developing Time-Oriented Dat, many operations like updates require more than one operation (e.g. INSERT, MSSQL Server doesn't implement DEFERRABLE INITIALLY DEFERRED. How could a similar constraint or trigger be then implemented?, the constraints would be checked after all operations have finished. This would at the same time also increase the performance of multiple IN, then UPDATE). This doesn't work with this trigger, using multiple INSERTs leads to long waiting times. Furthermore