I’m working with several Postgres databases that share identical schemas, and I want to make their data accessible from a single interface.

Currently, I’m using Postgres FDWs to import the tables from those databases. I then create views that UNION ALL the relevant tables, adding a column to indicate the source database for each row.

This works, but I’m wondering if there’s a better way — ideally something that can query multiple databases in parallel and merge the results with a source database column included.

Would tools like pgdog, pgcat, pganimal be a good fit for this? I’m open to suggestions for more efficient approaches.

Thanks!

Thanks for the Pigsty link. I have been a big fan of running Postgres on metal machines.

Here's hoping LLMs stick to the naming trend used for telescopes like the ELT:

• Large Telescopes → Large Language Models (LLM): Solid start, foundational capabilities.

• Large Telescope (VLT) → Very Large Language Models (VLLM): Major upgrade in size and skills.

• Giant Telescopes → Giant Language Models (GLM): Multimodal, smarter and more specialized.

• Extremely Large Telescope (ELT) → Extremely Large Language Models (ELLM): Expert-level, cross-domain.

• Overwhelmingly Large Telescope (OWL) → Overwhelmingly Large Language Model (OWLLM): Theoretical AGI, huge power, ethical dilemmas.

I have used https://github.com/lastmile-ai/aiconfig to encode some of my more common prompts into application like things. You can encode them into a yaml/json file.

With v12.5.1.1 My Tesla ran into a curb, I had to get 2 wheels and tires replaced

https://twitter.com/gourneau/status/1821005220190798038

Who paid for this in your case?

So far I have paid out of pocket, I have an insurance claim but I expect to at least max out of deductible.

So you're insurance rates are going up while Telsa avoided all liability for what should be considered buggy safety critical software?

Meta folks if you are reading this , please give us a real SDK. Great hack though until we get that!

If you are on Windows and have extra laptops of devices hanging around SpaceDesk https://www.spacedesk.net/ to a great free app (not open source). I use it with on my Windows Dev machine (WSL2 FTW) and use old laptops as external displays. It works well even on WiFI.

Thanks, I just got SpaceDesk working on a cheap Amazon tablet over USB-C (after realising I had to set PTP mode on the tablet...) Should work really nicely as a second monitor when travelling, I have it on 60fps and high settings and the latency is barely perceptible.

I was excited seeing iOS 9.3+ on their requirements listing, but after digging my useless but 100% functional iPad 2 out of storage it won't install the app. :(

I do use the built-in iPad as a second screen thing in MacOS with a still supported iPad on occasion and that works quite well.

Thanks Eli! Almost 15 years ago learned a lot about Python GUI work from your blog. Some of your examples helped me write some software for NASA!

I also loved this game it was my first MMO, and in many ways was so ahead of its time. I still dream about it occasionally.

BTW the author has one of the best FIRE (Financial Independence to Retire Early) calculators as well https://engaging-data.com/early-retirement-calculators-and-t...