skysight-inc/HackerNews huggingface dataset:
Though I respect and applaud the effort that went into creating this and successfully releasing it, It has fewer features than duckdb supports at the moment.

Duckdb supports both Postgres, Mysql, SQLite and many other extensions.

Postgres: https://duckdb.org/docs/extensions/postgres

MySQL: https://duckdb.org/docs/extensions/mysql

SQLite: https://duckdb.org/docs/extensions/sqlite

You can try this yourself.

1. Clone this repo and create a postgres container with sample data: https://github.com/TemaDobryyR/simple-postgres-container

2. Install duckdb if you haven't and if you have just access it on the console: https://duckdb.org/docs/installation/index?version=stable&en...

3. Load the postgres extension: INSTALL postgres;LOAD postgres;

4. Connect to the postgres database: ATTACH 'dbname=postgres user=postgres host=127.0.0.1 password=postgres' AS db (TYPE POSTGRES, READ_ONLY);

5. SHOW ALL TABLES;

6. select * from db.public.transactions limit 10;

Trying to access SQL data without using SQL only gets you so far and you can just use basic sql interface for that.
In the eastern block cable radio[0] was used explicitly like this - even though it normally worked as a normal radio, but as the receivers were powered by the cable & the system presumably had battery backup, it could be used in an emergency/apocalypse scenario.

And it also had the added benefit of being easier to control, as the receivers could not be used to listen to western radio like regular radio receivers.

[0] https://en.wikipedia.org/wiki/Cable_radio
Very interesting. I have listened to an AI audiobook once and although the inflection was somewhat jarring at first you got kinda used to it. I suppose it's good enough for your own use. And audiobook prices being what they are rather affordable one as well.
> Jolla had to close

From the best I can tell, Jolla is still an active company:

https://jolla.com/
Surely drivers know what Yield means though right? I guess the US might need yield signs at a roundabout given not all drivers will get the basics of how they work. There should never be a stop sign on a roundabout, the whole point is you're supposed to be able to keep going without stopping at all if theres nobody coming round it.
Doing my web stuff in Rust was fine but concurrency was a pain. A crate that abstracts web workers with transferrable types would help. After that you have to pick a component library of which there are few, and all are experimental. Making pretty, performant things is hard. Switching compontent libraries isn't easy. The backend stuff is a breeze, I think Rust is doing fine there.

I'm switching to Flutter for my UX needs. There's flutter-rust-bridge that binds Rust code concurrently without any headaches in the client, and I can deploy to the web, android, Linux, etc. with ease. Looks p. good out of the box. Got GRPC working quickly, am happy.

Using Rust in the client is nice because I have a single workspace that contains all of my business logic. Backend changes will cause errors in the client code if changes are necessary. The codebase is easy to refactor and trust. Dart ain't half bad.

I stayed away from Flutter at first because it doesn't respect the DOM etc but at this point I'm willing to sell my soul to the devil for how easy it is to make a great UX that deploys anywhere.

I don't love relying on something Google made, though. Feels a little like building a foundation on sand.
A platform for merging interior design with AI
HN, I’m Madhavi. Meet InstaRoom.ai!A platform for merging interior design with AI.For our Product Hunt launch, both InstaRoom.ai and a course I teach on Udemy about AI in interior design are FREE - no strings attached. Dive into the intersection of AI and interior design. Tech enthusiasts, we'd love your feedback and upvotes,Thanks!
Check it out: https://www.producthunt.com/posts/instaroom-ai
Signage exists. Plus the vast majority of times painted ones are used in areas where almost everyone on the road knows how it works, and within minutes of it snowing a very clear outline of the path cars have taken would make it abundantly clear what the process is.

Roundabouts are engrained into UK road culture, you'd seldom find a driver in the UK that cant figure out how one works, even if they may not have great lane discipline on the larger ones.
I think it'd be a moot point if SQL wasn't painful and awkward to work with in the first place. But database purists control it and won't let go, so we will have to live with everyone else inventing layers to make their lives easier.
> Can someone find more about why GEICO did this? It makes no sense. Furthermore, they could just increase rates if they found accidents too common.

