Supports QtScript, which is more or less the same as JavaScript (aka ECMAScript). Supports SQL understood by SQLite 3 (which covers SQLite 2 as well). Examples of such fields is SQL Editor, Custom SQL functions window, Custom collations window, etc. Syntax highlighter plugins are used in any input text field that displays some code. Populating plugins Constant (built-in) Random (built-in) Random text (built-in) Sequence (built-in) Script (built-in) Dictionary (built-in) Syntax highlighter plugins See RegExpImport for more details and usage examples. This plugin imports certain parts of text using regular expression. See CsvImport for more details and usage examples. SELECT import( 'c:/test.csv ', 'CSV ', 'my_table1 ', 'UTF-8 ', 'CsvImport.Separator=1 CsvImport.FirstRowAsColumns=true ') CSV Files created by this plugin look more or less like this: You can also export results of a query, which can be later imported (executed) into other database. Using this plugin you can make a dump of the entire database (or only some of its elements) into SQL file, which can be later executed on any database, to recreate the exactly same objects and data. Future versions may depend on more recent Python versions and should be documented here when that happens.Īt the moment no further documentation for this plugin is provided. Version 3.9 is required at least for the plugin version provided in SQLiteStudio 3.4.0. Python plugin requires the Python 3.9 to be installed in your system. Implements Tcl scripting language support.įor more details see ScriptingTcl. Using SQL scripting plugin is allowed in any other contexts, where scritping plugins are used (obviously), but SQL is not really a programming language, so it's not a good candidate for using it anywhere else. One would implement custom SQL function with SQL scripting plugin, put various SQL statements in the implementation and then execute such "procedure" with: SELECT my_procedure(arg1, arg2).įunction code that uses SQL as an implementation language can refer to input arguments using following placeholders:įor example if you implement function, that have 2 input arguments named "primary_id" and "secondary_id", you can write query like:ĭELETE FROM some_table WHERE pr_id = AND sec_id = :secondary_id Its main purpose was to allow writing kind of procedures (since SQLite lacks procuders), using custom SQL functions. SQL scripting plugin is a very limited one. QtScript implements ECMAScript language, which is pretty much what JavaScript is. Using provided scripting languages you can implement: Scripting languages plugins are used in various ways across the application. It basicly can uppercase keywords and reduce multiple whitespace characters into single one (excluding whitespaces in string values). It has very little of configuration options and doesn't provide much of a formatting. Simple formatter is more for an example (for developers) of how the formatter plugins work and how to implement them. These plugins can provide their own configuration options available in Configuration Dialog, under Plugins -> SQL Formatting -> PluginName. That includes SQL Editor, View window, Trigger Dialog and many more. SQL formatter plugins are used by the SQL formater service in SQLiteStudio to format SQL statements in text input fields that are used to display SQL. All queries and changes are executed directly on the device. It enables SQLiteStudio to access SQLite databases directly on the Android device. This plugin is available only under Windows, because it relies on Windows API. Accessing databases is now provided by the DbSqliteWx plugin.Įnables support for databases. DbSqliteSystemDataĭEPRECATED! This plugin is deprecated as of SQLiteStudio 3.3.0. Since version 3.3.0 of SQLiteStudio the plugin makes use of SQLite3MultipleCiphers for implementing support to all wxSQLite3, and SQLCipher databases. It enables support for SQLCipher databases in SQLiteStudio.Įnables support for wxSQLite3 databases (part of wxWidgets). It comes with SQLite 2.8.17 on board.Ĭompilation notes: If you're compiling this plugin by yourself, be aware that it assumes that the SQLite 2 library was compiled with UTF-8 support. For accessing SQLite 2 please use older SQLiteStudio versions.Įnables support for an old SQLite 2. DbSqlite2ĭEPRECATED! It is deprecated as of SQLiteStudio 3.3.0. SQLiteStudio uses this plugin to store its own configuration. It always provides support for the most recent, official SQLite3 version.īinary distributions of SQLiteStudio also have some SQLite extensions built in (currently only FTS in versions 1, 2, 3 and 4). This is a default plugin (that's why it's built-in) for databases. (*) - BLOB support in SQLite 2 is limited, see possible issues.QtScriptHighlighter (built-in) (aka JavaScript highlighter)ĭatabase plugins provide support for various SQLite database formats.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |