Discover gists

QEMU with VirtIO GPU Vulkan Support

With its latest reales qemu added the Venus patches so that virtio-gpu now support venus encapsulation for vulkan. This is one more piece to the puzzle towards full Vulkan support.

An outdated blog post on clollabora described in 2021 how to enable 3D acceleration of Vulkan applications in QEMU through the Venus experimental Vulkan driver for VirtIO-GPU with a local development environment. Following up on the outdated write up, this is how its done today.

Definitions

Let's start with the brief description of the projects mentioned in the post & extend them:

These are the tasks you might encounter in your PHP/Laravel job interviews:

Coding exercises: These may involve solving programming problems using PHP or other relevant languages, implementing algorithms, or working with data structures.
API design and implementation: You might be asked to design and implement APIs to meet specific requirements or integrate with existing systems.
Database queries: You could be given tasks that involve writing SQL queries to retrieve or manipulate data in a database.
Framework-specific tasks: You may have tasks to work with Laravel.

Converting Range in Google Spreadsheet as Image using Google Apps Script

This is a sample script for converting a range in Google Spreadsheet as an image data using Google Apps Script. Unfortunately, there are no methods for directly converting the range in Google Spreadsheet as an image data in the built-in functions. So in this case, as a workaround, Charts Service is used.

Sample script

const range = "B5:D10";
const [header, ...values] = SpreadsheetApp.getActiveSheet()
 .getRange(range)

Cloudflare Tunnel Setup on Linux

This quick guide will help you set up a Cloudflare Tunnel on your Linux server !

Cloudflare Tunnel provides you with a secure way to connect your resources to the web without a publicly routable IP address. With Tunnel, you do not send traffic to an external IP, instead, a lightweight daemon in your infrastructure (cloudflared) creates outbound-only connections to Cloudflare’s edge. Cloudflare Tunnel can connect HTTP web servers, SSH servers, remote desktops, and other protocols safely to Cloudflare. This way, your origins can serve traffic through Cloudflare without being vulnerable to attacks that bypass Cloudflare. (Source)

	#!/bin/bash

	# Production Docker Host Hardening Script v2
	# For Ubuntu Server 24.04 LTS (Noble)
	# Suitable for both Kamal deployment and builder hosts

	set -euo pipefail
	IFS=$'\n\t'

	# --- Constants ---

	/* Iconic Firefox (https://gist.github.com/emvaized/a379d61ed8970e5711ca7278a39c1895/) */
	/* based on https://gist.github.com/qaz69wsx/83a90423163b65a8344b2e60fc356a58 (now removed) */
	/* for better compatibility with dark mode, enable `svg.context-properties.content.enabled` in `about:config` */
	:root{
	--uc-popup-menu-icon-color:color-mix(in srgb, currentColor 75%, transparent);
	}
	.subviewbutton:not(.subviewbutton-iconic, [checked="true"], [targetURI])>.toolbarbutton-icon,
	.subviewbutton:not(.subviewbutton-iconic, [checked="true"], [targetURI])>.protections-popup-footer-icon {
	width:16px;
	height:16px;

	/**
	* Visualize Google Sheets Data in HTML Charts
	* By: bpwebs.com
	* Post URL: https://www.bpwebs.com/visualize-google-sheets-data-in-html-charts
	*/

	function doGet() {
	let template = HtmlService.createTemplateFromFile('Index');
	let html = template.evaluate().setTitle('Data Visualization Web App');

	## This p4ignore file is a combination of Epic's documentation, but
	## adjusted to work even if its not in the same folder as the .uproject
	## file, and the p4ignore gist from Luis Placid

	# The syntax for P4IGNORE files is not the same as Perforce syntax.
	# Instead, it is similar to that used by other versioning systems:
	#
	# - Files are specified in local syntax
	# - a # character at the beginning of a line denotes a comment
	# - a ! character at the beginning of a line excludes the file specification

	# Perforce File Type Mapping Specifications.
	#
	# TypeMap: a list of filetype mappings; one per line.
	# Each line has two elements:
	#
	# Filetype: The filetype to use on 'p4 add'.
	#
	# Path: File pattern which will use this filetype.
	#
	# See 'p4 help typemap' for more information.