gorshkov-leonid

Slippy map and EPSG3857. How to get SW / NE coordinates of tile.

        // 8 / 85 / 154
        const z = 8
        const x = 85
        const y = 154
        const x0 = (x / Math.pow(2.0, z)) * 360 - 180;
        const y0 = 360 / Math.PI * Math.atan(Math.exp((180 - (y / Math.pow(2.0, z)) * 360) * Math.PI / 180)) - 90;
        const x1 =  (x + 1) / Math.pow(2.0, z) * 360 - 180;
 const y1 = 360 / Math.PI * Math.atan(Math.exp((180 - ((y + 1) / Math.pow(2.0, z)) * 360) * Math.PI / 180)) - 90;

gorshkov-leonid

Open remote proxy and forward into internal network with dumping

1. Use white ip on routher (let it be a.b.c.d)
2. Make port fowarding from router to PC (let it be 1063)
3. Install python 3
4. Use script MITM Relay
5. Install Burb Suite Common Edition See https://security.stackexchange.com/questions/229698/intercepting-tcp-traffic-through-mitm-attack

# Burb Suite Common Edition listens on 127.0.0.1:8080
# Replays from 0.0.0.0:1063 to 127.0.0.1:9090

gorshkov-leonid

yum install epel-release
yum localinstall --nogpgcheck https://download1.rpmfusion.org/free/el/rpmfusion-free-release-7.noarch.rpm
yum install --downloadonly --downloaddir=ffmpeg ffmpeg

yum --disableplugin=fastestmirror -y -v localinstall ./ffmpeg/*.rpm

gorshkov-leonid

Official

1. Chrome for Testing since 113, see Chrome JSON API endpoints and npx @puppeteer/browsers ...
2. Download Chromium
3. Download Chromium History Version get Chromium by version of Chrome. Here all tags and info for tag
4. Chromium Snaphots

CentOS

cat <<'EOF' > /etc/yum.repos.d/google-chrome.repo
[google-chrome]

gorshkov-leonid

If some service have problems with connection:

netsh winsock reset
netsh int ip reset
ipconfig /release
ipconfig /renew
ipconfig /flushdns

Be dangerous:

gorshkov-leonid

oracle / convert date to epoch

-- https://dbfiddle.uk/_DO-kBb6
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';

WITH test_data ( date_value ) AS (
  SELECT DATE '1970-01-01' + INTERVAL '3' HOUR FROM DUAL
)
SELECT date_value,

gorshkov-leonid

https://github.com/peshrus/gitlab-wide

https://chrome.google.com/webstore/detail/clngdbkpkpeebahjckkjfobafhncgmne

width 3840

66%:

.fixed-width-container,
.fixed-width-container *,

gorshkov-leonid

estimate size of geometry

https://www.oracle.com/technetwork/database/enterprise-edition/spatial-perf-twp-130138.pdf

select sum(k) / count(*) from (
   select (SDO_UTIL.GETNUMVERTICES(geometry)*2*7 + 104) as k from my_spatial
)

find invalid geometries

https://docs.oracle.com/database/121/SPATL/sdo_geom-validate_geometry_with_context.htm#SPATL1130

gorshkov-leonid

https://stackoverflow.com/questions/59861486/record-video-from-website-using-puppeteer-ffmpeg

let recordVideo = (setup) => {
    return new Promise(async (resolve, reject) => {
        let frames = [];
        let session;

        let start = async () => {
 session = await page.target().createCDPSession();

gorshkov-leonid

function dumpFeaturesBySources(onlyRendered)
    {
        Object.keys(window.MapboxForDebug.style.sourceCaches).forEach((key)=>dumpFeatures(onlyRendered, key))
    }

    function dumpFeatures(onlyRendered, sourceId) {
        var mapbox = window.MapboxForDebug;
        const logResult = [];
        if (onlyRendered) {