skysight-inc/HackerNews huggingface dataset:
TBF: you don't. The moment you care about any shortcoming of SQLite, move away.

One of the cool things about it, is that SQLite is very lax about what it accepts (mostly in the datatype area). You can write your SQL statements targeting whatever database you think you'll move to later and they'll work while you're still on SQLite. I believe having this migration work seamlessly towards PostreSQL is one of the advertised features.
This appears to be the strategy. In the U.K. they used to sell legal highs in tablets marked as “do not eat - plant food” since technically they weren’t safe for human consumption. That’s effectively the same too!
Try rails you won't look back
I think the mistake here is that the author doesn't understand the potential of cryptocurrency so sees electricity use for crypto as a pure cost. You can see this because of comparisons to centralized services.

On coal power: It's bad to use coal to mine Bitcoin, but it's bad to use coal to provide power for any activity. Coal power should be banned outright.
I know how to atomically write a JSON file.

Are you sure? I’ve had a lot of trouble getting that to work reliably myself across multiple OSes. (In hindsight I wish I’d used SQLite!) This article gives a good explanation of the many difficulties:

https://danluu.com/deconstruct-files/

My eyes have completely glazed over. If I add this to my app, what will it actually do? How can I even know?

Well, fundamentally it’s very hard to get it exactly right, and I imagine that’s why the implementation is a little involved.

But you could a) read through those docs, lengthy though they are, and/or b) trust the many testimonials saying SQLite is very, very robust and reliable.
Like everyone else, I'm going to offer tuning tips even thought that very much wasn't your point :-)

What you are describing sounds almost exactly like PRAMGA synchronous = FULL [1] (which is the default). That pragma controls when fsync occurs. Depending on your application, you might have got away with NORMAL or even OFF. Again depending on your application, you could have set journal_mode = OFF or increased the mmap_size (both also discussed on that page). Yes those are fairly magical hacks, but synchronous and journal_mode at least are things are always worth considering for a new SQLite database (and before building it with debugging symbols!).

Even without those tweaks, the really key thing is to use fairly large transactions. I'm surprised that alone wouldn't have got you decent performance.

One option you didn't have at the time but might help today is write-ahead mode [2] with journal_mode = WAL (but still presumably not as fast as journal_mode = OFF!). I believe the only reason it isn't enabled by default is for backwards compatibility. According to that article, it was introduced in 2010-07-21, and improved to better handle large transactions (>100MB) in 2016-02-15.

[1] https://www.sqlite.org/pragma.html#pragma_synchronous

[2] https://sqlite.org/wal.html
stablecoins can be manipulated and not have the actual value backing them. and they can be reversed.
Hopefully you do actually recognise what that does: the standard library has many methods documented to return an enumerator if no block is given. This is how.
> Usenet is low key and mainly for file distribution nowadays but it still has its niche.

I always find it funny that people think of Usenet "mainly for file distribution" (though that happened), when I used it exclusively for discussion... long before the News servers had the capacity to deal with all those alt.binaries.* groups.
Same question but for Node.
This is one things I like so much about SBCL, it not only compiles the Lisp code directly to native code, with the disassemble function you can print out the generated code for each function to see how much the compiler was able to optimize a function. This is especially important in the context of dynamic languages to see where generic operators have to be called and where the type inferencer was able to compile it into an assembly instruction like integer multiplication.
why are nukes and coal affected?

This makes no sense at all.
> You apply one of eight abilities to the lemmings, which all have obvious uses but can also follow on and interrupt each other to offer new possibilities.

This is a really good point. Lemmings was one of the earliest examples of real-time emergent gameplay based on a handful of simple rules, and nowadays the number of games that include similar mechanics is kind of mind-blowing.
As a practical tip, I find posting on Betalist helpful. On average, I would say you will get around 100-300 sign-ups.

Out of those sign-ups, you may be able to convert ~20% to actually register for your product.

And out of those, you may be able to convert some to paying customers.

