Charcoal HQ

11:01 AM

[ SmokeDetector | MS ] Few unique characters in answer: How to loop through data in WebForms like in MVC by sadasdasda on stackoverflow.com

CalvT븃

Think it's just CE - metasmoke uses oauth

SmokeDetector

[ SmokeDetector | MS ] Potentially bad keyword in body: Why Learn German Language? by Ram Patil on mathoverflow.net

tpu- by CalvT븃

[ SmokeDetector | MS ] Bad keyword in username: Using NFC in Android by puria hadinejad on stackoverflow.com

fp- by J F

Ferrybig

@Henders That's the part of ads I don't understand, it makes me less likely to buy something, since I already decided I don't want to interact with that website anymore

SmokeDetector

[ SmokeDetector | MS ] URL in title, bad NS for domain in body, bad NS for domain in title, bad keyword in body, bad keyword in title, +5 more: healthonlinereviews.com/test-troxin/ by kanewiluaum on meta.SE

tpu- by Ferrybig

A J

@SmokeDetector why did you post it?

SmokeDetector

11:15 AM

@AJ Username - Position 1-6: puria

A J

@SmokeDetector why is that a bad keyword?

SmokeDetector

@AJ That's not a report.

A J

@SmokeDetector why?

SmokeDetector

@AJ That's not a report.

Ferrybig

Smokey has only limited artificial intelligence

A J

11:16 AM

@SmokeDetector Hey! Don't tell "that's not a report" me whenever I ask why.

CalvT븃

@AJ just do a search on metasmoke and you'll understand why

SmokeDetector

[ SmokeDetector | MS ] Bad NS for domain in body, bad keyword in body, blacklisted website in body, link at end of body, pattern-matching website in body: And additionally friends in delaying by Comfor dery on drupal.SE

tpu- by J F

Ferrybig

@SmokeDetector fpu-

SmokeDetector

[ SmokeDetector | MS ] Blacklisted website in answer, blacklisted user: Recommended distribution for my laptop (problems with Ubuntu on HP Probook 655 G1) by media player on askubuntu.com

A J

@CalvT븃 ok. puria serum

SmokeDetector

11:18 AM

tpu- by A J

Henders

@Ferrybig Brand recognition though - If I do decide in the future to go climbing, I'll probably visit go ape first because I know the name. (And I hear the employees in some of their branches help to fight spam here so... )

Ferrybig

@AJ Its a bad keyword because spammers usually include it in post bodies

SmokeDetector

[ SmokeDetector | MS ] Few unique characters in body, repeating words in body: Using a struct to hold and display PPM images in C by Bobby Mitchell on stackoverflow.com

New metasmoke user 'Kasper Franz' created

tp- by J F

Glorfindel

@SmokeDetector v

A J

still alive

Translation maybe bad, but it is obvious R/A

and username is kinda "cat on the keyboard"

thanks whoever listened to me. :P

resists the urge to use blame command :P

Glorfindel

11:26 AM

!!/blame

SmokeDetector

@Glorfindel It's angussidney's fault.

A J

lol

SmokeDetector

[ SmokeDetector | MS ] Bad keyword with email in answer, potentially bad keyword in answer: Is net-positive fusion power generation impossible on Earth? by Maksim Yaroslav on physics.SE

tpu- by A J

A J

@SmokeDetector phone number in that post can work in India as well. I just don't know who will pick it up.

SmokeDetector

[ SmokeDetector | MS ] URL in title, bad NS for domain in body, bad NS for domain in title, bad keyword in body, bad keyword in title, +5 more: supplement4help.com/nitridex/ by user279164 on apple.SE

tpu- by Glorfindel

tripleee

11:30 AM

@AJ hmmm what? that's a Russian phone number

it should work from everywhere as long as you know how to call international

that's what the + is for

!!/blacklist-keyword (?:7\W*)?926\W*503\W*65\W*51

SmokeDetector

