skysight-inc/HackerNews huggingface dataset:
I had the same idea in my mind, but I am struggle to understand efficient implementation.

Say, I have large table A, which I want to group by.
I can chunk it into small tables, for example:

for i in range(64): execute('create table_%i as select * from A where hash(id) % 64 = %i')

but this would mean scanning source table 64 times which is likely not efficient, I am wondering if duckdb has some functionality which can do more efficient chunking?
Love that Sama literally spent 16 seconds of a 45minute announcement on whisper - https://app.reduct.video/o/eca54fbf9f/p/250fab814f/share/9d9...
OpenAI Lets Mom-and-Pop Shops Customize ChatGPT
Really think about this claim. Have you ever heard of a Tesla driving through a dead zone and bricking itself on a mountain, or in a desert? Or in a disaster zone when cell service was down?

If that happened, you would hear about it instantly. It's obviously not true.
To use Regus you needed to be part of a business and have agreements and stuff. To use WeWork you needed a credit card.
archive.is also blocks quad9 now. pretty much every privacy-oriented DNS service doesn't provide EDNS, which means that whether or not archive.is blocks them depends on whether or not the operator has gotten in a mood yet.
Planck the scientist? The Planck length is 10 to the −20 times the diameter of a proton. Why are we using something so small to talk about galactic distances?
A fool and their money...
My biggest thing was slowing the fuck down and consistency. I was an athlete in HS and had a huge ego around how fast I should be going. For reference I didn’t run faster than 12min/mi for the first 2 weeks. Also I run 5-6x a week now (1 long run the rest super easy recovery runs <5.5 mi)

Other things:
1. Foot/ankle strengthening. Lookup YouTube videos on how to strengthen feet and knees. 5-10 mins a day as you’re starting. If you’re going slow it’s low impact too.
2. Focus on form/don’t zone out. I used to run and try to “zone out” as quickly as possible to “ignore” the pain. Instead focus in and run a mental checklist of your form. Again, YouTube videos on good form (which often aren’t targeted/explained how to run that well when running so slowly, so be specific with your searches).
3. I moved to NRC which I liked a lot better than C25K. I like the mental coaching and found it very valuable especially in the beginning. Now I run without music because I like listening to my breathing, as if I lose focus on my breath that also hurts.

There’s a lot of other things that I now keep track of for funsies. But those will come naturally if you start to enjoy running for the sake of running. I’m not running for health, to lose weight, or to look better. I’m running because I really enjoy running. YMMV
Well, from my first account (I worked there) this is wrong. Also, there's never been stack ranking.
wireguard is equally simple. Both pihole and wireguard are set and forget in my experience.
I had this happen to me when I got into running. I went on a trip for 2 months and let my injuries recover. When I got back into running, I had no pain and haven’t had for more than a year. I’d say give it another try, I think a lot of the injuries are overuse and your body will adapt over time.
Depart the road means flip?
Few queries out of ignorance.

What are some use cases for 128k context length?
We detached this subthread from https://news.ycombinator.com/item?id=38172482.

No workaround link works for everyone, unfortunately.
When these machine translations fail, they tend to reflect poorly on the brand as well. It can cost more than simply hiring translators in the first place. [1][2]

[1] https://www.escapistmagazine.com/minecraft-legends-arabic-tr...

[2] https://www.minecraft.net/en-us/article/minecraft-legends-ar...
It's the other way around: they phone home so that they can be bricked, or at the very least have important features disabled at Tesla's whim.

What you're suggesting can't work because there isn't cell reception everywhere, but of course that hasn't stopped car rental companies (I think) implementing exactly that with the predictable result of people being stranded in remote locations.

The real danger is that someone from Tesla is here reading your comment and putting it on the to do list.
davidjfelix outlines some of the issues, but I wanted to add in some that may have been simple upfront headaches that made people resistant:

