February 2017 - daangemist Blog

Excellent Article on chatbot best practices

Feb 26, 2017 daan

I have been working on chatbots for several months now, and this article I came across is a very good one. The 19 tips are really good en will definitely improve the quality of any chatbot you are building.

At Sabre Labs, we explore how exciting, up-and-coming technologies impact travel. Lately, one of these technologies has been conversational interfaces. We jumped on the chatbot bandwagon with enthusiasm last year, interacting with dozens of chatbots and building several prototypes of our own. Across our research and prototypes it became clear: we still have ways to go before “best practices” for conversational interfaces are established.

19 Best Practices for Building Chatbots

MySQL drop all tables in database using queries

Feb 10, 2017 daan

Tags: linux, mysql

During development I sometimes need to drop all tables in a database. When executed, all existing tables are dropped, so be careful executing it.

SET FOREIGN_KEY_CHECKS = 0;
SET GROUP_CONCAT_MAX_LEN=32768;
SET @tables = NULL;
SELECT GROUP_CONCAT('`', table_name, '`') INTO @tables
  FROM information_schema.tables
  WHERE table_schema = (SELECT DATABASE());
SELECT IFNULL(@tables,'dummy') INTO @tables;

SET @tables = CONCAT('DROP TABLE IF EXISTS ', @tables);
PREPARE stmt FROM @tables;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
SET FOREIGN_KEY_CHECKS = 1;

Via Stackoverflow