ubq323

the

i am the owner of this terrible excellent website

i have other websites also

— ubq323

joined
a very long time ago

recent posts

ubq323 #252

css/presentation todo:

  • tidy up all the old grid things since we don't need them any more.
    • remove all obsolete or unused css from style.css and generally organise it a bit
  • add "number of replies" field back to thread listing
ubq323 #251

(posting this here now because it's in my head but i have to go and do something else right now)

db todo:

  • use rcte for forum parent breadcrumbs
  • create views for most recent activity (per forum and for subforums), then simplify the big query for viewing a forum
ubq323 #244

this could occur. what tags would you like to see specifically? what kinds of animations?

and doesn't this count as an animation anyway

ubq323 #237

this is a test test

ubq323 #236

🐝 🐝 🐝 🐝

ubq323 #235

todo item: apionet integration and discord webhook support

ubq323 #232

ah yes

ubq323 #229

this is being sent from the lynx browser

ubq323 #219

<marquee> now works

ubq323 #195

wow!

ubq323 #194

A spectre is haunting Europe - the

ubq323 #193

once subforums exist all existing threads will be sent into one of the subforums. i haven't decided what kind of subforum that should be yet. deleting everything would be unfortunate, perhaps

ubq323 #188

sqlite is slightly annoying about what kinds of columns you are allowed to add to tables after already creating them. specifically i want to have the forum column on the threads table be NOT NULL DEFAULT 1 REFERENCES forums(id) but when adding columns with ALTER TABLE the default has to be NULL if the column includes a foreign key. it would therefore be slightly easier if i could delete all threads and create a new threads table.

however i can still just create a new threads table, with the column i want, and then copy all the existing rows into it, and that can all be done in pure sql so it will even still work with our exisitng migration thingy. so you're right this isn't even much of a big deal at all.

hmm there was something else involving moderators that i think would make this a bit more difficult but i have forgotten what that was about now. i'm sure i can figure out a way around it. and anyway, the worst case is that i have to manually run a python script on the server or something. there is only one deployed instance so this isn't that hard.

ubq323 #187

SO true

ubq323 #162

it is possible that the development of certain future apioforum features would be made easier if the database was wiped during certain updates, instead of performing complicated migrations to preserve everything. i would be interested to hear people's opinions for and against this, so that i can know whether people strongly want things on this site to not be deleted, or if they don't care that much.

it isn't guaranteed that wiping will ever be necessary, or preferable; i am just curious about how people feel about this, if it ever does become a thing that might be useful for us.

please deposit your opinions about this into this thread, where they will be ignored considered thoroughly.

ubq323 #156

i agree

ubq323 #151

so true

ubq323 #137

i didn't mention, but fenced code blocks are also enabled now

def bee():
    for i in range(12345):
        print("bee")

syntax highlighting isn't enabled, yet.

ubq323 #133

update: images are now enabled

ubq323 #132

actually i changed my mind. the apiology tag now exists.

ubq323 #131

i could allow the <img> tag i suppose. i might have to do some cssoids so it doesn't look terrible but i can't see any other reason not to do that.

ubq323 #130

currently, adding tags is somewhat bees, since it requires directly messing with the database. i was going to add an interface to allow admins to manage tags, but i have postponed this for now, because it would need refactoring after adding support for subforums. this is because subforums will be able to have their own sets of tags, determined by the moderators of those subforums.

i would add the tag that you requested, but i don't want to set a precedent of adding arbitrary tags at a global level whenever anyone asks, because fairly soon you will be able to create whatever tags you want for your own purposes.

ubq323 #123

notifications and mentions

  • add syntax for mentioning another user, perhaps @username. when a post containing mentions is posted, that user is notified about that post.
    • perhaps also support mentioning groups of users, eg all the moderators of a given forum or all the site admins, or something
  • each user has a set of threads they are 'subscribed' to. there is a button to subscribe/unsubscribe on every thread. when you create a thread, you are by default subscribed to that thread.
  • there is a 'notifications' page that lets you view unread notifications.
  • presumably there is some system to work out which notifications you have read and haven't read. i will think through that later.
    • also, if we separately have a 'number of unread posts' field on each thread which is separate from this notifications system, then that will use the same system as this, presumably. (presumably it will be useful to see the number of unread posts on threads you aren't subscribed to)
  • once we have subforums, you will be able to
    • subscribe to a forum, and be notified when new threads are created there
    • (separately) enable auto-subscription to all threads created there, and be notified of all posts created in those threads
    • subscribe/unsubscribe to all existing threads at once easily.
  • presumably we should avoid notifying a user twice about the same post (ie via subscribed thread and via mention)
    • but if a post is edited so that it now contains a mention we would want to notify them
  • if a post is deleted presumably notifications pertaining to that post should be removed. if a post is edited so it no longer contains a mention then the notification of that mention should presumably be removed. (we should think about what ux makes most sense here)
ubq323 #122

oh, unless you're talking about formatting, in which case markdown formatting is supported but you can use html tags too.

ubq323 #121

there is no javascript anywhere on this site, if that's what you're asking. the backend is written in python, and the source code for the whole site is available here.

ubq323 #106

!!!!!

ubq323 #97

you can click on anyone's username to go to their user page. you can also go to your own user page by clicking your username in the navbar at the top right. on your own user page, you can click settings to edit your user bio. you can also change your password on this settings page.

hail GEORGE

ubq323 #96

mu