singlepaynews

I have a postgres schema for relating authors, posts, comments, likes, follows, and all kinds of stuff that works great for relational queries.

The articles table in particular is great, with the exception of the "body" column, where all the sudden I'm hosting a large markdown file.

I want to have an "article_bodies" table in MongoDB that holds many [article_id:article_body] entries, which in my understanding is what MongoDB was made for. I'm thinking this will open higher performance from my postgres, while allowing me to keep writing relational queries everywhere.

Is there a fast and easy way to connect my pg "articles" table to a mongo "articles" table? I'm using PostgREST to host the rest API, will this have the performance impact I'm expecting?

I'm a self-taught webdev, but it seems like more or less everything is either best served by a relational db or a document db, with mongo and postgres being the most widely used standards. Are there any projects/companies dedicated to supporting tooling that links these two? Could we finally be done building new databases?

I’m watching Palantir’s Apollo explainer (https://vimeo.com/745514542/c0ec314888), and it basically seems like a new set of dashboards for what I normally view via AWS EC2, RDS, and IAM. To be clear, I’m not trying to place a value judgement here, my use of the word “just” is because I feel like I must be missing something, but is Apollo just a dashboard layer over AWS?

I am currently stuck in a loop between my iPhone, and a series of new laptops. I'm sure the flowchart is familiar to others: you start with a macbook, it breaks, and now you're constantly reconfiguring your laptop to achieve some version of productivity and sync with your phone.

I thought I'd be able to solve this with a NixOS config, the thinking being that my machine config is a git repo, and if/when a laptop breaks I can simply duplicate it on the new machine.

What's actually happening is that I'm spending more time wrestling unsaved passwords across windows, iPhone, and new Linux installs than any other computer activity.

Like most consumer users, I never really understood how iCloud worked, much less OneDrive, and more often than not am wrestling them to not do things automatically that confuse me. My current state is trying to setup syncthing across two windows machines, only to have an automatic OneDrive action create a mess of my desktop, and I'm hoping someone here will have a 3rd person view and help me stop wasting time on configuration.

My last local maxima was "iPhone / MacBook, everything just works even if iCloud is weird I can do dev work and generally my phone and laptop are the same". I'd like to be able to say "x phone and x laptop, everything just works and when something gets broken/lost I can magically restore the software setup on a new device to replace it without losing data as in files or data as in installed and configured software"

Can this even be done? Am I tilting at windmills? It seems like every major company is trying to achieve this under the condition that you have vendor lock in at the hardware, but even assuming you do that you will only achieve data protection as in files, and every new machine will need another new vsCode install/config step, as will every other application.

I get that there is and always will be both a hardware lifecycle and vendor lock-in, what I feel should be left in the past is the idea that software configuration cannot be moved across the hardware lifecycle painlessly.

www.singlepaynews.com; I’m pretty happy with having a SPA up and running, and not sure what to change, but I feel like my UI is very “coder” and I’d like it to be very “journalist”, if that makes sense. What would be your ideal UI for reading text that was written by Walter Cronkite? (God rest his Soul)