skysight-inc/HackerNews huggingface dataset:
Country to maximize earning potential as a new grad SWE
New grad swe at a tech firm. Curious to know what would be the ideal country to be working in if I want to maximize earnings and retire by the age of 30. My current compensation is $250K including sign on and minimum guaranteed bonus
But this is just a plausible looking answer, it is still a text generator, this has no bearing on reality per se.
For complex things like MATCH_RECOGNIZE (and CASTs) whose syntax and semantics differ across underlying systems unfortunately the result will be that some data is going to be pulled and be processed in Trino - so it'll be slower than native. If you are only dealing with a single data source (unless it's not an RDBMS, say files on S3 or an API) I'd say Trino is not needed and would slow you down.

The rule of thumb is that Trino aims to provide a uniform layer over whatever sits underneath. So operations which when "pushded down" to the source result in same results as when executed within Trino do get "pushed down" - i.e. executed on the source. But in cases where the results might differ or it's complex to push-down the operation the operation runs within Trino - i.e. pull data from source (minimum needed data) and then perform operation within Trino.

Note that it's not an all-or-nothing case, e.g. a query like:

SELECT n.name, r.name
FROM postgresql.tpch.nation n
LEFT JOIN postgresql.tpch.region r ON r.regionkey = n.regionkey
WHERE n.name > 'A'
AND r.name = 'ASIA'

will result in the following query to Postgres:

SELECT n.name, r.name FROM tpch.nation n LEFT JOIN tpch.region r ON r.regionkey = n.regionkey WHERE r.name = 'ASIA'

The rest of the query (n.name > 'A') would be applied in Trino to results fetched from Postgres because the collation in Postgres will affect results if we push complete query down to Postgres and may not match results when entire query would be processed by Trino. With single data source this is not easily appreciated but e.g. if the second table in the query came from SQL Server then you'd want to have a consistent comparision logic regardless of source of table.

This is a very simplified example though.
I thought it was on the front page to show how brilliant land management plan is ridiculous in implementation.
Ask HN: How did you get your first job as an sysadmin?
Heya HN,
I'm thinking of my career prospect after university and I've came to conclusion I feel most drawn into administration as a field.
I wanted to ask you for what your experience in getting job as an administrator after university, especially if it was your first job in IT that you did.
What were the skills you had to have? How did you on about looking for the job, or internship? Have you had any certificates and so on?
Fastfilter: Binary fuse and xor filters for Zig
This device seems too good to be true. Have they shipped any?
I subscribe and I use GPT-4
Is it memory/disk bandwidth bound or latency bound?
Fact checked myself and I was m wrong in my memory of what the campus where for. Looks like it a forced quarantine for those infected or believed to be exposed, I w thinking they also force quarantined those who didn't get the jab as well.

Sorry for the confusion! I guess different stories are starting to blend together from all the pandemic response hysteria and I should have checked that myself before posting.

https://www.bbc.com/news/world-australia-59486285
Most people think - if I'm already carrying a smartphone carrying a second computer seems like overkill. If you want a better keyboard just get a Bluetooth one.
I didn't know this about ChatGPT - brokers of user data, trading data collected for compute. As interesting as this is, there's a lil bit of an interesting public policy and computer technology for fair use of one's personal data. No expert, but might be a slippery slope long term, so highly suggest you get a checkbox in there with some sort of absolvement in liability between your app and the user's resume.

Other than that, it's like all good things - 80% of it is the button click, while the last 20% is proofing the final result and correcting the model so the machine can learn.

God Speed man. Love new tools.
The app is complete garbage, and the dark patterns on their mobile webpage are insidious.

If I have to wait to go to my desktop to see something on reddit, most likely I’ll forget about it and not visit at all. Or I’ll go through the old.reddit on mobile which isn’t great.

But it’s only a matter of time until they remove old.reddit.

Perhaps web scrapers can come to the rescue in some way? Maybe a self-hosted instance of a scraper that pulls the data for each page you’d like to see, kind of like a proxy between your client and reddit? Would be a fun project to try out.
Both options may be true for different cases.

