Clickhouse is faster than PostgreSQL or BigQuery for Geospatial Enrichment

https://tech.marksblogg.com/faster-geospatial-enrichment.html

​There is a new item (from the subscriber) in my collection of non-DB SQL tools at github:

https://github.com/noborus/trdsql
CLI tool that can execute SQL queries on CSV, LTSV, JSON and TBLN. Can output to various formats.

Two weird PostgreSQL-related projects in a row:

postgresml.org - OSS extension for training and deploying ML models from inside Postgres

hydras.io - SaaS Postgres to Snowflake mapping

ZverPG
repack by vonng :)))

https://github.com/Vonng/pigsty

Reason #12345 for using postgresql instead of mysql (https://twitter.com/tobias_petry/status/1526868551994318850)

Absolutely fucking insane!
Using snowflake data market for ingesting your stripe data into your snowflake db:

https://stripe.com/en-gb/data-pipeline

Developers: ORM allows us to change the database vendor if necessary.
ORM: https://docs.djangoproject.com/en/4.0/ref/contrib/postgres/fields/

Two different people have brought my attention to Neon Database (Nikita Shamgunov's startup, co-founder of MemSQL / SingleStore) – a serverless implementation of PostgreSQL, an auto-scaling, on-demand database as a service for modern applications.

Neon's key innovation is the separation of storage and compute (just like in snowflake :) ), which simplifies provisioning and managing database capacity, and enables key features like horizontal scaling and branching that are otherwise hard to achieve.
Demo 🐘

Now they are looking for Engineering manager ($150-300k+/year, remote-first or relocation to Cyprus), golang dev and rust dev

Feel free to contact @owlkov for details

​1) sqlite in your browser
2) python in your browser
3)

yes

MASKING POLICY in PostgreSql:
https://www.postgresql.org/about/news/postgresql-anonymizer-10-privacy-by-design-for-postgres-2452/

O’Reilly и CockroachDB выкатили. Читается легко.

Paul Modderman, Jim Walker, Charles Custer. What Is Distributed SQL? Scale, Resilience, and Data Locality for Modern Applications. 2022.

vacancy from our Snowflake chats RU EN:

Colleagues, hi! I'm writing on behalf of international VC Target Global who is currently looking for Snowflake Data Architect/ Engineer to join our team in London/ Berlin/ other locations possible

The main goal of this position would be to migrate from Postgre DB to Snowlake (including through Matilion), position is vastly hands-on

Please feel free to contact me on @Yuzhanova with your CV/ LinkedIn and I'll provide detailed job denoscription

All the best,
Tatiana

CockroachLabs сделали очередное исследование цен и производительности облаков Амазона, Майкрософта и Гугла, рекомендуется к изучению всем технарям. Из предсказуемых выводов — цены у всех почти выравнялись, сервера на AMD лидируют по производительности (arm не тестировался), в совокупной цене облака слишком большую часть сейчас занимает внутренний трафик.

Т.к. исследование внезапно оказалось за логином, вот вам напрямую файл (осторожно, pdf). И не забывайте, что всё это исследование — своего рода промо для CockroachDB, он тоже любопытный.