Skip to content

Instantly share code, notes, and snippets.

Avatar

Jannis R derhuerst

678 followers · 92 following
View GitHub Profile
@derhuerst
derhuerst / _.md
Created September 19, 2023 10:08
EC 171 from Berlin Hbf to Praha hl.n.
View _.md

The was no delay.

@derhuerst
derhuerst / 01-tripsearch.http
Created September 3, 2023 11:22
DB Navigator v23.08.01 on iOS: HTTP requests
View 01-tripsearch.http
POST /bin/mgate.exe?checksum=91746988ad3df7292ecb95c35eb65875 HTTP/1.1
Host: reiseauskunft.bahn.de
Content-Type: application/json
Accept-Encoding: gzip, deflate, br
Cookie: AWSALB=UwdJtOV5ejYzrkWNGhXoqr9bBtrjNg4laLKECYpK4EqNrhbqCS2TQ1Ep/4phJrpoYim+m4EZBhcRyLr3GJdwTvAtH6iaTd1ifIK35Zyl22TEledn3mlBvZL5nfPE; AWSALBCORS=UwdJtOV5ejYzrkWNGhXoqr9bBtrjNg4laLKECYpK4EqNrhbqCS2TQ1Ep/4phJrpoYim+m4EZBhcRyLr3GJdwTvAtH6iaTd1ifIK35Zyl22TEledn3mlBvZL5nfPE; utag_main=v_id:0188b53b978a1219ed98086fb4d81506d003706500432$_sn:20$_se:3$_ss:0$_st:1693740651409$ses_id:1693738846547%3Bexp-session$_pn:1%3Bexp-session; request_consent_v=3; s_vi=[CS]v1|0B4B7D97B8374B8C-2FFCABEBD7E2A777[CE]; AMCV_5FA50A5953FB37E50A4C98BC%40AdobeOrg=-408604571%7CMCAID%7C0B4B7D97B8374B8C-2FFCABEBD7E2A887%7CMCIDTS%7C19537%7CMCMID%7C17007382676835350149043660885083312138%7CvVersion%7C4.6.0; optimizelyEndUserId=0A9887D8-3427-4557-862B-3697EC8CA833
Connection: keep-alive
Accept: */*
User-Agent: DB Navigator/23.08.01 (iPhone; iOS 16.6; Scale/2.00)
Accept-Language:
@derhuerst
derhuerst / from-hafas-1.json
Created July 26, 2023 22:30
ICE 500 from Bamberg to Berlin Hbf
View from-hafas-1.json
{
"trip": {
"origin": {
"type": "stop",
"id": "8000261",
"name": "München Hbf",
"location": {
"type": "location",
"id": "8000261",
"latitude": 48.140364,
@derhuerst
derhuerst / ice-2923.ndjson
Created July 23, 2023 22:49
ICE 2923 from Büchen to Berlin Hbf
View ice-2923.ndjson
{"serviceLevel":"AVAILABLE_SERVICE","internet":"HIGH","latitude":53.451945333333335,"longitude":10.6620965,"tileY":383,"tileX":75,"series":"412","serverTime":1690102052404,"speed":149,"trainType":"ICE","tzn":"ICE9483","wagonClass":"FIRST","connectivity":{"currentState":"NO_INFO","nextState":null,"remainingTimeSeconds":null},"bapInstalled":true,"ok":true,"gpsOk":true,"clientTime":1690102052274}
{"serviceLevel":"AVAILABLE_SERVICE","internet":"HIGH","latitude":53.45029683333333,"longitude":10.664028833333333,"tileY":383,"tileX":75,"series":"412","serverTime":1690102057366,"speed":152,"trainType":"ICE","tzn":"ICE9483","wagonClass":"FIRST","connectivity":{"currentState":"NO_INFO","nextState":null,"remainingTimeSeconds":null},"bapInstalled":true,"ok":true,"gpsOk":true,"clientTime":1690102057275}
{"serviceLevel":"AVAILABLE_SERVICE","internet":"HIGH","latitude":53.448666833333334,"longitude":10.665933,"tileY":383,"tileX":76,"series":"412","serverTime":1690102062360,"speed":156,"trainType":"ICE","tzn":"ICE9483","wagon
@derhuerst
derhuerst / _.md
Created July 11, 2023 15:43
convert results of multiple pgbench invocations to CSV
View _.md
  • slightly opinionated (column selection)
  • could be made more configurable, e.g. (let $BENCHMARK_TIME_SECONDS pick up from env var)
  • uses Miller (mlr)
  • uses qsv, a fork of xsv
@derhuerst
derhuerst / 00-analytics.http
Last active July 5, 2023 18:23
Flixbus iOS app requests
View 00-analytics.http
POST https://cujo-collector.flux.flixbus.com/com.snowplowanalytics.snowplow/tp2 HTTP/2.0
cookie: sp=90326e70-6de2-450f-bc24-6a1f944fb28e
accept: text/html, application/x-www-form-urlencoded, text/plain, image/gif
content-type: application/json; charset=utf-8
user-agent: flixapp/3 CFNetwork/1408.0.4 Darwin/22.5.0
accept-language: en-GB,en;q=0.9
content-length: 2974
accept-encoding: gzip, deflate, br
{
@derhuerst
derhuerst / from-hafas.json
Created June 24, 2023 19:04
ICE 278 from Karlsruhe Hbf to Frankfurt Hbf
View from-hafas.json
{
"trip": {
"origin": {
"type": "stop",
"id": "8507492",
"name": "Interlaken Ost",
"location": {
"type": "location",
"id": "8507492",
"latitude": 46.690502,
@derhuerst
derhuerst / from-hafas.json
Last active June 24, 2023 12:04
TGV 9593 from Paris Est to Karlsruhe Hbf
View from-hafas.json
{
"trip": {
"origin": {
"type": "stop",
"id": "8700011",
"name": "Paris Est",
"location": {
"type": "location",
"id": "8700011",
"latitude": 48.876976,
@derhuerst
derhuerst / from-hafas.json
Last active June 24, 2023 09:22
TGV 9592 from Karlsruhe Hbf to Paris Est
View from-hafas.json
{
"trip": {
"origin": {
"type": "stop",
"id": "8000096",
"name": "Stuttgart Hbf",
"location": {
"type": "location",
"id": "8000096",
"latitude": 48.785052,
@derhuerst
derhuerst / from-hafas.json
Last active June 24, 2023 09:16
TGV 8404 from Bordeaux to Paris Montparnasse
View from-hafas.json
{
"trip": {
"id": "1|1032621|0|80|24062023",
"origin": {
"type": "stop",
"id": "8700047",
"name": "Bordeaux-St-Jean",
"location": {
"type": "location",
"id": "8700047",