hi Man hit by plane, killed on Austin-Bergstrom airport runway, officials say By news.yahoo.com Published On :: Fri, 08 May 2020 07:03:51 -0400 A person died Thursday night after being hit by a plane as it was landing at Austin-Bergstrom International Airport, according to airport officials. Full Article
hi US accuses China, Russia of coordinating on virus conspiracies By news.yahoo.com Published On :: Fri, 08 May 2020 20:21:56 -0400 The United States on Friday accused China and Russia of stepping up cooperation to spread false narratives over the coronavirus pandemic, saying Beijing was increasingly adopting techniques honed by Moscow. "Even before the COVID-19 crisis we assessed a certain level of coordination between Russia and the PRC in the realm of propaganda," said Lea Gabrielle, coordinator of the State Department's Global Engagement Center, which tracks foreign propaganda. The Global Engagement Center earlier said thousands of Russian-linked social media accounts were spreading conspiracies about the pandemic, including charging that the virus first detected last year in the Chinese metropolis of Wuhan was created by the United States. Full Article
hi Virginia Man Faked His Own Death in Ridiculously Elaborate Plot to Avoid Bankruptcy By news.yahoo.com Published On :: Thu, 07 May 2020 18:18:00 -0400 The wild plot involved faking his own death, stealing the identity of a Florida attorney, using an app to disguise his voice, and pretending to have prostate cancer, bone cancer, and a brain aneurysm.Unemployed Virginia man Russell Louis Geyer was so determined to hide his assets in bankruptcy proceedings, he even threw his own wife under the bus—duping her into handing over $70,000 and using her email address to inform an attorney he was dead. Geyer, 50, pleaded guilty on Wednesday to contempt of court, bankruptcy fraud, wire fraud, and aggravated identity fraud. He faces up to life in prison.“In an effort to game the bankruptcy system, Mr. Geyer devised a made-for-TV plot that ultimately collapsed under its own weight,” U.S. Attorney Thomas Cullen said in a statement.Minnesota Man Killed Wife, Buried Her Under Home, Then Faked Her Disappearance: Court DocsGeyer and his wife, Patricia Sue Geyer, from Saltville, filed for voluntary bankruptcy in late 2018, listing liabilities of $532,583.80, according to court documents.They were behind on payments for three of their four vehicles, for both their home and a rental property they owned, and for most of their furniture. They hadn’t paid electricity bills, bank overdrafts, credit card bills, and dozens of medical bills, and more than 50 creditors were chasing them for everything from their 65-inch TV to their Kawasaki ZX1000 motorbike. At one point in the bankruptcy proceedings, Geyer told his lawyer, John Lamie, he’d gone to the Mayo Clinic in Florida to be treated for prostate cancer, but it had spread to his bones and he intended to stop treatment.Four months later, according to a criminal complaint, he told Lamie he was now in a hospice in Florida after treatment failed. He said his wife was there, too, and had undergone bypass surgery for a heart condition. She wasn’t cleared to drive back to Virginia, he claimed.Then, a few days before September 5, 2019, when Geyer was due to appear in person at a bankruptcy hearing, Lamie received an email from Geyer’s wife. Her husband was dead, it said. He’d apparently had a brain aneurysm in June while being transported back from Florida after his chemotherapy treatments.Around the same time, Geyer’s attorney got a threatening email from an attorney in Florida who said he’d sold the assets that debtors were trying to recover in the bankruptcy case. “[Patricia] doesn’t know anything about this, and neither does Russell,” the email said. “I have complete control of Russell and told him to kill himself. You will not find him in time.” He ended the email by saying: “I am on a plane out of the country.”However, investigators later found that the Florida attorney whose name was used in the email existed but had nothing to do with the case. Geyer had simply set up a bogus email account using his name.‘Please Come Get Me’: Fatal Indianapolis Police Shooting May Have Aired on Facebook He even used the attorney’s identity to fleece his wife, a registered nurse who earned $3,200 a month, for $70,000. Geyer told his wife he’d won a $1 million settlement in Florida in an unrelated court case but needed her to pay $70,000 in legal fees for the money to be released. He used the bogus email address and an app that disguised his voice to pose as the Florida attorney and confirm the settlement was imminent. “It was all untrue,” the U.S. Attorney’s Office for the Western District of Virginia said in a statement on Thursday.The plot unraveled on Sept. 4, the day before the bankruptcy hearing, when a process server visited the couple’s Saltville home to give them a notice to appear.The home was empty but, just as the process server was leaving, Geyer and his wife arrived home in their car and got out—far from the Florida hospice he had claimed to be languishing in. The next day, Patricia Geyer, who said she’d largely let her husband deal with the bankruptcy case, left home to attend the court hearing about an hour after her husband. He never showed up.She told the court she had no idea about her husband’s wild story. She said they hadn’t been in Florida recently, she hadn’t had bypass surgery, and her husband didn’t have cancer. The first time she’d heard of her husband’s supposed death was two days earlier, when Lamie called her to say he’d heard about Geyer’s passing.“A few days ago, [Lamie] called me at work,” she said under cross-examination in court. “I got a message to call him. So I immediately called him and then he told me all this stuff about Russell being dead and all that. It just floored me, so I had no clue.”“Where’s Mr. Geyer now?” a judge asked her.“I couldn’t tell you, because he left the house this morning an hour, hour before me. And he was supposed to come down here and be here at 10:30, and then when I ended up here, he wasn't here. So I don’t know.” After that day in court, she only ever received text messages from Geyer saying he was in a hospital in West Virginia following a suicide attempt. Geyer was tracked down two weeks later and charged with criminal offenses. He underwent a psychiatric evaluation as part of the criminal case but was found to be competent to stand trial.“Despite its complexity and shameless use of deceit, including against his own wife, Mr. Geyer’s scheme failed to account for the FBI’s and the US Attorney’s office’s commitment to protect both fraud victims and our judicial system,” FBI Special Agent David W. Archey said.Read more at The Daily Beast.Got a tip? Send it to The Daily Beast hereGet our top stories in your inbox every day. Sign up now!Daily Beast Membership: Beast Inside goes deeper on the stories that matter to you. Learn more. Full Article
hi 'Never Seen Anything Like This': Experts Question Dropping of Flynn Prosecution By news.yahoo.com Published On :: Fri, 08 May 2020 08:25:08 -0400 WASHINGTON -- The Justice Department's decision to drop the criminal case against Michael Flynn, President Donald Trump's former national security adviser, even though he had twice pleaded guilty to lying to investigators, was extraordinary and had no obvious precedent, a range of criminal law specialists said Thursday."I've been practicing for more time than I care to admit and I've never seen anything like this," said Julie O'Sullivan, a former federal prosecutor who now teaches criminal law at Georgetown University.The move is the latest in a series that the department, under Attorney General William Barr, has taken to undermine and dismantle the work of the investigators and prosecutors who scrutinized Russia's 2016 election interference operation and its links to people associated with the Trump campaign.The case against Flynn for lying to the FBI about his conversations with the Russian ambassador was brought by the office of the former special counsel, Robert Mueller. It had become a political cause for Trump and his supporters, and the president had signaled that he was considering a pardon once Flynn was sentenced. But Barr instead abruptly short-circuited the case.On Thursday, Timothy Shea, the interim U.S. attorney in the District of Columbia, told the judge overseeing the case, Emmet G. Sullivan, that prosecutors were withdrawing the case. They were doing so, he said, because the department could not prove to a jury that Flynn's admitted lies to the FBI about his conversations with the ambassador were "material" ones.The move essentially erases Flynn's guilty pleas. Because he was never sentenced and the government is unwilling to pursue the matter further, the prosecution is virtually certain to end, although the judge must still decide whether to grant the department's request to dismiss it "with prejudice," meaning it could not be refiled in the future.A range of former prosecutors struggled to point to any previous instance in which the Justice Department had abandoned its own case after obtaining a guilty plea. They portrayed the justification Shea pointed to -- that it would be difficult to prove to a jury beyond a reasonable doubt that the lies were material -- as dubious."A pardon would have been a lot more honest," said Samuel Buell, a former federal prosecutor who now teaches criminal law at Duke University.The law regarding what counts as "material" is extremely forgiving to the government, Buell added. The idea is that law enforcement is permitted to pursue possible theories of criminality and to interview people without having firmly established that there was a crime first.James G. McGovern, a defense lawyer at Hogan Lovells and a former federal prosecutor, said juries rarely bought a defendant's argument that a lie did not involve a material fact."If you are arguing 'materiality,' you usually lose, because there is a tacit admission that what you said was untrue, so you lose the jury," he said.No career prosecutors signed the motion. Shea is a former close aide to Barr. In January, Barr installed him as the top prosecutor in the district that encompasses the nation's capital after maneuvering out the Senate-confirmed former top prosecutor in that office, Jessie K. Liu.Soon after, in an extraordinary move, four prosecutors in the office abruptly quit the case against Trump's longtime friend Roger Stone. They did so after senior Justice Department officials intervened to recommend a more lenient prison term than standard sentencing guidelines called for in the crimes Stone was convicted of committing -- including witness intimidation and perjury -- to conceal Trump campaign interactions with WikiLeaks.It soon emerged that Barr had also appointed an outside prosecutor, Jeff Jensen, the U.S. attorney in St. Louis, to review the Flynn case files. The department then began turning over FBI documents showing internal deliberations about questioning Flynn, like what warnings to give -- even though such files are usually not provided to the defense.Flynn's defense team has mined such files for ammunition to portray the FBI as running amok in its decision to question Flynn in the first place. The questioning focused on his conversations during the transition after the 2016 election with the Russian ambassador about the Obama administration's imposition of sanctions on Russia for its interference in the American election.The FBI had already concluded that there was no evidence that Flynn, a former Trump campaign adviser, had personally conspired with Russia about the election, and it had decided to close out the counterintelligence investigation into him. Then questions arose about whether and why Flynn had lied to administration colleagues like Vice President Mike Pence about his conversations with the ambassador.Because the counterintelligence investigation was still open, the bureau used it as a basis to question Flynn about the conversations and decided not to warn him at its onset that it would be a crime to lie. Notes from Bill Priestap, then the head of the FBI's counterintelligence division, show that he wrote at one point about the planned interview: "What's our goal? Truth/admission or to get him to lie, so we can prosecute him or get him fired?"Barr has also appointed another outside prosecutor, John H. Durham, the U.S. attorney in Connecticut, to reinvestigate the Russia investigators even though the department's independent inspector general was already scrutinizing them.And his department has intervened in a range of other ways, from seeking more comfortable prison accommodations last year for Paul Manafort, Trump's former campaign chairman, to abruptly dropping charges in March against two Russian shell companies that were about to go to trial for financing schemes to interfere in the 2016 election using social media.Barr has let it be known that he does not think the FBI ever had an adequate legal basis to open its Russia investigation in the first place, contrary to the judgment of the Justice Department's inspector general.In an interview on CBS News on Thursday, Barr defended the dropping of the charges against Flynn on the grounds that the FBI "did not have a basis for a counterintelligence investigation against Flynn at that stage."Anne Milgram, a former federal prosecutor and former New Jersey attorney general who teaches criminal law at New York University, defended the FBI's decision to question Flynn in January 2017. She said that much was still a mystery about the Russian election interference operation at the time and that Flynn's lying to the vice president about his postelection interactions with a high-ranking Russian raised new questions.But, she argued, the more important frame for assessing the dropping of the case was to recognize how it fit into the larger pattern of the Barr-era department "undercutting the law enforcement officials and prosecutors who investigated the 2016 election and its aftermath," which she likened to "eating the Justice Department from the inside out."This article originally appeared in The New York Times.(C) 2020 The New York Times Company Full Article
hi Coronavirus: China offers to help North Korea fight pandemic By news.yahoo.com Published On :: Sat, 09 May 2020 09:12:25 -0400 President Xi Jinping expresses concern about the threat to its neighbour, and offers to help. Full Article
hi Plastic shields in place, Dutch schools to reopen amid coronavirus By news.yahoo.com Published On :: Fri, 08 May 2020 11:15:05 -0400 At the Springplank school in the Dutch city of Den Bosch, staff have installed plastic shields around students' desks and disinfectant gel dispensers at the doorways as part of preparations to reopen amid the country's coronavirus outbreak. New infections in the Netherlands have been declining for weeks, and the government on Wednesday announced a schedule to relax some of its lockdown measures, with elementary schools to reopen on May 11. "Our teachers are not worried," said Rascha van der Sluijs, the school's technical coordinator. Full Article
hi Ex-husband of Biden accuser Tara Reade said she told him of being sexual harassed: report By news.yahoo.com Published On :: Fri, 08 May 2020 08:39:13 -0400 Biden has repeatedly denied Reade's allegation. Full Article
hi Coronavirus: Are these seven targets being hit? By www.bbc.co.uk Published On :: Wed, 06 May 2020 17:11:09 GMT Ministers have set targets for testing, medical equipment and hospital beds. Have they delivered? Full Article
hi Coronavirus R: Is this the crucial number? By www.bbc.co.uk Published On :: Fri, 08 May 2020 10:41:01 GMT The number at the heart of the decision whether to lift lockdown. Full Article
hi Coronavirus: 'Virus not beaten' but UK can think about next phase, says Raab By www.bbc.co.uk Published On :: Thu, 07 May 2020 16:50:06 GMT The Foreign Secretary says the prime minister will outline what steps the UK "can responsibly take over the following weeks." Full Article
hi Coronavirus: UK death toll passes Italy to be highest in Europe By www.bbc.co.uk Published On :: Tue, 05 May 2020 19:56:38 GMT The figure of 29,427 deaths is "a massive tragedy", the foreign secretary says, but steers clear of comparisons. Full Article
hi Coronavirus: Ministers launch hardship fund for dairy farmers By www.bbc.co.uk Published On :: Wed, 06 May 2020 20:55:26 GMT Demand for milk has dropped with the closure of cafes and restaurants during the coronavirus crisis. Full Article
hi Coronavirus: MP Nadia Whittome 'sacked' as carer after 'speaking out' about PPE By www.bbc.co.uk Published On :: Thu, 07 May 2020 08:06:17 GMT Nadia Whittome claims she was "sacked" but the care employer says she was no longer needed. Full Article
hi VE Day: How is it being celebrated this year? By www.bbc.co.uk Published On :: Thu, 07 May 2020 01:12:35 GMT Coronavirus means people are marking the 75th anniversary of VE Day from their own homes. Full Article
hi Winston Churchill's inspiring wartime speeches in Parliament By www.bbc.co.uk Published On :: Fri, 08 May 2020 13:06:45 GMT As his great grandson launches a competition to "inspire like Churchill", we look at the PM's wartime words. Full Article
hi Coronavirus: Photographers' children's lives in lockdown By www.bbc.co.uk Published On :: Wed, 06 May 2020 09:32:17 GMT Photographers who work for Unicef have taken candid shots of their children's lives during lockdown. Full Article
hi US shopping centres re-open: 'This is the best day ever' By www.bbc.co.uk Published On :: Wed, 06 May 2020 23:16:45 GMT In states like Texas, malls can operate at a 25% capacity and for some, it's a reason to get out of the house. Full Article
hi 'Definitely not the real thing': why eracers can't go from the bedroom to the cockpit By www.bbc.co.uk Published On :: Sat, 09 May 2020 10:28:03 GMT With more and more F1 drivers making the move to esports during the lockdown and doing well, could an expert sim racer easily make the leap the other way? Full Article
hi 'I feel fresher and healthier' - Hamilton enjoying parts of F1 break By www.bbc.co.uk Published On :: Sat, 09 May 2020 13:17:54 GMT Mercedes driver Lewis Hamilton says he feels certain benefits from his enforced time away from Formula 1. Full Article
hi Watford third team to oppose Premier League neutral venue proposals By www.bbc.co.uk Published On :: Sat, 09 May 2020 10:28:18 GMT Watford become the third team to publicly oppose the use of neutral venues when Premier League football returns. Full Article
hi Can robotaxis ease public transport fears in China? By www.bbc.co.uk Published On :: Fri, 08 May 2020 01:00:03 GMT More self-driving cabs are being launched in China at a time when people are worried about public transport. Full Article
hi Magician Roy Horn dies after catching coronavirus By www.bbc.co.uk Published On :: Sat, 09 May 2020 04:59:58 GMT He and his stage partner Siegfried Fischbacher were one of the longest-running acts in Las Vegas. Full Article
hi Coronavirus: China offers to help North Korea fight pandemic By www.bbc.co.uk Published On :: Sat, 09 May 2020 09:55:51 GMT President Xi Jinping expresses concern about the threat to its neighbour, and offers to help. Full Article
hi Coronavirus: Can live-streaming save China's economy? By www.bbc.co.uk Published On :: Tue, 05 May 2020 23:17:27 GMT In China, the live-streaming industry has become an important platform for economic recovery. Full Article
hi Coronavirus: NHS reveals source code behind contact-tracing app By www.bbc.co.uk Published On :: Thu, 07 May 2020 18:09:47 GMT More than 40,000 people have downloaded the contact tracing app so far, ahead of a wider release. Full Article
hi Things that more developers should know about databases By dbweekly.com Published On :: Fri, 24 Apr 2020 00:00:00 +0000 #301 — April 24, 2020 Read on the Web Database Weekly 'Things I Wished More Developers Knew About Databases' — A Google engineer (whose name may be familiar to those Go developers amongst you) shares 17 insights about databases she’s picked up over the years. I strongly recommend this piece and I identify with lots of the points myself.. Jaana B. Dogan Lambda Store: A New 'Serverless Redis' Service — This seems a neat idea. Claiming to not be just another Redis cloud service, Lambda Store applies a serverless-style pricing model which opens up a variety of neat use cases for the popular data structure server (serverless caching, for starters). The underlying system appears to be a custom clone of Redis rather than the real deal, however. Sven Anderson ???? AWS, GCP, & Azure Punch Back at the 2020 Cloud Report — AWS, GCP, & Azure each responded to the Cockroach Labs 2020 Cloud Report with instructions on how to tune their respective clouds for optimal performance. Cockroach Labs sponsor How io_uring and eBPF Will Revolutionize Programming in Linux — Even more exciting times are coming for development on Linux thanks to these technologies. A good overview from an engineer at ScyllaDB. Glauber Costa kvrocks: An Open Source, RocksDB-based, Redis-compatible Database — You know Redis’s API is good when so many projects continue to implement it for themselves. kvrocks brings the Redis API (with pretty good support) together with the RocksDB persistent key-value store. Written in C++. Bit Leak Mireo SpaceTime: An Absurdly Fast Spatiotemporal Database? — The SpaceTime database provides unprecedented analytical tools speed, sometimes outperforming other state-of-the-art solutions by three orders of magnitude. Miljen Mikić Cloud GPUs Aimed at Data Scientists — Core Scientific, an AI and cloud infrastructure vendor, is teaming with GPU-accelerated analytics specialist SQream Technologies to deliver a “GPU Cloud for Data Scientists.” Datanami An Easy Postgres 12 and pgAdmin 4 Setup with Docker — Docker provides an easy and loosely coupled way to get things set up in a development environment. Jonathan S. Katz Why We Index Everything — Tired of constantly managing indexes to speed up queries? Learn about how Rockset automatically indexes every field in a row-based store, column-based store, and search index. Rockset sponsor Redis Labs Moving RedisJSON to a New Codebase Written in Rust — RedisJSON provides a JSON data type to Redis and it’s been ported from C to Rust for better safety and developer experience. Gavrie Philipson (Redis Labs) Replicate Multiple Postgres Servers to a Single MongoDB Server using Logical Decoding Output Plugin David Zhang xsv: A Fast CSV Command Line Toolkit Written in Rust — Another ‘Swiss Army knife’ for your slightly structured data. Andrew Gallant ???? Jobs DevOps Engineer at X-Team (Remote) — Join the most energizing community for developers. Work from anywhere with the world's leading brands. X-Team Data Engineer (Remote - USA Only) — Help us architect and design “big data” systems which require queries returning within sub-second response times. Social Chorus Full Article
hi ‘Justice not charity’ - the blind marchers who made history By www.bbc.co.uk Published On :: Thu, 30 Apr 2020 11:40:33 GMT Remembering the maverick blind campaigners who walked to London a century ago to demand equality. Full Article
hi Coronavirus: Lockdown life 'a challenge' for vulnerable children By www.bbc.co.uk Published On :: Mon, 04 May 2020 19:59:02 GMT Charities warn some children who are missing out on additional support at school are falling into crisis. Full Article
hi Coronavirus schools return: Can you really keep children 2m apart? By www.bbc.co.uk Published On :: Wed, 06 May 2020 00:14:17 GMT What's it like in a school that has re-opened? Denmark and Germany show how it might look. Full Article
hi 'Tumbleweed tornado' hits US driver By www.bbc.co.uk Published On :: Fri, 01 May 2020 23:11:02 GMT An eerily beautiful dust devil flings picking up hundreds of tumbleweeds in Washington state. Full Article
hi ICYMI: Penguin chicks and new dining ideas By www.bbc.co.uk Published On :: Sat, 09 May 2020 10:43:24 GMT Some of the stories from around the world that you may have missed this week. Full Article
hi You got this. By www.zeldman.com Published On :: Wed, 22 May 2019 13:30:14 +0000 I’M LEARNING new tech and it’s hard. Maybe you’re in the same boat. Through the rosy lens of memory, learning HTML and Photoshop back in the day was a breeze. It wasn’t, really. And CSS, when it came along in 1996, was even tougher to grasp—in part because it was mostly theoretical, due to poor […] The post You got this. appeared first on Zeldman on Web & Interaction Design. Full Article business Career CSS Design Education maturity
hi A panel on accessibility, design inclusion and ethics, hiring and retaining diverse talent, and landing a job in UX. By www.zeldman.com Published On :: Thu, 05 Dec 2019 15:00:29 +0000 It’s one thing to seek diverse talent to add to your team, another to retain the people you’ve hired. Why do so many folks we bring in to add depth and breadth of experience to our design and business decision-making process end up leaving? Hear thoughtful, useful answers to this question and other mysteries of […] The post A panel on accessibility, design inclusion and ethics, hiring and retaining diverse talent, and landing a job in UX. appeared first on Zeldman on Web & Interaction Design. Full Article Accessibility Diversity video
hi The Whims By www.zeldman.com Published On :: Fri, 24 Apr 2020 13:45:42 +0000 One of my first professional jobs was at a tiny startup ad agency in Washington, DC. The owner was new to the business and made the mistake of hiring a college buddy as his creative director. This guy was not up to the job. He was not the slightest bit curious about our clients’ businesses, […] The post The Whims appeared first on Zeldman on Web & Interaction Design. Full Article Advertising Career Design glamorous Coronavirus ISeeWhatYouDidThere
hi An intro to making Postgres high availability on Kubernetes By postgresweekly.com Published On :: Wed, 15 Apr 2020 00:00:00 +0000 #351 — April 15, 2020 Read on the Web Postgres Weekly A Detailed Look at pg_show_plans — A few issues ago we linked to a basic introduction to pg_show_plans – this goes a little further. pg_show_plans lets you look at the execution plans of slow queries in real time as they’re being executed which can help you when troubleshooting. Kaarel Moppel Intersecting GPS Tracks to Identify Infected Individuals — I’m not a huge fan of COVID-19 related content, but this is a pretty interesting technique with numerous use cases. Essentially it uses PostGIS to identify overlapping paths. Florian Nadler Online Training: Learn PostgreSQL from Home — The remote PostgreSQL Database Administration training course is available at a discounted rate & will be conducted in two different timezones. The course covers day-to-day DBA operations, monitoring, server configurations, and more. 2ndQuadrant PostgreSQL Training sponsor PostgreSQL's 'Related Projects' — Thanks to Andreas Scherbaum for pointing out a new page on the Postgres site dedicated to projects related to Postgres like the code that runs the Postgres web site, mailing list, build farm, package management system, etc. PostgreSQL Global Development Group Authentication Configuration in Postgres (and CockroachDB) — In Postgres, client authentication can be controlled via a ‘HBA’ (host-based authentication) file. It’s not something we see covered very often, so you might find this interesting, particularly as it compares things against CockroachDB. Raphael ‘kena’ Poss ▶ Easy And Correct High Availability Postgres with Kubernetes — A 50 minute talk from PostgresOpen 2019 that goes all the way ‘from containers up’ until actually doing stuff with Postgres. Steven Pousty How To Set Up an Express API Backend Project With Postgres — A pretty extensive walkthrough of creating an HTTP API using Express with Node.js and Postgres on the backend, then deploying it all on Heroku. Chidi Orji A Beginners Guide to Basic Indexing in Postgres James Bannister eBook: The Most Important Events to Monitor in Your Postgres Logs — In this eBook, we are looking at the Top 6 Postgres log events for monitoring query performance and preventing downtime. pganalyze sponsor Documenting the Citus Extension to Postgres: An Interview with Joe Nelson — Joe, a.k.a. begriffs, talks about why he works on documentation, why the multi-tenant and real-time analytics tutorials matter, the INSERT..SELECT with repartitioning feature, and what development platform Citus uses for docs. Citus Data (Microsoft) Procedural vs Query Approaches for Finding Packages — Explorations of a query that can be used to display which packages are available for a given FreeBSD port. Get your head around the data model and the ideas here apply to all sorts of situations. Dan Langille ???? Upcoming Events All in-person events we had listed are cancelled or postponed due to the COVID outbreak, so we're now linking to webinars, livestreams, and similar online events. If you have any, just hit reply and if it's Postgres related (and either free or not too expensive) we'll include it in a future issue. Just one this week: ???? Date/Timestamp types in PostgreSQL with Andrew Dunstan and 2ndQuardrant on April 22 at 4pm UTC. ???? – requires e-mail address or registration???? – costs money to participate ???? Seen on Twitter Saw this tweet and thought it was a pretty neat reminder of the sorts of things we can do with Postgres. Justin kindly let us include it: Click through to the original tweet if you want to see the code better. Neat use for a generated column! Full Article
hi Medium-hard SQL questions to think about By postgresweekly.com Published On :: Wed, 6 May 2020 00:00:00 +0000 #354 — May 6, 2020 Read on the Web Postgres Weekly pgModeler: A Postgres Database Modeler — An easy way to create and edit database models in a visual way. It’s packaged up as a paid product but is also open source so you can build your own. Raphael Araújo e Silva The Best Medium-Hard Data Analyst SQL Interview Questions — This article begins with a quote: “The first 70% of SQL is pretty straightforward but the remaining 30% can be pretty tricky.” True! This article focuses on the tricky ‘medium-hard’ area that few tutorials venture into. Zachary Thomas Monitor Custom Postgres Metrics in Real-Time with Datadog — Monitor and visualize Postgres performance in context end-to-end alongside the rest of your stack. Create custom, drag-and-drop dashboards to quickly view analytics on any Postgres metric. Try Datadog free. Datadog sponsor My Favorite PostgreSQL Extensions: Part Two — The second part of a series we linked to last week. This time, Nawaz takes a look at pgAudit, pg_repack, and HypoPG. Nawaz Ahmed Backup Manifests and pg_verifybackup in Postgres 13 — Postgres 13 will introduce two features to enhance the automated validation of physical backups: backup manifests and a new tool called pg_verifybackup. Gabriele Bartolini arm64 Packages Now on apt.postgresql.org — If you’re running ARM64 hardware and Debian or Ubuntu, you can now install Postgres via apt. Christoph Berg Speeding Up count(*): Why Not Use max(id) - min(id)? — A warning tale in case you decide to take this shortcut. While you might be able to estimate or fudge a number that’s close, you can’t guarantee sequences will give you an exact, correct answer here. Hans-Jürgen Schönig Using Postgres for JSON Storage — With JSON and JSONB types and associated advanced ways to query such columns, using Postgres as a store for JSON data is pretty simple. This is the briefest of overviews but leads into an interactive online tutorial. Steve Pousty How to Migrate From Inheritance-Based Partitioning to Declarative Partitioning — Partitioning was introduced in Postgres 10 and Postgres 11 improved the declarative partitioning support. This article demonstrates a move from inheritance based partitioning to declarative partitioning using the native features found in Postgres 11+. Caterina Magini Free eBook: How to Get a 3x Performance Improvement on Your Postgres Database — Learn our best practices for optimizing Postgres query performance for customers like Atlassian and how to reduce data loaded from disk by 500x. pganalyze sponsor How to Backup Multiple Tablespaces with pg_basebackup Ahsan Hadi ▶ Security and Compliance with Postgres — A recorded webinar that 2ndQuadrant ran recently. Boriss Mejías Oracle to PostgreSQL: ANSI Outer Join Syntax in Postgres — The latest in a series of blog posts about migrating to Postgres from Oracle which looks at what Postgres offers in place of Oracle’s join operators. Kirk Roybal An Interview with 2ndQuadrant's Jimmy Angelakos — The latest ‘PostgreSQL Person of the Week’ to face questions about his experiences with Postgres. Andreas Scherbaum dadbod.vim: A Modern Database Interface for Vim — A Vim plugin for interacting with numerous databases, including Postgres. Tim Pope ???? Upcoming Online Events Postgres Pulse - weekly at 11am ET each Monday. Weekly Zoom-based sessions with folks like Bruce Momjian, Vibhor Kumar, and other people at EnterpriseDB. ???? Postgres Vision 2020 on June 23-24. A full attempt at an online Postgres conference across multiple days with multiple tracks. ???? – requires e-mail address or registration???? – costs money to participate Full Article
hi An interview with Ruby ETL expert Thibaut Barrère By rubyweekly.com Published On :: Thu, 30 Apr 2020 00:00:00 +0000 #499 — April 30, 2020 Read on the Web ???? Occasionally we run interviews in Ruby Weekly and we're back with another one.. with long time Rubyist and Kiba maintainer, Thibaut Barrère. Be sure to check out the bottom of this issue to read it, especially if you ever run ETL jobs with Ruby! ???? Ruby Weekly ▶ Let's Build a Twitter Clone in 10 Minutes with Rails, CableReady, and StimulusReflex — You know that cloning Twitter in 10 minutes is impossible, but what about the core mechanism of the idea? After a slow first minute, this video does a pretty good job of showing off some techniques you might not have used before. Nate Hopkins discuss.rubyonrails: The Rails Project Discussion Forum — Basically a Web version of the Rails mailing lists and a worthwhile place to head if you want to suggest features, ask questions, etc. Ruby on Rails Discussions Easy Rails Deployments — Deploy your Ruby, Rails, Sinatra, and Rack application to any cloud or server. Cloud 66 offers a scalable Heroku alternative that doesn't lock you in. Try it free and get extra $66 free credits with the code: 'Ruby-Weekly'. Cloud 66 sponsor sequel-activerecord-adapter: Allows Sequel to Reuse an ActiveRecord Connection — If you want to use more Sequel or migrate in that direction, this makes it easy. Janko Marohnić Ruby Adds Experimental Support for 'End-Less' Method Definitions — We’ve touched on this in a previous issue, but if you fancy a proper blog post with examples, this is more accessible than digging through feature tracker discussions. I’m not a fan of this syntax myself yet, but Prateek does a good job of selling it. Prateek Choudhary CableReady: Trigger Client-Side DOM Changes from Server-Side Ruby — If you skipped the video above because it’s a video (and I know many of you do ????) CableReady is still worth checking out. It aims to “complete the ActionCable story” by providing a way to directly interact with clients over ActionCable WebSockets. The docs will help you get the idea. Hopsoft ???? Jobs Find a Job Through Vettery — Vettery specializes in tech roles and is completely free for job seekers. Create a profile to get started. Vettery Security Engineer (Remote) — Are you an engineer with experience in Rails and/or Go? Join our team and help secure our apps and cloud infrastructure. Shogun ℹ️ Interested in running a job listing in Ruby Weekly? There's more info here. ???? Articles & Tutorials A Practical Use for PStore — PStore is one of the older parts of Ruby’s stdlib and lets you persist (and restore) a Ruby hash to disk. I haven’t seen it in Ruby code for years but Arkency have found a neat, modern use case. Paweł Pacana ▶ Drag and Drop Sortable Lists with Rails and Stimulus JS — How to wire up drag and drop lists with a Rails app using Sortable, Stimulus and acts_as_list. Go Rails Setting Up Multi-Factor Authentication for RubyGems.org — If you’re a registered user of the official Ruby Gems repository, you should have had an email this week about securing your account using 2FA. This is just my own reminder that this is a good idea especially if you publicly publish widely used gems! :-) Rubygems.org Let’s Explore Big-O Notation With Ruby ???? — Learn to use Big-O to look at an algorithm and easily discern its efficiency, without having to run a profiling tool. Honeybadger sponsor ▶ Discussing Docker and Kubernetes with Kelsey Hightower — A worthwhile show to listen to if Kubernetes and Docker intimidate you but you want to know a little more. Kelsey is good at breaking these things down into understandable pieces. Rails with Jason Podcast podcast Rails System Tests in Docker — We’re seeing an uptick in articles about system tests in Rails. Here’s how to integrate them into your development Docker setup. Hint.io The Difference Between System Specs and Feature Specs — If you’ve felt the difference between RSpec’s “feature specs” and “system specs” is quite subtle, this explanation will help. Jason Swett Why Rubyists Should Consider Learning Go — If you want compilation and a type system, Crystal is probably a better fit for Rubyists, but Go is undoubtedly a neat language and ecosystem (and if you do end up in the Go world, check out our Go weekly! ????) Ayooluwa Isaiah Building a Ruby CLI with Thor Daniel Gómez ???? Code and Tools git curate: Peruse and Delete git Branches Ergonomically — Got a repo cluttered with branches here and there? git curate aims to cure the pains of getting those branches back under control. Matt Harvey MessageBus: A Reliable and Robust Messaging Bus for Ruby and Rack Sam Saffron Are You Spending Too Much on Heroku? Rails Autoscale sponsor bootstrap_form: A Rails Form Builder for Bootstrap v4-Style Forms Bootstrap Ruby ActiveModelAttributes: The Active Record Attributes API, but for Active Model — Brings some of the goodies of the Rails 5 Active Record attributes API to ActiveModel too. 1.6.0 just dropped. Karol Galanciak ???? A Q&A with…Thibaut BarrèreCreator of Kiba ETL Thibaut Barrère is a long-time Rubyist and data engineer who built and maintains the popular Extract, Transform, and Load (ETL) framework Kiba. We asked him some questions about his work: What inspired you to create Kiba? A lot of my work since ~2005 has been focused on data integration (making systems speak together), data aggregation etc. I sometimes used GUI-based tools like Microsoft SSIS which, while powerful, are quite far from the coding experience. I was already using Ruby at that time, and was happy to discover activewarehouse-etl (maintained by Anthony Eden, who runs DNSimple now) providing a Ruby DSL to declare data pipelines. I used it for a while with very good success to implement data extractions and business intelligence ETL, and ultimately took over the maintenance. In the long run, though (as I explained in a recent Paris.rb talk), the balance between the the cost of OSS maintenance and the usability for my billable and non-billable use-cases proved to be not good enough, which made me decide to stop the maintenance, sadly. I still wanted to use Ruby to write data pipelines, but I needed to cover more use-cases and reduce the OSS maintenance burden at the same time. This ultimately led me to write and share (in 2015) Kiba ETL, a focused DSL for declarative processing, matching those criterias. Do you find yourself adding more features while in quarantine? Before the quarantine, I directed my Kiba bandwith and focus on finalizing Kiba v3 and rewriting the documentation from scratch, to properly encourage best practices I’ve been discovering. I also created experimental branches for Ruby 2.7/2.8 keywords. During the quarantine, I've reduced client work and OSS work too, to focus on shipping Kiba Pro v2 (which I’ll announce shortly officially). I’ve extracted and generalized (from real-life projects) very useful components, such as a “batch SQL lookup” (useful when replacing relationships keys during data migrations and datawarehouses sync code, in batch rather than row by row), a “file lock” to ensure a single job runs at once, and a “parallel transform” to achieve easy concurrency for things like HTTP queries. What's the wildest ETL that you've encountered? Getting the data out of a system which is actively not acting in that direction is always a bit wild.. One can see all types of fancy stuff on the field. For instance, it is not uncommon to have an ETL process start a headless browser, jump through pages, just to get to the CSV/PDF/Excel file that you will then use as your data source! You can also end up having to figure out ways to read or write very old file formats at times. Recently I wrote a Kiba component to generate a COBOL delimited file, for instance. In large companies, a very widely used I/O is good old SFTP, far away from modern APIs and formats. Can you tell us how to say your last name? ???? I had to deploy a page to my blog to answer that question properly ????. You’ll find out how to say my name here. Merci Thibaut! You can read some of Thibaut's posts on his blog and find out more about Kiba ETL here. Full Article
hi 'My search for the boy in a child abuse video' By www.bbc.co.uk Published On :: Sun, 08 Mar 2020 00:09:54 GMT Lucy Proctor was horrified when she was WhatsApped a sex abuse video. And she wanted to find out if the boy was safe. Full Article
hi Coronavirus: The month everything changed By www.bbc.co.uk Published On :: Sat, 28 Mar 2020 00:03:25 GMT In the space of a month, the United Kingdom has transformed beyond recognition. Full Article
hi Birth in a pandemic: 'You are stronger than you think' By www.bbc.co.uk Published On :: Tue, 31 Mar 2020 23:09:29 GMT Coronavirus is throwing many birth plans up in the air and leading some health trusts to increase home births. Full Article
hi The man who grew his own Amazon rainforest By www.bbc.co.uk Published On :: Wed, 01 Apr 2020 23:07:59 GMT Fighting back against destruction in the Amazon: how one man grew a rainforest of his own. Full Article
hi From patient to healer: How this woman is saving lives By www.bbc.co.uk Published On :: Wed, 08 Apr 2020 23:17:58 GMT Women who have overcome depression are running therapy sessions to help others Full Article
hi Coronavirus: Three perspectives on furloughing By www.bbc.co.uk Published On :: Tue, 07 Apr 2020 23:09:17 GMT Three people react to the furloughing scheme put in place in response to the coronavirus outbreak. Full Article
hi Coronavirus: How a plus-size fashion retailer is adapting By www.bbc.co.uk Published On :: Tue, 21 Apr 2020 22:55:43 GMT Ojoma Idegwu, founder of plus-size fashion label Dear Curves, explains how she is adapting to coronavirus. Full Article
hi Mexico receives ventilator shipment from US By www.bbc.co.uk Published On :: Wed, 06 May 2020 15:44:54 GMT The 211 machines were purchased from a US firm, Mexico's foreign minister said. Full Article
hi 2000 FIFA Club World Championship: Corinthians 0-0 Vasco da Gama (4-3 PSO) By www.fifa.com Published On :: Sun, 02 Dec 2012 23:18:00 GMT Corinthians-Vasco da Gama, FIFA Club World Cup Brazil 2000 Final: The all-Brazilian final had a plethora of familiar names - including legend Romario, Edmundo, Gilberto Melo, Ricardinho and Dida - and ended in a dramatic penalty shootout. Full Article Area=Tournament Section=Competition Kind=Video Tournament=FIFA Club World Championship Brazil 2000
hi 2012 Club World Cup Final: Corinthians 1-0 Chelsea By www.fifa.com Published On :: Mon, 17 Dec 2012 02:43:00 GMT Corinthians and Chelsea met in the FIFA Club World Cup Cup Japan 2012 final. Watch highlights from the match when the South American champions defeated their European counterparts. Full Article Area=Tournament Section=Competition Kind=Video Tournament=FIFA Club World Cup Japan 2012
hi Kashima Antlers 3-2 CD Guadalajara (UAE 2018) By www.fifa.com Published On :: Sat, 15 Dec 2018 16:36:00 GMT Losing finalists at the 2016 edition of the FIFA Club World Cup, Kashima Antlers defeated Mexico's CD Guadalajara to set up a semi-final against the team that beat them in that 2016 final, Real Madrid. Full Article Area=Tournament Section=Competition Kind=Match HL Tournament=FIFA Club World Cup UAE 2018
hi Kashima Antlers 0-4 River Plate (UAE 2018) By www.fifa.com Published On :: Sat, 22 Dec 2018 15:58:00 GMT River Plate ended their FIFA Club World Cup UAE 2018 campaign with an emphatic 4-0 victory over AFC Champions League holders Kashima Antlers. Full Article Area=Tournament Section=Competition Kind=Video Tournament=FIFA Club World Cup UAE 2018
hi Lincoln (R) of Brazil battles for the ball with Ibrahim Kane and Boubacar Haidara of Mali By www.fifa.com Published On :: Sat, 28 Oct 2017 13:08:00 GMT KOLKATA, INDIA - OCTOBER 28: Lincoln (R) of Brazil battles for the ball with Ibrahim Kane and Boubacar Haidara of Mali during the FIFA U-17 World Cup India 2017 3rd Place match between Brazil and Mali at Vivekananda Yuba Bharati Krirangan on October 28, 2017 in Kolkata, India. (Photo by Buda Mendes - FIFA/FIFA via Getty Images) Full Article Area=Tournament Section=Competition Kind=Photo Tournament=FIFA U-17 World Cup India 2017