dtheodor

Install MariaDB Columnstore on Centos 6 - Single server as root installation

Information put together from

https://mariadb.com/kb/en/mariadb/preparing-for-columnstore-installation/

https://github.com/mariadb-corporation/mariadb-columnstore-vagrant/blob/master/bootstrap.sh

Install some prerequisites

dtheodor

Goal

1. Look into the RAML spec for Web APIs, and ways to visualize it (e.g. raml to html).

http://raml.org/ 2. Automatically generate a RAML spec for a basic web API built using django rest framework Serializers and APIViews

http://www.django-rest-framework.org/api-guide/serializers/

http://www.django-rest-framework.org/api-guide/views/

dtheodor

Jenkins stuff

Ideas on what to do per build, when to trigger builds, etc.

Basic build per project

• compile
  • triggers build failure
• run unittests
• triggers build unstable

dtheodor

Oracle with SQLAlchemy on Ubuntu

Installation

Download and install all instant client rpms from the Oracle website. For version 11.2.0.4.0 you probably need at least

oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm

dtheodor

Task callbacks, dependencies, cached results

Discussion on a celery API and implementation that solves

1. Ability to dynamically add callbacks to already running tasks
2. Tasks with dependencies
3. Caching/invalidating task results
4. Being able to stop/restart a task

Async result that allows adding callbacks

dtheodor

Problem:

• There's a module that knows how to load (and re-load) data through an API, and stores it locally.
• Multiple modules access the loaded data, and transform them into a different representation (each module does a different transform), also storing them locally
• The transformed data is exposed to the view, with a 'loading' indication when the original data is (re)loaded and/or the transformation is in progress.

##API idea

Promises support:

• on resolution callbacks, where the transform function can be attached.
• a isResolved attribute, which is false when the promise has been started but not yet resolved.

dtheodor

app.js

define(['angular', 'login', 'charts', 'routes'],
function(angular, login, charts, routes){
  'use strict';

  angular.module('app', [
      login.name,
      charts.name
      ...

dtheodor

import select
import datetime

import psycopg2
import psycopg2.extensions

from sqlalchemy import create_engine, text

engine = create_engine("postgresql+psycopg2://vagrant@/postgres")

dtheodor

import select
import datetime

import psycopg2
import psycopg2.extensions

conn = psycopg2.connect(database="postgres", user="vagrant")
#conn.set_isolation_level(psycopg2.extensions.ISOLATION_LEVEL_AUTOCOMMIT)

curs = conn.cursor()

dtheodor

from sqlalchemy_continuum import get_versioning_manager

class VersionBase(object):
    """Base class for SQL Alchemy continuum objects that supports tagging"""
  
    @classmethod
    def tag_current_transaction(cls, **kwargs):
        """Add keyword arguments that will be stored as a `TransactionMeta`
        entry on next successful commit that includes versioned objects.
        """