skysight-inc/HackerNews huggingface dataset:
> There is no world where it makes more sense to write a copy of everything you do into an "everything I did" table, than it does to use an append-only / immutable / log-centric DBMS (where "Postgres with an ETL pipeline pointed at its WAL logs" is a rather hacky immutable DBMS.)

There is one: the world where append-only / immutable / log-centric DBMS do not offer the same advantages as mainstream RDBMSs - scalability, stability, performance, language support, open sourcing, active development, ubiquitous SQL knowledge, etc. etc.

The downside of bolting an event-sourcing or changelog system onto an established RDBMS like Postgres are (a) the cost of writing them, and (b) the performance / disk space cost. Both of those may be easier to deal with than, say, Datomic's licensing and Clojure-oriented APIs, especially if you can use an existing library like Marten.

What immutable DBMS would you recommend?
I was talking about the way to do it before. You could create a NULL-able column, add the default in batches, add the default/make it non-NULL-able. But, the last part took some time (not in the range of ms) for large tables.
Thank you for considering the needs of people who speak non-LTR languages, like Arabic. I'm excited that bidirectional text support is in the roadmap!
> No, I understand you mean "somebody might build" - but so far, nobody did.

there are plenty of products on top of bitcoin. but i guess it's important for you to believe that there are none?

> Sure. How many of them are necessary to a typical credit card/cash user?

gee, i don't know, what do you think, does typical credit card/cash user do this thing called "transacting with other people"? sigh.

> You seem to be under impression dispute resolution is a technical problem in search of suitable algorithm

when you're not sure it's wise to ask rather than to make assumptions.

> if the middle-man can't reverse transaction, what prevents me from selling you an iphone, sending a brick instead and leaving with the money

what prevents you is smart application of cryptography. maybe you should inform yourself on the topic before arguing? https://en.bitcoin.it/wiki/Multisignature#Multisignature_App...

> feds close it after a month because it is being used to trade drugs

quick, somebody tell feds most of drug deals are done in USD, make them close USD!

this is depressing.
A small survey about agile methods
Also I think when you have enough karma, you can flag comments for review.

Yep, but the option is hidden away. You have to click on the comment time to view it first.
Maps of subjective feelings
>Bikes are expensive personal transportation

Not true in the Netherlands.

>they take up space in every home with muddy, oily mechanisms

Usually, unless it's a very nice cycle at high risk of theft, it's not kept in one's home. It's just locked up outside. Bike garages are exceedingly common, especially in larger buildings or offices. Or at train stations.

>they take up a lot of space in bicycle parks outside every desirable destination serving to push everything further apart for humans on foot

Bike parking is an issue, especially in high congestion areas like train stations, but pushing things further for humans is most certainly not an issue in the Netherlands.

>they require equipment you might need to carry (locks, helmets, other)

Almost no one wears helmets in the NL in daily cycling and the locks are fixed to the bike or wrapped around the frame. This is really a non-issue in the NL.

>they need ongoing maintenance