- Simply put, print was ` print "text" ` instead of ` print("text") `. Looking back, this was such an annoying habit to break; but if you're codebase had thousands of print statements, that becomes thousands of changes

- range(3) used to return a list [0, 1, 2] while Python 3's range(3) returns an object. If your codebase relied on that explicitly created list, then it'd break in Python 3.

- Division was originally integer division, so again if you expected an integer and are now getting a float (with a non-numeric decimal point), then more crashes

- except used to be except (Error1, Error2) as e and Python 3 explicitly requires each except to be on their own exception catch

All in all, tons of changes that you'd need to do before switching otherwise your codebase would crash. It also meant you couldn't rely on Linux's default Python (2.7). I never needed to make the switch on a production base, but hopefully you can see why someone would drag their feet

[edit] Python was also still a "new kid on the block" of languages. Its popularity was growing, but since it was not an industry standard yet, these systems were mostly through hobbyist, so I imagine there was plenty of just trying to find that mythical "free time" I keep hearing about.
You can select "Plain SVG" instead of "Inkscape SVG" in the file saving dialogue.
Agreed, but one is a recognizable trademark (I assume) and one is a generic catch-all term that means a lot of things and would probably be worse from a branding/marketing perspective.
ZipWP already does something close to this for WordPress sites.
> It’s still useful to talk about the density of matter inside a volume that is equivalent to the volume defined by the sphere with a Schwartzchild radius because it sets an upper limit on the density that a given mass could be before an event horizon would form.

No, it doesn't. There are indeed upper limits on the mass of objects that are formed from stars that run out of nuclear fuel, before the objects collapse to black holes (the Chandrasekhar limit for white dwarfs and the Tolman-Oppenheimer-Volkoff limit for neutron stars), but those limits are not based on density.

It is true that, especially in the early universe, gas clouds forming very massive black holes without going through the intermediate stage of forming stars is considered possible; but that is not based on the kind of simplistic calculation that you describe. It's based on numerical simulations of the Einstein Field Equation with relevant initial conditions.

Another factor you are not considering is that the universe is expanding, and the early universe was expanding much more rapidly than our current universe is. So gas clouds contracting to form very massive black holes had to work against the expansion to do so. That further complicates the calculations.
Governments are a whole other ballgame, your right. They often have very particular requirements that not every company is going to be able or willing to meet, though. I don't know enough about their particular business to say without a more complete analysis, but even with governments, just having a cheaper product is not always enough to get your bid accepted.
Lawyers aren't limited to isolated cases. Class actions exist for this exact reason and regularly lead to hundred million dollar+ payouts from banks and other large defendants for harm done to large groups of people.
Ah my dad has the same story about his time in the Math and Computer building at UW. Though he said it got a lot better in later years when he could just show up at 4am and run things pretty much right away because nobody wanted to be there at 4am. That part I find hard to believe based on my time at UW.
Well, yes, I get that generally, but you can't lay off your mortgage payments so prioritizing growth is tricky.
Sent you an invite code.
There are books that can help with this action -> thought -> emotion spiral.

I found great help by reading the (IMHO poorly titled) Happiness Trap: How to Stop Struggling and Start Living

https://a.co/d/1QeKVAn
No, but I have certainly heard stories of Teslas in underground parking garages that couldn’t get a cell signal and therefore couldn’t start.

I don’t know what particular conditions cause that. Maybe using phone as a key? And perhaps it was fixed. But it famously happened to Glenn Howerton.
Aider uses different prompting strategies for GPT-3.5 and 4.

GPT-3.5 is only able to reliably edit a file by returning a whole new copy of the file with the edits included. This is the "whole" edit format.

GPT-4 is able to use a more efficient "diff" edit format, where it species blocks of code to search and replace.

All of this is described and quantified in more detail in the original aider benchmarking article.

