skysight-inc/HackerNews huggingface dataset:
Yes, both of those are alternative solutions.

Using a wrapper like SQLAlchemy is probably an improvement for most medium and large projects, but it has costs of its own. Using portable ANSI SQL - above the Hello World level - is something basically nobody does unless they make a serious effort, lean on linting tools and forego some of the most useful features of their DBMS. sh is perhaps a closer comparison than C here: it's at least possible to write portable C accidentally.

And neither of these help you if you started with a SQLite database - an excellent choice for most - and decide that you need to support a dozen or a hundred concurrent users.
in SF, Hoogasian Flowers
If you look later on at the readme, you'll see that the stx_catf function does not reallocate, it truncates, there is another function for reallocating append.

That said, I don't really see why one would need such a no-realloc function. In c++, I would just use std::string::reserve(some_big_num).
Who else? They'll get the job done but I don't think they are going to accept any deadline.
Show HN: Superadmin – No Code Visual Testing Made Easy
Show HN: Code with Replit – 20 Practical Python Projects for Beginners
When in doubt, C4. But it wouldn’t even help: It is shallow and there isn’t enough water to fill such a hole.
I work on a project to transform partial feeds into full-text versions. The idea is you give it the partial feeds URL and subscribe to the feed URL it generates: https://www.fivefilters.org/full-text-rss/
> Its a suggestion to fix the awkwardness, one that will never get approved

You were courageous to even try :-)

From their refusal to see any use in explicit variables declarations, their (somewhat related) huge scope debacle, to its strange and irregular 'resolution', not to mention the original absurdly weird propositions they had made to resolve it: the scope and variable declaration subject is pretty hopeless in Julia land. I quickly gave up on it years ago (long before the scope debacle), as I had no intention of losing my time, when I saw the arguments and the logic they used.
Show HN: Web Based Augmented Reality for E-Commerce
You could increase the buoyancy by something like 230 kilograms per cubic meter if you fully saturate it on a hot day, but I suppose you'd have to dam up both sides to keep the brine from washing away.
Having done quite a lot of it professionally once I can say that the details of high level cooking are both mostly understandable to a lay person and incredibly boring to someone who isn't specifically invested in the process of cooking.
A lot of measures are preventative, and kind of have to be.

Consider the hypothetical scenario of being totally out of memory. I mean completely: not a single page free, all buffers and caches flushed, everything else taken up by data that cannot be evicted. So in result, you cannot spawn a process. You cannot do any filesystem operations that would end up in allocations. You can't even get new page tables.

Hence things like Linux's OOM killer, which judiciously kills processes--not necessarily the ones you would like killed in such a situation. And again, a lot of preventative measures to not let it come that far.

Our Turing Machines still want infinite tapes, in a way.
Had this in a 70s F150. A "Main - Aux" switch on the dash, right above the 8-track player. I used to let the main tank sputter out on fumes and then triumphantly shout "Rerouting auxiliary power to engine!" while sliding the switch. Letting them empty out alternately would have been a lot smarter.
All of that company's ships names start with 'Ever'.
The common tragedy of the commons. Sorry anytime I see something inplicit, I feel like I need to say it out loud.
A friend told me a new hire spent weeks drawing diagrams on the board and explaining to coworkers how X feature should work, after two months of zero commits he was let go.

A perfect example of a -2 X 5, zero work done but great presentation, now the guy is infamous in our circle and no one would recommend him to be hired anywhere.
I wonder how much economic damage is caused every day that ship is stuck.
"That would have worked if you hadn't stopped me!"

- Spengler in Ghostbusters
How about the COSCO ship that's been parked by the bay bridge forever?
The Big, Stuck Boat Is Glorious
I find them particularly strange from a design perspective. If anyone here does design on car interfaces, please let me know why this is the direction you're taking, because I'm stumped.

