CleanSpeak's Advance Image Approval Queue


Image Moderation Just Got Faster

Image Approval Queue

As applications, websites and online communities continue to expand, user generated content becomes difficult to manage. Nonetheless, a moderation solution is critical for sites that rely on users to succeed. Companies often focus on filtering chat, URLs and personally identifiable information. It is important to remember that images can be just as harmful to a brand and its user community.

Uncensored images are making their way to children via various platforms due to deficient moderation or lack of moderation altogether. Seven out of ten youths have accidentally come across pornography online.

Continue reading

How To Filter Microsoft's Hitler-Loving AI

Kelly Strain

Microsoft apologizes after artificial intelligence experiment backfired. What could they have done differently?

Tay, marketed as “Microsoft’s AI fam from the internet that’s got zero chill,” candidly tweeted racist and sexist remarks confirming she in fact had “zero chill”. The chatbot was shut down within 24 hours of her introduction to the world after offending the masses.

Continue reading

Filtering Content - What you don’t know, will hurt you.

Kelly Strain

Podcast

A healthy and engaged online community is critical to a company’s success. This is a hot topic amongst CMGRs and top industry influentials and while most people can agree on the importance of a branded online community not all agree on the path to achieving this safe environment.

If you have an active online community, you already know that not every user is a good user. Trolls, bullies and URL spam inherently present problems and there will be consequences if you simply ignore the issue.

Continue reading

3 Trends Shaking Up App Development in 2016

Brian Pontarelli

3 trends shaking up app development in 2016

With the number of apps and mobile users projected to increase exponentially, developers who create the most advanced technology fastest will gain the competitive edge needed to stand out amongst competition.

The software industry is ever-changing. The field is highly dynamic, focused on building and changing the way we live, work and play. 2015 was a tumultuous year for developers.

IT was impacted by innovations from within as well as external factors, such as increased government regulations and cyber-crimes originating both in the U.S. and abroad.

Continue reading

PostgreSQL int to UUID

Brian Pontarelli
  • By Brian Pontarelli
  • Technology
  • September 23, 2015

I've been working to convert a bunch of our database columns from integers to UUIDs. I was having a hard time figuring out how to handle this conversion easily in PostgreSQL. For some reason, the PostgreSQL developers decided that the int data type was not converted to UUID automatically. This is somewhat shocking because both of these data types are binary types with different lengths (int being 4 and UUID being 16),. Since I couldn't submit a feature request and wait 2-3 years to have it implemented, I had to find a solution that worked in an SQL script easily.

After some playing around and hacking in sql, I figured out the solution. Here's a little snippet of my solution:

CREATE TABLE foo (
  id int
);

ALTER TABLE foo ADD COLUMN new_id UUID NULL;
UPDATE foo SET new_id = CAST(LPAD(TO_HEX(id), 32, '0') AS UUID);
ALTER TABLE foo DROP COLUMN id;
ALTER TABLE foo RENAME COLUMN new_id TO id;
ALTER TABLE foo ALTER COLUMN id SET NOT NULL;

The trick here is you need to convert the integer column to a hexadecimal string and then pad it with zeros. Since PostgreSQL happy converts strings to UUIDs, you can just cast the string to a UUID. Simple!

Continue reading
Tags: