netcraft

I remember when the json stuff started coming out, I thought it was interesting but nothing I would ever want to rely on - boy was I wrong!

It is so nice having json functionality in a relational db - even if you never actually store json in your database, its useful in so many situations.

Being able to generate json in a query from your data is a big deal too.

Looking forward to really learning json_table

sorry, yeah, thats a much better way of saying it and my smooth vs continuous was just confusing

the size. An optical telescope is limited by the size of the mirror which needs to be one continuous surface (though not necessarily smooth for instance the JWT but I digress), but a radio telescope doesnt, it can be many individual collectors that can be joined together. This enables it to be much larger so it can collect more signal, and the radio waves are much longer so it needs to be much larger. In an extreme example we have used many different radio telescopes together with very precise timing to produce the images of the black holes at the center of M87 and the milky way.

But it requires those different clusters of collectors to be stationary - so while you could probably build a swarm of satellites, they would have to stay in very precise distances from each other over time which would be considerably more difficult than planting them on a surface.

Also, a big shield like the moon blocking out radio interference coming from the earth is desirable.

IANAA, corrections to my understandings welcome

I love json tools, I use several like https://jsoneditoronline.org/ Any chance of a hosted version?

this looks awesome, I cant wait to play with it! we need to get this into RDS as soon as we can

this looks awesome. Is it possible to create a database and load it with data and then share it with others? Would be amazing for teaching SQL, but also just many data collaboration tasks

I had no idea it was related to diaspora. After reading only the first few paragraphs I can't wait to read it all. Thank you!

I havent yet read permutation city but Diaspora is one of my favorite sci-fi novels. I need to make time for it

previously: https://news.ycombinator.com/item?id=40820022 Link directly to the arxiv paper: https://arxiv.org/abs/2406.19108

I've searched off and on for a great stylistic representation of the ASCII table, id love a poster to hang on my wall, or possibly even something I could get as a tattoo.

how do you dry yourself after using it?

I would venture to bet that the vast majority of Americans have never had the opportunity to try a bidet, and wouldnt know how to use one or what to expect if they did. I know I haven't.

I think this is an education problem. And articles like this only serve to highlight the problem, not solve it.

In ignorance, spraying water at feces on a rear, especially with no way to aim things before hand, leads me to expect a mess being sprayed around the bowl at least, and outside the bowl if you don't have a good seal. Aerosolizing feces is already a problem with the flush, now we are splashing it around? And I assume you still need to use TP to wipe up, but anyone who has used toilet paper around water knows how ineffective it is at drying things.

I'm sure im wrong and theres good answers to all of these concerns - ive heard many proclamations of my savagery at not using a bidet over the years, but ive never seen these things addressed. Find a way to tell people how they actually work and I bet you would see a lot more movement. Put them in hotels or other places where people have a chance to give them a try.

When we figure out how this formed, I wonder if that will have any impact on the feasibility of sulfur based lifeforms?

check out Bunny: https://www.instagram.com/whataboutbunny/?hl=en

altered carbon is a great show that deals with this

there are many mini-split heat pump systems that can be installed by a homeowner without a professional installation now. An example: https://www.youtube.com/watch?v=ZmwZVD2KEDY

I just came to ask basically the same question. Why does inflammation exist, what is its purpose, how did it evolve, are there downsides to blocking it?

We have entire classes of drugs including OTC ones whose entire job is just reducing inflammation, its indicated in tons of diseases and conditions, lots of health industry people (and snake oil salesmen) tell me that x and y and z cause it, but I dont really know what it is.

I was talking with someone from Greece recently who was experiencing a heat wave and they dont have AC. I am from the south eastern US where we are basically required to have AC for de-humidification as much as cooling - we would be overrun with mold and mildew without AC in the summer. Our heat indexes regularly reach 105F during the summer and sometimes much higher. I joked the other day that if our aquifers ever ran out of water we could probably get most of what we need with just a better dehumidifier.

Edit to add: just in case, you should never use water out of a dehumidifier for anything but grey water use cases unless you sanitize and purify it - it can make you very sick!

Thanks!

Would we expect this to be sensitive to the same frequencies as LISA?

I got 45 fairly easily, but ive been writing html for a long time. Would love to see the output reveal them in a list in order of commonality - would love to see if im missing some common ones - like if you guessed 1-20 but missed 9...

edit: Case in point, I missed <img>...

will be looking forward to the Dr. Becky explainer for this one, I have a feeling she is going to be excited

What frequencies would this be sensitive to I wonder?

I always love it when new science is done with old observations

another discussion: https://news.ycombinator.com/item?id=40969120

techcrunch article with more info https://techcrunch.com/2024/06/11/flow-claims-it-can-100x-an...

yes absolutely- that system was built a long time ago before the uuid type - you should def not store things in chars (and probably shouldnt use char at all, use text)

was saying that even with that poor implementation we still were not having issues using uuids

>DuckDB Labs and the DuckDB Foundation do not vet the code within community extensions and, therefore, cannot guarantee that DuckDB community extensions are safe to use. The loading of community extensions can be explicitly disabled with the following one-way configuration option:

So we should think of this like NPM.

Still, very cool and very useful. Would love a way from inside of duckdb directly to query the extensions available from community.

lol, I of course don't mean that I have no issues, performance or otherwise. Only that I have never had an issue with UUIDs in postgres

The point of UUIDs is that they're inherently unique. You can generate them in the database or in your application, or anywhere. You can move records between databases without worrying about a collision. Its this reason that theyre so useful and so many people use them that others like to write articles like this.

You do not need to search. I have generated hundreds of millions and have never hit a duplicate. Its technically possible, but its so vanishingly rare it will be something to brag about, not worry about. If you're really worried about it, and building something that cannot tolerate an error, put a try/catch around it and detect a PK failure and try again. But it will be a waste of time.

Another day, another article saying not to use UUIDs as PKs. I've maintained systems using UUIDs stored as char(36) with million record tables without issue - This is not an endorsement, just explaining that this is bikeshedding. Should you use v7 when you can? Sure. Would int/bigint be faster in your benchmarks? Sure. But the benefits totally outweigh the speed differences until you get to a very large system. But instead of worrying about this, spend your energy on a million other things first and then celebrate when UUIDs become your bottleneck.