That's option one. Or do you insist on some particular definition of exceptional circumstances?
Grapheme are a made up human thing that, while useful, is locale dependent. Most people when they talk about grapheme clusters mean the default "locale-independent" graphemes but it's not the only one (in Hungarian for example 'ly' is a single letter). Having the same string be two different lengths in two countries is… let's go with surprising. The common denominator where everyone computes the same
number is code points.
Ready my OP again, thats my exact point!

This is not caused by some unprecedented economic crash or poverty crises. As I've said in the OP, "this is an epidemic of uninformed tolerance and apathy ravaging an entire nation."

These are either addicts, mentally ill or uncivilised people. Every society from the most liberal ones to the most tyrannical ones have set up laws and institutions to deal with them.

You forcefully institutionalise the mentally ill. You provide an option of voluntary treatment to addict or forced. You forcefully remove the uncivilised people.

I personally have stronger beliefs when it comes to what to do with these peoples but that will get me banned (its a little biblical).

What I'm talking about here is the humane/liberal option. The alternative is to let them rot and devolve further whilst ravaging our cities, nobody wins.
Find #31 "Radio Row". this is where you could buy vacuum tubes and anything electronic from a local concentration of shops that carried all that. It was taken over by eminent domain to make way for building the World Trade Center.
In general, building programs interactively by changing them as they run. That's the default, normal way to write programs in certain languages (notably in Common Lisp and its antecedents and in Smalltalk).

In such languages, you want to be able to use the entire language at any arbitrary point, including at a point where execution has halted for the moment because of some error that has occurred in some arbitrary place. The condition system provides a nice set of tools for doing that.
Sounds like quite something with a high risk of selection bias. You wouldn't expect to hear from them either way.
It is clear that it is satire, but it does not really work because it asks the wrong question. When you ask the right question (about travelling in an airplane, not jumping out of one) the fact that commercial aviation is conducted without parachutes (though with seat restraints) makes sense.
I find as I get older and my eyesight isn't quite as good that what I want for that sort of use case is an external keyboard and a monocle, or some other head-mounted display. Any portable device with a stand that's any smaller than a laptop means leaning over and squinting.
This is such a bizarre comment to make about something that is Apache licensed. Who cares what happened before now that it’s truly open?
Here is something quite similar I've just made, but in the image domain :

https://github.com/unrealwill/uncroppable

It's a tool POC to steganographically encode an image into itself to make it crop resistant.
Might be my wrong sampling methods but I thought introducing yourself with the job description was more of an American thing? My impression meeting people around here (Europe) is more like "where are you from? aaaa cheese right?" and it goes on from there.
No, "free" source code and "open" source code are two different, distinct concepts[1][2].

Conflating one with the other is counterproductive and inhibits understanding of the concepts concerned.

[1]: https://www.gnu.org/philosophy/floss-and-foss.en.html

[2]: “Free and Open Source Software” is misleading in another way: it suggests that “free and open source” names a single point of view, rather than mentioning two different ones. This conceptualization of the field is an obstacle to understanding the fact that free software and open source are different political positions that disagree fundamentally.
Does an OS upgrade remove this malware though? Maybe it doesn't and it's why so many phones were infected.
I have a Mazda and don't have any of the issues the commenter has including any type of resistance when changing lanes.
He gained a huge amount of reputation by saying "I don't have equity in the company. I'm doing it because I love it" in front of the Congress. While he was demanding licensing for AI because it's too dangerous.

I love it. It's dangerous. Hypocrisy? No. It's the tendency of man to pursue what is harmful to himself. Even though optimistic technologists of HN won't agree, much of technology has not benefitted humanity.
As a PM I feel seen. So many past experiences in companies with poor product culture where this happens. Companies like to say they’re hot on agile and have a strong product culture involving mvp, test, learn, iterate frameworks but in reality so many are just; mvp, test, learn, release, move on to the next different mvp

