Turbo87

CREATE OR REPLACE FUNCTION semver_ord(num varchar) RETURNS jsonb AS $$
DECLARE
    max_prerelease_parts constant int := 30;
    match_result text[] := regexp_match(num, '^(\d+).(\d+).(\d+)(?:-([0-9A-Za-z\-.]+))?');
    prerelease jsonb;
    prerelease_part text;
    i int := 0;
BEGIN
    IF match_result[4] IS NULL THEN
        -- A JSONB object has higher precedence than an array and versions without

Turbo87

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

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

Turbo87

-- 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

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

{
  "models": [
    {
      "id": 219,
      "name": "AFH 22",
      "index": 98,
      "type": "glider",
      "weglideId": 283
    },
    {

Turbo87

Aldi LED Panel

Tastenwiederholung

[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

Turbo87

Turbo87

Empty tarballs

• /se/rv/servo/servo-0.0.1.crate

cargo.toml (lowercase)

• /3/q/qmu/qmu-0.1.0.crate
• /3/q/qrl/qrl-0.1.0.crate
• /3/r/rpc/rpc-0.0.1-dev.1.crate
• /an/im/animality/animality-0.1.0.crate

Turbo87

aahing
aahs
aal
aah
aahed
aam
aardvarks
aardwolf
aaronic
aaronite