https://aider.chat/docs/benchmarks.html
If you take a self-parking/-summoning ride to a dealership service department where they shuffle cars every few minutes, it's reasonable to leave keys or their equivalent. If the equivalent is a geofenced, limited duration, remote control credential generated only by an owner-initiated positive control process, then that's fine too.
Yes. I know the latest HN trend is to hate on Cloudflare, but I’ve had zero negative experiences even as a heavy user (dns and CDN and workers) even during the major downtime events.

The negativity toward Cloudflare has always confused me. I don’t get it.
Great, now I can cancel my order of a faraday cage double garage.
In theory the existing shareholders should be the first to lose their stake - though those with inside access can benefit by re-investing at a low price once the restructuring is complete.

Those owed debts can lose much of what they are owed. In the case of WeWork, landlords will likely lose a lot of owed rent, and lease agreements will be cancelled or renegotiated at much lower rates.

Employees are meant to be at the top of the list to be paid what they’re owed, but that’s still contingent on funds being available to pay them.
The design do's and don'ts always stress me out because once I know the rules, I can't un-see all the violations coworkers make, even if I do my best.

Former coworkers will probably recall that I was quite the stickler for the particular shade of red at a previous startup. I hope I didn't get on too many people's nerves :)
I didn't understand this well enough to appreciate it. What's the use cases and how about privacy? How's it different to regular GPT 4?
Anything open about OpenAI starts and ends with the name
> our senses generally work on a log scale, so it’s not something unnatural.

Where confusion creeps back in is when sensory input is quantified. People don't perceive a 1000 lumen source as twice as bright as a 500 lumen source, but tend to think they should.
Maybe those motorcycle training courses have become so strict that young people don't bother, and most of the bikers you see are those "grey haired dudes" who learnt back when standards were lower.
Funny that two of your commits don't actually tell us why they exist, one simply describes the diff (which you should never need lol?) and the other proxies that responsibility to some other system.

You could have simply randomized the text in each commit, put the ticket id and the one "why" in the merge commit body and gotten the same end result amount of real information in the end.
Ultra HDR - I predict it will cause a revolution in photography. This isn't the old HDR that was all about capturing a wider range of brightness; it refers to display of a wider range of brightness. It's built into Android 14 and you can now capture Ultra HDR images with the Pixel 8 and 8 Pro. Ultra HDR is really just jpg, uses the standard jpg extension and works the same as a regular jpg, unless your display software knows about the "HDR mask" that's embedded in the metadata, AND your display supports extra brightness. Chrome supports the format, and you can view images that look SO REALISTIC on most recent phones and desktops/laptops that support HDR display, both macs and PCs. The look just like reality. BUT - now I need a way to convert my big camera's HDR images into the Ultra HDR format, and I haven't found a way. Really just need to create and embed a brightness mask. Looks like Adobe is adding support to lightroom...
>As soon as every vehicle in Manhattan is autonomous, people will bully them into sitting idle at green lights while walkers, bikers, scooters and everyone else flagrantly jaywalk in front of them.

Sounds like pretty much how things work now so long as anything has paused the road traffic--which is all the time.
Perhaps you might be interested in the works of George Ivanovich Gurdjieff. When I encountered his ideas, I was impressed by his psychological insights. I had never encountered same level of insight before. It really resonated with me.

His approach is not religious in the usual sense -- there is no need to believe anything or pray to some entities. It is not in conflict with religions either. Gurdjieff is presenting the psychological and spiritual ideas that are behind many mystical traditions of religions in a way that is more digestible by the modern man, and possible to apply in modern life.

His own books are probably too dense to start from. A good starting point for me was the book series Psychological commentaries by Nicoll. Another popular one is In the search of the Miraculous by Ouspensky. You can only get the Commentaries as used, and they are really expensive, but you only need one of them to start with and PDF versions can be found online. One one book of the series will do, as they all are all composed of one pagers on recurring topics.

Drop me a note if you are interested.
On "rebus":