Leadership often say they want agile processes and iteration but at the end of the day they just want releases of new features
Implementing a simple traceroute clone in Python
it’s the entertainment sector, who cares.

most of the bewilderment is about the size of the existing collectors market - which blockchain activity simply reveals due to its transparency - and everyone is mostly acting surprised that the collectors market exists, at any size, and has frictions whose NFT based solutions are of interest to collectors. By that standard, the answer to your question is “nearly all”? These collectors are not crypto enthusiasts, they don’t know anything about crypto technology, just a 5 step process of getting their wallet open and using one marketplace.
I am not trying to undermine anything :D.
The article says:

>An indirect indication of the presence of Triangulation on the device is the disabling of the ability to update iOS.

So I assume that the malware stops working when iOS is updated. This highlights the tremendous importance of keeping software up to date.
Neverflow: C macros that guard against buffer overflows
I occasionally fire up Windows 95 in a VM and marvel at how fast it is. Sometimes I use it for actual tasks, although it is hard to find things Windows 95 is useful for nowadays. My copy has office 97 installed, and I use that for some spreadsheety tasks.

I really like being able to click anything and know I won't see a loading spinner.
Thanks Dave, as a PM this is super useful to me to help me emphasise with my team.

I love your illustration of the work involved to get a project live. I think I might bookmark this for when I encounter that pushy stakeholder that wants a fixed estimate
Android apps are just not setup with a keyboard in mind. Chuck an adapter and a usb keyboard onto your phone or android TV, and you will quickly experience how painful it gets.

Little things like weird tab order, or widgets not giving feedback when they are focused add up to a bad experience.
African or European mouse?
Makes me think of the treeships in Hyperion.
Even having worked on JuxtaCode, I have to stop and think about how each term applies depending on the situation. But I find that by sprinkling "Ours" and "Theirs" badges throughout the UI, including the commit graph, it helps me keep track of what each term means in the current context. But I get that might not do it for everyone.
Reddit is past its expiration date anyway and I'm surprised no one has created a challenger site. Perhaps this was due to Reddit's friendliness toward programmatic access but it seems they are taking that away.

