metrics VS szurubooru

It's worth keeping an eye on Diesel's metrics suite (https://github.com/diesel-rs/metrics) as well; I found and fixed some suboptimal buffering that was affecting performance.

See here for some numbers. The relevant code lives inside the diesel github repository. Please also keep in mind that these are just numbers and you should run those these on your own and also run tests with your actual work load.

Performance is worse than in comparable frameworks

For the database part you might want to checkout a crate that's not based on sqlx as sqlx is known for providing non-optimal performance for the sqlite backend. rusqlite or diesel perform much better for this use case.

No it will likely not be less performant. See these numbers for some benchmark results for numbers. (As always with benchmarks: Please don't trust my numbers. To be sure you need to do your own benchmarks with your own use-case)

See here for some benchmark results. The benchmarks itself are in the diesel repository. Otherwise I believe there are numbers in the techempower benchmarks as well, although that includes other factors .

I'm developing a Rust web server backend in Axum that uses Postgres and performance will be pretty important since I plan to run it on one server for as long as possible. It seems like the postgres crate is about 2x faster than sqlx, and the postgres repository seems pretty active still.

Congratulations to the release. I know all of this is hard work. I would like to invite you to submit a ormlite implementation to the diesel benchmark collection. As soon as that's merged you will get regular reports here. The relevant code is here in the diesel repository.

In that case you may be interested in the metrics for different database libraries. diesel is doing rather well at the moment. sqlx is in the middle of a large rewrite that should improve performance, so we'll see how it compares after that

See here for some benchmark results for the diesel repository. Please keep in mind that as always with benchmarks, these numbers are not necessarily true for your usecase. Be sure to checkout at least the benchmark code and draw your own conclusions from there.

I've been accumulating art and pictures downloaded from the internet, what's a good way to store and tag them with the original artist and source? Maybe a simple solution would be just adding appropriate EXIF data to the files? This approach would still require a good folder structure to make sense of. Another option I came across was https://hydrusnetwork.github.io/hydrus/index.html, but after trying it, the experience was really janky and not pleasant. Or I could even host an image booru so the collection would benefit others too, with https://github.com/rr-/szurubooru perhaps?

How do other people deal with it, I'm curious to hear.

also agree with hydrus network. im at 18million items. next best thing is probably something like a selfhosted booru server so that you can remotely organize files during your downtime on the toilet or jury duty.

I'm your savior, together with https://github.com/rr-/szurubooru

There is also https://github.com/rr-/szurubooru/discussions

On unraid postgres is used by szurubooru, mealie, and grafana. I don't know specifically what but I know redis is also used by one of the apps in the cloud group as well.

name: mybooruname #yes this next line is empty as i mention above, but the [INSTALL.md](https://github.com/rr-/szurubooru/blob/master/doc/INSTALL.md) says you can skip lines of which you want to use the defaults. or should i add something here? domain: secret: mysecretstring delete_source_files: no thumbnails: avatar_width: 300 avatar_height: 300 post_width: 300 post_height: 300 user_agent: max_dl_filesize: 25.0E+6 convert: gif: to_webm: false to_mp4: false allow_broken_uploads: false smtp: host: localhost port: 25 user: myusername pass: thisisapass from: noreply@localhost enable_safety: yes # the rest is just regexes for tags, pools, usernames, and passwords, and user rank privilege stuff

If you need tagging / users and stuff for the images, I’ve used https://github.com/rr-/szurubooru

Honestly, your project makes me want to contribute to I but I have absolutely no experience with Golang. I see a lot of potential in it and because it's comparatively new and barebones, there aren't any entrenched concepts like with more mature projects. Like, if you ever get around to implementing a more comprehensive organization system, do check out Szurubooru. Tags and tag categories can replace Albums, Faces, Places, Objects, Themes, Colors, EXIF data and so much more. You can still use tooling like AI recognition, geotagging, EXIF readers, and whatnot to populate them accordingly but being standardized as TAGS makes searching and crawling much easier. Not to mention defining custom tags would allow for a very versatile usage. And with a fluid browsing like yours, it will be a dream app.

I can share something like that. There is this imageboard called (Szurubooru)[https://github.com/rr-/szurubooru]. People use such boards to host their anime and hentai stuff.

I kinda have something for Twitter accounts, said thing being this extension, but I stupidly don't use it enough. You see, I archive my posts using szurubooru, which is on a by-post basis, so everything has to be added one by one. (Technically, you can upload multiple at once but there's no function to add tags before upload, only after.)