By reilo Go To PostSharp rightly pointed out that I had the wrong index. Due to a specific Postgres configuration he made, the query planner wasn't going against this new index, so we had to add another index to make it work. That fixed it and now the execution time is sub 1ms for users with 0 posts and up to 7ms at most for users with some posts.
Word. solid work mang.
By reilo Go To PostThere’s ways to handle that without posts counts. We don’t care about user post counts as status symbols but really it’s because counts are super fucking slow from the database. There’ll be updates in the future to help with the UX of new threads.
appreciate you responding to my garbled post!
By PanickyFool Go To PostJust noticed something? Where are the adds? Is this a bug?Nope, there none.
By RobNBanks Go To PostNope, there none.Blessed be this board.
By PanickyFool Go To PostJust noticed something? Where are the ads? Is this a bug?
Even though I do not know how to edit, and instead quoted myself lol. (edit after figuring out edit)
By reilo Go To PostI’ll make a trackable list of features being worked on tonight. Check a couple pages back I gave an update on what’s happening.Dude, thanks for that! I've only been doing web dev for about a year and a half. Whenever I visit a site that I don't think I could build with my current skillset I get obsessively curious about the stack. I'm in my infancy stages of learning React, cool to see it used here. Interesting that you use Python with Django for a backend but pair it with Node. It makes sense given your use case - I just don't know if I would've thought of that! I have extremely limited backend experience, though, so I didn't really even know this was a thing. I'm still learning what people use Node for other than just with Express as a web framework. You gave me some good Google material :D
And our stack is Python with Django, Postgres, React and SASS for the client with Node 8 and Babel for handling the JavaScript so I can code in ES201x. We use Cloudfront to host our static assets and images which are gzipped and cached globally for performance.
Speaking of site updates, is the view who quoted you feature temporarily disabled?
By reilo Go To PostTo clarify, I use node to build the front end, nothing with the backend.I got what ya mean... I guess I just hadn't considered that you don't actually need to be running an Express server for Node to still be useful. By "with your use case" I meant to use Babel for compiling new JS into browser compatible JS. I suck at using terms appropriately.
I've got 2 questions I wonder if anyone can help me with:
1. How do I search for a specific thread?
2. Does Zelda BOTW have an official thread here?
1. How do I search for a specific thread?
2. Does Zelda BOTW have an official thread here?
Yea exactly. Technically we have a third dependency on Ruby (😒) to compile SASS but I can get rid of that once I re-write our SASS stack to be compatible with node-sass and autoprefixer.
By Watershed Go To PostI've got 2 questions I wonder if anyone can help me with:Coming in a major update maybe this weekend.
1. How do I search for a specific thread?
By Watershed Go To Post2. Does Zelda BOTW have an official thread here?https://slaent.com/thread/1023937/
Any plans for building in React Native once all web features are your list are built? Not that it really needs it at all, the mobile site looks and works great.
Guess I'm just curious because I don't know of any other forums using React for the front end, so seems like a unique position you guys are in. I have absolutely no experience with React Native so not sure how involved porting a React project actually is.
Guess I'm just curious because I don't know of any other forums using React for the front end, so seems like a unique position you guys are in. I have absolutely no experience with React Native so not sure how involved porting a React project actually is.
React Native? Doubtful. Probably will do PWA though for those kind of improvements. There just isn't enough to warrant a dedicated mobile app.
Is there a way to set up a Slaent bot Twitter account that posts all new threads from here? That's the way I usually catch up on forums to make sure I don't miss any topics I care about.
By Falchion Go To PostIs there a way to set up a Slaent bot Twitter account that posts all new threads on here? That the way I usually catch up on forums to make sure I don't miss any topics I care about.Yea, we can! I'll look into what it'll take, not sure when I'll get to it though. Tbh, the grunt work of that code where it posts to Twitter could be written by someone else, I'd just need to implement it on thread creation on my end by passing in a URL to thread and a title for the body.
Had a question about page counts, if the next post would go on page 2 or whatever, does the forum show the thread as already having that many pages? There has been a couple threads I went to the last page in, but it ended up being the page before the last page with no button to go to the next page. Currently the Fire Emblem Warriors thread is displaying 2 pages, with only 1 page available to me.
Hope that makes sense and thanks!
Hope that makes sense and thanks!
By reilo Go To PostYea, we can! I'll look into what it'll take, not sure when I'll get to it though. Tbh, the grunt work of that code where it posts to Twitter could be written by someone else, I'd just need to implement it on thread creation on my end by passing in a URL to thread and a title for the body.
That's awesome! I have no clue how to code something like that but I'd definitely use the shit out of that.
I think I saw someone ask this somewhere and now I can't find it but is there a way to follow threads?
By angelgrievous Go To PostI think I saw someone ask this somewhere and now I can't find it but is there a way to follow threads?
Also can’t figure this out. I’m almost exclusively a mobile user on iOS/Safari.
By angelgrievous Go To PostI think I saw someone ask this somewhere and now I can't find it but is there a way to follow threads?
By Brakke Go To PostAlso can’t figure this out. I’m almost exclusively a mobile user on iOS/Safari.Not atm. But Reilo is working on it.
By reilo Go To PostThere’s ways to handle that without posts counts. We don’t care about user post counts as status symbols but really it’s because counts are super fucking slow from the database. There’ll be updates in the future to help with the UX of new threads.
Now, I'm not going pretend I know what's under the hood aside from the stack you posted, but why not just keep track of thread post counts as posts are made? Just have a counter that increments. I believe that's how most data structures handle counts/lengths as they're usually O(1) complexity.
It'd be the kind of thing you'd need to run some DB script to populate now for existing threads, but probably better earlier than later when there are way more threads. Just my (unprompted) 2 cents :D
That's one way of handling it but we'd have to change a bit of the structure about it. It would require a whole new table as the concept of what a thread isn't traditionally defined under a hood. It's far more agnostic.
To put it confusingly... a forum is a post, a thread is a post.
To put it confusingly... a forum is a post, a thread is a post.
Y'all are doing an outstanding job with this site. I love it and have been having fun just browsing around for a couple days now taking in the UI along with enjoying the community. I particularly love the ease of switching between edit and preview when typing comments. So many forward-thinking implementations here.
Any suggestions I could have atm have been beaten to death already so I'm gonna wait until the stated features are rolled out and try to bring some fresh ideas up.
Mostly wanted to give a recommendation to @Dodongo who posted a few pages back. He's been a good friend of mine for over a decade and we lived together for a few years. When you're ready to let others help with dev here he is definitely someone to trust with it.
Wanted to also echo the sentiment that I'd be more than happy to pitch in a few bucks regularly through a Patreon or something if you decide to go that route. I don't make much but this is the kind of web design and community that deserves my support.
Oh, and I'd like to formally request that I be given a tag by the mods a la GAF if possible. Not now of course, but when I show my ass enough to deserve one. I know I can give myself one but it just doesn't feel right. Promise I won't fish for one. ❤
Any suggestions I could have atm have been beaten to death already so I'm gonna wait until the stated features are rolled out and try to bring some fresh ideas up.
Mostly wanted to give a recommendation to @Dodongo who posted a few pages back. He's been a good friend of mine for over a decade and we lived together for a few years. When you're ready to let others help with dev here he is definitely someone to trust with it.
Wanted to also echo the sentiment that I'd be more than happy to pitch in a few bucks regularly through a Patreon or something if you decide to go that route. I don't make much but this is the kind of web design and community that deserves my support.
Oh, and I'd like to formally request that I be given a tag by the mods a la GAF if possible. Not now of course, but when I show my ass enough to deserve one. I know I can give myself one but it just doesn't feel right. Promise I won't fish for one. ❤
Thanks for the sentiment and appreciate the offer to donate! It means a lot, it truly does. Hopefully in the future we can secure some partnerships where both the site and the user benefits, because let's be honest: nobody likes ugly banners.
Also, we have sub forums! We just launched the Gaming, Film, and Music sub-forums. Our mods are at work tagging threads already in those categories.
The neat thing? If you make a thread in Gaming or Film or Music, that thread will also show up in Entertainment.
Please don't mind the UI... it's a bit last minute right now but I will tweak the area on the homepage and in the navigation to better implement that section. Let me know if you have any questions!
The neat thing? If you make a thread in Gaming or Film or Music, that thread will also show up in Entertainment.
Please don't mind the UI... it's a bit last minute right now but I will tweak the area on the homepage and in the navigation to better implement that section. Let me know if you have any questions!
By reilo Go To PostAlso, we have sub forums! We just launched the Gaming, Film, and Music sub-forums. Our mods are at work tagging threads already in those categories.
The neat thing? If you make a thread in Gaming or Film or Music, that thread will also show up in Entertainment.
Please don't mind the UI… it's a bit last minute right now but I will tweak the area on the homepage and in the navigation to better implement that section. Let me know if you have any questions!
Nice work reilo
Okay so now that I'm thinking of it, one idea that I keep coming back to in my head is some kind of simple ability to "like" posts. I don't personally care about it in a reputation context and if there's a worry it'd end up being used in that way I understand avoiding it. I just personally like being able to show my appreciation for specific comments without muddying up a thread responding to them.
Thanks again!
EDIT: SUB FORUMS ALREADY THAT'S WHAT I WAS WAITING FOR ZOMG
Thanks again!
EDIT: SUB FORUMS ALREADY THAT'S WHAT I WAS WAITING FOR ZOMG
You can only reach the subforums from the first page right? On mobile at least?
Great job guys, the forum was awesome and now it's getting awesome...er?
Great job guys, the forum was awesome and now it's getting awesome...er?
By reilo Go To PostIt's also in the menu now!Holy shit it is! And it looks great! Bravo brate
I don't love the UI around it but I'm tired and need to think on it to be more dynamic for the future. Anyway, happy browsing.
By reilo Go To PostAlso, we have sub forums! We just launched the Gaming, Film, and Music sub-forums. Our mods are at work tagging threads already in those categories.Wow great stuff reilo man. So quick, hope you are getting rest/sleep.
The neat thing? If you make a thread in Gaming or Film or Music, that thread will also show up in Entertainment.
Please don't mind the UI… it's a bit last minute right now but I will tweak the area on the homepage and in the navigation to better implement that section. Let me know if you have any questions!
FootballSlaent will keep things civil around here in the meantime
By reilo Go To PostI don't love the UI around it but I'm tired and need to think on it to be more dynamic for the future. Anyway, happy browsing.You could remove the "Videogames, Movies, Music" subheading under &Entertainment maybe but then the orher subheadings look weird maybe. It works and looks great as it is IMO.
Thanks for your hard work.
By reilo Go To PostAlso, we have sub forums! We just launched the Gaming, Film, and Music sub-forums. Our mods are at work tagging threads already in those categories.
The neat thing? If you make a thread in Gaming or Film or Music, that thread will also show up in Entertainment.
Please don't mind the UI… it's a bit last minute right now but I will tweak the area on the homepage and in the navigation to better implement that section. Let me know if you have any questions!
You are a fucking BEAST!! I'm throwing money at my screen but nothing's happening!
EDIT:
UI looks fine to me *shrugs*
By rossonero Go To PostYou could remove the "Videogames, Movies, Music" subheading under &Entertainment maybe but then the orher subheadings look weird maybe. It works and looks great as it is IMO.I thought of that but felt it would get lost. Too subtle.
Thanks for your hard work.
By blackace Go To PostWe just introduced 3 sub-forums for now but that might grow as we doI REALLY like that if you are into just music and gaming, you just go to those sections, but if you're into all 3 you can just go to Entertainment.
Now all we need is to make Suen mod, and slaent is complete
By FootbalIFan Go To PostI REALLY like that if you are into just music and gaming, you just go to those sections, but if you're into all 3 you can just go to Entertainment.You can thank Sharp for implementing the tagging system for this exact reason.
Now all we need is to make Suen mod, and slaent is complete
Now how about this idea of a Community-specific tag... say a "Football Community" with all of the Footy threads that also show up in Sports ;) 2018
By reilo Go To PostYou can thank Sharp for implementing the tagging system for this exact reason.
Now how about this idea of a Community-specific tag… say a "Football Community" with all of the Footy threads that also show up in Sports ;) 2018
That sounds ace.
Oh, and thanks, Sharp!
By reilo Go To PostYou can thank Sharp for implementing the tagging system for this exact reason.:o
Now how about this idea of a Community-specific tag… say a "Football Community" with all of the Footy threads that also show up in Sports ;) 2018
Imo its important to make a thread titled "How to Slaent" for the future
Show people how to send pm's, how to edit posts, how to embed tweets, insta etc, how to change to dark theme, link to those purplemug thread template things, who the mods are, link to the support thread for suggestions, general rules, ability to edit thread title and so on
Just all very common questions i see. I still see some people posting screenshots of tweets for example.
I believe one of our mods is going to work on that. We need definitely need that, maybe even make it a page in the footer.
I was worried that having three additional sections would fragment everything too much but it seems to work more like tags so you can find specific subjects. Neat.
I think that the three additional buttons when you bring up the drop down menu would fit in better if they were directly under the Entertainment section.
Good stuff, Reilo! 👍
I think that the three additional buttons when you bring up the drop down menu would fit in better if they were directly under the Entertainment section.
Good stuff, Reilo! 👍
By Falchion Go To PostThat's awesome! I have no clue how to code something like that but I'd definitely use the shit out of that.
I think this is a really good idea. Would greatly increase overall user interaction.