pg-copy-ch
Simply copy the current PostgreSQL data to ClickHouse
https://github.com/maiha/pg-copy-ch
#postgres #clickhouse #sql
Simply copy the current PostgreSQL data to ClickHouse
https://github.com/maiha/pg-copy-ch
#postgres #clickhouse #sql
MongoDB Query Performance: Understanding the Query Planner & Advanced Index Types
https://ifelse.io/2020/06/19/mongodb-query-performance-understanding-the-query-planner-advanced-index-types/
#mongo #mongodb #query #perfomance
https://ifelse.io/2020/06/19/mongodb-query-performance-understanding-the-query-planner-advanced-index-types/
#mongo #mongodb #query #perfomance
Forwarded from HABR FEED + OPENNET
[ΠΠ΅ΡΠ΅Π²ΠΎΠ΄] ΠΠΎΠ½ΡΠ΅ΡΠ΅Π½ΡΠΈΡ QCon. ΠΠ²Π»Π°Π΄Π΅Π½ΠΈΠ΅ Ρ
Π°ΠΎΡΠΎΠΌ: ΡΡΠΊΠΎΠ²ΠΎΠ΄ΡΡΠ²ΠΎ Netflix Π΄Π»Ρ ΠΌΠΈΠΊΡΠΎΡΠ΅ΡΠ²ΠΈΡΠΎΠ². Π§Π°ΡΡΡ 3
https://habr.com/ru/post/507966/?utm_source=habrahabr&utm_medium=rss&utm_campaign=507966
Tags: ΠΠ»ΠΎΠ³ ΠΊΠΎΠΌΠΏΠ°Π½ΠΈΠΈ ua-hosting.company, IT-ΠΈΠ½ΡΡΠ°ΡΡΡΡΠΊΡΡΡΠ°, ΠΠ½Π°Π»ΠΈΠ· ΠΈ ΠΏΡΠΎΠ΅ΠΊΡΠΈΡΠΎΠ²Π°Π½ΠΈΠ΅ ΡΠΈΡΡΠ΅ΠΌ, ΠΠΎΠ½ΡΠ΅ΡΠ΅Π½ΡΠΈΠΈ, ΠΠΈΠΊΡΠΎΡΠ΅ΡΠ²ΠΈΡΡ, Netflix, ΠΌΠΈΠΊΡΠΎΡΠ΅ΡΠ²ΠΈΡΡ, Javaweb, Oracle
Author ua-hosting #habr
https://habr.com/ru/post/507966/?utm_source=habrahabr&utm_medium=rss&utm_campaign=507966
Tags: ΠΠ»ΠΎΠ³ ΠΊΠΎΠΌΠΏΠ°Π½ΠΈΠΈ ua-hosting.company, IT-ΠΈΠ½ΡΡΠ°ΡΡΡΡΠΊΡΡΡΠ°, ΠΠ½Π°Π»ΠΈΠ· ΠΈ ΠΏΡΠΎΠ΅ΠΊΡΠΈΡΠΎΠ²Π°Π½ΠΈΠ΅ ΡΠΈΡΡΠ΅ΠΌ, ΠΠΎΠ½ΡΠ΅ΡΠ΅Π½ΡΠΈΠΈ, ΠΠΈΠΊΡΠΎΡΠ΅ΡΠ²ΠΈΡΡ, Netflix, ΠΌΠΈΠΊΡΠΎΡΠ΅ΡΠ²ΠΈΡΡ, Javaweb, Oracle
Author ua-hosting #habr
Π₯Π°Π±Ρ
ΠΠΎΠ½ΡΠ΅ΡΠ΅Π½ΡΠΈΡ QCon. ΠΠ²Π»Π°Π΄Π΅Π½ΠΈΠ΅ Ρ
Π°ΠΎΡΠΎΠΌ: ΡΡΠΊΠΎΠ²ΠΎΠ΄ΡΡΠ²ΠΎ Netflix Π΄Π»Ρ ΠΌΠΈΠΊΡΠΎΡΠ΅ΡΠ²ΠΈΡΠΎΠ². Π§Π°ΡΡΡ 3
ΠΠΆΠΎΡ ΠΠ²Π°Π½Ρ ΡΠ°ΡΡΠΊΠ°Π·ΡΠ²Π°Π΅Ρ ΠΎ Ρ
Π°ΠΎΡΠΈΡΠ½ΠΎΠΌ ΠΈ ΡΡΠΊΠΎΠΌ ΠΌΠΈΡΠ΅ ΠΌΠΈΠΊΡΠΎΡΠ΅ΡΠ²ΠΈΡΠΎΠ² Netflix, Π½Π°ΡΠΈΠ½Π°Ρ Ρ ΡΠ°ΠΌΡΡ
ΠΎΡΠ½ΠΎΠ² β Π°Π½Π°ΡΠΎΠΌΠΈΠΈ ΠΌΠΈΠΊΡΠΎΡΠ΅ΡΠ²ΠΈΡΠΎΠ², ΠΏΡΠΎΠ±Π»Π΅ΠΌ, ΡΠ²ΡΠ·Π°Π½Π½ΡΡ
Ρ ΡΠ°ΡΠΏΡΠ΅Π΄Π΅Π»Π΅Π½Π½ΡΠΌΠΈ ΡΠΈΡΡΠ΅ΠΌΠ°ΠΌΠΈ ΠΈ ΠΈΡ
ΠΏΡΠ΅ΠΈΠΌΡΡΠ΅ΡΡΠ². ΠΠΏΠΈΡΠ°ΡΡΡ Π½Π°...
Forwarded from Π’Π΅Ρ
Π½ΠΎΠ»ΠΎΠ³ΠΈΡΠ΅ΡΠΊΠΈΠΉ ΠΠΎΠ»Ρ ΠΠ΅Π½ΠΎΠ½Π°
From Russia With Love: How ClickHouse Saved our Data
https://mux.com/blog/from-russia-with-love-how-clickhouse-saved-our-data/
https://mux.com/blog/from-russia-with-love-how-clickhouse-saved-our-data/
Mux
How ClickHouse saved our data | Mux
The Mux Data platform is used by some of the biggest broadcasters to monitor the video streaming experience of their end users. Think of it like Google Analytics or New Relic for video playback. It's a...
Forwarded from I hate overtime
#postgres
Π’ΡΡ Π½Π°ΠΌΠ΅ΡΠ°Π΅ΡΡΡ ΠΊΠ»Π°ΡΡΠ½ΡΠΉ ΡΠ΅ΡΠΈΠ°Π» ΠΎΡ 2ndquadrant ΠΏΡΠΎ ΠΏΡΠΎΠ±Π»Π΅ΠΌΡ ΠΏΠΎΡΡΠ³ΡΠ΅ΡΠ°. ΠΠ΅ΡΠ²Π°Ρ ΡΠ°ΡΡΡ ΠΏΡΠΎ 32-Π±ΠΈΡΠ½ΡΠ΅ ΡΠΊΠ°Π·Π°ΡΠ΅Π»ΠΈ ΡΡΠ°Π½Π·Π°ΠΊΡΠΈΠΉ ΠΏΠΎΠ»ΡΡΠΈΠ»Π°ΡΡ Π΄ΠΎΠ²ΠΎΠ»ΡΠ½ΠΎ ΠΈΠ½ΡΠ΅ΡΠ΅ΡΠ½ΠΎΠΉ, ΠΆΠ΄Π΅ΠΌ ΠΎΠ±Π΅ΡΠ°Π½Π½ΠΎΠ³ΠΎ ΠΏΡΠΎΠ΄ΠΎΠ»ΠΆΠ΅Π½ΠΈΡ
Π’ΡΡ Π½Π°ΠΌΠ΅ΡΠ°Π΅ΡΡΡ ΠΊΠ»Π°ΡΡΠ½ΡΠΉ ΡΠ΅ΡΠΈΠ°Π» ΠΎΡ 2ndquadrant ΠΏΡΠΎ ΠΏΡΠΎΠ±Π»Π΅ΠΌΡ ΠΏΠΎΡΡΠ³ΡΠ΅ΡΠ°. ΠΠ΅ΡΠ²Π°Ρ ΡΠ°ΡΡΡ ΠΏΡΠΎ 32-Π±ΠΈΡΠ½ΡΠ΅ ΡΠΊΠ°Π·Π°ΡΠ΅Π»ΠΈ ΡΡΠ°Π½Π·Π°ΠΊΡΠΈΠΉ ΠΏΠΎΠ»ΡΡΠΈΠ»Π°ΡΡ Π΄ΠΎΠ²ΠΎΠ»ΡΠ½ΠΎ ΠΈΠ½ΡΠ΅ΡΠ΅ΡΠ½ΠΎΠΉ, ΠΆΠ΄Π΅ΠΌ ΠΎΠ±Π΅ΡΠ°Π½Π½ΠΎΠ³ΠΎ ΠΏΡΠΎΠ΄ΠΎΠ»ΠΆΠ΅Π½ΠΈΡ
EDB
PG Phriday: 10 Things Postgres Could Improve - Part 1
Postgres is a database soft
ΠΡΡΡΡΠΏΠ»Π΅Π½ΠΈΠ΅ ΠΊΠΎΠΌΠΏΠ°Π½ΠΈΠΈ Flant.ru Π½Π° GitOps Days 2020
https://youtu.be/WetiGGcNZGw?list=PL9lTuCFNLaD2NiNrdt7SaQjpYx_m37czS
https://youtu.be/WetiGGcNZGw?list=PL9lTuCFNLaD2NiNrdt7SaQjpYx_m37czS
YouTube
Dmitry Stolyarov (Flant) on Introduction to werf: Another view on GitOps
Day 1 - Session 13c "After Hours" Introduction to werf
This talk presents another approach to GitOps that does not require a reconciliation operator. It will be followed by a short introduction to werf (github.com/flant/werf) β simple tool to implement thisβ¦
This talk presents another approach to GitOps that does not require a reconciliation operator. It will be followed by a short introduction to werf (github.com/flant/werf) β simple tool to implement thisβ¦
https://www.jooq.org/translate/
Use the jOOQ Parser to translate any SQL statement(s) to a different dialect.*
Use the jOOQ Parser to translate any SQL statement(s) to a different dialect.*
jOOQ
Format, pretty print, and translate your SQL from one dialect to another
Use the online jOOQ parser to format, pretty print, and translate or transpile between over 30 SQL dialects
Forwarded from There will be no singularity
βΠΠΎΠΊΠ° ΠΊΠΎΡΠΌΠΈΡΠ΅ΡΠΊΠΈΠ΅ ΠΊΠΎΡΠ°Π±Π»ΠΈ Π±ΠΎΡΠΎΠ·Π΄ΡΡ (Π·Π°ΡΠ΅ΡΠΊΠ½ΡΡΠΎ) postgresql ΡΡΠ°Π½ΠΎΠ²ΠΈΡΡΡ Π±ΡΡΡΡΠ΅Π΅ Ρ ΠΊΠ°ΠΆΠ΄ΡΠΌ Π½ΠΎΠ²ΡΠΌ ΡΠ΅Π»ΠΈΠ·ΠΎΠΌ, ΠΌΠΎΠ½Π³Π° ΡΡΠ°Π½ΠΎΠ²ΠΈΡΡΡ ΠΌΠ΅Π΄Π»Π΅Π½Π½Π΅Π΅:
https://www.percona.com/blog/2020/06/24/evaluating-mongodb-under-python-tpcc-1000w-workload/
https://www.percona.com/blog/2020/06/24/evaluating-mongodb-under-python-tpcc-1000w-workload/
Forwarded from Π’Π΅Ρ
Π½ΠΎΠ»ΠΎΠ³ΠΈΡΠ΅ΡΠΊΠΈΠΉ ΠΠΎΠ»Ρ ΠΠ΅Π½ΠΎΠ½Π°
Π‘Π΅Π³ΠΎΠ΄Π½Ρ ΡΠΎΡΡΠΎΠΈΡΡΡ 4-ΡΠΉ Online Monitoring Meetup: ΠΌΠΎΠ½ΠΈΡΠΎΡΠΈΠ½Π³ Π‘Π£ΠΠ.
Π’ΡΠ°Π½ΡΠ»ΡΡΠΈΡ Π±ΡΠ΄Π΅Ρ ΡΡΡ
https://www.youtube.com/channel/UCyQ9sLBi9F3Mo_LRQrJ6RNg
ΠΠ°ΡΠ°Π»ΠΎ Π² 18:30 ΠΠ‘Π
ΠΡΠΎΠ³ΡΠ°ΠΌΠΌΠ°
18:30 β ΠΊΡΡΠ³Π»ΡΠΉ ΡΡΠΎΠ» ΡΠΎ ΡΠΏΠΈΠΊΠ΅ΡΠ°ΠΌΠΈ ΠΈ ΡΠΊΡΠΏΠ΅ΡΡΠ°ΠΌΠΈ;
19:30 - ΠΠ»Π΅ΠΊΡΠ΅ΠΉ ΠΠ°Π»Π°ΠΆΡΠ΅Π½ΠΊΠΎ, Percona, Backend Architect, Β«ΠΠΎΠ½ΠΈΡΠΎΡΠΈΠ½Π³ MySQL, PostgreSQL ΠΈ MongoDBΒ»;
20:10 β ΠΠ»Π΅Π³ ΠΠ²Π°Π½ΠΎΠ², Native Technology, ΡΠΈΡΡΠ΅ΠΌΠ½ΡΠΉ Π°Π΄ΠΌΠΈΠ½ΠΈΡΡΡΠ°ΡΠΎΡ, Β«ΠΠ± ΠΎΡΠΎΠ±Π΅Π½Π½ΠΎΡΡΡΡ ΡΠ°Π±ΠΎΡΡ ΠΈ ΠΌΠΎΠ½ΠΈΡΠΎΡΠΈΠ½Π³Π° redis, redis-cluster ΠΈ keydbΒ»;
20:30 β ΠΠ°ΡΠΈΠ»ΠΈΠΉ Π’ΡΠ±Π΅ΠΊ, Mail.ru Group, ΡΡΠΊΠΎΠ²ΠΎΠ΄ΠΈΡΠ΅Π»Ρ ΠΊΠΎΠΌΠ°Π½Π΄Ρ ΡΠ°Π·ΡΠ°Π±ΠΎΡΠΊΠΈ, Β«ΠΠ°ΠΊ ΠΌΡ Π² ΠΎΠ΄Π½ΠΎΠΌ ΡΠ΅Π»Π΅ΠΊΠΎΠΌΠ΅ ΡΠ°ΡΠ°Π½ΡΡΠ»Ρ ΠΌΠΎΠ½ΠΈΡΠΎΡΠΈΠ»ΠΈΒ»;
21:10 β Π·Π°Π²Π΅ΡΡΠ΅Π½ΠΈΠ΅ ΠΎΠ½Π»Π°ΠΉΠ½ ΠΌΠΈΡΠ°ΠΏΠ°.
Π§Π°Ρ
@monhouse_tech
Π’ΡΠ°Π½ΡΠ»ΡΡΠΈΡ Π±ΡΠ΄Π΅Ρ ΡΡΡ
https://www.youtube.com/channel/UCyQ9sLBi9F3Mo_LRQrJ6RNg
ΠΠ°ΡΠ°Π»ΠΎ Π² 18:30 ΠΠ‘Π
ΠΡΠΎΠ³ΡΠ°ΠΌΠΌΠ°
18:30 β ΠΊΡΡΠ³Π»ΡΠΉ ΡΡΠΎΠ» ΡΠΎ ΡΠΏΠΈΠΊΠ΅ΡΠ°ΠΌΠΈ ΠΈ ΡΠΊΡΠΏΠ΅ΡΡΠ°ΠΌΠΈ;
19:30 - ΠΠ»Π΅ΠΊΡΠ΅ΠΉ ΠΠ°Π»Π°ΠΆΡΠ΅Π½ΠΊΠΎ, Percona, Backend Architect, Β«ΠΠΎΠ½ΠΈΡΠΎΡΠΈΠ½Π³ MySQL, PostgreSQL ΠΈ MongoDBΒ»;
20:10 β ΠΠ»Π΅Π³ ΠΠ²Π°Π½ΠΎΠ², Native Technology, ΡΠΈΡΡΠ΅ΠΌΠ½ΡΠΉ Π°Π΄ΠΌΠΈΠ½ΠΈΡΡΡΠ°ΡΠΎΡ, Β«ΠΠ± ΠΎΡΠΎΠ±Π΅Π½Π½ΠΎΡΡΡΡ ΡΠ°Π±ΠΎΡΡ ΠΈ ΠΌΠΎΠ½ΠΈΡΠΎΡΠΈΠ½Π³Π° redis, redis-cluster ΠΈ keydbΒ»;
20:30 β ΠΠ°ΡΠΈΠ»ΠΈΠΉ Π’ΡΠ±Π΅ΠΊ, Mail.ru Group, ΡΡΠΊΠΎΠ²ΠΎΠ΄ΠΈΡΠ΅Π»Ρ ΠΊΠΎΠΌΠ°Π½Π΄Ρ ΡΠ°Π·ΡΠ°Π±ΠΎΡΠΊΠΈ, Β«ΠΠ°ΠΊ ΠΌΡ Π² ΠΎΠ΄Π½ΠΎΠΌ ΡΠ΅Π»Π΅ΠΊΠΎΠΌΠ΅ ΡΠ°ΡΠ°Π½ΡΡΠ»Ρ ΠΌΠΎΠ½ΠΈΡΠΎΡΠΈΠ»ΠΈΒ»;
21:10 β Π·Π°Π²Π΅ΡΡΠ΅Π½ΠΈΠ΅ ΠΎΠ½Π»Π°ΠΉΠ½ ΠΌΠΈΡΠ°ΠΏΠ°.
Π§Π°Ρ
@monhouse_tech
Forwarded from Π’Π΅Ρ
Π½ΠΎΠ»ΠΎΠ³ΠΈΡΠ΅ΡΠΊΠΈΠΉ ΠΠΎΠ»Ρ ΠΠ΅Π½ΠΎΠ½Π°
YouTube
Online Monitoring Meetup: ΠΌΠΎΠ½ΠΈΡΠΎΡΠΈΠ½Π³ Π‘Π£ΠΠ
Mongo, Redis, Oracle, Prostgre, MySQL, OpenTSDB... ΠΈ ΡΡΠΎ Π½Π΅ Π²Π΅ΡΡ ΠΏΠ΅ΡΠ΅ΡΠ΅Π½Ρ ΠΈΡΠΏΠΎΠ»ΡΠ·ΡΠ΅ΠΌΡΡ
Π±Π°Π· Π΄Π°Π½Π½ΡΡ
Π² ΡΠΎΠ²ΡΠ΅ΠΌΠ΅Π½Π½ΡΡ
ΠΏΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΡΡ
ΠΈ ΡΠ΅ΡΠ΅Π½ΠΈΡΡ
. ΠΠ΅ΡΠ΅Π΄ΠΊΠΎΡΡΡ ΠΈΡΠΏΠΎΠ»ΡΠ·ΠΎΠ²Π°Π½ΠΈΠ΅ Π½Π΅ΡΠΊΠΎΠ»ΡΠΊΠΈΡ
Π±Π°Π· Π΄Π°Π½Π½ΡΡ
Π΄Π»Ρ ΡΠ°Π·Π½ΡΡ
ΡΠΈΠΏΠΎΠ² Π΄Π°Π½Π½ΡΡ
Π² ΠΏΡΠ΅Π΄Π΅Π»Π°Ρ
ΠΎΠ΄Π½ΠΎΠ³ΠΎ ΠΏΡΠΎΠ΅ΠΊΡΠ°. Π ΡΡΠΎ Π½ΡΠΆΠ½ΠΎ ΠΌΠΎΠ½ΠΈΡΠΎΡΠΈΡΡ.β¦
Π’Π΅ΠΌ Π²ΡΠ΅ΠΌΠ΅Π½Π΅ΠΌ Comcast ΡΠΎΠ²ΠΌΠ΅ΡΡΠ½ΠΎ Ρ Mozilla Π²ΠΊΠ»ΡΡΠΈΡ DNS over HTTPS (DOH) ΠΏΠΎ-ΡΠΌΠΎΠ»ΡΠ°Π½ΠΈΡ Π΄Π»Ρ ΡΠ²ΠΎΠΈΡ
ΠΊΠ»ΠΈΠ΅Π½ΡΠΎΠ². Π‘Π°ΠΌΠΎ ΡΠΎΠ±ΠΎΠΉ ΠΌΠΎΠΆΠ½ΠΎ Π±ΡΠ΄Π΅Ρ ΠΏΠ΅ΡΠ΅ΠΉΡΠΈ ΠΈ Π½Π° Π΄ΡΡΠ³ΠΈΡ
ΠΏΡΠΎΠ²Π°ΠΉΠ΄Π΅ΡΠΎΠ² DOH - Π½Π°ΠΏΡΠΈΠΌΠ΅Ρ Cloudflare, NextDNS. ΠΠΎΠ³Π΄Π°? - ΠΏΠΎΠΊΠ° Π½Π΅Ρ Π΄Π°ΡΡ.
Ars Technica
Comcast, Mozilla strike privacy deal to encrypt DNS lookups in Firefox
Comcast/Mozilla deal follows dispute over ISP snooping and DNS encryption.