News for hackers. Stuff that matters.

rexpan

Re:“I don't know the numbers”: a math puzzle on Monday May 09, 2022 @05:09AM (#31312033)
My SQL Solution (SQL Server)

    -- Create Table #x(v) from 1..99
    WITH x AS (SELECT n FROM (VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) v(n))
    SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS v INTO #x 
    FROM x ones, x tens ORDER BY 1
    ;
    DELETE FROM #x WHERE v > 99
    ;
    -- Create Candidate #c(x, y, s, p) with pair (x,y) (x <= y) and sum `s` and product `p`
    SELECT x.v AS x, y.v AS y, x.v + y.v AS s, x.v \* y.v AS p INTO #c FROM #x x, #x y WHERE x.v <= y.v
    ;
    -- Peter: I don’t know the numbers.
    DELETE FROM #c WHERE p IN (SELECT p FROM (SELECT p, COUNT(*) AS n FROM #c GROUP BY p) AS d WHERE n < 2)
    -- Sandy: I don’t know the numbers.
    DELETE FROM #c WHERE s IN (SELECT s FROM (SELECT s, COUNT(*) AS n FROM #c GROUP BY s) AS d WHERE n < 2)
    -- Peter: I don’t know the numbers.
    DELETE FROM #c WHERE p IN (SELECT p FROM (SELECT p, COUNT(*) AS n FROM #c GROUP BY p) AS d WHERE n < 2)
    -- Sandy: I don’t know the numbers.
    DELETE FROM #c WHERE s IN (SELECT s FROM (SELECT s, COUNT(*) AS n FROM #c GROUP BY s) AS d WHERE n < 2)
    -- Peter: I don’t know the numbers.
    DELETE FROM #c WHERE p IN (SELECT p FROM (SELECT p, COUNT(*) AS n FROM #c GROUP BY p) AS d WHERE n < 2)
    -- Sandy: I don’t know the numbers.
    DELETE FROM #c WHERE s IN (SELECT s FROM (SELECT s, COUNT(*) AS n FROM #c GROUP BY s) AS d WHERE n < 2)
    -- Peter: I don’t know the numbers.
    DELETE FROM #c WHERE p IN (SELECT p FROM (SELECT p, COUNT(*) AS n FROM #c GROUP BY p) AS d WHERE n < 2)
    -- Sandy: I don’t know the numbers.
    DELETE FROM #c WHERE s IN (SELECT s FROM (SELECT s, COUNT(*) AS n FROM #c GROUP BY s) AS d WHERE n < 2)
    -- Peter: I don’t know the numbers.
    DELETE FROM #c WHERE p IN (SELECT p FROM (SELECT p, COUNT(*) AS n FROM #c GROUP BY p) AS d WHERE n < 2)
    -- Sandy: I don’t know the numbers.
    DELETE FROM #c WHERE s IN (SELECT s FROM (SELECT s, COUNT(*) AS n FROM #c GROUP BY s) AS d WHERE n < 2)
    -- Peter: I don’t know the numbers.
    DELETE FROM #c WHERE p IN (SELECT p FROM (SELECT p, COUNT(*) AS n FROM #c GROUP BY p) AS d WHERE n < 2)
    -- Sandy: I don’t know the numbers.
    DELETE FROM #c WHERE s IN (SELECT s FROM (SELECT s, COUNT(*) AS n FROM #c GROUP BY s) AS d WHERE n < 2)
    -- Peter: I don’t know the numbers.
    DELETE FROM #c WHERE p IN (SELECT p FROM (SELECT p, COUNT(*) AS n FROM #c GROUP BY p) AS d WHERE n < 2)
    -- Sandy: I don’t know the numbers.
    DELETE FROM #c WHERE s IN (SELECT s FROM (SELECT s, COUNT(*) AS n FROM #c GROUP BY s) AS d WHERE n < 2)
    -- Peter: I do know the numbers.
    SELECT * FROM #c WHERE p IN (SELECT p FROM (SELECT p, COUNT(*) AS n FROM #c GROUP BY p) AS d WHERE n < 2)
    /*
    x y s p
    77 84 161 6468
    */
Re:Three ways of handling user input on Friday January 14, 2022 @01:01AM (#29931098)
These 3 functions will stop on `await event.xxx` (if not, they will continue to execute or terminate). So when one of the functions is terminate https://github.com/pdubroy/handling-user-input/blob/main/abr...

   await Promise.any(fibers.map((f) => f.run()));
   fibers.forEach((f) => f.terminate());
Abro will reject the promise of these `await event.xxx` https://github.com/pdubroy/handling-user-input/blob/main/abr...

    this._promises.forEach(({ reject }) => reject());
Which will throw an Exception and exit the 2 other functions.
Re:How Does React Tell a Class from a Function? on Monday December 03, 2018 @11:58PM (#18596410)
Yup, it is gatsby. https://github.com/gaearon/overreacted.io

You can use https://overreacted.io/rss.xml for subscription.

Re:Enumerating Trees (2013) on Monday September 17, 2018 @03:29AM (#18003872)
> It maps every tree to a natural number, but not every natural number to a tree.

This is a one-to-one mapping between binary trees and natural numbers.

This encode an n level tree with O(n) bits

Re:SQL Operations Studio on Monday November 20, 2017 @03:36AM (#15738627)
Set

"telemetry.enableTelemetry": false

In Preference > Settings

Re:Visual Studio Code 1.18 on Thursday November 09, 2017 @03:00AM (#15660683)
My favorites:

- `F7`: no more inaccuracy Ctrl+D symbol navigation

- Auto Import

Re:A font to make sparklines in seconds on Thursday September 14, 2017 @11:44AM (#15249135)
Format > Font > Advanced > Use Contextual Alternates

https://github.com/aftertheflood/spark#using-atf-spark-in-ms...

Re:TypeScript 2.3 on Friday April 28, 2017 @04:33AM (#14217835)
React, AngularJS v1, basically everything that more than 100 lines of js code.
I think the current design fine. I mainly work on the desktop and want to gather much things to process. Waiting in the line to try this out.
Re:Learn ECMAScript6 by doing it on Sunday June 21, 2015 @04:18AM (#9752665)
You should try [this](https://chrome.google.com/webstore/detail/high-contrast/djcf...) if you use Chrome.