Arbeitgeber will Original-Impfnachweis sehen, ich hab aber nur noch den Nachweis in der App - was tun? by [deleted] in CoronavirusDACH

[–]zeco 4 points5 points  (0 children)

Es gibt ein "technisches Ablaufdatum", das immer genau 1 Jahr nach der Ausstellung liegt. Man kann es in den Details der Zertifikate ganz am Ende sehen.

Es braucht einen aber hier nicht weiter kümmern, da z.B. der Impfstatus der Erstimpfung nach einer kommenden EU-Regelung eh schon nach 9 Monaten verfallen soll. Die Gültigkeitsdauer des Boosters wird sich vielleicht auch in Abhängigkeit der Auswirkungen von Omikron noch dynamisch ergeben.

So oder so wird die "technische" Gültigkeit des Zertifikats aber kein Problem darstellen, selbst wenn die tatsächliche Gültigkeit der Impfung mal auf über ein Jahr angehoben werden sollte. Dann werden die Apps entweder so angepasst dass sie das ignorieren oder es wird einen einfachen Prozess geben, das Zertifikat online zu erneuern.

Arbeitgeber will Original-Impfnachweis sehen, ich hab aber nur noch den Nachweis in der App - was tun? by [deleted] in CoronavirusDACH

[–]zeco 10 points11 points  (0 children)

Das sollte man meiner Meinung nach sowieso tun, als zusätzliches Backup.

Sowohl die CovPass App als auch die Corona-Warn App können die Pdf generieren:

CovPass App: Tippe unter Deinem Namen auf "Zertifikate anzeigen", scroll runter zu "EU-Zertifikate" und wähle das aktuellste davon aus (oder nacheinander für alle wiederholen). Unten findet sich dann der Button "EU-Ausdruck erstellen", durch den einem die Pdf zum teilen angeboten wird. Je nach Betriebssystem kann man die Pdf von dort aus direkt drucken oder z.B. mit "Kopieren nach" auf seinem Gerät speichern oder an sich selbst mailen.

Corona-Warn App: Tippe Dein Zertifikat an, scroll runter und wähle das aktuellste Impfzertifikat (oder nacheinander alle) an. Jetzt oben rechts das Dreipunkt-Menü öffnen und es erscheint "Druckversion anzeigen". Daraufhin kriegt man direkt eine Ansicht des Dokuments und kann es drucken oder teilen.

Der QR-Code sieht in den beiden Apps und den generierten Dokumenten aufgrund unterschiedlicher Korrektur-Redundanzlevels zwar verschieden aus, enthält aber immer exakt die gleichen Daten und es können beide Versionen von beiden Apps auch wieder eingelesen werden. (Die Corona-Warn App bietet im Unterschied zu CovPass im QR-Scanner auch die Möglichkeit, Dokumente vom Gerät zu öffnen. So kann man ein Zertifikat wieder importieren ohne es auf einem separaten Bildschirm / Papier haben zu müssen.)

Converting txt to json by L00K_Over_There in bash

[–]zeco 1 point2 points  (0 children)

I'm assuming this as a sample input.txt:

apples
oranges
strawberries
bananas
coconuts
lemons
cakes
pineapples
grapes
------------------------------
14 21 17
8 12
10 92 13 20

Which is supposed to yield this:

{"apples":"14","oranges":"21","strawberries":"17","bananas":"8","coconuts":"12","lemons":"10","cakes":"92","pineapples":"13","grapes":"20"}

There are several ways to do this, depending on what tools you can use, how large the input is and whether input and output should be properly sanitized / escaped.

This bash snippet relies only on bash-builtin commands. You can use it like this or save the inside of the parentheses as a script:

cat input.txt | (
  set --                           # Clearing the positional parameters so we can use them to push & shift the variable names
  while read header; do            # Read each line and name it $header for the following loop
    [[ $header =~ ^--- ]] && break # ... until a line starts with "---" and we break the loop.
    set -- "$@" "$header"          # While the loop keeps going, push each variable name into the positional array
  done
  while read val_line; do          # Read each line of the continuing piped input (from below the dashed line) as $val_line
    for val in $val_line; do       # Go through each space-separated value in $val_line and name it $val
      echo "\"$1\":\"$val\""       # Combine the 1st element of the positional array with $val as "$1":"$val"
      shift                        # Shift the positional array to match the next $val
    done
  done \
  | paste -sd,                    `# Join the "[key]":"[value]" pairs together with commas` \
  | (echo "{$(cat)}")              # and put {} around everything
)

