Category : jsonb

I’m using Symfony Messenger and the Doctrine Transport. This means that Symfony messenger creates a table messenger_messages where it stores the messages to process. I’ve configured the serializer to use the json format, so, in the database, I can use PostegreSQL native json functions. Now, when a message is saved to the database, it has ..

Read more

How can i compare IP submit by Form with IP range in my database (postgresql) ? Actually my IP Range are stored in jsonb in database $builder ->add(‘firstIpAddresses’, TextType::class, [ ‘constraints’ => [ new Ip([ ‘version’ => Ip::V4_ONLY_PUBLIC ]), ], ]) ->add(‘lastIpAddresses’, TextType::class, [ ‘constraints’ => [ new Ip([ ‘version’ => Ip::V4_ONLY_PUBLIC ]), ], ]); ..

Read more