josejuansanchez

DROP DATABASE IF EXISTS universidad;
CREATE DATABASE universidad CHARACTER SET utf8mb4;
USE universidad;
 
CREATE TABLE departamento (
    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    nombre VARCHAR(50) NOT NULL
);

CREATE TABLE persona (

santoshshinde2012

Resources to start with Multi-tenant Architecture

Introduction

Multi tenant architecture is an ecosystem or model, in which a single environment can serve multiple tenants utilising a scalable, available, and resilient architecture. The underlying infrastructure is completely shared, logically isolated, and with fully centralised services.

SaaS Deep Dive: Designing and Building Multi-Tenant Solutions • Tod Golding • GOTO 2020

Creating a multi-tenant software-as-a-service (SaaS) application requires developers and architects to take new approaches to how they design, build, operate, and deploy their solutions. SaaS touches every dimension of your design, including how you decompose your system into services, how those services are built, how they are secured, how they store data, and how they are deployed.

karpathy

LLM Wiki

A pattern for building personal knowledge bases using LLMs.

This is an idea file, it is designed to be copy pasted to your own LLM Agent (e.g. OpenAI Codex, Claude Code, OpenCode / Pi, or etc.). Its goal is to communicate the high level idea, but your agent will build out the specifics in collaboration with you.

The core idea

Most people's experience with LLMs and documents looks like RAG: you upload a collection of files, the LLM retrieves relevant chunks at query time, and generates an answer. This works, but the LLM is rediscovering knowledge from scratch on every question. There's no accumulation. Ask a subtle question that requires synthesizing five documents, and the LLM has to find and piece together the relevant fragments every time. Nothing is built up. NotebookLM, ChatGPT file uploads, and most RAG systems work this way.

matejsemancik

Java.perform(function () {

    const versionName = 'firmware.bin';
    const changelog = 'Force upgrade to global firmware.';
    const firmwareUrl = 'https://files.catbox.moe/...';
    const md5 = 'md5HashOfFirmwareFile';

    let CheckUpdateUtil = Java.use("com.mi.fitness.checkupdate.util.CheckUpdateUtil");
    CheckUpdateUtil["compareFirmwareVersion2"].implementation = function (latestVersion, currentVersion) {
        console.log(`CheckUpdateUtil.compareFirmwareVersion2 is called: latestVersion=${latestVersion}, currentVersion=${currentVersion}`);

jcberthon

NetworkManager WiFi Power Saving

NetworkManager supports WiFi powersaving but the function is rather undocumented.

From the source code: wifi.powersave can have the following value:

• NM_SETTING_WIRELESS_POWERSAVE_DEFAULT (0): use the default value
• NM_SETTING_WIRELESS_POWERSAVE_IGNORE (1): don't touch existing setting
• NM_SETTING_WIRELESS_POWERSAVE_DISABLE (2): disable powersave

csnyder256

Build Your Own Personal AI Operating System

A brand-, harness-, and frontend-agnostic blueprint you hand to a coding agent.

This document describes how to build a persistent, always-on personal AI system: a supervised background process that turns an incoming message into either an answer or real work in a real code repository, accumulates knowledge that compounds over time, runs governed background jobs, stays reachable from your phone or terminal, and never lets a language model's context window, an untrusted document, or a compromised account cross a safety boundary.

It is not a chatbot. The intelligent layer decides and delegates. It does not hold the durable state itself. The founding rule that everything else follows from: durable state lives in files and a database, brains are ephemeral, and the coordinating kernel is small and boring. No model context outlives a single session. Anything that must survive a crash, a restart, or a model downgrade lives on disk, never in a context window.

bitsnaps

Polars Cheat Sheet

Here's a cheat sheet for the Polars Python package, covering many of its key functions and features:

Installation

pip install polars 

# Install Polars with all optional dependencies:
pip install 'polars[all]'

isao

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<!-- https://gist.github.com/isao/5f6fbe89a438086c36d8
BBEdit Language Module for TypeScript

Put this file in
   ~/Library/Application Support/BBEdit/Language Modules
or equivalent.

Forked from