[FEATURE] :API Security Report & Actions Finds where a user could see data that is not theirs, gives your account a score out of 100, and fixes many problems in one click. The report is kept in git and updates itself while your local client is connected or manually on button click.
[FEATURE] :Index Maker : automatic indexes. Switch the mode on and Index Maker records the queries of your APIs at regular intervals, asks the database with explain which ones use no index, and creates an index for the slow or frequent queries on big tables (thresholds, fields per index, indexes per table, excluded collections... are settings of the account). Every index goes into the migration script am_index_maker, a JSON list the script itself applies, so every environment creates the same indexes on its next deploy. The script can not be deleted, runs again without harm, and every decision is kept on its scanning period with the reason.
[FEATURE] :Index system APIs : g.sys.system.createIndexes, g.sys.system.dropIndexes and g.sys.system.getIndexes (and /create-indexes, /drop-indexes, /get-indexes) work the same on MongoDB, MySQL, MariaDB, SQL Server, PostgreSQL and Oracle. An index which exists already is EXISTS, a field no plain index can hold is SKIPPED with the reason, a refusal of the database is FAILED with its message.
[IMPROVEMENTS] : Index Maker page redesigned : the automatic indexes panel, a summary of every scanning period with its state and shapes, suggestions with Add to script, and the index form with the verdict of every field, the existing indexes and the size of the table. Indexes get a name built from their fields, the same in every environment and within the limit of every database.
[IMPROVEMENTS] : Index names are quoted on Oracle and bracketed on SQL Server, so tables with lower-case or mixed-case names get their indexes.
[IMPROVEMENTS] : Docker tab added in analytics dashboard.
[IMPROVEMENTS] : Local Client : It will start immediately without installing and waiting for the dependencies. Local client is standalone now.
[IMPROVEMENTS] : Local Client : 2 way sync is implemented.
[IMPROVEMENTS] : Git status will not show difference when there is change of new line at the end of file.
[BUG] : Fields having encryption, decryption or hashing conversion can now be saved & updated with null value, earlier it was giving error or storing wrong value because API Maker was trying to convert the null value.
[BUG] : The schema code of a PostgreSQL table with an array or json column could not be generated.