👋

Ricardo Sawir sawirricardo

👋

Full Stack Developer - Golang - iOS SwiftUI - Android Jetpack Compose - Laravel - Rust

sawirricardo / AppServiceProvider.php

Last active April 15, 2025 14:42

Better defaults for your laravel projects, inspired by Nuno Maduro

	<?php

	namespace App\Providers;

	use Carbon\CarbonImmutable;
	use Illuminate\Database\Eloquent\Model;
	use Illuminate\Support\Facades\Date;
	use Illuminate\Support\Facades\DB;
	use Illuminate\Support\Facades\Http;
	use Illuminate\Support\Facades\URL;

sawirricardo / Dockerfile

Last active April 16, 2025 05:04

Deploy Laravel app to Coolify or any docker-compose deployment

	# Versions
	# https://hub.docker.com/r/serversideup/php/tags?name=8.4-fpm-nginx-alpine
	ARG SERVERSIDEUP_PHP_VERSION=8.4-fpm-nginx-alpine
	# https://github.com/minio/mc/releases
	ARG MINIO_VERSION=RELEASE.2025-03-12T17-29-24Z
	# https://github.com/cloudflare/cloudflared/releases
	ARG CLOUDFLARED_VERSION=2025.2.0
	# https://www.postgresql.org/support/versioning/
	ARG POSTGRES_VERSION=17

sawirricardo / index.html

Created February 14, 2024 05:20

web libraries

	<!DOCTYPE html>
	<html>
	<head>
	<meta name="charset" content="utf-8"/>
	<meta name="csrf-token" content={ CSRF(ctx) }/>
	<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"/>
	<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.1/css/all.min.css" integrity="sha512-DTOQO9RWCH3ppGqcWaEA1BIZOC6xxalwEsw9c2QQeAIftl+Vegovlnee1c9QX4TctnWMn13TZye+giMm8e2LwA==" crossorigin="anonymous" referrerpolicy="no-referrer"/>
	<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css" integrity="sha384-xOolHFLEh07PJGoPkLv1IbcEPTNtaed2xpHsD9ESMhqIYd0nLMwNLD69Npy4HI+N" crossorigin="anonymous"/>
	<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/adminlte.min.css"/>
	<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/unpoly.min.css"/>

sawirricardo / install_packages.sh

Last active August 17, 2024 03:13

go almost must use libraries

	go get -u github.com/joho/godotenv;
	go get -u github.com/a-h/templ;
	go get -u github.com/manifoldco/promptui;
	go get -u github.com/go-chi/chi/v5;
	go get -u gopkg.in/gomail.v2;
	go get -u github.com/amacneil/dbmate/v2/pkg/driver/postgres;
	go get -u github.com/jackc/pgx/v5/pgxpool;
	go get -u github.com/gorilla/sessions;
	go get -u github.com/gorilla/csrf;
	go get -u github.com/google/uuid;

sawirricardo / select_types_postgres.sql

Created January 20, 2024 08:31

Select types for postgresql

	select
	t.typname as name,
	n.nspname as schema,
	t.typtype as type,
	t.typcategory as category,
	(
	(
	t.typinput = 'array_in'::regproc
	and t.typoutput = 'array_out'::regproc
	)

sawirricardo / select_views_postgres.sql

Created January 20, 2024 08:24

Select views for postgresql

	select
	viewname as name,
	schemaname as schema,
	definition from pg_views
	where
	schemaname not in ('pg_catalog', 'information_schema')
	order by
	viewname;

sawirricardo / select_tables_for_postgres.sql

Last active January 20, 2024 08:41

get all tables postgreSQL

	select
	c.relname as name,
	n.nspname as schema,
	pg_total_relation_size (c.oid) as size,
	obj_description (c.oid, 'pg_class') as comment
	from
	pg_class c,
	pg_namespace n
	where
	c.relkind in ('r', 'p')

sawirricardo / HasPeriodColumns.php

Last active December 19, 2023 15:16

HasPeriodColumns

	<?php

	namespace App\Support\Traits;

	use Carbon\CarbonInterface;
	use Illuminate\Contracts\Database\Eloquent\Builder;

	trait HasPeriodColumns
	{
	public function scopeOverlapping(Builder $query, CarbonInterface $start, CarbonInterface $end, string $startColumn, string $endColumn): Builder

sawirricardo / TransactionEncapsulation.php

Last active November 22, 2023 13:33

It captures responses, handles DB transactions, and allows custom error messages.

	<?php

	namespace App\Http\Middleware;

	use Closure;
	use Illuminate\Http\Request;
	use Illuminate\Support\Facades\DB;

	class TransactionEncapsulation
	{

sawirricardo / app.blade.php

Created September 4, 2023 15:56

Handle 419 token expired