Iman Tunggono imantung

## pg_logical_replication.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                imantung
                / pg_logical_replication.md
            
            
              Last active
              April 17, 2023 01:03
            
              
                Posgres Logical Replication Notes
              
          
    Postges Logical Replication

Overview


Table specific replicatlion
Support on postgres 10 above
Pub-sub model
Also known as Change Data Capture (CDC)


## google_script_helpdesk.js
// Read more at: https://medium.com/@imantung/simple-helpdesk-using-google-forms-and-apps-script-ee3c755bb2b7

const TOAST_TIMEOUT = 3; // toast show for 3 sec
const FORM_SUBMIT_SHEETNAME = "Form Responses 1"

const TICKET_NO_LENGTH = 5;
const TICKET_NO_CHARSET = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';

const SUPPORT_EMAIL = "support@example.com"
const SUPPORT_NAME = "Your Humble Support"

## jira.go
package main

import (
	"fmt"
	"log"

	gojira "github.com/andygrunwald/go-jira"
)

// Example to fetch data from Jira

## aliyunoss_presigned_url.go
package main

import (
	"fmt"
	"log"

	"github.com/aliyun/aliyun-oss-go-sdk/oss"
)

// Example create presigned url for Aliyun OSS

## gsheet.go
package main

import (
	"context"
	"fmt"
	"log"

	"google.golang.org/api/option"
	"google.golang.org/api/sheets/v4"
)

## get_soap_body.java
package coba;

import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;

import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.transform.OutputKeys;

## ast_print_struct_fields.go
package main

import (
	"fmt"
	"go/ast"
	"go/parser"
	"go/token"
)

var src = `package mypackage
	// Read more at: https://medium.com/@imantung/simple-helpdesk-using-google-forms-and-apps-script-ee3c755bb2b7

	const TOAST_TIMEOUT = 3; // toast show for 3 sec
	const FORM_SUBMIT_SHEETNAME = "Form Responses 1"

	const TICKET_NO_LENGTH = 5;
	const TICKET_NO_CHARSET = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';

	const SUPPORT_EMAIL = "support@example.com"
	const SUPPORT_NAME = "Your Humble Support"
	package main

	import (
	"fmt"
	"log"

	gojira "github.com/andygrunwald/go-jira"
	)

	// Example to fetch data from Jira
	package main

	import (
	"context"
	"fmt"
	"log"

	"google.golang.org/api/option"
	"google.golang.org/api/sheets/v4"
	)
	package coba;

	import org.w3c.dom.Document;
	import org.w3c.dom.Element;
	import org.w3c.dom.Node;
	import org.w3c.dom.NodeList;

	import javax.xml.parsers.DocumentBuilder;
	import javax.xml.parsers.DocumentBuilderFactory;
	import javax.xml.transform.OutputKeys;