Which biometric data will be stored by British border control when EU citizens scan their biometric passport at the airport (entry and exit to / from Europe)?

Stack Exchange network

The Stack Exchange network consists of 175 Q & A communities, including Stack Overflow, the largest and most trusted online community where developers can learn, share, and build a career.

Visit Stack Exchange

Architecture – Microservices and Stored Procedures

There is nothing that explicitly prohibits or opposes the use of stored procedures with microservices.

Disclaimer: I do not like stored procedures from a developer's POV, but this has nothing to do with microservices.

Stored procedures usually work with a monolith database.

I think you are making a logical mistake.

Stored procedures are decreasing nowadays. Most of the stored procedures that are still in use come from an older codebase that still exists. At that time, monolithic databases were much more common than at times when microservices became popular.

Stored procs and monolithic databases both come from old codebases, so you'll see them together more often. But that is not a causal connection. They do not use stored procs there You have a monolithic database. You do not have a monolithic database there They use stored procs.

Most books on microservices recommend one database per microservice.

There is no technical reason why these smaller databases can not have stored procedures.

Like I said, I do not like stored procs. I find it awkward and resistant to future maintenance. I think that distributing sprocs to many small databases further aggravates the problems that I do not already like. That does not mean that it is not possible.

Again, most books on micro-service architecture state that they should be autonomous and loosely coupled. Integrate the microservice closely with this technology using specially stored Oracle stored procedures.

On the other hand, the same argument can be made for the ORM used by your microservice. Not every ORM supports every database. The coupling (especially its tightness) is a relative concept. It's about being as relaxed as possible.

Sprocs generally suffer from tight coupling, regardless of microservices. I would generally advise against Sprocs, but not especially because you use microservices. It's the same argument as before: I do not think sprocs are the right way (in general), but that might just be my bias, and it's not microservices.

Most MSA books (which I read) recommend that microservices should be business oriented (developed with Ddd). Moving business logic to stored procedures in the database no longer works.

That has always been my main problem with Sprocs: business logic in the database. Even if it is not the intention, it somehow always ends like this.

But even here, there is this point of criticism, regardless of whether you use microservices or not. The only reason it looks like that is that microservices are pushing you to modernize your entire architecture and that sprocs are no longer so popular in modern architectures.

Stored CRUD procedures in Oracle PL / SQL without using cursors

I have a little doubt about the procedures stored in Oracle. You asked me to do a CRUD of a table (table: position, columns: ID, name and description) using store procedures. The problem is that I have been asked for the SP not to use cursors.
My question is how I use no cursors.
If someone can show me an example, I would appreciate it very much.

Where do I save Instagram videos stored on my device?

These are videos I took with Instagram on the device, not videos of other people. I then pressed his videos before sharing / posting on the "Save" button. Over time, I have several videos that I want to download to my PC.

The only way to find them on the device seems to be in the Instagram app, where you publish articles and browse all the media on your device; when I scroll down, I see the videos, but that's not it filtered or organized.

I searched the device memory IE

This PC Pixel 3 Internal Shared Storage Android data com.instagram.android

To find only a few files there. You need to be on the device because I can search it while posting to the Timeline / Story, but can not find it.

Machine Learning – Request for stored data and statistics

I am currently working on a project to optimize the memory algorithm of memcached using machine learning.

Since I do not own / use large memcached servers, someone would be willing to share the stats from:

a] Which * data sizes * are normally entered? {average value size}

b] what kind of distribution of sizes takes place? {Normal distribution, Poisson distribution, etc.}

If someone just wants to send raw data so that I can find out these two myself, I would be very grateful!

Mapping – Defining a function from an evaluated function stored in a variable

I have the rating of a function bstored in appo, Now I want to define a new function f (actually the same as b) With appoas in the code below, which does not work.

b(s_) := s^2
appo = b(t)
f(t_) := appo;
f(2)
b(2)
(*
 t^2
 t^2
 4
*)

Note that instead

b(s_) := s^2
appo = b(t)
f(t_) := b(t);
f(2)
b(2)
(*
 t^2
 4
 4
*)

works perfect. Do I miss anything important about handling parameters in Mathematica? What is the problem with the first version?

Many thanks.

