Abstract. 

The article examines the process of import substitution of the Administrator-tor-D software package in the context of implementing support for the PostgreSQL open-source database management system in its client part. As part of the study, a universal DbClient module was developed in the C# programming language, which abstracts interaction with various types of databases (Microsoft SQL Server, PostgreSQL). Particular attention is paid to the technical aspects of this process. Test results are presented demonstrating the effectiveness of implementation and high performance of the developed solution.

Keywords: 

import substitution, database, PostgreSQL, Microsoft SQL Server, C#. 

DOI 10.14357/20718632250108 

EDN KHEVNJ

PP. 85-92.

References

1. Moiseeva V.V. Import substitution: problems and prospects in Russia. Moscow: Direct Media; 2016, 296 p. (In Russ). 

2. DB-Engines Ranking. Available from: https://dbengines.com/en/ranking [Accessed 12 November 2024]. 

3. PostgreSQL topped the world ranking of DBMS popularity growth and became the absolute leader among popular DBMS in Russia. Available from: https://www.cnews.ru/news/line/2024-01-09_postgresql_vozglavila_mirovoj [Accessed 12 November 2024]. (In Russ).

4. Shameel A. Migrate your SQL Server Workloads to PostgreSQL: Quick Reference: Second Edition. North Charleston: Independently Published; 2022, 159 p. 

5. Karpov, V.V. Import substitution in the field of information technology on the example of migration from DBMS "Oracle" to DBMS "PostgreSQL". In: V. V. Karpov, A. A. Ryndin. Management of socio-economic development of regions: problems and ways of their solution: collection of scientific articles of the 13th International scientific and practical conference. 23-24 June 2023, Kursk, Russia. Financial University under the Government of the Russian Federation, Kursk branch; 2023. P. 425-428. (In Russ).

6. "Is There Life" After Oracle – Database Import Substitution. Available from: https://www.zit.ru/news/analitika/detail/1054/ [Accessed 12 November 2024]. (In Russ).

7. Import substitution. Available from: https://www.keysystems.ru/products/importozameshchenie/importozameshchenie/ [Accessed 12 June 2024]. (In Russ).

8. Martyshyn S. A. Databases. Practical application of SQLand NoSOL-type DBMS for application of information systems design. Moscow: Forum; 2023, 368 p. (In Russ).

9. PostgreSQL C#: Connecting the PostgreSQL Database. Available from: https://www.postgresqltutorial.com/postgresql-csharp/postgresql-csharp-connect/ [Accessed 12 June 2024].

10. Npgsql - .NET Access to PostgreSQL. Available from: https://www.npgsql.org/ [Accessed 12 June 2024].

11. Voronchihin M.V., Galanina N.A. Using the “MigrationKS” software package to solve the problem of import substitution of a database. Information technologies. 2024;30(9):462-467 doi: 10.17587/it.30.462-467 (In Russ). 

12. Rogov E. PostgreSQL 15 from the inside. Moscow: DMK Press; 2023, 662 p. (In Russ).

13. Dombrovskaya H. Optimization of PostgreSQL queries. Moscow: DMK-Press; 2022, 278 p. (In Russ).

14. Voronchihin M.V., Galanina N.A. Translation of the “Administrative Practice” subcomplex, which is part of the Administrator-D information system, to the open source PostgreSQL DBMS. In: Voronchihin M.V., Galanina N.A. New competencies of digital reality: theory and practice of their development among students: collection. report and scientific Art. IV All-Russian scientific-practical Conf. 6 April 2023, Cheboksary, Russia. Chuvash Publishing House. Univ.; 2023. P. 91-96. (In Russ). 

15. Voronchihin M.V., Galanina N.A. Development of the report “Form 0510837. Statement of accrual of budget revenues” in the “Administrator-D” software package. In: Voronchihin M.V., Galanina N.A. Informatics and Computer Science: collection. scientific Trud. 2023, Cheboksary, Russia. Chuvash State University named after I.N. Ulyanov; 2023. P. 63-67. (In Russ).

16. Migration of an Oracle PL/SQL application to Postgres pl/pgSQL: a look two years later. Available from: https://pgconf.ru/media/2021/10/29/Anfinogenov%20Anatoly% 20-%20Migration%20Oracle%20PL%20SQL%20at%20Postgres% 20pl%20pgSQL%20look%20two%20years%20later.pdf [Accessed 12 June 2024]. (In Russ). 

17. Tarasov S.V. DBMS for a programmer. Databases from the inside. Moscow: SOLON-Press; 2015, 320 p. (In Russ).

18. Business is moving from foreign IT solutions to commercial Open Source. Available from: https://www.vedomosti.ru/technology/articles/2024/03/19/1026484-biznes-perehodit-na-kommercheskii-open-source [Accessed 12 June 2024]. (In Russ).