Ir al contenido principal

When “Pre-Installed OpenWrt” Isn’t Plug-and-Play

  Lessons Learned After Finally Configuring a Raspberry Pi CM4 Mini Router (Bought in 2022) Product Mini Router built with Raspberry Pi Compute Module 4 Dual Gigabit Ethernet NICs 4GB RAM / 32GB eMMC Pre-installed OpenWrt Compact form factor, fanless, low power Background: A Device That Waited Its Turn I bought this device back in 2022 . At the time, it looked like the perfect small router: Raspberry Pi Compute Module 4 Dual Ethernet ports OpenWrt already installed No SD card required thanks to eMMC But like many homelab projects, it ended up sitting on a shelf . Fast forward to today — with more networking experience, a clearer home network plan, and a real need for a flexible router — I finally decided to configure it properly. That’s when the real journey started. What I Expected (Even in 2025) Even knowing this wasn’t a consumer router, I still expected: Plug WAN into my upstream router Plug LAN into my laptop Access 192.168.1.1 Hav...
Publicar un comentario

Algunos puntos al momento de trabajar con MYSQL

Estoy haciendo un pequeno programa, de manejo de horarios.
Decide usar MYSQL para dicha apliacion. Aqui voy a escribir algunos puntos importantes que tengo que tener en cuenta al momento de manejar mysql.

Estoy usando como sistema operativo Ubuntu 11.10. Si desean saber como instalar mysql pueden ver este link (https://help.ubuntu.com/11.04/serverguide/C/mysql.html)

Comando para ingresar a nuestra base de datos

  • mysql -u usuario -p
    donde usuario es el usuario que ustedes crearon o el usuario rooot, que es el que se crea por default. -p indica que espera el parametro de la contrasena.(Password en ingles)

Comando para crear la base de datos

  • CREATE DATABASE NOMBRE

Comando para acceder a la base de datos

  • use nombre
    Donde nombre es el nombre de la base de datos

Comando para crear una table con llave primaria

Comando para crear table con llave foranea

  • CREATE TABLE consumidor (fecha DATE NOT NULL, hora TIME NOT NULL, codigo_id INT NOT NULL, PRIMARY KEY (fecha, hora), FOREIGN KEY (codigo_id) REFERENCES nombre_table (id) ON UPDATE CASCADE ON DELETE RESTRICT) ENGINE=INNODB;

Supongamos que tenemos nuestra base de datos en un archivo te texto y deseamos importar la informacion. Este es el comando

  • LOAD DATA LOCAL INFILE '/home/diego/NetBeansProjects/a.txt' INTO TABLE nombre_table;

Espero que les sirva un poco

Etiquetas:

Comentarios

Publicar un comentario

Entradas populares de este blog

Modern Architecture for Native Apps with AWS Backend: A Practical Guide

Introduction Designing a mobile app today goes far beyond building a beautiful interface. Native apps — whether for iOS or Android — need secure authentication, user role management, real-time communication with the backend, and scalable infrastructure to support growth. In this post, I’ll walk you through a clean and modern architecture to connect native mobile apps to a robust backend on AWS. The architecture is modular, scalable, and aligned with best practices for security and performance — without relying on overly complex tools. Why it matters: apps today are more than just UI A production-grade mobile app often includes: User login (email, Google, or others), Differentiated access for multiple roles (e.g., user vs admin), Secure token-based communication, A backend capable of handling business logic and data, Data storage, asset management, and scalable APIs, Compliance with Google Play and App Store requirements. All of these require a backend architecture ...
Publicar un comentario
Leer más

How I miss you Synaptic!

Several years  have passed since we saw the Synaptic included in Ubuntu. You can found reasons here  . So in a clear english the reason was to have a better add/remove program for users. A friendly application. The explanation sounds good, I didn't complain about that, until right now. Ubuntu has change a lot, it's really a friendly user OS. I have use CLI when necessary, but today I couldn't believe it. I'm a Google Chrome user, I know you will tell me it's not open source or I should use Chromium or FF. But no. I'm a user of Google Chrome, and many people also prefer Chrome over Chromium, so why it should be quite complex remove it? If Ubuntu wants to be more friendly user why you should use the terminal for removing one of the most popular web browsers? I could understand if is a browser few people use, a good reason. But not a popular browser, Chrome is one of the most popular browsers on the world! A screen shot of the Ubuntu Software Center, trying t...
11 comentarios
Leer más

Understanding Liveness, Readiness and Startup Probes in Kubernetes

 This is a small article about understanding the liveness, readiness and startup in kubernetes.  There's good explanation in the kubernetes documentation: https://kubernetes.io/docs/tasks/configure-pod-container/configure-liveness-readiness-startup-probes/ This video also explains well the process: https://www.youtube.com/watch?v=aTlQBofihJQ But I wanted to understand it in a practical way. So I have this demo: https://github.com/DiegoTc/guest-book-js-docker/tree/Running-App-Version-1 It's a simple application running on a kubernetes cluster. https://github.com/DiegoTc/guest-book-js-docker/blob/Running-App-Version-1/argo/deployment.yaml apiVersion: apps/v1 kind: Deployment metadata: name: chat-ui spec: replicas: 1 revisionHistoryLimit: 3 selector: matchLabels: app: chat-ui template: metadata: labels: app: chat-ui spec: containers: - image: diegotc/guestbook:20230803-064434 imagePullPolicy: Alwa...
Publicar un comentario
Leer más