@tripleee Blacklisted (?:7\W*)?926\W*503\W*65\W*51

tripleee

it's actually at 6/6 already, dunno why I didn't notice yesterday

SmokeDetector

CI on 7a8aa93 succeeded. Message contains 'autopull', pulling...

[ SmokeDetector ] SmokeDetector started at rev 7a8aa93 (SmokeDetector: Auto blacklist of (?:7\W)?926\W*503\W*65\W*51 by tripleee --autopull*) (running on teward/Solar Flare)

Restart: API quota is 16723.

[ SmokeDetector | MS ] URL in title, bad NS for domain in body, bad NS for domain in title, bad keyword in body, bad keyword in title, +4 more: supplement4help.com/nitridex/ by wbbubjfqp on apple.SE

tpu- by J F

J F

@SmokeDetector I’m pretty sure the goal of fusion is to avoid burning petroleum.

Glorfindel

@doppelgreener ~~Still alive: unix.stackexchange.com/a/428980/111051~~ thanks

doppelgreener

11:40 AM

@Glorfindel 💥

Glorfindel

I wonder what's going to appear in the lower right corner ...

doppelgreener

@Glorfindel a grue

Mithrandir

Funny, I didn't notice any flags

JAD

@Glorfindel one more to go and you have bingo :D

Suraj Rao

@Glorfindel I now the blue one.. what are the others?

A J

11:45 AM

@tripleee Well, if you use +91, someone named Sangi will pick up in India.

SmokeDetector

[ SmokeDetector | MS ] URL-only title, bad keyword in body, bad keyword in title, bad keyword in username, blacklisted website in body, +3 more: healthcares.com.au/tryvix-cream/ by Tryvix on askubuntu.com

Glorfindel

@SurajRao red = reply (you're getting one now)

SmokeDetector

tpu- by Glorfindel

Glorfindel

orange = mod chat flag

Suraj Rao

ohk..

John Dvorak

11:46 AM

Lower right could be a whisper from a friend

when SE finally acknowledges that friendship exists

Henders

11

A J

@Glorfindel what's the third one below left?

@Henders lol

Glorfindel

1 min ago, by Glorfindel

orange = mod chat flag

SmokeDetector

[ SmokeDetector | MS ] Bad keyword in answer, bad keyword in username, bad keyword with email in answer, email in answer: Can there be a space age without petroleum (crude oil)? by NefteGaz Agent on worldbuilding.SE

tpu- by CalvT븃

A J

@Henders This much @Glorfindel is loved here, right? ;)

7 stars.

9 now.

SmokeDetector

11:59 AM

[ SmokeDetector | MS ] URL-only title, bad NS for domain in body, bad NS for domain in title, bad keyword in body, bad keyword in title, +6 more: www.nutritionfit.org/alpha-force-testo/ by Senew1968 on askubuntu.com

tpu- by Henders

CalvT븃

12:14 PM

That's not a bad reason weight

Eric Leschinski

Angry noises about the Audit Queue! Decent gramatically correct useful relevant and secondary education level academic answers from very high reputation users are supposed to be deleted.

Glorfindel

... wrong room? I don't see how this is related to Charcoal, but I could be missing something.

Magisch

@EricLeschinski o_O?

Mithrandir

wat

CalvT븃

Hey @Mithrandir thanks btw for your edits to the auto comments - I was the one that pieced them together from SOCVR's so feel a bit responsible for them - what you did is something I should have done in the first place

Mithrandir

12:25 PM

np

Eric Leschinski

This audit answer is supposed to be deleted: stackoverflow.com/review/low-quality-posts/19044580 It looks a lot worse from this link, because it has downvotes and the latex equation is raw. But in the audit it looks a lot better.

I guess the point is that you can't just base audits on quality, you have to research backstory.

Suraj Rao

@EricLeschinski well the sole link in the answer is same as user name.. It seems to be deleted as spam

Glorfindel

ah, missed that.

Suraj Rao

by a Mod

SmokeDetector