Very few insurers will insure literally anything (back in the day, Lloyds of London were notably unusual in that they would write a policy on basically anything, though you mightn't like the cost). Most conventional insurers will have a line after which they say "this is too risky, we'll leave it to specialist insurers". Ask anyone who's ever tried to get insurance on a non-conventional-construction house.

And it's a pretty niche vehicle; if they do find it unacceptably risky, then dropping it is presumably a fairly easy decision.
Yeah FP can for sure take some getting used to before it clicks! I think a great resource for that is Gleam's Exercism track (https://exercism.org/tracks/gleam), not only will it teach you the language but by starting with small-ish exercises it can definitely help grokking FP concepts

And if you feel like you're stuck and need help Gleam's Discord is a great place to ask questions :)
Nobel Prize in medicine honors two Americans for discovery of microRNA
Regardless of merits of "ChatControl" and the feasibility of it actually becoming law (IMO pretty low, I don't see the current parliament approving it), the EUCHR will probably strike it down as against human rights:

https://hudoc.echr.coe.int/eng/?i=001-230854
Any time my car radio switches to AM there is major discomfort. It's time to say goodbye, and the future should be on the phone.

Any time congress gets involved many millions are spent. Again when a law is passed. Again by the manufacturers. These costs mandate the future should be supported, not the past.

Mandate that cell towers, at least along major highways, survive indefinitely on solar. A degraded service level would be acceptable, no video for example. Require satellite internet fallback! Do it now.

Any highway parking spot should have abundant charging opportunities (on solar) and drinking fountains. Prepare for the inevitable big disasters coming.
It seems this would solve the problem with normal roundabouts where you have a lane you should be following but know that a vehicle in an adjacent lane is likely to infringe on yours.
For something a bit more streamlined, I can recommend Clicks [0] which is a well thought out keyboard case for current iPhones.

[0] https://www.clicks.tech/
Plus a plethora of right-angle and U-shaped adapters, and cables/connectors which report voltage and current on tiny display.
The issue that can happen is when one direction has significantly more flow than the other - in this case you end up needing traffic lights otherwise nobody can ever pull out from the minor direction at rush hour.

The other issue in the UK is massive signalised roundabouts used for junctions where traffic volumes clearly justify a proper grade separated junction like a stack, purely to penny pinch. South Mimms A1M/M25 junction is a good example, or the M2/M25 junction where they eventually had to put in free flowing slips eastbound to northbound because the roundabout was constantly congested.

That's not really a problem with roundabouts per se though, it's just bad design choosing an inappropriate junction design purely to avoid having to pay for bridges
Take down requests for DMCA and/or LEO for CSAM. Even though it is impossible for the server operator to know that material is on the server, the URLs + decryption passwords are shared with someone or a group -- if that is discovered by law enforcement or rights holders, they will issue takedowns.

It's not uncommon for forums to share links to resources, along with the password to decrypt them. And FF Send had a nice API for uploading material. It'd be an afternoon coding project to build a tool to re-upload material every 7 days, and update forum posts automatically so it could be available long term, beyond the max expiration time for anonymous uploads.
VMS ist eine komplexe Lösung zur Überwachung und Verwaltung mehrerer Standorte von einem Ort aus. Normalerweise handelt es sich dabei um eine Softwarelösung auf Enterpriseebene, die in Kombination mit der Hardware funktioniert. Kameras, Encoders, Bedienstationen und andere zugehörige Geräte sind Teil eines komplexen und vernetzten Systems. Die Fallstudie zeigt die Besonderheiten der Lösung, ihre Kernfunktionen, Entwicklungsherausforderungen und mehr.
It is not certain that the slow metabolism of reptiles is primitive and that birds and mammals have developed homeothermy independently.

Because there are certain similarities between the homeothermy of birds and that of mammals that seem less likely to be coincidences, there exists an alternative hypothesis, that homeothermy and fast metabolism has already evolved in the ancestor of all amniotes.

Later, in the ancestors of crocodyles, of turtles and in that of lizards and snakes (both etymologically and cladistically, it would be better to apply the term "reptiles" only to lizards and snakes), poikilothermy and slow metabolism have evolved as an adaptation that allows the reptiles to live using much less food than needed by birds and mammals.

This reversal appears especially likely for crocodiles, whose ancestors were terrestrial and agile.

Such a reversal is also consistent with the fact that reptiles need a high body temperature for a normal activity, unlike the amphibians, for which there is no doubt that they did not have an ancestor with homeothermy. To reach their required body temperature, reptiles need to use external sources, e.g. basking in sun light. Because of their dependence on external sources of heat, reptiles become rare or completely absent in colder climates, where amphibians are still abundant.
Different company but if I ever got serious about doing graphics/photo editing again I might actually prefer a dedicated ~2010-era CS installation on a virtualized legacy box over anything that either Adobe or the rest of the market has to offer today. CS4~6 felt pretty "done". Creative Cloud still sucks.

Surely that's a gaping hole in the market waiting to be filled?
Four way stops are common in lightly trafficked situations where the locals can't justify spending the money on anything but a few stop signs. For instance, the main street through a small town (<2k pop) might have traffic lights and maybe a circle for the one other major road it intersects, but where the two or three roads parallel to that intersect with other town roads, a four way stop makes the most sense. Most of the time a car gets to one, it will be alone. Since neither road is long and neither is expected to have fast cars anyway, a four way stop is the most natural and intuitive option way to sign it.

Four way stops are also common when two country roads of relatively equal weight intersect. There are so many roads like that, so many intersections, that the local government can't possibly afford lights or circles on all of them. If one of the roads is known to get substantially more traffic than the other than a two-way stop is usually used, but if it isn't obvious then a four way stop is the safe default. In these situations, pedestrians aren't a factor at all because the intersection is five miles away from a town and it's farmland on both sides of both roads. Virtually nobody is walking there, not even people walking their dogs (unpaved access roads are better for that anyway.)
I would say it shines when you have systems constraints, for example embedded & robotics work well with Rust. You cannot have a GC (either you don't have a heap or you cannot tolerate a GC pause resp.) but you still have the benefits of a good functional programming language to write your algorithms in.

The benefits are less obvious if you have less of those constraints: go is way way simpler to write large codebases for cloud applications in and still provide an excellent concurrency support. Python is way better for experimenting.
please, publish to openvsx.
It's a normal language for most ESL people. It's how we have been taught.

Also things like "Dear XYZ", "Yours faithfully/sincerelly" - it is how we were drilled to write mails.
> How did a language that's supposed to be so hard get popular to the point where people view its fans as pushing it aggressively?

Popular languages don't really have evangelism or fans pushing it aggressively. Those are traits of smaller languages that don't interop well with other ecosystems so they need a lot of evangelism to build out the library ecosystem.

> there's a space for a higher-level language with most of what people like from Rust that has a (tracing) garbage collector

What non-memory management related things is it people like from Rust that is missing from, say, Java or Kotlin? Because those have great web frameworks that address all the features requested in the article and a whole lot more, there's good first class support for all major platforms, lots of documentation etc. These languages are also famously developer friendly with good error messages.
Normal consumers have all outbound traffic open anyways.
https://mrdoob.com/projects/htmleditor/ very similar
Kind of. However on first glance it seems like the separator in PRQL is a newline instead of a `|`, which is less ergonomic in a shell.
This thread is about LLM replacing people, so yes you're confirming that you do need a skilled person to get working code out of it.
I do love how on streetview they've caught what looks to be an accident on it: https://www.google.com/maps/@44.0108294,-88.5835298,3a,75y,5...

That being said that looks like a pretty decent and standard setup for a set of roundabouts, certainly wouldn't look out of place in the UK and would be vastly superior to a whole host of stop signs and red lights. It probably could've been simplified slightly by turning the two middle ones into one long oval roundabout, those are pretty common on motorway junctions in the UK.
I couldn’t agree with her more. They’ve turned physics into scholastic sophistry.
b-trees are just 'better' binary trees as they have lower amounts of indirections (nodes)
I live in a decently sized city in Poland.

Helpdesk internship position I saw had more than 500 applications.

Helpdesk.

:(
Is the cellular modem removable, e.g. in M.2 slot?
Congrats to the winners. Btw when I saw the first picture of the winner I thought it’s Jeremy Howard from fastai/answerai
> An other baffling design I've encountered in the UK is a roundabout with traffic lights half-way through.. Wasn't the concept based on removing traffic lights to fluidify traffic..?

This is indeed a weird one from a US perspective.

The way to think about it is not as a roundabout with traffic lights, but as a light-controlled intersection in the shape of a roundabout.

A roundabout-shaped intersection can handle more variations than a normal intersection, you can have more than 4 roads, or roads entering at odd angles.

As for what the advantage is of having lights on the roundabout as opposed to on the approach, I have no idea.
Stop fighting WPE if you actually want to do better.
Full article anyone?
Similarly in GCC it is hardcoded, with a choice of ASCII or EBCDIC (in gcc/libcpp/charset.cc):

/* Convert an escape sequence (pointed to by FROM) to its value on
the target, and to the execution character set. Do not scan past
LIMIT. Write the converted value into TBUF, if TBUF is non-NULL.
Returns an advanced pointer. Handles all relevant diagnostics.
If LOC_READER is non-NULL, then RANGES must be non-NULL: location
information is read from *LOC_READER, and *RANGES is updated
accordingly. */
static const uchar *
convert_escape (cpp_reader *pfile, const uchar *from, const uchar *limit,
struct _cpp_strbuf *tbuf, struct cset_converter cvt,
cpp_string_location_reader *loc_reader,
cpp_substring_ranges *ranges, bool uneval)
{
/\* Values of \a \b \e \f \n \r \t \v respectively. */
#if HOST_CHARSET == HOST_CHARSET_ASCII
static const uchar charconsts[] = { 7, 8, 27, 12, 10, 13, 9, 11 };
#elif HOST_CHARSET == HOST_CHARSET_EBCDIC
static const uchar charconsts[] = { 47, 22, 39, 12, 21, 13, 5, 11 };
#else
#error "unknown host character set"
#endif

uchar c;

/* Record the location of the backslash. */
source_range char_range;
if (loc_reader)
char_range = loc_reader->get_next ();

c = *from;
switch (c)
{
...
case 'n': c = charconsts[4]; break;
...
For me this feels like the complaints about error handling in Go. People who work with it all the time, don't even think about it past the first week. If you are starting out it might bother people because they are not used to it.

Personally I really like working with SQL and find it quite elegant, I always encourage people to use it as it really is a job-superpower if you can just dig up issues directly in the DB quickly. It has a long history so for every question you have there's many answers or avenues to ask them.
phone app still has template code left in; react native?
DIY enables original Blackberry keyboard. How does the Clicks keyboard compare?
> If you really want real numbers passing them as decimal string is actually sensible.

Hexadecimal, if so. Nearly any decent modern language and runtime can it.

$ python
>>> import math
>>> math.pi.hex()
'0x1.921fb54442d18p+1'

This gives exact value without any rounding effects and conversion cost.

(I donʼt count decimal floating-point as it is quite rare and its application is faint. In overwhelming most of cases, fixed point is better.)
> Shockingly

Yeah, see I don't think that's at all shocking.
I have built a web app for streaming music (for personal use/satisfaction) that i primarily use as a mobile PWA.

PWA is sort of like if you tied an electron app to the user's installed browser, so you are still going to have browser specific quirks. Not all browsers support installing a PWA (most notably for me, safari on macos).

On mobile (especially iOS) PWA can have considerable limitations compared to a traditional app, but less limited than running the app "as a websute". Local storage limits come to mind. I believe a PWA on iOS can only store 50mb?

Distributing it is in theory VERY easy. but its not a common way that users install apps, so it comes with more explanation than simply saying "download from the App store".

React native is a whole other thing entirely, and is not limited to simply being an embedded website in a browser wrapper.

If there already exists a web version of the application, then the saved effort might be worth these quirks, but if its a greenfield project I'm not sure the "Ease of development" actually beats something like React Native.
Good job. I’ve quit a job similarly over ethical issues. But this is the problem with software engineering lacking an ethical standard: there’s always Bob, three desks down, who is willing to build the Torment Nexus. One person’s ethical stand is meaningless.
if you think DAB a failure, then the "we" I meant is just unevenly distributed.

(norway and switzerland are both mountainous countries, which meant the same FM station had to maintain several different transmitters on numerous frequencies — if you're in a country flat enough to serve with vanilla sugar and hagelslag, might that have something to do with our divergent experiences?)
I don’t remember everything I read in a book. It’s just the ideas that I get from it stick in my brain. It just expands my capacity to think and contemplate different things.
Certainly for some things I need to memorise a fact or something, but then it’s just literally a fact I focus on, and I use repetition to ensure I can recall later. But if just reading it in It’s entirety I’m unlikely to remember it all. Certain good books have content that is definitely far easier to recall. I put that down to the authors being good writers, or me being extra interested in the topic.
I'm also an Affinity user, very happy with it.
This reminds me of this oddity in Nottingham:

https://osm.org/go/eu8S4TeKc?way=50459468

(right-hand drive)
Similar with Hemel's: https://www.google.com/maps/@51.7458345,-0.4742799,3a,75y,21...

The map/diagram helps people not familar, the only really complicated thing is making sure you get in the right lane, and keeping an eye on those around you.
B-trees are supposed to address the bad cache behavior of binary trees because they are generally much shallower. Crit-bit trees as originally described do not have this property.
related: https://github.com/cloudflare/trie-hard
The most foundational science is pretty obvious after all.

We all know that apples fall from trees and that banging 2 rocks together makes sparks.
Great analysis. This must be the crux of it, meaning the engineering tradeoff between good EMI mitigation and lower cost. Shielding is one way to go. I do not know the details here for cars, but in digital systems people tend to use spread spectrum clocking (SSC) to lessen the interference. Others on the thread seem to suggest the culprit is not the electronics, though, so that technique probably is not applicable.
Daemonization in Unix programs is probably about restarting programs
This thread is amusing.

Go look at job boards. The competition for Go, Rust, Django or whatever is Java+Spring. That's pretty much the industry standard unless you're in a Microsoft-only shop.
I thought the standard for roundabouts is yield sings on all entrances. Not stops, just simple yields...
TBH, I prefer all of WebOS (on HP Pre 3), Maemo/Meego (on Nokia N9 and N900) and Ubuntu Touch (on Meizu MX4) over Android for the UX qualities.

Obviously, they lacked in phone hardware and app selection, but basic experience was unmatched.

IIRC, Sailfish was inspired or derived from Maemo, so I wouldn't be surprised it took some great stuff with it.

Hitting the critical mass is tricky without having hundreds of millions to lose before you "validate" your experiment: Nokia was at that point with N9 release (to a wide acclaim in reviews too), but shifted right after that release fully to Microsoft Windows straight to their demise.

Canonical pulled out quickly as well, and well, HP Pre 3 didn't even make it to the market (WebOS changed hands weeks before the release).

I actually used each of these phones for a couple of years, and that was so much smoother (OS-wise) than Android. Never used iOS for a longer period to make any claim there (though if I go by MacOS, it's much hype for nothing).
Over here there's a paddle wheel tourist ship (no steam though, just plain diesel). But the cheeky thing is that it's actually powered by propellers, the paddle wheel is just turned around by a small electric (hydraulic?) motor for show.
Thank you for the recommendation - I'll take a look!
You won't have a specific plugin, but you can absolutely use any common VPN config and configure that on OPNsense as a client.
I have the option "show details" and there to choose "strictly necessary". (on mobile Safari and Desktop Edge, Desktop Firefox blocks the cookie screen automatically)
So it looks like at least one contributor of `arm-gen.c` does not want to relicense. Does that mean that the architecture I'm compiling for dictates what license I should refer to? Or would I need to compile a version of tcc without `arm-gen.c` present at all so I could be confident that I'm using MIT licensed software?
Neither of these really solve the problem if you're trying to go anywhere other than the first exit. OP is right, this is an issue with roundabouts and you end up needing traffic lights in this case (at least at peak times)
Is there any evidence (yet?) of an autoimmune disease caused by the immune system accidentally attacking part of the micro-biome?
The 727 That Vanished