pesterhazy

This gist lists challenges you run into when building offline-first applications based on IndexedDB, including open-source libraries like Firebase, pouchdb and AWS amplify (more).

Note that some of the following issues affect only Safari. Out of the major browsers, Chrome's IndexedDB implementation is the best.

Backing file on disk (WAL file) keeps growing (Safari)

When this bug occurs, every time you use the indexeddb, the WAL file grows. Garbage collection doesn't seem to be working, so after a while, you end up with gigabytes of data.

Random exceptions when working with a large number of indexeddb databases (Safari)

dpid

How to notarize a Unity build for macOs 10.15 Catalina

As of January 2020, all apps running on macOs 10.15 Catalina are required to be notarized. For Unity games distributed outside the Mac App Store, such as with Steam, the notarization process is done post build using a series of Xcode command line tools.

Prerequisites

• a Mac that is compatible with macOs 10.15 Catalina :
  • MacBook (2015 or newer)
  • MacBook Air (2012 or newer)
• MacBook Pro (2012 or newer)

rsms

Fixing macOS 10.14, 10.15, 12

Dark main menu without the rest of dark mode

1. Set Light mode
2. defaults write -g NSRequiresAquaSystemAppearance -bool Yes
3. Log out and log back in
4. Set Dark mode

radiatoryang

// mostly from https://github.com/dsoft20/psx_retroshader
// mixed with parts of https://github.com/keijiro/Retro3D
// under MIT license by Robert Yang (https://debacle.us)

Shader "Custom/VertexLit-Retro3D" {
	Properties{
		_MainTex("Base (RGB)", 2D) = "white" {}
		_Color("Color", Color) = (0.5, 0.5, 0.5, 1)
		_GeoRes("Geometric Resolution", Float) = 40
	}

Split82

Shader "Name" {

    Properties {

        _Name ("display name", Range (min, max)) = number
        _Name ("display name", Float) = number
        _Name ("display name", Int) = number
        _Name ("display name", Color) = (number,number,number,number)
        _Name ("display name", Vector) = (number,number,number,number)

keijiro

ppolsinelli

YOUR METHOD HERE - BEGIN

if (SOME_CONTROL_OF_YOURS && Application.isEditor)
            {
                Action<string> commCallback = (csv) =>
                {
                    LoadCSVText(csv);
                };
                StartCoroutine(DownloadCSVCoroutine(spreadSheetId, commCallback, true, "YOUR_ASSET_NAME_NO_EXT", tabId));

Draknek

#!/usr/bin/env python3
import os
import sys
import time
import zipfile

startingdir = os.getcwd()

if (len(sys.argv) == 1):
	print("Usage: " + os.path.basename(sys.argv[0]) + " path/to/application.app [path/to/output.zip]")

smkplus

Shader "MaterialPropertyDrawer"
{
Properties
{
_MainTex("Texture", 2D) = "white" {}
 
[HideInInspector] _MainTex2("Hide Texture", 2D) = "white" {}

yumayanagisawa

#pragma kernel CSParticle

 // Particle's data
struct Particle
{
	float3 position;
	float3 velocity;
	float life;
};