techkuz

SELECT table,
    formatReadableSize(sum(bytes)) as size,
    min(min_date) as min_date,
    max(max_date) as max_date
    FROM system.parts
    WHERE active
GROUP BY table

techkuz

# List all available versions
$ pyenv versions
    system

# Install Python3 on machine as full binary
$ pyenv install 3.5.2

# Create virtualenv out of 3.5.2
$ pyenv virtualenv 3.5.2 developer
$ pyenv activate developer

techkuz

git update-index skip-worktree file

techkuz

function getParam() {
    var currUrl = window.location.href;
    var url = new URL(currUrl);
    var param = url.searchParams.get('param');
    return param;
}

techkuz

# in your template put all your mustache code inside this raw tags
{% raw %}
<script type="text/template" id="company-template">
    <a href="#companies/{{id}}/jobs" class="list-group-item">
        <h4 class="list-group-item-heading">{{name}}</h4>
        <p class="list-group-item-text">{{description}}</p>
  </a>
</script>
{% endraw %}

techkuz

1. Install npm
2. $ npm install --save-dev coffeescript
3. $ npx cake or $ npx coffee

techkuz

function getOffset(el) {
  el = el.getBoundingClientRect();
  return {
    left: el.left + window.scrollX,
    top: el.top + window.scrollY
  }
}

// https://stackoverflow.com/a/28222246/7127824
// getOffset(element).left

techkuz

alert(JSON.stringify(obj, null, 4)); // beautiful indented output.

techkuz

Install PostgreSQL 10 on Ubuntu

This is a quick guide to install PostgreSQL 10 - tested on Ubuntu 16.04

Add PostgreSQL apt repository

The current default Ubuntu apt repositories (up to 02.05.2018) only have up to postgresql-9.5. To get 10, we'll add the official postgres apt repository.

• Ubuntu 16.04: sudo add-apt-repository 'deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main'

techkuz

%PDF-1.6
%âãÏÓ
1 0 obj
<</AcroForm 59 0 R/MarkInfo<</Marked true>>/Metadata 2 0 R/Names 60 0 R/Pages 235 0 R/Type/Catalog/Perms 233 0 R/StructTreeRoot 243 0 R/NeedsRendering true>>
endobj
2 0 obj
<</Length 4114/Subtype/XML/Type/Metadata>>stream
<?xpacket begin="" id="W5M0MpCehiHzreSzNTczkc9d"?>
<x:xmpmeta xmlns:x="adobe:ns:meta/" x:xmptk="Adobe XMP Core 5.4-c005 78.150055, 2013/08/07-22:58:47        ">
   <rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#">