akhenakh

-- rename files to parquet: find . -type f  -exec mv {} {}.parquet \;  
-- easier for tools detection like tad

LOAD spatial;

-- Update with Geoparquet

FROM read_parquet('/opt/public_files/overturemaps/theme=places/type=place/*', filename=true, hive_partitioning=1)
     where bbox.xmin > -71.2 and bbox.xmax < -71.1 and bbox.ymin > 46.7 and bbox.ymax < 46.9
     LIMIT 1;

akhenakh

Image resizing

https://www.birme.net/?target_width=256&target_height=256

better birme with zoom https://www.presize.io/

Image Generation

AI https://pixart-alpha.github.io/

akhenakh

qemu-system-aarch64 -m 4096M -cpu host -M virt,accel=hvf \
        -bios edk2-aarch64-code.fd -serial mon:stdio -nographic \
        -drive if=virtio,file=FreeBSD.qcow2,id=hd0 \
        -device virtio-net,netdev=vmnic \
        -netdev user,id=vmnic,hostfwd=tcp:127.0.0.1:9022-:22
        
# on the guest service sshd onestart or enable sshd in rc.conf
# bios can be found here wget https://lxr.missinglinkelectronics.com/qemu/+save\=pc-bios/edk2-aarch64-code.fd.bz2

akhenakh

Right click on your connection: Edit Connection, then Driver Settings, Driver Properties tab.

Add allow_unsigned_extensions to true.

akhenakh

package main

import (
	"bufio"
	"encoding/json"
	"io"
	"os"

	"github.com/peterstace/simplefeatures/geom"
)

akhenakh

const std = @import("std");

pub fn build(b: *std.build.Builder) void {
    const target = b.standardTargetOptions(.{ .default_target = .{ .abi = .gnu } });
    const mode = b.standardReleaseOptions();

    const exe = b.addExecutable("hello-gamedev", "src/main.zig");
    exe.setTarget(target);
    exe.setBuildMode(mode);

akhenakh

input:
  label: input_geojson
  stdin:
    codec: all-bytes
    max_buffer: 1e+06
pipeline:
  processors:
    - mapping: root = this.features
    - unarchive:
        format: json_array

akhenakh

akhenakh

-- load the extension (usually mod_spatialite)
select load_extension("/opt/homebrew/lib/mod_spatialite.dylib");

-- display the current version to prove it's loaded
select spatialite_version();

-- Transform the geometry to st_astext in your queries
select st_astext(GEOM) as geom from not_enabled_airspace;

-- or as binary

akhenakh

Tools

Install required tools

brew install fzf
brew install kubectx
brew install stern
brew install kube-ps1
brew install kubecolor/tap/kubecolor