skysight-inc/HackerNews huggingface dataset:
Ask HN: Help me help my young developer make my site better and gain some users
Hi all,

I used an external dev to create a website that solves my own problem. It works for me, but I hope it could also be useful to others.

It is a search engine and aggregator of equity crowdfunding deals (www.hellosharky.com) plus some tools to score the startups.

I am a finance guy and by looking at it, I feel it can look better. My programmer is a young guy in India and he does exactly what I tell him to do, but doesn't offer any technical suggestions or alternative ideas to improve the functionality.

One example: the central functionality is search which should allow a user to enter any (ideally) reasonable keyword and instantly see all relevant startups. I tried to think of how it should produce the best result so I decided to manually tag every startup so that it better matches what people type. This approach kind of works for now, but I assume it is a very inefficient way of doing it at scale.

He is a good guy and I am sure we can do things much more efficiently.

I would very much appreciate any feedback on both the product and the tech so I can give him better guidance and ideas.

Thanks much.
care to explain what is Brave and what is FLoC?
I did not write The Goal ;)
Microsoft Researchers Claim Entire Universe Is a Machine-Learning Algorithm
Dressing in black (blackshirts), marching down the streets, beating the perceivably "wrong" thinking civilians, demanding end of democracy, suppressing free speech, etc.
When half of America sees a fascist under every rock, but doesn't even know anything about real fascist and fascism from history books.
Imagine if instead the same number of people would consume heroine or LSD or other similar drugs at that level, as several people here are advocating for.
Do you think that the human race would have any chance of survival?
> likely the chemicals rather than the tobacco

Everything is "chemicals".

> somewhere over a pack a week was habit forming

Try three packs a day

> I've drank lots,

Probably not, compared with someone (such as me) that does drink lots.

> I've taken to consuming a bottle of red per week ... I also have a couple cups of coffee throughout the day

Careful there!

My point is that different people have wildly different ideas about what is acceptable, damaging and addictive, and their ability to deal with it, in one way or another. I easily managed to give up cigarettes because my girlfriend said she would leave me if I didn't. She gave up alcohol (which she was a heavy user of) when she became pregnant (not by me), which is something I know I will never be able to do.
There is no lower limit for alcohol being neurotoxic, which my asian engineering teachers were always careful to remind us when teaching fermentation process design. Not noticing the minor amount it causes doesn't mean it isn't slowly happening.
there is a reasonable middle ground between "absolutely every business must accept physical cash" and "physical cash no longer exists".

places that do a lot of cash business will naturally continue to accept cash as long as it exists. several business I patronize only accept cash. it's not some colossal injustice if the fancy coffee shop is plastic-only.
Like naming variables, choose better names for your table aliases, then.
I've come to the same conclusion, that it's easier and more profitable to create and sell your own application than to do the hiring song and dance, especially in the long term.
I only buy Android One phones now. Monthly security updates for several years, guaranteed. Pretty stock Android, too.

Great? Perhaps not. But much better than the phones manufacturers just dump onto the market and then forget about.
Do they compare it against wine with the ethanol removed?
The cynicism here is tiresome. Akon has done a lot of good for Africa, a place which is plagued by lack of access to financial systems. I hope his project works well.
You can easily add remove columns like this, just removing the entire line. If you add the comma the traditional way, you will change 2 lines (the end of previous line with comma, and the new line). It's nice for maintenance and diff'ing
>"real world skills" is a nebulous concept. What counts as a "real world skill" and what doesn't?

Got a sprain? Call a doctor. Leaking pipe? Call a plumber. Doesn't seem nebulous at all.
Conversely, speculation and greed ruining the world? Call on the populace to bail them out. Speculation doesn't build or fix physical stuff.

>You mean some sort of planned economy? Those have not worked well historically.

Because historically it has been done on inferior computers. Whereas now we have the computing power to calculate the economy n-times over. Dr. Paul Cockshott on Cybersocialism: https://www.youtube.com/watch?v=LtlZys7QOO4.
That being said, I'm sceptical as well; the video leaves many things unanswered which he expands on in his books that I have yet to read. However, I welcome any ideas on how to detach humans from having to deal with money, so we can collectively pursue more lofty goals, beyond profit.
Good article, but, IMO, wrong conclusion.

Instead of “In short, RAPM has made me appreciate the importance of asking, before all else – how can my actions most positively contribute to whatever I am trying to achieve.”, I think that should be “whatever we are trying to achieve”.

Isn’t the message that some of those high-scoring/high blocking players do better for themselves than for the team?

That player who rarely blocks a shot because opponents do not dare try shooting will be less famous and, likely, less well paid than the star who makes the spectacular dunks, even if that slightly increases the risk of failing to score.
I mean, I think amazon does a good job. Google too, Microsoft gets some points too.
From the Akoin white paper:

