skysight-inc/HackerNews huggingface dataset:
it seems like nationalism brings a vicious cycle of crazyness for everyone
nah. even used gas cars are pretty expensive.
I'm a huge fan of SQLite! My org's apps use it heavily, often via this simple key-value interface built on sqlite: https://github.com/aaviator42/StorX

Handles tens of thousands of requests a day very smoothly! :)

As an aside, has anyone tried using a RAM-disk as the storage medium for SQLite DB files? We've started experimenting with it lately and results have been promising!
Coercion isn’t necessarily what you want. See discussion here (when STRICT was introduced):

https://news.ycombinator.com/item?id=28259104

It’s also only two years old which is forever in the web world and brand new by Databases ops/maturity standards. There are likely still warts waiting to be discovered (there always are, but the discovery rate tapers over decades).
Note that your operating system caches file system reads so SQLite doesn't need to put anything extra in RAM. Most reads will be from RAM, so no disk access required.
Serverless doesn't mean hard-drive-less, it just means that you, the person deploying the software, don't have to manage servers, only your application which may or may not access files on the filesystem that may or may not be a local disk.
Dedicated apps are a FANTASTIC use case for SQLite, but most people already have SQLite as their goto for these applications.
"Ugly" might not be the best one-word description but there are a lot of basic accessibility issues with the Django admin. The general user experience could also really benefit from using more modern design patterns (for example modal windows over pop-up windows).
Justifications or not, when I can't easily pay for something and get it, I will torrent it. The ball is in their court like ever. The tao of piracy
I totally understand the point about the scroll bars, I meant to say that I habitually scroll pages, without even thinking. There's no analysis, no attention to the (hard to see) scroll bar, the intuition is always to scroll. Even when it's very clear that I'm intended to be at the bottom (e.g. I can see a conventional footer layout) it's just a reflex.

But yes, I agree with you it's undoubtedly common (enough). I was just pointing out the difference with "internet natives".
At least within the us, theft associated with things like shoplifting is dwarfed by wage theft. Companies steal from their customers and employees more than the other way around. I would argue this is the purpose of the streaming model, to make sure people can't pass their media collection on to their descendants so it has to be repurchased. Theft.

Piracy is an activity within the scope of the free market, just like this institutionalized theft. Giving companies a blank check while holding individuals to the highest standard is a more impressive feat of mental gymnastics.
Counter take is that it's the perfect environment from a learning perspective: if you succeed there, you can succeed in easier conditions.
Sober raving, bees, and playing D&D: how those with stressful jobs decompress
I think this speaks more to the target audience of the courses he sells:

> So, can you use SQLite? For the vast majority of you reading this, the answer is “yes.” Should you use SQLite? I’d say that still for the majority of you reading this, the answer is also “yes.”

If you’re making a simple proof of concept app, a side project you just need to get working, or a toy project for learning then SQLite will be fine.

If you’re trying to learn how to build maintainable web apps for a business, getting PostgreSQL or MySQL or similar up and running shouldn’t be that big of a hurdle.

He also either doesn’t understand the limitations and complexities of using SQLite (migrations, foreign key quirks, other issues mentioned in this thread) or he’s deliberately ignoring them because it would weaken his point.

For what it’s worth, we’ve had to un-teach some of this author’s material to junior devs after they read into it a little too literally. He likes to push his way as the “right” way to do things, which can turn into a cargo cult mentality for junior devs buying his courses. He pushes his new “Epic web stack” in the same way.
True but if it hints towards the younger generations not liking or trying alcohol at all, it seems a bit out of touch.
Sorry, but I prefer to stay with the Yugoslav term - adding more and more letters is just another expression of petty nationalism.

Also, the M in BCMS is Montenegrin, the latest made-up language, not Macedonian (which is separate). Seems like not even the defenders of linguistic seperatism can keep up with the insanity ;-)
Companies are already testing self-driving cars in SF, Phoenix, and LA. So much for this theory.
how/why would there be correct pirating statistics lmao
It’s either PowerPoint or draw.io depending on the time I have and the complexity.