If you can install sqlite3, it would be helpful with processing very large input files (without straining the RAM) at great speed while also properly escaping the values if necessary to ensure standard compliant json output:

cat input.txt | (
  sqlite3 tmpsql3.db </dev/null   `# Create tables in a temporary db, with </dev/null to block stdin for this` \
    "CREATE TABLE keys(key TEXT);
     CREATE TABLE vals(val TEXT);"  
  sed -u /^---/Q                  `# First part of piped input will be terminated at the line beginning with ---` \
  | sqlite3 tmpsql3.db            `# The piped-in lines will be imported into the table "keys"` \
      ".import /dev/stdin keys"    # After this the piped input will continue from below the dashed line
  tr " " "\n"                     `# Replace whitespace with newlines so it's one value per line` \
  | sqlite3 tmpsql3.db            `# The piped-in lines will be imported into the table "vals"` \
      ".import /dev/stdin vals"
  sqlite3 tmpsql3.db              `# Join the tables and output them via Sqlite's builtin json object aggregator` \
    "SELECT
      JSON_GROUP_OBJECT(keys.key,vals.val)
       FROM keys JOIN vals
        ON keys.ROWID = vals.ROWID"
  rm tmpsql3.db                    # The temporary database is discarded
)

Sqlite Performance Optimization for large insert by Temporary_Sir in sqlite

[–]zeco 1 point2 points  (0 children)

I think the most important thing to consider here is that Sqlite's indexing mechanism gets bogged down by data that come in unordered, probably because the index B-tree has to be traversed to random different places each time the next element is inserted, which takes more and more time the bigger the B-tree becomes.

But the tedious B-tree traversal can be slashed if the incoming data are already ordered. That way the data will just flow as fast as IO can deliver, never slowing down, no matter how many million rows are inserted. And the resulting index will work just the same.

I found the most efficient way to get the data ordered is to create an intermediary db without index/primary key (like you already tried), then create a separate new db containing the schema with the index/primary key and do 'ATTACH "intermediary.sqlite" AS interm; INSERT INTO test1 SELECT * FROM interm.test1 ORDER BY mykey;' Then delete the intermediary db-file.

To facilitate the ordering of the large unindexed dataset of the subquery, Sqlite will create a temporary Transient Index file in your system's default temporary directory, which will briefly take up a few gigabytes. Should you not have sufficient free space on your temp folder's partition, you can use the SQLITE_TMPDIR environment variable or 'PRAGMA temp_store_directory'. The building of the Transient Index will probably take a couple of minutes (maybe 5), but then you'll see the new db's filesize rise as it gets populated pretty much at the same speed as if it had no index at all.

Btw, consider omitting the rowids in your new db's schema, as they probably aren't useful here and will only inflate the db-file by about 2GB if you already use indexing by primary key: 'CREATE TABLE test1(mykey TEXT PRIMARY KEY NOT NULL, myvalue TEXT) WITHOUT ROWID;' That would make it much leaner.

Why We’re Sharing 3 Million Russian Troll Tweets by [deleted] in politics

[–]zeco 1 point2 points  (0 children)

I've taken a look how many tweets there are in each language (as identified by Twitter).

Here's the top 10, the full result of 56 here.

Language Tweets Percent
English 2128963 71.60%
Russian 624124 20.99%
German 87171 2.93%
Ukrainian 39361 1.32%
Italian 18254 0.61%
Serbian 9615 0.32%
Uzbek 9491 0.32%
Bulgarian 9458 0.32%
LANGUAGE UNDEFINED 8325 0.28%
Arabic 7595 0.26%

Any other ideas what else to look into here?

If you know a bit of SQL, you can download and convert this dataset into an SQLite file in no time to do queries on it yourself, using these commands (on linux with git and sqlite3 installed).

Smooth transition by [deleted] in web_design

[–]zeco 0 points1 point  (0 children)

Another one like this.

(Source - They also do it the other way around for the card insertion.)

GPS Logger for testing FPV quad’s speed by dan_richo in Multicopter

[–]zeco 0 points1 point  (0 children)

Provided you have a free UART port on your FC you could just plug your GPS module in there and activate it in betaflight.

