The Geo for Good Summit session recordings are available now. Check out the 5-hour workshop on the Earth Engine Python API and geemap 👇
YouTube playlist: https://t.co/UBl5JJVSie
#geospatial#EarthEngine#geemap#GeoforGood23
Worried that rain 🌧 will ruin your trip? @sensibleweather gives travelers the confidence to book that next trip by offering weather-guarantee protection. It also provides weather insights using climate analytics. https://t.co/ltSG0CLwPQ #NSFSBIR ☔
📸: Sensible Weather
Great updates and additional content in 2nd edition. Project based learning on a variety of fun topics (🐧!). Deploy your apps and adapt them to your own interests!
Stoked to be a part of it, great work @tylerjrichards !
Today is the day!! The 2nd edition of Streamlit for Data Science is officially launched.
I've used @streamlit basically every day since the 1st edition came out, and i'm so pumped to put all the lessons on paper.
Today i'm releasing 🥟 st-paywall, a @streamlit component that lets you build subscription Streamlit apps.
Just run pip install st-paywall, add your Google+Stripe keys, add add_auth() to your app, and you've got a subscription Streamlit!
https://t.co/amosmk23f7
Larger than RAM group bys have landed in @DuckDB's master branch!
This means that now every operator in DuckDB can handle larger than memory intermediates.
So the max data a single node can handle is the size of your SSD, not RAM!
https://t.co/ZS2mXxVlbF
New post: I read a really great book recently, "Naming Things", that explains why picking the right abstractions in development is so hard. https://t.co/SBu9Ej0I3J
@FranckPachot@duckdb@PostgreSQL Great examples of other ways to write this query!
I’m getting worse performance with the window function on Postgres even with indices on the 100k example. (DuckDB scan stayed constant)
Fair nit-pick on the “CTE” definition
CTE vs Subquery: Who Gives a 🦆uck?!
New blog post comparing @duckdb and @PostgreSQL performance + their combined power.
Heavily inspired by de-correlated queries duckdb blog and referenced paper
https://t.co/SHXpcx56Ux
@duckdb@PostgreSQL related duckdb blog: https://t.co/IwN97CP8Hl
related paper: https://t.co/NdwpJf2ts3
github repo for demo code: https://t.co/am8RANTD7P
@__AlexMonahan__@TheRockstarDBA This is spicy! I’m trying out the first query from the paper with 100k students. Preliminary results:
duck db scanning pg: 1.4 s
duck db cached: 0.26 s
Pg: still running