pe1uca

joined 2 years ago
MODERATOR OF
[–] pe1uca@lemmy.pe1uca.dev 10 points 1 year ago (2 children)

I can't imagine this flow working with any DB without an UI to manage it.
How are you going to store all that in an easy yet flexible way to handle all with SQL?

A table for notes?
What fields would it have? Probably just a text field.
Creating it is simple: insert "initial note"... How are you going to update it? A simple update to the ID won't work since you'll be replacing all the content, you'd need to query the note, copy it to a text editor and then copy it back to a query (don't forget to escape it).
Then probably you want to know which is your oldest note, so you need to include created_at and updated_at fields.
Maybe a title per note is a nice addition, so a new field to add title.

What about the todo lists? Will they be stored in the same notes table?
If so, then the same problem, how are you going to update them? Include new items, mark items as done, remove them, reorder them.
Maybe a dedicated table, well, two tables, list metadata and list items.
In metadata almost the same fields as notes, but description instead of text. The list items will have status and text.

Maybe you can reuse the todo tables for your book list and links/articles to read.

so that I can script its commands to create simpler abstractions, rather than writing out the full queries every time.

This already exists, several note taking apps which wrap around either the filesystem or a DB so you only have to worry about writing your ideas into them.
I'd suggest to not reinvent the wheel unless nothing satisfies you.

What are the pros of using a DB directly for your use case?
What are the cons of using a note taking app which will provide a text editor?

If you really really want to use a DB maybe look into https://github.com/zadam/trilium
It uses sqlite to store the notes, so maybe you can check the code and get an idea if it's complicated or not for you to manually replicate all of that.
If not, I'd also recommend obsidian, it stores the notes in md files, so you can open them with any software you want and they'll have a standard syntax.

[–] pe1uca@lemmy.pe1uca.dev 5 points 1 year ago (1 children)

Well, the thing is, if the physics or render steps (not necessarily the logic) don't advance there's no change in the world or the screen buffer for the pc to show you, so, that's what those frame counters are showing, not how many frames the screen shows, but how many frames the game can output after it finishes its calculations. You can also have a game running at 200 frames but your screen at 60.

So, when someone unlocks the frame rate probably they just increased the physics steps per second which has the unintended consequences you described because the forces are not adjusted to how many times they're being applied now.

And a bit yeah, if you know your target is 30fps and you don't plan on increasing it then it simplifies the devlopment of the physics engine a lot, since you don't have to test for different speeds and avoid the extra calculations to adjust the forces.

[–] pe1uca@lemmy.pe1uca.dev 26 points 1 year ago (1 children)

Neither, use "Latino", that's the gender neutral form.
Or if you don't want to use it and don't want to follow Spanish rules then follow English rules and use "Latin".

[–] pe1uca@lemmy.pe1uca.dev 4 points 1 year ago

Here's how I have harry potter 1 with the option for the extended format, I'm guessing it'll be the same flow for different codecs.

hp.1[imdbid-tt0241527].mp4
hp.1[imdbid-tt0241527] - [Extended][Latino].mp4

And in the UI it shows me a dropdown called Version which has two options
hp.1[imdbid-tt0241527]
[Extended][Latino]

https://jellyfin.org/docs/general/server/media/movies/#multiple-versions-of-a-movie

Not sure if this works for shows. Also because the name template you use already has dashes.
And most probable it won't work to autoselect the codec for the device you're using.

[–] pe1uca@lemmy.pe1uca.dev 10 points 1 year ago

What? AI search in Firefox? Haven't seen it, tho I have a custom search engine.

How is the setting in brave related to Firefox?

[–] pe1uca@lemmy.pe1uca.dev 1 points 1 year ago

A browser is also an app, it's not embedded into an OS.
In some it comes preinstalled, which is the case for safari in ios.
Also, some browsers just happen to include a PDF reader, but not all had or currently have.

As @viking@infosec.pub mentioned, Android is meant to be lightweight so it can run in several configurations of hardware.
Most OEM do include a browser in Android, this usually being Chrome. GrapheneOS is basically just Android (in this context) so it doesn't include a browser or a PDF reader, but both are available as a dedicated app from the GrapheneOS team or with any other app you want, for example I use readera, or sometimes Firefox.

[–] pe1uca@lemmy.pe1uca.dev 1 points 1 year ago

I was juggling like that, I had most of my files in NTFS so I could read them in windows, even for files read only by Linux programs.
Most programs were able to read from any part of the file system, but for those with strict paths I used symlinks.

But I haven't had any use for Windows lately so I decided to delete all but one NTFS partition and this last one is only 256GB with 100GB free.
The rest of the data I moved it to ext4 and btrf partitions.

[–] pe1uca@lemmy.pe1uca.dev 6 points 1 year ago (2 children)

You can explain them google is already integrated, they can use the address bar to type their query and hit enter to ask Google whatever they want.

[–] pe1uca@lemmy.pe1uca.dev 7 points 1 year ago (1 children)

Could you get a fountain?
Specially if it spreads the water like rain, it'll help cool the air around, you'd just have to change the water every so often.

If where you live is not very humid you could investigate into swamp coolers.

[–] pe1uca@lemmy.pe1uca.dev 1 points 1 year ago

You have to configure the space bar to allow a long-press to give you a popup menu to select another language. Currently there's no way to have multiple languages with the same layout, it's annoying but you can work with it.

[–] pe1uca@lemmy.pe1uca.dev 1 points 1 year ago

Oh, I was only aware of credits where the lender sets the amount to be the total exactly spread over the period, those are the only ones I've seen and taken, so each month I get a charge for the amount needed to keep up with the credit.
For the rest then it makes sense how they make money, since I've had credit cards which don't show or at the very least hide the amount to not pay interest and only tell you the minimum payment.

[–] pe1uca@lemmy.pe1uca.dev 5 points 1 year ago

Well, it's just a TS project with a very simple Dockerrile, you can just bun install && bun run prod.
The rest of the dependencies aren't included in the docker image.

view more: ‹ prev next ›