The Q3 2025 Issue of the FreeBSD Journal is here!
-
The Q3 2025 Issue of the FreeBSD Journal is here!
This edition focuses on Embedded FreeBSD and features articles covering:
- Starting Firewall Development: Interview with Igor Ostapenko
- FreeBSD, Home Assistant, ant rtl_433
- Writing Effective Bug Reports
- Implementing a Quantum-Safe Website on FreeBSDAnd much more!
Read it here https://freebsdfoundation.org/our-work/journal/browser-based-edition/embedded-2/
-
undefined Stefano Marinelli ha condiviso questa discussione su
Gli ultimi otto messaggi ricevuti dalla Federazione
-
-
Milano: diritto alla casa e agli spazi sociali. Diario di un’estate di lotta
@anarchia
Dopo le mobilitazioni contro il Decreto Sicurezza, che tra le altre cose sanziona pesantemente chi occupa per necessità, c’è stata una forte ripresa di iniziative per rivendicare tale diritto. Il periodo estivo a Milano è stato particolarmente denso di mobilitazioni...
-
@theverge @the-verge-theverge That sucks
-
@StarTrekScreens hell yeah let's do this
-
@Steve I went down the rabbit hole by searching for "EZLN". It looks like there isn't an official account but a lot of discussion and shared content.
https://schoolsforchiapas.org/the-commons-zapatistas-launch-a-new-stage-of-autonomy/
-
3 October 1934 | A Polish Jewish girl, Nina Ehrlich, was born in Sosnowiec.
In 1943 she was deported to #Auschwitz from Będzin ghetto. She was murdered in a gas chamber.
---Children at Auschwitz
Lesson: https://lekcja.auschwitz.org/dzieci_EN/
Podcast: https://youtu.be/aYKx_zpLSqA
-
Implementing a Kalman Filter in PostgreSQL to Smooth GPS Data
Usually databases are treated primarily as fairly dumb data storage systems, but they can be capable of much more. Case in point the PostgreSQL database and its – Ada-based – PL/pgSQL programming language, which allows you to perform significantly more complex operations than would be realistically possible with raw SQL. Case in point the implementation of a Kalman Filter by the folk over at Traconiq, which thus removes the necessity for an external filtering pipeline.
Using a Kalman Filter is highly desirable when you’re doing something like vehicle tracking using both dead-reckoning and GPS coordinates, as it filters out noise that can be the result of e.g. GPS reception issues. As noted in the article, transferring state from one row to the next requires a bit of lateral thinking, but is doable with some creative SQL usage. As PL/pgSQL is very similar to Oracle’s PL/SQL, this same code should work there too without too much porting required.
The code for the different implementations and associated benchmarks can be found on GitHub, though the benchmark results make it abundantly clear that the most efficient approach is to run an offline aggregate processing routine. This coincides with the other batch processing tasks that are typically performed by a database server to e.g. optimize storage, so this isn’t entirely unsurprising.
-
This post did not contain any content.