[ SmokeDetector | MS ] Misleading link: How to solve Microsoft Office error 1402 on Windows 7? by Charles F Radley on superuser.com

fp- by Floern

New metasmoke user 'Lyrion' created

WELZ

12:44 PM

2

Tschallacka

Heh funny, there is the post by @ArtOfCode on the meta and below it the post by tim post about benevolent bots. Gives the impression of people talking but not listening to eachother heh.

Tinkeringbell

@WELZ Yours is better, just because the circle has the right size :D

WELZ

Charcoal Approved!

JAD

1:00 PM

@WELZ oh god the pixels

And that's a GD user... ;)

WELZ

@JAD Well that "GD User" got a shitty quality pic, what did you expect!

John Dvorak

@WELZ just scan the sticker

WELZ

User ≠ Designer...

JAD

@WELZ I don't believe you

WELZ

@JohnDvorak The sticker I never got...

Also he's not complaining about the logo, the blurry image with the rainbow circle.

3 hours to teams.

Glorfindel

1:05 PM

@WELZ here is the original resolution.

Suraj Rao

#photoshopbattle

Mithrandir

@Chris_Rands In a sense, sort of. You'll still be on Stack Overflow, you'll still see the public Q&A, you'll just also see the private team stuff and additional navigation options. So from the UX point of view, you're still on SO, it's just that private content is very clearly differentiated. Now, if your organization favored lots of subjective questions, then you would sort of feel like you were on another site. I think it depends on perspective. SO For Teams is designed for teams too small for a whole private instance, so sort of like a site .. no single good answer here :) — Tim Post ♦ 1 min ago

Henders

@Tinkeringbell To be fair, I did it in about 30 seconds :P

SmokeDetector

[ SmokeDetector | MS ] Bad NS for domain in body, bad keyword in body, blacklisted website in body, link at end of body, pattern-matching website in body: Using them longer than ought to can by Uplas fordery on drupal.SE

Henders

And photoshop crashed before I could save it so I screenshotted before it restarted :P

SmokeDetector

1:10 PM

tpu- by Glorfindel

Federico

what is this channel thing?

Mithrandir

303

Q: Introducing: Channels - Q&A For Engineering Teams

When you use Stack Overflow to solve some of your problems, you begin wanting to use it for everything. We've often said that Stack Overflow isn't a place for everything that programmers want to do and talk about, but we've always wished that we could make it easier for teams of engineers to bet...

Federico

ty!

WELZ

2

Mithrandir

and then other questions tagged [channels] are a useful read

WELZ

1:12 PM

there ya go

Mithrandir

also

Dec 7 '17 at 13:04, by ArtOfCode

TL;DR: We get alpha access. We own our content; SE owns Channels; we license our content to SE to use within Channels. Any feedback (including usage data) we give or generate is not confidential and our ownership of it gets assigned to SE; SE has to ask if they want to use our logos or text feedback in public materials. Don't be a dick or our access gets revoked. No warranty; no liability; backup your data.

Suraj Rao

@WELZ cant pin that in the sidebar can we?

Henders

I think there's enough pins there at the moment :P I've never seen so many!

Mithrandir

@SurajRao too many pinz already

WELZ

@SurajRao a RO or mod has to, but it'll only show a link, not the image.

[tempted to make his eyes like that 4th circle o.o]

ArtOfCode

1:18 PM

@Mithrandir that... was a remarkably accurate summary of the terms

SmokeDetector

New metasmoke user 'Alexandru Severin' created

Ferrybig

@Henders That would be a good idea for a new tag of the room [tag:too-many-pins], but that would piuhs the starboard even down more

A J

!!/blame

SmokeDetector

@AJ It's Ferrybig's fault.

Mithrandir

@Ferrybig how I solve the issue: github.com/HodofHod/SE-Modifications/raw/master/…

Glorfindel

1:22 PM

yesterday, by Glorfindel

[too-many-tags]

SmokeDetector

