I have been working on performance recently and today had some pretty nice gains for builds related server code. 3x more efficient in common paths and up to 15x on less common paths! + improved localized date time logic. Now it uses your browser language and should be more consistent. #sendouink

SendouQ Season 11 Finale Qualifier is now live! 🎙️ @sasuinurpants.bsky.social & @roseofbattle.com 🟣 twitch.tv/iplsplatoon 🔴 youtube.com/@IPLSplatoon

PRAGMA optimize; Basically record information about the data to optimize queries. Except in this one case the extra information caused the query planner to drastically choose the suboptimal plan making the query get 520x times slower Databases are cool but scary

Splatoon popping off in Singapore 🔥🔥🔥🔥 Too bad they have 0% solve rate with bot captchas Anyway this got me distracted from the real root cause of the website crashes in the past day. Real reason seems to be DB call hanging on tournament finalization. I now disabled it temporarily. #sendouink

Since the season is ending this weekend one more reminder how it works this time around: - SQ Finale Qualifier TOMORROW, top 4 teams advance to Finale - In addition top 12 teams from leaderboard advance to Finale - Finale acts as a qualifier to Global Gauntlet #2 #sendouink

I've been focused on various bug fixes/tweaks. Most not really worth mentioning as they are minor or fixing very rare crashes except: - Adding Splatnet link to chat should now generate the QR (and make the link clickable) - Fixed tournament bracket/match pages not auto-updating #sendouink

⚠️ important info ⚠️ Top 3 from SQ Finale qualify for Global Gauntlet #2! To qualify (qualifyception) to SQ Finale you need either 1) Top 12 from the leaderboard (same old method) 2) Top 4 in SQ Finale qualifier this Sat ⚠️ 7 SQ sets needed to be able to play SQ Finale qualifier ⚠️ #sendouink

For what it is lacking the core data gathering functionality of the official tournament manager is awesome. Still have all the stats from 2023 viewable. Makes me think (wish) how it could work in cooperation with sendou.ink just because having automatically all replays and stats would be so cool

With the Plus Server voting starting a couple reminders: 1) How votes are processed is changed as communicated earlier 2) In one week there is SQ Finale qualifier that is alternative way to qualify other than the leaderboard! Every member needs 7 SQ sets played this season #sendouink

New match page update (SQ/tournaments/scrims) is live now! If you find any issues or even something working a bit funny let me know and I will take a look. #sendouink

This last month I have been working on a full reworking of the match page! Familiar look but with new often requested additions 💠 unified look SQ/tournament/scrims (and future features 👀) 💠 new SQ rejoin q flow 💠 weapon reporting for tournaments 💠 splatnet join link w/ qr's and more! #sendouink

Happy birthday sendou.ink! 🍾🎉 7 years ago I made the first commit to my university project. I don't think I would have expected to keep working on it almost every single day for the next 7 years :) Here's for 7 more? Thank you every user along the way! It's been nothing but fun. #sendouink

Today's update: Date format preference (DD/MM/YYYY or YYYY-MM-DD) and pagination for vods (before it just used to not show all vods if there were too many with the filter....) Also random bug fixes and tweaks as always. #sendouink

I kind of want to experiment with a format in Season Finale where at the start both teams ban one mode TC/RM/CB and then remainder of the set is SZ->TC/RM/CB->SZ etc.

We survived; Global Gauntlet #1 by SWS, presented by IPL in collaboration with AREA CUP has concluded. Thank you for playing! Look forward to news about GG2 coming soon. #sws26

The format is way too good. The only problem is that there are so many sets that would be grand finals tier in any other events so you want to watch them all. #sws26

GG such a hype event. Good job anyone involved. We actually added quite a few new features to the platform to support the event: custom pick/ban, "bipartite" round robin, API changes & stand-alone RR tournaments. Watch here! sendou.ink/to/3369/stre...

Global Gauntlet #1 concludes tonight. #sws26 EN on @iplabs.ink 1: @patjortom.bsky.social @sasuinurpants.bsky.social 2: @splatfufu.sunsetsurge.ink @spfdark.bsky.social Analysis: @kbot273.bsky.social @popgun.bsky.social (!) @xshadowind.bsky.social JP on AREA CUP @hemicha.bsky.social & Nitorabichi

Tomorrow!

Was a fun interview! Lots of topics covered. Thank you @ismiseradha.bsky.social

Some quick and dirty UI exploration for fun, but what if we used the chat sidebar slot for other things too depending on the context like this inline analyzer feature when browsing builds? I could see it being used elsewhere too like checking out a player quick while seeding or SQing... #sendouink

IN THE ZONE 51 This Saturday @ 1PM ET / 7PM CET $240 prize for the winner! SZ only. Register or look for a team here: sendou.ink/to/3436/regi... #sendouink

Wanna thank everyone who takes time out of their day to give feedback on the project! Almost everyday I’m adding or fixing something based on that. Invaluable for making the app the best it can be 💪 Example from today: reorder comps in analyzer via dragging. #sendouink

