Modern messengers as the assistant of the database administrator

Authors

  • Vadim Kozhevnikov Peter the Great St. Petersburg Polytechnic University Polytechnicheskaya str., 29, Saint Petersburg, Russian Federation, 195251, Russian Federation https://orcid.org/0000-0001-5986-0820
  • Oleg Sabinin Peter the Great St. Petersburg Polytechnic University Polytechnicheskaya str., 29, Saint Petersburg, Russian Federation, 195251, Russian Federation https://orcid.org/0000-0001-6065-2690
  • Yulia Shats Peter the Great St. Petersburg Polytechnic University Polytechnicheskaya str., 29, Saint Petersburg, Russian Federation, 195251, Russian Federation https://orcid.org/0000-0003-2591-9622

DOI:

https://doi.org/10.15587/2313-8416.2018.134769

Keywords:

Bot, Java, messengers, Slack, Facebook, Telegram, databases, PostgreSQL, statistics, database administration

Abstract

This article considers usage of modern messengers and their capabilities by database administrators. The process of creating a bot, which allows the administrator to receive timely notifications about problems and errors that occurred with the database, as well as receive usage statistics, are described. The main difference from other similar products is the implementation for instant messengers, which are currently popular. The article provides a description of the development using platforms Telegram, Facebook Messenger and Slack, based on a single library

Author Biographies

Vadim Kozhevnikov, Peter the Great St. Petersburg Polytechnic University Polytechnicheskaya str., 29, Saint Petersburg, Russian Federation, 195251

Senior Lecturer

Department of Computer Intelligent Technologies

Oleg Sabinin, Peter the Great St. Petersburg Polytechnic University Polytechnicheskaya str., 29, Saint Petersburg, Russian Federation, 195251

Associate Professor

Department of Computer Intelligent Technologies

Yulia Shats, Peter the Great St. Petersburg Polytechnic University Polytechnicheskaya str., 29, Saint Petersburg, Russian Federation, 195251

Department of Computer Intelligent Technologies

References

Drake, J., Worsley, J. (2002). Practical PostgreSQL. O'Reilly Media, Inc., 640.

Introduction to Push Notifications (2018). Google Developers. Available at: https://developers.google.com/web/ilt/pwa/introduction-to-push-notifications

Telegram Bot API. Telegram. Available at: https://core.telegram.org/bots/api

Slack Developers Documentation (2018). Slack. Available at: https://slack.com/developers

Documentation Facebook (2018). Facebook for Developers. Available at: https://developers.facebook.com/docs/messenger-platform

Duffy, J., Moore, B. (2018). The Best Business Messaging Apps of 2018. PCMAG. Available at: https://www.pcmag.com/roundup/355674/the-best-team-messaging-apps

Most popular messaging apps 2018 (2018). Statista. Available at: https://www.statista.com/statistics/258749/most-popular-global-mobile-messenger-apps/

Smith, L. (2015). What PostgreSQL has over other open source SQL databases: Part I. Compose Articles. Available at: https://www.compose.com/articles/what-postgresql-has-over-other-open-source-sql-databases/

Smith, L. (2015). What PostgreSQL has over other open source SQL databases: Part II. Compose Articles. Available at: https://www.compose.com/articles/what-postgresql-has-over-other-open-source-sql-databases-part-ii/

Riggs, S., Ciolli, G., Bartolini, G., Krosing, H. (2015). PostgreSQL 9 Administration Cookbook. Packt Publishing, 504.

Putano, B. (2017). Most Popular and Influential Programming Languages of 2018. Stackify. Available at: https://stackify.com/popular-programming-languages-2018/

Kozhevnikov, V. A., Sabinin, O. Y., Shats, J. E. (2017). Library Development for Creating Bots on Slack, Telegram and Facebook Messengers. Theoretical & Applied Science, 50 (6), 59–62. doi: http://doi.org/10.15863/tas.2017.06.50.4

O’Brien, T., Van Zyl, J. (2009). Maven: The Definitive Guide. O’Reilly Media, Inc., 250.

Published

2018-06-22

Issue

Section

Technical Sciences