[ SmokeDetector | MS ] URL-only title, bad NS for domain in body, bad NS for domain in title, bad keyword in body, bad keyword in title, +6 more: supplement4help.com/nitridex/ by inclusivep on askubuntu.com

tpu- by Glorfindel

ArtOfCode

I solve it by contracting the avatars to 16x16

expandable on hover

Henders

@Ferrybig Ha! RO away :P

Suraj Rao

chat.stackoverflow.com/transcript/message/41544976#41544976 @Magisch thoughts? relevant link chat.stackoverflow.com/transcript/message/41545707#41545707

Tinkeringbell

@Henders You should have took another 10 then, to make the circle the right size XD (Honestly, that's fast.)

SmokeDetector

1:26 PM

New metasmoke user 'samdd' created

Henders

@Tinkeringbell Bah, can't get anything right, can I? :P

Tinkeringbell

@Henders I'm just a difficult person XD

Henders

Best type of person to be :P

ArtOfCode

I'm gonna trim banana-for-monkey and corn-for-horse down to just one of the two so that the tags fit on two lines still

room topic changed to Charcoal HQ: Where diamonds are made, smoke is detected, and we break things by developing on production. 87,500 true positives and counting. Handy links: charcoal-se.org, github.com/Charcoal-SE, charcoal-se.org/blaze, metasmoke.erwaysoftware.com [best-bad-practices] [corn-for-horse] [crazed-maniacs] [dev-on-prod] [everything-is-broken] [panic-driven-development] [plastic-knives] [programmatic-crowbars] [roadkill-pasta]

SmokeDetector

New metasmoke user 'TomDoesCode' created

ArtOfCode

1:31 PM

who's Tom

Federico

@ArtOfCode ahem

what kind of monster screen do you have?

ArtOfCode

1920x1080

Federico

me too :|

WELZ

@ArtOfCode it's 3 lines here as well cc: @Federico

Mithrandir

it's 5 here

ArtOfCode

1:37 PM

someone needs to get off their phone :P

Mithrandir

@ArtOfCode nope, laptop

ArtOfCode

WELZ

So... I just spanned the chat across both of my screens... it's pretty cool

SmokeDetector

[ SmokeDetector | MS ] URL in title, bad keyword in body, bad keyword in title, pattern-matching website in body, pattern-matching website in title, +1 more: MORE INFO @>> supplement4fitness.com/illuminosity-cream/ by niryllen on apple.SE

tpu- by WELZ

JAD

pls

WELZ

1:38 PM

would work better if I didn't have these HUGE bevels and borders on the end

Mithrandir

(wow, I can tell that I have like 5 scripts just from that sidebar alone)

WELZ

@ArtOfCode what's the (6) near the # of participants?

ArtOfCode

heh, that's not a number of participants

WELZ

oh lol

It just was around the number....

Glorfindel

@WELZ # of people kicked out of the room by Art ...

WELZ

1:42 PM

7

Q: Add in current number of participants in a chat room

On Mobile Chat there's this nice little tab that shows the number of participants currently in the room: Would be nice to get have something like that for web that said: "40 Users" (and it can be linked to the Currently in room page).

feature-request chat

Old FR that they ignored -_-

ArtOfCode

I count 32 current participants

definitely not 46

Glorfindel

@WELZ chat gets very little dev time

WELZ

well this room regularly has 35-45, so it "made sense"

I didn't actually count

ArtOfCode

Yup, just an incorrect assumption this time :)

WELZ

Maybe all y'all'll make a user script

I made an ass (out of) u (and) me

ArtOfCode

1:43 PM

*y'all'll

If you want to use correct Southern grammar, it'd be "all y'all'll"

because Southern grammar totally makes sense

WELZ

Lol, fixed

JAD

@ArtOfCode I like it

SmokeDetector

2:02 PM

[ SmokeDetector | MS ] Bad keyword with a link in answer: Spring ScheduledTask - start/stop support? by Alexandre Pinho on stackoverflow.com