> A rebus (/ˈriːbəs/ REE-bəss) is a puzzle device that combines the use of illustrated pictures with individual letters to depict words or phrases. For example: the word "been" might be depicted by a rebus showing an illustrated bumblebee next to a plus sign (+) and the letter "n". It was a favourite form of heraldic expression used in the Middle Ages to denote surnames.

* https://en.wikipedia.org/wiki/Rebus
I believe creditors are first in line. Then preferred shareholders, then common shareholders.
With my explicit consent for each access they can do whatever they like. A button to issue a virtual key, for instance, would work great.
As a second opinion, everyone is different. This is quite literally the last advice I would give anyone starting out. Short high effort intervals and spiking HR for someone with poor cardiovascular strength (myself 12 weeks ago) feels like absolute horrid shit and I would never want to go to the track again.

Prioritize enjoying the run. Which you can’t do when your body thinks you might be having a heart attack.
If you get to the point where you have some insight on trading electricity... i know some people who have some capital..
I'll reply here when I hit publish on the repo.
I don't remember the name of the company, but it was a service you bought where you would get network monitoring by placing these small PoE powered boxes all over your offices.

It would allow you to do network reliability testing, as well as get data back on Wifi AP's and some environmental data.

Company I worked for had them spread out across all of their offices in various different locations, all of them reporting back to a central location.

When we took apart the device we found a Raspberry Pi inside, with a PoE hat. It made sense for the use case, cheap devices, custom case, and MAC address that was set to the vendors MAC address range upon boot up.

At the time I was helping with a security assessment, and being able to run our own software/tools on a device that would blend in was kinda nice ;-)

"Embedded industry" is a VERY large segment.

Here's a fun one for you. This was told to me by the person who helped build this project. Parallax makes a device they call the BASIC Stamp 2 (https://www.parallax.com/product/basic-stamp-2-microcontroll...). It is a very easy to use and develop for microcontroller yet it is incredibly capable. You program it in BASIC.

The BASIC Stamp 2 was for the longest time used in a production sold to consumer timer clocks for turning solenoids on and off for sprinkler systems. At one point in time you could buy it off the shelf at Home Depot not knowing that the device contained a very simple BASIC Stamp 2 to do its functions.

These devices end up in the weirdest places. You'd think a manufacturer would switch from a BASIC Stamp based product to spinning their own board + using a small embedded CPU instead, but the cost savings just weren't there.

The RaspberryPi is likely used in far more places than you or I could imagine in ways that are considered "professional". That stuff gets hidden in little metal/plastic moulded boxes and for all intents and purposes disappears.
Isn't that what all IPOs are these days?
Conversion.ai / Jarvis.ai / Jasper.ai / whatever they’re called today raised $125M at a $1.5b valuation, so it made sense at some point to some people.
If they're stolen, go prove it in court. The logo doesn't really enter into it.
It used to be a mandatory part of the UK driving test. Now it's one test out of three, so you can skip preparing it and just retake your test if you get unlucky.
Calls for AI regulations after manipulated porn images shared online
The changes I’ve seen in 3 months are frankly staggering. I quit smoking, cut like 95% of my alcohol consumptions, started eating healthier, etc. and it was really easy for me to do all at the same time.

I had tried tackling each of these problems independently before and typically failed. Withdrawals, cravings, etc. are too much. But man I really fucking love running now and smoking, binge drinking and junk food just look so gross to me now that I know they’re gonna ruin my runs.

The brain is weird. I’m insanely grateful.
Tangentially, it turns out one could use late 70s technology to store 5gb of data on a VHS tape: https://www.youtube.com/watch?v=xSnrQBfBCzY
Your answer is fantastic! You're a really cool person. I like how you handle each point comprehensively and informatively and maintain a friendly tone throughout.

And very funny about the:

Oh! Ha ha! Nice! I'm glad you like the code! I'd love to tell you it was the product of a journey of discovery that embedded deep magics in a (possibly) one-liner... but it's actually recommended (for the most part) on MDN's documentation about eval (and why not to use it).

