bitnerd's profile picture. @bitnerd@mastodon.social
Ultra Runner/Coach/RD - http://missinglinkrunning.com
Geo/FOSS/Database Dev
http://dbspatial.com & http://developmentseed.org
he/him

David Bitner

@bitnerd

@[email protected] Ultra Runner/Coach/RD - http://missinglinkrunning.com Geo/FOSS/Database Dev http://dbspatial.com & http://developmentseed.org he/him

I'm running away from this platform. Find me on Blue sky @bitnerd.missinglink.run bsky.app/profile/bitner…


David Bitner 님이 재게시함

Last reminder: PostGIS Day is tomorrow! Please register! It's free and it helps us size the webinar account. crunchydata.com/community/even…

pwramsey's tweet image. Last reminder: PostGIS Day is tomorrow!
Please register! It's free and it helps us size the webinar account. crunchydata.com/community/even…

David Bitner 님이 재게시함

Part of maturing as an engineer is recognizing the difference between "thing you would do differently" and "thing you should comment on during code review"


David Bitner 님이 재게시함

🚀 We’re hiring! Join us as a Technical Project Lead to advance open science in the cloud and help drive impactful NASA projects. Are you a proactive, independent leader with PM experience? Apply today: grnh.se/ad0fe1593us

developmentseed's tweet image. 🚀 We’re hiring! Join us as a Technical Project Lead to advance open science in the cloud and help drive impactful NASA projects. Are you a proactive, independent leader with PM experience? Apply today: grnh.se/ad0fe1593us

David Bitner 님이 재게시함

Can't overstate how incredibly useful and key pg_stat_statements is for every single Postgres database. Doesn't require much work and can get huge performance insights out of your database x.com/crunchydata/st…

pg_stat_statements is an extension that ships included with Postgres as part of the contrib set of extensions. It's incredibly handy for analyzing performance of your Postgres database. If you don't already have it enabled you can enable it with: CREATE EXTENSION…



David Bitner 님이 재게시함

Published arro3 v0.4: a minimal Python implementation of @ApacheArrow based on the @rustlang Arrow crate. This adds zero-copy data import from Numpy, so you can use numeric Numpy-backed arrays with Rust Arrow operations without copies! github.com/kylebarron/arr…


David Bitner 님이 재게시함

News: PostgreSQL 17 Released! postgresql.org/about/news/pos…


David Bitner 님이 재게시함

After 1 year at Voltron Data, I found myself along with my teammates and 50+ people in need of a job I have plenty experience building OSS Python data tools, presenting at conferences and OS community management. If you think I'd be a good fit for a job please let me know


David Bitner 님이 재게시함

Postgres 17 was just released today, it offers some very real performance improvements. Here's a great deep dive with actual numbers on what the gains can look like crunchydata.com/blog/real-worl…


David Bitner 님이 재게시함

And they're off -- PostgreSQL 17.0 is out of the gate! The rest is all up to you :-) postgresql.org/about/news/pos…


David Bitner 님이 재게시함

Recent Postgres releases there is often "better performance", but it's easy to get numb to this. But the real world numbers on this improvement in PG17 are pretty amazing. Awesome work on the feature @petervgeoghegan and @brandur on the benchmarking. x.com/brandur/status…

Postgres 17: Expect *serious* real world perf gains in apps making heavy use of eager loading. We benchmarked an average complexity endpoint and saw +30% throughput and a 20% drop in request time. We're expecting that across the board on final release. crunchydata.com/blog/real-worl…

brandur's tweet image. Postgres 17: Expect *serious* real world perf gains in apps making heavy use of eager loading.

We benchmarked an average complexity endpoint and saw +30% throughput and a 20% drop in request time. We're expecting that across the board on final release.

crunchydata.com/blog/real-worl…
brandur's tweet image. Postgres 17: Expect *serious* real world perf gains in apps making heavy use of eager loading.

We benchmarked an average complexity endpoint and saw +30% throughput and a 20% drop in request time. We're expecting that across the board on final release.

crunchydata.com/blog/real-worl…


David Bitner 님이 재게시함

