skysight-inc/HackerNews huggingface dataset:
Cognos is a BI tool, and the formats you are talking about are for rendering reports, not data. If you're picking data formats based on being able to load & edit them in to Excel, you're already doomed.
Thats why I love the only tech question we give to people: Write me a stopwatch. Pick a tech, define the features yourself, and make it while explaining what you're doing.

There is actually an incredible amount of technical nuance in this question and you can ask this both on junior interviews and senior ones.
Ask HN: Online science courses for those with only a high-school background?
Hi all, I've become interested in developing a proper understanding of science fundamentals (specifically physics and biology).

The catch is I seem to be an in-between case. Most online courses seem to be geared towards freshman high school students or first year university students, and not for adults that barely passed Physics 12 back in the day ;-)

Any recommendations?
Thanks for posting that, I'd been blissfully unaware of that murkiness.

On a side note, "artisanally mined" looks like a euphemism for "dug out of the dirt with spades and bare hands by the desperately poor serving brutal overlords", or something similar. Pretty much like the "artisan" child cobalt miners of Congo. See [1] Is my phone powered by child labour?

[1] https://www.amnesty.org/en/latest/campaigns/2016/06/drc-coba...
"entity with plausible ability to solve it"

I didn't see a mention of an overall solution in the article. I see they mention that leaky pipes could be the cause for that stream. Is there evidence to suggest that the sewage treatment facility actually removes these chemicals?
Variants vs. vaccines – is the Covid-19 race ever going to end? – analysis
What makes you think that having a Twitter account or not is important? It seems like a version of western NIMBY for the online world. Once we realize that what is posted to Twitter (or not) has very little relevance to anything maybe we can focus on something real and important?
> But I completely and whole heartedly support any audits, lawsuits, investigations, whatever that anybody wants to do.

Improper “audits” are not harmless, they risk destroying (both as evidence of what actually happened, and, in the case of operational equipment, as usable equipment) the items subjected to the audit. That's (both for ballots which have been compromised by the “audit” process and voting machines) been an issue with the Arizona audit.

You can't believe in election integrity and blindly support “any audits, [...] whatever that anybody wants to do.” They are fundamentally mutually incompatible.
A lawyer dissects the lawsuit. tl;dr, it'll get tossed.
https://twitter.com/Popehat/status/1427800736960708611
The significance of the Dominion lawsuits is confirming who owns it. It appears the CCP bought it for $400 million in mid-2020 (ie. just before the US election.)

After the purchase, the About web page was 100% Chinese briefly, then was scrubbed. (Reported by NTD.)
Did you misread / misunderstand my comment somehow? Hint: my comment is not about generating CSV for excel to consume.
And how many of those pictures will you have in your library?
The process would not trigger any action. The NCMEC, who can look at the material, and are the people to whom the matter is reported, would compare the flagged image with the source material and reject it as not matching known CSAM.

What if the legal porn of a 21 year old that triggered the collision match looked really really really close? So close that a human can not distinguish between the image of a 12 year old being raped that they have in their database and your image? Well then you might have a problem, legal and otherwise.

> defence lawyers are not allowed to look at alleged CSAM material in court right

I know this is not true in many countries, but cant speak for your country.
Very true, just wanted to paint a picture on how this could be abused.
Yeah, I don’t know anything, but it seems like understanding the problem well is important, and writing up whatever you learn about your inputs and assumptions (problem formulation) would be valuable.
The reason the distinction is meaningful here is that Apple end to end encrypts iCloud uploads, meaning that Apple does not have access to the files. Scanning on the device is this weird middleground where they do sort of have access, and in some cases might very well end up with access (false positives).
I assume because their data source is not great (aggregation of some kind of Glassdoor data).

