Ewald Benes ewaldbenes

SQLite Cache Schema

This schema provides a ready-to-use structure for caching different data types.

Types

Immutable

It efficiently stores and retrieves immutable binary and textual data, accessed by a textual key. Use the cache_blob and cache_text tables for this purpose.

	#!/bin/bash

	# Usage: ./trim-icalendar-ics foo-bar.ics 2024 06
	# Removes all events before 2024 and month May (or keeps everything from May 2024 onwards)
	# and saves the remaining events into the file foo-bar.ics.out

	# Note: current working directory must be the one where the ics file resides!

	# Note for Mac and BSD users: this script requires the GNU version of csplit and sed!

	# file_entropy.py
	#
	# Shannon Entropy of a file
	# = minimum average number of bits per character
	# required for encoding (compressing) the file
	#
	# So the theoretical limit (in bytes) for data compression:
	# Shannon Entropy of the file * file size (in bytes) / 8
	# (Assuming the file is a string of byte-size (UTF-8?) characters
	# because if not then the Shannon Entropy value would be different.)

	/**
	* Written in Typescript (v3+).
	*
	* Dependencies:
	* - rxjs >= 6
	* - firebase-tools >= 6
	*
	* Have fun!
	*
	*/