Redash – Connect to any data source, easily visualize and share your data

Join the chat at

Redash is our take on freeing the data within our company in a way that will better fit our culture and usage patterns.

Prior to Redash, we tried to use traditional BI suites and discovered a set of bloated, technically challenged and slow tools/flows. What we were looking for was a more hacker’ish way to look at data, so we built one.

Redash was built to allow fast and easy access to billions of records, that we process and collect using Amazon Redshift (“petabyte scale data warehouse” that “speaks” PostgreSQL).
Today Redash has support for querying multiple databases, including: Redshift, Google BigQuery, PostgreSQL, MySQL, Graphite,
Presto, Google Spreadsheets, Cloudera Impala, Hive and custom scripts.

Redash consists of two parts:

  1. Query Editor: think of JS Fiddle for SQL queries. It’s your way to share data in the organization in an open way, by sharing both the dataset and the query that generated it. This way everyone can peer review not only the resulting dataset but also the process that generated it. Also it’s possible to fork it and generate new datasets and reach new insights.
  2. Dashboards/Visualizations: once you have a dataset, you can create different visualizations out of it, and then combine several visualizations into a single dashboard. Currently it supports charts, pivot table and cohorts.


You can try out the demo instance: (login with any Google account).

Getting Started

Getting Help

Reporting Bugs and Contributing Code

US considers asking visa applicants their social media passwords

Part of U.S. President Trump’s plan to subject visitors to the United States to “extreme vetting” could be to ask them for passwords to their social media accounts, Homeland Security Chief John Kelly told a congressional hearing Tuesday.

“We’re looking at some enhanced or some additional screening. We may want to get on their social media, with passwords,” he said.

“It’s very hard to truly vet these people in these countries, the seven countries. But if they come in, we want to say, what websites do they visit, and give us your passwords. So we can see what they do on the internet.”

He also indicated that applicants would not be let in if they fail to cooperate.

While Kelly stressed that no final decision has been made, he did indicate that the Trump administration intends to make the screening process a lot tougher for those wishing to enter the U.S.



People can’t believe a supermarket is selling a single boxed strawberry for $22

As far as fruit packaging goes, this is perhaps the least Earth-friendly one by far.

A Hong Kong supermarket has come under fire from shoppers for carrying an elaborately packed single strawberry from Japan.

The strawberry, sold by the upscale CitySuper, is packaged in a box, nestled in a straw nest and fruit sock within. Its price tag? HKD $168 ($21.60).

The uproar started over the weekend, when a picture of the fruit was posted on Facebook.

It soon started making its way round social media.

CitySuper says that the strawberry was packaged this way by the Japanese supplier as a Valentine’s Day gift idea.

“The strawberry gift box was imported from Japan with its original packaging given its premium grade, rarity, and fragility for quality protection,” a spokesperson for the supermarket told the Hong Kong Free Press

The supermarket said that the strawberry’s high price was due to its cost price, logistical costs, market conditions and product exclusivity. 

The strawberry was air-flown from the city of Nara, Japan, and has been billed as a “rare” fruit with “good acidity and rich sweetness”. 

The uproar about the box comes amidst a petition by environmentalists in Hong Kong calling for less plastic packaging by supermarkets. The petition was launched in January and now has 7,917 signatures.

Environmentalists have also started a campaign, #trashthecheckout, to pressure the city’s supermarkets to reduce plastic packaging by removing plastic packaging from fruits and vegetables and leaving it at checkout counters:

Gary Stokes, who started the campaign, wrote in his Facebook post: “If everyone starts to #trashthecheckout then we can only hope that the supermarkets will start listening and begin to source their produce responsibly.”

Stokes, who is also Asia director for the Sea Shepherd Conservation Society, told the South China Morning Post that the “heavily packaged strawberry” reminded him “of something out of Mad Max — like it’s the last strawberry on Earth.” 

via Mashable!

J.K. Rowling’s response to this meme about her death is absolutely classic

LONDON — Sometimes, even the most well-meaning tributes can come across a bit odd.

Expressing the emotions you’ll feel when someone you admire dies, for instance, is totally fine. Tagging them in the meme you’ve created specifically to address that event, though — well, that might come across as a little strange.

On Tuesday night, J.K. Rowling shared the following meme on Twitter. 

“I won’t be offended if you untag me when making plans for my death.” Classic Rowling.

A short while later, a fan made the following observation.

Once again, Rowling busted out her trademark sass.

Being a celebrity on Twitter must a strange thing sometimes.

BONUS: J.K. Rowling weighs in hard on the Donald Trump/Meryl Streep feud

via Mashable!

Ireland to get social media watchdog

The Irish government is finalizing plans to create an independent watchdog authority responsible for keeping social media platforms accountable for online abuse.

Minister for Communications Denis Naughten will meet with ministerial colleagues next week to discuss the establishment of a new watchdog to monitor social media like Facebook and Twitter in their efforts to remove abusive content, bullying and harassment, the Irish Independent reported Tuesday.

The watchdog would be called the “Digital Safety Commissioner” and would produce a code of conduct for platforms to remove abusive content.

The minister proposing the plan suffered from online abuse by internet trolls when he had a bicycle accident early January, the paper reported.

The European Commission is considering drafting guidelines for internet platforms on how best to flag and remove abusive or illegal content. The measures, which likely won’t be legally binding, could be released as soon as this spring.



AWS to Take on the Likes of Cisco and Microsoft with Amazon Chime Video Teleconferencing Service

Amazon has been directly competing with the other SaaS (software as a service) services ever since it started with the Amazon Web Services (AWS). Today AWS has launched Amazon Chime, an enterprise offering that can be used for voice and video calls along with instant messaging. As one might have already figured out Amazon’s Chime will go at loggerheads with similar enterprise services like the Cisco WebEx. Also, the Chime will prove to be a competition for the Skype for Business from Microsoft which is based on the Azure public cloud.


The Amazon Chime is also expected to rival the Google GSuites and other smaller, but popular offerings including Slack and Dialpad. Amazon Chime will be available for Windows, Mac, Android and iOS apps and unlike the WebEx, it doesn’t require the users to punch in a PIN number. AWS has been fast paced when it comes to expanding its offering and previously they have announced a business intelligence suite called QuickSight, WorkMail and an email and Calendar service. Interestingly tools like Chime will also rival other smaller services like Zoom which are using AWS.

As of now, Amazon is offering a free edition of Chime. The Plus Edition with advanced user management and Active Directory (AD) support along with 1GB of message retention is priced at $2.50 per user per month. The Pro Edition, however, costs $15 per user per month and will include screen sharing and video chat that supports up to 100 users along with unlimited VoIP. Enterprise offerings seem to have become the area of focus for many companies and this only means that the other smaller offerings like Slack and other collaborating tools have a bigger rival to fend. That said Microsoft still seems to have an upper hand with its enterprise offerings but things don’t take long to change.

via Technically Personal!

Free Fonts With Personality And Style



The sharing spirit in the design community is remarkable. Designers spend countless hours on side projects and without asking for anything in return, they share their creations freely with the community. Just to give something back, to inspire and to support fellow folks in their work.

30 Free Fonts With Personality And Style

When working on a project yourself, freebies like these can come to the rescue when you have to get along on a tight budget, but, more often that that, they simply are the missing piece that’ll make your design complete.

The post Free Fonts With Personality And Style appeared first on Smashing Magazine.

via Smashing Magazine