text:
Seven Guatemalans caught in Mexico had some elite training
Mexican authorities said Thursday that some of the seven Guatemalans caught here had received training from their country's elite "Kaibil" forces, but are still investigating whether the men had drug links.
Earlier, authorities had acknowledged the men had military backgrounds, but said they doubted they were Kaibiles, an elite Guatemalan paratrooper unit known for its grueling jungle-survival training.
Guatemala, meanwhile, identified three of the men as deserters from the Guatemalan army, and a fourth as a discharged former soldier, and that all had taken the course. The seven men face charges of weapons trafficking after being caught near the Guatemalan border on Sept. 10 with six large-caliber rifles and 1,600 rounds of ammunition.
According to Mexican press reports, U.S. intelligence officials had alerted police along the U.S.-Mexico border in August that former Kaibiles might be operating in that area. Mexican officials apparently fear the Guatemalan paratroopers might add their military expertise to that of the Zetas, a gang of drug smugglers and hit men led by deserters from an elite Mexican army unit. The Zetas have been waging turf wars in northern border towns such as Nuevo Laredo, against other groups for control of lucrative smuggling routes into the United States.


In Australia Visual Workplace and Lean are also referred to as Continuous Improvement, Six Sigma, World-class Manufacturing and TQM (Total Quality Management). These concepts were originally designed for use in manufacturing environments but are now more commonly being used across the entire workplace.
Visual communication tools prevent injuries and ensure staff and visitors are aware of possible dangers and protective equipment requirements for designated work areas. Placement of your visual tools should easily locate potential hazardous areas and alert people to proceed with caution.


text:
Q: Equally distribute a list in python Suppose I have the following list in python:
a = ['a','b','c','d','e','f','g','h','i','j']

How do I distribute the list like this:
['a','f']
['b','g']
['c','h']
['d','i']
['e','j']

And how do I achieve this if I have a list of unequal length and putting the 'superfluous' items into a separate list?
I want to be able to distribute the elements of the original list into n parts in the indicated manner.
So if n=3 that would be:
['a','d','g']
['b','e','h']
['c','f','i']

and the 'superfluous' element in a separate list
['j']

A: You can use zip with a list comprehension:
def distribute(seq):
    n = len(seq)//2  #Will work in both Python 2 and 3
    return [list(x) for x in zip(seq[:n], seq[n:])]

print distribute(['a','b','c','d','e','f','g','h','i','j'])
#[['a', 'f'], ['b', 'g'], ['c', 'h'], ['d', 'i'], ['e', 'j']]

A: Not exceedingly elegant, but here goes:
In [5]: a = ['a','b','c','d','e','f','g','h','i','j']

