omar o-az

Configuring PRAGMAs. We need to send the following PRAGMA commands right after opening the connection:

PRAGMA journal_mode = WAL;

enables write-ahead log so that your reads do not block writes and vice-versa.

PRAGMA busy_timeout = 5000;

sqlite will wait 5 seconds to obtain a lock before returning SQLITE_BUSY errors, which will significantly reduce them.

PRAGMA synchronous = NORMAL;

onNavigate, onMount, onDestroy, and beforeUpdate run in a specific order

example:

<script lang="ts">
  import { onNavigate } from '$app/navigation'
  import { onMount, onDestroy, beforeUpdate, tick } from 'svelte'

  beforeUpdate(async () => {
 console.info('beforeUpdate - tick')

	export const reactiveQueryArgs = <T>(cb: () => T) => {
	const store = writable<T>();

	$effect.pre(() => {
	store.set(cb());
	});

	return store;
	};

	sudo apt update --yes
	sudo apt upgrade --yes

	sudo apt install --yes \
	curl \
	apt-transport-https \
	ca-certificates \
	software-properties-common

	curl -fsSL https://download.docker.com/linux/ubuntu/gpg \

	echo "http://dl-cdn.alpinelinux.org/alpine/v3.20/main" > /etc/apl/repositories;
	echo "http://dl-cdn.alpinelinux.org/alpine/v3.20/community" >> /etc/apl/repositories;
	echo "http://dl-cdn.alpinelinux.org/alpine/edge/main" >> /etc/apl/repositories;
	echo "http://dl-cdn.alpinelinux.org/alpine/edge/community" >> /etc/apl/repositories;
	echo "http://dl-cdn.alpinelinux.org/alpine/edge/testing" >> /etc/apl/repositories;
	echo "http://dl-cdn.alpinelinux.org/alpine/latest-stable/main" >> /etc/apl/repositories;
	echo "http://dl-cdn.alpinelinux.org/alpine/latest-stable/community" >> /etc/apk/repositories;

	apk update

	<html lang='en'>

	<head>
	<title>GraphiQL</title>
	<Style>
	body {
	margin: 0;
	width: 100%;
	height: 100%;
	overflow: hidden;

	<!DOCTYPE html>
	<html>
	<head>
	<title>ES6 Demonstration</title>
	<style>
	.pager { margin: 5px 10px; user-select: none; font-family: sans-serif; }
	.page { display: inline-block; padding: 0 5px; cursor: pointer; }
	.page:active, .selected { color: red; }
	.selected { font-weight: bold; }
	#content { font: bold 250% sans-serif; padding: 25px 10px; }

	{
	"schema": "https://json.schemastore.org/tsconfig.json",
	"compilerOptions": {
	"strict": true,
	"baseUrl": ".",
	"noEmit": true,
	"allowJs": true,
	"checkJs": true,
	// depending on the use case
	// we might add "DOM" and "DOM.Iterable" as well

	name: 'Auto Commit Prettier'

	on:
	pull_request:
	branches: ['main']

	jobs:
	auto-commit:
	name: 'Auto Commit'
	runs-on: ['ubuntu-latest']

	function git-fzf-log
	git log --oneline --decorate --color=always \| fzf --ansi --no-sort --reverse --multi --bind 'ctrl-s:toggle-sort' \
	--header 'Press CTRL-S to toggle sort' \
	--preview 'git show --color=always {+1}' \| awk '{print $1}'
	end

	git-fzf-log \| xargs -I % git diff %^ %