Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

SQLite visual management method

A management method and code technology, applied in the field of SQLite visual management, can solve problems such as hindering development, reducing development efficiency, and program generation problems, and achieving the effect of reducing maintenance costs, speeding up development progress, and improving productivity

Inactive Publication Date: 2013-02-06
盛冠商务咨询(上海)有限公司
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Browser does not support the SQL statement code prompt function, database developers can only write SQL statements based on their familiarity with the database, or refer to related documents, especially for beginners, people often forget a command, or forget their own What objects are in the database, and querying these things is undoubtedly a waste of time, reduces development efficiency, is very inconvenient, and will cause problems in the program due to developer input errors
[0003] In addition, Browser does not support database encryption, which makes users doubt the security of SQLite and hinders its further development; it also does not support DTS (Data Transfer Service) data import, which is very inconvenient when switching from other databases to SQLite databases

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 visual management method
  • SQLite visual management method
  • SQLite visual management method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] One embodiment of the SQLite visual management method of the present invention is as follows: figure 1 As shown, the SQLite visual management tool software is started, and after entering the operation database, code prompts can be performed, and the code prompts include the following steps:

[0034] 1. Through the SQL statement operation, the user enters the SQL code;

[0035] 2. After the event for code prompting is generated, check the sentence of code at the word where the current cursor is located;

[0036] 3. Determine whether the word where the current cursor is located has a context. The context refers to the word before or after a word in a code, such as the code "select*from Table", then the word "from" above It is "select", and the following is "table"; if the word where the current cursor is located has no context, no code prompt will be performed; if the word where the current cursor is located has context, go to step 4;

[0037] 4. Search the context to d...

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 discloses a SQLite visual management method which comprises the steps of: after entering an operating database, inputting structured query language (SQL) codes by a user to generate an event for code hint, detecting a sentence of code of a word at a position of the current cursor; judging whether the word at the position of the current cursor has a context, if so, searching the context for finding a table name; if finding the table name, taking a field name in the table for prompting the user, if not, searching the context for finding another name, if finding the another name, searching a real name of the table corresponding to the another name in all input SQL sentences; and if finding the real name, taking the field name in the table for prompting the user. The SQLite visual management method can carry out the SQL sentence code prompting, thereby improving the development efficiency of SQLite.

Description

technical field [0001] The invention relates to database development and management technology, in particular to a SQLite visual management method. Background technique [0002] As an increasingly popular database, SQLite has never had a really easy-to-use visual development and management integration system. Therefore, for SQLite operations, you can only focus on the console, or use SQLite Database Browser (Browser for short, its official website is http: / / sqlitebrowser.sourceforge.net / ). Browser does not support the SQL statement code prompt function, database developers can only write SQL statements based on their familiarity with the database, or refer to related documents, especially for beginners, people often forget a command, or forget their own What objects are there in the database, and querying these things is undoubtedly a waste of time, reduces development efficiency, is very inconvenient, and will cause problems in the program due to developer input errors. ...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
Inventor 何晓杰
Owner 盛冠商务咨询(上海)有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com