Car interfaces seem like something you would want to optimize for being able to be easily controlled without taking neither eyes nor focus off the road. This, to me, means physical interface elements with good built-in feedback (clicky buttons, notched knobs etc.). Instead, we appear to be going down a dangerous path of having everything be in a screen.

How come?

Sidenote: I'm generally not a big fan of voice-interfaces due to their general inferiority to 'hand-interfaces' (no muscle memory, large latency, high rate of error etc.), but as an interface in a car I think they do make some sense, given the obvious design constraint that you want the driver to focus on the road. They can't replace all functions though due to the aforementioned constraints, but other than that, this is a very fitting niche for the technology.
Leading with “One weird trick that...” will increase your CPM, guaranteed.
As bad as this seems, it's still a long way from the ships that were trapped in the Suez for ... eight years. Yep, eight years:

https://www.youtube.com/watch?v=4DiXRCo7eBs
That's actually an interesting idea - set up a temporary lock/dam on either side of the ship to float it. If, instead of a boring dam made out of concrete or something "normal" we used a fleet of Chinooks then all the better!

I do believe this is probably one of the solutions that's being investigated but I also believe it's

1. Super expensive to construct an impromptu dam under water

2. Floating a listing ship can result in more severe listing if you're not careful (See, for instance, the fact that when a ship beaches itself while the tide is out it's initially bad news - and when the tide starts to come back in it becomes significantly worse news.

Learning and humor are fun together!
At this point just fill in that section of the canal, leave the ship there, and dig a new canal.
I'll have to disagree.

I use Next because it offers SSR plus the hydration step for a fully-fledged React app on client, and the ease with which you can pass stuff between the two. SSR for paint speed and SEO/bots/meta/whatever, and the rich client side app functionality that people expect these days. A traditional server-side-render-only approach doesn't make that as easy, IMO.

I use Vercel for the DX, mostly. I can copy an old project repo and have a fully functioning new project site up in literally 20 mins. Same reason people use Netlify.

Also, they're not necessarily slower for dynamic content. Only noticeably if you hit a cold start really. But that's just the normal serverless/Lambda caveat: in exchange for interventionless scaling, one request in n is a little slower during scale-up events. You can always put your next app on EC2/EB/etc if it worries you. I'm more pro-nextjs than pro-Vercel.
Live Previews with Rails and StimulusReflex
Removing ballast from a ship with such a heavy top load is super risky. That could turn 'days or weeks' into 'months or years'.
For the same reason (kill bugs), the same thing is recommended when you buy flour. Put it in the freezer for 24+ hours, then take it out and store at room temperature.
Sure. I'm a good speller but there are a few words that I learned the wrong way and had a blind spot for. I discovered I had been spelling them wrong all my life when Word kept underlining them in red.

In related news, Japanese teachers lament the fact that predictive text entry systems on their students' phones mean that they don't know how to write kanji anymore. They can recognize them, but don't have enough practice to write them consistently anymore.
> "We have not yet found a system that effectively removes the angry shouting, or urinating, or otherwise crazy-acting person from the sidewalk, or bus, or urban train, that is not uncomfortably close to a police state."

you're advocating unnecessary force. it wouldn't just be uncomfortably close, it would be a police state, where force is used to gain compliance and instill arbitrary order. mincing words like this is an attempt to avoid cognitive dissonance (i'm a good person so i'd never advocate a police state!). it's the same coercive impulse that gives us poor policy decisions to all sorts of non-obvious situations, including this pandemic.

when faced with a "crazy" person, it'd be better to control your own fears and realize that that person is quite unlikely to be a threat to you. control yourself, not others, and default to compassion and humility under uncertainty. being fearful is nearly as bad as being belligerent, in that they both serve to distance and disconnect us from our humanity.
Hmm, I don't have any negative associations with SSI, seems like similar ideas have existed in lots of more recent platforms (like partials in Rails, e.g.). Static site generators are doing something similar, just in advance?
This is an old technique. For example, some game developers back in the early days used to put dummy files in the game data space, and code the entire game with less space so that if later more space was needed, it was just a matter of deleting the dummy files. In that context, it kinda forces you to be smarter about your game assets and code.
Accident. There was very adverse weather during the crossing.