We teamed up with @EarthGenome and Better Planet Lab (@ZiaMehrabi) to tackle a complex problem: visualizing the global food system. Our design sprint process gave us new ways to think about data modeling and collaboration. Learn more in our blog: ds.io/visualizingfood

developmentseed's tweet image. We teamed up with @EarthGenome and Better Planet Lab (@ZiaMehrabi) to tackle a complex problem: visualizing the global food system. 

Our design sprint process gave us new ways to think about data modeling and collaboration. Learn more in our blog: ds.io/visualizingfood

David Bitner 님이 재게시함

A collaborative approach is central to how we get things done at Earth Genome & it's a joy to work alongside partners like @developmentseed. Here's a preview of the Global Food Twin project & the step-by-step design approach before the official launch: developmentseed.org/blog/2024-09-1…

EarthGenome's tweet image. A collaborative approach is central to how we get things done at Earth Genome & it's a joy to work alongside partners like @developmentseed. 

Here's a preview of the Global Food Twin project & the step-by-step design approach before the official launch: developmentseed.org/blog/2024-09-1…

David Bitner 님이 재게시함

Window functions in #PostgreSQL are one of those things that once you get them, they're amazing! For various types of analysis they're such a handy tool to have in your toolbox. This post by @sqlliz is such a solid walkthrough. x.com/planetpostgres…

craigkerstiens's tweet image. Window functions in #PostgreSQL are one of those things that once you get them, they're amazing! For various types of analysis they're such a handy tool to have in your toolbox. This post by @sqlliz is such a solid walkthrough. x.com/planetpostgres…

Elizabeth Garrett Christensen (@sqlliz): Window Functions for Data Analysis with Postgres postgr.es/p/6Df



David Bitner 님이 재게시함

We'd like to invite you to attend SatCamp in beautiful Boulder, Colorado, from October 1 to 3, 2024. Because of its unique nature, space is very limited. There are still a few spots left that include accommodations. satcamp.xyz

developmentseed's tweet image. We'd like to invite you to attend SatCamp in beautiful Boulder, Colorado, from October 1 to 3, 2024. Because of its unique nature, space is very limited. There are still a few spots left that include accommodations. satcamp.xyz

David Bitner 님이 재게시함

finally someone made it – tetris in @PostgreSQL, [almost] in pure SQL, with recursive CTEs github.com/nuno-faria/tet… HN: news.ycombinator.com/item?id=414448… UPD: the repo's README is amazing


David Bitner 님이 재게시함

youtu.be/LFzhN5wQqBk?fe… The live demo gods were in my favor! Check out Lonboard running in @pyodide... full speed ahead to geospatial Python running in the browser!

kylebarron2's tweet card. Browsertech.wasm NYC

youtube.com

YouTube

Browsertech.wasm NYC

This will be live streamed! Tune in and cast your bets for whether my live demo will work or not 🎲 youtube.com/live/TQcALWR3d…



David Bitner 님이 재게시함

Lonboard & GeoArrow Rust in @ProjectJupyter's JupyterLite, all running in WebAssembly right in your browser! No server required! Try it out here: jupyterlite.ds.io/lab/index.html…

kylebarron2's tweet image. Lonboard & GeoArrow Rust in @ProjectJupyter's JupyterLite, all running in WebAssembly right in your browser! No server required!

Try it out here: jupyterlite.ds.io/lab/index.html…

David Bitner 님이 재게시함

We're exploring how cloud-native technologies can transform data management for humanitarians. With @jcrowley, we're envisioning a decentralized system for sharing methods & metadata while safeguarding privacy. Let's innovate together! 🤝 🔗: ds.io/rethinking-cri…

developmentseed's tweet image. We're exploring how cloud-native technologies can transform data management for humanitarians. With @jcrowley, we're envisioning a decentralized system for sharing methods & metadata while safeguarding privacy. Let's innovate together! 🤝
🔗: ds.io/rethinking-cri…

David Bitner 님이 재게시함

If you have a PhD in Hydrology, experience with coding/working in the cloud, and an enthusiasm to learn more software dev skills, please reach out! We have a really exciting job opening coming up at @NASAEarthData GES DISC.


United States 트렌드

Loading...

Something went wrong.


Something went wrong.