Not much...and so do humans (you've still got to take care of yourself; even biking contributes to that).

> they don't go well with nice clothes and tend to require places to change, carrying a change of clothes, or even showers, after any but short journeys in mellow weather.

Most of the year the weather is mellow; people routinely wear suits/formal clothing without issue on bikes; many offices have shower facilities but most people don't use them because the weather is mild and people don't race. All of this isn't really an issue in the Netherlands.

I feel like you've posed a lot of complaints that really don't apply or really aren't such a concern in the Netherlands. Cities here tend to work very well for both pedestrians and cyclists.

Come visit the NL sometime...I think ít will change your perspective.
UK aid brings together experts to predict where cholera will strike next
It would be great if we can get as much as responses we can.
I'd like to see what happens if psychologists design a social media platform around encouraging positive healthy interactions.

I can think of many improvements:

* Boosting instead of retweeting can avoid viral outrage, explanation - https://www.codesections.com/blog/mastodon-elevator-pitch/

* Reduce the incentives & rewards for signalling and curating an online identity, e.g. avoid Like buttons and Share'd content. Snapchat shows it's possible for Like-less social media without curated identity to still be popular, despite lacking Like-button dopamine hits, and the vacuum left by viral content and image grooming might¹ be replaced with socializing with your friends and ability to be yourself (¹ see https://news.ycombinator.com/item?id=11828280)

* Should "goes on your permanent record" always be the platform's default behavior for social interactions?

But I'm just a mere coder watching social media make my social circles ill, I wonder what systems real psychologists could come up with and test.
It's not really a mesh network. It's basically stick a dish on your roof and point it at a tower downtown that has a direct connection to the internet.

Yes you can then extend it a bit a sort of create a mesh, but it's not really the same as having a mesh network which spreads out evenly from individual access points.
There's nothing to fix imo, you learn how to deal with stuff when dealing with stuff, I see no good in preventing it.
Nothing about this comes from services being paid or not. Paid services blocking (or being blocked by) third parties can and does happen.
A family member of mine ended up with permanent peripheral neuropathy in their feet within days from taking a fluoroquinolone-class antibotic for something that wasn't even that serious. They were old enough that remyelination wouldn't occur, and it didn't. Still can't feel their feet to this day, and it happened a decade ago.

Funny enough I was prescribed a fluoroquinolone a few months back without even asking; the condition was so benign that using it was left up to me as optional. The risk calculus there was unfathomably bad, and suffice it to say I didn't take any.
"You suppressing flat earthers seems fine to you now.."

As I read it, PP advocates for ignoring those people not suppressing them. Ignoring somebody and punishing them for what they publish is not the same.

Or perhaps more importantly, the question is who does the ignoring? The user or the platform?

Personally, I think users (and not platforms) need better to tools to selectively ignore. For example, it would be great if I could mark somebody on the social network as "unreliable source" and then all people parroting or use that source (transitively through the social graph) would be (proportionally) marked unreliable as well. And vice versa, why cannot I mark things that come from people I know personally as more reliable than things that come from some Russian troll farm (or - for the balance - American astroturfing startup)?
You can use e-bikes on bike lanes. That makes a huge difference.
Cool! Is it possible to buy one?
Similar to Scott Fahlman's Scone Knowledge-Base Project:
http://www.cs.cmu.edu/~sef/scone/
I think you're right...but knowing what glory hounds most writers are, it's possible we're overlooking an important factor: the motivating aim of the authors.

In 1800, say in England, there were probably some thousands of people whose opinion an author really cared about. Now authors measure success in much higher numbers. If, and it is a big If, the cultural significance of fiction erodes then it won't matter how many people can read words off a page. Most writers want the greatest audience that they can reach and they want to give them a meaningful experience.
> fake passport

Can you please read it again & think how many people you know or read about who had fake passports to get ration? Heck people who need subsidized ration most probably do not even have the Original passport & not even the need for that.

Only ration cards were used for ration, if you know, & someof them were specific. Light green A5 size booklet were the common one, anybody could have it, but not everybody could get ration on it. So most of the time it was used as address & ID proof as it had address, photo of all family members. Only kerosine oil, sugar, soap was available on it. Then there were blue books, yellow cards etc for people below poverty line, enabling them free wheat, rice, salt etc.

Nobody could fake a ration card because the depot incharge also had a master register, where the card details need to be matched.
It actually is a joke how bad some tests are. In a lot of cities in Florida your test is done in a parking lot with no real world driving with other cars, and it omits a lot of things, like parallel parking. Ideally licenses should be able to be transferred across states, but tests like the majority of ones in Florida mean drivers from there may be inadequately prepared for driving in some other states like CA.
Amazon Music Library songs online now – coupontop10
>My only side-effect is that it left me with not being able to eat anything heavy. I can only digest something like Soylent now, ...

Glad it saved your life, however I must say that's a pretty severe side effect.
In China, WeChat is the social medium (and everything else).
Not that I know of, and I don't see a major business-case for it. The UK ISP market is much better than its US counterpart (we have no Comcast, for starters) so I'm not sure there would be enough demand for a wireless ISP.

But if you have any ideas on how to make this profitable, I'm up for it. Email in my profile.
I think you're missing the point - you shouldn't censor ideas just because they are not credible. I can dig through to find my previous list of reasons why but this is the point that both myself and the other commenter are making. It's also at the core of free speech as a principle.

Also, the idea that Western civilisation itself has gotten more scientific is both wishful, and imo would be a terrible thing if it did happen. We've just traded one appeal to authority (priests) for another (pop science promoters and journalists).

Materialism is a great way to investigate natural phenomena but I would hate to live in a society that treats it as a moral principle.
This makes me wonder. What would happen if you'd embed a piece of code inside a text document? Would you need to embed a CodeMirror instance inside a ProseMirror instance?
FIRE – ‘financial independence, retire early’
> Whereas there are techniques for bringing on self-forgiveness that are already available, though not yet accepted in the mainstream.

Could you comment on what those are?
What are these white heterosexual Christians defending their identity against?
Still they are a meta search engine mostly depend on bing. Have they ever shared how much of traffic they serve from each "source"? Never.
It's easier to get away with staring at a tiny screen while "working" than with reading a book that is obviously a novel.

Recently I wanted to lend a paperback novel to a friend. "Thanks for the recommendation", she said, "but I'll buy it for Kindle; then I can read it at work on my phone."
How Does Working Remotely Work?
you can create a temporary conditional index on that table, then the check will be instantaneous. There is a `create index concurrently` that won't cause locks on the table.

With this the re-check for nulls when adding the not null constraint will not take any time at all.
AeroLogic’s freighter fleet set to grow to eleven with new Boeing 777F
Make something people want and tell them about it where their eyes are, preferably for free.

Then, hope they tell their friends.
Show HN: AcousticBrainz
Agree - the entire movie made no sense. "The Oasis" would be one of many competing worlds, if it's worth trillions of dollars why wouldn't someone make a competitor? The challenges would have been solved in a day, the characters act like they see, feel and hear everything in VR but really the experience would never be the same as RL. Why would you wear a haptic suit if it can hurt you when you get punched?

None of it made any sense. But it had some references to back to the future and other "geek" stuff, so everyone loved it.
This is exactly why we set out to build Blink (YC SS ‘18), where you talk to friends face-to-face with video messaging, and share your plans to gather IRL for genuine, in-person connections. We think gen z will set a trend that bounces back from the social excess of the last decade, in favor of something more balanced and natural. This won’t necessarily mean ditching technology, but rather the technology evolving to facilitate healthy and more rewarding relationships.

The most popular social apps out there optimize video for broadcasting your life at your friends (and followers), but not so much for actual conversation with your friends. Their Stories format only amplifies this concept: show off what you’re doing now to everyone who’s watching. Who should be surprised that it feels like a popularity contest competing for who has the most perfect life?

What makes Blink different is a new video format we’re introducing that brings your words to life. Through a symbiosis of speech-to-text, NLP/NLU and kinetic typography, Blink captures your emotion and your words, resulting in video conversations that get the message across, sound or not! This is our foundation: Talk more, broadcast less. Message face-to-face, not with a text.

If you’d like to see a preview of what we’ve been cooking up (and you have an iPhone), you’re welcome to check us out in the App Store:
https://blink.cm

We’d love to hear your feedback!
The user is always free to ignore bad info. It's a serious problem when the platform steps in to do the disregarding for you. That is a form of censorship.
> But, the last part took some time (not in the range of ms) for large tables

create a temporary index covering that column. Then it will be in the range of ms.
I'd imagine there are slides, and slides, and slides of ape neurons in circulation, possibly imaged as photomicrographs and stored in digital libraries, and heaping data sets of genomic primate data.

Are data rights costly? I doubt that sort of information has a shelf life. Consider that HELA cells are still around.

If they release the specific results, and how they arrived at such conclusions, others should be able to take that in hand, and move quickly to look at primate corollaries.
Hi, I run Philly Mesh. You might be close to some other geeks, but if not you can always use cjdns' overlay ability :).

Come chat if you’d like, https://phillymesh.net
Go doesn't chain things much. I like that it doesn't.

Verbosity can be a pain. But needlessly dense code is (imho) less readable. Having a single character that changes the entire context of a statement is not fun (I have the same problem with !). Reading a set of a dozen chained functions, some with ? and some without... that's not fun for anyone.
By the way, the Xi-Editor of Raph Levien (Google) has some architectural notes, which could be useful.

https://google.github.io/xi-editor/docs.html
Woof woof! Bark!
My guess is that it is mostly bing, a few percentages for other sources. They never share the breakdown. It would spoil their magic I suppose.
Asian Games Jakarta Palembang 2018 – Medals List – Tops China with 200+ Gold
Is Bitcoin KILLING the planet?
Generally speaking, Gophers don't interactively debug. There is some support for it, but it's historically been difficult and we have tended to adjust to logging everything and working out the problem from the logs.
Anticholinergic Burden Calc – estimate long-term neurological harm from meds
Raincheck: Blockchain Powered Loyalty Rewards Points for Online Shopping
It doesn't surprise me that this comes straight from the top leadership.

I worked in varies companies (maybe too many). But there was 1 things that was always clear: the company culture always reflects the top leadership.

I also once wanted to change something within a company, and had the support of various other managers. We were all pushing hard for the best of the entire company. But then I learned something: you can't change the top management, and you can't change the top managements opinion. Either accept it, or move on.
All of us moved on to other jobs, and the company went bust a few years later.

When I read the recent stories about Riot Games, I knew it was trickled down from top management. It always is. They define the company culture more than you would imagine.
How Alibaba Cloud supported 70% of World Cup live broadcast traffic using Redis
>for messages directly addressed to me

If that isn't only SMS messages you likely use it like most do. Facebook, Instagram, Snapchat, WhatsApp, etc. I don't have a phone off day but I don't use any social media on my phone at all. I do believe anyone who does could use some time off because it is an addiction and most are addicted. Using it with other people around really should be frowned upon. Like back in the day when you only called people on the phone after 9 and before 21 and not at eating times. It is bad behavior really.
As someone who's pretty pathetically addicted to the internet at times, having Freedom on my laptop and phone has been a huge plus.

I'm sure I could work around it very easily (I know I can on the laptop) but the shame factor involved is enough to stop me generally and I'm surprised there isn't a huge market for this kind of thing. Been gradually limiting my usage of certain sites down to tiny windows of the day and it's left me with so much more time. Along with that, it's largely removed those sites from my reflex routine of checking for updates... several of them I've just dropped entirely.

Used a few free ones beforehand and the risk of it messing up my hosts file or w/e was always too high to actively recommend to anyone.
A tiny AS like this certainty relies on their upstream transit ISPs. I doubt they're getting more than 1/8th of the global v4 routing table via local free peering.
also, if you write a ton of log statements because that's how you debug, then when your production system blows up and you can't fire up the debugger, you have something to work on.
It is highly relevant because we in industry are the ones who actually have to work with and scale all these needlessly slow piece of shit language implementations. Implementations that get a pass because nobody can be bothered to have this conversation. Languages that are dynamic or good for scripting, rapid prototyping or whatever the hook is do not need to be implemented using slow and inefficient techniques and shouldn't get a pass for it. Similarly terrible languages shouldn't get a pass for being terrible just because they happen to have fast implementations.

It's precisely in academia where it is a worthless nondistinction, there a language doesn't even need to be implemented to be studied. For instance lambda calculus predates the programmable computer.
The Great Lakes Brewing Company has a Burning River Pale Ale as a toast to that. https://www.greatlakesbrewing.com/burning-river
because otherwise you end up with kids being taught that the Earth is 12000 years old and that evolution is a communist plot.
This is not really a mesh neteork. It may resemble a mesh in a logical diagram, but it's composed of PTP wireless, ptmp, and fiber.
> There needs to be regulations which prohibit apps from generating content which incites such stupidity.

Ban things I don't like.
They message you on Instagram because they can..
What would the world look like if Bitcoin did not exist?

Personally I think that energy would be better used growing food, transporting kids to school or heating poor people's homes.
I use to take adderall until I discovered its a false prophet and hurts way more than it helps. Marijuana would help calm my brain after a busy day of coding, but as I get older I'm looking for more ways to do better without the drugs.
Sure, I think in rural areas, 3) happens somewhat more for OSM than 1) happens for Google Maps. In urban areas, though, I'd guess that 1) happens far more often for Maps than 3) for OSM.