* Looking at data for Google in San Francisco, Glassdoor says that average total compensation for a "Senior Software Engineer" is 230K $, whereas levels.fyi (which I trust a bit more) says that Level 5 (the one labeled "Senior SWE") earns 350K $ on average. Interestingly, Glassdoor also offers a breakdown of total compensation into the components. Adding the average value of the components together also results in something around 350K $ ... I guess Glassdoor just aggregates things in a wrong way.
* People at different stages of their career probably have a very different likelihood to create a Glassdoor account (let alone one that accurately names their salary). Similar with small vs. large companies, European vs. American companies etc. This potentially introduces enough bias to make the whole thing worthless for jobs that have a large variance in salaries (such as "director of engineering").
* I still assume that the general thrust of the article is right (when starting your software eng career, the bay area is not a bad place to be). But I wouldn't trust the salary numbers very much.
If you are proficient in C, maybe his videos might help you:

https://www.youtube.com/user/mycodeschool/videos

General tips:

If you are implementing a hash table (std::unordered_map) via open addressing: you cannot simply delete "buckets" or entries out of a hash table. Why? Because you "break" the search chain. The solution is to have a flag or something for each bucket.

FULL|"I stored this here"|EMPTY|nullptr|DEAD|"I am invalid now :("|...

You have 3 states. When searching or deleting, you preserve the "search chain" that way. "FULL" and "DEAD" means you can iterate over or delete when on a search or delete op. "EMPTY" on an add operation means, okay here it is, here I can place something.
If you use chaining instead of open addressing you don't have to worry about "breaking the search chain".
Then you just switch to a 3-line php script (fgetcsv() in a loop) and continue on... :)
This stood out to me as well. I'd never attempt to quantify someone's "IQ", which is really a very specific type of test. There are many types of "intelligence."

I'd be more interested in productivity, adding value, understanding the problem space, leadership, communications, technical range, ability to listen.
> I fought this problem for several days going from NetSuite to Snowflake via CSV.

Yeah if you see a CSV import feature without a billion knobs you know you're in for a world of hurt.

If you see a CSV import feature with a billion knobs, you're probably still in a world of hurt.
Great on you ,
But i dont see my parents disabling the auto feature , nor do my friends.

Youre right indeed , you can protect yourself from this , but all the measures you mentioned are settings which are non-default,

A lot of apps annoyingly turn it on by default , while HN users can turn it off , I doubt my grandparents will go through the same effort or understand it.

Question is , why should they ?
Their phone was supposed to help them , not be a snitch and a snitch with flaws at that.

Why should my non-tech friends train to protect themselves from “their” phones.

Human society has always tried to place co-existence and trust on their fore frontier , their ideal wish for society.

This makes us and our devices act as snitches to each other.

Snitch for whom ?
Apple ?

But yes youre right , that if its normal image it will stop at review level , (altho thats on the condition you trust apple employees who are reviewing them)

I just still dont think its a good idea to even reach till this step.

This just makes our computers feel more hostile
If you interpret "CSV" as purely comma seperated values then maybe. But in my bubble "CSV" means textfiles that are separated by some separator. Be it tabs, spaces, commas, or any other ASCII character. Some are more usable then others, if you have commas in your data then use tabs. If you have tabs use Form Feed or Record Separator or vertical tabs ... and so on.

Of course this is not always applicable, since you sometimes don't control the format you get your data.
Show HN: Pop.com – pair programming with low-latency, Screenhero-style sharing
The difference is that now they confirmed that they do search your private images.
No one is going to send gray blobs, they will be finding legal porn (like pussy close ups, tongue pics, whatever) and then disturbing it to trigger a CSAM hit.

The low res derivative will match, perhaps even closely, because pussy closeups look similar to an apple employee when its grayscale 64 by 64 pixels (remember: it's illegal for Apple to transmit CSAM, so it must be so visually degraded to the point where it's arguably not visual).

The victim will get raided, be considered a paedophile by their workplace, media, and family, and perhaps even go into jail.

