Our startup DWH.DEV is coming to Disrupt 2022!
Proud to announce that we’re in the Startup Battlefield 200. Come see us at the show 10/18-20! Get discounts on passes here! - https://tcrn.ch/3BUuT2D
Follow us at https://www.linkedin.com/company/dwhcorp and https://twitter.com/dwhdev
Proud to announce that we’re in the Startup Battlefield 200. Come see us at the show 10/18-20! Get discounts on passes here! - https://tcrn.ch/3BUuT2D
Follow us at https://www.linkedin.com/company/dwhcorp and https://twitter.com/dwhdev
TechCrunch
TechCrunch Disrupt 2022 - Overview
A little cursed, but ok...
https://modeling-languages.com/hybrid-textual-graphical-er-modeling-vscode/
https://modeling-languages.com/hybrid-textual-graphical-er-modeling-vscode/
Modeling Languages
Hybrid Textual and Graphical ER Modeling in VS Code with the bigER Modeling Tool
bigER is a free and open-source ER modeling tool supporting hybrid, textual- and graphical editing, multiple notations, and SQL code generation. The tool is available as an extension for Visual Studio Code.
Linux kernel patches boost PG performance up to twice:
https://www.phoronix.com/news/MGLRU-Reaches-mm-stable
https://www.phoronix.com/news/MGLRU-Reaches-mm-stable
Phoronix
MGLRU Patches Merged To "mm-stable" Ahead Of Linux 6.1 - New Benchmarks Look Good
As further indication of MGLRU hopefully being mainlined for Linux 6.1 as planned, the Multi-Gen LRU patches have now been moved to Andrew Morton's mm-stable branch.
At what conference for the second year in a row was the author of this channel not invited to speak? :)
In short, about MERGE in just released Postgres 15:
https://twitter.com/samokhvalov/status/1580935490580058112
https://twitter.com/samokhvalov/status/1580935490580058112
Twitter
Two things MERGE lacks now:
- RETURNING clause to allow user to see what exactly was done and save on RTT
- WHEN NOT MATCHED BY [SOURCE|TARGET] to allow easy syncing with source - e.g., ETL
The former is postgresism, the latter is what SQL Server has (but…
- RETURNING clause to allow user to see what exactly was done and save on RTT
- WHEN NOT MATCHED BY [SOURCE|TARGET] to allow easy syncing with source - e.g., ETL
The former is postgresism, the latter is what SQL Server has (but…
Lads - check out our super serious (no) reel for Techcrunch Disrupt!
https://youtu.be/RxijVdlUBZk
Ps: no sound needed :)
https://youtu.be/RxijVdlUBZk
Ps: no sound needed :)
MySQL HeatWave Performance Comparison
- 11X faster than Redshift
- 9X faster than Snowflake
- 9X faster than BigQuery
- 3X faster than Synapse
https://www.oracle.com/mysql/heatwave/performance/
- 11X faster than Redshift
- 9X faster than Snowflake
- 9X faster than BigQuery
- 3X faster than Synapse
https://www.oracle.com/mysql/heatwave/performance/
Oracle
HeatWave MySQL Performance Comparisons
HeatWave MySQL on OCI outperforms top cloud databases.
A few PG hacks from Alibaba (thx to @olegkovalov)
1) PostgreSQL Graph Search Practices - 10 Billion-Scale Graph with Millisecond Response
https://www.alibabacloud.com/blog/postgresql-graph-search-practices---10-billion-scale-graph-with-millisecond-response_595039
2) Social Friend Relationship System Practice in PostgreSQL - Accelerating Queries of Positive and Negative Relationships
https://www.alibabacloud.com/blog/595043
1) PostgreSQL Graph Search Practices - 10 Billion-Scale Graph with Millisecond Response
https://www.alibabacloud.com/blog/postgresql-graph-search-practices---10-billion-scale-graph-with-millisecond-response_595039
2) Social Friend Relationship System Practice in PostgreSQL - Accelerating Queries of Positive and Negative Relationships
https://www.alibabacloud.com/blog/595043