Re: Let's approach stored procedures
At 09:40 AM 9/11/01 +0200, Arnulf Kristiansen wrote: I have just started to look into the stored procedure issue. We will come up with a definite plan within a short period of time. It is true that there are solutions that would make transitions from another DBMS to MySQL easier however, I am leaning towards the ANSI standard rather than PL/SQL or Transact-SQL. Are the ANSI standard online somewhere ? I would be glad to read them too :) -- Claudio Cicali aka FleXer [EMAIL PROTECTED] http://www.flexer.it GPG Key Fingerprint = 2E12 64D5 E5F5 2883 0472 4CFF 3682 E786 555D 25CE - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Stored procedures (2)
I've got a tour on the web, searching for info and ideas, regarding the subject to implement some sort of stored procedure in mysql (remember Lets approach stored procedure thread ?) This was what I discovered - The Perl stored procedures (myperl project) in not a good idea at all, but, even if called poor man's stored procedure, I think that this project don't add, actually, stored procedure in the precise meamning of term. It add only a binding with Perl via UDF. It's a nice (and quite simple) hack. Dana Power, I've not take a look to _your_ hack, but I think this is the same approach. - I had searched everywhere the ANSI SQL3 directive... not luck. I only found a 1994 document where this directives were proposed It is quite incomprensile, though (like all standard doc I have read :) - I'm evalueting the IBM DB2 approach. Since the ol' COBOL days (rattles...) I remember the EXEC SQL ... END-EXEC commands embedded inside the COBOL as the host language. At compile time there was a cross-compile step the produced some code to get recompiled and finally linked and binded. This is also the (old?) informix approach, where SQL EXECs were embedded inside the C source, and then a cross-compile (or precompiler) make the dirty work, creating another C source that could finally be compiled and linked. But I don't know to have some (low skilled) SQL coders to be well skilled in some other language to write down a stored procedure. So here came my idea: use a SIMPLE language to write the logic of the stored procedure (no complex structures, definition and use of local variables, some test statement, error trapping, and of source free SQL coding), than use a precompiler to convert that source into the source of an UDF. At last, we had stored procedure written in a simple language, but compiled and used as UDFs. MySQL itself could then be used to store the packaging approach (as Oracle does), or other information regarding validation of the sp, last modification time, user... etc Just some thoughts Claudio Cicali mysql, database, tables - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Let's approach stored procedures
I think this is a little OT here, so after reading please indicate me where to talk about this subject. I'm a skilled programmer in C, C++ and others progr. lang. I have also a solid background in SQL and some RDMS (DB2, Oracle, SQLServer, and of course, Mysql). I'm going to attend a long period of holidays (finally) so, I thought: why don't try to implement stored procedures in mysql ? Now, on with the questions: I think that MySQL programmers had yet thinked on some way to implement sp, and I'd wish that someone say me: - No, dude it's impossible/too hard - No, dude, we are in the way to finish that by ourselves - No, dude, we never insert big patches in our official distribution branch, that does not belong to us Or, better, something more optimistic... I don't want to loose my time, in something that you know is impossible or too hard to get. Another question: At a first glance, I think Oracle PL/SQL is the best (afaik) programming language for sp, but, in the case we implement that language, should we go against some Oracle copytight infringment ? That's all, for now. database, mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Let's approach stored procedures
At 10.44 07/09/2001 -0500, Ed Carp wrote: Claudio Cicali ([EMAIL PROTECTED]) writes: At a first glance, I think Oracle PL/SQL is the best (afaik) programming language for sp, but, in the case we implement that language, should we go against some Oracle copytight infringment ? Why would you want to do such a thing? Isn't SQL good enough? I'm just trying to figure out your reasoning here, besides the same argument used by the XML crowd of it's the latest/greatest do-all-be-all-end-all, so everyone should be using it type of nonsense. Nice question, overall. Answers (partial list): - it's cool - where I work, we have a HUGE database-driven web-application. A lot of our businness logic is implemented via stored procedures, that act as black boxes for the web-designers. Think of enterprise java beans. They are not nonsense or such. They are usefull. (I know, you can use ejb with JDBS and mysql..., but if you want to have some logic incapsualted, you should use some kind of component) - sp extends the RDBMS itself in its functionality. Think about some stupid check_fiscal_code() or insert_new_customer(). Web designers use the insert_new_customer, instead of using SQL directly. I think that there are others examples, but this is my point. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Let's approach stored procedures
At 11.03 07/09/2001 -0500, Ed Carp wrote: - it's cool Not a valid business reason. - where I work, we have a HUGE database-driven web-application. A lot of our business logic is implemented via stored procedures, that act as black boxes for the web-designers. Think of enterprise java beans. They are not nonsense or such. They are usefull. Stored procedures aren't nonsense, but using or re-implementing a particular vendor's implementation is. (I know, you can use ejb with JDBS and mysql..., but if you want to have some logic incapsualted, you should use some kind of component) - sp extends the RDBMS itself in its functionality. Think about some stupid check_fiscal_code() or insert_new_customer(). Web designers use the insert_new_customer, instead of using SQL directly. These are all great reasons to implement stored procedures, not Oracle PL/SQL. I think I'm missing your point here... No, sorry, it's me :) I haven't got your point. All, clear, now. bye - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Reply-to and this list
At 11:13 AM 8/30/01 +0200, Carl Troein wrote: A quick question: How come the mailing list software doesn't add a reply-to header? Is this intentional to keep replies off the mysql list, and if so why? I'll try to remember to reply to the list rather than directly to the people who ask the questions, as replying in private does little to stop the same questions from reappearing, and if there's something this list has too much of it's the same questions over and over... :-o There is also a famous document about reply-to: http://www.unicom.com/pw/reply-to-harmful.html -- Claudio Cicali aka FleXer [EMAIL PROTECTED] http://www.flexer.it GPG Key Fingerprint = 2E12 64D5 E5F5 2883 0472 4CFF 3682 E786 555D 25CE - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication: Push by Master or Pop by Slaves ?
There is an issue that confuse me a bit, altough it is not important for an operational point of view: From the manual: The master server keeps a binary log of updates and an index file to binary logs to keep track of log rotation. The slave, upon connecting, informs the master where it left off since the last successfully propagated update, catches up on the updates, and then blocks and waits for the master to notify it of the new updates. So, it seems that is the master that pushes information to the slave(s) But I can also read: MySQL replication is based on the server keeping track of all changes to your database (updates, deletes, etc) in the binary log and the slave server(s) reading the saved queries from the master server's binary log so that the slave can execute the same queries on its copy of the data. Here, seems that are the slaves that pop data from master. So where is the truth ? Is the master that pushes or the slaves the pops ? Or it is a combination of the two ? Thanks. -- Claudio Cicali aka FleXer [EMAIL PROTECTED] http://www.flexer.it GPG Key Fingerprint = 2E12 64D5 E5F5 2883 0472 4CFF 3682 E786 555D 25CE - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Editing code on WinNT
At 03:56 PM 8/22/01 +0100, DL Neil wrote: Does one of our more experienced brethren know of an article/web page comparing offerings/discussing a good editor to use when working on MySQL and PHP code please? I use WinNT and 2000 platforms and am new to Open System tools (although 'old' in the business). Please advise, =dn I don't understand the relation between the use of an editor and the Open Source systems. Anyway, consider Ultraedit (www.ultraedit.com). It is the most powerful stand-alone editor I ever seen (exception: GNU Emacs) for the Windows platform. Syntax hilight is provided for most of programming languages on this planet. (SQL and PHP, of course). Give it a try. -- Claudio Cicali aka FleXer [EMAIL PROTECTED] http://www.flexer.it GPG Key Fingerprint = 2E12 64D5 E5F5 2883 0472 4CFF 3682 E786 555D 25CE - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Delete user problem
At 12:54 PM 8/21/01 +0200, Marcin Pyla wrote: Hi, I have problem with delete user: I login to mysql as root'a and I do: mysql delete from user where user='admin80' and Host='%'; Query OK, 1 row affected (0.07 sec) Try to escape the '%' character as '\%' (just a guess, I haven't tried it) -- Claudio Cicali aka FleXer [EMAIL PROTECTED] http://www.flexer.it GPG Key Fingerprint = 2E12 64D5 E5F5 2883 0472 4CFF 3682 E786 555D 25CE - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Import from Access to MySql
At 09:43 AM 8/21/01 -0300, Gabriel wrote: Anyone can tell me how can i import an access db to mysql. Thanks in advance, Gabriel. Convert the access data into text file, comma separated (CSV) then use LOAD DATA INFILE c:\textfile INTO TABLE table_name You can get additional hints using Google, as usual (try mysql access convert) -- Claudio Cicali aka FleXer [EMAIL PROTECTED] http://www.flexer.it GPG Key Fingerprint = 2E12 64D5 E5F5 2883 0472 4CFF 3682 E786 555D 25CE - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: VB with MySQL
At 06:12 PM 8/21/01 -0300, Pablo Javier Gonzalez Mateos wrote: Hello, im new in the list, im a VB 6.0 programmer, and im learning the MySQL basics with the Paul DuBois Book... i have a question to do... its possible to make a connection from an VB app. to a MySQL database ???, if its possible, how can i do it ???. Have you never heard of... ODBC ? :) -- Claudio Cicali aka FleXer [EMAIL PROTECTED] http://www.flexer.it GPG Key Fingerprint = 2E12 64D5 E5F5 2883 0472 4CFF 3682 E786 555D 25CE - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php