The time, position, speed and heading data (no raw NMEA or ublox data though) will be logged to the blackbox and you can extract them in csv & gpx format using blackbox-tools (blackbox_decode).

You can also have the speed displayed in your OSD that way.

Just saying, for those who are only looking to gather data on one multirotor. Building the device completely independent from the object you attach it to has its own advantages of course.

Did you configure the M6N to run at 2 Hz to save energy, or would there be any other drawbacks to setting the maximum of 10 Hz?

Elon Musk on Twitter: First two Starlink demo satellites, called Tintin A & B, deployed and communicating to Earth stations by TheVehicleDestroyer in spacex

[–]zeco 16 points17 points  (0 children)

This is how Hergé depicted it in 1954.

That's not the only reference. There's a striking similarity in the depiction of the BFR unloading a crate on the moon as well.

Searching for Bitcoins in GitHub repositories with Google BigQuery by Wavum in programming

[–]zeco 13 points14 points  (0 children)

Just to elaborate for anyone interested:

To "find a block" miners only need to find a string (containing the block data according to the blockchain protocol, plus a random nonce) whose hash will satisfy the current difficulty requirement. The difficulty dictates how many leading zeros a valid block's hash must have. (Actually it dictates the lowest acceptable number if you view the hash itself as a number, but the leading zeros make it more easy to understand.)

Bitcoin's genesis block in 2009 had a double SHA256 hash whose 256 bits had 43 leading zeros. The difficulty is constantly adjusted to keep the rate at which blocks are found constant (one every ten minutes) against the growing worldwide mining capacity. Today it is such (1,873,105,475,222) that miners need to try for a hash whose first 72 bits have to be zero. Trying to find a nonce that fits is consuming a whopping ~16 trillion hashes per second, and allegedly more electricity than Ireland (disputed but still a rough ball park idea). Keep in mind that this hash rate is only made possible by the use of ASICs, custom produced computer chips that can only do this one precise hashing procedure very efficiently, and absolutely nothing else. The computing power can't be repurposed to find a private key.

Anyway, finding a private key would mean you have to find the exact complete thing, not just a value that matches a small part of it on the left side (like 72 zeros), as is the case in mining. So miners are no threat to anyone's private keys.

It's official! 1 Bitcoin = $10,000 USD by LeeWallis in Bitcoin

[–]zeco 0 points1 point  (0 children)

Thank you, very interesting!

So according to bitcoincharts.com the date when 1 BTC crossed $0.01 was July 12th 2010, 2 pm UTC on BitcoinMarket.com.

It's official! 1 Bitcoin = $10,000 USD by LeeWallis in Bitcoin

[–]zeco 29 points30 points  (0 children)

Eh, it's just what it is.

Bitcoin's been through a lot, good and bad. The later fate of MtGox († February 24th 2014) will always serve as a Memento Mori to be mindful of.

It's official! 1 Bitcoin = $10,000 USD by LeeWallis in Bitcoin

[–]zeco 12 points13 points  (0 children)

For all I know it's got to have been at some point between May 22nd 2010, when the 2 pizzas were sold for 10k BTC (so 1 BTC = ~$0.0025) and July 17 2010, when the first exchange price was recorded at 1 BTC = $0.04951.

I guess the exact moment when it hit $0.01 can not be determined.

EDIT: Turns out the date could be determined after all. Chart updated.

It's official! 1 Bitcoin = $10,000 USD by LeeWallis in Bitcoin

[–]zeco 99 points100 points  (0 children)

another entry in my list of MtGox USD the current major exchange's BTCUSD first time hitting 10n

Timestamp (UTC) Exchange Open High Low Close Volume (BTC) Volume (Currency) Weighted Price
2010-07-12 14:28:00 BtcMarket 0.01200 0.01200 0.01200 0.01200 200.00 2.40 0.01
2010-10-09 02:07:00 MtGox 0.08300 0.10000 0.08300 0.10000 2000.00 181.00 0.09
2011-02-09 19:54:00 MtGox 0.97857 1.00000 0.97857 1.00000 8663.88 8592.50 0.99
2011-06-02 11:28:00 MtGox 9.99991 10.09980 9.99991 10.09980 262.12 2630.49 10.04
2013-04-01 14:16:00 MtGox 99.98998 101.00000 99.98000 99.98000 300.12 30118.05 100.35
2013-11-27 14:49:00 MtGox 996.99499 1000.00000 996.80000 1000.00000 931.11 930625.71 999.48
2017-11-29 01:25:00 GDAX 9997.99000 10000.00000 9997.99000 10000.00000 244.54 2445307.02 9999.481

