Pinned Loading

1. WinPass WinPass Public

   A unofficial KeePass password manager client, compatible with KeePass 2.x for desktop.

   C# 9 15

2. InstantUtilitiesBot InstantUtilitiesBot Public

   Instant utilities bot for Telegram. For example it uses duckduckgo Instant API.

   C# 2 2

3. GeorgianKeyboard GeorgianKeyboard Public

   Georgian Keyboard for WP7

   JavaScript 1 1

4. Remote database server backup of all... Remote database server backup of all databases (all schemes) with mysqldump example with comments. And restore command with retained comments in procedures (for example).)

   1

   #!/bin/bash

   2

   3

   # For example: https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html 

   4

   # --no-data Do not dump table contents

   5

   # --triggers Do add triggers too

5. MySQL catch exception and log it int... MySQL catch exception and log it into another table for example.

   1

   # CREATE PROCEDURE AND OTHER DECLARE STATEMENTS HERE

   2

   # ....

   3

   4

   DECLARE EXIT HANDLER FOR SQLEXCEPTION

   5

   BEGIN

6. Grant all procedures that were chang... Grant all procedures that were changed TODAY (or other date as parameter) in any database (as parameter) for any user (as parameter). Works for MariaDB too.

   1

   ---------------------------------------------

   2

   -- Creates procedure that takes schema/user/modificationFromDate as parameters and calls it for some schema/user/today in the end. This works for MariaDB too.

   3

   4

   -- Example of grant as concat select

   5

   -- SELECT CONCAT('GRANT EXECUTE ON PROCEDURE YOUR_SCHEMA.', routine_name, ' TO user@`10.1.%`;') FROM information_schema.routines where routine_schema = 'YOUR_SCHEMA'  AND ROUTINE_TYPE = 'PROCEDURE';