Then I found this web based coded solution 1 and I was having more fun then I deserved, especially to quickly add shapes, connections, and not worry too much how it is going to look aesthetically. But then I do worry how it is going to look and I can’t really force where I want the shapes and group them differently, and when I’m adapting myself to the tool instead of the other way around,… I go back to draw.io and screenshot to PowerPoint.

1 — https://nomnoml.com/
> where he holds the James and Carol Collins chair

What is the academic impact of holding an endowed chair like the 'James and Carol Collins chair'? It it related to any specific advantages or responsibilities? Those titles seem like they serve as a form of recognition for donors, is there a deeper significance behind them?
That is, by definition, monthly active users and the same way that basically everywhere calculates it. And yes, one click a month is considered an active user.

You could compute more satisfying metrics like “how active is my average user” and that does tell a story. But MAU says a lot about a product’s reach even if it feels uncompellingly broad.
Model Y sales were higher Q2 & Q3 than Q1. So while it is theoretically possible that it won't be the bestselling car in 2023, it's highly unlikely.
This is not entirely true. There are services that provide pirated TV and streaming for a subscription.

https://tweakers.net/nieuws/150656/europese-politiekorpsen-r...

Remember there was a time when criminals made lots of money selling bootleg DVDs and CDs. Obviously those buyers had money.
Yeah but since he did all this in the USA, I’m not sure why that’s relevant.
Iirc this has already been solved by an experimental GMO.
Those rocks come from the mantle. You can find them in outcrops in places like Oman and Norway. Typically they get to the surface through tectonics.
The django admin looks way better to me than most websites with more fashionable interfaces.
Taylor Swift Vaults into Billionaire Ranks with Blockbuster Eras Tour
I don’t think the news here is that PEG can be targeted by antibodies (research companies have been manufacturing anti-PEG antibodies for decades), but that anti-PEG arises naturally (and frequently!) in the adaptive immune system.

Might be a good biomarker to adjust dosing and estimated pharmacokinetics of PEGylated drugs; it might make sense to take another look at PEG-based therapies that failed Phase II/III with this new finding in mind?
The only thing I’ve noticed is that the “ADD POST” text is at a different height than the “+” next to it, which is a bit jarring. It’s also the only button shaped as a rectangle with rounded corners on the page (aside from “Go” which is styled differently as well). Overall, I see 4 different styles of buttons on this page. But other than the buttons, it seems fine to me.
> use C++ or Rust instead of Java or C# in that case?

Despite having to spend extra time translating C API headers into C#, the productivity gains of the higher-level memory safe language were enormous.

Another example, I have shipped commercial embedded software running on ARM Linux, and based on .NET Core runtime. The major parts of the implementation were written in idiomatic memory-safe C#.

> doing business (especially web) apps

Well, these business web apps are precisely the long-running servers I have mentioned. Still, the software ecosystem is not limited to that class of problems, and due to different tradeoffs Java is not great for anything else.
I just cancelled Amazon Prime completely.

Just found out you dont even need it for Amazon Video anymore, and most of the good stuff you had to pay for there anyway.

For deliveries it was always barely worth it for me with prime same/one/two day free shipping being novel 10 years ago, but always hard to quantify how much I used it and the speed has gotten worse and worse, with Amazon Video being the extra thing to keep it just interesting enough.

For the low volume I order I’m often on a retailer’s website. Same day delivery is just gone in my area, and actually Uber and Doordash will just go straight to retail stores for you and its actually 20 minute delivery. They have subscriptions too that reduce some fees.

And if I’m not saving money while using something more convenient, then Amazon Prime time to go! Thanks for the last decade, obsolete this decade.
Apparently PEG is/was the one of the reasons of the severe allergic reactions in mRNA COVID-19 vaccines (Moderna, Pfizer)[0]

That's plastics for you folks...

