Sergey Melekhin C-Pro

## audit_trail.sql
create table t1(x int);
create table t2 (x int, y varchar);
create table audit_trail(
    id bigserial primary key,
    table_name varchar,
    data_before jsonb,
    data_after jsonb,
    ts timestamp
);

## mapbench_test.go
package main_test

import "testing"

func BenchmarkBoolMap(b *testing.B) {
	m := map[int]bool{}
	for i := 0; i < b.N; i++ {
		m[i] = true
	}
}

## zeroisnull.go
// https://go.dev/play/p/gTzl_yht11I

package main

import (
	"database/sql/driver"
	"fmt"
)

type valuer[T comparable] struct {

## null_uint.go
package main

import (
	"context"
	"database/sql"
	"database/sql/driver"
	"fmt"
	"strconv"
	"time"

## fires_twice.sql
--Before update or insert trigger
--fires twice when INSERT .. ON CONFLICT(uk) DO UPDATE operation
--fails to insert and does the update part.
--First it will be called with TG_OP='INSERT'
--and then with TG_OP='UPDATE'

create table t1 (x int);
create unique index t1_ui on t1(x);
create table t1_log(x int, op varchar(100), ts timestamp default clock_timestamp());

## neq_test.go
package main_test

import (
	"testing"
)

func cmp(a, b string) bool {
	if len(a) != len(b) {
		return false
	}

## my-talks.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                C-Pro
                / my-talks.md
            
            
              Last active
              June 7, 2020 12:33
            
              
                Видео моих выступлений на конференциях
              
          
    Видео моих выступлений на конференциях


2020 Developers Sabbath: Что хуже, DRY или SOLID? https://youtu.be/1Op-Oy745dE?t=8691
2017 DevFest Siberia: Build a robot: https://www.youtube.com/watch?v=RYwvCIpuB-U
2017 I/O Recap Siberian edition: https://youtu.be/FRhuN8CsLw0?t=3h8m30s
2017 VLDC Lite: Docker для тестирования и деплоя https://www.youtube.com/watch?v=-zxWm-dBW_c
2016 Новосибирск DevFest: Светлое будущее с Machine Learning https://www.youtube.com/watch?v=wLpkbekRNGw
2015 Москва Pgconf.ru: https://pgconf.ru/2015/89397
2014 Владивосток VLDC: Халява, Плиз https://www.youtube.com/watch?v=4oGRf30rKGE
2012 Владивосток VLDC: Волков не бояться http://video.vvsu.ru/vieweven/id/10290852/vtoraya_vladivostokskaya_konferenciya_razrabotchikov


## frontend_task_excel_en.md

      
              1 file
            
          
              1 fork
            
          
              0 comments
            
          
              0 stars
            
          
                C-Pro
                / frontend_task_excel_en.md
            
            
              Created
              May 15, 2020 00:36
            
          
    ExcelJS

The task is to make an Excel-like table with support for the simplest formulas.
Recalculation of values in the cells should occur immediately upon loss of focus and affect only those cells whose values should be changed.
Do not recalculate the whole table every time (if not necessary).
Use pure JS (ES6), HTML, CSS. Use third-party frameworks, libraries is not encouraged for this task.
Task result will be viewed with the latest version of chrome (desktop and mobile).
Let the table size be 100x1000 (WxH)

  
## sunny_days.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                C-Pro
                / sunny_days.md
            
            
              Last active
              May 13, 2020 06:09
            
          
    Your task is to build one page web application.
It will allow user to see length (in days) of continuous periods of sunshine in a given city:

Historical longest period of sunny days in given city
Longest period in current month
Length of current period of sunshine

Length of sunny days period is a number of consecutive days in a given city when the sun is shining (no overcast clouds, no precipitation).
User can select city from dropdown list and frontend should request for data from backend without reloading the page (e.g. REST or smth. similar). Request should be processed in less then 30ms (our service will be very popular!).

  
## concatbench_test.go
package concatbench

import (
	"fmt"
	"strings"
	"testing"
)

const (
	s1 = "четёре чёрненьких чумазеньких чертёнка, "
	create table t1(x int);
	create table t2 (x int, y varchar);
	create table audit_trail(
	id bigserial primary key,
	table_name varchar,
	data_before jsonb,
	data_after jsonb,
	ts timestamp
	);
	package main_test

	import "testing"

	func BenchmarkBoolMap(b *testing.B) {
	m := map[int]bool{}
	for i := 0; i < b.N; i++ {
	m[i] = true
	}
	}
	// https://go.dev/play/p/gTzl_yht11I

	package main

	import (
	"database/sql/driver"
	"fmt"
	)

	type valuer[T comparable] struct {
	package main

	import (
	"context"
	"database/sql"
	"database/sql/driver"
	"fmt"
	"strconv"
	"time"
	--Before update or insert trigger
	--fires twice when INSERT .. ON CONFLICT(uk) DO UPDATE operation
	--fails to insert and does the update part.
	--First it will be called with TG_OP='INSERT'
	--and then with TG_OP='UPDATE'

	create table t1 (x int);
	create unique index t1_ui on t1(x);
	create table t1_log(x int, op varchar(100), ts timestamp default clock_timestamp());
	package main_test

	import (
	"testing"
	)

	func cmp(a, b string) bool {
	if len(a) != len(b) {
	return false
	}
	package concatbench

	import (
	"fmt"
	"strings"
	"testing"
	)

	const (
	s1 = "четёре чёрненьких чумазеньких чертёнка, "