Hacker Newsnew | past | comments | ask | show | jobs | submit | inquist's commentslogin

Looks like `haptic` is local first, not local only


The summary article makes it sound like it’s somehow surprising that sea turtles can swim. The paper itself clarifies that it’s more a question of whether there are trends in the directionality of their swimming.

> Studies that compared turtle movements to oceanographic drifters suggest that swimming by young sea turtles directs their oceanic dispersal [19,21]. In addition, research in the Gulf of Mexico and South Atlantic suggests that young oceanic-stage turtles actively swim and there may be distinct differences among species in orientation, dispersal and swimming behaviour [19,21]. Understanding whether and when juvenile turtles are active swimmers or passive drifters is critical for determining dispersal trajectories, exposure and transition times in areas impacted by anthropogenic activities (e.g. oil spills) and connectivity between populations and habitats [29]. Without basic biological and behavioural data, it is difficult to improve assessments of anthropogenic impacts on protected species, necessitating conservative or precautionary approaches to management using ‘best available data’.


I thought the article was quite clear about this. They thought turtles mostly followed currents but it turns out they swim their own route.


I think failure mode analysis is definitely part of engineering


> Wright Waste Management, located in nearby Harris County

Houston is in Harris county…


It’s very near by


They probably mean outside city lines in the unincorporated part of Harris County.


Houston is Harris county.


You’ve seen Greater Houston, now meet Greatest Houston


I’ve spent so much time wrestling with and learning all (most) of these pitfalls, and I consider it time well spent. After my first few weeks I started dreaming in bash.


An obvious example of platform enshittification

https://americandialect.org/2023-word-of-the-year-is-enshitt...


Turns out frogs are smarter than we thought

https://web.archive.org/web/20240118204920/https://www.fastc...


That story actually came about from a scientist doing experiments on frogs. Frogs with removed brains. Arguably the frogs are not smarter than we thought

See https://en.m.wikipedia.org/wiki/Boiling_frog under the Experiments header.


What’s wrong with uuidv4 as PK?


Serial integers always work better than any uuid as PKs, but the thing with uuid4 is that it disrupts any kind of index or physical ordering you decide to put on your data.

Uuids are really for external communication, not in-system organization.


FWIW this isn’t true anymore with newer uuid schemes like v7 that are roughly time sortable.


Serial index forces a synchronisation point on every entity that can create records. If this is only ever a single database that’s fine but plenty of apps can’t scale this way.


They don't. Clustered databases deal with parallel generation of them just fine.

They require periodic synchronization. What isn't a big deal at all and is required by many other database features.


If you have a sharded DB, each instance can get its own range of ints, which are periodically refreshed.

PlanetScale uses int PKs [0], and they seem to have scaled just fine.

[0]: https://github.com/planetscale/discussion/discussions/366


Anything non-k-sortable in a B[+,-]tree will cause a ton of page splits. This is a more noticeable performance impact in RDBMS with a clustered index (MySQL's InnoDB, MS SQL Server) [0], but it also impacts Postgres [1] in multiple [2] ways.

[0]: https://www.percona.com/blog/uuids-are-popular-but-bad-for-p...

[1]: https://www.cybertec-postgresql.com/en/unexpected-downsides-...

[2]: https://www.2ndquadrant.com/en/blog/on-the-impact-of-full-pa...


I searched and didn’t find any identical prior comment



Is it a bot? were you able to figure anything out?


no idea, but its funny how it/he/she fetched the comment a similar reddit discussion and pasted it here...


So this 'ar9av' is a bot reposting comments or a troll?

Wonder if dang could take a look at this.


What sound should it make when it's using up your battery monitoring for freefall conditions?

Maybe some sort of radar ping... vigilance mode enabled...


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: