dongxu c4pt0r

Infrastructure engineer / entrepreneur, CTO & Co-founder of PingCAP. Gatekeeper of TiDB

c4pt0r / filesystem.go

Created October 17, 2025 07:34

Interface

	package filesystem

	import (
	"io"
	"time"
	)

	// Common Meta keys used across all plugins
	const (
	MetaKeyPluginName = "plugin-name" // Plugin name that provides this file/directory

c4pt0r / main.go

Created April 13, 2023 00:26

Small tool to split large CSV file

c4pt0r / vortex.go

Created March 7, 2023 00:36

Vortex1.go

c4pt0r / poll.py

Created September 15, 2022 06:19

poll db for new rows, like tail -f

	#!/usr/bin/env python3
	# Usage:
	# ./poll.py --host <xxx.tidbcloud.com> --port 4000 --user <username> --password <pwd> \| jq --unbuffered .text \| grep http
	import signal
	import time
	import os
	import argparse
	import MySQLdb

	parser = argparse.ArgumentParser(description='polls db for new rows')

c4pt0r / bigetc.go

Last active June 7, 2022 01:31

bigetc.go

	package bigetc

	import (
	"database/sql"
	"time"

	"github.com/c4pt0r/log"
	_ "github.com/go-sql-driver/mysql"
	)

c4pt0r / jq.go

Last active June 11, 2025 13:27

Job Queue using TiDB

c4pt0r / gist:43950c1c34127d57c7c1cd0435e8801f

Last active June 8, 2022 19:56

Install TiUP

$ curl --proto '=https' --tlsv1.2 -sSf https://tiup-mirrors.pingcap.com/install.sh | sh

$ tiup playground

c4pt0r / How

Last active February 25, 2024 14:33

Build your own Dropbox using TiDB Cloud Free Tier + JuiceFS + AWS S3 in 2 lines.

	1. Open S3 service in AWS, create bucket and get the access point, like this: https://${bucket-name}.s3.us-west-2.amazonaws.com
	2. Go to https://tidbcloud.com and register a new free TiDB instance (10G), get a MySQL endpoint, and make sure the traffic filter is properly configured to allow public access.
	3. Install the juicefs client locally in Distributed Mode (https://juicefs.com/docs/community/getting-started/for_distributed)
	4. initialize and mount FUSE according to the following two lines:

	# juicefs format --storage s3 \
	--bucket https://${bucket-name}.s3.us-west-2.amazonaws.com \
	--access-key ${aws-access-key} \
	--secret-key ${aws-secret} \
	mysql://${mysql-user}:${mysql-password}@$your-cloud-tidb.prod.aws.tidbcloud.com:4000$/juice \

c4pt0r / zhihu.py

Last active March 28, 2020 06:56

	#!/usr/bin/env python3
	import time
	import slack
	import os
	import sqlite3

	from requests_html import HTMLSession

	client = slack.WebClient(os.environ.get('SLACK_BOT_TOKEN'))
	session = HTMLSession()

c4pt0r / index.html

Last active February 26, 2020 10:50

tiup index.html

	<!DOCTYPE html>
	<html lang="en">

	<head>
	<link href="https://cdn.bootcss.com/mini.css/3.0.1/mini-dark.min.css" rel="stylesheet">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<meta charset="UTF-8" />
	<title>TiUP</title>
	</head>