Raiders look pretty fun but it does look like DLC that just got a bit out of hand. I guess the main difference to something like Side Order is just the amount of content looking at this? Hopefully some meaty S3 patch to go along with it.

8 years ago 🤯 The base idea in my opinion was simple but fun. Teams are ranked in a ladder and you climb by winning against teams above you. If you win you swap places. Limits how high up you can challenge. Both 1v1/4v4 versions.

Today's update: - Fix own messages showing unread in chat - Chat room for pickups (tournament LFG feature) - No unread/chat room clutter if you are not in the active roster for tournament sets - Allow TO's to read chats up to 1 week after tournament has finalized #sendouink

Added some new features 1) Map planner ranges - estimate range of all main weapons. Toggle on/off. Both overhead and minimap. For weapons with splash damage (e.g. blasters), it is shown as another blue circle. 2) On user results page search for results by tournament name #sendouink

Proof of concept ranges in Map Planner. Worth the effort or not?

Very cool little UX touch added by @hfcred.dev You can now type w./u./t./o./to. to quickly change what you are searching for on the global search eliminating those unnecessarily clicks when you just have to go... Register for In The Zone 51! Happening Saturday 25th April w/ $240 prize #sendouink

How to work on features: 1) Gaslight yourself by saying "it won't be that much work surely" 2) (optional) Scope creep by saying "might as well do that while we're here" 3) It is that much work but now you have to keep going because otherwise so much work wasted 4) ???? 5) Repeat

Thanks to a donation In The Zone 51 two weeks from now on Saturday has a $240 dollar price for the winning team! Can't get a pick up together early enough for this one 🤯 sendou.ink/to/3436/regi... #sendouink

My favorite tournament prize

LUTI Divs vs. sendou ink seeding power How much difference there really is between Div 7 and Div 10? Otherwise I guess you see the hierarchy of it quite well.

I see like nobody play it but to me personally Sloshing Machine feels better than any blaster I've tried this patch. Just the added range compared to something like Luna is so nice.

Very nice PR by @inkfarer.com in today's update. Open source always 🔛 🔝 for stuff like this. Great way to keep learning more.

New new user profile page widget: member join # Unlike the numbers you have on the old design these actual correspond when you joined the site. I reconstructed them from the old database (so e.g. mine is now 1 instead of 274). If you are a true OG you might even see the "SPL2" B) #sendouink

New SendouQ feature today: team map/mode preferences In addition to your personal map/mode preferences you can now have one for each of your team's. The team map preferences are automatically used when queueing with your team. #sendouink

Planning to redesign the current match page to make room for some new features etc. lmk if you have some problems with it. Idea is that tournaments/SQ/some future things will share the core layout with specific things unique between them ofc. #sendouink

New sendou ink features! 1) After tournament has concluded, we will now automatically get timestamped VOD links for Twitch and show them on bracket. 2) "Spoiler free" mode you can enable on the settings, hides results of recent tournaments unless you click a button to reveal #sendouink

Reminder that there is still the new layout feedback thread on my Discord. I think most of the reported things have been either fixed or noted for later but if you have something in mind that you didn't report yet feel free to do so. In replies here is good too. #sendouink

Idea for a new badge system where the actual models will be rendered in real time, fully interactable. Model by @brushmommy.bsky.social

Brand new features! 1) Aside from just counterpick or ban 2 you can now have more custom pick/ban in tournaments. For teams this means a new strategic depth and for organizers new ways to differentiate your event 2) Friends widget (new user page) #sendouink

picoCAD 2 is out! 📐 build models easily 🎨 draw pixelart textures 🍿 make simple animations Get it on Steam and itch! 👉 picocad.net #screenshotSaturday #pixelart #gamedev

In The Zone 50 is happening tomorrow! Don't have a team yet? Try the new #sendouink tournament LFG feature: sendou.ink/to/3435/look...

For the past few days I've been mostly in bug fix mode but also managed to sneak in a few new features: 1) You can now generate YT timestamps from a VoD you submitted to the site (chapter markers) 2) Notifications for /to/:id/looking page like/group merge 3) Tournament page share button #sendouink

Idek how it was before but it's so funny to play. Inkjet one of the better designed specials no doubt. I'm what you might call a seasoned player these days so these longer range guns suit me well

This concept came to mind about map+mode notes. For example: your own notes from solo what spots work? Team notes from VoD review, how to open? Some top level players notes about the best inkjet spots on that map. Goal=improve your play across variety of maps. Useful or not really? #sendouink

Thanks for the early feedback everyone 💪 Got 17 different fixes in already tonight and more tomorrow as well as over the weekend.

It got a bit out of the hand

Biggest update to sendou ink ever is now live! New layout, friends system, SQified tournament subs, site-wide chat, new mobile UI and so much more... Huge shout-out to @hfcred.dev for all the work on this with me. Wouldn't be possible without their efforts. #sendouink