Re: [Maria-developers] New MariaDB builds: regular trusty and special kvm-deb-sid-pbuilder-amd and (Re: MariaDB)
2014-03-06 12:20 GMT+02:00 Kristian Nielsen : >> I assumed this meant that Kristian would finish the setup. Kristian, >> are you following this? > > I am. Unfortunately, I am extremely busy at the moment with several tasks. > > I will try to get something done within a week or so, if > possible... meanwhile, if you can make a list as detailed as possible about > what you want me to do, that would be a great help. At the moment I am not > sure about what exactly I need to do... Stuff like file names, repository > URLs, how to get buildbot notifications from github, ... This was actually already pretty detailed: https://lists.launchpad.net/maria-developers/msg06767.html You can just copy-paste. And for Github integration - what options in the build bot is there for accepting notifications? Can build bot do something like this http://developer.github.com/webhooks/testing/ ? If not, then the commands I sent can just be but in a cron job and run daily. There is the 'git fetch -- if HEAD..master' check that will yield true only if there are new commits and then run the build commands. -- Check out our blog at http://seravo.fi/blog and follow @ottokekalainen ___ 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] Rev 4033: MDEV-5766 - my_atomic_load does memory writes
Hi, Sergey! On Mar 07, Sergey Vojtovich wrote: > revno: 4033 > revision-id: s...@mariadb.org-20140307074306-i3l4fllu2rj5pouf > parent: s...@mariadb.org-20140306121912-i1p8iilpsgc8m4bn > committer: Sergey Vojtovich > branch nick: 10.0 > timestamp: Fri 2014-03-07 11:43:06 +0400 > message: > MDEV-5766 - my_atomic_load does memory writes > > my_atomic_load() is implemented as __sync_fetch_and_or(var, 0) which > writes or-ed value back to var. Memory writes as such have worse > performance and scalability than reads. > > gcc 4.7 and up offers better facility for atomic loads/stores. Use it > whenever it is available. Thanks. ok to push 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] Some questions on GSOC project User Defined Event
Hi, Savita! On Mar 09, Savita Agrawal wrote: > If we want the application developers to take advantage from events > occurring on a table then we could reuse a plugin from drizzle > database which one of friends developed as part of gsoc last year. > This plugin allows the drizzle client to call a function > wait_for(type_of_event, table_name, num_of_events, time_out) and > returns when this event occurs in the table the given number fo times. > Currently drizzle uses this in their replication slave as well. I am > not sure how stable this plugin is. Yes, it's similar, in a sense. But our GSoC task is about SQL interface for this feature, not about protocol or C-API changes. 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] Some questions on GSOC project User Defined Event
Hi, Savita! On Mar 09, Savita Agrawal wrote: > > As far as I know user defined events are supposed to save applications > resources used in polling. But I think the application developer could > have created a trigger and udf and use lib_mysqludf_sys to invoke > external application. But there are security issues in this method. > Is it the primary/only reason for this project? It has little to do with external applications. The idea is to be able to wait for something to happen. It might be used with external applications, I agree: WAIT EVENT WHEN mysqldump_finished BEGIN ... END and then run mysqldump (in another window) that will POST mysqldump_finished. But waiting could also be useful without external applications. 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] Some questions on GSOC project User Defined Event
Hi, Savita! On Mar 08, Savita Agrawal wrote: > > what is the difference between a trigger and user defined event? A main difference: a trigger is automatially run by DBMS when something happens. User defined event - you need to wait for it, it's more procedural programming. > In postgres there is a clear distintion between trigger and event > trigger. Triggers are activated when DML statements are executed whereas > event triggers are activated when DDL statements are executed. No, that's unrelated. > But in soliddb (from which our post in JIRA page is inspired), it > seems like user defined events can be activated for DML statements. > What is it that can't be done with triggers and can be done with user > defined event? Waiting for something to happen. You cannot wait with a trigger. > Why is the restriction that events can only be posted and received by > stored procedures only? I'd say, events can be posted from anywhere, not only a stored procedure. But received - yes, only there, because we don't support compund statements outside of a stored routine yet. 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] Project in GSOC 2014.
Hi Sergei, Thanks for your response. I can understand. Now I am interested as a person who is willing to contribute to the Java Connector not as a GSOC project. I am waiting for the next set of tasks to be added for the Java Connector new version. I proposed certain new things that can be added to the Java Connector. Here are the things that I proposed: *The feature is:* * RowSetFactoryInterface and RowSetProviderClass as per JDBC Spec 4.1 which is not part of latest Java connector version * *JDBC 1.1.6* *Benefit:* *Any types of row sets that are supported by the JDBC Driver can be created.e.g JDBCRowSet,CachedRowSet in MySQL* *One Last Question:* *I have seen the source code of Java Connector and I understood they are made in Java 6.* *Are there any plans to migrate the code from Java 6 to Java 7?* I will be more than happy to receive a response on above. Regards Puneet. On Mon, Mar 10, 2014 at 5:04 PM, Sergei Golubchik wrote: > Hi, Puneet! > > > I appreciate your response. > > But It will be really good if you can provide me the details of future > > tasks in the project. > > I will choose certain tasks and prepare the propsal.In case, help is > > required I can ask in the community. > > The whole community is a mentor. > > A mentor in GSoC is a well defined role, a mentor fills out evaluation > forms, a mentor takes the responsibility, a mentor has an account in > melange, after all. The whole community can help, but it cannot be a > "mentor" in the GSoC sense. It has to be a person. > > 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] [Gsoc] LDAP authentication plug-in project
Hi, Sudheera! On Mar 09, Sudheera Palihakkara wrote: > Hi all, > It seems we need openldap-devel libraries for the client ldap. I'm not sure > about the way how I can add these libraries in maria code. I mean of course > I can install these libraries when the maria is build and install, but > there should be a proper way the dir structure etc etc, Can you help me out > please. just treat them as any other external library. Detect whether openldap-devel is present in your CMakeLists.txt. There are numerous examples in our cmake files and online cmake manual is very helpful too. 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
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
Re: [Maria-developers] Project in GSOC 2014.
Hi, Puneet! > I appreciate your response. > But It will be really good if you can provide me the details of future > tasks in the project. > I will choose certain tasks and prepare the propsal.In case, help is > required I can ask in the community. > The whole community is a mentor. A mentor in GSoC is a well defined role, a mentor fills out evaluation forms, a mentor takes the responsibility, a mentor has an account in melange, after all. The whole community can help, but it cannot be a "mentor" in the GSoC sense. It has to be a person. 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
