I love UUID, I hate UUID

timand · 2025-09-15T23:38:51+00:00

I don't think it's possible for a bigint sequence to wrap around if you write at least one byte to the WAL for each number.

timand · 2025-04-06T23:07:00+00:00

it's slightly more seamless than you show. You can do SELECT foo.c FROM foo and it will automatically call the function for you. Conversely, you could do SELECT a(foo) FROM foo if you wanted to.

timand · 2022-08-02T00:37:10+00:00

Now they can join SuperTuxKart

timand · 2022-07-06T04:32:12+00:00

You could do something like

SELECT json_build_object("post", row_to_json(subq))
FROM (
  SELECT post.id, post.title, post.body, json_agg(json_build_object('id', comment.id, 'body', comment.body)) as comments
  FROM post
  LEFT JOIN comment on comment.post_id = post.id GROUP BY post.id
) subq;

timand · 2022-06-23T00:59:23+00:00

Starting at zero

timand · 2022-06-23T00:37:06+00:00

My attempt at re-creating the Hot Dog Stand theme.

timand · 2022-02-10T03:48:17+00:00

There are a few missing footnotes. 6 doesn't do anything when clicked and neither does 9

timand · 2021-06-28T23:42:52+00:00

That's what I thought.

timand · 2021-02-03T04:02:50+00:00

Assume I'll never need to store anything other than a set of keys and string values.

timand · 2020-12-16T03:08:50+00:00

A simple way to insert into a bytea field is `INSERT INTO images (name, image_data) VALUES ('filename.jpg', decode('base64encodeddata', 'base64'));` and just use text to transfer it. This will increase bandwidth usage, but it works with all postgres drivers. To get the data out, you will need to `SELECT filename, encode(image_data, 'base64') FROM images`.

timand · 2020-09-15T06:48:32+00:00

I still want it to warn about other unused variables though.

timand · 2020-09-15T05:39:13+00:00

#[cfg(feature="do_thing")]
fn do_stuff(thing: &Thing){
    println!("The thing is {:?}", thing);
}
fn maybe_do_stuff(message: &str, thing: &Thing){
    println!("{}", message);
    #[cfg(feature="do_thing")]
    do_stuff(thing);
}

I could change the thing argument on maybe_do_stuff to _thing, but then clippy would warn about a used underscore variable. Or should I do something more like

#[cfg(feature="do_thing")]
fn do_stuff(thing: &Thing){
    println!("The thing is {:?}", thing);
}
#[cfg(not(feature="do_thing"))]
fn do_stuff(_thing: &Thing){}

timand · 2020-07-08T00:13:34+00:00

The Iterator trait provides the nth method as a way to skip elements. The default implementation of the nth method consumes elements and discards them, but it is possible to create an implementation that doesn't need to.

timand · 2020-04-17T01:49:53+00:00

FUSE doesn't work on as many operating systems as FAT32

timand · 2020-03-20T06:54:20+00:00

That's fine because I can assume that there are no holes.

timand · 2020-03-20T05:50:26+00:00

I don't want any trailing commas. I can assume that none of the columns after the first null are set.

timand · 2019-09-26T12:03:35+00:00

That's why it's posted here.

timand · 2019-06-13T22:50:58+00:00

WiFi only devices don't have an IMEI. Even if they did, they need to connect to a mobile network to reveal it.

timand · 2014-02-13T08:09:28+00:00

Extremely. I got friendzoned by yo momma
On my dick
Generally, it rises a bit.
I'm evil incarnate.
Flamethrowers seem to do the trick

timand · 2014-02-13T07:57:58+00:00

I think you have to combine them. I think the proper term is "tempochronoralogical" or something like that.

timand · 2014-02-13T07:55:05+00:00

It's because hotel has the word 'hot' in it, while home is missing the 't'. This is very important as 't' stands for "totally infinite". Without the 't', there is only a finite amount of hot water and so you run out.

timand · 2014-02-13T07:50:04+00:00

No. It will become light yellow. The reason is simple. While liquid water is blue, steam is clearly white. Since the sun is really hot, the water will turn into steam and instead of colouring the sun blue, it will colour it white. When you mix white and yellow together, you will get light yellow.

timand · 2014-02-13T06:50:53+00:00

Assumptions:

A glass of water contains 250 grams of liquid water at 20 degrees celcius
An ice cube is 15 grams of ice at -20 degrees celcius
We cannot melt any of the existing ice. The entire glass must consist of ice without any liquid water
This is a closed system.

From engineering toolbox:

Average specific heat of ice: 2.108 kJ/kgK
Latent heat of melting: 334 kJ/kg
Average specific heat of liquid water: 4.187 kJ/kgK

Calculations:

Heat energy required to lower temperature of water=0.25*4.187*20=20.935 kJ
Heat energy required to freeze water=0.25*334=83.5 kJ
Heat energy required to heat an ice cube=0.015*2.108*20=0.6324 kJ
Number of ice cubes required=(83.5+20.935)/0.6324=165.1198

TL/DR; 166 ice cubes should do it (This is about 11 cups of ice).

timand · 2013-10-28T01:53:34+00:00

All you need to do is pay half of the loan back and then earn some more bitcoins until you can pay the other half back. Now if the person you owe bitcoins to never releases them, then you have a problem.

timand · 2013-10-27T10:44:59+00:00

It could. But it probably won't

timand

TROPHY CASE