>Akoin has chosen to only issue 10% of tokens in this public sale. To accomplish this, the remaining token supply will be used to drive adoption amongst merchants/vendors and to bring value to the platform. The total supply of Akoin will be released over the course of 4 years, with 39.41% released after 12 months, 70.12% released after 24 months, 87.25% after 36 months, and 100% at 48 months. This is subject to change with Escrow tokens being placed back into Escrow if they are not needed in the month they are released.Each token allocation is subject to vesting and lock-up periods except for Public Sale tokens which are available immediately.

This sounds sketchy as hell.
Thanks for the pointer to :split +term - I just dug through all of :help terminal. Apparently this is a feature from Vim 8.1 that I had completely missed!
In the US, I recall the ringing sound for the caller being different depending on who you were calling. I understood it to be generate by the remote station, powering their ringer via the line. Presumably you could still get different ring counts in such a setup if one side hasn't been connected to the call yet.
For those who like me wonder what is FLoC : https://github.com/WICG/floc
Quoting https://en.wikipedia.org/wiki/Brave_(web_browser) :

> Brave is a free and open-source web browser developed by Brave Software, Inc. based on the Chromium web browser. It blocks ads and website trackers, and provides a way for users to send cryptocurrency contributions in the form of Basic Attention Tokens to websites and content creators along with the ability to keep the cryptocurrency they earned.

Quoting https://amifloced.org/ :

> Third-party cookies are the technology that powers much of the surveillance-advertising business today. But cookies are on their way out, and Google is trying to design a way for advertisers to keep targeting users based on their web browsing once cookies are gone. It's come up with FLoC.

> FLoC runs in your browser. It uses your browsing history from the past week to assign you to a group with other "similar" people around the world. Each group receives a label, called a FLoC ID, which is supposed to capture meaningful information about your habits and interests. FLoC then displays this label to everyone you interact with on the web.
That's a really interesting thought. I think it would be worth seeing if OGR/GDAL can be ported to wasm.

Next would be GRASS.

JSTS is pure JS and does a lot of vector GIS fine.

I think those three things and a decent UI would be an absolutely killer Web app for the general public to do more GIS.
Neat. For some reason I find it satisfying to read an example like that where there's actual real tangible work being done with immediate and obvious benefits.
> The Medallion fund is a whole other kettle of fish.

It should be noted that while markets may be mostly efficient, I do not think anyone is claiming they are completely efficient.

If there are price discrepancies/anomalies, they could be exploited, at least some of the time. It could be that Medallion can find some and exploit them, say, 55% of the time. But over a large volume of transactions.

Casinos make huge profits by exploit small house edges in volume:

* https://wizardofodds.com/gambling/house-edge/

There's a reason why Medallion has been closed for years: the (possible) market inefficiency exploits they're using may not scale.
Are you talking about driver signing?
As a liberal, my biggest fear is people embracing the ridiculous woke nonsense in articles like this.
I don’t think I have ever seen that way of doing an inner join in the wild, despite working as a DBA or data engineer for the past 15 years, 10 of those Postgres-only roles.
some banks have a minimum age for authorized users of a card (usually 13 or 16). some don't have this requirement.
> I have noticed

The extremes, the noisy, stereotypes and what media like to focus on get noticed. The rest of us in the 90% who just have a little bit with a meal occasionally never get noticed. So comparisons between countries and cultures has more to do with perception than statistics.
Sorry to rain on your parade, but there is nothing in that article that is not included in the basic SQL manuals like Itzik Ben-Gan's.

