amatix

Joined 14 years ago

Karma
445
Submissions
140
Member since
May 17
http://koordinates.com founder, open source contributor, map geek, sailing enthusiast. Was in New Zealand, now in Scotland.

Get in touch at [email protected] or @amatix on twitter.

[ my public key: https://keybase.io/rcoup; my proof: https://keybase.io/rcoup/sigs/erPE3dtWlicE8kWtYvVC7tPg_tSaXjaIMEueKWz0bH0 ]

View on Hacker News

Recent submissions

Comment · 2 years ago
Comment · 2 years ago
Comment · 2 years ago
Comment · 2 years ago
Even today the LEGO-compatible knock-offs are complete junk, my kids occasionally end up picking up a loose bag for £1 from the local charity shop. Pieces don't stick together properly (with each other, let alone LEGO pieces); legs, arms, and hands come off the minifigs; etc. You can instantly tell — even ignoring the assault rifles that would never make it in a LEGO box.
Comment · 2 years ago
> Spotify reported that it had 9,400 employees at the end of the third quarter of 2023. It had already cut back employee numbers by 6% in January and by a further 2% in June.
Comment · 3 years ago
Comment · 3 years ago
Good questions

> Are the raw files in the working repository GeoPackages?

The working copy for a vector/table dataset can be in a GeoPackage or a SQL database like PostGIS. For rasters/point-clouds they're flat files.

> How is it tracking the changes made inside the geopackages?

In general, triggers which store RowIDs/PKs of inserts/updates/deletes. Then when you ask for a diff or make a commit Kart figures out any actual row-level (or schema) differences.

> What happens if it's replaced with an updated copy of the geopackage the was edited via some other application?

If it's edited by something else (QGIS, ArcGIS, python/go/whatever application, SQL CLI, whatever) it'll work: you do edits where you want to. If it's replaced by something else, it won't work.

> How does it diff the changes?

Comparing the features/rows in the repository (and their schemas) against the rows in the working copy database. It uses the stored list of modified rowids to make this fast.

Comment · 3 years ago
Comment · 3 years ago
The BluMartin FreshAir 100 and the Fresh-R series are both MVHR units that fit into existing walls: there’s a Fresh-R model that goes into a window frame too.
Comment · 4 years ago
Different brands vary, but IME this is only correct for a few weeks at best. Otherwise you'll get a lot of residue, and if it's been outside exposed to UV you'll get even more. And duck tape is worse.
Comment · 5 years ago
Comment · 5 years ago
Comment · 5 years ago
I'd argue the official spec is now https://commonmark.org/ - it was partially reversed from the actual implementations in use and their behaviours, and is very highly specific compared to the original guide.
Comment · 5 years ago
TripMode (https://tripmode.ch/) for filtering application Internet access when you're running on mobile data uses a kernel extension.

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton