subversive_dev

Fair enough, I capitulated and I use spotify for podcasts now

Have you used Firefox recently? There are a few chrome only sites but I’ve been daily driving it for a few months and it’s mostly upside

I found this in the wastelands of Google: https://www.howtogeek.com/linux-distributions-to-breathe-new-life-into-old-hardware/

I read the guide and it seems pretty solid.

If it is not x86 is it the Itanium ISA?

You’re welcome!

So if you didn’t care about having to wait for the video to buffer on every scroll, it becomes an easier problem. I kind of think that defeats the purpose of a tiktok-style interface though.

I agree that you wouldn’t necessarily need to build a new algorithm, but like I said, it’s part of the smooth scrolling magic

I’m a dev but not very good at mobile.

I can promise you that a lot of engineering work went into making the tiktok scrolling experience so smooth. Part of the trick is having a good enough algorithm that the user wants to watch the majority of served videos.

Another huge part of it is having lightning fast content distribution and aggressive “prefetching” of the next videos in the feed.

I don’t want to discourage you but I also don’t want you to be caught off guard by the difficulty. Do you want to make this bad enough to give it your nights and weekends for a year?

ELI5: a database is the “memory” of a program.

Every piece of data that any software uses almost certainly comes from and goes to multiple databases.

Once the data is stored, you can execute “queries” to have powerful access to update many records at a time, read particular records based on their relationship to other records, and so much more.

Your bank balances, your purchase history, your emails, every part of your digital life is almost certainly spread across a constellation of databases.

Bonus Fediverse content:

Lemmy itself uses the Postgres database extensively. Posts, users, comments, votes and more are all individually stored in the database.

Mastodon also uses Postgres. If a post goes up on Lemmy, and a Mastodon server is federated with it, the Lemmy server will send out a HTTP request to the Mastodon server containing the contents of the post. The Mastodon server will use this information to write its own record of the post in its own database.

Regarding your question about VMs: You can run a database inside a VM, or give the VM access to an outside database via queries, or both! You might run SQLlite (a small and excellent embedded database) on the VM to track its local state, while also running queries against a large postgres database to synchronize with other services in the cluster.

“Performance talent doesn’t exist, also: Ayn Rand”

Who is “we” and why do they get to decide whether other countries exist?

Be the poster you want to see in the Lemmy

Well probably because:

• Lemmy is explicitly a reddit clone
• The vast majority of lemmy users are recent emigres from Reddit
• Reddit is still much larger and more influential

It’s a reference to 1984

It looks like this is the closest thing to what you are looking for.

someone builds a lemmy PWA so every user can have their own interface with api to the instance.

Fellow traveler, I’m happy to tell you that’s how it is already!

The URLs like m.lemmy.world are just a convenience, and you can use Voyager, mlmym, Alexandrite and the rest on ANY Lemmy instance, whether they have set up a convenience URL or not.

Welcome to the wonderful world of Standard Fruit Company

Damn what a rabbit hole and TIL

It’s possible your posts could get boosted by new/all sorters and make it to hot/all even with no subscribers, but I would recommend trying to advertise the community and get subs first to improve your odds of growing your audience

Right!? I believe it has the hallmark repetitive blandness indicating AI wrote it (because oroboros)

Total guess but I imagine the increase in relative humidity impacts the combustion efficiency of the engine as well