Jari Pennanen Ciantic

Ciantic / suspend-tty.sh

Last active October 28, 2025 08:27

Suspend from tty script

	#!/bin/bash

	# Gnome-shell+Nvidia sometimes fails to suspend, os instead change to tty3 and suspend from there, then return to tty2.

	set -e

	# Current wakeup count
	WAKEUPS=$(cat /sys/power/wakeup_count)

	# switch to TTY3 and suspend

Ciantic / tailwind-daisyui-expanding-search.html

Last active September 29, 2025 12:15

Tailwind4, DaisyUI 5 auto-expanding search field with button appearing on the right

	<form className="inline-flex input pl-[2.5em] pr-0 w-0 has-[input:not(:placeholder-shown)]:w-[250px] focus-within:w-[250px] has-[input:not(:placeholder-shown)]:[&_.btn]:block transition-[width] duration-300 ease-in-out has-[input:placeholder-shown]:border-transparent has-[input:placeholder-shown]:shadow-none" method="GET" action="/search">
	<label className="overflow-hidden flex-1">
	<div className="h-[100%] w-[2.5em] absolute left-0 top-0 cursor-text">
	<svg
	aria-hidden="true"
	className="h-[1em] w-[1em] absolute left-[0.2em] top-1/2 -translate-y-1/2 ml-2"
	xmlns="http://www.w3.org/2000/svg"
	viewBox="0 0 24 24"
	>
	<g

Ciantic / tsdown.config.ts

Created September 17, 2025 09:18

1-to-1 bundling with tsdown

	import { defineConfig } from "tsdown";

	// Try to create 1-to-1 file mapping between src and dist
	export default defineConfig({
	entry: "./src/*/.(ts\|tsx)",

	// Generate package.json `exports` property automatically
	// exports: {
	// devExports: true,
	// },

Ciantic / solid-js-todos-with-stores.ts

Last active August 21, 2025 14:47

SolidJS TODO example with logical createStore and methods

	import { render } from "solid-js/web";
	import { For, createSignal } from "solid-js";
	import { createStore, produce } from "solid-js/store";

	/**
	* Reusable todo store, with logical state change functions
	*/
	function createTodos(initialTitle: string) {
	const createTodo = (id: number, task: string) => ({
	id,

Ciantic / parse-postgresql-to-typescript.ts

Last active July 6, 2025 10:04

Parse PostgreSQL schema, and output types

	import { deparse, parse } from "npm:pgsql-parser";
	import type { Node, ParseResult } from "npm:@pgsql/types";

	const schemaSql = `
	-- PostgreSQL schema
	CREATE TYPE my_enum_example AS ENUM ('good', 'bad', 'ugly', 'dont know');

	CREATE TABLE
	"various_types" (
	"bigserial" bigserial primary key,

Ciantic / stop-asus.ps1

Last active June 24, 2025 10:00

Stop ASUS services automatically

	# EDIT: There is more comprehensive debloat instructions here: https://github.com/sammilucia/ASUS-G14-Debloating/blob/main/README.md

	# Get services starting with "Asus*" to a variable
	$services = Get-Service -Name "Asus*"

	# Stop services
	foreach ($service in $services) {
	# Print service
	Write-Host "STOP" $service.Name
	Stop-Service -Name $service.Name

Ciantic / pglite-kysely-driver-simple.ts

Last active March 1, 2025 19:31

Simple PGLite kysely driver

	import * as k from "npm:kysely";
	import { PGlite } from "npm:@electric-sql/pglite";

	function createPgLiteDialect(db: PGlite) {
	return {
	createDriver: () =>
	({
	acquireConnection: () => {
	return Promise.resolve({
	executeQuery: async (compiledQuery) => {

Ciantic / deno-example.ts

Created April 14, 2024 21:43

Deno example of mmomtchev/sqlite-wasm-http

	import { createSQLiteThread, createHttpBackend } from "npm:sqlite-wasm-http";

	// This is required hack:
	const OldWorker = globalThis.Worker;
	// @ts-ignore: Default to module workers
	globalThis.Worker = class {
	constructor(url: URL, opts: any = {}) {
	return new OldWorker(url, { type: "module", ...opts });
	}
	};

Ciantic / nodejs-postgresql-timestamp.js

Created October 12, 2023 10:28

nodejs-postgresql-timestamp.js

Ciantic / sqlite3.html

Last active November 11, 2024 17:02

Example how to use official SQLite3 WASM with ESM modules

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8" />
	<meta http-equiv="X-UA-Compatible" content="IE=edge" />
	<meta name="viewport" content="width=device-width, initial-scale=1.0" />
	<title>Document</title>
	</head>
	<body>
	LOOK AT THE CONSOLE