This is a good opportunity to create a new community, and essentially take back messaging from the corporations (let's be real about what reddit is) and put it back into the hands of the people.
Funny, this one stood out to me as less baity since they actually did include "in stimulated test" in the title
Don't forget that with the Blackberry there was a massive image factor: if you had one, that implied you were important enough to need messaging on the go. The form factor was almost incidental. As full text messaging became ubiquitous it lost its cachet.
Another better alternative is for these companies who can't afford the top talent, to train new talent (new grads, new juniors or people with less then 3 years experience) and upgrade them into where they need to be for the companies long term benefit. Also if you are going to say next that these people will just eventually leave, the number one reason people leqve a job is because of a shitty boss/manager. A company who invests in their employees will hopefully not develop bad managers, who can keep good individual contributors. Hell that's in my situation, i'm underpaid, but I also am working for the best manager i've had so far in my career, so I trade off stress and money for a relaxed and longer life.
Crypto stuff is definitely disabled, even if you skip the welcome screen. Actually, I don't think they even ask you to enable it on the welcome screen either.

All of it is definitely opt-in. Even Brave Rewards are disabled by default.
I found this repository to make storymaps with Google Sheets and Leaflet, that could be a nice addition: https://github.com/HandsOnDataViz/leaflet-storymaps-with-goo...
> It doesn’t feel like anything to be a table or a chair.

That, we don't know. It's based on assumptions, such that some biological processes must go on, because. _obviously_ if they don't, there can't be this consciousness thing (that we don't know what is) going on..

It's an interesting flaw, we know we have this huge gab in our understanding of the subject, yet we have an intimate relationship with the very same phenomenon, and it might be that duality which tricks us into such assumptions as "It doesn’t feel like anything to be a table"..

We can't ask a table if it feels anything, we can't induce in it, any of the measurable responses that we get when interacting with a person, for instance, and so we assume, that since we cannot observe it, this thing that we don't know what is, is not present.

Until not that long ago, it was assumed that infants didn't feel pain, that animals didn't feel pain.. Now we seem to have concluded, that since they have the biological gear for it, they do in fact feel pain.. However, we strictly speaking haven't proven that the biological gear that allows us to produce measurable responses, is actually instrumental in giving rise to consciousness, rather than simply allowing expression of it.
https://upgrader.gapminder.org/
Location: India
Remote: Preferred (US, UK Timezone ok)
Willing to relocate: No

Technologies:
* Java, Spring, MultiThreading, Distributed System, Concurrent System, Spring Boot, Dropwizard, Vertx, MongoDB, MySQL, Postgresql, Redis
* Kafka, RabbitMq, S3
* AWS, Google Cloud, Docker

Résumé/CV: Email Me
Email: [ankush]{chaudhary}(348)[AT][GMALE][DOT][COM]
LinkedIn: https://www.linkedin.com/in/ankush-kumar-519284129

Currently, I am working as a Senior java developer. I have designed scalable and fault tolerant system. I currently have 6 years of experience.
Indeed, I think the poster was referring to a metaphorical railroad. The term comes from https://en.wikipedia.org/wiki/Underground_Railroad
I feel this for a lot of things, but I love flying and I've probably done it dozens of times. I know people who travel for business and that sounds like it'd kill the magic, but I still love it. Earbuds + laptop! Isolated for hours! They bring food _to you_! You're miles up in the sky!
Man Group Alpha Tech | Quant Python Engineer | London, UK | Onsite | Full Time
As a Quant Python Engineer in Alpha Tech at Man you will be building the tools, frameworks, libraries and applications which power our Quantitative Research and Systematic Trading. This includes responsibility for the continued success of “Raptor”, our in-house Quant Platform, next generation Data Engineering, and evolution of our production Trading System as we continually expand the markets and types of assets we trade, and the styles in which we trade them. Your challenges will be varied and might involve building new high performance data acquisition and processing pipelines, cluster-computing solutions, numerical algorithms, position management systems, visualisation and reporting tools, operational user interfaces, continuous build systems and other developer productivity tools.

Our systems are almost all running on Linux and most of our code is in Python, with the full scientific stack: numpy, scipy, pandas, scikit-learn to name a few of the libraries we use extensively. We implement the systems that require the highest data throughput in Java. For storage, we rely heavily on MongoDB and Oracle.

We use Airflow for workflow management, Kafka for data pipelines, Bitbucket for source control, Jenkins for continuous integration, Grafana + Prometheus for metrics collection, ELK for log shipping and monitoring, Docker for containerisation, OpenStack for our private cloud, Ansible for architecture automation, and HipChat for internal communication. But our technology list is never static: we constantly evaluate new tools and libraries.

Alpha Tech has a small company, no-attitude feel. It is flat structured, open, transparent and collaborative, and you will have plenty of opportunity to grow and have enormous impact on what we do. We are actively engaged with the broader technology community.

o We host and sponsor London’s PyData and Machine Learning Meetups o We open-source some of our technology. See https://github.com/man-group o We regularly talk at leading industry conferences, and tweet about relevant technology and how we’re using it. See @manquanttech Essential Skills o Exceptional technology skills; recognised by your peers as an expert in your domain o A proponent of strong collaborative software engineering techniques and methods: agile development, continuous integration, code review, unit testing, refactoring and related approaches o Expert knowledge in one or more programming languages, preferably Python, Java and/or C/C++ o Proficient on Linux platforms with knowledge of various scripting languages o Strong knowledge of one or more relevant database technologies e.g. Oracle, MongoDB o Proficient with a range of open source frameworks and development tools e.g. NumPy/SciPy/Pandas, Pyramid, AngularJS, React o Familiarity with a variety of programming styles (e.g. OO, functional) and in-depth knowledge of design patterns.

If you're interested, please get in touch with Milly Parrott milly.parrott@man.com
> just ChatGPT

There's obviously a ChatGPT-3.5 and a ChatGPT-4. Actually 4 different ChatGPT-4's: Normal, Browsing, Plugins, Code Interpreter.
Adjacent topic but i have a friend who told me buying a refurbished iPhone from a local shop was a bad idea from a security perspective.

Is this true? I thought a hard reset and secure enclave etc. was enough? Can you put "stuff" in it that survives to a new user?
Houston Astros? https://news.ycombinator.com/item?id=10492177

Honestly that's pretty awesome (and a genuinely amazing story); every time I've seen a championship ring, it spurred deep conversation. Admittedly it only happened three times, all for Nationals staff, but everyone was passionate about what they did.
ARM's newer SVE/SVE2 instructions can do something like this now. SVE allows the vector length to vary between 128 and 2048 bits, at 128 bit increments. RISC-V's vector RVV instructions also allow the vector length to vary across different CPU implementations. This way, the same RVV vector code can run on different CPUs having different vector lengths.
How about a Pinephone with the keyboard case?
Allow me to introduce to you White Painting, The inspiration for 4:33

https://www.sfmoma.org/artwork/98.308.A-C/
The law most definitely distinguishes between the rights of a human and the rights of a software program running on a computer.

AI does not read, look at or listen to anything. It runs algorithms on binary data.
An AI developer who uses millions of files to program their AI system also does not read, look at or listen to all of that stuff. They copy it.
That is the part explicitly covered by international copyright law. It is not possible to use some file to "train" a ML model except by copying that file. That's just a fact. It wasn't the computer that went out and read or looked at the work. It was a human who took a binary copy of it, ran some algorithms on it without even looking at it, and published/sold/gave access to the software.

AI software is a work by an author; not an author.
The solution is only allowing 3rd party access to Reddit subscribers, to avoid the need to monetize through ads.

If Reddit is asking 12000$ for 50M requests, then a regular Reddit user (344 reqs/day) would be paying around 2,5$/month, which seems more reasonable than putting the burden on the 3rd party developer.
Mice around me fairly frequently climb trees. They know whats at the bottom of the tree (hard soil). Yet I never see them jumping off - they always climb back down the way they came up.

It could be to avoid getting disorientated though, or to be able to see a predator and reverse course...
"Avoid Republican-voting counties" was completely apolitical before I came in. This is an actual argument you thought makes sense. Ok...
Sorry, this is part of my effort of learning Go and is also a WIP. So I am not yet comfortable sharing the code. I can share the libraries I used:

- go html/template for the front-end

- github.com/twpayne/go-gpx for parsing the gps tracks

- github.com/fogleman/gg for drawing the images

- github.com/dsoprea/go-exif/ for reading the exif of the photos, so I can show where are they taken on the route map
Taking financial privacy to the extreme is how you get failed states.
Every social network goes through this. You used to be able to access Facebook via other front-ends as well, same with Twitter.

This will cut down drastically on my reddit usage, and for that I am thankful. I don't have the Facebook or Twitter apps on my phone, and only use them from Firefox in Private mode when I do get the urge to check them.
I'm very interested in such products. It appears to be similar to Materialize DB.

I use dbt and Postgres for managing a data warehouse. It appears Risingwave doesn't have support for dbt yet, there is an open issue [1]. Materialize supports dbt. Materialize also offers Postgres wire compatibility i.e. I can connect to the Materialize using Postgres drivers. I wasn't able to find this information on Risingwave yet.

[1] https://github.com/risingwavelabs/risingwave/issues/7577
Not directly. There was one or more intermediary stage, probably jumping between trees. Outside my window, the squirrels are busy doing just that.

I have a vague recollection of reading that most squirrels have evidence of trauma from falling, such as healed bone fractures.
You don't get any roads without politics in the first place. Everything is "politics".

I don't see the issue with the comment, he didn't assign any judgement to the map. Which is where the politics problem usually arises.