gabidavila

Why ?

If you intend to stop using Protonmail, non of this is required however if you just want to clear down unwanted emails and claim back storage quota this may be of use.

According to ProtonMail support in normal operation you need to move emails to the delete folder then go into the delete folder and delete all to get rid of them.

This way youre 'all mail' folder wont just fill up eternally, increasing storage and thus require to buy more storage

Also if youve got a paid plan and wish to delete an associated domain name, you can't do this untill all emails that are addressed to that domain have first been deleted.

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,