Good news: I'm back!

Bad news: I'm even crazier than before! 🤪

I'll open commissions a little later. I'll also probably slowly migrate from vector stickers to video stickers.

Overcoming technical problems with crazy tricks is fun and all, but it isn't sustainable if commissions are to be my main source of income. 😆

Viewed:	8 times
Added:	9 months, 3 weeks ago 17 Apr 2024 15:46 CEST

5 Comments on this Journal

Leave a Comment...

GreenReaper

9 months, 3 weeks ago

link

You won't believe this one great trick that saved Inkbunny from database index corruption! 😸

CrazySnep

9 months, 3 weeks ago

link

@ GreenReaper

Wait, what trick? 😆

GreenReaper

9 months, 3 weeks ago

link

@ CrazySnep

It's extensively covered in my comment to this post. Be warned, CTEs ahead!

CrazySnep

9 months, 2 weeks ago

link

@ GreenReaper

How on Earth the previous sorting order was "a, $a, a$, A"? 😂

What keywords became duplicate?

GreenReaper

9 months, 2 weeks ago

link

Edited 9 months, 2 weeks ago by Owner

@ CrazySnep

Well, 'cub', for a start. That was about when we started getting reports of problems, as you might imagine. There were actually three instances at one point, because it would use the index to see if a word was present, and if the index is corrupt it might go the wrong way down a b-tree and never find the existing value, so it would create a new keyword entry when it was meant to be unique. And because the new 'cub' had a different numeric ID, it wasn't stored in everyone's blocklists.

New Comment:

Move reply box to top ↑

Log in or create an account to comment.

Help

Information

Policy & Legal

All artwork and other content is copyright its respective owners.

Powered by Harmony 'Gravitation' Release 80.

Content Server: Virginia Cache - provided by Inkbunny Donors. Background: Blank Gray.

The Inkbunny web application, artwork, name and logo are copyright and trademark of their respective owners.