{"id":75449,"date":"2025-05-07T15:30:26","date_gmt":"2025-05-07T12:30:26","guid":{"rendered":"https:\/\/foxminded.ua\/?p=75449"},"modified":"2025-05-07T15:35:33","modified_gmt":"2025-05-07T12:35:33","slug":"android-sqlite","status":"publish","type":"post","link":"https:\/\/foxminded.ua\/ru\/android-sqlite\/","title":{"rendered":"Android SQLite"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Android \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u043e\u0434\u043d\u043e\u0439 \u0438\u0437 \u0441\u0430\u043c\u044b\u0445 \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u044b\u0445 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0441\u0438\u0441\u0442\u0435\u043c \u0434\u043b\u044f \u043c\u043e\u0431\u0438\u043b\u044c\u043d\u044b\u0445 \u0443\u0441\u0442\u0440\u043e\u0439\u0441\u0442\u0432, \u0447\u0442\u043e \u0434\u0435\u043b\u0430\u0435\u0442 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0443 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0439 \u043d\u0430 \u044d\u0442\u043e\u0439 \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u0435 \u0430\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u043e\u0439 \u0438 \u0432\u0430\u0436\u043d\u043e\u0439 \u0434\u043b\u044f \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0441\u0442\u043e\u0432 \u0438 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0439. \u0421\u0440\u0435\u0434\u0438 \u043c\u043d\u043e\u0436\u0435\u0441\u0442\u0432\u0430 \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u043e\u0432, \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u044b\u0445 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0430\u043c, android sqlite \u0437\u0430\u043d\u0438\u043c\u0430\u0435\u0442 \u043e\u0441\u043e\u0431\u043e\u0435 \u043c\u0435\u0441\u0442\u043e \u0431\u043b\u0430\u0433\u043e\u0434\u0430\u0440\u044f \u0441\u0432\u043e\u0435\u0439 \u043f\u0440\u043e\u0441\u0442\u043e\u0442\u0435, \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u043e\u0441\u0442\u0438 \u0438 \u043b\u0435\u0433\u043a\u043e\u0441\u0442\u0438 \u0438\u043d\u0442\u0435\u0433\u0440\u0430\u0446\u0438\u0438 \u0432 Android-\u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f. SQLite \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u0441\u043e\u0431\u043e\u0439 \u043b\u0435\u0433\u043a\u043e\u0432\u0435\u0441\u043d\u0443\u044e \u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u0443\u044e \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0430\u043c \u0443\u043f\u0440\u0430\u0432\u043b\u044f\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \u043d\u0430 \u043b\u043e\u043a\u0430\u043b\u044c\u043d\u043e\u043c \u0443\u0440\u043e\u0432\u043d\u0435. \u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f <a href=\"https:\/\/foxminded.ua\/\">FoxmindEd<\/a> \u0430\u043a\u0442\u0438\u0432\u043d\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442 SQLite \u0432 \u0441\u0432\u043e\u0438\u0445 \u043f\u0440\u043e\u0435\u043a\u0442\u0430\u0445, \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432\u0430\u044f \u043d\u0430\u0434\u0435\u0436\u043d\u043e\u0435 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u0438 \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 \u0434\u043b\u044f \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 \u0441\u0432\u043e\u0438\u0445 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0439.<\/p>\n\n\n    <div class=\"adv_block\">\r\n        <div class=\"top_text\">\ud83d\ude80 \u0413\u043e\u0442\u043e\u0432\u044b \u043f\u043e\u0433\u0440\u0443\u0437\u0438\u0442\u044c\u0441\u044f \u0432 \u043c\u0438\u0440 Android \u0441 <a href=\"https:\/\/foxminded.ua\/ru\/android-1\/\">\u043d\u0430\u0448\u0438\u043c \u043e\u043d\u043b\u0430\u0439\u043d-\u043a\u0443\u0440\u0441\u043e\u043c<\/a>?\r\n\r\n\ud83d\udc49 \u0421\u043c\u0435\u043b\u043e \u043f\u0435\u0440\u0435\u0445\u043e\u0434\u0438\u0442\u0435 \u043a \u0440\u0435\u0433\u0438\u0441\u0442\u0440\u0430\u0446\u0438\u0438 \ud83d\udc47\ud83d\udc47\ud83d\udc47<\/div>\r\n        \r\n        <a href=\"https:\/\/foxminded.ua\/ru\/android-1\/\" class=\"adv_block_btn btn btn-primary\">\r\n            \u0420\u0435\u0433\u0438\u0441\u0442\u0440\u0430\u0446\u0438\u044f        <\/a>\r\n    <\/div>\r\n\n\n\n<h2 class=\"wp-block-heading\">\u0427\u0442\u043e \u0442\u0430\u043a\u043e\u0435 SQLite \u0432 Android?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">SQLite \u2014 \u044d\u0442\u043e \u0432\u0441\u0442\u0440\u0430\u0438\u0432\u0430\u0435\u043c\u0430\u044f \u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u0430\u044f \u0431\u0430\u0437\u0430 \u0434\u0430\u043d\u043d\u044b\u0445, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0430\u043c \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u043e \u0443\u043f\u0440\u0430\u0432\u043b\u044f\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \u0432 Android-\u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f\u0445. \u0415\u0435 \u043e\u0441\u043d\u043e\u0432\u043d\u0430\u044f \u0444\u0443\u043d\u043a\u0446\u0438\u044f \u0437\u0430\u043a\u043b\u044e\u0447\u0430\u0435\u0442\u0441\u044f \u0432 \u0442\u043e\u043c, \u0447\u0442\u043e\u0431\u044b \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432\u0430\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u043e\u0435 \u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0435 \u0434\u043b\u044f \u0434\u0430\u043d\u043d\u044b\u0445, \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044f \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0442\u044c \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0438 \u0447\u0442\u0435\u043d\u0438\u044f \u0438 \u0437\u0430\u043f\u0438\u0441\u0438 \u0431\u0435\u0437 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0441\u0442\u0438 \u043e\u0431\u0440\u0430\u0449\u0435\u043d\u0438\u044f \u043a \u0443\u0434\u0430\u043b\u0435\u043d\u043d\u044b\u043c \u0441\u0435\u0440\u0432\u0435\u0440\u0430\u043c. \u0411\u043b\u0430\u0433\u043e\u0434\u0430\u0440\u044f \u0441\u0432\u043e\u0435\u0439 \u043c\u0430\u043b\u043e\u0439 \u0440\u0430\u0437\u043c\u0435\u0440\u043d\u043e\u0441\u0442\u0438 \u0438 \u0432\u044b\u0441\u043e\u043a\u043e\u0439 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438, SQLite \u0438\u0434\u0435\u0430\u043b\u044c\u043d\u043e \u043f\u043e\u0434\u0445\u043e\u0434\u0438\u0442 \u0434\u043b\u044f \u043c\u043e\u0431\u0438\u043b\u044c\u043d\u044b\u0445 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0439, \u0433\u0434\u0435 \u0440\u0435\u0441\u0443\u0440\u0441\u044b \u0443\u0441\u0442\u0440\u043e\u0439\u0441\u0442\u0432\u0430 \u043c\u043e\u0433\u0443\u0442 \u0431\u044b\u0442\u044c \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u044b. \u0411\u0435\u0437\u0443\u0441\u043b\u043e\u0432\u043d\u043e, \u044d\u0442\u0430 \u0442\u0435\u0445\u043d\u043e\u043b\u043e\u0433\u0438\u0447\u0435\u0441\u043a\u0430\u044f \u043e\u0441\u043d\u043e\u0432\u0430 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0441\u043e\u0437\u0434\u0430\u0442\u044c \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f, \u0441\u043f\u043e\u0441\u043e\u0431\u043d\u044b\u0435 \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0434\u0430\u0436\u0435 \u0432 \u0443\u0441\u043b\u043e\u0432\u0438\u044f\u0445 \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u043d\u043e\u0433\u043e \u0438\u043d\u0442\u0435\u0440\u043d\u0435\u0442-\u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u044f, \u0447\u0442\u043e \u0434\u0435\u043b\u0430\u0435\u0442 \u0435\u0435 \u043d\u0435\u043e\u0442\u044a\u0435\u043c\u043b\u0435\u043c\u043e\u0439 \u0447\u0430\u0441\u0442\u044c\u044e \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043d\u0430 <a href=\"https:\/\/foxminded.ua\/android-1\/\">Android<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0438 \u0441 SQLite \u0432 Android<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">SQLite \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0430\u043c \u0440\u044f\u0434 \u0431\u0430\u0437\u043e\u0432\u044b\u0445 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0439 \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0441 \u0434\u0430\u043d\u043d\u044b\u043c\u0438, \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044f \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0442\u044c \u0432\u0441\u0442\u0430\u0432\u043a\u0443, \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 \u0438 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0437\u0430\u043f\u0438\u0441\u0435\u0439 \u0432 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445. \u042d\u0442\u0438 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0438 \u044f\u0432\u043b\u044f\u044e\u0442\u0441\u044f \u0444\u0443\u043d\u0434\u0430\u043c\u0435\u043d\u0442\u0430\u043b\u044c\u043d\u044b\u043c\u0438 \u0434\u043b\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0438\u043d\u0442\u0435\u0440\u0430\u043a\u0442\u0438\u0432\u043d\u044b\u0445 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0439, \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044f \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f\u043c \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u043e \u0443\u043f\u0440\u0430\u0432\u043b\u044f\u0442\u044c \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0435\u0439. \u0420\u0430\u0431\u043e\u0442\u0430\u044f \u0441 SQLite, \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0438 \u043c\u043e\u0433\u0443\u0442 \u0431\u044b\u0441\u0442\u0440\u043e \u0438 \u043f\u0440\u043e\u0441\u0442\u043e \u043c\u0430\u043d\u0438\u043f\u0443\u043b\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u043c\u0438, \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432\u0430\u044f \u043f\u043b\u0430\u0432\u043d\u043e\u0441\u0442\u044c \u0438 \u043e\u0442\u0437\u044b\u0432\u0447\u0438\u0432\u043e\u0441\u0442\u044c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u0441\u043a\u043e\u0433\u043e \u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441\u0430. \u041a\u0430\u0436\u0434\u0430\u044f \u0438\u0437 \u044d\u0442\u0438\u0445 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0439 \u0438\u043c\u0435\u0435\u0442 \u0441\u0432\u043e\u0438 \u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e\u0441\u0442\u0438 \u0438 \u0442\u0440\u0435\u0431\u0443\u0435\u0442 \u0432\u043d\u0438\u043c\u0430\u0442\u0435\u043b\u044c\u043d\u043e\u0433\u043e \u043f\u043e\u0434\u0445\u043e\u0434\u0430, \u0447\u0442\u043e\u0431\u044b \u0438\u0437\u0431\u0435\u0436\u0430\u0442\u044c \u043f\u043e\u0442\u0435\u043d\u0446\u0438\u0430\u043b\u044c\u043d\u044b\u0445 \u043e\u0448\u0438\u0431\u043e\u043a \u0438 \u0433\u0430\u0440\u0430\u043d\u0442\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0446\u0435\u043b\u043e\u0441\u0442\u043d\u043e\u0441\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u0445.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">android sqlite insert<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0435\u0440\u0430\u0446\u0438\u044f android sqlite insert \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u043e\u0434\u043d\u043e\u0439 \u0438\u0437 \u0441\u0430\u043c\u044b\u0445 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0445 \u0438 \u0447\u0430\u0441\u0442\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u043c\u044b\u0445 \u043f\u0440\u0438 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0435 Android-\u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0439. \u041e\u043d\u0430 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0442\u044c \u043d\u043e\u0432\u044b\u0435 \u0437\u0430\u043f\u0438\u0441\u0438 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445, \u0437\u0430 \u0441\u0447\u0435\u0442 \u0447\u0435\u0433\u043e \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043c\u043e\u0436\u0435\u0442 \u0441\u043e\u0445\u0440\u0430\u043d\u044f\u0442\u044c \u0432\u0430\u0436\u043d\u0443\u044e \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044e. \u041f\u0440\u043e\u0446\u0435\u0441\u0441 \u0432\u0441\u0442\u0430\u0432\u043a\u0438 \u0434\u043e\u0432\u043e\u043b\u044c\u043d\u043e \u043f\u0440\u043e\u0441\u0442 \u0438 \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u043e \u0443\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0447\u0435\u0440\u0435\u0437 \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u044b\u0439 \u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441 SQLite, \u0447\u0442\u043e \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0430\u043c \u043b\u0435\u0433\u043a\u043e \u0438\u043d\u0442\u0435\u0433\u0440\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u044d\u0442\u0443 \u0444\u0443\u043d\u043a\u0446\u0438\u043e\u043d\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0432 \u0441\u0432\u043e\u0438 \u043f\u0440\u043e\u0435\u043a\u0442\u044b.<\/p>\n\n\n    <div class=\"adv_courses_links\">\r\n        <div class=\"adv_courses_wrap\">\r\n            <div class=\"top_block\">\r\n                <span>FoxmindEd<\/span> &#8212; \u044d\u0442\u043e \u0443\u0447\u0435\u0431\u043d\u044b\u0439 \u0446\u0435\u043d\u0442\u0440 \u0441 \u0431\u043e\u043b\u044c\u0448\u0438\u043c \u0432\u044b\u0431\u043e\u0440\u043e\u043c \u043d\u0430\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0439 \u043a\u0443\u0440\u0441\u043e\u0432 \u0434\u043b\u044f \u043d\u043e\u0432\u0438\u0447\u043a\u043e\u0432 \u0438 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0441\u0442\u043e\u0432 \u0441 \u043e\u043f\u044b\u0442\u043e\u043c!            <\/div>\r\n            <div class=\"adv_courses_link\">\r\n                <span>\u041d\u0430\u0447\u0438\u043d\u0430\u0435\u0442\u0435 \u0441\u0432\u043e\u0439 \u043f\u0443\u0442\u044c \u0432 I\u0422?<\/span> \u041f\u043e\u043f\u0440\u043e\u0431\u0443\u0439\u0442\u0435 <a href=\"https:\/\/foxminded.ua\/ru\/start-course-2\/\">\u0441\u0442\u0430\u0440\u0442\u043e\u0432\u044b\u0435 IT-\u043a\u0443\u0440\u0441\u044b<\/a>            <\/div>\r\n            <div class=\"adv_courses_link\">\r\n                <span>\u0418\u043c\u0435\u0435\u0442\u0435 \u0431\u0430\u0437\u043e\u0432\u044b\u0435 \u043d\u0430\u0432\u044b\u043a\u0438 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f?<\/span> \u0422\u043e\u0433\u0434\u0430 \u0432\u0430\u043c \u043d\u0430 <a href=\"https:\/\/foxminded.ua\/ru\/junior-course\/\">\u043a\u0443\u0440\u0441\u044b \u0444\u043e\u0440\u043c\u0430\u0442\u0430 \u041c\u0435\u043d\u0442\u043e\u0440\u0438\u043d\u0433<\/a>            <\/div>\r\n            <div class=\"adv_courses_link\">\r\n                <span>\u0425\u043e\u0442\u0438\u0442\u0435 \u0443\u0433\u043b\u0443\u0431\u0438\u0442\u044c \u0441\u0432\u043e\u0438 \u0437\u043d\u0430\u043d\u0438\u044f \u0432 I\u0422?<\/span> \u0423 \u043d\u0430\u0441 \u0435\u0441\u0442\u044c <a href=\"https:\/\/foxminded.ua\/ru\/advanced-courses\/\">\u043a\u0443\u0440\u0441\u044b \u0434\u043b\u044f middle\/senior<\/a>            <\/div>\r\n        <\/div>\r\n    <\/div>\r\n\n\n\n<h3 class=\"wp-block-heading\">android sqlite update<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">android sqlite update \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0430\u043c \u0438\u0437\u043c\u0435\u043d\u044f\u0442\u044c \u0443\u0436\u0435 \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u044e\u0449\u0438\u0435 \u0437\u0430\u043f\u0438\u0441\u0438, \u0447\u0442\u043e \u043a\u0440\u0438\u0442\u0438\u0447\u0435\u0441\u043a\u0438 \u0432\u0430\u0436\u043d\u043e \u0434\u043b\u044f \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0430\u043d\u0438\u044f \u0430\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0438 \u0432 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f\u0445. \u042d\u0442\u0430 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u044f \u043f\u043e\u043c\u043e\u0433\u0430\u0435\u0442 \u0438\u0441\u043f\u0440\u0430\u0432\u043b\u044f\u0442\u044c \u043e\u0448\u0438\u0431\u043a\u0438 \u0438 \u0443\u0447\u0438\u0442\u044b\u0432\u0430\u0442\u044c \u043d\u043e\u0432\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435, \u0447\u0442\u043e, \u0431\u0435\u0437\u0443\u0441\u043b\u043e\u0432\u043d\u043e, \u0443\u043b\u0443\u0447\u0448\u0430\u0435\u0442 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u0441\u043a\u0438\u0439 \u043e\u043f\u044b\u0442. \u0412\u0430\u0436\u043d\u043e \u0443\u0434\u0435\u043b\u0438\u0442\u044c \u0432\u043d\u0438\u043c\u0430\u043d\u0438\u0435 \u043f\u0440\u0430\u0432\u0438\u043b\u044c\u043d\u043e\u0439 \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u0430\u0446\u0438\u0438 \u043b\u043e\u0433\u0438\u043a\u0438 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f, \u0447\u0442\u043e\u0431\u044b \u0438\u0437\u0431\u0435\u0436\u0430\u0442\u044c \u043a\u043e\u043d\u0444\u043b\u0438\u043a\u0442\u0430 \u0437\u0430\u043f\u0438\u0441\u0435\u0439 \u0438 \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0442\u044c \u0446\u0435\u043b\u043e\u0441\u0442\u043d\u043e\u0441\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u0445.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">android sqlite delete<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Android sqlite delete \u2014 \u0432\u0430\u0436\u043d\u044b\u0439 \u0430\u0441\u043f\u0435\u043a\u0442 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0435\u0439 \u0432 Android-\u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f\u0445. \u042d\u0442\u0430 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u044f \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0430\u043c \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432\u0430\u0442\u044c \u0447\u0438\u0441\u0442\u043e\u0442\u0443 \u0434\u0430\u043d\u043d\u044b\u0445, \u0443\u0434\u0430\u043b\u044f\u044f \u043d\u0435\u043d\u0443\u0436\u043d\u044b\u0435 \u0438\u043b\u0438 \u0443\u0441\u0442\u0430\u0440\u0435\u0432\u0448\u0438\u0435 \u0437\u0430\u043f\u0438\u0441\u0438. \u041d\u0435\u0441\u043c\u043e\u0442\u0440\u044f \u043d\u0430 \u0441\u0432\u043e\u044e \u043f\u0440\u043e\u0441\u0442\u043e\u0442\u0443, \u043f\u0440\u043e\u0446\u0435\u0441\u0441 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u044f \u0442\u0440\u0435\u0431\u0443\u0435\u0442 \u0430\u043a\u043a\u0443\u0440\u0430\u0442\u043d\u043e\u0433\u043e \u043f\u043e\u0434\u0445\u043e\u0434\u0430, \u043f\u043e\u0441\u043a\u043e\u043b\u044c\u043a\u0443 \u043d\u0435\u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0443\u044e\u0449\u0435\u0435 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u043c\u043e\u0436\u0435\u0442 \u043f\u0440\u0438\u0432\u0435\u0441\u0442\u0438 \u043a \u043f\u043e\u0442\u0435\u0440\u0435 \u0432\u0430\u0436\u043d\u043e\u0439 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0438. \u0412\u0430\u0436\u043d\u043e \u0432\u043d\u0435\u0434\u0440\u044f\u0442\u044c \u0434\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0435 \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0438, \u0447\u0442\u043e\u0431\u044b \u0433\u0430\u0440\u0430\u043d\u0442\u0438\u0440\u043e\u0432\u0430\u0442\u044c, \u0447\u0442\u043e \u0442\u043e\u043b\u044c\u043a\u043e \u043d\u0443\u0436\u043d\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u0431\u0443\u0434\u0443\u0442 \u0443\u0434\u0430\u043b\u0435\u043d\u044b.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u041f\u0440\u0430\u043a\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0435 \u043f\u0440\u0438\u043c\u0435\u0440\u044b \u0440\u0430\u0431\u043e\u0442\u044b \u0441 SQLite \u0432 Android<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">SQLite \u2014 \u044d\u0442\u043e \u043c\u043e\u0449\u043d\u044b\u0439 \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442 \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u043c\u043e\u0431\u0438\u043b\u044c\u043d\u044b\u0445 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f\u0445. \u041d\u0438\u0436\u0435 \u043c\u044b \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u043f\u0440\u0430\u043a\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0445 \u0441\u0446\u0435\u043d\u0430\u0440\u0438\u0435\u0432, \u0433\u0434\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 SQLite \u043c\u043e\u0436\u0435\u0442 \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e \u0443\u043b\u0443\u0447\u0448\u0438\u0442\u044c \u0444\u0443\u043d\u043a\u0446\u0438\u043e\u043d\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u044c Android-\u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0439.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u0446\u0435\u043d\u0430\u0440\u0438\u0439 1: \u0425\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0438\u0441\u0430\u043d\u0438\u0435: \u0412 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f\u0445, \u0433\u0434\u0435 \u0442\u0440\u0435\u0431\u0443\u0435\u0442\u0441\u044f \u0440\u0435\u0433\u0438\u0441\u0442\u0440\u0430\u0446\u0438\u044f \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439, \u043c\u043e\u0436\u043d\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c SQLite \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u0441\u043a\u0438\u0445 \u0434\u0430\u043d\u043d\u044b\u0445, \u0442\u0430\u043a\u0438\u0445 \u043a\u0430\u043a \u0438\u043c\u044f, \u044d\u043b\u0435\u043a\u0442\u0440\u043e\u043d\u043d\u0430\u044f \u043f\u043e\u0447\u0442\u0430 \u0438 \u043f\u0430\u0440\u043e\u043b\u044c.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u041f\u0440\u0438\u043c\u0435\u0440 \u043a\u043e\u0434\u0430<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u0445 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"public class UserDbHelper extends SQLiteOpenHelper {\n\n\u00a0\u00a0\u00a0\u00a0private static final String DATABASE_NAME = &quot;userdatabase.db&quot;;\n\n\u00a0\u00a0\u00a0\u00a0private static final int DATABASE_VERSION = 1;\n\n\u00a0\u00a0\u00a0\u00a0public static final String TABLE_USER = &quot;users&quot;;\n\n\u00a0\u00a0\u00a0\u00a0public static final String COLUMN_ID = &quot;id&quot;;\n\n\u00a0\u00a0\u00a0\u00a0public static final String COLUMN_NAME = &quot;name&quot;;\n\n\u00a0\u00a0\u00a0\u00a0public static final String COLUMN_EMAIL = &quot;email&quot;;\n\n\u00a0\u00a0\u00a0\u00a0public static final String COLUMN_PASSWORD = &quot;password&quot;;\n\n\u00a0\u00a0\u00a0\u00a0public UserDbHelper(Context context) {\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0super(context, DATABASE_NAME, null, DATABASE_VERSION);\n\n\u00a0\u00a0\u00a0\u00a0}\n\n\u00a0\u00a0\u00a0\u00a0@Override\n\n\u00a0\u00a0\u00a0\u00a0public void onCreate(SQLiteDatabase db) {\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0String CREATE_USER_TABLE = &quot;CREATE TABLE &quot; + TABLE_USER + &quot;(&quot;\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0+ COLUMN_ID + &quot; INTEGER PRIMARY KEY AUTOINCREMENT,&quot;\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0+ COLUMN_NAME + &quot; TEXT,&quot;\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0+ COLUMN_EMAIL + &quot; TEXT,&quot;\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0+ COLUMN_PASSWORD + &quot; TEXT&quot; + &quot;)&quot;;\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0db.execSQL(CREATE_USER_TABLE);\n\n\u00a0\u00a0\u00a0\u00a0}\n\n\u00a0\u00a0\u00a0\u00a0@Override\n\n\u00a0\u00a0\u00a0\u00a0public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0db.execSQL(&quot;DROP TABLE IF EXISTS &quot; + TABLE_USER);\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0onCreate(db);\n\n\u00a0\u00a0\u00a0\u00a0}\n\n}\" style=\"color:#90A4AE;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki material-theme-lighter\" style=\"background-color: #FAFAFA\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #90A4AE\">public <\/span><span style=\"color: #9C3EDA\">class<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #E2931D\">UserDbHelper<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #9C3EDA\">extends<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #E2931D\">SQLiteOpenHelper<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #39ADB5\">{<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #90A4AE\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #9C3EDA\">private<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #9C3EDA\">static<\/span><span style=\"color: #90A4AE\"> final String <\/span><span style=\"color: #E53935\">DATABASE_NAME<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #39ADB5\">=<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #91B859\">userdatabase.db<\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #90A4AE\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #9C3EDA\">private<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #9C3EDA\">static<\/span><span style=\"color: #90A4AE\"> final int <\/span><span style=\"color: #E53935\">DATABASE_VERSION<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #39ADB5\">=<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #F76D47\">1<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #90A4AE\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #9C3EDA\">public<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #9C3EDA\">static<\/span><span style=\"color: #90A4AE\"> final String <\/span><span style=\"color: #E53935\">TABLE_USER<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #39ADB5\">=<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #91B859\">users<\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #90A4AE\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #9C3EDA\">public<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #9C3EDA\">static<\/span><span style=\"color: #90A4AE\"> final String <\/span><span style=\"color: #E53935\">COLUMN_ID<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #39ADB5\">=<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #91B859\">id<\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #90A4AE\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #9C3EDA\">public<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #9C3EDA\">static<\/span><span style=\"color: #90A4AE\"> final String <\/span><span style=\"color: #E53935\">COLUMN_NAME<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #39ADB5\">=<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #91B859\">name<\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #90A4AE\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #9C3EDA\">public<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #9C3EDA\">static<\/span><span style=\"color: #90A4AE\"> final String <\/span><span style=\"color: #E53935\">COLUMN_EMAIL<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #39ADB5\">=<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #91B859\">email<\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #90A4AE\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #9C3EDA\">public<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #9C3EDA\">static<\/span><span style=\"color: #90A4AE\"> final String <\/span><span style=\"color: #E53935\">COLUMN_PASSWORD<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #39ADB5\">=<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #91B859\">password<\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #90A4AE\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #9C3EDA\">public<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #E53935\">UserDbHelper<\/span><span style=\"color: #39ADB5\">(<\/span><span style=\"color: #90A4AE; font-style: italic\">Context<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #90A4AE; font-style: italic\">context<\/span><span style=\"color: #39ADB5\">)<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #39ADB5\">{<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #90A4AE\">super<\/span><span style=\"color: #E53935\">(<\/span><span style=\"color: #90A4AE\">context<\/span><span style=\"color: #39ADB5\">,<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">DATABASE_NAME<\/span><span style=\"color: #39ADB5\">,<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">null,<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">DATABASE_VERSION<\/span><span style=\"color: #E53935\">)<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #39ADB5\">}<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #90A4AE\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #39ADB5\">@<\/span><span style=\"color: #90A4AE\">Override<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #90A4AE\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #9C3EDA\">public<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #39ADB5\">void<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #E53935\">onCreate<\/span><span style=\"color: #39ADB5\">(<\/span><span style=\"color: #90A4AE; font-style: italic\">SQLiteDatabase<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #90A4AE; font-style: italic\">db<\/span><span style=\"color: #39ADB5\">)<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #39ADB5\">{<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #90A4AE\">String<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">CREATE_USER_TABLE<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">=<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #91B859\">CREATE TABLE <\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">+<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">TABLE_USER<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">+<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #91B859\">(<\/span><span style=\"color: #39ADB5\">&quot;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #39ADB5\">+<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">COLUMN_ID<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">+<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #91B859\"> INTEGER PRIMARY KEY AUTOINCREMENT,<\/span><span style=\"color: #39ADB5\">&quot;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #39ADB5\">+<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">COLUMN_NAME<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">+<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #91B859\"> TEXT,<\/span><span style=\"color: #39ADB5\">&quot;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #39ADB5\">+<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">COLUMN_EMAIL<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">+<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #91B859\"> TEXT,<\/span><span style=\"color: #39ADB5\">&quot;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #39ADB5\">+<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">COLUMN_PASSWORD<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">+<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #91B859\"> TEXT<\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">+<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #91B859\">)<\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #90A4AE\">db<\/span><span style=\"color: #39ADB5\">.<\/span><span style=\"color: #6182B8\">execSQL<\/span><span style=\"color: #E53935\">(<\/span><span style=\"color: #90A4AE\">CREATE_USER_TABLE<\/span><span style=\"color: #E53935\">)<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #39ADB5\">}<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #90A4AE\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #39ADB5\">@<\/span><span style=\"color: #90A4AE\">Override<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #90A4AE\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #9C3EDA\">public<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #39ADB5\">void<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #E53935\">onUpgrade<\/span><span style=\"color: #39ADB5\">(<\/span><span style=\"color: #90A4AE; font-style: italic\">SQLiteDatabase<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #90A4AE; font-style: italic\">db<\/span><span style=\"color: #39ADB5\">,<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #90A4AE; font-style: italic\">int<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #90A4AE; font-style: italic\">oldVersion<\/span><span style=\"color: #39ADB5\">,<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #90A4AE; font-style: italic\">int<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #90A4AE; font-style: italic\">newVersion<\/span><span style=\"color: #39ADB5\">)<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #39ADB5\">{<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #90A4AE\">db<\/span><span style=\"color: #39ADB5\">.<\/span><span style=\"color: #6182B8\">execSQL<\/span><span style=\"color: #E53935\">(<\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #91B859\">DROP TABLE IF EXISTS <\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">+<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">TABLE_USER<\/span><span style=\"color: #E53935\">)<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #6182B8\">onCreate<\/span><span style=\"color: #E53935\">(<\/span><span style=\"color: #90A4AE\">db<\/span><span style=\"color: #E53935\">)<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #39ADB5\">}<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #39ADB5\">}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f \u0432 \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"public void addUser(String name, String email, String password) {\n\n\u00a0\u00a0\u00a0\u00a0SQLiteDatabase db = this.getWritableDatabase();\n\n\u00a0\u00a0\u00a0\u00a0ContentValues values = new ContentValues();\n\n\u00a0\u00a0\u00a0\u00a0values.put(COLUMN_NAME, name);\n\n\u00a0\u00a0\u00a0\u00a0values.put(COLUMN_EMAIL, email);\n\n\u00a0\u00a0\u00a0\u00a0values.put(COLUMN_PASSWORD, password);\n\n\u00a0\u00a0\u00a0\u00a0db.insert(TABLE_USER, null, values);\n\n\u00a0\u00a0\u00a0\u00a0db.close();\n\n}\" style=\"color:#90A4AE;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki material-theme-lighter\" style=\"background-color: #FAFAFA\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #90A4AE\">public <\/span><span style=\"color: #39ADB5\">void<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #6182B8\">addUser<\/span><span style=\"color: #90A4AE\">(String name<\/span><span style=\"color: #39ADB5\">,<\/span><span style=\"color: #90A4AE\"> String email<\/span><span style=\"color: #39ADB5\">,<\/span><span style=\"color: #90A4AE\"> String password) <\/span><span style=\"color: #39ADB5\">{<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #90A4AE\">SQLiteDatabase<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">db<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">=<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">this.<\/span><span style=\"color: #6182B8\">getWritableDatabase<\/span><span style=\"color: #E53935\">()<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #90A4AE\">ContentValues<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">values<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">=<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">new<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #6182B8\">ContentValues<\/span><span style=\"color: #E53935\">()<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #90A4AE\">values<\/span><span style=\"color: #39ADB5\">.<\/span><span style=\"color: #6182B8\">put<\/span><span style=\"color: #E53935\">(<\/span><span style=\"color: #90A4AE\">COLUMN_NAME<\/span><span style=\"color: #39ADB5\">,<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">name<\/span><span style=\"color: #E53935\">)<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #90A4AE\">values<\/span><span style=\"color: #39ADB5\">.<\/span><span style=\"color: #6182B8\">put<\/span><span style=\"color: #E53935\">(<\/span><span style=\"color: #90A4AE\">COLUMN_EMAIL<\/span><span style=\"color: #39ADB5\">,<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">email<\/span><span style=\"color: #E53935\">)<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #90A4AE\">values<\/span><span style=\"color: #39ADB5\">.<\/span><span style=\"color: #6182B8\">put<\/span><span style=\"color: #E53935\">(<\/span><span style=\"color: #90A4AE\">COLUMN_PASSWORD<\/span><span style=\"color: #39ADB5\">,<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">password<\/span><span style=\"color: #E53935\">)<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #90A4AE\">db<\/span><span style=\"color: #39ADB5\">.<\/span><span style=\"color: #6182B8\">insert<\/span><span style=\"color: #E53935\">(<\/span><span style=\"color: #90A4AE\">TABLE_USER<\/span><span style=\"color: #39ADB5\">,<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">null,<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">values<\/span><span style=\"color: #E53935\">)<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #90A4AE\">db<\/span><span style=\"color: #39ADB5\">.<\/span><span style=\"color: #6182B8\">close<\/span><span style=\"color: #E53935\">()<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #39ADB5\">}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u0431\u044a\u044f\u0441\u043d\u0435\u043d\u0438\u0435: \u041c\u044b \u0441\u043e\u0437\u0434\u0430\u0435\u043c \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u0445 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439, \u0430 \u0437\u0430\u0442\u0435\u043c \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c \u043c\u0435\u0442\u043e\u0434 \u0434\u043b\u044f \u0432\u0441\u0442\u0430\u0432\u043a\u0438 \u043d\u043e\u0432\u043e\u0439 \u0437\u0430\u043f\u0438\u0441\u0438. \u042d\u0442\u043e \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0435 \u0445\u0440\u0430\u043d\u0438\u0442\u044c \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u044e \u043e \u043a\u0430\u0436\u0434\u043e\u043c \u0437\u0430\u0440\u0435\u0433\u0438\u0441\u0442\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e\u043c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u0421\u0446\u0435\u043d\u0430\u0440\u0438\u0439 2: \u041a\u044d\u0448\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u043f\u0438\u0441\u0430\u043d\u0438\u0435: \u0415\u0441\u043b\u0438 \u0432\u0430\u0448\u0435 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0435 \u0438\u0437\u0432\u043b\u0435\u043a\u0430\u0435\u0442 \u0434\u0430\u043d\u043d\u044b\u0435 \u0438\u0437 \u0432\u0435\u0431-\u0441\u0435\u0440\u0432\u0438\u0441\u0430, \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c SQLite \u0434\u043b\u044f \u043a\u044d\u0448\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u044d\u0442\u0438\u0445 \u0434\u0430\u043d\u043d\u044b\u0445, \u0447\u0442\u043e\u0431\u044b \u0443\u043c\u0435\u043d\u044c\u0448\u0438\u0442\u044c \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u0438 \u043f\u043e\u0432\u044b\u0441\u0438\u0442\u044c \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u041f\u0440\u0438\u043c\u0435\u0440 \u043a\u043e\u0434\u0430<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">\u0421\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"public void cacheData(String jsonData) {\n\n\u00a0\u00a0\u00a0\u00a0SQLiteDatabase db = this.getWritableDatabase();\n\n\u00a0\u00a0\u00a0\u00a0ContentValues values = new ContentValues();\n\n\u00a0\u00a0\u00a0\u00a0values.put(&quot;data&quot;, jsonData);\n\n\u00a0\u00a0\u00a0\u00a0db.insert(&quot;cache_table&quot;, null, values);\n\n\u00a0\u00a0\u00a0\u00a0db.close();\n\n}\" style=\"color:#90A4AE;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki material-theme-lighter\" style=\"background-color: #FAFAFA\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #90A4AE\">public <\/span><span style=\"color: #39ADB5\">void<\/span><span style=\"color: #90A4AE\"> <\/span><span style=\"color: #6182B8\">cacheData<\/span><span style=\"color: #90A4AE\">(String jsonData) <\/span><span style=\"color: #39ADB5\">{<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #90A4AE\">SQLiteDatabase<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">db<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">=<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">this.<\/span><span style=\"color: #6182B8\">getWritableDatabase<\/span><span style=\"color: #E53935\">()<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #90A4AE\">ContentValues<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">values<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">=<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">new<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #6182B8\">ContentValues<\/span><span style=\"color: #E53935\">()<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #90A4AE\">values<\/span><span style=\"color: #39ADB5\">.<\/span><span style=\"color: #6182B8\">put<\/span><span style=\"color: #E53935\">(<\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #91B859\">data<\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #39ADB5\">,<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">jsonData<\/span><span style=\"color: #E53935\">)<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #90A4AE\">db<\/span><span style=\"color: #39ADB5\">.<\/span><span style=\"color: #6182B8\">insert<\/span><span style=\"color: #E53935\">(<\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #91B859\">cache_table<\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #39ADB5\">,<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">null,<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">values<\/span><span style=\"color: #E53935\">)<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #90A4AE\">db<\/span><span style=\"color: #39ADB5\">.<\/span><span style=\"color: #6182B8\">close<\/span><span style=\"color: #E53935\">()<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #39ADB5\">}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u0417\u0430\u0433\u0440\u0443\u0437\u043a\u0430 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0437 \u043a\u044d\u0448\u0430:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" data-code=\"public String loadCache() {\n\n\u00a0\u00a0\u00a0\u00a0SQLiteDatabase db = this.getReadableDatabase();\n\n\u00a0\u00a0\u00a0\u00a0Cursor cursor = db.query(&quot;cache_table&quot;, new String[]{&quot;data&quot;}, null, null, null, null, null);\n\n\u00a0\u00a0\u00a0\u00a0if (cursor != null &amp;&amp; cursor.moveToFirst()) {\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0String data = cursor.getString(0);\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0cursor.close();\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return data;\n\n\u00a0\u00a0\u00a0\u00a0}\n\n\u00a0\u00a0\u00a0\u00a0return null;\n\n}\" style=\"color:#90A4AE;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki material-theme-lighter\" style=\"background-color: #FAFAFA\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #90A4AE\">public String <\/span><span style=\"color: #6182B8\">loadCache<\/span><span style=\"color: #90A4AE\">() <\/span><span style=\"color: #39ADB5\">{<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #90A4AE\">SQLiteDatabase<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">db<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">=<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">this.<\/span><span style=\"color: #6182B8\">getReadableDatabase<\/span><span style=\"color: #E53935\">()<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #90A4AE\">Cursor<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">cursor<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">=<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">db<\/span><span style=\"color: #39ADB5\">.<\/span><span style=\"color: #6182B8\">query<\/span><span style=\"color: #E53935\">(<\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #91B859\">cache_table<\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #39ADB5\">,<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">new<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">String<\/span><span style=\"color: #E53935\">[]<\/span><span style=\"color: #39ADB5\">{<\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #E53935\">data<\/span><span style=\"color: #39ADB5\">&quot;<\/span><span style=\"color: #39ADB5\">},<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">null,<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">null,<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">null,<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">null,<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">null<\/span><span style=\"color: #E53935\">)<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #39ADB5; font-style: italic\">if<\/span><span style=\"color: #E53935\"> (<\/span><span style=\"color: #90A4AE\">cursor<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">!=<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">null<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">&amp;&amp;<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">cursor<\/span><span style=\"color: #39ADB5\">.<\/span><span style=\"color: #6182B8\">moveToFirst<\/span><span style=\"color: #E53935\">()) <\/span><span style=\"color: #39ADB5\">{<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #90A4AE\">String<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">data<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">=<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">cursor<\/span><span style=\"color: #39ADB5\">.<\/span><span style=\"color: #6182B8\">getString<\/span><span style=\"color: #E53935\">(<\/span><span style=\"color: #F76D47\">0<\/span><span style=\"color: #E53935\">)<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #90A4AE\">cursor<\/span><span style=\"color: #39ADB5\">.<\/span><span style=\"color: #6182B8\">close<\/span><span style=\"color: #E53935\">()<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #39ADB5; font-style: italic\">return<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #90A4AE\">data<\/span><span style=\"color: #39ADB5\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #39ADB5\">}<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E53935\">\u00a0\u00a0\u00a0\u00a0<\/span><span style=\"color: #39ADB5; font-style: italic\">return<\/span><span style=\"color: #E53935\"> <\/span><span style=\"color: #39ADB5\">null;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #39ADB5\">}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u041e\u0431\u044a\u044f\u0441\u043d\u0435\u043d\u0438\u0435: \u0412 \u044d\u0442\u043e\u043c \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u043c\u044b \u0441\u043e\u0437\u0434\u0430\u0435\u043c \u0434\u0432\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438: \u043e\u0434\u043d\u0443 \u0434\u043b\u044f \u0441\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u043a\u044d\u0448 \u0438 \u0434\u0440\u0443\u0433\u0443\u044e \u0434\u043b\u044f \u0438\u0437\u0432\u043b\u0435\u0447\u0435\u043d\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0437 \u043a\u044d\u0448\u0430. \u042d\u0442\u043e \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0432\u0430\u0448\u0435\u043c\u0443 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044e \u0431\u044b\u0441\u0442\u0440\u043e \u0437\u0430\u0433\u0440\u0443\u0436\u0430\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u0435 \u0431\u0435\u0437 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0441\u0442\u0438 \u043f\u043e\u0432\u0442\u043e\u0440\u043d\u043e\u0433\u043e \u043e\u0431\u0440\u0430\u0449\u0435\u043d\u0438\u044f \u043a \u0441\u0435\u0442\u0438.<\/p>\n\n\n    <div class=\"adv_youtube\">\r\n        <div class=\"adv_youtube_block g-bg-white d-flex align-items-center justify-content-center\">\r\n            <img decoding=\"async\" src=\"https:\/\/esvt4mphmap.exactdn.com\/wp-content\/themes\/foxminded\/icon\/general\/adv_logo.png?strip=all&quality=92&webp=92&avif=90&sharp=1&w=640\">\r\n            <div class=\"bubble_text\">\r\n                <span>\u041f\u043e\u0434\u043f\u0438\u0448\u0438\u0442\u0435\u0441\u044c \u043d\u0430 \u043d\u0430\u0448 \u042e\u0442\u0443\u0431-\u043a\u0430\u043d\u0430\u043b!<\/span> \u041f\u043e\u043b\u0435\u0437\u043d\u044b\u0435 \u0432\u0438\u0434\u0435\u043e \u0434\u043b\u044f \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0441\u0442\u043e\u0432 \u0443\u0436\u0435 \u0436\u0434\u0443\u0442 \u0432\u0430\u0441!                <a class=\"btn btn-primary btn-primary-icon\" href=\"https:\/\/www.youtube.com\/c\/SergeyNemchinskiy\">\r\n                    <img decoding=\"async\" src=\"https:\/\/esvt4mphmap.exactdn.com\/wp-content\/themes\/foxminded\/icon\/general\/youtube_btn_icon.svg\">\r\n                    YouTube   \r\n                <\/a>\r\n            <\/div>\r\n        <\/div>\r\n        <div class=\"adv_mentoring_block g-bg-white d-flex align-items-center justify-content-center\">\r\n            <img decoding=\"async\" src=\"https:\/\/esvt4mphmap.exactdn.com\/wp-content\/themes\/foxminded\/icon\/general\/adv_logo.png?strip=all&quality=92&webp=92&avif=90&sharp=1&w=640\">\r\n            <div class=\"bubble_text\">\r\n                <span>\u0412\u044b\u0431\u0435\u0440\u0438\u0442\u0435 \u0441\u0432\u043e\u0439 \u043a\u0443\u0440\u0441!<\/span> \u041f\u0443\u0442\u044c \u043a \u043a\u0430\u0440\u044c\u0435\u0440\u0435 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0441\u0442\u0430 \u043d\u0430\u0447\u0438\u043d\u0430\u0435\u0442\u0441\u044f \u0437\u0434\u0435\u0441\u044c!                <a class=\"btn btn-primary\" href=\"https:\/\/foxminded.ua\/ru\/junior-course\/\">\r\n                    \u041f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c                    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20\" height=\"20\" viewBox=\"0 0 20 20\" fill=\"none\">\r\n                    <path d=\"M11.6927 5.8584L11.6927 9.19173L4.25937 9.19173L4.23437 10.8667L11.6927 10.8667L11.6927 14.1917L15.8594 10.0251L11.6927 5.8584Z\" fill=\"white\"\/>\r\n                    <\/svg>\r\n                <\/a>\r\n            <\/div>\r\n        <\/div>\r\n    <\/div>\r\n\n\n\n<h2 class=\"wp-block-heading\">\u041e\u0441\u043e\u0431\u0435\u043d\u043d\u043e\u0441\u0442\u0438 \u0438 \u043b\u0443\u0447\u0448\u0438\u0435 \u043f\u0440\u0430\u043a\u0442\u0438\u043a\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f SQLite \u0432 Android<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">SQLite \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0432\u0441\u0442\u0440\u043e\u0435\u043d\u043d\u043e\u0439 \u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u043e\u0439 \u0421\u0423\u0411\u0414, \u0448\u0438\u0440\u043e\u043a\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u043c\u043e\u0439 \u0432 Android \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0445 \u0434\u0430\u043d\u043d\u044b\u0445. \u041a\u043b\u044e\u0447\u0435\u0432\u044b\u0435 \u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e\u0441\u0442\u0438 \u0432\u043a\u043b\u044e\u0447\u0430\u044e\u0442 \u043b\u0435\u0433\u043a\u043e\u0441\u0442\u044c \u0438\u043d\u0442\u0435\u0433\u0440\u0430\u0446\u0438\u0438, \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0440\u0430\u0431\u043e\u0442\u044b \u0441 SQL-\u0437\u0430\u043f\u0440\u043e\u0441\u0430\u043c\u0438 \u0438 \u043e\u0442\u0441\u0443\u0442\u0441\u0442\u0432\u0438\u0435 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0441\u0442\u0438 \u0432 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e\u043c \u0441\u0435\u0440\u0432\u0435\u0440\u0435. \u041b\u0443\u0447\u0448\u0438\u0435 \u043f\u0440\u0430\u043a\u0442\u0438\u043a\u0438 \u043f\u0440\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0438 SQLite \u0432\u043a\u043b\u044e\u0447\u0430\u044e\u0442 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u044e \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0439 \u0437\u0430\u043f\u0438\u0441\u0438, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0439 \u0434\u043b\u044f \u043f\u0430\u043a\u0435\u0442\u043d\u043e\u0433\u043e \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u0445. \u042d\u0442\u043e \u043d\u0435 \u0442\u043e\u043b\u044c\u043a\u043e \u0443\u0441\u043a\u043e\u0440\u044f\u0435\u0442 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u044b, \u043d\u043e \u0438 \u0441\u043d\u0438\u0436\u0430\u0435\u0442 \u0440\u0438\u0441\u043a \u043f\u043e\u0432\u0440\u0435\u0436\u0434\u0435\u043d\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u0445. \u0420\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u0443\u0435\u0442\u0441\u044f \u0442\u0430\u043a\u0436\u0435 \u043c\u0438\u043d\u0438\u043c\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u0445 \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0439, \u0432\u0435\u0434\u044c \u043a\u0430\u0436\u0434\u043e\u0435 \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435 \u0442\u0440\u0435\u0431\u0443\u0435\u0442 \u0440\u0435\u0441\u0443\u0440\u0441\u043e\u0432 \u0441\u0438\u0441\u0442\u0435\u043c\u044b. \u041e\u0431\u0449\u0438\u0435 \u043e\u0448\u0438\u0431\u043a\u0438, \u0442\u0430\u043a\u0438\u0435 \u043a\u0430\u043a \u043d\u0435\u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u044b\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u0438\u043b\u0438 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0438\u0437\u0431\u044b\u0442\u043e\u0447\u043d\u044b\u0445 \u0438\u043d\u0434\u0435\u043a\u0441\u043e\u0432, \u043c\u043e\u0433\u0443\u0442 \u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u0443\u0445\u0443\u0434\u0448\u0438\u0442\u044c \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445. \u0414\u043b\u044f \u0438\u0445 \u043f\u0440\u0435\u0434\u043e\u0442\u0432\u0440\u0430\u0449\u0435\u043d\u0438\u044f \u0432\u0430\u0436\u043d\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u044b \u043f\u0440\u043e\u0444\u0438\u043b\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0438 \u0442\u0435\u0441\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438, \u0430 \u0442\u0430\u043a\u0436\u0435 \u0432\u043d\u0438\u043c\u0430\u0442\u0435\u043b\u044c\u043d\u043e \u0441\u043b\u0435\u0434\u0438\u0442\u044c \u0437\u0430 \u0441\u0445\u0435\u043c\u043e\u0439 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0438 \u0441\u043b\u0435\u0434\u043e\u0432\u0430\u0442\u044c \u043f\u0440\u0438\u043d\u0446\u0438\u043f\u0430\u043c \u043d\u043e\u0440\u043c\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0417\u0430\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0435<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u0418\u0437\u0443\u0447\u0435\u043d\u043d\u044b\u0435 \u0430\u0441\u043f\u0435\u043a\u0442\u044b \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f SQLite \u043f\u043e\u0434\u0447\u0435\u0440\u043a\u0438\u0432\u0430\u044e\u0442 \u0432\u0430\u0436\u043d\u043e\u0441\u0442\u044c \u044d\u0442\u043e\u0433\u043e \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430 \u0434\u043b\u044f \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u043e\u0433\u043e \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 Android-\u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f\u0445. \u041f\u0440\u0430\u0432\u0438\u043b\u044c\u043d\u0430\u044f \u0438\u043d\u0442\u0435\u0433\u0440\u0430\u0446\u0438\u044f \u0438 \u043f\u0440\u0438\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u043b\u0443\u0447\u0448\u0438\u0445 \u043f\u0440\u0430\u043a\u0442\u0438\u043a \u043d\u0435 \u0442\u043e\u043b\u044c\u043a\u043e \u0443\u043b\u0443\u0447\u0448\u0430\u0435\u0442 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c, \u043d\u043e \u0438 \u043f\u043e\u0432\u044b\u0448\u0430\u0435\u0442 \u0443\u0441\u0442\u043e\u0439\u0447\u0438\u0432\u043e\u0441\u0442\u044c \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f \u043a \u043e\u0448\u0438\u0431\u043a\u0430\u043c. \u041f\u0440\u0438\u043c\u0435\u0440\u043e\u043c \u0443\u0441\u043f\u0435\u0448\u043d\u043e\u0433\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f SQLite \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u044f FoxmindED, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442 \u044d\u0442\u0443 \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 \u0434\u043b\u044f \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 \u043f\u0440\u043e\u0446\u0435\u0441\u0441\u043e\u0432 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0438 \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0434\u0430\u043d\u043d\u044b\u0445, \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432\u0430\u044f \u0432\u044b\u0441\u043e\u043a\u0443\u044e \u043d\u0430\u0434\u0435\u0436\u043d\u043e\u0441\u0442\u044c \u0438 \u0431\u044b\u0441\u0442\u0440\u0443\u044e \u0440\u0435\u0430\u043a\u0446\u0438\u044e \u0441\u0432\u043e\u0438\u0445 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0439!<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"\u0427\u0435\u043c \u0437\u0430\u043d\u0438\u043c\u0430\u0435\u0442\u0441\u044f Android \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a? \u0422\u0440\u0435\u0431\u043e\u0432\u0430\u043d\u0438\u044f \u043a \u0441\u043f\u0435\u0446\u0438\u0430\u043b\u0438\u0441\u0442\u0430\u043c, \u0444\u0440\u0435\u0439\u043c\u0432\u043e\u0440\u043a\u0438 \u0438 \u0440\u0430\u0431\u043e\u0442\u0430 \u043d\u0430 \u0444\u0440\u0438\u043b\u0430\u043d\u0441\u0435\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/COKWA6hj-W8?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Android \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u043e\u0434\u043d\u043e\u0439 \u0438\u0437 \u0441\u0430\u043c\u044b\u0445 \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u044b\u0445 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0441\u0438\u0441\u0442\u0435\u043c \u0434\u043b\u044f \u043c\u043e\u0431\u0438\u043b\u044c\u043d\u044b\u0445 \u0443\u0441\u0442\u0440\u043e\u0439\u0441\u0442\u0432, \u0447\u0442\u043e \u0434\u0435\u043b\u0430\u0435\u0442 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0443 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0439 \u043d\u0430 \u044d\u0442\u043e\u0439 \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u0435 \u0430\u043a\u0442\u0443\u0430\u043b\u044c\u043d\u043e\u0439 \u0438 \u0432\u0430\u0436\u043d\u043e\u0439 \u0434\u043b\u044f \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0441\u0442\u043e\u0432 \u0438 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0439. \u0421\u0440\u0435\u0434\u0438 \u043c\u043d\u043e\u0436\u0435\u0441\u0442\u0432\u0430 \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u043e\u0432, \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u044b\u0445 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0430\u043c, android sqlite \u0437\u0430\u043d\u0438\u043c\u0430\u0435\u0442 \u043e\u0441\u043e\u0431\u043e\u0435 \u043c\u0435\u0441\u0442\u043e \u0431\u043b\u0430\u0433\u043e\u0434\u0430\u0440\u044f \u0441\u0432\u043e\u0435\u0439 \u043f\u0440\u043e\u0441\u0442\u043e\u0442\u0435, \u044d\u0444\u0444\u0435\u043a\u0442\u0438\u0432\u043d\u043e\u0441\u0442\u0438 \u0438 \u043b\u0435\u0433\u043a\u043e\u0441\u0442\u0438 \u0438\u043d\u0442\u0435\u0433\u0440\u0430\u0446\u0438\u0438 \u0432 Android-\u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f. SQLite \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u0441\u043e\u0431\u043e\u0439 \u043b\u0435\u0433\u043a\u043e\u0432\u0435\u0441\u043d\u0443\u044e \u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u0443\u044e \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0430\u043c \u0443\u043f\u0440\u0430\u0432\u043b\u044f\u0442\u044c [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-75449","post","type-post","status-publish","format-standard","hentry","category-learning"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Android SQLite: \u0420\u0443\u043a\u043e\u0432\u043e\u0434\u0441\u0442\u0432\u043e \u043f\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044e \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445<\/title>\n<meta name=\"description\" content=\"\u0423\u0437\u043d\u0430\u0439\u0442\u0435, \u043a\u0430\u043a \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0441 SQLite \u0432 Android \u0434\u043b\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0438 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u043b\u043e\u043a\u0430\u043b\u044c\u043d\u044b\u043c\u0438 \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445. \u041f\u0440\u0438\u043c\u0435\u0440\u044b \u0438 \u043f\u043e\u043b\u0435\u0437\u043d\u044b\u0435 \u0441\u043e\u0432\u0435\u0442\u044b \u0432\u043d\u0443\u0442\u0440\u0438.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/foxminded.ua\/ru\/android-sqlite\/\" \/>\n<meta property=\"og:locale\" content=\"ru_RU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Android SQLite: \u0420\u0443\u043a\u043e\u0432\u043e\u0434\u0441\u0442\u0432\u043e \u043f\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044e \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445\" \/>\n<meta property=\"og:description\" content=\"\u0423\u0437\u043d\u0430\u0439\u0442\u0435, \u043a\u0430\u043a \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0441 SQLite \u0432 Android \u0434\u043b\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0438 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u043b\u043e\u043a\u0430\u043b\u044c\u043d\u044b\u043c\u0438 \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445. \u041f\u0440\u0438\u043c\u0435\u0440\u044b \u0438 \u043f\u043e\u043b\u0435\u0437\u043d\u044b\u0435 \u0441\u043e\u0432\u0435\u0442\u044b \u0432\u043d\u0443\u0442\u0440\u0438.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/foxminded.ua\/ru\/android-sqlite\/\" \/>\n<meta property=\"og:site_name\" content=\"FoxmindEd\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/foxmindedco\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-05-07T12:30:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-07T12:35:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/esvt4mphmap.exactdn.com\/wp-content\/uploads\/2025\/05\/foxminded_main_logo_with_descriptor_name_orange-1.png?strip=all&quality=92&webp=92&avif=90&sharp=1\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"554\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Nemchyns\u02b9kyy Serhiy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u041d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0430\u0432\u0442\u043e\u0440\u043e\u043c\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nemchyns\u02b9kyy Serhiy\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 \u043c\u0438\u043d\u0443\u0442\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/foxminded.ua\\\/ru\\\/android-sqlite\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/foxminded.ua\\\/ru\\\/android-sqlite\\\/\"},\"author\":{\"name\":\"Nemchyns\u02b9kyy Serhiy\",\"@id\":\"https:\\\/\\\/foxminded.ua\\\/#\\\/schema\\\/person\\\/cc2955ca75c958d66beb74b6b994515c\"},\"headline\":\"Android SQLite\",\"datePublished\":\"2025-05-07T12:30:26+00:00\",\"dateModified\":\"2025-05-07T12:35:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/foxminded.ua\\\/ru\\\/android-sqlite\\\/\"},\"wordCount\":738,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/foxminded.ua\\\/#organization\"},\"articleSection\":[\"\u041e\u0431\u0443\u0447\u0435\u043d\u0438\u0435\"],\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/foxminded.ua\\\/ru\\\/android-sqlite\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/foxminded.ua\\\/ru\\\/android-sqlite\\\/\",\"url\":\"https:\\\/\\\/foxminded.ua\\\/ru\\\/android-sqlite\\\/\",\"name\":\"Android SQLite: \u0420\u0443\u043a\u043e\u0432\u043e\u0434\u0441\u0442\u0432\u043e \u043f\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044e \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/foxminded.ua\\\/#website\"},\"datePublished\":\"2025-05-07T12:30:26+00:00\",\"dateModified\":\"2025-05-07T12:35:33+00:00\",\"description\":\"\u0423\u0437\u043d\u0430\u0439\u0442\u0435, \u043a\u0430\u043a \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0441 SQLite \u0432 Android \u0434\u043b\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0438 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u043b\u043e\u043a\u0430\u043b\u044c\u043d\u044b\u043c\u0438 \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445. \u041f\u0440\u0438\u043c\u0435\u0440\u044b \u0438 \u043f\u043e\u043b\u0435\u0437\u043d\u044b\u0435 \u0441\u043e\u0432\u0435\u0442\u044b \u0432\u043d\u0443\u0442\u0440\u0438.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/foxminded.ua\\\/ru\\\/android-sqlite\\\/#breadcrumb\"},\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/foxminded.ua\\\/ru\\\/android-sqlite\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/foxminded.ua\\\/ru\\\/android-sqlite\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0413\u043e\u043b\u043e\u0432\u043d\u0430\",\"item\":\"https:\\\/\\\/foxminded.ua\\\/ru\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Android SQLite\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/foxminded.ua\\\/#website\",\"url\":\"https:\\\/\\\/foxminded.ua\\\/\",\"name\":\"FoxmindEd\",\"description\":\"\u0415\u0449\u0451 \u043e\u0434\u0438\u043d \u0441\u0430\u0439\u0442 \u043d\u0430 WordPress\",\"publisher\":{\"@id\":\"https:\\\/\\\/foxminded.ua\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/foxminded.ua\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ru-RU\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/foxminded.ua\\\/#organization\",\"name\":\"FoxmindEd\",\"url\":\"https:\\\/\\\/foxminded.ua\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ru-RU\",\"@id\":\"https:\\\/\\\/foxminded.ua\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/foxminded.ua\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/foxminded_sign_logo_orange.webp\",\"contentUrl\":\"https:\\\/\\\/foxminded.ua\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/foxminded_sign_logo_orange.webp\",\"width\":2063,\"height\":2222,\"caption\":\"FoxmindEd\"},\"image\":{\"@id\":\"https:\\\/\\\/foxminded.ua\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/foxmindedco\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/foxminded.ua\\\/#\\\/schema\\\/person\\\/cc2955ca75c958d66beb74b6b994515c\",\"name\":\"Nemchyns\u02b9kyy Serhiy\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Android SQLite: \u0420\u0443\u043a\u043e\u0432\u043e\u0434\u0441\u0442\u0432\u043e \u043f\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044e \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445","description":"\u0423\u0437\u043d\u0430\u0439\u0442\u0435, \u043a\u0430\u043a \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0441 SQLite \u0432 Android \u0434\u043b\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0438 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u043b\u043e\u043a\u0430\u043b\u044c\u043d\u044b\u043c\u0438 \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445. \u041f\u0440\u0438\u043c\u0435\u0440\u044b \u0438 \u043f\u043e\u043b\u0435\u0437\u043d\u044b\u0435 \u0441\u043e\u0432\u0435\u0442\u044b \u0432\u043d\u0443\u0442\u0440\u0438.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/foxminded.ua\/ru\/android-sqlite\/","og_locale":"ru_RU","og_type":"article","og_title":"Android SQLite: \u0420\u0443\u043a\u043e\u0432\u043e\u0434\u0441\u0442\u0432\u043e \u043f\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044e \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445","og_description":"\u0423\u0437\u043d\u0430\u0439\u0442\u0435, \u043a\u0430\u043a \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0441 SQLite \u0432 Android \u0434\u043b\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0438 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u043b\u043e\u043a\u0430\u043b\u044c\u043d\u044b\u043c\u0438 \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445. \u041f\u0440\u0438\u043c\u0435\u0440\u044b \u0438 \u043f\u043e\u043b\u0435\u0437\u043d\u044b\u0435 \u0441\u043e\u0432\u0435\u0442\u044b \u0432\u043d\u0443\u0442\u0440\u0438.","og_url":"https:\/\/foxminded.ua\/ru\/android-sqlite\/","og_site_name":"FoxmindEd","article_publisher":"https:\/\/www.facebook.com\/foxmindedco\/","article_published_time":"2025-05-07T12:30:26+00:00","article_modified_time":"2025-05-07T12:35:33+00:00","og_image":[{"width":1024,"height":554,"url":"https:\/\/esvt4mphmap.exactdn.com\/wp-content\/uploads\/2025\/05\/foxminded_main_logo_with_descriptor_name_orange-1.png?strip=all&quality=92&webp=92&avif=90&sharp=1","type":"image\/png"}],"author":"Nemchyns\u02b9kyy Serhiy","twitter_card":"summary_large_image","twitter_misc":{"\u041d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0430\u0432\u0442\u043e\u0440\u043e\u043c":"Nemchyns\u02b9kyy Serhiy","\u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f":"5 \u043c\u0438\u043d\u0443\u0442"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/foxminded.ua\/ru\/android-sqlite\/#article","isPartOf":{"@id":"https:\/\/foxminded.ua\/ru\/android-sqlite\/"},"author":{"name":"Nemchyns\u02b9kyy Serhiy","@id":"https:\/\/foxminded.ua\/#\/schema\/person\/cc2955ca75c958d66beb74b6b994515c"},"headline":"Android SQLite","datePublished":"2025-05-07T12:30:26+00:00","dateModified":"2025-05-07T12:35:33+00:00","mainEntityOfPage":{"@id":"https:\/\/foxminded.ua\/ru\/android-sqlite\/"},"wordCount":738,"commentCount":0,"publisher":{"@id":"https:\/\/foxminded.ua\/#organization"},"articleSection":["\u041e\u0431\u0443\u0447\u0435\u043d\u0438\u0435"],"inLanguage":"ru-RU","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/foxminded.ua\/ru\/android-sqlite\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/foxminded.ua\/ru\/android-sqlite\/","url":"https:\/\/foxminded.ua\/ru\/android-sqlite\/","name":"Android SQLite: \u0420\u0443\u043a\u043e\u0432\u043e\u0434\u0441\u0442\u0432\u043e \u043f\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044e \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445","isPartOf":{"@id":"https:\/\/foxminded.ua\/#website"},"datePublished":"2025-05-07T12:30:26+00:00","dateModified":"2025-05-07T12:35:33+00:00","description":"\u0423\u0437\u043d\u0430\u0439\u0442\u0435, \u043a\u0430\u043a \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0441 SQLite \u0432 Android \u0434\u043b\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0438 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u043b\u043e\u043a\u0430\u043b\u044c\u043d\u044b\u043c\u0438 \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445. \u041f\u0440\u0438\u043c\u0435\u0440\u044b \u0438 \u043f\u043e\u043b\u0435\u0437\u043d\u044b\u0435 \u0441\u043e\u0432\u0435\u0442\u044b \u0432\u043d\u0443\u0442\u0440\u0438.","breadcrumb":{"@id":"https:\/\/foxminded.ua\/ru\/android-sqlite\/#breadcrumb"},"inLanguage":"ru-RU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/foxminded.ua\/ru\/android-sqlite\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/foxminded.ua\/ru\/android-sqlite\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0413\u043e\u043b\u043e\u0432\u043d\u0430","item":"https:\/\/foxminded.ua\/ru\/"},{"@type":"ListItem","position":2,"name":"Android SQLite"}]},{"@type":"WebSite","@id":"https:\/\/foxminded.ua\/#website","url":"https:\/\/foxminded.ua\/","name":"FoxmindEd","description":"\u0415\u0449\u0451 \u043e\u0434\u0438\u043d \u0441\u0430\u0439\u0442 \u043d\u0430 WordPress","publisher":{"@id":"https:\/\/foxminded.ua\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/foxminded.ua\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ru-RU"},{"@type":"Organization","@id":"https:\/\/foxminded.ua\/#organization","name":"FoxmindEd","url":"https:\/\/foxminded.ua\/","logo":{"@type":"ImageObject","inLanguage":"ru-RU","@id":"https:\/\/foxminded.ua\/#\/schema\/logo\/image\/","url":"https:\/\/foxminded.ua\/wp-content\/uploads\/2024\/08\/foxminded_sign_logo_orange.webp","contentUrl":"https:\/\/foxminded.ua\/wp-content\/uploads\/2024\/08\/foxminded_sign_logo_orange.webp","width":2063,"height":2222,"caption":"FoxmindEd"},"image":{"@id":"https:\/\/foxminded.ua\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/foxmindedco\/"]},{"@type":"Person","@id":"https:\/\/foxminded.ua\/#\/schema\/person\/cc2955ca75c958d66beb74b6b994515c","name":"Nemchyns\u02b9kyy Serhiy"}]}},"_links":{"self":[{"href":"https:\/\/foxminded.ua\/ru\/wp-json\/wp\/v2\/posts\/75449","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/foxminded.ua\/ru\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/foxminded.ua\/ru\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/foxminded.ua\/ru\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/foxminded.ua\/ru\/wp-json\/wp\/v2\/comments?post=75449"}],"version-history":[{"count":7,"href":"https:\/\/foxminded.ua\/ru\/wp-json\/wp\/v2\/posts\/75449\/revisions"}],"predecessor-version":[{"id":75462,"href":"https:\/\/foxminded.ua\/ru\/wp-json\/wp\/v2\/posts\/75449\/revisions\/75462"}],"wp:attachment":[{"href":"https:\/\/foxminded.ua\/ru\/wp-json\/wp\/v2\/media?parent=75449"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/foxminded.ua\/ru\/wp-json\/wp\/v2\/categories?post=75449"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/foxminded.ua\/ru\/wp-json\/wp\/v2\/tags?post=75449"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}