Hacker News: cribwi

New comment by cribwi in "1k Photos of Dolphin Fins"

cribwi — Tue, 11 Apr 2023 07:15:28 +0000

A similar research is done for humpback whales by HappyWhale: https://happywhale.com/ They're doing a great effort with already over 600K user/tourist submitted photos of whale encounters to track individual whales over the globe

New comment by cribwi in "PostgreSQL views and materialized views and how they influenced TimescaleDB"

cribwi — Fri, 15 Jul 2022 14:52:36 +0000

Great approach and good write-up! I’ve implemented a similar technique before on PostgreSQL, but with the materialisation in the application backend. Still works like a charm.

>So instead, we created a special kind of trigger that tracks the minimum and maximum times modified across all the rows in a statement and writes out the range of times that were modified to a log table. We call that an invalidation log.

Does this invalidation log also take into account cases where the view has an aggregate that is based on data from a bucket other than itself? For example, a lag() or lead() might be used to calculate a delta compared to the previous bucket. Then, if a data point inside bucket 1 is added into the realtime table and bucket 1 is invalidated and re-materialised, for integrity reasons also bucket 2 needs to be re-materialised?

New comment by cribwi in "PRQL – A proposal for a better SQL"

cribwi — Tue, 25 Jan 2022 07:59:07 +0000

In some cases for removing repeating (intermediate) calculations, I generally find it easier to use a lateral join (in postgres), like

    select
        title,
        country,
        avg(salary)         as average_salary,
        sum(salary)         as sum_salary,
        avg(gross_salary)   as average_gross_salary,
        sum(gross_salary)   as sum_gross_salary,
        avg(gross_cost)     as average_gross_cost,
        sum(gross_cost)     as sum_gross_cost,
        count(*)            as emp_count
    from
        employees,
        lateral ( select
            (salary + payroll_tax)                   as gross_salary,
            (salary + payroll_tax + healthcare_cost) as gross_cost
        ) employee_ext
    where
        country = 'usa'
        and gross_cost > 0
    group by  title, country
    having    count(*) > 200
    order by  sum_gross_cost
    limit 3;

New comment by cribwi in "How to create a 1M record table with a single query"

cribwi — Wed, 24 Mar 2021 08:03:01 +0000

If you're running PostgreSQL, you can use the built-in generate_series (1) function like:

  SELECT id, random()
  FROM generate_series(0, 1000000) g (id);

There seems to be an equivalent in SQLite: https://sqlite.org/series.html

[1] https://www.postgresql.org/docs/current/functions-srf.html

New comment by cribwi in "Why is it so hard to see code from 5 minutes ago?"

cribwi — Fri, 19 Feb 2021 10:07:45 +0000

You can assign a custom shortcut to it via Settings > Keymap and then the action "Main Menu > File > Local History". I myself have assigned the shortcut control+shift+=

An automatic pool playing robot

cribwi — Tue, 16 Feb 2021 17:05:03 +0000

Article URL: https://www.youtube.com/watch?v=vsTTXYxydOE

Comments URL: https://news.ycombinator.com/item?id=26156047

Points: 2

# Comments: 0

New comment by cribwi in "Dependency"

cribwi — Tue, 18 Aug 2020 06:57:20 +0000

Try using https://m.xkcd.com/ and click the comic to toggle the alt text

The Mexican Fisherman

cribwi — Tue, 24 Dec 2019 09:16:31 +0000

Article URL: https://bemorewithless.com/the-story-of-the-mexican-fisherman/

Comments URL: https://news.ycombinator.com/item?id=21870851

Points: 1

# Comments: 0

Wikipedia's JavaScript Initialisation on a Budget

cribwi — Fri, 20 Sep 2019 09:00:25 +0000

Article URL: https://phabricator.wikimedia.org/phame/post/view/175/wikipedia_s_javascript_initialisation_on_a_budget/

Comments URL: https://news.ycombinator.com/item?id=21024588

Points: 1

# Comments: 0

New comment by cribwi in "The Lottery Hackers"