The attacker in this case can be users of Pegasus unhappy with a journalist.
I don't know anyone who flushes their meds. Is this really a big issue? I thought it's mostly waste based sources.
Blue Origin Loses Top Talent to Rivals as Moon Lander Fight Continues
Congrats! That's awesome.
Genuine question: why not just use macOS without signing into iCloud?

Personally I use dropbox and my own private mail server
There’s a significant leap from implementing something server side to on the consumer handheld devices themselves. Even if it’s just similar software it is regardless much more serious.

I personally thought the unencrypted backups was enough of a death-knell as it provides everything on your phone but anything with real-time on device access is always a gold mine for surveillance hawks.
You can just say it's Karat.
Astronomers were skeptical about dark matter – until Vera Rubin came along
It's not surprising for a large company. For example, Google uses C++, Rust and Go on Fuchsia. They have Angular with Typescript and Angular with Dart. Big companies are what they are, an association of a lot of people that are all different.
See if you can transfer internally. If not, quit. I suspect that even if they're not excited about you transferring, if you're willing to quit over it, they'll make something happen.

Teams at large companies are all different (small companies, too), and the way this reads, I don't think you'll be effective with any amount of toughing it out, and it will end up being more stressful than it's worth.
I can't think of another more efficient format for tabular data that's also human readable with a simple text editor... I'm personally not retiring the CSV any time soon!
Service Invocation Performance with Dapr
I work at a fortune 500 company right now and it's regular people who do mundane office jobs. Some just happen to be programmers.

I love the boring lame talk because it gets me out of work.
Because it's not something OP or anyone can actually measure their coworkers for, so it isn't actually a metric, just a way of degrading their coworkers. To me, it says more (negatively) about OP, than it does about their coworkers.
Git 201
An established organization will work fundamentally differently from a startup. For some people, this is a hard transition to make.

If you want to actually make it work, you need to meet them halfway and assume that they know something about working in an established organization that you don't. Tossing out their institutional knowledge will likely be a case of throwing the baby out with the bath water.

This just may not be for you. After doing things a particular way, doing them a completely different way tends to be a trial by fire and most people don't want that and won't tolerate it if they don't have some personal crisis forcing the decision.

If you have other viable options that are more comfortable for you, there's no shame in pursuing those instead. If you don't, you need to spend less time feeling superior and more time trying to figure out how things actually work (as opposed to assuming your way is best in all things).
GDPR specifically excludes law enforcement so it doesn’t apply here. The sad thing is Apple was legally required to allow law enforcement to search iCloud backups before they implemented this system, so nothing fundamentally changed.

However, after this backlash you can bet other manufacturers will continue to hide what their actually doing.
If your first thought, like mine, was "Who cares? The whole point is that there will be plenty of false positives.", this is pre-image:

https://github.com/AsuharietYgvar/AppleNeuralHash2ONNX/issue...
I really love this idea. I see a lot of similarities to fitness with the idea of organizing regiments to sprints/pomodoro for generating flow. It seems like the current iteration is a conservative and accessible akin to a Planet Fitness approach, light on the pressure and celebratory of wins. I would be very interested in a Peloton approach that is focused on keeping the pace high and pushing me further. In my world, I need less discipline for vision work and more for tedious activities.
Plenty of opportunities out there. Reach out to companies that are working on things you have expertise in and contracting shops.
Sure, but if everyone is blocked from using the format consultant1 opposes because the industry wakes up one day and abandons it utterly, then consultant2 no longer has an advantage, which is why someone who would be consultant1 except that they don't want to lose business to consultant2 lobbies for it.
Little-endian is superior at the system level largely because casts between integer sizes are free. Casting a 32-bit LE value to an 8-bit value is just reinterpreting what the pointer means. This is a fairly common operation.