Bitcoin Core – Create P2SH address does not match the address stored on the RPC node

I have a private key and I'm trying to create a P2SH address on testnet how my node was created, but they are not identical. Please help me a bit, thank you.

Private key: c5964e19634e473e9c8fed3b149c4d44b6d62d62724035aad3eb911a1495ae27

P2SH Address of 1 Threshold and 1 Pubkey:
2N4GriyLchUgwwCBonzYHgsCHNhYRHW45w7

P2WPKH address: 2NGA8uGdnaQ21phNpVyV5uye5cbUtudxBWh || tb1qld2fzw9gj30wxjamsz73fug62das7cyq0em4mn

Address from the node: 2N8qKVKuR3QAy2cA5fF2QbuCpBGfGCmbUHx

Here's more detail from getaddressinfo:

{
    "result": {
        "address": "2N8qKVKuR3QAy2cA5fF2QbuCpBGfGCmbUHx",
        "scriptPubKey": "a914aafc9f09b99cbb1ba46001ec4868ba4fb32543ca87",
        "ismine": true,
        "solvable": true,
        "desc": "sh(wpkh((a1696bdc/0'/0'/375509')02a7065a210c28d27a591e55ac6be092111349fc4b23927bb4d13c46a683bcfff7))#hrgzj3gs",
        "iswatchonly": false,
        "isscript": true,
        "iswitness": false,
        "script": "witness_v0_keyhash",
        "hex": "00146da71bc5de0c0b59bbf73520df7e7d4048d02594",
        "pubkey": "02a7065a210c28d27a591e55ac6be092111349fc4b23927bb4d13c46a683bcfff7",
        "embedded": {
            "isscript": false,
            "iswitness": true,
            "witness_version": 0,
            "witness_program": "6da71bc5de0c0b59bbf73520df7e7d4048d02594",
            "pubkey": "02a7065a210c28d27a591e55ac6be092111349fc4b23927bb4d13c46a683bcfff7",
            "address": "tb1qdkn3h3w7ps94nwlhx5sd7lnagpydqfv5pyqurf",
            "scriptPubKey": "00146da71bc5de0c0b59bbf73520df7e7d4048d02594"
        },
        "label": "test",
        "ischange": false,
        "timestamp": 1561438016,
        "hdkeypath": "m/0'/0'/375509'",
        "hdseedid": "e2e9dd17501f967b789c28c4be1dbf64897ad8d2",
        "hdmasterfingerprint": "a1696bdc",
        "labels": (
            {
                "name": "test",
                "purpose": "receive"
            }
        )
    },
    "error": null,
    "id": 1
}

SQL Server schema of the sync database table and stored procedures

We have 2 databases, one is on our server, the other is local.
and we both need to synchronize in a way that the local database contains all the data and the server database contains no data, just empty tables and stored procedures and functions.

In the server database, we change stored procedures and functions as tables as before in the server database and the local database

Table 1 (ID, name, price)

common to both db

now we switch to the server db

Table 1 (ID, name, price, IsActive)

Where the local database still has an old structure and we can not delete the table due to data, but we want the IsActive field in the local database

and the need to synchronize stored procedures and functions.

In simple words, we need a solution to synchronize stored procedures and functions and the table schema without corrupting existing data.

can anyone suggest any tools or codes that we can use to satisfy the same
with some google and search we found a codeproject article, which can be used for fresh databases. still share the link below.
https://www.codeproject.com/Articles/994806/SQL-Server-Database-Cloning-Tool-using-Csharp

Many thanks

Stored Procedures – To update the column value based on the number of another column without an aggregate error

I'm trying to set a column value to "YES" if certain criteria are met. Some of these criteria apply when the number of column values ​​is greater than 1. Some of the criteria are not based on the number.

The goal is to mark a lgh_type3 field as Yes if a driver needs to pick up or deliver in certain areas. There are states (8) that pay a bonus, and there are three-digit zip areas that pay a bonus. The bonus is applied automatically when "Yes" is displayed in the "lgh_type3" field. I've tried different combinations within the update statement, but still get the aggregate error. The count is needed when a trip is split. This lists 2 ord_hdrnumbers in the legheader table. The same driver is displayed on both legs, and the driver's count is also indicated at 2.

