gabidavila

MySQL NY Meetup Group Code of Conduct

Our community welcomes participants from around the world with different experiences, unique perspectives, and great ideas to share.

We are committed to providing a friendly, safe, and welcoming environment for all, regardless of age, body size, disability, ethnicity, sex characteristics, gender identity and expression, level of experience, education, socio-economic status, nationality, personal appearance, race, religion, sexual identity and orientation, or other such characteristics.

Our Standards

Everybody carry their own bucket of experience, and this is one of our greatest strengths, but it can also lead to communication issues and unhappiness.

gabidavila

use blog;

-- Count posts id
SELECT COUNT(DISTINCT id) FROM posts;
-- => 7

-- count posts id
SELECT COUNT(DISTINCT post_id) from comments;
-- => 3

gabidavila

if settings.has_key?('services')
    settings['services'].each do |service|
        service['enabled'].each do |enable_service|
            config.vm.provision "shell", inline: "sudo systemctl enable #{enable_service}"
        end if service.include?('enabled')

        service['disabled'].each do |disable_service|
            config.vm.provision "shell", inline: "sudo systemctl disable #{disable_service}"
        end if service.include?('disabled')
    end

gabidavila

# Snippet
# Enable Services
if settings.has_key?('services')
  settings['services'].each do |service|
    if service.include?('enabled')
      enable = service['enabled']
      enable.each do |enable_service|
        config.vm.provision "shell", inline: "sudo systemctl enable #{enable_service}"
      end
    end

gabidavila

All about database

Because you know I am all about database
database, database, but no trigger (4x)

I am about database, base, base

Yeah it ain't clear
This font is size 2

gabidavila

FROM composer:latest as composer

COPY src /var/www/html
WORKDIR /var/www/html

ENV COMPOSER_ALLOW_SUPERUSER 1

RUN composer install && composer dump-autoload
RUN composer require google/cloud-language

gabidavila

Connection string for JDBC driver on DataGrip

jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId={project:param};OAuthType=0;OAuthServiceAcctEmail={email:param};OAuthPvtKeyPath={secret:param}

gabidavila

WITH RECURSIVE fizz_buzz (sequence, modulo_3, modulo_5) AS (
  SELECT 1, CAST('' AS CHAR(4)), CAST('' AS CHAR(5))
  UNION ALL
  SELECT sequence + 1,
         IF(MOD(sequence + 1, 3) = 0, 'Fizz', ''),
         IF(MOD(sequence + 1, 5) = 0, 'Buzz', '')
  FROM fizz_buzz
  WHERE sequence < 100
)

gabidavila

WITH RECURSIVE traversed (id, name, path, `left`, `right`) AS (
  SELECT id,
         name,
         CAST(JSON_ARRAY(id) AS JSON),
         `left`,
         `right`
  FROM binary_tree
  WHERE id = 1
  UNION
  SELECT b.id,

gabidavila