https://www.washingtonpost.com/world/2021/03/25/faq-suez-can...
Nuking the Suez canal was a better proposal than using the rocket boosters. The most important artery in the world is blocked right now and you're concerned about clean-up work? It's the desert!
Can’t we just dig a new canal?
Worst case you end up with a nice replacement for Arecibo.
I'm sure there's some pypi package that has a full search system you can download. For that matter, there's the python sqlite package. It's irrelevant that it's ten lines of library calling code when you're comparing it to a toy implementation.
"Ever Given" is the ship's name

Evergreen is the company that owns (manages?) the ship
Off topic:

I once ordered a cheeseburger and got a “burger” without a beef patty or any other kind of meat, not even the veggie pretend meat. Just bread, sauce, pickles and a single slice of cheese.

I felt pretty disappointed with that “cheeseburger”.

Anyway, my point is that the real world lying about cheeseburgers situation is a lot worse than pulling a fast one and handing over a chicken sandwich.

I would begrudgingly have accepted a chicken sandwich.
The company name is Evergreen, the name of the ship is Ever Given.
I was not aware that you could extract the audio that way. A raw download of the video gives a big file but this might make YouTube usable.
Mine played Othello using the same mechanism. It was cool because every square that was a valid move would change the cursor when hovered over. The CGI would make the players move, plan the computers counter move, return the board showing the players move with an automatic reload after X seconds to the URL encoding the game state plus the pre-planned machine move. Used a html table ang gifs. So fun.
Something like this? Is this why they’ve asked all other ships to back up? https://knowyourmeme.com/photos/1699656-world-war-iii
Show HN: A Chrome extension that helps you find Airbnbs with fast WiFi
It's the world's spirit animal.
The Mil V-12 was built to lift ICBMs, and could easily lift any container.

https://youtu.be/yOApFeEgHcE
Something like "PRAGMA STRICT = ON;" should be trivial to add after the strict mode is actually implemented.

But IMO that would just warrant an entirely separate software package. Shoving it inside sqlite3 is likely to make it much more complex.
They warn you because they don't want you doing it. So if it's a tragedy of the commons (it usually is), the obvious thing to do is to do what they don't want you to.
I appreciate it! Someone drops that link into just about every discussion about CXX. I have to respect the mindshare that your blog gets!
Would you say overall it’s easier to have impact there as a Java, C++, or Go focused Dev?
I knew a place where Exchange was configured to delete all mails after 6 months. Soon after I discovered that people started to form circles in which they would forward older mails from internal mailing lists to each other to retain them longer than that.
I mean, selectable, cheap, memory model changes are novel and I pretty much guarantee they have patents on some aspects of it. Depending on the patent there might be some cute ways to work around it, but it's going to take some work on your part. They might even have patents on other attempts to get to the same effect that they might have tried out.

PowerPC's biendianness would be patentable too if it had been an absolutely ancient technique about as old as computers themselves.

And there's people other than ARM and Apple making ARM cores. Samsung's Exynos M5 should be coming out before too long for instance.
Yes but you have to recognize that there is something irrational in the perception of the problem. How do you go from -> a lot of fragile and old people are going to die
to -> omg I am going to be starved to death
?
It's amazing to me that a company that has been started so recently has put such little thought into editorial decisions and moderation.

> We do not allow hate,

Factually untrue. Substack is a welcome home for bigots that have been pushed off places like twitter (for exampl Graham Linehan)

Also for me, their speech on what they "tolerate" is worthless until they come clean about their editorial standards, ie, who do they pay to come write for them. Some people like Matty are honest, but it should be a requirement to disclocse that they're funded by the platfrom.
Another click-bait article title. "Fake commuting" would mean that people actually drive or take public transport in the morning and then immediately return back to work at home.