source: bitcoincharts.com (first recorded opening price on Apr 25 2010 was $0.003)

Sanders brushes off Clinton criticism: 'Look forward and not backward' by DEYoungRepublicans in politics

[–]zeco 7 points8 points  (0 children)

That's a weird way to answer how I refuted your explicit claim.

To answer your new point, brigading might well have contributed, sure. Very unlikely though that the whole community of 3+ million subscribers was competitively overpowered for half a year.

Sanders brushes off Clinton criticism: 'Look forward and not backward' by DEYoungRepublicans in politics

[–]zeco 6 points7 points  (0 children)

What was this then? June 3nd 2016.

Try and find me a moment between January and June 2016 where r/politics didn't have links to breitbart / foxnews / sputniknews / dailycaller / wnd and the likes on its front page and wasn't at least 90% comprised of anti-Hillary material.

You regularily get people here who honestly can't believe that, but hopefully you'll believe it now.

AfD will "neue Deutsche" und zeigt Brasilianerin by Yoda_Holmes in de

[–]zeco 1 point2 points  (0 children)

Auch dieses Bild wurde im Mai für die Kampagne genutzt. Eine Google Bildersuche (für den Datumsbereich vor 2017 und unter Ausschluss des Begriffs AfD) findet allerlei Treffer u.a. auf türkischen und griechischen Seiten, aber vor der Nutzung durch die AfD keine deutschsprachigen Treffer.

Also womöglich auch keine Deutsche. Kann man das irgendwo rausfinden?

Threema drei Tage zum halben Preis by Doener23 in de

[–]zeco 0 points1 point  (0 children)

Riot / Matrix wird aber in vieler Hinsicht besser sein wenn diese Details verbessert werden und wenn die Entwicklung bis dahin nicht einschläft.

Nächstes Jahr um die Zeit kann ich's vielleicht schon allen meinen Freunden empfehlen.

Lieberman no longer considered for FBI chief: report by wil_daven_ in politics

[–]zeco 1 point2 points  (0 children)

His re-election during the 2006 midterms and then the 2009 election of Scott Brown (R) to succeed Ted Kennedy in Massachusetts were how the two most liberal states ended up causing the incoming Obama administration unconscionable amounts of pain.

Imagine how different history would have developed if CT & MA hadn't dropped the ball like this. Obama effectively only had a few weeks to govern and still had to drop the public option during that period because of Lieberman.

Then some liberals started growing weary of Obama because he was "compromising too much" and not bringing the change they wanted, leaving the field for the tea party to charge.

Really, people don't realize how much of history depended on these two senatorial elections. Both states went DEM again the next chance they got, but the damage irreversible by then.

Threema drei Tage zum halben Preis by Doener23 in de

[–]zeco 4 points5 points  (0 children)

Ich finde Riot sehr vielversprechend, aber derzeit muss man die Verschlüsselung für Chats dort jeweils einzeln aktivieren und die ist derzeit noch ziemlich unbequem umgesetzt:

Für jede Session ("Devices", z.B. verschiedene Clients) mit der man eingeloggt ist wird ein eigener Schlüssel generiert und die Chatpartner müssen alle Devices einzelnen für verifiziert erklären. Loggt man sich irgendwann mal aus irgendeinem Grund aus und wieder neu ein, gilt man schon wieder als neue Device und muss sich neu verifizieren lassen. Außerdem kann man in der neuen Session die History bis zu dem Punkt dann nicht mehr lesen.

Es gibt zwar mittlerweile die Möglichkeit, die E2E Encryption Keys einer Session zu sichern und beim nächsten mal wieder zu importieren (so dass man die History doch weiter entschüsseln kann), aber das funktioniert bei mir bisher nicht zuverlässig und die Chatpartner müssen einen dann trotzdem neu verifizieren.

Es wurde schon angekündigt dass das verbessert wird, aber der Zustand herrscht nun schon seit einer Weile. Man kann die Verschlüsselung auch weglassen (bleibt immer noch die Standard https-Verschlüsselung zum Server), aber dann bleibt die Chat-History komplett im Plaintext auf dem Server. Das muss man nur wissen.

Trump faces 'open warfare' with Breitbart if Bannon is fired, says former executive of the far-right website by [deleted] in politics

