Skip to content

Instantly share code, notes, and snippets.

View sistematico's full-sized avatar
🏠
Working from home

Lucas Saliés Brum sistematico

🏠
Working from home
View GitHub Profile
@sistematico
sistematico / clear-planetscale-db-drizzle.ts
Created April 13, 2024 16:31 — forked from ThimoDEV/clear-planetscale-db-drizzle.ts
A simple script to clear all the data of your planetscale DB (force-reset from PrismaORM)
// db.ts
import * as schema from "./schema"
export const db = drizzle(connection, { schema })
//reset.ts
async function reset() {
const tableSchema = db._.schema
if (!tableSchema) {
throw new Error("No table schema found")
@sistematico
sistematico / docker-compose.yml
Last active April 6, 2024 11:59
Docker: Nginx, PHP-FPM, SQLite3 (& MySQL?)
version: "3"
services:
nginx:
container_name: nginx
image: nginx:latest
ports:
- "80:80"
- "443:443"
volumes:
@sistematico
sistematico / git_large_file.md
Created April 4, 2024 23:01 — forked from naviocean/git_large_file.md
Fixing the “GH001: Large files detected. You may want to try Git Large File Storage.”

Fixing the “GH001: Large files detected. You may want to try Git Large File Storage.”

I just migrated my repositories from BitBucket to GitHub but, suddenly, I received an interesting error when I tried to push a repo with some large files inside.

remote: error: GH001: Large files detected. You may want to try Git Large File Storage — https://git-lfs.github.com.
remote: error: Trace: b5116d865251981c96d4b32cdf7ef464
remote: error: See http://git.io/iEPt8g for more information.
remote: error: File fixtures/11_user_answer.json is 131.37 MB; this exceeds GitHub’s file size limit of 100.00 MB
@sistematico
sistematico / downloads.txt
Last active February 2, 2024 10:22
ShoutCast Scripts
Downloads 64 bits:
sc_serv: https://dl.dropbox.com/s/awj65gxyighz4ro/sc_serv2_linux_x64-latest.tar.gz?dl=1
sc_trans: https://dl.dropbox.com/s/ol88p5cwy9ivhvx/sc_trans_linux_x64_10_07_2011.tar.gz?dl=1
Downloads 32 bits:
sc_serv: [FALTANDO]
sc_trans: https://dl.dropbox.com/s/zfmfh0ahdv7mjx0/sc_trans_linux_10_07_2011.tar.gz?dl=1
Para baixar o último sc_serv vá até: https://www.shoutcast.com/BroadcastNow
@sistematico
sistematico / feriados.json
Last active January 28, 2024 00:16
Json com os feriados nacionais
{
"2001-01-01": "Confraternização Universal",
"2001-02-27": "Carnaval",
"2001-04-13": "Paixão de Cristo",
"2001-04-21": "Tiradentes",
"2001-05-01": "Dia do Trabalho",
"2001-06-14": "Corpus Christi",
"2001-09-07": "Independência do Brasil",
"2001-10-12": "Nossa Sr.a Aparecida - Padroeira do Brasil",
"2001-11-02": "Finados",
@sistematico
sistematico / index.ts
Created January 20, 2024 11:04
Determinar o último dia útil não feriado
export async function ultimaDataUtil(): Date {
const path = import.meta.dir + "/../json/feriados.json";
const file = Bun.file(path);
const { feriados } = await file.json();
let dataAtual = new Date();
while (true) {
const dataFormatada = `${dataAtual.getFullYear()}-${(dataAtual.getMonth() + 1).toString().padStart(2, '0')}-${dataAtual.getDate().toString().padStart(2, '0')}`;
const dataFeriado = new Date(dataFormatada);
@sistematico
sistematico / fivem.service
Last active January 16, 2024 15:18
FiveM Server Ubuntu
[Unit]
Description=FiveM Server
[Service]
Type=oneshot
User=ubuntu
WorkingDirectory=/opt/fivem
ExecStart=/opt/fivem/fivem.sh
ExecStop=/usr/bin/tmux kill-session -t fivem
RemainAfterExit=yes
@sistematico
sistematico / nodejs
Last active January 12, 2024 18:19 — forked from wwwdata/gist:11217377
FreeBSD service script for Node.js
#!/bin/sh
# PROVIDE: nodejs
# REQUIRE: NETWORKING SERVERS DAEMON
# BEFORE: LOGIN
# File: /etc/rc.d/nodejs
# https://docs.freebsd.org/en/articles/rc-scripting
# https://man.freebsd.org/cgi/man.cgi?query=daemon
@sistematico
sistematico / config.ini
Last active December 25, 2023 18:31
Telegram Bot API
# Arquivo de configuração do Telegram Bot API Server
local = false
log = /var/log/telegram-bot-api.log
verbosity = 2
@sistematico
sistematico / GitCommitEmoji.md
Created September 28, 2023 10:54 — forked from parmentf/GitCommitEmoji.md
Git Commit message Emoji