‘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.

history of ‘hello world’…

Hello World

Have you ever come across this word? If you have learnt any programming language in your life, I bet the answer is ‘yes’. I can still remember my school days when I used to print ‘Hello World’ in QBasic. Since then, I have learnt many other programming languages and every time the first chapter happens to begin from Hello World. So, I thought of researching on it a bit.