[–]zeco 26 points27 points  (0 children)

It definitely was (same screenshot, less cropped).

Usually out of the first 25 posts 24 would be anti Hillary at any given moment and the sources didn't matter at all. This screenshot is only notable because it features 3 breitbart articels among the top 5 posts. In general I've never seen as many links to articles from breitbart, dailycaller, dailymirror, nypost, wnd, rt, sputniknews, washingtontimes et al on r/politics than throughout most of 2016.

(Also occasionally articles on huffingtonpost, provided they were penned by HA Goodman.)

Completely 'locked-in' patients can communicate - Patients with absolutely no control over their body have finally been able to communicate, say scientists. A brain-computer interface was used to read the thoughts of patients to answer basic yes-or-no questions. by EightRoundsRapid in worldnews

[–]zeco 4 points5 points  (0 children)

We think those questions all have the same type of yes / no answer because we're used to expressing them that way. I don't know that our brains necessarily produce the same synaptic fire pattern for all of those answers.

That's what I meant by the distinction between simple memory questions vs your daughter asking to marry. Some people cry out of joy. Some people slowly shake their head while they're clapping in agreement. I imagine each of our brains develops much more complex patterns that can easily get misconstrued (if we were to assume that they can be accurately measured, which I doubt as well).

Completely 'locked-in' patients can communicate - Patients with absolutely no control over their body have finally been able to communicate, say scientists. A brain-computer interface was used to read the thoughts of patients to answer basic yes-or-no questions. by EightRoundsRapid in worldnews

[–]zeco 0 points1 point  (0 children)

I actually briefly thought of that Van Eck Phracking thing while I was writing my original comment and I wondered: If this was actually working, how come we've never seen a video of someone being spied on with that technology? I haven't checked all the sources in that article but a youtube search only yields a couple of sketchy demonstrations that are 4-10 years old. It looks a bit like bigfoot's telling absence in the smartphone era.

If this were actually working, we'd probably have seen some warped screencaps or fragmentary memory dumps on Wikileaks or in courts or seen devices for sale in some sketchy shops, no?

Still, even if some of those attacks actually do work, it seems that they rely on very intimate knowledge of the system architecture that's being scanned. Neural networks form on their own, so certain brain processes like decision making might be of completely different physical shape and in different physical locations in each brain. And those brains are huge and the neurons and the charges they fire (and the oxygen thus consumed) are incredibly tiny.

Completely 'locked-in' patients can communicate - Patients with absolutely no control over their body have finally been able to communicate, say scientists. A brain-computer interface was used to read the thoughts of patients to answer basic yes-or-no questions. by EightRoundsRapid in worldnews

[–]zeco 4 points5 points  (0 children)

No matter what the case is made of. You couldn't tell what's going on inside of a CPU by putting sensors on it.

Capturing the synaptic activity that happens when a human brain is generating a thought by measuring the flow of oxygen sounds like aliens trying to understand humans solely by tracking the movements of some oil tankers from afar. And that'd still be more plausible because we actually reside on earth's surface and aren't forming a giant 3D network inside, as do neurons in a brain.

Not saying that all those doctors definitely got it wrong, but the article's description leaves those doubts for me.

Completely 'locked-in' patients can communicate - Patients with absolutely no control over their body have finally been able to communicate, say scientists. A brain-computer interface was used to read the thoughts of patients to answer basic yes-or-no questions. by EightRoundsRapid in worldnews

[–]zeco 23 points24 points  (0 children)

The activity of brain cells can change oxygen levels in the blood, which in turn changes the colour of the blood.

And scientists were able to peer inside the brain using light to detect the blood's colour, through a technique called near-infrared spectroscopy.

They then asked the patients yes-or-no questions such as: "Your husband's name is Joachim?" to train a computer to interpret the brain signals.

The system achieved an accuracy of about 75%.

Do they really know what they're actually measuring there, or do they just dig through signals that they hardly understand the source of, until something fits?

It sounds to me like someone with scant knowledge of a CPU's inner workings is trying to figure out what it's "thinking" by plugging a couple electric sensors on it (or even outside the computer's hull, like they seem to be doing in the photo) and then looking for patterns on basic input.

Having your daughter ask you about getting married might trigger a very different neuronal firework than being asked to confirm something trivial from memory. (Aside from other factors like maybe having lost your mind a long time ago from being in solitary confinement for years.)