skysight-inc/HackerNews huggingface dataset:
I have implented such a work in my initial career days like 15 yrs back there i have implemented first, previous,next, last no goto page number. It works for multiple columns in the order by. The trick is to swith the order by in reverse and limit the results to page size, this way we get results in reverse orde but while returning just send them.in the reverse order....

The assumption is to include the primary key as mandatory order by at the end implicitly.

This makes a lot easy in other situations like if mulitple pages of records found with same value.. etc...
Mongo stores objects pretty much the same as PG here, a single key update requires a rewrite of the object. Maybe Mongo has some fancy algorithms to avoid full decode/reencode in some cases, but in principle the physical data formats are almost identical
OTOH, isn't there a poverty-line amount in USA that makes some income level practically tax-free (through deductions, etc.)? I imagine that in most countries $15.000 / year is a rich person's income, while in USA it puts you under "starving". What I want to say, if you're living in, say, Kazakhstan, earning a good fat paycheck of $1000 a month and living like a king, shouldn't you file "I'm starving poor at $12000" to the IRS and get zero taxes, or, perhaps, even some food stamps or something like that?

(Just guessing, I don't have experience with this)
I don’t think size 8 in light grey in the footer is conspicuous, uppercase or otherwise.
Avalanche Effect
Unexpected Bad Things Will Happen If You Don’t Read This
Sure, if you defraud people by borrowing money and promising to repay, but later reneging on that promise, you can temporarily get richer, especially if there is no justice system that can force you to repay that debt. This is the situation the US government is currently in. That can work. The problem is that once people are defrauded, the trust is lost, and you might not be able to borrow anything from them for a long time.

In fact, it’s worse: you’re not only losing trust on the bondholders whom you reneged to repay, but also most everyone else who observed it happening. You’ll be only left with people who will require handsome compensation for observably very real risk of not getting paid back.

So yes, our children will either have to repay all the debts we took, or default and lose immense amount of food will and trust that we are exploiting by borrowing at low rates. Either way, we are enriching ourselves at the expense of our children.
This is not true. Many of these accidental Americans really weren't aware of this. Why would they? They never received a US passport or any other official US documents, never lived there, didn't go to school, and had no reason to be aware of their unintended dual citizenship until the US started bugging them for taxes.

Also, renouncing this accidental citizenship is far from trivial. That requires jumping through a lot of bureaucratic hoops. They never received any benefit from it, and if they knew at all, they ignored it.

And they have no problem paying taxes, they just pay their taxes in the country in which they live and work. They don't want to have to fill in tax forms for every random country that chooses to bestow unwanted citizenship on them.

Make no mistake, the only reason this is an issue at all, is because the US is too powerful to ignore. No other country does this (except maybe Ethiopia or Eritrea, I think), and no other country would get away with this. Only the US does.

It's rather odd that for a country where so many people question Obama's citizenship, the country is so eager to claim ownership over people who don't want it.
https://www.dailydot.com/unclick/nestle-california-bottled-w...
> there is no form of errata/banning

I liked Isotropic's solution for this, which was to draft 12 cards for the board, and then each player vetoed one.

You could also set a ban list. IIRC just about everyone had Possession on theirs.
Pick one: https://en.wikipedia.org/wiki/Nestlé#Controversy_and_critici...
The $100k you're referring to is the Foreign Earned Income Exclusion [1]. If you're an American working abroad, you don't need to pay income tax on your first $107,600. The exclusion does not apply to self-employment tax or investment income.

That's not even the real problem, though. The problem is that banks don't want to deal with the FATCA compliance issues and just refuse to deal with Americans, period. I've experienced this firsthand as an American expat and it is a colossal pain in the ass.

[1] https://www.irs.gov/individuals/international-taxpayers/fore...
That makes sense thank you! It's easy to conflate the concept/problem with the tool as an outsider.
It’s a low key signal I look for when interviewing candidates: when it’s clear they don’t know something do they say so? Or pretend they do
https://en.m.wikipedia.org/wiki/Nestl%C3%A9 - scroll to the controversy section
Already happened under our current system. Can't imagine how extreme the problem would be if it could affect the global outcome.

> the most extreme case was in South Carolina, where an impossible 101 percent of all eligible voters in the state had their votes counted

https://en.wikipedia.org/wiki/1876_United_States_presidentia...
Considering the Dutch created modern slavery and the modern concept of destroying entire cultures for profit via passive capital investment, I’m not sure the Dutch are great shepherds either.
That's accurate. It was a known concern going into the trials. Enough so that the Russian Sputnik V vaccine purposely used a different adenovirus in the first dose and the second dose and appears to have about 92% efficacy rate. I believe Oxford is also planning on running a trial using a mix of the Oxford and Spuknik vaccines to see if it improves efficacy.
It's not easy to renounce American citizenship. The US considers itself entitled to taxes from citizens who live in other countries. Even if they haven't been to the US since they were a baby. If you want to renounce citizenship you have to pay up.
Yes, I could have. But I didn't. Oh well.
Likely a reference to this 1974 report/investigation into Nestle pretty much intentionally giving mothers in developing countries free breast milk substitute, marketing it as superior to the real thing, then charging money for it once they’ve left the hospital and their own milk has dried up: http://archive.babymilkaction.org/pdfs/babykiller.pdf
Seems like buying into the stock market is a better insurance policy against inflation since you're tracking the actual economy

No. Stocks are hitting all time highs due to the Fed printing trillions of dollars while unemployment continues to soar.

Many people are facing food scarcity and people are in food lines that stretch for miles. Nothing about the stock market right now has anything to do with the actual economy.
I agree with your claim. I also believe many to see “free will”/consciousness/etc as that certain je ne sais quoi that separates the human experience from that of computers:

∀ x ∈ <free will definitions>, Has(x, humans) ≡ ~Has(x, AI)

For these to both be true, <free will definitions> becomes empty. Thus I argue we have none. Edit, or rather it’s meaningless to argue if we have any or not, as it cannot be defined.
heal thyself, physician
> I am not sure where in the 47 pages you are reading that

From the document: "An added benefit of the increase in electronic payments is the reduction of shadow economy. Each year trillions of Euro flow in the shadow market unregulated and untaxed, leading to long term deficits. Traceability of electronic payments is much better than with cash, leading to more information on the flow of money. This information can be used to reduce tax evasion and make regulation easier, in turn reducing the shadow economy"

> It should also be said that this report is not made by the european union, but for the european union by a 3rd party that got paid to make research for them.

Signature right on the front page: "Policy Department for Economic, Scientific and Quality of Life Policies Directorate-General for Internal Policies."

This "third-party document" shit is a really embarrassing excuse. Can't the EU apologists think of something better?

Maybe someone external cooperated on that document - but it's still a document by the EU and for the EU just like any other, authored and published by a department of the Directorate-General for Internal Policies of the EU. I am sure they wouldn't have signed and published it if they disagreed with the content (or at least would have said so). You wouldn't try to claim that a law/regulation written by an external lawyer and published by the EU is actually not an EU document, right? Because there is a lot of that, e.g. the GDPR.

From the document: "The study lays out predictions for digital services in the next one to ten years and provides recommendations for action for the European Parliament in preparation for the Digital Services Act. This document was provided by the Policy Department for Economic, Scientific and Quality of Life Policies at the request of the committee on the Internal Market and Consumer Protection."

Anyways, this document is one of many, it's just the first I had a link to. The same points (and other, even more concerning ones) are made in many more.

> "such as democratic values, data protection, data accessibility, transparency and user friendliness."

Sure, just like the encryption backdoors are for the children, for the democracy and especially for transparency. Take these democratic values with you, I am not interested. The EU is really efficient in showing us why is democracy wrong.
Can you mention what you've tried so far? I'm happy with borgbackup, but I don't know if it matches your bullet points.

Still, I'd be surprised if mainstream backup solutions corrupt your backups in case of sleep / disconnect. That would be a pretty big bug. Borgbackup also handles resumes IIRC. Your third point is unclear, you'd have to try in practice. But if throughput * time awake < size of compressed deduplicated data, you obviously cannot expect your backup to complete. I guess you just rephrased your second point.

For the last point, personally I think I'd take care of mobile hotspots / slow networks with a script wrapper rather than expecting the backup software to handle this.
> Sorry, but there is no way in hell a European wouldn't know they have dual citizenship by being born in the U.S. And there's no way they wouldn't have renounced it in all this time

Wrong on both counts. I know two people who fall under the category you deem "no way in hell"
Helpful, puts "my hovercraft is full of eels" in historical context.
P.S. For those interested in the origin of that phrase, https://en.wikipedia.org/wiki/Dirty_Hungarian_Phrasebook
How bad's the delay on live p2p? I'd be surprised to hear it getting below 10s and picture it more at 30

This is not a dig at Peertube, they're doing truly great work. My use case is probably different
DNA assembly standards: Setting the low-level programming code for biotechnology
If you become a US citizen you have to file yearly IRS tax returns, calculate and pay taxes. There is no getting around this, it does not matter where you live.

The US has bilateral tax agreements with certain countries to avoid double taxation. So if you happen to be in one of these countries, you will normally pay taxes to your host country and if those are greater than the taxes owed to the US (which in many cases they will be), your US tax will be zero. You still have to file the US tax return and you still need to pay taxes on income derived in the US (such as dividends and interest) as that can not be eliminated by foreign taxes.
Yeah, I was surprised the article completely glossed over why nobody outside the US wants to deal with FATCA, because on face value it sounded like a good tool to prevent money laundering and tax haven stashing.

But based on FATCA, only the other countries have a responsibility of reporting wealth information about US citizens, while if you are a Russian or a Brit or whatever you can safely stash all your wealth in the US if the tax regime is more lenient than your own country.
This may have downsides, especially with first simple words that come to mind (like in “everything is X” or “this is <adjective>”). Words turn ideas into a network of associative meanings that already exist and may fix them in stone once you get used to it. This happened to me many times so I got a habit of asking a lot of questions first rather than verbalizing ideas asap, and then using handmade verbs/adjs/nouns to describe thin differences.

As a russian classic said, feelings and emotions turned into words lose their power. Like a deep overwhelming emotion if analyzed and verbalized may turn into “I like her feet” if you didn’t use/know approriate terms or concepts before.
While I don't like that warmongering nation any more than you do, in this case, it is not a secret that people's citizenship can be affected by where they are born, their parents' citizenship etc.

So, if anything, their parents are to blame and not these folks who had no choice in the matter.
The accompanying talk by Richard I Cook at the O'Reilly Velocity conference is here:

https://www.youtube.com/watch?v=2S0k12uZR14

When I worked in operations, I would watch this talk every couple of months to remind myself of the principles. The principles are summarized in the list, but the talk adds a bit more context. I find that this context matters for seeing how the principles might be applied.
In Iran, you have to first finish your military service, currently 2 years, then apply to the president's office, which (almost?) never approves an application anyway.
Dropping alcohol
Show HN: Soul Provider – Internet radio for those who like to groove
First-to-invent isn't guaranteed to succeed (your criticism) but "first to get it right" (your counter-truism) is also not a truism. After all, what is "right" and what is the "first" "right" in [anything]? Certainly there's no permanent guarantee to being first, but neither is being first-improver.
This is the stance that GDPR takes.
You could take this idea further by fully parsing queries according to the grammar of the SQL language, rather than using simple pattern matching.

In fact it is a result of theoretical computer science that you _cannot_ correctly parse languages like SQL, HTML, Python, etc. with regular expressions: Any attempt to do anything non-trivial will have cases where it misunderstands the code.

So you would want to find a SQL grammar (an outdated example in [1]) and a module[2] that can use this to parse queries into a data structure to which you can apply transformations (e.g., changing case of keyword tokens) and then write back out as a string.

SQLite's documentation has some nice diagrams[3] to get an idea for how it parses a query string. The table of links at the top lets you dive into, e.g., all the optional parts of a SELECT statement.

1: https://ronsavage.github.io/SQL/sql-92.bnf.html

2: https://tomassetti.me/parsing-in-python/

3: https://sqlite.org/lang.html
Is the Roth 401k also then a tax shelter if your tax residency is elsewhere?
I think you’re being a bit unfair. Certainly there will be some like you suggest but a lot that just never thought about it or as the article says couldn’t spend the money to renounce it: “in part because the fees to relinquish American citizenship jumped in 2014 from $450 to $2,350, a sum many U.S.-born people could not afford to pay.” Note when you renounce your US citizenship (as I understand it) you may also be required to pay capital gains on what you own as if you sold it at that time, the rules around this are a little complicated. So imagine you live abroad since you’re a baby, don’t speak English, don’t have a US passport, and now you have to pay thousands in fees and maybe tens or hundreds of thousands in one time tax to the US government to be free from their dragnet, plus met a bunch of legal requirements about having filed your tax returns for past years etc.

I can definitely see a lot of people would just ignore that problem thinking it’s US overreach and they are a citizen of a sovereign country, then low and behold one day it catches up with them at their bank.
Soul Provider is my long-running passion project which revolves around sharing R&B/soul music with my friends and family. After experimenting with many different platforms and formats, I decided to focus my efforts on an online radio platform of my own creation where I am free to express myself without the restrictions and limitations of FB, IG, Twitter, SoundCloud, etc.

If you're interested in the source code, the repository is public on my GitHub (see my profile). Happy to answer any questions about the site. Would love to hear what you think :)
> Yes, this is a remarkable pain to learn and administer, but it's all possible to do without paying thousands in ongoing accountant and lawyer fees.

Where does someone begin this process? A few starting points would be appreciated.
They have been through an endless number of scandals and are one of the most boycotted companies in the world. Child labor, baby formula scandals, water rights, pollution, corruption, tainted food, price fixing, and general promotion of unhealthy food.
It’s a Small World After All: Chinese Influence in America
Ethics Lesson May Hold Outside the Classroom
Ask HN: How can I (a developer) start learning biology? Specifically genetics
I would like to start learning biology, especially get to the genetics. How should I start?
>That's basically true for any game where there's a wide range of possible skill levels.

In the last few years I've gotten a lot of enjoyment out of collaborative board games. 5 Minute Dungeon is more fun than it has any right to be. My family really enjoyed Pandemic. Haven't tried Gloomhaven but it seems fun as well.

Then there's the whole style of DnD types games, even if they're a bit different.
Let me check my historical correlation between massive margin borrowing and subsequent stock market prices ...
I wrote a coule of small CLI tools in Ruby. I really liked how a single line could do a lot of work and those fancy syntax sugars. But I found it difficult to work with due to bad code completion suggestions in IDEs and overall poor documentation.

I never knew what objects a function could return without reading the code or trying to call it first and inspecting the response.

Then I switched to Go and Python and found those best-suited for all my needs.
Similar Readings:

* "Reverse Engineering the source code of the BioNTech/Pfizer SARS-CoV-2 Vaccine" https://berthub.eu/articles/posts/reverse-engineering-source...
Because the Fed measures inflation by CPI. The price of gas and groceries. Nothing makes for a more unstable economy than a working class who can't afford food and mobility.
S3 has no https and unsatisfactory performance.

My website used to be in an S3 bucket, I was unhappy with it.
>"commercial banks invest my money on my behalf without me having any control over the process"

This is completely wrong. Your money on your bank account doesn't exist. What you see is the number of dollars the bank owes you. Its a debt. They dont invest your money anywhere. It doesn't exist. When someone transfers "money" to you the bank subtractions debt from their account and adds it to yours. Its still the same debt they just owe it to someone else now. If they give you credit for example because you want to build a house. They create the credit out of thin air by putting the house on the balance sheet so they can give out credit worth as much as the house. You pay it back and the house is yours you dont pay and the house goes to the bank. Your own money is used first so the house is allays worth more than what the bank credited at any point in time. Nowhere does the bank need someone else's money to give you that credit.
> If I end up going back to the country I was born in and leave the US what benefit do I have as a US citizen?

You have a benefit of a right to return to the country of your citizenship and to live there. You also still could vote in a country of your citizenship even if living outside (not sure how that fit in US federal setup).
As a thought experiment: How would you solve those problems with your hands tied behind your back (i.e. you don't have a government to rely on)? Just try one - assume you're in a fictional universe and writing a novel or something.

Anywho, the problem with this trail of discussion is that you can come up with an infinite amount of "problems" and libertarians can likewise come up with a "solution" to each one. However your rebuttal would always be yet-another problem because the original "solution" didn't cater for some arbitrary corner case or something basic that you assume can only come from a society with a government.

E.g. "Your customers randomly decide to not pay you. That's also OK."

Answer: Have an escrow organization that both parties trust. Rebuttal: "Your escrow organization decides it doesn't like a certain legitimate business and won't accept your trade." Or "Your escrow organization's owner is buddy-buddy with your customer and he decides to not keep their part of the bargain". Okay - "contracts", followed with "but who will enforce the contracts", etc etc.

As a side note: A lot of the time libertarians and anarcho-capitalists don't "pick" lack of regulation out of practicality, but rather out of plain moral principle. A lot of what is considered "regulation" and "rule of law", when stripped of it's noble/protective aura, is just authoritarianism and bully-like behavior.
It is interesting how much press Facebook constantly gets for 'profiting off of hate', but yet I never see Twitter and others mentioned in this light nearly as often, let alone any media organization.

Regardless of how good their policies are (or aren't), it's vastly under-appreciated how difficult it is to enact policies when your users are measured in the billions and single moderation mistakes often get you a lot of heat and make you even more enemies. Meanwhile every government, special interest group, think tank, political party, and so on, are constantly pressuring you with large-scale public campaigns to change your policies in various ways to benefit them.

It's truly a mess that I hope we develop better frameworks for in the future, because the current one seems to be entering some pretty bad areas for everyone involved (And I mean everyone - even Facebook does not want to be the moderator here, because they realize it is an unwinnable position that makes them more enemies).
In most countries, you do have to pay for government services. Renouncing citizenship is not a trivial thing and of course most countries would have some fee associated with it.

One could claim "I have never been there since I was an infant" but it falls on the people rendering the service to verify the facts.

I can see why people are upset (and I don't like the warmongering nation) but many of these complaints are not really well considered in my view.
Honestly, after ignoring these two letters he was _begging_ the FAA to make an example of him. Fine him $500 after two stern warnings? That's a good way to make sure that absolutely no one will heed any of your warnings in the future. I don't see anything totalitarian about it. I wonder, is GP by any chance a libertarian? The man is getting his just deserts, and that's all there is to it.
I very much feel the same way. Unfortunately it is not easy to move to another country long term and work there. Also obviously every other country also has its own issues, many that one likely wouldnt discover until after making a move.
Are you saying a name change might be the way out of this?
The way I interpret DKE is that low level people don’t (yet) know what they don’t know.

One thing that I think often gets skipped over in discussions on Imposter Syndrome is that imposters DO exist (that’s kind of why we use interviews when hiring people).
Hard to decide how much is too much.. the hard (and interesting) part of language is in the long tail