colinchartier

Postgres can be tuned to 10k inserts per second, Kafka is definitely overkill for 200/s

Reminds me of this video about the origin of the name Tiffany: https://m.youtube.com/watch?v=9LMr5XTgeyI

"I didn't fly across the Atlantic to... Of course I did"

colinchartier

3 年前議論

Reminds me of the ghost Unicode character saga: https://www.dampfkraft.com/ghost-characters.html

colinchartier

3 年前議論

Nested virt doesn't work with some things like OS snapshot/restore, so they might not support it to allow those features.

colinchartier

3 年前議論

We got around this at my company by just pooling all of the LISTEN/NOTIFY streams into a single database connection in software, here's a sample implementation:

function software_listen(channel, callback):

  if not channel_listened(channel):

    sql("LISTEN " + channel)

  listeners[channel].append(callback)

function on_message(channel, data):

  for listener in listeners[channel]

    listener(channel, data)

function unlisten(channel, listener):

  listeners[channel].remove(listener)

  if len(listeners[channel]) == 0:

    sql("UNLISTEN " + channel)

Here's the actual go implementation we use:

https://gist.github.com/ColinChartier/59633c1006407478168b52...

colinchartier

3 年前議論

As far as I understand, that's 100 shared queries across all users.

colinchartier

3 年前議論

Paul Graham would say for exponential growth, 10x better is the bar

colinchartier

投稿

Show HN: GPT4 Powered Multiplayer Jeopardy

コメント