Readit News logoReadit News
whoopdeepoo commented on Harlequin: DuckDB IDE for the terminal   harlequin.sh/... · Posted by u/billowycoat
quadrature · 2 years ago
If anyone here is using DuckDB in production i'd love to hear what your stack looks like over the entire lifecycle of extract->transform->load.
whoopdeepoo · 2 years ago
We use it to sort parquets out of core and then the arrow interface to read into Python and export as geoparquets

Loading parent story...

Loading comment...

whoopdeepoo commented on DuckDB 0.8   duckdb.org/2023/05/17/ann... · Posted by u/nnx
whoopdeepoo · 3 years ago
Such an amazing project. Once the geospatial extension lands I'm going to seriously consider switching our geoparquet workflows over.
whoopdeepoo commented on RAM’s New Electric Pickup Truck Aims for Battery Range of 500 Miles   wsj.com/articles/rams-new... · Posted by u/lxm
whoopdeepoo · 3 years ago
Electric pickup trucks are an insanely priced novelty until they figure out towing performance.
whoopdeepoo commented on Show HN: The Shark Programming Language   github.com/shogundevel/sh... · Posted by u/shogundev
whoopdeepoo · 3 years ago
Cool, but you really need a grammar check. Pass this through chatgpt or something.
whoopdeepoo commented on Hyundai promises to keep buttons in cars   thedrive.com/news/hyundai... · Posted by u/nixass
gorjusborg · 3 years ago
I've never owned a Hyundai, but stuff like this makes me want to look at them.

I recently bought what I thought was a car, only to find it is a tech-ridden abomination.

I want a vehicle that is reliable. I want a vehicle that is simple. I do not want a rolling AI/touchscreen.

Even just from a security standpoint I want minimal software in my car.

whoopdeepoo · 3 years ago
Buy a Mazda
whoopdeepoo commented on Apartment rents fall as new supply hits market   wsj.com/articles/apartmen... · Posted by u/lxm
MobileVet · 3 years ago
The number of 6 story high apartment complexes with massive footprints that have gone up in our university town is amazing. I need to find the raw numbers and compare that with the current population, but it is substantial.

Honestly, I have been wondering for several years now who is going to fill all these apartments. The scale of increase is really that big.

Maybe the answer is… no one?

whoopdeepoo · 3 years ago
The answer is foreign students if it's anything like my university town.
whoopdeepoo commented on A Heisenbug lurking in async Python   textual.textualize.io/blo... · Posted by u/willm
samwillis · 3 years ago
This is one of many reasons I'm sceptical of the current trend in Python to "async all the things". The nuance to how it operates is often opaque to the developer, particularly those less experienced.

GUI toolkits (like Textual) however are a really good use case for Asyncio. Human interaction with a program is inherently asynchronous, using async/await so that you can more cleanly specify your control flow is so much better than complicated callbacks. Using async/await in front end JS code for example is a delight.

Where I'm particularly unconvinced of their use is in server side view and api end point processing. The majority of the time you have maybe a couple of IO opps that depend on each other. There is often little than can be parallelised (within a request) and so there are few performance gains to be a made. Traditional synchronous imperative code run with a multithreaded server is proven, scalable and much easier to debug.

There are always places where it's useful though, things such as long running requests (websockets, long polling), or those very rare occurrences where you do have many easily parallelizable IO opps within one short request.

whoopdeepoo · 3 years ago
I don't write any colored function code in python, I'd much rather work with process/thread pools
whoopdeepoo commented on A Heisenbug lurking in async Python   textual.textualize.io/blo... · Posted by u/willm
whoopdeepoo · 3 years ago
> But who reads all the docs

Why is this so common? Do people seriously not read a language/library documentation? That's the absolute first thing I do when evaluating a technology.

whoopdeepoo commented on QGIS is the mapping software you didn't know you needed   chollinger.com/blog/2023/... · Posted by u/otter-in-a-suit
nobleach · 3 years ago
QGIS and PostGIS were my jam when I worked in that space. We were an ESRI shop so Oracle/SQL Server with SDE (topped with ArcGIS) were the official tools. Some of us were always looking for ways to subvert the culture by building tools based on open source stacks.

One of my favorite experiences from that era: We were meeting with a few ESRI reps for some integration stuff. The lead hot-shot was on his phone playing around during the meeting. He was basically on autopilot. The other two folks were working with GeoJSON response convertors. I said, "I built one of those with TopoJSON". One guy said, "I've never heard of it". I showed them how it was much more efficient and used splines instead of points. The lead dropped his phone and said, "I need you to tell me MORE about that". I showed them the service. They invited me to lunch, I politely declined and said, "today's my last day so I have a ton of things to wrap up". I do miss that realm sometimes.

whoopdeepoo · 3 years ago
ESRI is a scourge on the GIS industry. One of the creators of postgis can say it much better than I can.

https://blog.cleverelephant.ca/2018/11/esri-dominates.html

u/whoopdeepoo

KarmaCake day118March 25, 2022View Original