ALTER procedure (dbo).(update_move_postprocessing_EastCoast) (@leg int)

as
declare @EC_State table (OD_State varchar (2)) --States that pay when picked or delivered in.
insert into @EC_State (OD_State) Values
('ME'), ('VT'), ('NH'), ('MA'), ('CT'), ('RI'), ('NJ'), ('DE'), ('DC'), ('MD')

declare @EC_Zip table (OD_Zip varchar(3))
insert into @EC_Zip (OD_Zip) Values
('241'),('244'),('245'),('228'),('229'),('239'),('238'),('232'),('227'),('226'),('201'),('225'),('231'),('234'),('236'),('230'),('233'),('224'),('223'),('222'),('221'),('235'),('237'),('217'),('211'),('210'),
('219'),('212'),('208'),('214'),('207'),('216'),('218'),('206'),('209'),('200'),('203'),('202'),('205'),('204'),('129'),('128'),('123'),('122'),('125'),('126'),('105'),('117'),('106'),('107'),('104'),('110'),
('115'),('114'),('112'),('111'),('109'),('127'),('124'),('121'),('120'),('134'),('136'),('133'),('135'),('138'),('139'),('132'),('131'),('137'),('173'),('174'),('175'),('193'),('191'),('190'),('194'),('195'),
('196'),('171'),('179'),('180'),('182'),('187'),('183'),('184'),('185'),('186'),('188'),('170')

update L
set L.lgh_type3 =  
Case when Exists  
(Select ord_originstate, ord_deststate from orderheader where (ord_originstate =T.OD_State or ord_deststate = T.OD_State ))
       Then 'YES'
       Else 'NO'
       End
from legheader L 
Inner Join @EC_State T on T.OD_State = L.lgh_startstate or T.OD_State =  L.lgh_endstate
Inner Join orderheader O on O.ord_hdrnumber = L.ord_hdrnumber
where L.ord_hdrnumber = @leg 

update L
Set L.lgh_type3 = 
 Case  when exists
       (Select count(ord_hdrnumber) , count(lgh_driver1)  from legheader where Count(ord_hdrnumber)>1 and Count(lgh_driver1)>1 and T.OD_State in(Ord_originstate,ord_deststate))
       then 'YES'
       Else 'NO'
       End 
from legheader L 
Inner Join @EC_State T on T.OD_State = L.lgh_startstate or T.OD_State =  L.lgh_endstate
Inner Join orderheader O on O.ord_hdrnumber = L.ord_hdrnumber
where L.ord_hdrnumber = @leg 

update L
set L.lgh_type3 =  
Case When Exists 
( Select Left (ord_origin_zip,3), Left (ord_dest_zip,3) from orderheader join @EC_Zip on (Left(ord_origin_zip,3) = T.OD_Zip) or (Left(ord_dest_zip,3) = T.OD_Zip))
       Then 'YES'
       Else 'NO'
       End
from legheader L 
Inner Join @EC_Zip T on T.OD_Zip = Left (L.lgh_originzip,3) or T.OD_Zip =  Left (L.lgh_endstate,3)
Inner Join orderheader O on O.ord_hdrnumber = L.ord_hdrnumber
where L.ord_hdrnumber = @leg 

update L
Set L.lgh_type3 = 
Case When Exists
(Select count(ord_hdrnumber) ,count(lgh_driver1) from legheader where count (ord_hdrnumber)>1 and count(lgh_driver1)>1 and (Left(ord_origin_zip,3) = T.OD_Zip or LEft(ord_dest_zip,3)=T.OD_Zip))
       then 'YES'
       Else 'No'
       End 
from legheader L 
Inner Join @EC_Zip T on T.OD_Zip = Left(L.lgh_originzip,3) or T.OD_Zip =  Left(L.lgh_destzip,3)
Inner Join orderheader O on O.ord_hdrnumber = L.ord_hdrnumber
where L.ord_hdrnumber = @leg 







GO

Grant Execute on update_move_postprocessing_EastCoast to public
GO

For example, what happens is that a driver picks up a load in a city whose postal code starts at 196. This should set the lgh_type3 field to YES, which in turn activates a rate that pays as much per mile based on lgh_type3 = YES.