I'm also not quite sure how often large chains are importing their opening hours into OSM? Because quite a few of them probably do so for Google Maps (or at least - Google Maps often has their opening hours).
Go 2 considered harmful
WeTransfer (Funky Dutch cousin of Dropbox) is getting weird…
Something like bgp+ospf adjacency between routers and ring/triangle shaped networks can provide a high degree of resilience, but are not "mesh".
Physicians and psychiatrists often omit or forget to disclose the long-term permanent damage medications can cause... such medications can literallly age your brain with cognitive decline, tremors, dysfunctions similar to advanced age.
Maybe I'm misunderstanding your question, but there's nothing special about dialogue in MD. Quotation marks, inner thoughts in italics.

"It's just some text between quotation marks", Gabriel typed. *Have I completely misunderstood his question?*
Note that he did make exactly that. "That's not a new or interesting technology" sounds a lot like "this is nothing new" to me - direct quotes.

This may not be the latest and greatest cryptography breakthrough, but if it helps me offload the compliance PITA and not even touch any PII ever, I'll take it - so that my small team can focus on our main business - and no, I'm not aware of any such general service outside of payments use case. If you know specific examples of token proxying SaaS services, let me know! Just like Dropbox, this solves a unique pain point for us and others like us, even though it may not sound sexy to some people.
Maybe they could add geolocation data to the query if the query contains keywords like "near me" and similar. No user tracking involved.
It's entirely possible to build a WISP and have no transit upstreams or peers. If you wanted to truly island it you'd need additional DNS infrastructure that most wisps don't have. Never seen it done, though, because the use cases for such a thing are rare, vs a wisp that provides a default route to its customers out to the internet.
Maybe libmdbx would be interesting too.

https://github.com/leo-yuriev/libmdbx
Where they at though? How much do they spend on books per year?

I like reading free stuff and it's mostly non fiction.

You couldn't convince me to read something like Paper Towns.
Back in the days of the romantic poets, when Wordsworth published folios of his poems, they were the bestsellers of their day. By the time Kurt Vonnegut wrote his novels, you could probably say that poetry was dead. But now we have hiphop and graphic novels, so I would argue that “Literature” falls under a broader category of artistic human storytelling, which is now most popular in various multimedia formats.
PHP makes it really easy to write insecure software, because the first googleresult is often outdated and hacked in a short time by automated scripts.

The defaults of functions/methods in the standard library are often insecure.

if you want to write good PHP i can recommend following resources:
https://paragonie.com/software Would use their stuff if i wrote PHP
https://www.phptherightway.com
https://phpdelusions.net even though the name sounds abrasive it is a good resource on dbaccess if you want to know specifics. It is from a guy with several SO gold badges.
Cannon Bux Earn Cash Online