What the article says, is that people cannot tolerate a fully sedentary lifestyle at the same location and have to go for long walks, or even go for a drive to change environment.

It is not that they long the commute experience.
If I recall correctly https://www.foundationdb.org/ is also built on "distributed sqlite" at it's core.
It's more accurate to phrase point 1. as SQLite column constraints are opt-in. If you explicitly add a check constraint on a column schema, SQLite will dutifully perform it for you. It's a little extra work, and as siblings have pointed out, a greenfield SQLite would probably not have done things this way. But it's also easy, I have check constraints on many columns and they serve the purpose.

Think of SQLie as having a weird dialect where `Col1 INTEGER` is spelled `Col1 INTEGER CHECK (typeof(Col1) IN ('integer', 'null'))`. Ideal? No, but also, not a showstopper.

There are a few good reasons not to use SQLite. Your point 2 is one of them, running the client on one machine and accessing the database file via a network file system is another. Although I've pushed write-heavy workloads pretty hard with some care, it's easy to create a situation where contention becomes untenable. You can really pound on it with one client, but with several it gets dicey.
Or what?
What's horrible about it? The syntax is very straightforward
Given how important this canal is, I would have thought multiple countries have literally wargamed how to remove a blockade from the canal in a way that makes it still usable for shipping.
This baby can do it:

https://en.wikipedia.org/wiki/Mil_Mi-26

It will take time but that thing has the capacity.
Oh wow super interesting - At my last job we had really poor testing and something to visually monitor for breakages would have been perfect. Does this do a screenshot diff between builds? Does it run on CI or periodically?
Changes in ocean chemistry show how sea level affects global carbon cycle
Bad Apple on an Apple //e: playing video on a stock 1 MHz Apple II [video]
"On Intelligence: How a New Understanding of the Brain will Lead to the Creation of Truly Intelligent Machines" - By the guy that started Palm. It is from 2004, and probably deeply flawed in a lot of ways, but I read it at the right time and it "clicked." I think about it often.
Maybe disassemble part of the ship to disgorge its contents closer to equipment?
Not all negative feedback is stabilising.
Build a taller barrier!
I am far from an expert on game theory, but it seems that the cause of the tragedy of the commons is that people can use the shared resource for free. If there was a price to be paid, and the price was dynamically adjusted depending on conditions, then the overuse could be avoided.

Similarly for file storage and "reserving" it by creating huge but useless files. If everyone was charged a fee per gigabyte per day, then people would be less likely to create those placeholder files. You probably have to be careful about how you measure, otherwise you'll get automated processes that delete the placeholder files at 11:59pm and create them at 12:01am.
That would be fascinating it were true, but it isn't.

Wood isn't the best material, it is the cheapest, because it is already made and just waiting to be harvested.
I think the first thing you described is called spamming
This is typically used for agricultural/off-road fuel which is not priced with road taxes and as a result much cheaper. Off road fuel is dyed red in the US. If you get caught running dyed diesel on road you will be fined. Thus the switch on the dash, when you leave the highway to drive on your farm you flip over to dyed fuel to save $$.
Life builds things molecule by molecule, sometimes atom by atom. It's very humbling to think about. We are a long, long way from being able to replicate that in manufacturing.
If it keeps getting stuck higher and higher at some point it will be out of the canal thus solving the problem, no?
Pasta didn't sell out because people were afraid of starving.

Pasta sold out because people didn't know how to cook anything else themselves.
I agree. It's not fair for the middle east to have that much oil and sell it for that much.
20,000 TEU, not containers.
Bunks only go up.
> What about the millions of parents of girls, who do not want transwomen (biological men) in women’s sports

If that's an important issue to parents, I'd say we're doing pretty well.
Simpler to write, batteries included and with better performance (in both bundle size and runtime performance) than React.
> That's a lot of barges.

Maybe bring another Evergreen ship there and move containers onto it...?
Nuke the thing. Crater fills with water. Continue.
Classic Uncle Bob of pushing the responsibility on the individual instead of the system. I've always found that attitude weird. We're in an industry that uses automation and produces tools. Relying on self-discipline instead of creating a tool to ensure something seems backwards.

