Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Congratulations on creating the one billionth repository on GitHub

github.com

Post reply on HN
Print view View original

141–146 of 146 posts

Re: Congratulations on creating the one billionth repository on GitHub

#141

Post by hobs »

rudasn wrote: post #56
hobs wrote: post #53

Earlier quoted context omitted.

heh, that's happened at at least 5 companies I have worked at - go to check the database, find - currency as floats, hilarious indexes, integers gonna overflow, gigantic types with nothing in them.

I bet you haven't seen indeces on decimals though! Fun times :)

They'd certainly need decimals in the first place, but yeah I have seen indexes on every column, multiple times, I have seen indexes such that the sum of their size are 26 times the size of the original data... that's actively being written to.

Re: Congratulations on creating the one billionth repository on GitHub

#142

Post by robertlagrant »

gkalin59 wrote: post #132
robertlagrant wrote: post #125

Earlier quoted context omitted.

I don't really understand this - what is an out of production read replica? Why wouldn't it just go to a production read replica? And what is an "analytics db" in this context?

You stream CDC events to have a 1 to 1 read replica in something like Snowflake/Databricks where you can run all kinds of OLAP workflows on this analytics db replica.

Oh, sure, but wouldn't the whole website be served out of a read-friendly database? Why would you have a separate "analytics" database to the main database(s) driving the site?

Re: Congratulations on creating the one billionth repository on GitHub

#143

Post by eadmund »

ipaddr wrote: post #140
robertlagrant wrote: post #124

Earlier quoted context omitted.

Well done. Unsung heroes keeping it all going, and unsung villains who chose int32 in the first place long gone :-)

This comment can be reused when int64 is forced to change into int128 or int255 in the future.

Just use bignums. Seriously, a decent type system can use smaller representations for efficiency and not accidentally break the world.

That way, one can represent the numbers found in cryptography as … numbers, instead of opaque Base64- or (God help one) ASN.1-encoded byte sequences.

Machine words are an efficiency hack.

Re: Congratulations on creating the one billionth repository on GitHub

#144

Post by sebastiennight »

90s_dev wrote: post #129
sebastiennight wrote: post #121

Earlier quoted context omitted.

Do you mean a specific quote here? I couldn't find the reference.

The answer to that question is in the eye of the beholder or something idk

I'd have thought Diogene's moat was mostly personal-fragrance-based

Re: Congratulations on creating the one billionth repository on GitHub

#145

Post by ramon156 »

CGamesPlay wrote: post #71

Probably created via a script that just repeatedly checked https://api.github.com/repositories/999999999 until it showed up, and then created a new repository. Since repositories can be modified, could have even given it some buffer and created a bunch of repos, just delete the ones that don't get the right number. [append] Looking at the author's other repo created yesterday, I'm betting "yep" was supposed to be the…

Empty repo, so yes

Re: Congratulations on creating the one billionth repository on GitHub

#146

Post by erulabs »

robertlagrant wrote: post #125
erulabs wrote: post #120

Earlier quoted context omitted.

Cheap solution, sure, add an index. But you're asking an OLAP question question of an OLTP system. Questions like that are best asked at least of an out-of-production read replica or better an analytics db.

I don't really understand this - what is an out of production read replica? Why wouldn't it just go to a production read replica? And what is an "analytics db" in this context?

In general just avoiding mixed types of load. Predictable, audited application queries in a user request shouldn’t be mixed with potentially extremely expensive long running analytics queries. Different replica sets isolates customers from potential performance impacts caused by data analytics.
Post reply on HN