Big-endian is pretty much dead. I am not aware of any BE systems on sale right now outside small MIPS routers and embedded. If the Internet were designed today network byte order would probably be little-endian. New cryptographic algorithms are being designed little-endian-first.
> This is the biggest downfall of Elm projects that I’ve seen in the real world. Teams end up spending half of their time or more solving problems that could have been accomplished quickly with some off the shelf React libraries with numerous tutorials online.

This is an important point; I think it applies to varying degrees to any less popular language or framework. It’s a little worse with Elm because of the restrictions they’ve placed on JS interop. I'll add that unless you're very familiar with the framework/language you'll be using, it's pretty hard to estimate scope of work; you'll just encounter surprises during implementation along the lines of "wow I can't be believe they don't have a library for x." On the plus side, since the work of implementing these libraries is very generic with regard to any specific application, it's easy to delegate to other employees or contractors.

I’m currently working on a large PureScript project. At various times I’ve had to implement my own base libraries and components, but in many cases I’ve just been able to wrap existing JavaScript code. Some of the key libraries I use, which were developed by other community members are wrapped JavaScript libraries. This has been a pretty powerful mitigation strategy.

In the case of PureScript, I also have the benefit of reusing a substantial amount of front end code on the server. For me, on this particular project, the benefits of using a language with advanced features has far outweighed the above mentioned costs, but I think you've got to look at each situation differently and do that evaluation.
How low can their IQ be if they can solve Leetcode mediums in 30 minutes?
The Chinese already get more use of the northeastern Badakshan province than the Afghan government. They send patrols across into Afghanistan regularly. They are not necessarily viewed as helpers though, but mainly as opportunistic neighbors who won't hesitate to blur lines of control or step over boundaries to expand their own control.
Apples solution only scans photos that will be uploaded, and the results of the scan require a server side to be evaluated. The client does not know whether a match occurred.
Note that in Spain most immigration comes from Latin America, and they can get the citizenship after only two years, so they disappear from the immigration statistics quite soon.
I'm tired of the semantics, my co workers are dumb. They passed these interviews by memorizing the answers to questions, and they cant come up with useful software architecture. Everything they code is a one off solution to a one off problem.
Taking things my kid could do into the next generation. Awesome.
AI Email Tools for Salespeople
That’s a good thing.

We validate on ingestion and if there are changes upstream we can immediately triage without polluting our data warehouse.
I'm 10 years early to this party but:

Desktop: Debian + i3wm is where I landed and stayed...

If anything were to change in future it would be Debian, but I'd be taking my setup with me (few dot files), which is a nice capability to have.

This is easier if you are a developer (not an iOS developer ofc), because most work on the CLI is just so much easier on Linux. I tried The BSDs at first, various Linux distros, and ultimately settled on Debian after using Ubuntu for a while. This is an opinionated area, and no distro is perfect, but I settled on Debian due to it's ubiquity as a base for other distros and therefore familiarity and wealth of support and knowledge, but also because it's the less opinionated base you can add whatever you want to... I also like their focus on openness.

My recommendation to anyone who _likes_, (or liked) Apple desktop and UI: don't try to replace it or replicate it in Linux, you will be upset. Learn to love something else: control, and the permanence and stability it brings to your life. If you want a ready made full desktop environment they exist, KDE and GNOME, but in a way they are just another Apple, dictating and evolving how you do things with each update - It's probably easier when you first switch, but you may eventually find yourself moving towards something simpler and less shiny... less is more, they are just window decorations at the end of the day, most of it is bloat.

If you do any kind of media, video, audio, raster, vector work... I wont lie and pretend this is a comparable alternative, you will need probably need either WINE or Windows, unless you know exactly what you need and know of a well supported program for Linux, e.g blender is supposed to be a pretty good contender for the proprietary 3D packages these days. While I like Linux, I agree Inkscape and Gimp are trash compared to Photoshop... i don't even like adobe products but I've used both, and the former are an exercise in pain endurance - they are last resorts, don't expect them to replace.
Are there still plans at Google to use Fuchsia on smartphones?
Maybe they are jaded that they grinded leet code for two months only to be working on boring problems.