naa- by Tinkeringbell

terdon

@ArtOfCode Southern Llamedos?

Magisch

@SurajRao looks like obvious vote-ringing

Suraj Rao

yeah mod took care of it after my ping

SmokeDetector

[ SmokeDetector | MS ] Pattern-matching website in body: jQuery selector - inserting value only to selected id by David on stackoverflow.com

Magisch

People are so transparent with serial voting

SmokeDetector

2:14 PM

fp- by CalvT븃

Magisch

I should run my serial voting script on AU & Superuser sometime

Glorfindel

@Magisch they are, because they see they're not getting caught (soon/often enough)

@Magisch new AU & SU elections incoming

Suraj Rao

whats the rep criteria there? not 3k?

Cerbrus

@Magisch That sounds interesting

How does it work?

WELZ

@Magisch how does it work?

jinx

Mithrandir

2:16 PM

That... should probably remain a secret

CalvT븃

Think it's classified

Cerbrus

You don't think serial voters would come in here, do you?

CalvT븃

IIRC the mods have asked him not to share

Mithrandir

yup

Cerbrus

Oooh, very cloak & dagger

nice

Mithrandir

2:18 PM

@Cerbrus coughs when I first arrived one of the first things I came across was someone being kicked out for serial voting

Magisch

I have been asked by both mods and a CM not to share

Mithrandir

i.e. privs stripped

Magisch

And I like my account

WELZ

Serial voting being defined as....?

Mithrandir

@Magisch wise move

CalvT븃

2:19 PM

@WELZ Voting rings basically

Cerbrus

@Magisch Live a little, take a risk ;-)

Magisch

You can probably find it yourself

WELZ

@CalvT븃 I don't know what that means Lol :S

Mithrandir

@Magisch I... would not encourage that, though.

Magisch

I'm not

I'm arguably not really competent enough to interpret the results myself, and I wrote the thing

WELZ

2:20 PM

Like an arrangement between a few people to all vote on eachothers posts? Or do I have this all wrong? :/

CalvT븃

@WELZ a ring of people that up vote each others posts to get rep

Aye that

Magisch

Most of it is some people thinking they can ask their colleagues or make another account to just upvote all their posts and get them some sweet rep

the SE inherent script that reverses this is very conservative and misses a lot

WELZ

3.5 pages are this week alone

chat.stackexchange.com/…

CalvT븃

And now I'm deleting that to not give people ideas too much

Magisch

Because people see a list and start flagging like hell

which is annoying

CalvT븃

2:25 PM

Wonder if a display name change is worth it

I guess if the mods aren't that bothered

Mithrandir

@CalvT븃 You'd literally have to delete Magisch's account

and I doubt @mag would appreciate that

CalvT븃

@Mithrandir Couldn't you just change the username on data.se?

Mithrandir

I don't know, signing in to data.SE has actually never worked for me

CalvT븃

I can change mine, so would have thought it's one way to make discovery a bit harder

Then again, I guess that if you actually know mag has these tools, then you probably have some sense of responsibility

Cerbrus

Imagine what he could do if he were a moderator

You gonna run again, next time, @Magisch?

He'd be vicious :D

Mithrandir

2:42 PM

ALL YE SERIAL VOTERS TREMBLE

Tschallacka

hides around corner and whispers in a phone "they are on to us! abort!*

SmokeDetector

[ SmokeDetector | MS ] Pattern-matching website in answer: How can I take a picture with my built-in laptop camera with Windows 7? by Micheal Blu on superuser.com

tpu- by Glorfindel

Magisch

@Cerbrus I lost to both of the joke candidates

Tschallacka

You've had my vote everytime you've run

Undo

@Magisch Below about 5th, order stops mattering

Tschallacka

2:53 PM

so

we make a lot of accounts and all vote on magisch? i.imgur.com/Jq4EIPZ.gif

Magisch

I guess I can run again

I don't think I have good chances though

