Sam El-Borai dgellow

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)

13 valuable things I learned using CMake

Author : Dua Guillaume
Date : 04-26-2020

Requirement : A first experience with CMake

Intro

As a modern C++ specialist, my job is to focus on software development, from a performance and quality perspective.

I've been deceiving you all. I had you believe that Svelte was a UI framework — unlike React and Vue etc, because it shifts work out of the client and into the compiler, but a framework nonetheless.

But that's not exactly accurate. In my defense, I didn't realise it myself until very recently. But with Svelte 3 around the corner, it's time to come clean about what Svelte really is.

Svelte is a language.

Specifically, Svelte is an attempt to answer a question that many people have asked, and a few have answered: what would it look like if we had a language for describing reactive user interfaces?

A few projects that have answered this question:

2015-01-29 Unofficial Relay FAQ

Compilation of questions and answers about Relay from React.js Conf.

Disclaimer: I work on Relay at Facebook. Relay is a complex system on which we're iterating aggressively. I'll do my best here to provide accurate, useful answers, but the details are subject to change. I may also be wrong. Feedback and additional questions are welcome.

What is Relay?

Relay is a new framework from Facebook that provides data-fetching functionality for React applications. It was announced at React.js Conf (January 2015).

	{-# LANGUAGE FlexibleInstances,
	DerivingVia,
	DeriveGeneric,
	DeriveFoldable,
	DeriveFunctor,
	GeneralizedNewtypeDeriving#-}
	module Main where

	import Control.Monad.Zip

	BEGIN;

	-- note: the downside of a DOMAIN type in pg is that the type cannot be modified if it's used in
	-- a composite-type column as yet (i hope we don't do that)

	-- pgTAP is a suite of test functions to test SQL scripts on PostgreSQL - see https://pgtap.org/
	CREATE EXTENSION IF NOT EXISTS pgtap;

	-- we will have 4 pgTAP tests
	SELECT plan(4);

	-- Create the raw events table
	CREATE TABLE page_views (
	site_id int,
	path text,
	client_ip inet,
	view_time timestamptz default now(),
	view_id bigserial
	);

	-- Allow fast lookups of ranges of sequence IDs

	#!/bin/bash

	# Automatically configure a VM download Coursera courses.

	# This script works as a user data file for use with a cloud VM.
	# This script will resume downloading if the VM is restarted.
	# This script works with Debian jessie (or possibly Ubuntu with systemd).

	# You must enroll in each course and accept the Honor of Code of each course
	# before you can download them.

	import os
	import opengl
	import glfw/wrapper as glfw

	var
	win: GLFWwindow
	vaoID: GLuint
	vboID: GLuint
	cboID: GLuint
	vertexShaderID: GLuint