← Back to team overview

maria-developers team mailing list archive

Re: Maria DB project aspirant for GSoC 2014 : CREATE OR REPLACE, CREATE IF NOT EXISTS, and DROP IF EXISTS

 

Hi, Siddharth!

On Mar 08, Siddharth Dalmia wrote:
> Hello Sergei and all,
> 
> I am Siddharth Dalmia a second year undergraduate pursuing Computer
> Science Engineering from Birla Institute Technology and Science (BITS)
> Pilani, Hyderabad Campus.
> 
> I have a keen interest in programming and learning algorithms. I have a
> deep knowledge in C , C++ and sql. I have even done various projects in
> C++ including graphics. I have an average knowledge of data structures,
> java, Linux, html, css. I am also currently working on a project on
> concurrency in databases. I have a thorough knowledge in relational
> algebra and i have been using sql since 3 years (oracle and mysql).
> 
> I have gone through various projects of your's for GSOC and the one
> which interest me a most is CREATE OR REPLACE, CREATE IF NOT EXISTS, and
> DROP IF EXISTS . I am very keen to be a part of this project as it is
> something which i think its something which i am learning/learnt to put
> to use.
> 
> I know that i am a bit late, but it is not an end and i believe that i
> can work hard with dedication to make a good and convincing proposal. It
> will be very nice of you if you guide me on how to go about this project
> and from where i could start and elaborate what i need to do.

There's not much to add to the specifications.

There is CREATE TABLE statement, CREATE TABLE IF NOT EXISTS statement,
CREATE OR REPLACE TABLE statement.

There is CREATE USER statetement, but no CREATE USER IF NOT EXISTS and
no CREATE OR REPLACE USER.

There is CREATE PROCEDURE, but neither CREATE PROCEDURE IF NOT EXISTS
nor CREATE OR REPLACE PROCEDURE.

And so on. We'd like to have a consistent syntax and support "IF NOT
EXISTS" and "OR REPLACE" for all CREATE statements where possible.

And the same for DROP IF EXISTS

Regards,
Sergei