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

An alleged implementation of PhotoDNA was posted to GitHub a few weeks ago:

https://github.com/ArcaneNibble/open-alleged-photodna/


Possibly of interest: https://mace.home.blog/

Frustratingly, though, they haven't released any source code yet.


That's the same as Executor, or some similar project with GNU/Linux with was exactly what Mace does with a free license.

https://www.v68k.org/advanced-mac-substitute/

What I would like to see it's the full OS reimplementation a la AROS m68k.

There are Minivmac ports for 9front. Exegutor it's made in C++, so no way to compile it with NPE (micro-POSIX compat layer for 9front). If anyone had that under MiniVmac, it could run everywhere.

On Advanced Mac Substitute, as it has an SDL2 interface, it can be almost done unless it's written in C++. If it's ANSI C or C99, it might run under 9front.


I bet there's some way to make the GPU do the color conversion. It's not like it's doing much otherwise...

It looks like copying from EFB to XFB can do an RBG to YUV conversion automatically.

YUV is a color model, akin to RGB or HSL; it's independent of video formats like NTSC or PAL.

That's true in broad strokes, but looking into it, it turns out NTSC's variant of YUV is called YIQ, and SECAM's variant is called YDbDr. They are however all more or less the same thing, and the digital YUV used by the Wii hardware in this case is presumably independent of the video standard.

... with some extra holes in it, no less.

> although it is not clear to me how much alive is the project

It's essentially dead. There are very few practical applications for it - modern embedded RTOSes are better suited to low-memory MMU-less parts, and SoCs with a MMU and more memory that can run a "real" Linux aren't very expensive.



Yes, using the table-valued JSON functions like JSON_EACH and JSON_TREE (which works recursively). Details: https://sqlite.org/json1.html#table_valued_functions_for_par...

One handy bit of SQLite's JSON features which isn't called out in this article is the short syntax, e.g.

    SELECT payload->>'$.user.id' AS user_id FROM events ...
This works a little more consistently than JSON_EXTRACT - the -> operator always returns a JSON string; the ->> operator (used here) always returns a SQL scalar (text, number, or null). More details: https://sqlite.org/json1.html#jptr

> Frankenstein desktops built from heavily used 10+ year old Xeons running on suspicious motherboards made by obscure Chinese manufacturers you've never heard of.

I've heard reports that these are actually surprisingly good. I wouldn't want to use one in a production environment, but for homelab stuff they're an incredible deal.


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

Search: