this post was submitted on 02 Aug 2023
5 points (100.0% liked)

Mbin Blog Updates

4 readers
2 users here now

Blog updates for Mbin (fork of /kbin). Upcoming features, issues or anything else related Mbin or the fediverse.

Just follow this magazine to keep yourself up-to-date!

founded 1 year ago
MODERATORS
 

I pushed recently various sql improvements into the develop branch: https://codeberg.org/Kbin/kbin-core/commits/branch/develop

I advise all /kbin server owners to update their instance again!

I went through all the source code, fixing all possible sql injections once and for all. I have no idea how this all ended up in the code in the first place to be honest.
New code needs to be peer reviewed thus verified by another person, unit tested and follow our coding style guide as well.

top 4 comments
sorted by: hot top controversial new old
[–] [email protected] 2 points 11 months ago (1 children)

Thank you for reviewing and fixing the SQL.

[–] [email protected] 1 points 11 months ago

Don't forget the subscribe the magazine, if you wish to get more updates.

[–] [email protected] 2 points 11 months ago (1 children)

Maybe this is a good a place as any to ask... is there any reason the project Docker install is using PostgreSQL 13? I edited the docker compose scripts to use alpine 15 version of PostgreSQL and it seems to work fine. There are performance improvements in newer releases on indexes and such that would benefit the project.

Can someone established in the project do a pull request to change it?

I know existing installs would need to do an upgrade that revises the data, but surely new installs can start using 15?

Thank you.

[–] [email protected] 1 points 11 months ago

I was trying to accomplish the same thing months ago (https://codeberg.org/Kbin/kbin-core/pulls/235). But I think we can now even migrate to v16. Feel free to create a new PR again.