Haha! You totally got my meaning. Thanks for telling me that. Yeah the MDN docs contain hidden gems, I'll check it out.

Regarding the eval situation you describe, JavaScript running inside an iframe from a different origin (like BIGCLICK.NET) cannot access the DOM of the parent page (like NYTIMES.COM) due to the Same-Origin Policy enforced by web browsers. They could communicate over postMessage, but you can check the origin of the message and discard it if it's from an untrusted origin. The main risk with eval I think is that is can turn any string into code, so user input can be misused by an attacker. I'm not sure it's an issue here, because:

eval(`(function ${this.template.toString().replace(/^\s*function\s+/,'')}())`);

Simply evals the template function's string, which creates your template. The options for manipulating user input are potentially every template replacement variable, but, none of these will be treated as code by eval, as they are located in the template slots. Also, as the cooked template is injected into the DOM, this vulnerability exists independently of eval here. For example

.template() { return `<h1>${myHeader}</h1>` }

If an attack tries to set

myHeader = `;alert('evil');<script>alert('big evil');</script>`

It will not work because: 1) the first alert will not be executed as code, just as a string to insert into the template slot; and, 2) the second alert will not run because scripts injected via .innerHTML are not run.

However, if an attacker sets

myHeader = `<a href=# onpointermove=alert('evil')>Oh No</a>`

It will work when you pointer over it. I suppose the real risk then is from allowing unsafe-inline. Crucially tho "myHeader" can never be executed as code, its variable is simply replaced.

This is just a quick analysis, it could be patchy.

As long as you're good with a slow pace, I'm happy to make some pull requests.

Yes! I am totally fine with a slow pace. I completely understand and agree with the idea of going to your own limit, knowing how much bandwidth you have, and managing your workload for productivity and self care. Super important, it's the main thing--stay comfortable, no stress!

Also, if you're just too overloaded or don't feel an interest at the time, don't worry about it. No pressure, merely an invitation, you're free to take that up if it's something you feel like, or if not, for any reason, there's no disappointment or judgement at all. It's ok, we just value your contribution so far!

And I appreciate you linking some code, and clarifying any license on it, let me take a look at it! :)
There is, that specific bike has it and it's really close to the best performance you can get as an expert. But it's not very common
I'm still not why "original Apple parts" mean anything special?
There is a lot more to it than that. For instance, employees mostly come before other creditors.
After today's announcement, this list is about to get a whole lot bigger!!
3D? Do you mean illuminated?
Sorry, I read it as every 10 years.

Agreed on the lowering of consumerism.
I've always wondered why WeWork didn't operate more on a "franchise" model. Lots of property management companies have empty space that will be empty for a year or two, and the WeWork system is useful to install against, along with its brand, so these management companies should be able to "install" a WeWork for a year or whatever while their space is vacant, to help offset the lost revenue from leases.

Shifting the revenue to a franchise model seems like it solves the majority of their lease issues, and still lets them be useful, even in smaller markets. Their value, IMO, is in the "seamless" experience. Knowing I can paratroop into a city and will have a space to work that's of a consistent quality is great, someone sell me that!
For me, slowing down, proper foot striking (go for a couple barefoot runs at the park until you know what feels right and then translate that to form with running shoe on), and I did feet and ankle strength training for the first month.

Oh and #1 is listen to your body. I’m running for the joy of running. If something hurts I’m not gonna run, lol. Important to rest.
Are you saying that every USB-C cable is required to support DP alt mode? I’ve heard that’s not the case — that active cables, for example, will usually not support DP functionality.
Cool, but maybe let people actually use your service before everyone forgets what it is?
A fool and someones money
Would be incredible if it was the same person
You did the right thing. Stay strong!

When it's all uniform and consistent it's magic. When it's mushy and weird, it's a lot less magic.
I skimmed your substack, and it seems to me that you would like SICP. Give it a try.
1. have no relationship with cloudflare.

2. turn on "do not track"

3. reach enlightenment.