SQLite Extension [Updated] This extension provides you with additional mathematical functions. It doesn't modify the normal functionality of SQLite nor alter the performance of your queries. It's an independent module in order to allow modifications in future versions of SQLite. It has its own documentation. All functions are included in sqlext.sqlite, the extensions schema. Bugfixes This version fixes a problem with the functions that are used with the library of the Recompiler Release Notes v1.0.0 This extension has been designed to provide you with new functions for working with data. You can use them: · to create new databases with multisets, · to sort multisets, · to get the maximum or the minimum of values in a multiset. You can use them in any of your queries. The functions are included in sqlext.sqlite, the extensions schema. Bugfixes This version fixes a problem with the functions that are used with the library of the Recompiler Release Notes v1.0.0 This extension has been designed to provide you with new functions for working with data. You can use them: · to create new databases with multisets, · to sort multisets, · to get the maximum or the minimum of values in a multiset. You can use them in any of your queries. The functions are included in sqlext.sqlite, the extensions schema. Release Notes v1.0.0 This extension has been designed to provide you with new functions for working with data. You can use them: · to create new databases with multisets, · to sort multisets, · to get the maximum or the minimum of values in a multiset. You can use them in any of your queries. The functions are included in sqlext.sqlite, the extensions schema. Release Notes v1.0.0 This extension has been designed to provide you with new functions for working with data. You can use them: · to create new databases with multisets, · to sort multisets, · to get the maximum or the minimum of values in a multiset. You can use them in any of your queries. SQLite Extension Crack + With Key SQLite Extension allows you to use SQLite functions from a Database language on data stored in files, or from user inputs, or other databases. SQLite Extension functions · Introducing different functions to work with tables, views or datasets in a Database language. · Works with BigINT, BigDecimal, BLOB, FLOAT, VARCHAR, TEXT, DOUBLE, REAL, DATE, TIME and REALMATIC data types. · Support for string functions, like soundex and accents removal. · Support for Regular Expressions in queries, like `LIKE` and `REGEXP` operators. · Support for functions returning to tables, views or datasets, like `COUNT(*)` and `COUNT(field)` or `COUNT(DISTINCT(field))`. · Support for functions returning the number of matches, like `COUNT(*)`, or `COUNT(field)`. · Support for functions returning the number of non matches, like `COUNT(field)`. · Support for the `EXISTS` operator in queries. · Support for the `ORDER BY` clause with SQLite Extension. · Support for the `GROUP BY` clause with SQLite Extension. · Support for the `HAVING` clause with SQLite Extension. · Support for the `SELECT` clause in queries. · Support for the `UNION` clause in queries. · Support for the `SELECT` clause in joins. · Support for `INNER`, `LEFT`, `OUTER` and `UNION` joins with SQLite Extension. · Support for the `LEFT OUTER` join with SQLite Extension. · Support for the `SELECT` clause in arrays. · Support for the `FOR UPDATE` clause. · Support for the `FOR UPDATE NOWAIT` clause. · Support for the `EXCEPT` clause. · Support for the `LIMIT` clause. 1a423ce670 SQLite Extension Download A type of encryption. sqlite3_auth_key(authKey,password) Creates a user authentication key. The parameters are a string and a password. Return: Returns the new string. PASSWORD/USERNAME Password for authentication RANDOM(t_length) A random value, a random number. Return: A random number. ROUND(t_number, t_precision) Rounds a number. Return: The rounded value. SoundEx('sound-ex string') A string search. Return: The string with the soundex value of the string. SOUNDEX('sound-ex string') A string search. Return: The string with the soundex value of the string. sqrt(a) The square root of a. Return: The square root of a. STRPOS(t_str) The string's position. Return: The string's position. STRPOS(t_str, t_position) The string's position. Return: The string's position. STRTOK(t_str, t_position) The string's character. Return: The string's character. To calculate a checksum: RETURN(checksum(t_str)) Checksum for a string. To compare a string with a checksum: RETURN(st_equal(t_str,checksum(t_str))) Checksum for a string. To encrypt a blob: RETURN(encrypt(t_data,authKey)) Encryption for a blob. To decrypt a blob: RETURN(decrypt(authKey,t_data)) Decryption for a blob. Notes: · The test has a limited test mode. · When the string contains a utf8 character, it will be converted to latin1. · If it is not utf8, a SQLite error will be generated. · The copyright is included in the package. · The license is: GNU-General Public License 3.0. · The size of the package is: 0.02 KB. · The language of the package is: SQLite. · The date of the package is: 2008-11-12. Compatibility: · sqlite What's New In? System Requirements: Minimum: OS: Windows 8 or higher Processor: Intel Core i5 or better Memory: 8GB RAM Graphics: AMD Radeon HD 5870 or Nvidia GeForce GTX560 or better DirectX: Version 11 Network: Broadband Internet connection Storage: 30 GB available space Recommended: Processor: Intel Core i7 or better Memory: 16GB RAM Graphics: AMD Radeon HD 5970 or Nvidia GeForce GTX970 or better DirectX
Related links:
Comments