Home

Welcome to the PriSecDBAAS wiki Beta!

There'll be 6 sections in this wiki.

Note:Exclude foreign key(s) or primary key(s), all columns within the table must be text data type. In MySQL, there's text data type, don't confuse it with varchar. For security reasons, the automatic generated primary keys will all consider similar to that of a strong password, and developers must use such primary keys. Only DBA created PKs or web API created PKs is allowed. This has something to do with metadata and I don't think DBAAS provider would want to deal with problematic GDPR and any similar laws.

All pure lookup table's/table that has only primary key and its attributes without foreign key data, the column that stores primary key must declared its data type within the table as varchar with 500 in length.

1. Algorithms choosing
2. Single field insert with auto generating primary key.
3. Multiple field insert primarily used in filling the table with foreign keys or foreign keys with value.
4. Multiple field update primarily used to update foreign keys, existing encrypted values.
5. Multiple field select.
6. Multiple field delete.