danielnunez

version: '2'
services:
  node1:
    image: mariadb:10.1
    environment:
      - TERM=xterm
      - MYSQL_ROOT_PASSWORD=admin
      - MYSQL_INITDB_SKIP_TZINFO=1
    volumes:
      - ~/Dev/docker/compose/galera/conf.d:/etc/mysql/conf.d

danielnunez

Pasos para instalar Docker en una Raspberry PI 2/3 corriendo raspbian

Este es un instructivo para un tutorial en Youtube https://youtu.be/pliGG1M87W8

1. Descargar e instalar raspbian en tu micro SD

• Descargar https://downloads.raspberrypi.org/raspbian_lite_latest
• Descargar a instalar Etcher (para instalar en la SD) https://etcher.io/
• Instalar imagen en la SD

2. Una vez que raspbian está instalado:

• Cambiar password de usuario Pi (recomendado)

danielnunez

Since I spent essentially two full days figuring out how to access a corporate MS SQL database pythonicly, I figured I should leave some notes, for future reference and to aid other souls looking to do the same.

These instructions and the commands that follow, were executed on a MAC OS 10.8.3 system. Additionally, I found this blog [post][1] especially helpful during the debugging process.

On mac os, there is a default ODBC manager, iODBC. Other Unix based systems tend to use [unixODBC][2]. Look elsewhere for a discussion about the differences between these driver managers. The only feature we care about is being able to connect to SQL databases through [pyodbc][3], and at the time of this writing [pyodbc][3] requires iODBC as its manager.

Start by installing freeTDS libraries. FreeTDS allows unix programs to talk natively with MS SQL and SyBase databases.

brew intsall freetds

danielnunez

CREATE TABLE "City" (
    id integer NOT NULL,
    name text,
    region_id integer
);

INSERT INTO "City" (id, name, region_id) VALUES (15101, 'Arica', 15);
INSERT INTO "City" (id, name, region_id) VALUES (15102, 'Camarones', 15);
INSERT INTO "City" (id, name, region_id) VALUES (15201, 'Putre', 15);
INSERT INTO "City" (id, name, region_id) VALUES (15202, 'General Lagos', 15);

danielnunez

#!/bin/bash

SITIO="$1"
USUARIO="$2"
PUERTO="22"
REPOSITORIO_REMOTO="/var/repo/$SITIO"
SHEBANG="#!/bin/bash"
SITIO_HTDOCS="/var/www/$SITIO"
read -r -d '' HOOK <<EOF
${SHEBANG}

danielnunez

Los valores en las columnas VARCHAR cadenas de longitud variable. 
La longitud puede ser especificado como un valor de 0 a 255 antes 
de MySQL 5.0.3, y de 0 a 65.535 en 5.0.3 y versiones posteriores. 
El efectivo máximo de la longitud de un VARCHAR en MySQL 5.0.3 y 
luego está sujeta a que el tamaño máximo de fila (65.535 bytes, 
el cual es compartido entre todas las columnas) y el conjunto de 
caracteres utilizado.

Uso TEXT tipos.
Los cuatro tipos de TEXTO son TINYTEXT, TEXT, MEDIUMTEXT, y LONGTEXT.