mirzap / gist:ec6602ef1d6f4170406491eda22d43b0

Created April 1, 2025 09:00

1 million rows table - Plain JS

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8" />
	<title>Paginated Events Table</title>
	<style>
	body {
	font-family: Arial, sans-serif;
	}

mirzap / gist:5454f3c515b82c463237e7aa1f1012d4

Created April 1, 2025 08:35

Plain JavaScript large virtualized list with sorting and filtering

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8">
	<title>Virtualized Events List with Sorting and Filtering</title>
	<style>
	body {
	font-family: Arial, sans-serif;
	}

mirzap / agent loop

Created March 10, 2025 12:55 — forked from jlia0/agent loop

Manus tools and prompts

	You are Manus, an AI agent created by the Manus team.

	You excel at the following tasks:
	1. Information gathering, fact-checking, and documentation
	2. Data processing, analysis, and visualization
	3. Writing multi-chapter articles and in-depth research reports
	4. Creating websites, applications, and tools
	5. Using programming to solve various problems beyond development
	6. Various tasks that can be accomplished using computers and the internet

mirzap / query_customer_feedback.py

Created March 11, 2023 21:30 — forked from amix/query_customer_feedback.py

Use LlamaIndex and GPT-3 to query customer insights

mirzap / postgresql_recursive.sql

Created October 12, 2022 18:27 — forked from dankrause/postgresql_recursive.sql

An example of creating a recursive postgresql query to generate data about parent-child relationships within a single table.

	CREATE TABLE test
	(
	id INTEGER,
	parent INTEGER
	);


	INSERT INTO test (id, parent) VALUES
	(1, NULL),
	(2, 1),

mirzap / make_variable_check.md

Created August 30, 2022 19:47 — forked from bbl/make_variable_check.md

Makefile check if variable is defined

Check if variable is defined in a Makefile

ifndef MY_FLAG
$(error MY_FLAG is not set)
endif

mirzap / email-address-syntax-validation-let-the-browser-do-it.md

Created August 14, 2022 18:34 — forked from nepsilon/email-address-syntax-validation-let-the-browser-do-it.md

Email address syntax validation? Let the browser do it (without regexp) — First published in fullweb.io issue #77

Email address syntax validation? Let the browser do it (without regexp)

Here is a simple and robust way to check for the validity of an email address syntax directly in the browser. No need for crazy regular expressions.

e = document.createElement('input')
e.type = 'email'
// check some email addresses
e.value = 'hi@'

mirzap / fn_uuid_time_ordered.sql

Created July 16, 2022 18:21 — forked from fabiolimace/UUIDv6.sql

Function for generating time-ordered UUIDs (v6) on PostgreSQL


	/**
	* Returns a time-ordered UUID (v6).
	*
	* Tags: uuid guid uuid-generator guid-generator generator time order rfc4122 rfc-4122
	*/
	create or replace function fn_uuid_time_ordered() returns uuid as $$
	declare
	v_time timestamp with time zone:= null;
	v_secs bigint := null;

mirzap / generate_ulid_text.sql

Created July 15, 2022 17:29 — forked from kohenkatz/generate_ulid_text.sql

Postgres stuff for working with ULID

	-- From https://github.com/geckoboard/pgulid/blob/d6187a00f66dca196cf5242588f87c3a7969df75/pgulid.sql
	--
	-- pgulid is based on OK Log's Go implementation of the ULID spec
	--
	-- https://github.com/oklog/ulid
	-- https://github.com/ulid/spec
	--
	-- Copyright 2016 The Oklog Authors
	-- Licensed under the Apache License, Version 2.0 (the "License");
	-- you may not use this file except in compliance with the License.

mirzap / gist:a12ff04472d49e2aa45d965a727e93d6

Created September 30, 2021 15:57 — forked from robertsosinski/gist:1123254

Recursive breadcrumb query for Postgres

	with recursive breadcrumbs(id, parent_id, name) as (
	select id, parent_id, name
	from pages
	where id = 4
	union
	select p.id, p.parent_id, p.name
	from pages p
	inner join breadcrumbs b on p.id = b.parent_id
	)
	select * from breadcrumbs;