Also, lots of these are not very well defined. What is "harmful code"? How do you measure if "code for others [is] harder to understand or change"? What does "making the code worse" means? I can easily create example for each, but finding an universal definition is, I think, really hard. How then are you supposed to enforce these?
I believe you're thinking of https://docs.julialang.org/en/v1/manual/metaprogramming/#Gen...

(but I don't find it helpful to compare to fexprs, which I think of as more about deferring evaluation, whereas generated functions are about "staged programming".)
Yeah, the wire would be heavier than the ship.

That is a relatively fundamental result. With current materials, it's pretty much impossible to levitate anything against Earth's magnetic field. You can't put enough current through a wire to create a force bigger than its own gravity without using unreasonable amounts of power. Even if you put in that power, you'd melt the wire.
Government?

I see that as the SOP for large companies too...
Is fish not considered meat?
> I wonder at what point the operating cost of those waiting leads them to just unload and destroy the ship?

(1) as I understand the effect of how it is stuck, you have to unload very carefully or you destroy the ship in the process, well before you are done, and

(2) unloading a massive cargo ship like this anywhere but a specialized port designed to handle such operations (even if it's not, say, stuck on both sides crossways in the Suez Canal) is...well, perhaps not technically impossible, but not an “oh, sure, we’ll just do that and get things resolved right quick” option.
Amazon Just Cut Off Warehouse Workers from a Companywide Directory
I've used it indirectly through Arcadia which allows you to use Clojure as a live programming environment inside the unity game engine

It's pretty cool
After Slack acquired screenhero but before they killed it, i actually convinced my employer to get a paid slack in part because it was the only way then to get screenhero. then they killed it shortly after we did that. oops.
Hey HN! I'm Gaurav, founder at Superadmin. It’s like a visual CI for your web apps. You can run the test-runner on builds and it will render pages and alert you if there's any changes.

We had a tool like this at Google and I know many companies build something simple on their own or setup really complex toolchains to do this. With the use of a chrome browser extension (coming soon) we're looking to make a no code tool to build tests and make it easier to get regression testing checked off for dev teams.

It’s free to use and getting started from sign-up to running tests should take less than 5 minutes.

And we’d love to hear what you think!
What is the sweat spot for clojure? Seems like it could be useful in places where the programmers are also responsible for "data entry" and it's better to use a lisp instead of xml or java annotations.
Someone grab a whiteboard...
> substack currently right now hosts newsletters that are aggressively transgender-hostile

I’m sure this comes down to a hyperbolic claim, as we often see from transrights activists and those in favor of cancel culture. What does “hostile” mean to you? Did they call for violence? Or do they simply disagree with the forced assertion that transwomen are women, or that trans- and bio- athletes should have to compete against each other, or that anyone unwilling to date a trans person is a “bigot”?

> I doubt for most of them it's going to be trans teen athletes.

So all those who aspire to compete in a fair women’s league should sit aside when biological men take their opportunity away from them? Why should anyone get to trivialize their concerns? And more to the point, why call to shutdown writing and discussions about these concerns? That is plainly authoritarian.
Well that's a good idea. Perhaps an OS that just works is a start.
I see Chris Siebenmann (https://utcc.utoronto.ca/~cks/space/blog/) blog about Prometheus (https://prometheus.io/) often. It seems quite capable of this and a lot more complex alerts.
Mi-26 has record of 56 tons lifted: https://www.fai.org/record/2174

Although I suspect you don't want to repeat that trick too many times without serious inspection/maintenance.
I used to experience that, but it's gone away since I moved to never having vibrations on my phone. Highly recommended!
We do this to a large degree with set office hours for questions and most meetings. Personally I get more work done once the sun has set and churn out the "best" work then. "Best" being the fewest silly mistakes and it works as expected the first time.