‘QCompiler’ – SQL Syntax Checker using lex and yacc

As the name suggests, QCompiler is an SQL Syntax Checker that was build using lex and yacc. I made this in my Compiler Design Class and in ONE NIGHT! It wasn’t the best of experience but I managed to complete the mini-project with satisfactory result. The QCompiler will accept SQL Syntax embedded in html and check for any sql syntax error and also suggest proper correction.

The lex and yacc basically covers most of the SQL Commands like INSERT, DELETE, UPDATE, SELECT, GROUP BY etc. It provides the exact error like table name missing, keyword missing, variable missing, lots of parameters, keyword incorrect etc.

I have pushed the codes in my GITHUB. Be sure to check it out.

Thanks.

’til then.

Advertisements

2 thoughts on “‘QCompiler’ – SQL Syntax Checker using lex and yacc

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s