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

[Sergei]

Hi, Siddharth!

First: please send questions like this to maria-developers@lists.launchpad.net
it's a public mailing list dedicated to MySQL and MariaDB internals, source
code, and related things. I am subscribed, so I'll see you mail there, and you
may be sure I will, because it won't be accidentally catched by my spam filter,
or sorted out in some obscure folder. Furthermore other subscribers will see
your question and could reply if I will be not available (e.g. I could be
travelling).
Thank you.

On Mar 11, Siddharth Dalmia wrote:
 Hi Sergei,
 
 I am interested in working on the project. I am new to the open source
 world so, can you tell how i should go forward? Do I need to work on
 something and show?

No, this is not required, but if you do it'll be a bonus point for you -
you'll get familiar with MariaDB source code and would be able to write
a better proposal.

Everything you have to do and how you should move forward is written at
the GSoC site. See http://www.google-melange.com/gsoc/homepage/google/gsoc2014

Regards,
Sergei

___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

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

[Sergei]

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


___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp