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.
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.
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.
<!-- Okay, if you really want to see a photo of my cat and have resorted to looking at the source HTML, here is a photo: https://gail.com/boxcat.jpg -->
I love my M1 for development, I have a work M1, and I like it so much I am getting M2 for person use.
I had 2 main issues at first, but they are both resolved. One, if you want to use arm native Python conda now supports arm which is great. The second issue was docker, but it turns out that docker has qemu built in. here is an example of how to use x86 docker images on a M1 Mac.
Cool post thanks for sharing! I wanted to throw out another option, older enterprise server hardware is surprisingly cheap on ebay. https://labgopher.com/ has a nice page to help you find good deals (I am not affiliated with them). One warning these servers are outrageously loud and power hungry.
We have been working software for FDA submissions as well. We use Jama https://www.jamasoftware.com/ for requirements management and traceability to test cases.