SQLITE database upgrading method and device, terminal and system

A technology for database and information upgrade, applied in the field of database upgrade, it can solve problems such as database and software version incompatibility, and client software cannot be used normally.

Pending Publication Date: 2021-03-12
SHANGHAI ZHONGTONGJI NETWORK TECH CO LTD
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This situation will lead to incompatibility between the database and the software version. Due to the difference between the database version and the software version, the client software cannot be used normally.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • SQLITE database upgrading method and device, terminal and system
  • SQLITE database upgrading method and device, terminal and system
  • SQLITE database upgrading method and device, terminal and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0052] In order to make the objects, technical solutions, and advantages of the present invention, the technical solutions of the present invention will be described in detail below. Obviously, the described embodiments are merely the embodiments of the invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained without making creative labor without making creative labor, in the premise of creative labor.

[0053] When the user uses the client software, after the client software version is updated, the corresponding database version is still the original old version. At this time, the database is required to upgrade the update operation, the specific operation process is as follows.

[0054] figure 1 It is a flow chart of the SQLite database upgrade method provided by an embodiment of the present invention. See figure 1 , A SQLite database upgrade method, including:

[0055] Step 101: Get the database version informat...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention relates to an SQLITE database upgrading method and device, a terminal and a system. The method comprises the steps of obtaining database version information of an SQLITE database and software version information of corresponding client software; judging whether the database version information is matched with the software version information; and if not, performing table structure upgrading operation on the SQLITE database according to the difference upgrading file. According to the method, the software version information is matched with the database version information, and then version upgrading is performed on the database, so that the problem of database table structure change caused by client software upgrading is solved.

Description

Technical field [0001] The present invention relates to the field of database upgrade technologies, and specific relates to a SQLite database upgrade method, device, terminal, and system. Background technique [0002] With the popularity of terminal system applications, more and more client software is put into use. Client software requires running with the support of the database, and the database provides data support for client software. With the continuous improvement of user needs, the continuous increase in the function of the client software is upgraded. With the increase in software functions, the database must be updated to provide data support for client software. [0003] Existing client software uses the SQLite database, and the software upgrade update is often required when the client software uses the SQLite database. However, client software does not have differences in the local SQLite database, that is, the SQLite database does not upgrade the update. This situat...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F8/65G06F8/71G06F16/21
CPCG06F8/65G06F8/71G06F16/21
Inventor 周保江
Owner SHANGHAI ZHONGTONGJI NETWORK TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products