ArtOfCode

I'm probably not going to run in this one

Tschallacka

You will have my vote again :-)

Magisch

Some of the former mods hate me with a passion

Tschallacka

why is that?

Magisch

2:55 PM

Got into a spat with one former SO mod over a closed question a while ago

Mithrandir

@Magisch Work on perspective and knowing when to back down and you won't be horrible

</unsolicited advice>

Tschallacka

sometimes you have to agree to disagree. And do best not to let it get personal

cough

Mithrandir

burning people to the ground is usually not the best course of action

Tschallacka

but... but... that's how you get dragons

I saw it on that documentary game of thrones

Mithrandir

believe me, you don't want Smaug "Fire and Death" Terrible to show up

Smaug - I am Fire! I am death!

►

Tschallacka

2:58 PM

true true...

that might be bad

Magisch

Looking at ma sheet' it should be about 700 serial voting flags I've raised so far

give or take a couple

CalvT븃

And % helpful?

Magisch

all but 2 or 3

those were misclicks

CalvT븃

Nice

Glorfindel

@Tschallacka you need 150 rep to vote in an election.

Tschallacka

3:01 PM

So I bought licorice from jumbo which is sugar free. advice, don't eat as many as you would eat if they had sugar, otherwise you'll get intimate with your toilet for a while.
Bloody sweeteners

150 rep is easely gathered :P

SmokeDetector

[ SmokeDetector | MS ] Blacklisted website in body, link at end of body, link following arrow in body, pattern-matching website in body, repeated URL at end of long post: Disadvantages of Enhance Mind IQ by Shoothe 19 on drupal.SE

CalvT븃

300 on SO no?

SmokeDetector

tpu- by Glorfindel

[ SmokeDetector | MS ] Bad keyword in answer: Publishing in KDP direct from outside the US by Erhurhe Victor on writing.SE

tpu- by Glorfindel

Glorfindel

