Rewriting the pg_chameleon SQL library
- Mentors
- Andreas 'ads' Scherbaum, Federico Campoli
- Organization
- PostgreSQL
- Technologies
- python, mysql, postgresql, regexp
- Topics
- database, Parsing
The pg_chameleon library translates DDL from MySQL dialect to PostgreSQL dialect. In doing this, there is an intermediate tokenization step. This step makes sense of the input DDL by identifying parts of the DDL such as command, table name, and column definitions. This has currently gotten quite big and hard to change. The scope of this project would be to make it simpler and easy to change. Once that is done, we go on to expand its capabilities so that it can make changes before returning its output, parse the CREATE INDEX statement, and ignore some specific statements when required.