@[email protected]

As Bill & Ted say: "Be excellent to each other!" ; Somewhere between Gen Z, Millennial, and Very Confused 🚀💻🥏

@[email protected]

[Steven Tey @steventey]

TIL you can turn any website into an editable canvas with just a simple command in the console:

document.designMode = 'on'

[Qiusheng Wu @giswqs]

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

[@[email protected] @GarsBar35Plus]

@boristane JSON-RPC servers admitting they aren't RESTful: https://t.co/EaJ5bYEU17

[Fanilo Andrianasolo @andfanilo]

I produced my first book trailer 🙃 find it here: https://t.co/TcI5N70KKs

And if you watch until the end, there may be a surprise gift 🤔

[U.S. National Science Foundation @NSF]

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

[@[email protected] @GarsBar35Plus]

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 !

[Tyler Richards @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.

[Tyler Richards @tylerjrichards]

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

[@[email protected] @GarsBar35Plus]

@minimaxir I like the simpleaichat cli so far. Very little friction having a random terminal open with a running chat

[Alex Monahan @__AlexMonahan__]

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

[@[email protected] @GarsBar35Plus]

Just standup things

[vicki @vboykis]

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

[@[email protected] @GarsBar35Plus]

💧☀️ Awesome summary!

[Sensible Weather @sensibleweather]

Thank you @EmmyReports for talking about the weather with Sensible CEO, @nick_cavanaugh! https://t.co/rQhqRQo4DH

[@[email protected] @GarsBar35Plus]

@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

[@[email protected] @GarsBar35Plus]

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

[@[email protected] @GarsBar35Plus]

@duckdb @PostgreSQL related duckdb blog: https://t.co/IwN97CP8Hl

related paper: https://t.co/NdwpJf2ts3

github repo for demo code: https://t.co/am8RANTD7P

[@[email protected] @GarsBar35Plus]

@ghalimi Are you looking for historical climatology at each location / date or historical observations? Looks like a fun exploration!

[@[email protected] @GarsBar35Plus]

@__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

[@[email protected] @GarsBar35Plus]

@andfanilo @streamlit @langchain It’s always the edge cases 😉

[@[email protected] @GarsBar35Plus]

@zahnster we've got backends for frontends and now frontends for frontends! what a time to be alive!

[DuckDB @duckdb]

New blog post by @Maxxen_: PostGEESE? Introducing The DuckDB [Geo]Spatial Extension - https://t.co/mAp3ccV26F #GIS