| SQLite is a small database developed by a team. Because it can be stored locally and accessed offline, flashair is optimistic about this small database.
Today, many developers outside China developed many ide
Some 2.2 m, some less than 1 m, and some 22 m... Stuffy... This IDE is so different ..
Having a good tool is equivalent to having a good assistant to help developers faster.
But which development tool does it choose? I checked some data with questions !! ( 1) sqliteadminIDE size: 3.8 m
Sqliteadmin is an open sourceCommunityDeveloped SQLite currently supports 17 languages
Of course, there are also Chinese characters in it. I think this tool is quite good. It is open-source and free to meet the original spirit of SQLite !!!
The Chinese version is also being updated !! Strongly recommended .. Official Website: http://sqliteadmin.orbmu2k.de/ (2)SqlitespyIDE size: 1.86 m Sqlitespy is free for personal and educational purposes. sqlitespy has the following features:
1. Database Overview: All architectures, including tables, columns, indexes, and triggers, are displayed in a tree. Press F5 to update the architecture tree, double-click a table or view to display its data, and use the context menu of Common commands.
2. Grid Cell Editing: edit a table cell. A table is displayed in the tree structure. Select a cell and press f2 to call the editor. Then modify and confirm that your changes are written back to the table.
3. Data Type display: The local SQL data type displays different background colors to help detect type errors. Type errors may cause performance degradation or incorrect select result sets, preventing confusion between null values and empty strings.
4. Full UNICODE: sqlitespy fully supports Unicode of SQLite. Data display and input are fully Unicode, including SQL commands.
5. Editing Multiple SQL statements: Modern tags are used to edit and display query statements and results that are easier to query Multiple SQL statements. SQL query execution input or loaded to SQL they edit. Press the F9 key to run the query, or press Ctrl + F9 to run the current row or select only.
6. Time Measurement: the SQL Execution time is automatically measured and displayed to help optimize the query.
7. Regular Expression: the SQL keyword Regexp is supported, and the complete Perl regular expression syntax 5.10 sqlitespy is added. The diregex library is used.
8. Mathematical SQL functions: The following SQL functions can be used in mathematics except for SQLite default: ACOs (), asin (), atan (), atan (), atan2 (), ceil (), ceiling (), cos (), Cot (), degrees (), exp (), floor (), Ln (), log (), log (), log2 (), log10 (), MOD (), Pi (), POW (), radians (), sign (), sin (), SQRT (), Tan (), truncate ().
9. Data Compression: the compressed SQL function () applies to zlib compression to any text or blob value.
10. Compact result storage: the internal data storage mechanism is used to achieve optimal compatibility with native Data Types of SQLite. Therefore, sqlitespy is much lower than other SQLite memory management and can process a large number of tables more effectively.
11. built-in SQLite engine: sqlitespy has been built into a single application Program Files and SQLite Database Engine executable files. No DLL files need to be deployed, which makes sqlitespy easier to deploy.
12. encryption support: sqlitespy can read and modify encrypted database files generated by disqlite3. Disqlite3 implements its own native AES encryption. This is compatible with implementations that do not comply with commercial SQLite encryption extensions (SSE) or any other third party.
13. easy to install and uninstall: To Run sqlitespy, you only need to decompress the sqlitespy.exe file to any directory and execution file. No installation is required. At the beginning, the program created a file sqlitespy. db3 (1 sqlite3 database) to store and set. It does not write any other files or registries. Address: http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index
E-good brothers and sisters, you can go and have a look! (3)SQLite expert professional 3IDE size: about 23 MB
Brief Introduction
SQLite expert is divided into professional 3 into professional 3 and personal 3
Personal and advanced editions
The biggest difference is: Its free version only has three functions: data import and export, constraint management, and trigger management. See http://www.sqliteexpert.com/screenshots.html for details The free version can only be used for free for a period of time and cannot be used after expiration (In addition, this article also posts its cracking method) At present, most of them are using reg file cracking, that is, rewrite time, so that it can last longer.
The procedure is as follows:
1) Create a New TXT file and change it to crack. Reg. Set the followingCodeCopy in the file-> Save
1
2
3
4 |
Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE \ SOFTWARE \ SQLite expert \ 3.x]
"Install" = "lhcbkpjocfgaacioejha" |
Close and click execute !!! IDE: http://www.sqliteexpert.com/download.html |