That's exactly what I did with my product Newsy - https://www.newsy.co
> They’re way too negative and usually list weird one off problems or shipping issues.

That's presumably why they said "read" the negative reviews. Obviously you don't then base your decision off negative reviews that turn out to not matter.
Ah, so it's the same then
> OpenBSD pretty much designed the idea of "secure by default" and still to this day, probably lead all modern software OS in this ideology.

If you care about security today you should consider Qubes OS instead. It provides security through isolation. Snowden uses it.

https://qubes-os.org
This seems very thorough. Was this funded by Microsoft?

FYI, there is a tiny typo in the first paragraph: there -> they
How is it that nuclear is affected?

>The shortfalls appear to be widespread, affecting everything from wind turbines to nuclear plants. One source of trouble may be an increased competition for natural gas, which is commonly used for heating in the United States.
I agree reward halving help to concentrate the wealth on early adopters. The simplest and arguably fairest emission would just fix the block subsidy. I'm aware of only one coin that has adopted such an emission.
I agree, but am fine with less. I think no mechanism for head pain reliev is known, but we know that some medication works (painkiller). Ultimately we need to know why, but currently we have to life with less.
> it seems that Ruby is determined to keep adding syntax.

With async/await, type hints, the walrus operator and now pattern matching, Python’s designers are just as guilty of this as Ruby’s.
35 million miles is more than google cars did from 2017-2020 so it’s still significant.
Indeed. In my app using SQLite I log every query that takes longer than 5ms (the db is a few GBs, largest table about 1m rows). It logs very little
Presse-Citron is definitely more aligned with the tech establishment, but it remains useful for general tech news - and the comments are still rather sharp.

CanardPC is a GREAT addition, excellent build! About so much more than games too.
> instead of looking for the islands of truth in a story

You’re shifting the burden of proof.

https://en.wikipedia.org/wiki/Burden_of_proof_(philosophy)
How can that be? Why are nuclear plants unable to produce?

Aren't they baseload plants and run at pretty much the same capacity most of the time?
As someone else here wrote: until I tried a good L2 system. ACC and LKA are pure value adds. Lower the number of moments where your focus snaps back in as you are meandering out of the lane or creeping up on the person in front of you.
I mean some languages have outright bugs (e.g. the php ternary operator)
It's a common way to express "things that are unix-like" and avoiding the pedanticism of what is & isn't an actual UNIX™
You exchange network access against filesystem access, but what if your filesystem is a network device?
Does anyone have a recommendation for implementing an equivalently flashy terminal dashboard in golang?

https://github.com/gizak/termui ?

https://github.com/mum4k/termdash ?
> Swear words and insults work because they break a taboo. If you regulate language to avoid one taboo, then speakers will simply resort to breaking another taboo.

I agree with this indeed, but I stand my point: the use of the word "retarded" is by all mean used to compare someone to a person with intellectual disability. I don't know the Dutch nuances of _Kankerlijer_ so I can probably wrong but I wouldn't think that it is used to compare one person to someone with cancer. What would that ever mean?
"Retarded" it is used to compare, and it means that I consider you a lesser person just like an intellectually disabled one.
>Before the Cold War intervened, many Alaska Natives had family in Siberia, and vice versa. No land bridge needed.

You lost me on this sentence. How is Alaska Natives having family across pond in modern times related to land bridges 2000 years ago and what did the Cold War do to those families?

I just don't understand. What am I missing?
Optimization is not only rearranging instructions. You can make a program of twice the size that runs twice as fast but does the same computation. There is no upper bound.

But even so, minimizing the program size is uncomputable as well. Given a Turing Machine M, create a program P(i) that simulates M for i steps and return true if the machine reaches an accepting state. If you provide an optimizing program OPT, then OPT(P) would be "return false;" if and only M does not halt. I.e. the optimizer would solve the halting problem which we know is not possible.
GNU Artanis-0.5 is ready for Docker
This sounds tempting, but it would trigger a wave of unreadable, irrelevant micro optimization by many programmers.

