netcraft

19 ms·

211.
by netcraft 5y ago
I very well may be wrong about this, but I believe thats not exactly true. Parker required the fasted launch as of its time because it had to shed the momentum of the earth that it started with to be able to fall into that gravity well. quo
212.
by netcraft 5y ago
The formal name for this is the https://en.wikipedia.org/wiki/Interstellar_travel#Wait_calcu...
213.
by netcraft 5y ago
I was just talking about this the other day, its formal name is called the Wait Calculation https://en.wikipedia.org/wiki/Interstellar_travel#Wait_calcu...
214.
by netcraft 5y ago
Location: TN, USA (US/Central) Remote: Yes (Only) Willing to relocate: No Technologies: Strong SQL experience, JS/TS, Docker, AWS Résumé/CV: https://ryanguill.com/resume/ Email: ryanguill+hn
215.
by netcraft 5y ago
relevant comment from the author on the other graphql for pg thread today: https://news.ycombinator.com/item?id=29432666
216.
by netcraft 5y ago
No, and I didnt brine either. I cooked three turkeys sous-vide (which is a terrible name) at 147F - 150F for a few hours and they came out perfectly tender and juicy. even after multiple reheats. The downside is that the fat and skin doesnt
217.
by netcraft 5y ago
I'm starting to think Hadden had the right idea - "why build one when you can build two at twice the price"
218.
by netcraft 5y ago
I sort of expect that nothing can be assumed when talking about strings and characters anymore. Waiting for the post on HN one day that says that its in the unicode spec that characters can animate or be in superposition until observed…
219.
by netcraft 5y ago
In my experience the difficulty and time requirements ramp up considerably after about day 10. I think that plus the fact that its Christmas time makes it hard to complete the whole thing - I would even wager that some significant fraction
220.
by netcraft 5y ago
I dont mean to take away anything from your post - but wanted to mention that the parker solar probe has now beat new horizons for fastest man made object (if you don’t count the manhole cover :) )
221.
by netcraft 5y ago
There are two main ways we detect exoplanets. The primary way that I believe accounts for the vast majority of planets we have detected is the transit method. Basically we watch the light from a star very closely and look for a dip in the a
222.
by netcraft 5y ago
I replied to a sister comment similarly, but the one resource that we are severely limited by is time. There were events that were far more common in the early universe that we may never see now. Rare things could happen at any time. The re
223.
by netcraft 5y ago
I totally understand this from a rational standpoint, but if you take that to its logical conclusion, you expect that nothing will happen in that year that is very interesting or rare, so why look at all? Sure, our timescales are nothing, m
224.
by netcraft 5y ago
Thanks for the info! I expected it was something like this, that you expect the increased sensitivity is worth it. I just wish we had more observatories running in different sensitivities - we've just got to get the cost down, thats al
225.
by netcraft 5y ago
the Gravitational Observatories are so impressive to me - I can remember reading about them being theoretical well before LIGO ever started construction, and the fact that theyre here and working just like we expected is so amazing. I can&#
226.
by netcraft 5y ago
I'll stop short of giving a recommendation or using the word "should", but ill give encouragement to consider using uuid's for keys. I have used them in several systems and have never had any issues with them, and they s
227.
by netcraft 5y ago
Great article, always learn a lot from this author. Here is another way I have used to do pivot tables / crosstab in postgres where you have a variable number of columns in the output: https://gist.github.com/ryanguill&
228.
by netcraft 5y ago
I replied to a sister comment with an example. HSTORE can take a whole row and turn it into an HSTORE value, plus HSTORE has an operator of `-` that will diff two HSTORE values. So combine that with the OLD and NEW that you get in the trigg
229.
by netcraft 5y ago
``` , SUBSTRING(TG_OP, 1, 1) -- this gets you I,D,U, or T for truncate , HSTORE(oldData.*) - HSTORE(newData.*) , HSTORE(newData.*) - HSTORE(oldData.*) ``` this is basically what we do, getting the old and new of only what chan
230.
by netcraft 5y ago
So we do something similar, using HSTORE to diff the old and new records, which then allows us to easily tell what was changed in the case of an update. Useful for many kinds of things, but especially forensics.
231.
by netcraft 5y ago
What I would like to see in posts like this is a description of the kinds of programs the author thinks are great candidates for this language over others, maybe with an acknowledgement of the other options and a comparison of why (in this
232.
by netcraft 5y ago
Postgres 13 was released 2020-09-24 13.1 was released 2020-11-12 13.2 was released 2021-02-11 https://www.postgresql.org/docs/13/release-13-2.html AWS supported 13 as of 2021-02-24 https://aws.amazon.co
233.
by netcraft 5y ago
dont quote me on this, but I think it used to be quite a while, but since 12 things have gotten a lot better. I think they generally wait for the .1 patch and then get it in pretty quick.
234.
by netcraft 5y ago
And now the wait for RDS to support it. Thanks PG team!
235.
by netcraft 5y ago
thank you! I knew some of that but learned a lot too.
236.
by netcraft 5y ago
I don't understand your comment - could you expand on it?
237.
by netcraft 5y ago
Thank you!
238.
by netcraft 5y ago
uh, what? that does not sound like a feature to me - I expect that when I close a document without saving it is gone for good. Is there a way to turn that off?
239.
by netcraft 5y ago
Ive always wished to be able to put an expiration on tweets. There are a lot of things that dont need to live forever. Here in the south if I go a couple hours without looking at twitter sometimes ill have to scroll through lots of weather
240.
by netcraft 5y ago
I dont see the answer to a single one of their questions on that page - did you link to where you intended? Edit: you have to click the things on the left, I didn't realize they were tabs.

More ›