Also a few things are dead wrong: the "make the haystack small" is optimization (it should be at the end, as the first rule says), the "prefer UNION ALL to UNION" is missing the context (a good dev knows what is needed, not what to prefer) and the usage of CTEs is nice, but sometimes slower that other options and in SQL slower can easily be orders of magnitude, so nice is not enough. Same for 'avoid sorting where possible, especially in subqueries' or "use composite indexes" (really? it's a basic thing, not a best practice).

In the past few months I interviewed and hired several DBAs, this list is ok-ish for a junior but a fail for a senior. I am not working for FAANG, so the bar is pretty low, this article would not even pass for a junior there.
Yes... the comment above is describing a way to evade such laws, used by food trucks. But I've never seen such that workaround in action, hence my question.
Agreed. Actually even the openlink virtuoso database project is kind of using the RDBMS approach in its underlying implementation. https://en.wikipedia.org/wiki/Virtuoso_Universal_Server

However part of the power of the graph database that utilising a linked dataset such as RDFs is that you will be able to use SPARQL to query the graphs, which is more suitable for sets / graphs.
Brave [0] is a web browser, built from Chromium, but with built in ad and tracker blocking.

FLoC stands for Federated Learning of Cohorts. The third party cookie is dying, and FLoC is a way for companies to group people together and track them, rather than tracking individuals. Here's more info about that [1] and here's an EFF article about why it's dangerous [2].

[0] https://brave.com/
[1] https://github.com/WICG/floc
[2] https://www.eff.org/deeplinks/2021/03/googles-floc-terrible-...
Financial industry preps for proposal that requires 36-hour breach notification
Lol, facts. Hopefully it wasn't important though.
I don't know, I have seen a lot of pro LSD and psilocybin mushroom micro-dosing posts and comments. I think this place still has a generally libertarian ethos and most people think of drugs questions as best sorted out by a rational market. (My own take is different from that, fwiw).

> Prevailing opinion of HN comments seems to be getting a lil stupid for fun is Bad.

That part might be true. I think there's a tendency to be a little robotic/scientistic/productivist about...just about every topic.
Found this thought provoking:

"[...] immutable smart contracts that spread wealth in proportion to the number of people, accounting for basic needs and disproportionate wealth disparities? But even then I'd suppose blockchain wouldn't be the most efficient way to do it."

Edit: Or, maybe, it would?
I find the graph that others link to [1] to be confusing at best. It seems to be tabulating *absolute harm* over all users. So if a substance has many users, it has more total harm. But then the substances are ranked in a way that seems to imply the intrinsic danger of it all by itself. Thus alcohol may cause more damage on a national level than crack cocaine. But tracking the lives of 1 user of alcohol vs 1 user of crack cocaine would show, IMHO, the cocaine use to lead to more problems.

A similar analogy would be to compare the relative danger of automobiles to atomic bombs.

[1] https://www.economist.com/graphic-detail/2019/06/25/what-is-...
Which is why I put it in scare quotes since they’re not charitable donations that have special status. They’re just regular purchases but with nothing attached to them — “pay what you want”, “support development”, “buy me a coffee.”

Google and Apple (for now) say that this is just normal app revenue.
FLoC stands for Federated Learning of Cohorts which aims to target advertising better without it directly relying on singularly personal information.

https://web.dev/floc/

FLoC enables ad selection without sharing the browsing behaviour of individual users.

FLoC provides a privacy-preserving mechanism for interest-based ad selection.

As a user moves around the web, their browser uses the FLoC algorithm to work out its "interest cohort", which will be the same for thousands of browsers with a similar recent browsing history. The browser recalculates its cohort periodically, on the user's device, without sharing individual browsing data with the browser vendor or anyone else.

https://www.chromium.org/Home/chromium-privacy/privacy-sandb...
FLoC is a way to make Google's ad network's targeting worth comparatively more than other ad networks'.

Brave is an other ad network.
It's actually just a long-con truth test to easily catch any false-positives that got through the process ;)
Yup, and it took a long time for journalism to describe Trump's falsehoods as lies because they merely thought him dumb or misinformed. It took a while for it to become apparent that he knew what he was saying was not true and that the correct term was that he was lying...
I disagree. My dumb detectors started false positives after just a few years. Their mute/silence buttons didn't work so burnt toast meant two minutes of screeching. No options for remote alerts (without external smart hardware). Batteries would only fail at night even after a few years. Or dust? Or carbon monoxide? Never knew, because the beeps were a terrible form of communication.

Smoke detectors SHOULD have some safe, reliable smart technology. All my Protects have outlasted the simple Kiddes.
Fortunately not, otherwise you wouldn't have been able to provide us with this submission :)
Readability is weird heh, I'm exactly the opposite. For me long lines become a blur, so better to have a short alias.
The difficult thing about talking about project management is that it is so inconsistent at different organizations that makes it impossible to talk about it without having a lot of context.

I worked at companies where project managers had very strong technical background and experience, but I also worked at a company where project managers were only a little technical, but had very strong project management skills. Then there is the other end of the spectrum, where project managers are simply incompetence. They got promoted to become a project manager with almost no knowledge about it and also no willingness to learn it properly and become good at it.

The latter (incompetence PM) is awful for any type of engineering work. And some companies make it even worse by making engineers report directly to those project managers.

The first type (technical project manager) is obviously harder to build, because not many engineers want to become project managers, and not many engineering teams are able to navigate without a good product team in organizations that don't have a solid engineering culture (e.g. traditional companies). So you often find companies with the second type. And even then I think it’s best if there is a clear separation of concerns between product and development teams. A product manager/team that takes care of product concerns but not engineers themselves. While they work with each other, engineers should report directly to a technical lead that understands their efforts and needs.
Brave claims to be a privacy oriented web browser. It is apparently based on Chromium and someone identified a Chromium feature that was phoning home (I.e. Google servers) with some informations reducing user anonimity
(At least that's what I understood from a quick look)
Still amazing to be living at a time when a non-fiction article starts with "Mars helicopter"
Brave is a web browser, and I found this in the code: federated_learning::kFederatedLearningOfCohorts, I suppose that's what FLoC stands for.
It’s not about logic, it’s about entrenched interests and deeply engrained belief systems of those in power.

This is not crazy. The system is doing exactly as one would expect based on how it’s structured.
> SOP is a solution to a browser-specific security issue.

Indeed, it is, but in my opinion a pretty bad one as it causes a lot of collateral damage. Instead, they should just use the (cookie) state from the origin that initiates the request instead of the origin that receives the request. AFAIK, that should have solved the security issue much more precisely. But now we have to live with the SOP+CORS in the web based world :-/
It's not a gimbal, it's a set of stepper motors and gears. It's not designed for constant movement or tracking. The current starlink terminal is a dual beamforming phased array that will align itself to have its flat face oriented towards the area above you that has the highest simultaneous density of satellites at any given point in time. Beta terminals in north WA state, for example, are angled about 10 degrees off flat, looking slightly north.

In fact a current starlink terminal (which has a 6-axis sensor and GPS receiver built into it) will turn itself off if it detects movement. The terminals for things like yachts are not available to the public yet, though I have no doubt they're in the works.
RC Cars and Electronics
Minneapolis/St. Paul.
That is only true of the first or last line.

col1,
col2,
col3

col1
,col2
,col3

You can remove col2 from either of those examples and have valid syntax.
Software development is research work.

If you take processes from people who build machines and apply them to software, it will fail. Software means inventing machines.
I am basing my observations on firsthand experience, not media impressions.
Is there any evidence behind the idea that FLoC is more privacy-preserving than third-party cookies? Intuitively that is not obvious to me at all, especially given there are so many other fingerprinting techniques it could be combined with.
I don't have a problem - I don't use bash unless its few lines or absolute must.

Its disaster because launching process to achieve simple math expression is just ridiculous, besides being slow and besides having to terminate it with ;. Its wrong on so many levels I don't even know where to start, they must have been smoking some nasty things back in time.
Most users don't receive timely push notifications when an email is received. Especially in the case of Gmail, which is the most popular email provider with Android users, since they employ an algorithm to automatically categorize emails in categories such as "promotions" and "updates" - which causes those emails to not trigger a notification.
> You'll note that, while 'there are many restrictions,' there is no outright federal ban on tobacco advertising--were it possible, why not do it?

Not super familiar with specifics around the restrictions because I can't remember the last time I saw a ad for tobacco; meanwhile I have seen 10+ alcohol ads today. I would say the restrictions effectively ban tobacco advertising

I agree with your point; from skimming Wikipedia [1] I would argue that restrictions were gradually imposed through acts of Congress and I would imagine largely uncontested by Big Tobacco because they lacked leverage due to the series of scandals involving them. I think you are right that the major alcohol brands would fight back largely because they don't have their hands behinds their back

[1] https://en.wikipedia.org/wiki/Regulation_of_nicotine_marketi...
You may have missed something important, which is you should have some ideal portfolio balance in mind when purchasing. This forces you to “buy low and sell high” in that you buy whatever you need to to bring your percentages in line with you’re ideal. This is the only strategy I’ve seen that provably beats the market (and it’s been a while since I saw the paper talking about this, may be that it only beats the market in terms of total risk adjusted returns, and not total dollars returned).

Edit: also it’s important that you’re asset portfolio has asset classes that tend to be out of phase, like stocks vs bonds.
It's not necessarily better from that perspective; it's a much smaller+simpler tool, and it solves some of the same problems in a different way. But if tmux works for you and you're not on a suckless binge, dvtm probably won't be appealing.
To a first approximation, no one is looking at employment gaps at that level of granularity. Now if you can't find a job for another year, that's maybe something different but you're back to switching jobs without really having a job.
Maintaining Connection with Co-Workers Through a Pandemic
These are really useful. Thanks.
“Wow” for some US-citizens, “whew” for the rest of the world.

“Only a few countries recognize an individual right to keep and bear arms and protect it constitutionally, with more classifying it as a statutory privilege granted to some segment of the population.” —https://en.wikipedia.org/wiki/Right_to_keep_and_bear_arms
It's useful when you're not running under X, or for folks who want to tile terminals but not run a tiling window manager.
I'd ask you to expand on this but I'm not sure I'd care for the answer. If you're judging me because I wouldn't want to hire folks who can't work with women, you may need some self reflection.
We are doing something very similar, except we add extra indentation to the joins like you did for the second condition in the WHERE. This is because we strongly separate each block - SELECT, FROM, WHERE, <ORDER>, so everything that is in the FROM block is indented. Same for the SELECT if it so long it goes to a second or third row.
New research reveals how long it takes for cannabis impairment to subside
You can't use FLoC ID for fingerprinting, it changes continuously.
I don't think I've seen any blogs produce such consistently good content recently. (No insult intended to any other blog writers. I'm not aware of all blogs, and would love to hear about more with this level of quality.)