If you have a desired assembly result, write it yourself in the first place.

The one concession to this I would like is a "constant time" marker for cryptography functions where it is an absolutely critical property that there be no data dependant branches.

(This is a little different on GPUs where branches are so unreasonably expensive, and it sounds like that would also benefit from "no branches here" markers. The downside of this is that it makes valid code un compilable if the compiler can't find a branchless way of doing it.)
What happened to Wirecutter?
This argument has been made for years and I’ve yet to see it really be true.

You can make anything with anything, but Rails is the closest thing to an Aspect Oriented Programming environment that I’ve seen in the wild. It’s not easy to replicate that type of ecosystem with any other framework. I’ve spent ample time on teams using Go, Python, PHP, Java and C#.

There’s just no comparison vs what a small Ruby team can accomplish.
Is there a review system where I can see just my friends' reviews? Eg browsing for a phone and I see my buddy's review, you see your buddy's?
A need little trick is to explicitly state “begin transaction “ and “end transaction” in my app. Not sure how general use this is.
This is mine.

It is something I wrote for my own use after looking at all existing options and finding them not to my liking. This is pretty much a weekend hack, it is from 2019 and it's still close to what I need. When I have time I plan to improve keyboard support, add color tags and archiving of completed items. It will also be redone to not use localStorage and to support a remote storage option. Shared use (with 2+ instances working with the same copy of the data) is also something that I'd like to do, but that's on a back burner.

The Show HN post from 2019 - https://news.ycombinator.com/item?id=20077177
I did not know that, thanks for pointing it out. The similarities are flagrant - do they operate such listing sites in other countries too?
> In fact I specifically presented a model in which voluntary offices / co-working spaces exist for those who want them.

No, you presented "co-working spaces" as a particular form of alternative to offices. Those two things aren't the same, and from your prior comments, it does seem that you find offices to be bad, and want to replace them with co-working spaces. (co-working spaces, at least to my mind, resemble something where I might rent a space and work in proximity to other people, but we all have various employers)

Further, when I stated that I'd likely choose an employer who provided an office, you resorted to calling me naive and implying I have ulterior motives like trying to keep my job, seemingly suggesting that me commenting negatively about offices would cause Google to fire me.

I maintain that up until this post, everything you said supported a remote-only approach, instead of remote-optional, and that's flawed. If that's a misrepresentation of your actual opinion, than you're more than welcome to clarify it, but I'll reiterate that to many, a co-working space is less useful than a dedicated company office, and both are superior to work from home. Hacker News is not broadly representative of opinions on WFH. I realize that as someone who likes work from home you may not enjoy hearing those things, but they're true.
> That’s not normally what you need for an application format though is it.

Well, it depends what you mean by “need”. But continuous, incremental updates generally provide a much better user experience, either instead of or in addition to active “save” actions.

So, yeah, I think its exactly something that is commonly desirable in a file format for maintaining application state, even if there is a different interchange format that the application produces/consumes as a static input or output.
Could you elaborate on your setup an usecase?
Thank you for checking this. I really expected to see copyright infringements.
Natural depletion on a finite planet is like banning, but slower. End result will be the same.
I saw a presentation about Phoenix/Elixir that described this once and it really impressed me. It's been 4 or so years that I've been meaning to pick up Phoenix for a project but still haven't.
sqlite pages are all pleasure to read, all the badass statements reminds me of the classic:

SQLite does not compete with client/server databases. SQLite competes with fopen().
My understanding is that SQLite doesn't impose any format either?
I find the placement fine. How would you write it?
There was one person who wrote deep reviews of things like chargers and battery packs (I think) on Amazon, checking for standards compliance and design safety. Does anyone remember who?
There was also ebay feedback which was key to shopping for a lot longer I'd say.
It's a bussy thing so you could just get an OBD2 splitter. You can even tuck the metromile thing behind the dash if needed.
I tried that once, only forgot to position near the ceiling. Second year in the flat I had the unlucky experience of high ground water levels which flooded the basement. Down system and lost all data :(
> are there any more fundamental data types other than null, int, real, text and blob?

Those type names are just hints, they don't constrain the valid values in any way.

https://dbfiddle.uk/?rdbms=sqlite_3.27&fiddle=4634e3821676ed...
It sounds like PostGIS might be a good fit. It gives you a lot of tools for accessing and indexing geometry data, and it can scale to huge sizes.

Parsing text formats is unlikely to be a bottleneck, accessing the data is more likely to be the bottleneck. The correct data structure (schema) and indexes are going to make the biggest difference.

If you do complex computations on the data, and it fits in RAM, you'll probably see the best performance if you first load the data into data structures optimized for the computation first, and it's less important how you store the data on disk.
Not strictly related, but it reminded me of http://inform7.com/about
I was in Course 2 (Mechanical Engineering), but 6.004 and 6.033 were two of my favorite classes at MIT. As I remember, we spent 2 lectures covering many mistakes made in the Therac-25. We also covered the Ariane 5's first launch failure. We also covered a bunch of systems that made good design trade-offs and discussed their design spaces.
Startup UX Design, User Research, and Pragmatism
Microplastics and Human Health
Thanks a lot, it's the optional chaining operator. We'll have to avoid it or change the ES build target.
I tend to downvote lazy arguments or loaded questions which can be easily answered in 10 seconds by looking them up and have regularly appeared on HN, devoid of new content.

It's fine not to know something, but the threshold to comment should be slightly higher than that; a quick Internet search shouldn't already answer your question / remark.

If I'm not careful I start writing an answer to these, only to realize that I've already done so for the same remark several times already. At that point I just dismiss my comment and downvote instead.

I think we're kind of missing a HN FAQ which we could assume is common knowledge. Obviously I'm talking about technical topic where there is a clear answer.
https://j.gifs.com/o2vRzL.gif
I'm shocked that there is gambling in this establishment.
Sir here are your winnigs
Not OP - I don't think this statement needs that phrase. Venice was Venice 500 years ago.
For this to happen the storage "module" needs to be redone and cleaned up, which in turn requires having a couple of free weekends and these are hard to come by.

That said, if you will get to the point of doing anything with an aim of submitting a pull request - do ask me first. Chances are that it will take a very long time to accept the request, because that too requires a weekend to review.
Stock commingling means that you may buy a product that's sold and shipped by Amazon and still get some other seller's counterfeit. That seller simply claims to sell the same product as Amazon, with the same product code, and places it into an Amazon warehouse. Amazon will ship from the place closest to you so they might just ship what they think is the correct item from another seller's stock even if it's actually a counterfeit, and do the clearing later. They later assign one genuine item from the Amazon stock in another warehouse to the seller's stock.

As a buyer you have no control over this and Amazon does their best to be opaque and not allow buyers to publicly flag issues beyond a return and refund because it would reflect poorly on Amazon's image and make them look like peddlers of cheap knockoffs.
As a IT person who's a motorcyclist, your remark "I figure I will eventually end up as a JIRA ticket" made me spill my coffee.
What other things were terrible about the biography? It's my favorite biography of all time. I'd love to know better what important parts were left out.
An exploding phone is not a straw man argument. It’s an extremely valuable data point.

Who is more likely to commit murder, a randomly selected person or a randomly selected person from those with an existing murder conviction?
>This is actually a widespread problem in medicine. The worst offender is the FDA, which tends to list every problem anyone had while on a drug as a potential drug side effect, even if it obviously isn't. This got some press lately when Moderna had to disclose to the FDA that one of the coronavirus vaccine patients got struck by lightning; after a review, this was declared probably unrelated."

How I laughed out loud... Gold
The article misleadingly states “Ruby 3.0 has Fibers”. Not false, but Ruby 2.0 had fibers, they are used for building a variety of cooperative concurrency behaviours, and they go back years.
Yeah - why there and not "what is now the Brooks Range mountains in what is now Alaska"? Venice was still Venice even back then. Especially back then when it was a major international player, not a damp place populated with tourists.
"Obviously" it would not be a total ban, even with strict lockdowns, essential workers (like supermarket workers, food truckers) were still allowed to work.
It was written when I needed a kanban board done to my specs in a minimum amount of time using whatever things I was most comfortable with.
The Digital Antiquarian is also worth reading on the history of Lemmings:

https://www.filfre.net/2017/10/games-on-the-mersey-part-5-th...
In MWI energy and mass conserve, it's the state that branches.
And getting significantly more performance because those components can actually be cooled properly.
If you’re running sensitive servers, you might put the burden of proof on the vendor to convince you that the equipment they’re selling you isn’t backdoored. (You should also do your own checks)
Societe Generale's SoC Incident Mgmt Playbooks – Incident Response Methodologies
I highly suggest people use https://www.fakespot.com/ for any and all buying through Amazon. Unforuntately it only has a chrome extension but you can manually type in the link through the website. It has saved me from a few purchases, where there were 1000's of fake 5 star reviews but all the real ones were between 2-3 (all of them with comments as to how they couldn't understand how the product was rated so high).
Benson Leung? He was famous for his reviews of USB-C products.
Can I Delay CCPA Compliance?
The parent comment makes it sound like a bad thing, but I kind of enjoy the current way of not feeling the need to buy the latest and greatest every year.
ADT Insider Threat
PH launch: Free Zoom Recorder to attend an upcoming Zoom event and record it
Those damn books. They keep showing up and making life miserable for people. "How to Cargo Cult".
The parent comment makes it seem like blocking those Google services will brick all online functionality of the phone (I don't know if that's the case but it wouldn't surprise me), and proposing that as a viable solution.

I'm all for de-googling (and de-OEMing) our devices, but giving up all online functionality is not a viable alternative.
Haha, missed that.
I would say that's a case for using a proper replicated RDBMS if you need that level of replication. Sqlite is not a hammer for all occasions.
We see a lot of companies "planting trees " or "offsetting their carbon footprint" in their marketing material. However, they're not -actually- doing anything. They're just giving money to someone else that will "plant trees".

If I want to go ahead, and plant trees, there's no way for me, as an individual, to claim a bit of that money.

I think that's an issue.
The main difference between PTP and NTP is that PTP relies on hardware support in switches and routers. Those are not cheap. If they had the same support for NTP, it would perform as well.

A highly accurate stratum-1 NTP server can be build with a common computer NIC. No need to mess with FPGAs (unless that's your thing). The Intel I210 is about $50. It has a PPS input and output. With some calibration, the timestamping can be accurate to few tens of nanoseconds.

NTP can work very well between directly connected NICs. But without hardware support in the switches/routers, that accuracy degrades quickly in the network. A single switch can easily add hundreds of nanoseconds worth of jitter and tens of nanoseconds worth of asymmetry.
>> This is obviously flawed, because juries would vote innocent comments not supporting the mainline parler views to be extremely rulebreaking, and vote death threats (+doxxings, etc) that aligned with mainline parler views to be OK.

Sounds like here.
contingency is necessary but not sufficient for free will, Conway's definition is philosophically weak as it equivocates 'choice' and therefore the whole issue. The definition of choice includes not only possible options but also a selection mechanism, where for particles/random there is no selection mechanism (contingency)
Not a huge amount in concrete terms of capability, but the little differences add up in how the languages are used in practice. Python has functions you can refer to and pass around directly (as opposed to Ruby's blocks and procs), and that makes functions that are also generators just a little bit more friction free and more likely to be used. Python also has explicit support for differentiating between generators and regular functions in other parts of it's syntax (e.g. list comprehensions) that tend to make people reach for generators more quickly in Python than other languages.
If you need just a thorough recipie, there is always that EU regulation:
https://eur-lex.europa.eu/legal-content/EN/TXT/?uri=CELEX%3A...