@CalvT븃 nope. 300 is usually the required level to nominate yourself (on SO, it's 3000).

+ some specific badges

for details, see meta.stackexchange.com/q/58587/295232

Tschallacka

Vote in moderator elections - - 150

Journeyman Geek

3:05 PM

there's specific prerequiste badges?

(I donno, I stood for election with a full set for mod scores;p)

Glorfindel

!!/report travel.stackexchange.com/a/110914/28333

SmokeDetector

[ SmokeDetector | MS ] Manually reported answer: Where is the Gare du Nord taxi station? by Taxi Gare du Nord on travel.SE

Glorfindel

@JourneymanGeek for SO, yes.

Journeyman Geek

ah

Andy

Civic Duty, Strunk & White, Deputy, Convention

Glorfindel

3:06 PM

stackoverflow.com/election/9

!!/watch taxi-net\.fr

SmokeDetector

@Glorfindel Added taxi-net\.fr to watchlist

CI on ae2625a succeeded. Message contains 'autopull', pulling...

Restart: API quota is 14431.

SmokeDetector

3:24 PM

New metasmoke user 'skwarerüt' created

CalvT븃

Has anyone hit the recapture shutdown on SEDE?

quartata

@Undo Do you think you could get data on the most common regex searches on Metasmoke?

Tschallacka

woops, wrong chat

SmokeDetector

[ SmokeDetector | MS ] Linked punctuation in answer: How to find the common denominator of an element of the web? by K. John on superuser.com

quartata

Or really, rather: do you log regex searches

SmokeDetector

3:29 PM

tpu- by Glorfindel

quartata

I suppose "most common" isn't exactly what I meant since what I care about is the multigram set and not the regex itself

K.Dᴀᴠɪs

smart keeping a watch for linked punctuation.

CalvT븃

For anyone wondering

26

Q: reCaptcha v1 is shutting down on March 31, but SEDE still uses it

According to this post, I thought the new recaptcha API was used network-wide. Though today, when going to SEDE (which for whatever reasons never recognized me automatically), I got this message instead of a usable captcha image. V1 Unsupported Please direct siteowner to g.co/recaptcha...

bug data-explorer captcha

Will be fixed this week apparently

Glorfindel

!!/watch proweb365\.com

SmokeDetector

@Glorfindel Added proweb365\.com to watchlist

[ SmokeDetector | MS ] Blacklisted user: Computer shuts down shortly after boot, but only once by K. John on superuser.com

CI on 542d8ec succeeded. Message contains 'autopull', pulling...

[ SmokeDetector ] SmokeDetector started at rev 542d8ec (SmokeDetector: Auto watch of proweb365\.com by Glorfindel --autopull) (running on teward/Solar Flare)

Restart: API quota is 14131.

[ SmokeDetector | MS ] Blacklisted user: How to find the common denominator of an element of the web? by K. John on superuser.com

Undo

3:35 PM

@quartata Probably not any data you'd want - logs are spotty, and would need to find a way to grep them out.

Glorfindel

@K.Dᴀᴠɪs the user has now edited the link out, you might want to retract your flag.

SmokeDetector

naa- by Glorfindel

CalvT븃

Plus the comment on the edit is "fix mistake"

SmokeDetector

Conflicting feedback across revisions: current, #1

Glorfindel

@SmokeDetector k

@SmokeDetector n

SmokeDetector

3:38 PM

Conflicting feedback across revisions: current, #1

Mithrandir

@CalvT븃 we all just have to keep pinging @TimStone about it

CalvT븃

Doom da doom doom doooom. I'll fix the code this week, so presuming someone can deploy things will magically work out — Tim Stone yesterday

ArtOfCode

@Undo grepping for regexes using regexes sounds like an excellent way to break things

quartata

indeed.

I found a paper on an indexing scheme for regex queries, but I doubt it'll be very useful since we don't really have a fixed set of regexes we search for

(it literally solves an optimization problem in that regard)

Tim Stone

@Mithrandir DOOOOOOOOOOOOOOM

quartata

3:45 PM

DÖÖM

Mad Scientist

@quartata trigram indexes can speed up regular expressions from what I read, and while they don't work for all kinds of regular expressions, they're not restricted to a fixed set

quartata

This is kind of similar. It's solving some integer programming setup for the smallest set of n-grams that cover the queries

ArtOfCode

Honestly I'd be more tempted to just stick a fulltext index on posts.body

takes a non-trivial amount of disk, but makes text search so much faster

terdon

@ArtOfCode Why? Just use grep -F

quartata

does fulltext help with regexp?

I thought it built a suffix tree or something right

terdon

3:52 PM

@quartata Yes, it makes grep interpret the search string as a simple string, not a regular expression.

quartata

That would be for normal LIKE

Squidge the Octopus

blub BLUB blub. blub.

Tweeted by octopussquidge on March 8, 2018 at 3:48 PM

quartata

@terdon ?

!!

spike is unhappy

terdon

@quartata Ah wait, I'm talking about Linux grep, not SQL LIKE

quartata

it's a sign

K.Dᴀᴠɪs

3:53 PM

@Glorfindel Thanks for the ping. But the question is now deleted (and flag helpful)

terdon

   -F, --fixed-strings
          Interpret PATTERN as a list of fixed strings (instead of regular
          expressions), separated by newlines,  any  of  which  is  to  be
          matched.

SmokeDetector

[ SmokeDetector | MS ] Bad keyword in title, blacklisted website in body, link at end of body, link following arrow in body, pattern-matching website in body, +1 more: Enhance Mind IQ : An Al-Natural Solution by Shoothe 19 on workplace.SE

tpu- by K.Dᴀᴠɪs

quartata

sd - k

Glorfindel

@K.Dᴀᴠɪs great.

quartata

@ArtOfCode are you timing these tweets to interrupt conversations

be honest

ArtOfCode

3:56 PM

@quartata look at the timestamp, that's like 6 minutes before the conversation :P

feeds are just slow