Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 2

Displaying posts with tag: Obfuscator (reset)

MySQL Obfuscator, What features do you want to see ?
+0 Vote Up -0Vote Down

For those who don’t know the Obfuscator is for reporting bugs and support requests where the schema,data and queries are not allowed to be disclosed.

At the moment it requires PHP5+ and MySQL5+, the only requirement at the moment is the mysqli extension. It’s being written so that a simple command line interface will be added later as well as a way of interfacing with it directly in PHP. Because of the pluggable style infrastructure the possibilities are left wide open.

Features:

  • Multiple Query Obfuscation Multiple queries in a single obfuscation
    procedure, so that tables are obfuscated consistently over a few related
    queries.
  • Query Reformating the tokeniser will be able to pretty print queries no
    mater how ugly your query is.
  • Pluggable Schema Obfuscation



  [Read more...]
Obfuscator Column Renaming Scheme (draft)
+0 Vote Up -0Vote Down
This column obfuscation scheme is designed so that information can be gathered about the query and underlying schema, by just looking at the query. You will be able to tell if it is using keys correctly just by looking at the column names in the query.

Column Name Obfuscation 

  • Table Prefix Columns of a table will be prefixed with a abbreviation or (from a list of random names that can be selected from a list following a theme or something) of the Obfuscated table name (when I tackle joins this will resolve and conflict in names that are going to occur)

  • Column Type, undecided on whether or not to just go with simplified names like (str|int|float|bin) or go with the full data type (i.e BININT,BLOB,DECIMAL,VARCHAR,TEXT…).

  • Keys, P[0-9] numbers are only for multi value PRIMARY





  •   [Read more...]
    Showing entries 1 to 2

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.