[20:21:00][I][remote.pronto:237]: Received Pronto: data=0000 006D 0002 0000 015D 0056 0017 0181 06C3
[20:21:00][I][remote.pronto:237]: Received Pronto: data=0000 006D 0002 0000 015D 0056 0017 0181 06C3
[20:21:00][I][remote.pronto:237]: Received Pronto: data=0000 006D 0002 0000 015D 0056 0017 0181 06C3
Tobias Bieniek Turbo87
Turbo87
/ links-backfill-jobs.sql
Created
June 28, 2024 07:37
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| INSERT INTO background_jobs (job_type, data) | |
| VALUES | |
| ('sync_to_git_index', '{"krate": "CoreFoundation-sys"}'::jsonb), | |
| ('sync_to_sparse_index', '{"krate": "CoreFoundation-sys"}'::jsonb), | |
| ('sync_to_git_index', '{"krate": "IOKit-sys"}'::jsonb), | |
| ('sync_to_sparse_index', '{"krate": "IOKit-sys"}'::jsonb), | |
| ('sync_to_git_index', '{"krate": "accelerate-src"}'::jsonb), | |
| ('sync_to_sparse_index', '{"krate": "accelerate-src"}'::jsonb), | |
| ('sync_to_git_index', '{"krate": "advapi32-sys"}'::jsonb), | |
| ('sync_to_sparse_index', '{"krate": "advapi32-sys"}'::jsonb), |
Turbo87
/ links-backfill.sql
Created
June 27, 2024 08:47
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| UPDATE versions SET links = 'CoreFoundation' WHERE id = 11136; -- CoreFoundation-sys 0.1.0 | |
| UPDATE versions SET links = 'CoreFoundation' WHERE id = 14768; -- CoreFoundation-sys 0.1.1 | |
| UPDATE versions SET links = 'CoreFoundation' WHERE id = 16877; -- CoreFoundation-sys 0.1.2 | |
| UPDATE versions SET links = 'CoreFoundation' WHERE id = 17646; -- CoreFoundation-sys 0.1.3 | |
| UPDATE versions SET links = 'CoreFoundation' WHERE id = 71134; -- CoreFoundation-sys 0.1.4 | |
| UPDATE versions SET links = 'IOKit' WHERE id = 11300; -- IOKit-sys 0.1.0 | |
| UPDATE versions SET links = 'IOKit' WHERE id = 11362; -- IOKit-sys 0.1.1 | |
| UPDATE versions SET links = 'IOKit' WHERE id = 16878; -- IOKit-sys 0.1.2 | |
| UPDATE versions SET links = 'IOKit' WHERE id = 17647; -- IOKit-sys 0.1.3 | |
| UPDATE versions SET links = 'IOKit' WHERE id = 28038; -- IOKit-sys 0.1.4 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- from https://github.com/ioguix/pgsql-bloat-estimation/blob/8fde3c9e0e015ece51e10c1450228d23f7747db1/table/table_bloat.sql | |
| SELECT tblname, bs*tblpages AS real_size, | |
| (tblpages-est_tblpages)*bs AS extra_size, | |
| CASE WHEN tblpages > 0 AND tblpages - est_tblpages > 0 | |
| THEN 100 * (tblpages - est_tblpages)/tblpages::float | |
| ELSE 0 | |
| END AS extra_pct, fillfactor, | |
| CASE WHEN tblpages - est_tblpages_ff > 0 | |
| THEN (tblpages-est_tblpages_ff)*bs |
Turbo87
/ save_downloads.rs
Created
January 26, 2024 17:41
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| use anyhow::Context; | |
| use chrono::NaiveDate; | |
| use crates_io_cdn_logs::DownloadsMap; | |
| use diesel::prelude::*; | |
| use diesel::PgConnection; | |
| table! { | |
| temp_downloads (name, version, date) { | |
| name -> Text, | |
| version -> Text, |
Turbo87
/ skylines-aircraft.json
Last active
December 26, 2023 11:56
SkyLines aircraft list with WeGlide IDs
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "models": [ | |
| { | |
| "id": 219, | |
| "name": "AFH 22", | |
| "index": 98, | |
| "type": "glider", | |
| "weglideId": 283 | |
| }, | |
| { |
Turbo87
/ num_features.csv
Last active
October 11, 2023 16:18
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name | num | num_features | |
|---|---|---|---|
| leptos_icons | 0.0.11 | 21966 | |
| icondata | 0.0.5 | 21961 | |
| icondata | 0.0.7 | 21961 | |
| icondata | 0.0.4 | 21961 | |
| icondata | 0.0.6 | 21961 | |
| icondata | 0.0.1 | 21960 | |
| icondata | 0.0.2 | 21960 | |
| icondata | 0.0.3 | 21960 | |
| leptos_icons | 0.0.16-alpha | 21944 |
Turbo87
/ crate-files-with-missing-manifest.md
Last active
August 28, 2023 14:10
Turbo87
/ squatted-crates.csv
Created
July 3, 2023 11:21
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| aahing | |
| aahs | |
| aal | |
| aah | |
| aahed | |
| aam | |
| aardvarks | |
| aardwolf | |
| aaronic | |
| aaronite |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ID | CALL | CN | TYPE | |
|---|---|---|---|---|
| 06DD517F | UKE | |||
| 06DDABCD | J1 | |||
| 06DD51AD | AJ | |||
| 06DDB6E5 | KW | |||
| 06DDEE58 | BI | |||
| D01038 | BM | |||
| 06D0017F | V57 | |||
| 06DDB6FB | MF | |||
| 86DDF05C | SC |
NewerOlder