[0]: [Translated from German](https://www-aerzteblatt-de.translate.goog/archiv/217236/COVI...)
why are you arbitrarily pretending that makes up for all other forms of theft?
I actually love the way the Django Admin UI looks, but it does go against the grain of the current trends in UI design by being a bit explicit. For example, the "add post" button looks like a button rather than just being words and there are borders demarcating boundaries between sections. I think it's both good looking and a lot more usable than the current trends in UI design which favor minimalism to the point that it can be hard to discern what is clickable.
You want to use "affects"...Sorry...Friday is grammar Nazi day....
When did I do that?
That was an amazing video, thanks for sharing! I really appreciate that there's a link to the shader code as well. Makes me want to dive into graphics again!
I've used a microwave like this an I hated it. I like to put precise times into my microwave.
The article infers, not unreasonably IMO, that the support for this push comes neither from citizens nor fellow lawmakers but from labor unions with whom the lawmaker (Councilmember Hug Soto-Martínez) is closely aligned.

> "This has everything to do with making sure that the streets of Los Angeles are safe ... It’s also about making sure that we protect jobs"

> "During the Q&A that followed, TechCrunch asked if any constituents had raised specific concerns about robotaxis. Soto-Martínez replied that he “would have to check,”

> "Just two LA lawmakers were present at the conference on Wednesday"
hell yeah demonslayer irl
From a very quick glance at page 6 of https://arxiv.org/pdf/2310.05328.pdf

You can see he is treating the case of k=1,2 with that formula and uses induction to extend it to 1 ≤ 𝑘 ≤ 𝑛 − 2.

For k = n - 1 he uses a different bound defined in equation 2.2. So he bypasses the issue.
I don't know what SQLite has gotten over a 5 line docker-compose.yml running PG locally for my project. It's ready for scale-up when needed, supports more features and foreign keys without setting a flag manually, proper types etc.

I get SQLite for mobile and toy projects but really, a PG set up in docker-compose.yml in your project is the easiest thing to do these days.
And the discussion here: https://news.ycombinator.com/item?id=37482517.
Yeah but, what if his wife eventually needs a kidney transplant?

"Oopsie, I already gave it to a stranger."
This is where I think edge cases favor the human driver.

Imagine driving by a playground and, instead of a dog, you see a ball roll across the street in front of your car, but you can already intuit that it is rolling fast enough that it won't be an obstacle in your lane. A human driver can intuit from the context (playground + ball) there is a chance a child may come running after that ball, from between those same cars.

While self-driving tech may be faster at 'seeing and classifying'* objects, is it able to predict from a larger context? I haven't seen much to indicate it can. I think that's where a lot of the edge cases are going to come from. Driving is more than just 'see object and make a decision'.

*Because most of the tech is relatively opaque to the public, this performance seems to be generally taken on faith. But what the Uber accident in AZ showed is that (with that system, at that time, at least) the self-driving tech really wasn't very good at classification in real-time.
South Pole Medevac (2016)
> Sunlight is incredibly strong. Far stronger than any artificial light you have normally.

A few years ago, I wanted a photo near a window with one half on sunlight and the other half in shadows. I tried to adjust the camera, the distance, direct or indirect sunlight, the illumination inside the room to illuminate the "shadow". It was impossible, the sun is too bright compared with usual light sources. I finally gave up and faked it with gimp :) .
Having a SFH and a driveway is another nearly insurmountable requirement.
SQLite is an awesome tool, but I wish we’d stop trying to force it into situations it wasn’t made for. It doesn’t belong anywhere near a web app deployment that currently or will span two or more machines. Once you have a “distributed system” and the complexities of a DR scenario, reach for a tool that was built for such. You can’t go wrong with PG/MySQL. You can go very wrong with a VC-hyped replicated file system from a company known for outages.
I think it is lacking infinite scroll /s
i do read the following on the site:

If the idea of using a dedicated source code formatter doesn’t appeal to you, you can also use @stylistic/eslint-plugin-js for JavaScript or @stylistic/eslint-plugin-ts for TypeScript.

sure seems better then going to prettier.
I imagined that a prototype device of some sort that was being shipped to Acapulco pulverized the truck or ship that was transporting it
Bank of Canada also held its rate at its Wednesday announcement.