cribwi — Sun, 04 Mar 2018 22:22:47 +0000

I know that specific story from the book "How not to be wrong", by Jordan Ellenberg. It was nice to read it from a different angle in this article

Builder Pattern in Scala with Phantom Types

cribwi — Sat, 16 Sep 2017 10:05:23 +0000

Article URL: https://medium.com/@maximilianofelice/builder-pattern-in-scala-with-phantom-types-3e29a167e863

Comments URL: https://news.ycombinator.com/item?id=15263892

Points: 1

# Comments: 0

Computational Zoom: A Framework for Post-Capture Image Composition

cribwi — Tue, 01 Aug 2017 20:20:40 +0000

Article URL: http://cvc.ucsb.edu/graphics/Papers/SIGGRAPH2017_ComputationalZoom/

Comments URL: https://news.ycombinator.com/item?id=14904915

Points: 1

# Comments: 0

Pev: Postgres EXPLAIN Visualizer

cribwi — Tue, 11 Jul 2017 20:08:32 +0000

Article URL: http://tatiyants.com/pev/#/plans/new

Comments URL: https://news.ycombinator.com/item?id=14747574

Points: 4

# Comments: 0

$PHP = dead;

cribwi — Tue, 11 Apr 2017 08:48:12 +0000

Article URL: https://medium.com/fuzz/php-a0d0b1d365d8

Comments URL: https://news.ycombinator.com/item?id=14085925

Points: 3

# Comments: 0

What is the value of code review anyway?

cribwi — Tue, 20 Jan 2015 07:20:18 +0000

Article URL: http://blog.phacility.com/post/what_is_the_value_of_code_review_anyway/

Comments URL: https://news.ycombinator.com/item?id=8915810

Points: 1

# Comments: 0

New comment by cribwi in "Spotify Engineering Culture – Part 2"

cribwi — Mon, 01 Dec 2014 19:56:24 +0000

Part 1: https://news.ycombinator.com/item?id=7654439 http://vimeo.com/85490944

Spotify Engineering Culture – Part 2

cribwi — Mon, 01 Dec 2014 19:55:18 +0000

Article URL: http://vimeo.com/94950270

Comments URL: https://news.ycombinator.com/item?id=8683309

Points: 2

# Comments: 1

New comment by cribwi in "Phabricator, Wikimedia’s new collaboration platform"

cribwi — Tue, 25 Nov 2014 07:20:19 +0000

Since it has been broken some time ago: no. But when it was still working: yes, I found it rather useful. Especially with very small commits/bugfixes and such. I hope they'll fix it soon

New comment by cribwi in "Phabricator, Wikimedia’s new collaboration platform"

cribwi — Mon, 24 Nov 2014 22:15:24 +0000

I've been using Phabricator for almost a year now in our company. At first, I also had my questions about the workflow with arcanist (the local PHP cli software to interact with Phabricator). However, right now I really love it and miss it on every repository which works without Phabricator. Commands like 'arc feature', 'arc tasks' and 'arc inlines' provide a solid abstraction over the repository to bring the workflow to the cli.

About the unit tests: indeed, out-of-the-box Phabricator only supports running them locally (you can configure the unit engine to run every time a piece of code is been send into review). Luckily, it's not that hard to hook into the event engine (https://secure.phabricator.com/book/phabricator/article/even...) to, for example, trigger your CI-server to run the test suite for a specific revision. Also, Phabricator is still being developed actively. There are a bunch of alpha and beta applications which will only make it more powerful (for example: DryDock and Harbormaster, which will ease the work for automatic builds: http://www.guywarner.com/2014/05/integrating-jenkins-and-pha...)

In my opinion, Phabricator is one of the most powerful tools around for doing code reviews and effective collaboration management. Even with the large amount of beta applications (which are promising in many cases) the decision for us was easy to make.

PostgreSQL vs. MS SQL

cribwi — Sun, 16 Nov 2014 20:30:28 +0000

Article URL: http://www.pg-versus-ms.com

Comments URL: https://news.ycombinator.com/item?id=8615320

Points: 142

# Comments: 103