Clickhouse is faster than PostgreSQL or BigQuery for Geospatial Enrichment
https://tech.marksblogg.com/faster-geospatial-enrichment.html
https://tech.marksblogg.com/faster-geospatial-enrichment.html
Marksblogg
Faster Geospatial Enrichment
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
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.
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
postgresml.org - OSS extension for training and deploying ML models from inside Postgres
hydras.io - SaaS Postgres to Snowflake mapping
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
Using snowflake data market for ingesting your stripe data into your snowflake db:
https://stripe.com/en-gb/data-pipeline
Stripe
Stripe Data Pipeline: Sync Stripe data to your data warehouse
Stripe Data Pipeline sends all your up-to-date Stripe data to Snowflake or Amazon Redshift in a few clicks.
Developers: ORM allows us to change the database vendor if necessary.
ORM: https://docs.djangoproject.com/en/4.0/ref/contrib/postgres/fields/
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
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
MASKING POLICY in PostgreSql:
https://www.postgresql.org/about/news/postgresql-anonymizer-10-privacy-by-design-for-postgres-2452/
https://www.postgresql.org/about/news/postgresql-anonymizer-10-privacy-by-design-for-postgres-2452/
PostgreSQL News
PostgreSQL Anonymizer 1.0: Privacy By Design For Postgres
Limoges, France, May 17th, 2022 `PostgreSQL Anonymizer` is an extension that hides or replaces personally identifiable information (PII) or commercially …
Forwarded from Технологический Болт Генона
oreilly-report-what-is-distributed-sql.pdf
2.6 MB
O’Reilly и CockroachDB выкатили. Читается легко.
Paul Modderman, Jim Walker, Charles Custer. What Is Distributed SQL? Scale, Resilience, and Data Locality for Modern Applications. 2022.
Paul Modderman, Jim Walker, Charles Custer. What Is Distributed SQL? Scale, Resilience, and Data Locality for Modern Applications. 2022.