Meanwhile housing prices rage out of control, many working class people can't afford rent even in peripheral cities, and there's homeless encampments in most public parks. But this is not a factor they consider when setting the rate.

And somehow the public narrative has shifted so that high interest rates (not even actually high by historic standards) are to blame for the affordability problem, and not the bubble in housing prices that was created by low interest rates (compounded by low supply) in the first place.

Seems the central banks is content with having gotten unemployment rates back up again and wage growth down, and the provincial governments are happy to sit and do really nothing about real estate regulations and serious housing construction while everybody points the finger at the (ineffective and terrible) federal government, who actually can't do much about this situation . Yay.
I like her and I have donated some money in the past but I am running an old instance and have turned off updates. I don't need new features in OctoPrint. Maybe she should think about other ways of making money from it.

Also I don't need Octoprint anymore (except for one older printer) since I all but one of my printers are now directly connected to Wifi.
Show HN: Made a website that turns sites to mobile apps
But the problem is I don't know how to niche down.

Had some ideas for small businesses such as restaurants and spa owners (as customers can book/reserve quicker via the app)

Any advice is super appreciated
When I was younger, I used to participate in the local radio club's "foxhunts" on 2 meters. Every month I'd be trying out some new cobbled together antenna, or home made doppler gear. It was a lot of fun. I never did settle on an optimum setup. The joy of just trying things out was the reward.

---

As for actual gear fabrication, I used to make gears, mostly bevel gears, but also some spur and helical gears, as well as gear like objects. Since bouncing out of the field (due to long covid) it is only lack of budget that has kept me from trying to build/acquire gear to be able to make gears myself at home. I really want a pocketNC.

I'm convinced I could find a way to Power Skiving[1] straight bevel gears, which should be impossible(because the pitch of the gear teeth varies continuously across the distance from the central axis), with sufficient budget and time.

It's fun to tinker, and that's the reward in itself.

[1] https://www.youtube.com/watch?v=EefFxEGVbWo
Yep, this and the many other “why aren’t you always using SQLite” articles popping up here every month are classic submarine PR:

http://www.paulgraham.com/submarine.html

Which makes sense given they are a Y Combinator company.

See also: https://news.ycombinator.com/item?id=35915789
Ask HN: Best Resources for Understanding Modern Web Stack?
I'm working on a product idea for a market that I've been working in for the last 10 years or so. I've always worked on the biz dev side of things but am not scared of the technical side.

I think it'll be too time consuming to build this application myself, but if I hire someone to do it I still want to understand exactly how it works. What are they best resources for understanding a modern JS stack- like React, Node.js, MongoDB, AWS, APIs, authentication... all that stuff.

I'm open to anything from structured hands-on bootcamp, to architecture courses, to books, to youtube channels, etc. Thanks in advance!
Calm down satan. Until you manage to manufacture physical products for free (one time cost then get inf copies, as digital content) retail theft !== digital pirating
Also consider checking out icepanel.io

Uses the C4 diagramming model and looks really slick exactly for capturing this type of detail
PEG is not plastics...
Plus a bunch of plugins for VS Code and major IDEs.

One thing I always seem to hit is the default diagram size/memory limits, the FAQ on plantuml.com has command-line switches to override those.
I’ve been using Pocketbase[0] on my projects and I can’t recommend it enough.

It is built on a SQLite db and has real-time pub/sub capabilities. Its JS SDK is incredibly easy to use and setup for CRUD as well. For side projects and some medium tasks, I’d say SQLite/Pocketbase has been super easy to work with.

[0] https://pocketbase.io
This song was a tribute to Otis Redding. My first thought was that the article was about him lol.
I agree. SQLite is great for some simple purposes, but this article acts like launching PostgreSQL is impossibly difficult and can only be done on a server 100ms away from your web server.

For simple apps I just run Postgres on the same server and size things appropriately in settings. It’s really not hard and it’s well-trodden territory.

If someone is making a single-tenant app that runs on an embedded device or something then SQLite is awesome.

