Skip to content

Instantly share code, notes, and snippets.

Create new migrations with this command:
npx wrangler d1 migrations create <DATABASE_NAME> <MIGRATION_NAME>
After creating a new migrations with the previous command - don't change the first line which starts like:
-- Migration number: 00XX 2024-12-31T16:56:07.004Z
The previous line is autogenerated.
@abuiles
abuiles / config.ini
Created September 3, 2022 17:07 — forked from orendon/config.ini
Visa appointment (renewal)
[USVISA]
; Account and current appointment info from https://ais.usvisa-info.com
USERNAME = YOUR_EMAIL
PASSWORD = YOUR_PASSWORD
SCHEDULE_ID = YOUR_ID
MY_SCHEDULE_DATE = YYYY-MM-DD
; Spanish - Colombia
COUNTRY_CODE = es-co
; Bogotá
FACILITY_ID = 26
HTTP_PORT=11626
PUBLIC_HTTP_PORT=true
LOG_FILE_PATH=""
NETWORK_PASSPHRASE="Test SDF Network ; September 2015"
UNSAFE_QUORUM=true
FAILURE_SAFETY=1
CATCHUP_RECENT=10
@abuiles
abuiles / cap33.go
Created August 10, 2020 23:56
Sample cap33 on standalone
package main
import (
"log"
"github.com/stellar/go/clients/horizonclient"
"github.com/stellar/go/keypair"
"github.com/stellar/go/txnbuild"
)
CREATE TABLE accounts(address text NOT NULL);
INSERT INTO accounts(address) SELECT md5(RANDOM()::TEXT) FROM generate_series(1, 500000);
CREATE TABLE balances(claimants JSONB NOT NULL);
CREATE INDEX balances_gin_idx ON balances USING gin(claimants jsonb_path_ops);
-- insert 500k balances, one balance per account
INSERT INTO balances(claimants)
SELECT json_build_array(json_build_object('destination',a.address,'predicate', md5(RANDOM()::TEXT))) FROM accounts as a;
package main
import (
"log"
"github.com/stellar/go/clients/horizonclient"
"github.com/stellar/go/keypair"
"github.com/stellar/go/txnbuild"
)
declare namespace xdr {
interface UINT {
readonly MAX_VALUE: 4294967295;
readonly MIN_VALUE: 0;
read(io: Buffer): number;
write(value: number, io: Buffer): void;
isValid(value: number): boolean;
toXDR(value: number): Buffer;
fromXDR(input: Buffer, format?: "raw"): number;
fromXDR(input: string, format: "hex" | "base64"): number;
@abuiles
abuiles / xdr.ts
Last active April 30, 2020 23:40
declare namespace xdr {
interface SignedInt {
readonly MAX_VALUE: 2147483647;
readonly MIN_VALUE: -2147483648;
read(io: Buffer): number;
write(value: number, io: Buffer): void;
isValid(value: number): boolean;
toXDR(value: number): Buffer;
fromXDR(input: Buffer, format?: 'raw'): number;
fromXDR(input: string, format: 'hex' | 'base64'): number;
@abuiles
abuiles / protocol13.md
Last active April 25, 2020 14:34
Protocol 13 support

Protocol 13 support

Stellar Protocol 13 is coming soon, and we need your help bringing support for it to your SDK.

The most relevant changes for SDKs are:

122927c122927
< 7cf06b94575aa6e87112fbd58fea751a3c27f30e5fbe2ae47192c79d0a56bc07,24338403,2,GDGUS6YJV4QKIQZOF7WL7BDEQ4NASB7LUYHH6RH4UB44RL3TNE3KVOHO,67319953052663812,-1794967296,1,104532644921876480,AAAAAM1JewmvIKRDLi/sv4RkhxoJB+umDn9E/KB5yK9zaTaqlQL5AADvKyQAAAAEAAAAAQAAAAAAAAAAAAAAAF0DTNYAAAAAAAAAAQAAAAAAAAAAAAAAAHIKY+bukkRIu/ORC90+OAUYd8VJsLXOY/dBdtjHcTqwAAAAFloLwAAAAAAAAAAAAXNpNqoAAABAgixOvqGdVyD/DYW3PYalzU
7cf06b94575aa6e87112fbd58fea751a3c27f30e5fbe2ae47192c79d0a56bc07,24338403,2,GDGUS6YJV4QKIQZOF7WL7BDEQ4NASB7LUYHH6RH4UB44RL3TNE3KVOHO,67319953052663812,-1794967296,1,104532644921876480,AAAAAM1JewmvIKRDLi/sv4RkhxoJB+umDn9E/KB5yK9zaTaqlQL5AADvKyQAAAAEAAAAAQAAAAAAAAAAAAAAAF0DTNYAAAAAAAAAAQAAAAAAAAAAAAAAAHIKY+bukkRIu/ORC90+OAUYd8VJsLXOY/dBdtjHcTqwAAAAFloLwAAAAAAAAAAAAXNpNqoAAABAgixOvqGdVyD/DYW3PYalzUmxdzQuNUIfxoJjfXFDCkRXlN/4UN4kSWoiMreRhbSSnEiPk/qp38qs+/r7lLQ7AA==,AAAAAAAAAGQAAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAA=,AAAAAgAAAAIAAAADAXNf4wAAAAAAAAAAzUl7Ca8gpEMuL+y/hGSHGgkH66YOf0T8oHnIr3NpNqoAAAAWcry/YQDvKyQAAAADAAA