David Fahlander dfahlander

IndexedDB Safari10 bug (webkit bugzilla #158833)

IDBIndex is unreliable on Safari 10

Basically, if you have objectStores 'students' with an index 'name' and 'schools' with an index 'city', and you query the 'name' index on 'students' with no range specified (or WITH a range - it doesnt matter), you will get a cursor that iterates a mix of student names and cities. Each onsuccess callback from the cursor will have a key that sometimes is a student name and sometimes a city. The value though is always a student and some students are shown multiple times - one time with the name key and another time with a city key.

Bugzilla URL

https://bugs.webkit.org/show_bug.cgi?id=158833

Safari IndexedDB/WebSQL bug wishlist

Big overview of what's missing in Safari 7.1+ and iOS 8+ in terms of browser storage.

Updated May 25th 2016

	// This module shall be imported from BrowserWindow's main modules. The node main thread should instead import "workaround-ipc".
	// NOTE: This gist shall not be used if Electron solves issue https://github.com/electron/electron/issues/37417

	import Dexie from "dexie";
	import { ipcRenderer } from "electron";

	if ("unref" in BroadcastChannel.prototype) {
	// Node's BroadcastChannel has the `unref()` method.
	// Seems we got the Node- and not the DOM version of BroadcastChannel.
	// Only activate this workaround when we have the Node-version of BroadcastChannel

	// This module shall be imported from the main node module in electron.
	// The BrowserWindows shall instead import 'workaround-renderer.ts'
	// NOTE: This gist shall NOT be used in Electron versions where https://github.com/electron/electron/issues/37417 is resolved

	import { ipcMain } from "electron";
	import { BrowserWindow } from "electron";

	if (typeof BroadcastChannel !== "undefined") {
	// We're on electron version 23 with BroadcastChannel support in node
	ipcMain.on("dexie-storagemutated", (event, json) => {

	// On any web page that stores things in IndexedDB,
	// open devtools and in the console, write the following:
	script1 = document.createElement('script');
	script1.src = 'https://unpkg.com/[email protected]';
	document.body.appendChild(script1);
	script2 = document.createElement('script');
	script2.src = 'https://unpkg.com/[email protected]';
	document.body.appendChild(script2);

	function FriendsComponent({minAge = 75}) {
	const friends = useLiveQuery(
	() => db.friends
	.where('age').aboveOrEqual(minAge)
	.toArray()
	);

	return friends && <ul>{
	friends.map(friend =>
	<li key={friend.id}>

	import Dexie, { liveQuery } from "dexie";

	const db = new Dexie('MyDatabase');
	db.version(1).stores({
	friends: '++id, name, age'
	});

	const friendsObservable = liveQuery (
	() => db.friends
	.where('age').above(75)

	<html>
	<script src="https://unpkg.com/dexie/dist/dexie.js"></script>
	<script>
	const log = txt => console.log(txt);//document.writeln(`${txt}<br/>`);

	log (`Hello world!`);
	let db = new Dexie ('db');
	db.version(1).stores({
	friends: '++id,name,age'
	});

	<html>
	<script>
	const log = txt => document.writeln(`${txt}<br/>`);
	log("Deleting db2");
	indexedDB.deleteDatabase("db2").onsuccess = ()=> {
	log("db2 deleted");
	let req = indexedDB.open("db2", 1);
	req.onupgradeneeded = e => {
	log ("Creating db2");
	let db = req.transaction.db;

	<html>
	<script>
	document.writeln("Hello world!");
	</script>
	</html>

David Fahlander dfahlander

IndexedDB Safari10 bug (webkit bugzilla #158833)

IDBIndex is unreliable on Safari 10

Bugzilla URL

Safari IndexedDB/WebSQL bug wishlist

Safari (general)