Halama

select t1.query_type, 
    t1.avg_time as current_avg,
    t2.avg_time as previous_avg,
    t1.avg_time / t2.avg_time as performance_ratio    
    
from 

  (select query_type, count(*) as query_count, avg(total_elapsed_time) as avg_time
  from table(information_schema.query_history_by_user(
    'ct_us_keboola_3292', 

Halama

{
    "AWSTemplateFormatVersion": "2010-09-09",
    "Resources": {
        "S3FilesBucket": {
            "Type": "AWS::S3::Bucket",
            "Properties": {
                "CorsConfiguration": {
                    "CorsRules": [
                        {
                            "AllowedHeaders": [

Halama

{
  "parameters": {
    "api": {
      "baseUrl": "https:\/\/api.intercom.io",
      "authentication": {
        "type": "basic"
      },
      "http": {
        "defaultOptions": {
          "headers": {

Halama

{
    "authorization": {
      "oauth_api": {
        "id": "new-template-60"
      }
    },
    "parameters": {
      "api": {
        "authentication": {
          "type": "oauth10"

Halama

{
  "parameters": {
    "api": {
      "baseUrl": "http://api.fixer.io/"
    },
    "config": {
      "outputBucket": "currency",
      "incrementalOutput": true,
      "jobs": [
        {

Halama

{
  "parameters": {
    "api": {
      "baseUrl": "https://slack.com/api/"
    },
    "config": {
      "outputBucket": "slack",
      "debug": true,
      "jobs": [
        {

Halama

POST /activity
{"settings" : {
        "number_of_shards" : 1
    },
    "mappings" : {
        "activity" : {
            "properties": {
                "id": {
                    "type": "long"
                },

Halama

React = require 'react'


SearchRow = React.createClass
  displayName: 'SearchRow'
  propTypes:
    query: React.PropTypes.string.isRequired
  componentDidMount: ->
    @refs.searchInput.getDOMNode().focus()
  render: ->

Halama

Skripty které pollují frontu a spouštějí joby nespouštíme cronem ale máme nahozený pevně daný počet workerů. O udržování workerů při životě se stará Upstart http://upstart.ubuntu.com/getting-started.html

Konfigurace jobu

Pod rootem vytvořit soubor /etc/init/nazev-jobu.conf s obsahem:

instance $N
respawn
exec su -s /bin/sh -c 'exec "$0" "$@"' deploy -- php /cesta/k/memu-skriptu

Halama

<?php

$csvFile = new CsvFile(__DIR__ . '/_data/simple.csv');

$cols = $csvFile->getHeader());

$csvFile->next();
while($csvFile->valid()) {
	$row = $csvFile->current();
	var_dump($row);