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.

Downloads

Published

2018-06-22

Issue

No. 6 (2018)

Section

Technical Sciences

License

Copyright (c) 2018 Vadim Kozhevnikov, Oleg Sabinin, Yulia Shats

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

Our journal abides by the Creative Commons CC BY copyright rights and permissions for open access journals.

Authors, who are published in this journal, agree to the following conditions:

1. The authors reserve the right to authorship of the work and pass the first publication right of this work to the journal under the terms of a Creative Commons CC BY, which allows others to freely distribute the published research with the obligatory reference to the authors of the original work and the first publication of the work in this journal.

 2. The authors have the right to conclude separate supplement agreements that relate to non-exclusive work distribution in the form in which it has been published by the journal (for example, to upload the work to the online storage of the journal or publish it as part of a monograph), provided that the reference to the first publication of the work in this journal is included.