In [6]: [[a[i], a[len(a)//2+i]] for i in range(len(a)//2)]
Out[6]: [['a', 'f'], ['b', 'g'], ['c', 'h'], ['d', 'i'], ['e', 'j']]

If you're happy with a list of tuples, you could use zip():
In [7]: zip(a[:len(a)//2], a[len(a)//2:])
Out[7]: [('a', 'f'), ('b', 'g'), ('c', 'h'), ('d', 'i'), ('e', 'j')]

To convert this into a list of lists:
In [8]: map(list, zip(a[:len(a)//2], a[len(a)//2:]))
Out[8]: [['a', 'f'], ['b', 'g'], ['c', 'h'], ['d', 'i'], ['e', 'j']]

redpajama_set_name: RedPajamaStackExchange


text:
wordpress themes city park
Archive for the 'Anarchy/Anarchists' Category
Black Lives Matter follows in TakeAction Minnesota's footsteps
When Jason Lewis represented Minnesota's 2nd Congressional District, one of the DFL's lynch mobs, TakeAction Minnesota, aka TAM, visited Lewis's private home, which I wrote about here. This is what I wrote at the time:
These aren't frustrated people trying to contact a politician about an important issue. They're people who didn't think twice about intimidating young women in their own homes. That isn't acceptable. That's what playground bullies do.
TAM went onto Jason Lewis's private property without hesitation. As I wrote years earlier, Democrats are big into visiting people's private homes, then threatening and intimidating their targets' children with their tactics.
Fast forward to today. The Democrats' tactics haven't changed. The politicians change depending on who needs to be intimidated. This time, the intimidators of choice are Black Lives Matter and the politician receiving intimidation is State Sen. Warren Limmer. BLM criminals (they were videotaped trespassing on Sen. Limmer's private property) did their best to intimidate Sen. Limmer:
Black Lives Matter protesters show up at Republican Senator Warren Limmer's house in Minnesota demanding he address them. pic.twitter.com/VQJCn5bwDt
— Ian Miles Cheong (@stillgray) August 2, 2020
From Sen. Limmer's perspective:
"We were watching it on my Ring doorbell and … you get a different feeling when you see people slithering up to my front door, opening it and then pounding and yelling, demanding that I come out to greet the mob," Limmer said. "And it really isn't anything – that type of thing, no one in America should experience."
From BLM's perspective:
"You will come and talk to us, otherwise you will never run in (sic) office again," one man, who was shirtless and wearing what appeared to be a swim cap, yelled as he banged on Limmer's door. "You can't say that any more politely," he added as he walked away from the door.
A woman followed him with a more tactful approach: "We just want a little information here, that's all … You could come out and talk with us, you know. That's one of the easiest ways to deal with people that are protesting you, is to come talk with us."
Establishment Democrats insist that they're mostly moderates. I've called that a lie since 2010. BLM isn't moderate. Antifa is further left than BLM. Justice Democrats are further left than Antifa and BLM put together. What's interesting is that the 4 people in this video are white:
While these protests weren't nasty like other protests have been, it's still intimidating to have thugs show up at your private home. This isn't protected by the First Amendment because BLM was trespassing. Here's hoping Sen. Limmer forwards this video to law enforcement and presses charges against these criminals. Once the people start trespassing, there shouldn't be any mercy shown to the criminals.
Posted in Antifa, Black Lives Matter, Election 2020, Jason Lewis, TakeAction Minnesota | No Comments »
Indicting the Democrats
While much has been written about the Democrats' disastrous performance during yesterday's House Judiciary Committee hearing, one thing hasn't gotten enough coverage. What needs more amplification is the need to throw out the children running the House Judiciary Committee and replace them with adults. The winner of yesterday's hearing was determined before Bill Barr read his opening statement.
That doesn't mean that AG Barr didn't cut Democrats when Democrats weren't reclaiming their time. As Michael Goodwin notes in his column, Barr said "This is the first time in my memory that the leaders of one of our two great political parties, the Democratic Party, are not coming out and condemning mob violence" then asked "Can't we just say the violence against the federal courts has to stop? Could we hear something like that?"
That's beyond disgraceful. The Democrats haven't said a thing about Antifa's attacks against the federal courthouse in Portland or the federal law enforcement officers protecting the building. That's especially disgusting since 3 of those officers were blinded for life by laser lights. In this video, Pelosi called the federal law enforcement officers "stormtroopers":
Democrats are the party that's pushing the defund the police movement. Democrats are the ones that talked about the Seattle CHOP zone perhaps turning into the 'Summer of Love' Zone. About 4 minutes into this video, Mayor Durkan made that historic statement:
Democrats are too stupid or too passive or both to be in charge of anything. Anyone watching yesterday's House Judiciary Committee hearing knows that Democrats on that committee aren't that bright. Anyone watching Minneapolis, NY City, Portland or Seattle knows that the mayors of those cities with a fist of mashed potatoes. Anarchists, Antifa and agitators rule those cities' streets.
Democrats are the party that push propaganda that insists it's too dangerous to send children back to school. That's an outright lie. Nowhere in the world has a child transmitted COVID to a teacher. That's because children aren't spreaders. That's because children are the least likely to contract the virus.
Do you want dishonest stupid people in charge of anything? If you're voting for most Democrats, that's what you're getting. This isn't Bill Clinton's relatively rational Democrat Party. This is AOC's and Bernie's Socialist Party.
Finally, a Biden administration likely means Keith Ellison as Attorney General. If that doesn't frighten you, then you're hopeless.
Posted in Anarchy/Anarchists, Antifa, Democrats, Election 2020, Pelosi | No Comments »
The Nadler car accident, then the Nadler train wreck hearing
It's apparent that Democrats are attempting to provide a contrast between their law enforcement ideas and the Republicans' plans for restoring safety to America's streets. The comparison couldn't be more unmistakable. The choice facing the American people is between Democrats defending riots in Portland, Seattle and Minneapolis vs. the Trump administration's sending in federal law enforcement officers to protect neighborhoods and federal buildings.
Andy Ngo is providing incredible images from Portland. Check this out:
A rioter jumps over the barrier and lights some type of incendiary device to throw at the Portland federal courthouse. He is shot with pepper balls after he hurls the lit projectile. #PortlandRiots #antifa pic.twitter.com/bW3NOg7lyn
Next, check this out:
Here's a photograph of the man who jumped over the fence and lit some type of device to throw at the Portland federal courthouse. #PortlandRiots pic.twitter.com/kUMgq8u3ch
This is the definition of disgusting behavior:
I pleaded w/a local news crew to leave with them because I was about to get beaten or killed. Even though Zielinski & I disagree on politics, I would never try to hurt her. I'm airing this now because the public should be aware of how local journalists work hand-in-hand w/antifa.
Portland media is pretty much leftist fringe. They'd get along great with AOC, Rashida Tlaib and Ilhan Omar. But I digress.
Before the hearing, Chairman Nadler was in a car accident. That was just the start of Nadler's terrible day. He should've seen it as an omen of things to come. Not surprisingly, Axios published a partial transcript of Nadler's accusations:
First, under your leadership, the Department has endangered Americans and violated their constitutional rights by flooding federal law enforcement into the streets of American cities, against the wishes of the state and local leaders of those cities, to forcefully and unconstitutionally suppress dissent.
Second, at your direction, Department officials have downplayed the effects of systemic racism and abandoned the victims of police brutality; refused to hold abusive police departments accountable for their actions; and expressed open hostility to the Black Lives Matter movement.
Third, in coordination with the White House, the Department has spread disinformation about voter fraud, failed to enforce voting rights laws, and attempted to change the census rules to flaunt the plain text of the Constitution—all in the apparent attempt to assist the President's reelection.
Fourth, at the President's request, the Department has amplified the President's conspiracy theories and shielded him from responsibility by blatantly misrepresenting the Mueller Report and failing to hold foreign actors accountable for their attacks on our elections—undermining both national security and the Department's professional staff in the process.
Fifth, again and again, you personally have interfered with ongoing criminal investigations to protect the President and his allies from the consequences of their actions.
Finally, and perhaps most perniciously, the Department has placed the President's political needs over the public health by challenging stay-at-home orders in the states hit hardest by the pandemic. The Department's persistent efforts to gut the Affordable Care Act will make recovery that much harder.
Expressing open hostility towards the Black Lives Matter movement isn't a disgrace. It's sound judgment. Further, I'd argue that Democrats have turned a blind eye towards black-on-black crime. Republicans have expressed hostility towards the BLM movement because BLM's founders are admitted "trained Marxists." That isn't racist. The rest of Nadler's accusations plus a dollar are worth less than a dollar. The accusations are typical 'throw everything at the wall and hope that something sticks' Democrat special.
Michael Goodwin's column feasts on what's left of Nadler's carcass:
He came, he saw, he ate their lunch. Bill Barr, denied a meal break, feasted instead on a gaggle of Democratic amateurs.
Another congressional hearing, another Dem disaster. They planned a public hanging of the attorney general and spent weeks constructing their scaffold. He is corrupt, a liar, a toady, they and their media handmaidens assured us, and the House Judiciary Committee will reveal all.
Two obstacles quickly became apparent. The first is that the Dems were led by Rep. Jerry Nadler, whose rabidness is exceeded only by his haplessness.
When it comes to train wrecks, nobody does it better than Nadler. What he's missing in intellectual heft, he makes up for with oversized ego. It's why Pelosi demoted him during the Democrats' failed impeachment attempt. It isn't a stretch to say that Nadler is the worst chairman in the history of the House Judiciary Committee.
Posted in Antifa, Bill Barr, Black Lives Matter, Impeachment, Jerry Nadler, Pelosi | No Comments »
The Democrats' "mostly peaceful protests"
Yesterday's fiasco in the House Judiciary Committee was both frightening and embarrassing. Back when Republicans ran the House, committee hearings had plenty of grandstanding but they broke plenty of news, too. Tuesday's hearing of the House Impeachment Rubberstamp Committee (that's what it's famous for these days) got off to a terrible start when Chairman Jerry Nadler got into a car accident on his way to the hearing. It isn't a stretch to say that it went downhill after that. Perhaps, the accident should be viewed as an omen.
Two things became immediately clear the minute the hearing got started. First, Democrats weren't going to let William Barr answer their questions. Next, these Democrats were going to pound home the theme that Portland's riots were "mostly peaceful protests." At one point, Barr interrupted the Democrats and said (I'm paraphrasing here) "This is a hearing. Shouldn't I be heard?"
The 'Wall of Moms' aren't female patriots. Reporting from Portland indicates that they're human shields used to protect weapons-carrying Antifa/BLM rioters. That isn't what patriots do.
The Democrats' storyline was demolished during Steve Chabot's questioning of AG Barr:
It was demolished when AG Barr asked the rhetorical question "The courts are under attack. Since when is it ok to try to burn down a federal court? If someone went down the street to the Prettyman Court, that beautiful courthouse we have right at the bottom of the hill, and started breaking windows and firing industrial grade fireworks to start a fire and threw in kerosene balloons and start fires in the court, is that ok? Is that ok now?"
When AG Barr tried answering the Democrats' questions in ways that didn't advance the Democrats' storyline, they'd cut AG Barr off, saying that their time was limited and that they were reclaiming their time. I didn't keep count of how often Democrats pulled that stunt but it was easily a dozen times. Barr would then politely stop his reply and let Democrats make asses of themselves:
Democrats looked like jerks and idiots throughout. When Democrats didn't get the answer they wanted, the frequent reply was "I'm reclaiming my time." Democrats had a storyline that they'd established and they weren't deviating from it.
What's disgusting is that Nadler, Lofgren and the other Democrat idiots didn't do is propose a solution to the anarchists torching once-beautiful cities like Seattle, Portland and Chicago. Democrats spent the day insisting that federal law enforcement officers were the bad guys and that Antifa-BLM rioters were the good guys.
If you want to live with a Democrat majority that thinks that burning down "the system" is the right thing to do, just vote Democrat. If you're a thoughtful person who cherishes peaceful streets where riots are stopped quickly, you must vote for Republicans. It's that simple.
Posted in Anarchy/Anarchists, Antifa, Bill Barr, Black Lives Matter, Democrats, Jerry Nadler | No Comments »
Portland's peaceful protests
CNN's Brian Stelter, aka Humpty Dumpty, insists that the Portland are a figment of Fox's imagination. This article is proof that Humpty is a blithering idiot. The article states "The Oregonian reported that authorities responded to reports of gunfire in downtown Portland and an apparent victim was treated at a hospital after being taken there in a private vehicle. The report pointed out that it was not immediately clear if the shooting was related to the protest, which marked its 60th consecutive night in the city."
Then it continues, saying "Police said they found a bag containing loaded rifle magazines and Molotov cocktails at a nearby park. A photo of the items was shared in a tweet from police late Sunday saying someone pointed out the bag to officers at Lownsdale Square Park late Sunday. No further information was immediately released. It wasn't clear if either incident was connected to the demonstrations."
Ammunition and destructive devices recovered at Lownsdale Square Park (Photo) https://t.co/k4ZmvTzlh6 pic.twitter.com/xHaLZM8uWi
— Portland Police (@PortlandPolice) July 27, 2020
If Portland's peaceful protesters use these tools, then they aren't peaceful protesters:
On July 26, 2020 while Portland Police were investigating a shots fired call near Lownsdale Square Park a passerby pointed out a suspicious bag to them. Police examined the bag and found that it contained loaded rifle magazines and Molotov cocktails. Police recovered the bag. The origin of this ammunition and these destructive devices is under investigation.
I won't hold my breath waiting for Humpty Dumpty to issue his apology. Let's remember that CNN is one of the organizations that's already settled with Nicholas Sandman for defaming him.
Portland's rioters took to the streets for the sixtieth straight night last night. In other news, rioters presented Ted Wheeler, Portland's spineless mayor, with this list of demands:
The progressive mayor on Wednesday night entered the chaotic epicenter of Portland to engage in listening sessions with the rioters. Instead, the crowds castigated him and presented him with a list of demands that included defunding the police and for Wheeler himself to resign.
That's mindful of this scene from Minneapolis:
What is it about these wimpy progressive mayors? Were they built to be wimps?
Posted in Antifa, Jacob Frey, Law Enforcement, Riots | No Comments »
Antifa's threats, intimidation of Chad Wolf hits home
Antifa is perfectly willing to threaten or intimidate virtually anyone, including Chad Wolf, the acting secretary of Homeland Security. This article tells the story of 'protesters' showing up at Secretary Wolf's home:
Protesters marched to Homeland Security Acting Secretary Chad Wolf's home in Alexandria, Virginia, on Sunday to demand an end to the deployment of federal officers in response to unrest in the wake of George Floyd's death. Demonstrators began to gather at an intersection near Wolf's home in Alexandria on Sunday morning at around 10:15 a.m.
That's roughly the time Secretary Wolf started his interview with Maria Bartiromo. Anyone thinking that that's a coincidence is kidding themselves.
Marching under the "Shut Down D.C." banner, they then made their way to the DHS chief's home where activists were pictured gathering outside with signs that read "Resist Trump's Troops" and "No more teargas, no more tearing families apart."
"We know there are no career consequences for these men and women. We know there are no financial consequences for these men and women. We know there are no legal consequences for these men and women. We must make social consequences for these men and women," one protester could be heard saying in video posted to Twitter by journalist Julio Rosas.
There aren't any consequences for protecting law-abiding citizens. That's what DHS officers have done thus far. PS- There shouldn't be consequences for protecting law-abiding citizens. There should only be consequences for law-breaking citizens.
Protesters have gathered outside the home of Chad Wolf, acting secretary of Homeland Security. They are here to protest against DHS sending federal agents to Portland after rioters continue to target the federal courthouse in the city. pic.twitter.com/SeWSElO2KY
— Julio Rosas (@Julio_Rosas11) July 26, 2020
In recent days, Wolf has faced growing scrutiny over his role in overseeing the deployment of federal law enforcement to Portland, where officers have clashed with demonstrators for weeks.
It isn't enough to highlight the fact that Portland doesn't have a protest problem. Portland has a rioting problem even though CNN's Brian Stelter insists that it's a "gross exaggeration. It just is."
Oh really, Mr. Stelter?
An official with the Department of Homeland Security's Federal Protective Service said several officers sustained serious eye injuries after protesters pointed lasers in their eyes. According to FOX 13, Deputy Director of Operations Richard Cline said officers were putting out fires set by protesters when they were accosted with lasers.
"When officers responded to put out these fires, glass bottles were thrown and lasers, which can cause permanent blindness, were shined in their eyes," Cline told FOX 13. "We have three officers who currently have eye injuries and they may not recover sight in those eyes from those laser attacks." The FPS has since purchased anti-laser glasses officers are now wearing, according to FOX 13.
DHS's FPS division showed up to put out fires. Those fires have been confirmed by videos from the ground. If Humpty Dumpty wants to dispute the authenticity of the video, have at it.
Further, the fires confirm that the violence is real. There's a portion of the night that's used by protesters. Unfortunately for the Democrats' storyline, those protesters support what the rioters are doing. The faux protesters are used to tie up officers while the rioters sneak in supplies for the riot during the dark of night.
Posted in Antifa, Democrats, Homeland Security, Law Enforcement | No Comments »
Democrats ruined Portland, another once-vibrant, city
While Democrat leftists caterwaul about "Gestapo activities" in Portland, these Democrat leftists ignore the fact that businesses are permanently closing their doors. Apparently, Democrats don't care about the guys who run places like Old Town Pizza & Brewing. Old Town Pizza & Brewing recently finished the day "with just $18.75 in sales."
It's just another sad story in a series of sad stories radiating out from Democrat-run cities. Adam Milne, the owner of Old Town Pizza & Brewing, recently said "I think all restaurants are really hurting and struggling, but I'm not sure if the city and state officials realize that to be a restaurant and to be in downtown Portland right now is a double blow. Not only are we suffering from the pandemic, but we have an area of the state that everyone is avoiding eating and drinking."
Thanks to Antifa's and BLM's nightly riots, only an idiot would venture into downtown Portland. Meanwhile, Democrat House Majority Whip Jim Clyburn said this on CNN:
Democrat Representative Jim Clyburn Compares Federal Law Enforcement To Nazi Germany Gestapo pic.twitter.com/fkEHUDuyQb
— Arthur Schwartz (@ArthurSchwartz) July 20, 2020
Rep. Clyburn should be thrown out of the House for uttering that type of BS. Instead of challenging him on making such an incendiary statement, CNN just let it go. This isn't some back-bench bomb-thrower. This is the third-ranking Democrat in the House. Further, he's the guy that helped Joe Biden win the Democrats' presidential nomination. Without Clyburn's nomination right before the South Carolina Primary, Bernie would be the Democrats' nominee.
Speaking of Mr. Biden, here's what he said in an ad about uniting the country:
First, Biden hasn't criticized Portland's violence with the exception of him criticizing federal law enforcement:
Former Vice President Joe Biden said Tuesday that the Trump administration was deploying Department of Homeland Security officers in Portland without clearly defined goals, even as department officials defended their efforts to eliminate violent protests. "We have a president who is determined to sow chaos and division," said Biden, the presumptive Democratic nominee to challenge President Donald Trump on Nov. 3. "To make matters worse instead of better."
I guess that's Biden's way of uniting the nation. Criticizing law enforcement officers who are protecting a federal courthouse isn't uniting people. It's being a loud-mouthed jerk, then pretending to be a uniter.
The question is whether Americans will admit that they see what's happening. Joe Biden isn't pro-law enforcement. He's for whatever keeps Democrats together. In his minute-long ad, Biden talked about representing all Americans, whether they voted for him or not. What we've heard from, though, are the words of a divider, the words of a hate-filled man.
Joe Biden won't challenge Ted Wheeler, Portland's mayor. He won't stop the rioting, either. Frankly, Joe Biden doesn't know how to challenge Democrats. Whatever they want to do is fine with him. Portland is proof of that.
FOOTNOTE: When Barack Obama was president and Biden was his vice president, they were openly hostile to the police. Read about what they did in Ferguson. Remember that they didn't lift a finger to stop Chicago's violence, either. If you want more of the same, vote Biden. If you want safe streets, vote Trump. It's that simple.
Posted in Anarchy/Anarchists, Antifa, Black Lives Matter, Civil Rights Act, Crime, Democrats, Jim Crow Laws, Joe Biden, KKK, Law Enforcement, Obama, Racism | No Comments »
Portland is proof positive that Democrats hate police officers
Buck Sexton's op-ed exposes the Democrats' intentions to transform the United States into something resembling a third-world dictatorship. Sexton also highlights the media's role in running interference for the domestic terrorists.
For almost two months, Portland has been under siege from Antifa and other extremists. These troops of the left terrorize the downtown area every night. They operate with paramilitary precision. As organized anarchists, they deploy a wide array of less than lethal weapons to wound police, ranging from bats and bricks to lasers shot in the eyes of officers to permanently damage their sight. All of this is to further their goal to overturn our society and radically transform the country.
Antifa isn't murdering anyone. That type of violence would strip the MSM and other Democrats of their ability to spin Portland as a peaceful protest that got out of control. Instead, Antifa and BLM use tactics that destroy police officers' lives without killing them. Without the bloodshed, it's difficult to characterize Antifa/BLM as terrorists.
While it's difficult to characterize Antifa/BLM as terrorists, it isn't impossible. It just takes patience and logic. Once people explain to the average person what tactics Antifa/BLM uses, those people understand quickly. It's clear that they're participating in a riot. Judge Mukasey explained today that some of the crimes that Antifa/BLM are committing are legitimate predication for RICO indictments.
If the news media cared to tell the public the truth, it would have been a top story on nightly broadcasts for weeks. The Antifa rioters even tried to break into and burn down a federal courthouse in the city. The campaign of intimidation and destruction is plainly domestic terrorism. But the one reason the siege on Portland has become a major news story is because the administration is trying to restore law and order to the beleaguered city, and Democrats hysterically oppose any such action.
Thus far, Democrats have shown their hatred of police officers on a nightly basis. Check this out:
Antifa has no respect for the law. The police in Portland are effectively useless thanks to the city.
Officers were responding to a call about an alleged stabbing situation and here's how they were treated. pic.twitter.com/Ayt0WZHOKr
— Ian Miles Cheong (@stillgray) July 25, 2020
Before Jessica Tarlov or some other dishonest leftist mouthpiece says that these aren't Democrats, I'll just remind them that Portland Mayor Ted Wheeler spent the night with the rioters. Democrats in Oregon have filed lawsuits against the federal government to prevent them from doing their jobs, too. These are public officials who don't want to enforce the laws of their city and state. There's tons of proof that Democrats don't want to enforce existing laws. Bill de Blasio has threatened to file a lawsuit if President Trump tries stopping the violence. That's fine. Let that festering hellhole turn into a warzone where people can't live. It doesn't matter to me. I don't live there.
If Democrats don't want to enforce the laws, President Trump should fund advertisements telling Portlanders that states like the Carolinas, Georgia, Texas and Florida take law enforcement seriously and that their states aren't shooting galleries. If Democrats won't stand with police officers, then Portland shouldn't be surprised when people vote with their mortgages.
PS- Why hasn't Joe Biden spoken out against Portland's violence? Is it because he's counting on getting Antifa's votes while maintaining his image that he's a centrist? His silence says everything.
Posted in Anarchy/Anarchists, Antifa, Crime, Democrats, Election 2020, Joe Biden | No Comments »
Proof that Democrats hate police officers
For almost two months, Portland has been under siege from Antifa and other extremists. These troops of the left terrorize the downtown area every night. They with paramilitary precision. As organized anarchists, they deploy a wide array of less than lethal weapons to wound police, ranging from bats and bricks to lasers shot in the eyes of officers to permanently damage their sight. All of this is to further their goal to overturn our society and radically transform the country.
Antifa isn't murdering anyone. They're blinding federal law enforcement agents. The thing is that they're participating in a riot. They don't have to commit murders or violent crimes to be convicted and put in prison for decades. The deterrent with federal crimes is lengthy prison sentences in a federal penitentiary.
Before Jessica Tarlov or some other dishonest leftist mouthpiece says that these aren't Democrats, I'll just remind them that Portland Mayor Ted Wheeler spent the night with the rioters. Democrats in Oregon have filed lawsuits against the federal government to prevent them from doing their jobs, too. These are public officials who don't want to enforce the laws of their city and state.
Democrats who won't enforce their own laws but will file lawsuits attempting to prevent federal law enforcement officers from upholding federal law hate police. Another bit of proof that Democrats hate police is that Democrats have been totally silent about the Antifa rioters who used lasers to blind for life police officers. Officers that can't function shouldn't be ignored. Democrats have essentially ignored these officers wounded in the line of duty.
Posted in Anarchy/Anarchists, Antifa, Democrats, Law Enforcement | No Comments »
DFL: racism is a health crisis
According to this resolution, racism is a health crisis. That isn't my implication. That's from HR1 from the House Second Special Session. The resolution starts by saying "A House resolution declaring racism a public health crisis. WHEREAS, race is a social construct with no biological basis; and WHEREAS, racism is embedded in the foundation of America, beginning with chattel slavery in 1619; and WHEREAS, much of the Black experience in America has been endured under slavery and Jim Crow, which created preferential opportunities for white people while subjecting people of color to hardships and disadvantages in every area of life;"
First, let's dispose of the myth that the United States started in 1619. In 1619, the colonies were still under British rule. The Boston Tea Party, which was one of the first rebellious acts by the colonies against British governance, didn't happen until Dec. 16, 1773. This is proof that timelines matter. The British indeed loved a two-tiered system of government. Royalty and commoners weren't supposed to mix. The US didn't want that system so they did something revolutionary.
The US said that our rights came from "Nature's God" and that "all men are created equal." The 56 men who signed the Declaration believed that each person was created in the image of Nature's God. That's why the US fought a civil war to end slavery. The US is the only nation that's fought a war to abolish slavery. That isn't something that a nation committed to systematic slavery would do.
Even after the Civil War, the Confederacy, the home of the Democrat Party, still insisted on building impediments to full-fledged liberty. That's what Jim Crow was about. It's a biological fact. Next, most of the embedded pockets of racism, especially slavery and Jim Crow, were mostly found in the South when Democrats reigned supreme:
Black codes were strict local and state laws that detailed when, where and how formerly enslaved people could work, and for how much compensation. The codes appeared throughout the South as a legal way to put Black citizens into indentured servitude, to take voting rights away, to control where they lived and how they traveled and to seize children for labor purposes.
If the DFL wants to admit that the GOP was created to end slavery and that Democrats were the party of the KKK, Jim Crow and the Confederacy, that's fine. The things that Democrats have stood for have been evil. Recently, Democrats haven't protected minorities, letting Antifa and BLM rioters destroy minority-owned businesses and minority-owned neighborhoods. Democrats called for the dismantling of the police departments that protect minority neighborhoods.
WHEREAS, public health disparities have persisted for over 400 years and there are long-standing, unaddressed disparities as well as systemic racism and other socioeconomic inequities;
That's a lie. The problems within the black community first appeared after LBJ's signing of the Great Society legislation. Since then, poverty in minority neighborhoods has tripled.
WHEREAS, more than 100 studies have linked racism to worse health outcomes; and WHEREAS, in Minnesota the highest excess death rates exist for Black and Indigenous communities, at every age demographic; and WHEREAS, Minnesota must address persistent disparities in health outcomes and the social, economic, educational, and environmental inequities that contribute to them;
Linking worse health outcomes to racism is BS. How many of these 'studies' are peer-reviewed and questioned? Might outcomes improve if schools taught the value of proper nutrition?
We've advanced a resolution declaring racism a public health crisis in MN. Floor vote next. Thank you Rep. Ruth Richardson for your leadership. Our nation is facing a historic moment and the #MNHouse plans to be on the side of justice and human rights. https://t.co/wSeYmK2cAb
— Ryan Winkler (@_RyanWinkler) July 14, 2020
Posted in Antifa, Bill of Rights, Black Lives Matter, Jim Crow Laws, Racism | 1 Comment »

redpajama_set_name: RedPajamaCommonCrawl


Cemetery - Church - Dam - Populated Place - Post Office - Reservoir - School - Stream.
Cemetery Alexander Cemetery - Antioch Cemetery - Banks Cemetery - Bethel Cemetery - Wilson Cemetery - Church Antioch Church - Bethel Baptist Church - Beulah Hill Baptist Church - Dam Sorrell Lake Dam - Populated Place Banks - Post Office Banks Post Office - Reservoir Pine Lake - School Banks Junior High School - Bethel Academy (historical) - Bethel School - Hollis School (historical) - Stream Highsmith Branch.
Allred - Ansley - Antioch - Baltic - Brantley Mobile Home Park - Briar Hill - Broad View - Brundidge - Buckhorn - Caldwell Subdivision - Catalpa - Centre Ridge (historical) - China Grove - Colina - College Park - Corcoran - Country Club Estates - Curry - Dogwood Acres - Dozier Estates - Dozier Trailer Park - Dunn - Edgewood Mobile Home Park - Elmhill Plantation - Enon - Ezell - Forest Acres Mobile Home Park - Forest Circle - Friendship - Good Hope - Goshen - Green Oaks - Green Ridge - Hallsville - Hamilton Crossroads - Harmony - Henderson - Hephzibah - Heritage Ridge - Highland Park - Hillcrest - Jonesville - Josie - Kent - Lees Park - Lewis - Linwood - Little Oak - Logton - McClure Town - Meadow Grove - Meeksville - Monticello - Mossy Grove - Mossy Grove Estates - Mossy Grove Village - Mountainbrook - Needmore - North Ridge Mobile Home Park - Northdale - Oaks Heights - Olustee - Orion - Palmyra - Pierson Subdivision - Pine Forest Estates - Pine Ridge Estates - Pinewood Estates - Pleasant Hill - Pleasant Ridge - Pronto - Ramage Subdivision - Richland - Ridgewood - River Ridge - Saco - Sanders Hill - Sandfield - Shady Grove - Shellhorn - Shiloh - Spring Hill - Stills Crossroads - Sunset Mountain Mobile Home Park - Tarentum - Tennille - Thomas Crossroad - Town and Country Estates - Trojan Terrace - Troy - Westview - Wilson Trailer Park - Windmill Hills - Wingard - Woodland Hills - Youngblood .
Please find in what follows the full listing of the Hotels, Bed & Breakfasts and other accommodation available in Banks.
View the interactive maps of Banks and get road maps, satellite maps and much more. The maps cover a wide area centered on Banks .


1. At Hell in a Cell, Sami Zayn shocked the world by appearing out of nowhere to help Kevin Owens nearly manslaughter Shane McMahon. Tonight, he'll attempts to explain his actions. We'll be riveted. Complicated male friendship forever.
2. As noted above, Shane McMahon almost died for real. Will a new McMahon step in to fill the void on Smackdown? The options are limited, seeing as how at least two McMahons are pretty thoroughly out of action thanks to Owens. Will KO stop at nothing until every McMahon is in an infirmary? Probably!
3. AJ Styles lost his United States Championship at Hell in a Cell, but he'll be invoking his rematch clause tonight. Also, the U.S. Open Challenge will never return and we should probably just start coming to terms with that. It's acceptable to cry. We're sorry, too.
4. Speaking of new champions, the Usos are the tag champs again! Normally, it will be a shame when the New Days invoke their "nothing is ever over" rematch clause, but the New Day and the Usos have been so good together that they can fight each other forever. We honestly don't care. Bring it on.
5. Becky Lynch and Carmella will have a match tonight! They're trying to "gain ground" in the race for Natalya's title, even though one of these two women has the Money in the Bank briefcase and there are only seven women in the division. Whoa, weird, where did all these tumbleweeds come from?
As always, we're including 10 of the best comments from tonight's open discussion thread in tomorrow's Best and Worst of Smackdown Live report. Reply to your favorites with a +1 to nominate them for consideration, and share the open thread around so we can get some fresh voices and jokes in here. Enjoy the show!


18" Full Lace Wigs - Body Wave (Small Size) - Super Hair Factory Inc.
Our full lace wigs are all made of the very best quality 100% Indian Remi hair, medium density, and 6 ounces of hair. BODY WAVE texture gives a larger, roller set look. It is ideal for those who like to set their hair in rollers, or would like a hint of body.


text:
Family Fellowship
Foster Care Agencies
Decorate Bags
Build Skateboards
Build Bikes
Superhero Boxes
Help Locally
Waddler Club
Choose A Fundraiser
Donate Your Birthday
Judge's Tough Approach to Foster Care
Resources December 5, 2019
Judge's tough approach to foster care is transforming New Orleans. When you enter Judge Ernestine S. Gray's courtroom it looks more like a preschool than a courtroom. There is a bookcase full of children's classics and stuffed animals of every shape, size, and species.
Making the Worst Day Better
Juvenile Court Judge Ernestine S. Gray gives all children who appear in her court a bear and book. Something small but something she believes to ease what can be the worst day of their young lives. The dichotomy of Gray's soft touch does not overshadow her power as one of four judges on the child protection docket of Louisiana. Her work continues to reduce the numbers in Orleans Parish's foster care to numbers unmatched anywhere in the country.
The Washington Post reports,
Between 2011 and 2017, the number of children in foster care here fell by 89 percent compared with an 8 percent increase nationally. New Orleans children who do enter the system don't stay long. Seventy percent are discharged within a month; nationally, it's only 5 percent.
Gray has effectively all but eliminated foster care except in extreme situations, quickly returning children flagged by social workers to their families or other relatives.
A Refreshing Approach to Foster Care
Gray comments on her upbringing in the Post.
We shouldn't be taking kids away from their parents because they don't have food or a refrigerator," she said in explaining her philosophy. "I grew up in a poor family in South Carolina, and we didn't have a lot. But what I had was people who cared about me.
A private study conducted by Casey Family Programs in Seattle uncovered numbers so low that it left the child welfare community in shock. Gray's tough approach to foster care emulates a national movement for reform as seen with the passing of the Family First Prevention Services Act.
Reform Through Family First Prevention Services Act
Passed in 2018 the Family First Prevention Services Act allows states to reallocate fundings for foster care to preventative services. The rationale behind the act is to keep more families together through preventative treatments such as mental health care, substance abuse treatment, and parenting skills training. Gray tells the Post.
Foster care is put up as this thing that is going to save kids, but kids die in foster care, kids get sick in foster care," she said. "So we ought to be trying to figure out how to use that as little as possible. People have a right to raise their children.
Is this a Nation Model?
Gray holds her seat for one more year before mandatory retirement at age 70. While she does not have a comment on whether her approach to foster care is the best model nationally. She did comment needing more officials who are not afraid of negative publicity or losing elections. The Post quotes Gray in saying,
You have to have courage, she said. I don't advocate being reckless, but I think there are judges who do things just to be safe, for themselves and the families. To me, that's not the standard.
For more resources for foster youth and their families visit our website here.
Foster to Adopt Process: Becky
Adopt from Foster Care: Amy's Story
Tennessee Expanding Paid Family Leave
7 Things You Should Not Say To Aged Out Foster Youth
6 Ways to Help Kids in Foster Care in 2020
Build A Board
Building Bikes
Disney Days
Sweet Cases
Louisiana New Orleans
7 Easy Ways to Engage Employees
7 Ways to Give Back to the Community
More About TWR
#FosterLove
Sweet Case Bundles
Stats & Info
2008 - 2020 Together We Rise is a 501(c)3
non-profit that helps kids in foster care.
Contact Us | Sitemap | Privacy Policy
| Terms of Service | State Nonprofit Disclosures
| EIN: 26-3043727
Together We Rise


This is a dark brown men's vintage silk haori kimono jacket. It has a powerful and dramatic design of Fujin 風神 (wind god) and Raijin 雷神 (thunder god) in the lining, which is dyed. The outside textile is omeshi silk.
Omeshi is a heavy crepe silk woven with strongly twisted threads, and is even firmer in texture than chirimen.
Those man's haori jacket don't usually come with straps. You can wear without straps and keep the front open or you can contact me if you'd like a pair. Navy blue and brown colours straps are available at the moment.
There are some small flaws including a couple of slight stains, but as a whole, I think it is in very good condition.
Please check the detail photos and 'Extra Images'.


We take our jobs seriously here, especially when it comes to giving our readers the best and most accurate information. We want to make sure that we can be trusted to bring our readers the best news, reviews, articles, and more – so we've revamped and republished our Ethics and Standards Guidelines. The TechRaptor Ethics and Standards Policies are applied to all writers, and will be enforced in all cases in order to maintain journalistic integrity.
TechRaptor extensively consulted the SPJ code of ethics while writing this and adapted the ideals espoused therein to fit our particular website. We strive at all times to live up to the ideals of ethical journalism promoting the sharing of accurate, fair, and thorough information.
TechRaptor enlists authors who are interested in a genre or game to handle reviews of those specific genres or games. When working on a review, it is expected that the reviewer finish the game, though not necessarily collect all the collectibles and achievements. In games where there is no definitive main campaign or end mark, the reviewer is expected to play enough to have a solid grounding in the game – and will require editor approval to publish the review.
All reviews will be conducted with legally-obtained products, and we do not condone illegally downloading games or software. While TechRaptor may receive review copies (please see that section for how we handle those), companies cannot and are not expected to pay to get their product reviewed.
Review scores are determined by the author of the piece, with editors discussing it with them as needed. Please see our Review Score Policy for more information on how we score and work on reviews.
1) Developers can email us ([email protected]) to request a review of their game. A writer is assigned and a code/copy is given.
2) Writer requests that they review a certain game, and an approved requester (PR Manager or other) reaches out to see if a copy of the game can be given.
In both cases, the writer is the one who is given the code/copy for review, and as such they are expected to follow all guidelines (see Reviews and Embargoes for more info) in their review. Should a writer fail to write the review, or leave the site without notice, TechRaptor will attempt to reassign the game to another staff member and possibly purchase a copy for them.
In the event that TechRaptor is given extra copies outside of the number needed to test multiplayer, they will be either given to another staff member for streaming or coverage, or used in community giveaways on the site or on Twitter.
Any items that are greater than $100 in value (Not including DLC/expansions or in-game currency for review) can only be kept at the discretion of the managing editor, otherwise they will be returned to TechRaptor. The item(s) will then be used for giveaways or internal use (videos, etc.) and will either be mailed to the managing editor or supervisor, or directly to winner(s) – paid for by TechRaptor.
Some products require a Non-Disclosure Agreement (NDA) and/or release embargo when giving information or codes for products. TechRaptor will accept and follow any NDA's and embargoes that are laid out by developers and publishers – provided they do not request changes to the editorial process. Should the developer request we write an article a certain way due to an NDA or pre-release info, we will find a way to cover the game without those restrictions.
If an embargo or non-disclosure agreement would preclude us from talking about something until post-launch, we will not agree to it and instead disclose this fact to our readership and obtain the game through retail methods. If writers are able to obtain a game before Western release, the developer will be contacted before publishing a review.
Kickstarter/IndieGoGo: Staff members are allowed limited participation in these campaigns and all such participation must be relayed to the Editorial staff and disclosed in any pieces discussing it. If a writer has backed a campaign at a level staff believes may compromise their judgment (such decisions are made on a case by case basis but normally entailing large donations), they will be barred from writing on that topic. In any case, at all times the fact that the writer has backed it will be disclosed to the reader.
Patreon: Staff members are banned from using Patreon to back game creators, tech companies, game or tech journalists, and other similar fields. If a staff member is backing a Patreon in another field, they must disclose that to editorial staff and cannot discuss that company/item through their writing on TechRaptor. Additionally, if staff members have previously backed a Patreon for a project or person prior to coming on-board the site, they will disclose that fact along with when they began supporting it/them.
Early Access: While Early Access is used to help fund game development, we view it as separate since there is a product available. For most cases, Early Access is treated as a normal game, though evaluations will be previews – not reviews. Unlike other previews, Early Access will generally contain a judgement regarding whether or not it is worth buying in its current state. As in other previews and reviews, how we obtained the key will be disclosed in the article.
Often times during these campaigns developers are looking for feedback – be it on how their pitch is or what people think of their game in its current state. Our writers are encouraged to share their views on such things publicly.
TechRaptor strives to seek the truth on all matters and report honestly and fairly. Special care is given to verify all information and utilize original sources whenever possible. TechRaptor aims to never distort the facts or misrepresent them in any way either by intention or omission of facts such as context, and in cases that such may occur, steps will be taken to remedy it as soon as possible. This will be disclosed to the readers so they may know what has occurred.
We shall seek out the subjects of news and ask them to respond to any criticisms or allegations. In the event that they do not respond, this will be reported in the relevant article. Should TechRaptor receive a response after the fact, it shall be updated to include said response. We shall seek viewpoints from all sides, even those we disagree with, and allow them to share their point of view. All opinions, commentary, and advocacy on matters will be labelled as such.
TechRaptor always aims to treat all people as respected human beings and to minimize harm done by reporting whenever possible without compromising the truth. This involves balancing the public need-to-know on issues with things such as potential harm or discomfort. The pursuit of truth is not a reason to be rude, inconsiderate, or arrogant. In some cases, legal access to information does not mean there are ethical reasons to publish it.
TechRaptor considers it especially important to contemplate the long-term implications of information provided. We strive to always stay up to date with the most accurate information available. In the case of reviews, or opinions, a writer's views are their own and do not necessarily reflect the reviews or opinions of TechRaptor as a whole. If a review or opinion piece is found to have inaccurate information at the time of publication (information changed from a patch does not count) we will strive to make corrections as they are found – please see our review policy for more. Even if others publish it, we avoid sensationalized stories, instead aiming for accuracy and truth – lurid curiosity is not a reason to publish.
TechRaptor will never knowingly plagiarize documents, and instead seeks to attribute all documents to the original source. Ideally, this will be with a link, but there are times that it is not possible if it comes from a press release that isn't posted online or some methods of communication. In those cases it will be stated where the information came from.
In some cases, information pertaining to a story is taken offline for one of various reasons. In those cases, if possible, we will provide an archive link to sources within a story. This is the only time we will use archive links – when the original source is no longer available so that readers may verify the information themselves.
If you believe that anything on this site has been plagiarized please visit our contact us page and get in touch with staff so we may investigate and solve the issue as quickly as possible.
TechRaptor endeavors to keep all of our articles up-to-date with the most recent news that is out. In the current media landscape of the Internet, information travels faster than ever, and what was hot 20 minutes ago might no longer be accurate.
In light of this changing landscape, TechRaptor aims to find a ground generally between constantly changing what was written and providing the most accurate information. Depending on the circumstances, TechRaptor may either do a new article (typically linking to the old one), or update the article already written.
In the case of reviews, please check out the Review Policy for how review updates are handled – this section will deal with other articles we write.
When updating minor matters of copy, there will not be an update notice. These types of updates are any sort of spelling, grammar style mistakes that slip out, forgotten links, and rewording of phrases for clarification. Anything else will have a notice of updates.
Slightly larger updates, where information has come to us but does not substantially change or negate what was said, will similarly have an update at the bottom. These are typically updates in which the information expands on what was said, giving a clearer or larger picture but not changing the heart of the matter. Additionally, titles will be appended with the [Updated] tag at the front.
Large updates that change the tenor of the piece, are transformative in the type of information available, or are corrections of mistakes, will be prominently placed at the top of the article. These will also have the [Updated] tag at the front of the title.
Generally, in the latter two cases, if more than a short period of time has passed, we will send it out again to social media so that more people are exposed to the updated versions.
For TechRaptor to use an anonymous source, it must meet several criteria. First, the reason for anonymity must be out of fear for retribution or some other sort of harm if that source publicly released information with their name attached. Second, the anonymous source must have proprietary information that cannot be gathered elsewhere. Finally, the information must be vital to the news report and not merely contain speculation and/or opinion.
Further, the source's motivations for anonymity must be assessed. If their reason fails to meet our standards, that of putting oneself at serious risk if coming forward publicly, we will not use the source. TechRaptor will also evaluate how the information was obtained in an attempt to further verify its accuracy. If unable to adequately explain where or how they have/obtained the information, we will not use the source.
Only in rare instances will TechRaptor go forward with one source for a report. The case may be that the source is a high-ranking member of some organization that we can verify, which would put that source in a position to have detailed and accurate information. The same can be said for those with plenty of experience in a field. That will still be extremely rare, and TechRaptor will still attempt to get multiple sources for furthering the information's validity.
TechRaptor will also never use an anonymous source without 100% certainty of their identity, which we will keep private if the above criteria are met.
TechRaptor will also pursue avenues to validate the information with our own investigation. We will never leave an article to just the word of a few sources without first looking more into related evidence first.
TechRaptor runs advertising on the main website and its forums. Those ads are provided by the various ad networks that arrange advertising on the site. NSFW content, auto-play video, and sound ads are strictly prohibited, and if they are found, the ad network will be informed and asked to remove the offending ads.
TechRaptor does allow for sponsored articles and events. Such articles will be clearly outlined in the post with a tag of "Sponsored" on both the header image and as the listed author to ensure no confusion. No sponsored post will be accepted without these two criteria being agreed upon by the sponsor.
In all cases these articles must go through editorial and must be of value to the readership, and in many cases the articles will be written by a TechRaptor staff member. In cases where they do not meet the minimum standards for publishing we will refuse the sponsored post.
In order to create new and exciting content, as well as develop professional working relationships with people and companies in technology and gaming industries, TechRaptor staff will sometimes attend events around the world. At this time (April 2015), the limited budget of TechRaptor will sometimes help staff to pay for such events, but with approval of editorial and managerial staff – we may accept travel, lodging assistance, or meals paid for by the companies that we are working with so long as said arrangements are relevant to the stories we seek to cover. Having this flexibility allows TechRaptor and its staff to attend more events and meetings, as well as deliver more content throughout the year.
At this time, TechRaptor is able to sometimes help reimburse out-of-pocket expenses for staff members, but as we grow in both size and revenue, we plan to cover all expenses in the future.
If an event to be covered is a review event, TechRaptor will not accept any form of travel or accommodation. If we are to cover a review event, TechRaptor will pay for the staff member(s) to cover the event.
No staff member at TechRaptor is allowed to accept any personal gift from a developer, publisher, or PR agency that costs more than $60, nor are they allowed to take any form of cash. Should a gift greater than $60 be sent to a staff member, it becomes the property of TechRaptor, and management will determine whether said item(s) will be used in-house or for giveaways.
Any gifts that are sent to TechRaptor staff in an effort to sway coverage in any way will be denied, and should they reach the staff member, such gifts will immediately be given to the managing editor.
TechRaptor affiliates links through a variety of methods with different sites and at least one affiliate linking network (VigLink). These links are automatically affiliated, and nothing other than clicks is tracked by TechRaptor.
Affiliate links are added to all outbound links, and reviews are not affected by the fact that a game or product can be affiliated. Note: TechRaptor may sometimes do deal-heavy articles that include affiliate links, and will be labeled as such within the banner picture.
TechRaptor will sometimes conduct giveaways and contests on the website or social media. Giveaways will be done with keys or items or given to TechRaptor by staff, readers, or developers (extra codes and swag used for this purpose). For both website and social media giveaways, winners will be chosen with a random number generator.
Currently, TechRaptor accepts donations from our readers. This is handled by PayPal, Patreon, or Gratipay, and will be used for furthering TechRaptor's growth as well as writer payments and more.
Should TechRaptor determine that money was given to us by a developer in an effort to sway coverage for a game or product, we will make all efforts to return said donation in order to maintain professional distance from developers outside of sponsored posts.
TechRaptor staff members are expected to avoid any conflicts of interest, or in the event of a personal relationship, avoid coverage of a game or topic that said relationship might have an influence over. In regards to professional relationships, staff are expected to distance themselves from relationships that could alter their view on a product.
When it is deemed that the conflict of interest is minor, the staff member may continue as long as they publicly disclose the relationship. TechRaptor will never knowingly publish material where a discussion of conflict has occurred without publicly disclosing the nature of the conflict along with the material – even if that conflict is deemed inconsequential. When a conflict is deemed significant, another staff member will be assigned to the project.
Staff members interacting on Twitter or social media, or using a personal account to discuss a game or service is not considered a conflict of interest.
Any staff member who fails to disclose a conflict will be reprimanded accordingly.
TechRaptor staff members are allowed and encouraged to have personal social media and public profiles, as well as use them as they wish. Any opinions shared on said profiles are those of the staff member and separate from TechRaptor.
However, TechRaptor staff is not to use said profiles for harassment, libel, or discriminatory speech. Should a staff member violate these standards, action will be taken in regard to their conduct. Should the behavior continue, TechRaptor reserves the right to remove that staff member.
TechRaptor is pro-diversity, pro-equality, and strongly against any form of harassment, discrimination, or racism.
Staff members are encouraged to be active members of the video game industry, whether that be through public appearances in person, on another website, on a YouTube channel, or anything else of that nature on behalf of TechRaptor. Should a staff member make an appearance in a public event, they are expected to follow the conduct guidelines and represent the site in a good way.
TechRaptor staff are allowed and encouraged to comment and post on sites such as Reddit, Digg, forums, and more. In doing so, they are not to break the posting rules of those sites in order to gain more traffic to posts, or for any other dubious motives. They are expected to be upstanding members of any communities they should participate in.
Staff are not allowed to participate in TechRaptor giveaways, but are allowed to participate in any that have no relation to the site.
Yes, TechRaptor staff do indeed have a life outside of the site! As such, they have their own thoughts, feelings, blogs or YouTube channels – which means they will often share them and promote them outside of TechRaptor. With that said, those thoughts and opinions are not necessarily those of TechRaptor.
See the Social Media section for more information on acceptable conduct.
This Ethics Policy is under the Creative Commons Attribution-ShareAlike license, meaning that sites are welcome to use and edit our policy so long as proper attribution back to TechRaptor is given (link back to this policy with do-follow preferred). To see the details of this Creative Commons license, please visit this link.
Prior editions of our Ethics policy are also available under the same license, though you should link here.
If you'd like to use our policy, please email us at [email protected] and we'd be glad to give you any assistance you need, as well as add you to the list below of people using the policy.
If you feel our ethics and standards lack information or rules, or are wrong in any way, feel free to use the Contact Us page to sort the issue out. We're always looking to improve our practices!


text:
Q: Add datetime constraint to a PostgreSQL multi-column partial index I've got a PostgreSQL table called queries_query, which has many columns.
Two of these columns, created and user_sid, are frequently used together in SQL queries by my application to determine how many queries a given user has done over the past 30 days. It is very, very rare that I query these stats for any time older than the most recent 30 days.
Here is my question:
I've currently created my multi-column index on these two columns by running:
CREATE INDEX CONCURRENTLY some_index_name ON queries_query (user_sid, created)

But I'd like to further restrict the index to only care about those queries in which the created date is within the past 30 days. I've tried doing the following:
CREATE INDEX CONCURRENTLY some_index_name ON queries_query (user_sid, created)
WHERE created >= NOW() - '30 days'::INTERVAL`

But this throws an exception stating that my function must be immutable.
I'd love to get this working so that I can optimize my index, and cut back on the resources Postgres needs to do these repeated queries.

A: You get an exception using now() because the function is not IMMUTABLE (obviously) and, quoting the manual:

All functions and operators used in an index definition must be "immutable" ...

I see two ways to utilize a (much more efficient) partial index:
1. Partial index with condition using constant date:
CREATE INDEX queries_recent_idx ON queries_query (user_sid, created)
WHERE created > '2013-01-07 00:00'::timestamp;

Assuming created is actually defined as timestamp. It wouldn't work to provide a timestamp constant for a timestamptz column (timestamp with time zone). The cast from timestamp to timestamptz (or vice versa) depends on the current time zone setting and is not immutable. Use a constant of matching data type. Understand the basics of timestamps with / without time zone:

*

*Ignoring time zones altogether in Rails and PostgreSQL
Drop and recreate that index at hours with low traffic, maybe with a cron job on a daily or weekly basis (or whatever is good enough for you). Creating an index is pretty fast, especially a partial index that is comparatively small. This solution also doesn't need to add anything to the table.
Assuming no concurrent access to the table, automatic index recreation could be done with a function like this:
CREATE OR REPLACE FUNCTION f_index_recreate()
  RETURNS void
  LANGUAGE plpgsql AS
$func$
BEGIN
   DROP INDEX IF EXISTS queries_recent_idx;
   EXECUTE format('
      CREATE INDEX queries_recent_idx
      ON queries_query (user_sid, created)
      WHERE created > %L::timestamp'
    , LOCALTIMESTAMP - interval '30 days');  -- timestamp constant
--  , now() - interval '30 days');           -- alternative for timestamptz
END
$func$;

Call:
SELECT f_index_recreate();

now() (like you had) is the equivalent of CURRENT_TIMESTAMP and returns timestamptz. Cast to timestamp with now()::timestamp or use LOCALTIMESTAMP instead.

*

*Select today's (since midnight) timestamps only
db<>fiddle here
Old sqlfiddle

If you have to deal with concurrent access to the table, use DROP INDEX CONCURRENTLY and CREATE INDEX CONCURRENTLY. But you can't wrap these commands into a function because, per documentation:

... a regular CREATE INDEX command can be performed within a
transaction block, but CREATE INDEX CONCURRENTLY cannot.

So, with two separate transactions:
CREATE INDEX CONCURRENTLY queries_recent_idx2 ON queries_query (user_sid, created)
WHERE  created > '2013-01-07 00:00'::timestamp;  -- your new condition

Then:
DROP INDEX CONCURRENTLY IF EXISTS queries_recent_idx;

Optionally, rename to old name:
ALTER INDEX queries_recent_idx2 RENAME TO queries_recent_idx;

2. Partial index with condition on "archived" tag
Add an archived tag to your table:
ALTER queries_query ADD COLUMN archived boolean NOT NULL DEFAULT FALSE;

UPDATE the column at intervals of your choosing to "retire" older rows and create an index like:
CREATE INDEX some_index_name ON queries_query (user_sid, created)
WHERE NOT archived;

Add a matching condition to your queries (even if it seems redundant) to allow it to use the index. Check with EXPLAIN ANALYZE whether the query planner catches on - it should be able to use the index for queries on an newer date. But it won't understand more complex conditions not matching exactly.
You don't have to drop and recreate the index, but the UPDATE on the table may be more expensive than index recreation and the table gets slightly bigger.
I would go with the first option (index recreation). In fact, I am using this solution in several databases. The second incurs more costly updates.
Both solutions retain their usefulness over time, performance slowly deteriorates as more outdated rows are included in the index.