« first day (3409 days earlier)      last day (38 days later) » 

12:10 AM
0
A: Sandbox for Proposed Challenges

Λ̸̸The furthest string code-golf string Quoting Anush: I am very glad to provide a service to fill in the terrible gap in edit distance questions which codegolf.se has had. When there are as many edit distance questions as quine questions my job will be done. -- Anush Task This question is ...

0
A: Sandbox for Proposed Challenges

Λ̸̸Single-byte typo code-golf string Quoting Anush: I am very glad to provide a service to fill in the terrible gap in edit distance questions which codegolf.se has had. When there are as many edit distance questions as quine questions my job will be done. -- Anush Task Given a string consi...

 
@Arnauld I see. Thanks!
Oh and congrats on 100k, @Neil!
3
 
12:32 AM
Congrats!
 
1:09 AM
1
Q: Zero the byte (eventually)

Λ̸̸Given an infinite arithmetically-progressive¹ sequence, compute the minimum length of a prefix with a product divisible by 2^8. Sample cases & reference implementation Here is a reference implementation that I wrote in Io. 1, 1 -> 10 2, 4 -> 8 3, 5 -> 10 2, 6 -> 5 7, 5 -> 6 4, 1 ->...

 
1:33 AM
3
Q: Compute xkcd's Wrong Times Table

Aaron RotenbergThe 2020-05-29 xkcd comic showed us the numbers that Randall Munroe feels would be most likely to result from multiplication, other than the correct answers. The table does seem to have some sort of twisted logic to it. For your convenience, the Wrong Times Table is reproduced here in selectable...

 
 
16 hours later…
5:34 PM
0
Q: Your code has an uncanny mirror twin…

darrylyeoWrite two programs, each taking a string s and a number n ≥ 0, such that: The first program prints s n times, separated by newlines. The second program prints each character of s n times, with repeated characters separated by newlines. Every character at column x, line y in one program equals t...

 
 
6 hours later…
11:13 PM
3
Q: An alternative to querying with multiple JOIN over the same table?

Darth KangoorooI have a Postgresql 11 database. Let's say I have a table called houses. It should have hundreds of thousands of records. CREATE TABLE houses ( pkid serial primary key, address varchar(255) NOT NULL, rent float NOT NULL ); Now, my houses have features I want to register in the database. ...

I compared three queries
on a table with 100,000,000 rows of random values
one answer suggests group by and where, this took 2.5 minutes
the question joins three subselects, this took 1.5 hours
I also tried a simple join with where, this took so long that VirtualBox crashed my pc before it could finish, I think it had been running for 5 days
 

« first day (3409 days earlier)      last day (38 days later) »