The way this developer concludes that “most of you reading this” should use SQLite is very strange. Is that indicative of his audience building small or toy websites rather than actual production websites?
Youtube blocked adblock? It still works for me using firefox on both android and linux
It'd be interesting to know what metrics were used to come to that conclusion.
Huh, I take PEG in (large?) quantities before colonoscopies.
But it was largely limited to professional storywriters, Hollywood / Broadway types. The internet spread their lingo much more widely, and terms like that have become more common and fashionable in recent years.
I'd have thought LA was perfect for robotaxis. It is famously a driving, not walking, city. Everything is very spread out, so you have to drive to every place and park there.

It's also famous for its traffic, something automation can handle well (just follow the car in front of you). The real problems come with the unexpected, especially human beings jumping out in front of you (unarmored or in a car).

Mind you the city could really benefit from walkable neighborhoods and public transit, but that requires more planning than most lawmakers are up for.
I was blocked too. Posting for the records.
If you need a video for that: https://youtu.be/e21ZjwZGjiQ?si=r_oHvxYhiWvg7cRa
>they were mostly from autoimmune diseases that couldn’t plausibly be related to their donations

Sounds extremely brittle logic. Why couldn't they be "related to their donations"?

For starters, the donations could make their immune system weaker (and thus make any autommune diseases they already have more impactful) or make it go haywire to combat the post-operation stress...
This is just what I could find with a quick, cursory Google search...

>In a March 10, 2017, Twitter thread that was promoting its original series Love, Netflix wrote, "Love is sharing a password." The single tweet in the thread garnered more than 15,000 likes and more than 4,600 retweets.[0]

>Netflix CEO Says Account Sharing Is OK[1]

[0] https://www.newsweek.com/netflix-encouraged-subscribers-shar...

[1] https://techcrunch.com/2016/01/11/netflix-ceo-says-account-s...
Your argument sounds right but also why use the more difficult tool if the simple one fits your needs? Use right tool for the job.
> he did not start Tesla

While true, this meme feels almost as petty as Musk himself: Tesla had barely shipped its first car when Musk took over.

Founded July 1, 2003, the Roadster was officially revealed to the public on July 19, 2006; Eberhard was asked to step down as CEO in August 2007; Tesla had still only delivered 147 cars by January 2009.
Yes. The Swedish Transport Union just now declared that workers will stop unloading Tesla cars in the harbors starting noon November 7, if Tesla has not yet signed the collective agreement. Other unions are expected to follow with similar announcements.

Source in Swedish:
https://www.dn.se/ekonomi/transport-hotar-att-stoppa-tesla-i...
Always use a good vpn.
„You don’t fire me, I quit!“
It would explain why there have been no German psychologists nor philosophers, ..., wait ...
Depends on how much you drive. at 30k km a year the average car is done after 15 years and 450k km.
Your initial comment had such suggestive phrasing when taken in turn with the comment that person replied to before you edited the first one.
The idea that we should plow charitable donations into various low-value and ill-conceived projects because the moral calculus of doing so versus a malicious general AI strikes me as reactionary.

That’s independent of (but connected to) Yudkowsky’s whole thing, which to my understanding never really attempted to apply the logical extreme here.
Just let the HN hype wave wash over you my friend :)

I see the sqlite hype as a (legitimate) pendulum swing away from defaulting to 'web scale' everything to a realization that most of the systems we design don't need it.

On the other hand, when you start mixing in new tech like litefs to paper over shortcomings in the fundamental nature of an alternative, I start to question the sanity of the choice.

We have screwdrivers, hammers, wrenches, let's not select a wrench and wrap it in a 'screwdriver adapter as a service'.
Piracy as a whole is absolutely seeing a resurgence. The fragmentation of cable into the streaming era started wonderfully. There was a time when one or two subscriptions could service your media needs. I think the most egregious offender is the NFL. To follow your team, you need all these services: ESPN, Peacock, Paramount+, Amazon. Or, you can pay for a sub-par service offered by the NFL.

Ultimately, we are paying more for less content with more ads than cable. AND they are selling our data on top of everything.

Piracy will gain enough momentum to warrant government intervention that will further degrade and rob us of internet freedom. Mark my words.