Skip to content

Instantly share code, notes, and snippets.

View 0xTranqui's full-sized avatar

tranqui.eth 0xTranqui

106 followers · 98 following
View GitHub Profile
@0xTranqui
0xTranqui / mediaselector.tsx
Last active June 11, 2025 21:24
one shot media selector
import React, { useCallback, useEffect, useState } from "react";
import {
View,
Text,
TouchableOpacity,
FlatList,
Image,
StyleSheet,
Dimensions,
ActivityIndicator,
@0xTranqui
0xTranqui / emailtemplate.tsx
Created April 2, 2025 21:17
for anita
```
export const emailHtml = `
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<style>
@font-face {
font-family: 'River Mono';
@0xTranqui
0xTranqui / uselast.ts
Created March 6, 2025 16:31
lastvisted inbox
import { useMutation, useQueryClient } from '@tanstack/react-query'
import { now } from '@/utils/now'
import { useAuthContext } from '@/context/AuthProvider'
import { useNotificationContext } from '@/context/NotificationProvider'
export const useUpdateLastVisitedInbox = () => {
const queryClient = useQueryClient()
const { rid, sessionId } = useAuthContext()
const { updateNotificationCache } = useNotificationContext()
@0xTranqui
0xTranqui / useUriInfo.ts
Created March 5, 2025 17:52
underlying query for uri polling
import { graphql } from 'gql.tada'
import { gqlClient } from '@/utils/gql'
import { useQuery } from '@tanstack/react-query'
export const uriInfoQuery = graphql(`
query uriInfo($id: String) {
uriInfo(
where: {
id: { eq: $id }
content: { isNotNull : true }
@0xTranqui
0xTranqui / RiverRegistry.sol
Created February 3, 2025 01:01
simplified river registry
// SPDX-License-Identifier: MIT
pragma solidity 0.8.23;
import {EnumerableKeySet, KeySet} from "./EnumerableKeySet.sol";
contract RiverRegistry {
// Libraries
using EnumerableKeySet for KeySet;
@0xTranqui
0xTranqui / copyTable.ts
Created December 4, 2024 17:14
copyTable.ts
import { Client } from 'pg'
// Source database configuration
const sourceClient = new Client({
connectionString: // soruce pg
})
// Target database configuration
const targetClient = new Client({
connectionString: // target pg
@0xTranqui
0xTranqui / hehe.ts
Created October 2, 2024 19:30
idea for salief
app.post('/auth/validateSession', async (c) => {
try {
const { sessionId } = await c.req.json()
const session = await lucia.validateSession(sessionId)
const userDataForSessionId await db.query.sessions.findFirst({
with: {
auth: true
},
where: (sessions, { eq }) => eq(sessions.id, sessionId)
})
@0xTranqui
0xTranqui / hehe.ts
Created September 14, 2024 05:02
gotem
result.rows [
{
submission: {
id: "bafyr4ib6y6uz6fdfh6hx2j2m2c3674vcgkhnxhkip47r5gpxbz4uvq3lei",
text: null,
createdAt: 1726283641,
createdBy: 4,
username: "networkp",
itemId: {
id: "bafyr4icfhqzip3xb6q32jiuqshuit26lvvcewriue5wlzp2wy7kndbawam",
@0xTranqui
0xTranqui / hehe.md
Created September 14, 2024 05:01
ya

result.rows [ { submission: { id: "bafyr4ib6y6uz6fdfh6hx2j2m2c3674vcgkhnxhkip47r5gpxbz4uvq3lei", text: null, createdAt: 1726283641, createdBy: 4, username: "networkp", itemId: { id: "bafyr4icfhqzip3xb6q32jiuqshuit26lvvcewriue5wlzp2wy7kndbawam",

@0xTranqui
0xTranqui / incorporate.ts
Created September 12, 2024 15:43
expensify markdown
<MarkdownTextInput
value={markdownContent ? markdownContent : ''}
onChangeText={setCaptionText}
ref={textAreaRef}
placeholder={"What's on your mind?"}
autoFocus={true}
maxLength={300}
inputAccessoryViewID={inputAccessoryViewID}
multiline={true}
style={{