I’ve also worked with people who are against trying something new or take forever (thanks processes) to do simple things. It doesn’t equate with how hard the interview and gatekeeping is. People know they can coast and riding out a year or two until the bottom 10% are weeded to make a half million or more is worth it to some.

All that being said yeah the comment was a bit crass for sure.
Retiring CSV is as futile as retiring Unix pipes. It's a text format for text manipulations, and there is nothing simpler and more ubiquitous than a new-line and comma delimited table. Simplicity and flexibility has its drawbacks, but the advantages clearly outweigh those drawbacks. So, it will never retire, as long as we use text and blob filesystems that don't have interoperable structured metadata, across the board.
Postman raises $225M Series D at $5.6B valuation
In this case I suppose the real artwork is the space of all artworks that the machine is sampling from.
For transferring, I mean specifically that it is known that attacks transfer in a general sense e.g.,
https://www.usenix.org/system/files/sec19-demontis.pdf
It’s not easy in this setting due to the information asymmetry, but if someone wants to dedicate the resources it should be possible. They could get N random models and create images that fool all N.

For crowdsourcing, I mean that the crowd is a distribution network and not the attack creator (e.g., they are a self-distributing virus/“worm”). The attacker takes those images (the initial “worm” programs) and uploads them to reddit as a catchy meme for worldwide distribution. Meme sharers wouldn’t be aware that the meme has a hash collision with CP.

The entire defense of this sort of thing is obscurity (further obscured by using “magical” machine learning), since nothing is proven about how collision resistant the algorithm is. At Apple’s scale, it’s as careless as rolling your own crypto hash.
no

CSV is the A-10 warthog of data formats
Thanks for checking it out and the kind words re: the idea qnsi.

>I think there is no real accountability (I can imagine pathological procrastinator might lie that their session went well, when in reality they browsed FB).

That's a good point— a "pathological procrastinator" could definitely do that, but they'd mostly just be cheating themselves since they're not here to pretend to work for their boss. To your point though, some users have requested a way to share their screen for extra accountability, and we've even had a couple members do this with virtual cameras. At the end of the day though, we're building a community that celebrates the process and gradual progress made by time-blocking and goal-setting to do our best work, so if someone feels this way, I think the community can help them. To bring in another perspective, I'm an avid runner, and occasional cheating (course-cutting during races or faking Strava data) does happen within that community, but besides the shame of getting caught, if you're running every week with a community, cheaters will either self-select out of the community, or hopefully see the emptiness that comes with achievements they didn't earn.
"Astronomía" in Spanish, by José Comas Solá. It was a gift for me, almost 50 years ago. I think it was a little dated already.
Who's to say that the AI doesn't have intent, and makes no attempt at communication? These are certainly very philosophical questions and I would be ready to stand by the idea that first, there is possibly intent and communication here, and second, I've never heard of this narrow definition of art before. Art is art, defining it so narrowly seems strange to me.
> No, SQLite's dynamic data types would silently coerce data just like opening a CSV directly with Excel does.

SQLite's "dynamic data types" coerce data on input, not output. Once the data is in sqlite the way you wanted it, excel has no interpretation to perform, except insofar as really really wanting dates.

> The advantage of CSV is that it's as accurate as your plain text representation of your data can be.

Yeah nah.

> SQLite is not intended for data serialization. It's intended for data storage to be read back by essentially the same application in the same environment.

That's completely, absolutely, utterly, objectively, nonsensical.

Data analysis, exchange, container, and archiving, are literally all use cases listed as "appropriate uses for sqlite" in "Situations Where SQLite Works Well" on the official sqlite website: https://www.sqlite.org/whentouse.html
This is my plan:

Laptop: Framework laptop, if they start to sell it in the EU.

Phone: Currently an ASUS one (one of the very few, thats not made in Shenzen), but I'll switch to a Fairphone if it dies.