recent bookmarks

postgresql - What is an efficient way to do pattern match in MySQL? - Stack Overflow
REGEXP or its alternative spelling RLIKE:

WHERE value NOT RLIKE 'text|text2|text3|text4|text5'
(a regexp match is not anchored to the ends of the string unless you explicitly use ^ and $, so you don't need the .*(...).*.)

You should test it to see whether it is actually faster than the version with LIKE. On my test database with four words to find, LIKE was still considerably faster. It also has the advantage of being ANSI standard SQL so you can use it on any database.

If this is a common query, you should also consider fulltext indexing.
postgres  postgresql  regexp  rlike  not  anchored 
10 days ago by theskett
Twitter
You can sort of hack in arbitrary LIKE support at the cost of *lots* of blind indexes, but that's not a f…
from twitter
10 days ago by ciphpercoder
(429) https://twitter.com/i/web/status/1067908830854402049
RT : Cult members booted out of teen sexual health conference by NSW Health Minister. I put questions in yesterday, by e…
from twitter
10 days ago by kcarruthers
Twitter
Yup, the problem is the perceived risk of the live-ness.…
from twitter_favs
10 days ago by charisse
(429) https://twitter.com/i/web/status/1067924979071643648
RT : The interesting thing about this story is that NSW government officials were warned about these EXACT same people m…
from twitter
10 days ago by kcarruthers
Twitter
We’re even seeing a lot of orgs wanting to do Public Bet…
from twitter_favs
10 days ago by charisse
Twitter
WTFUCKING SWEET HELL IS THIS??? This isn’t Monday dec 3 right? Cause I have to work after and I C…
from twitter_favs
10 days ago by kbachelder
Twitter
Dems grabbed control of Maine's government, flipping the governorship and the state Senate on top of big gains in t…
from twitter_favs
10 days ago by snugthejoiner
Twitter
Since Letterform Archive opened its doors in 2015, our mission has been to inspire designers — and the designer in…
from twitter_favs
10 days ago by ebv
(429) https://twitter.com/i/web/status/1068185343873245191
RT : Edit: spoken by deep base narrator's voice.
"Watergate, but the crimes are way bigger and the parti…
from twitter
10 days ago by Jason89
www.washingtonpost.com
via Washington Post: Breaking News, World, US, DC News & Analysis https://wapo.st/2FHX347
NEWS 
10 days ago by aebraddy
Twitter
"Have some fucking weeds, antler rats."
from twitter_favs
10 days ago by brundlefly
(429) https://twitter.com/johnsy123aus/status/1068104224909611008
Let’s face it. The Liberals have been two parties living somewhat uncomfortably in the same tent ⛺️ for ages.
from twitter
10 days ago by kcarruthers
Twitter
It will totally be worth it when you are ready!
from twitter_favs
10 days ago by hecavanagh
(429) https://twitter.com/i/web/status/1068237296019812352
Breath of the Wild replay thoughts: fucking amazing game but they should have cut down on some of the animation/cut…
from twitter_favs
10 days ago by tjweir
Twitter
Grateful for the opportunity to meet and be interviewed by the amazing at .…
maltablockchainsummit  from twitter_favs
10 days ago by davidorban
Twitter
Yes most society journals have been contracted out to, or are outright owned by, big publishers. W…
from twitter
10 days ago by ceptional
Twitter
You know what would be neat? String destructuring, using ES6-style template strings but in reverse.

const `${hours…
from twitter_favs
10 days ago by briantrice
Talk Python to Me
THE python interview podcast
podcast  python 
10 days ago by Jmango
Untitled (https://www.youtube.com/watch?v=I8BRdwgPChQ&feature=youtu.be)
Lesson from History: Transgender Mania is Sign of Cultural Collapse - Camille Paglia
from twitter_favs
10 days ago by davidgusmao
Twitter
RT : For the young folks: It's not normal for the President of the United States to personally owe hundreds of millions…
from twitter
10 days ago by jrosenau
Step-by-Step illustration process with Terry Edward Elkins | Dribbble Design Blog
Terry Edward Elkins is a designer and illustrator based out of Alberta, Canada. His work is mainly inspired by nature and the beautiful landscapes of Western Canada. via Pocket
IFTTT  Pocket 
10 days ago by cijanzen
Guys Can Sew - YouTube
This channel #GuysCanSew is dedicated to sewing and embroidering.
youtube  video  sewing 
10 days ago by cyberchucktx
Twitter
Fight for the planet, fight for our lives.

Let’s do this 🌎
from twitter_favs
10 days ago by alan.calvert
Twitter
Fight for the planet, fight for our lives.

Let’s do this 🌎
from twitter_favs
10 days ago by nelag
Twitter
President Trump (@POTUS)
RT @WhiteHouse: "We need to support people who are addicted and to get rid of stigma that comes with opioid addiction." “The chances of yo…
US  TOP  Twitter 
10 days ago by AlexanderERyzhov
Twitter
Senator John Cornyn (@JohnCornyn)
RT @StraussCenter: TOMORROW: We're honored to co-host #TxNSF 2018 with @UTIntel & @ClementsCenter at @UTAustin, feat. an array of experts i…
US  Senators  Twitter 
10 days ago by AlexanderERyzhov
Twitter
Senator John Cornyn (@JohnCornyn)
Cartels don’t care who or what they’re trafficking. They’re exploiting gaps in our immigration system and preying on the weak—all to get rich. We must stop looking at these problems through a soda straw and work together on a comprehensive immigration solution. https://t.co/UzczyXFxVl
US  Senators  Twitter 
10 days ago by AlexanderERyzhov
Twitter
This is flipping *fascinating.*
from twitter_favs
10 days ago by joostvanderborg
Twitter
This is flipping *fascinating.*
from twitter_favs
10 days ago by drunkengrass
Twitter
This is flipping *fascinating.*
from twitter_favs
10 days ago by ninthart
Twitter
Yeah, my issue is that *that’s* the thing that feels like a target for legislation, but I get that a…
from twitter
10 days ago by alexhern
Twitter
Well done to , another one of our Twenty in Data and Technology awardees. Maxine is currently a PhD stud…
from twitter_favs
10 days ago by jasonclark
Untitled (https://www.mcsweeneys.net/articles/matreon-the-patreon-platform-for-emotional-labor)
So much this...Matreon: The Patreon Platform for Emotional Labor - McSweeney’s Internet Tendency
from twitter_favs
10 days ago by ali.alkhatib
Twitter
MLS' Media Policy is clear as day when it comes to giving access to writers before and after games and for relevant…
from twitter_favs
10 days ago by sd
Software Engineering daily
podcast about planning, designing, building and maintaining software and infrastructure
podcast  dev 
10 days ago by Jmango
security - Store sensitive information inside keepass database from c# - Stack Overflow
I thought about reading a KeyPass 2 database so I added a reference to KeyPass.exe in Linqpad and started to experiment. To my surprise and without any outside help (a testament to a good API), I was reading the database after only a few minutes.
dotnet  csharp  security 
10 days ago by andyhuey
Twitter
I support Palestinian freedom. I support Palestinian self-determination. I am deeply critical of Israeli policy and…
from twitter_favs
10 days ago by shawnfuryan
Twitter
I support Palestinian freedom. I support Palestinian self-determination. I am deeply critical of Israeli policy and…
from twitter_favs
10 days ago by transposition
Twitter
I support Palestinian freedom. I support Palestinian self-determination. I am deeply critical of Israeli policy and…
from twitter_favs
10 days ago by MattBinder
Twitter
I support Palestinian freedom. I support Palestinian self-determination. I am deeply critical of Israeli policy and…
from twitter_favs
10 days ago by mattgriffin
« earlier      later »

Copy this bookmark:



description:


tags:



Copy this bookmark:



description:


tags: