Re: New Idea
how much more efficient would it be to write the same statements to a text file, and then fork a child thread to connect to the database, and read the entire infile at once? If I understand you correctly, this is addressed in the section of the manual to which I previously referred you. From said section: When loading a table from a text file, use LOAD DATA INFILE. This is usually 20 times faster than using a lot of INSERT statements. See section 6.4.9 LOAD DATA INFILE Syntax. would MySQL run better on a quad ppro 200 (IBM PC704), or a similarily stocked 2.5ghz P4 single processor system? Most likely the P4. I don't believe Pentium Pros support hyperthreading, which would actually allow the database tasks to be split between the processors. I may be mistaken, but I'm fairly confident here. A great deal of skepticism about the multi-processor Pentium systems, especially older ones, always stemmed from the fact that neither the processor or the OS (in the case of Windows) was capable of making full use of a multi-proc architecture. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Shane Bryldt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, 16 June, 2003 17:30 Subject: New Idea Hello again, After realizing the obvious implementation flaws, I thought of a new idea and again, would appreciate some feedback on the efficiency benefits. My last post involved INSERT vs UPDATE efficiency. Neither is going to be a directly useful approach. With 48k records and growing for just one table of 2, the dump time was significantly too slow. Here is my new idea. Instead of directly communicating with MySQL, how much more efficient would it be to write the same statements to a text file, and then fork a child thread to connect to the database, and read the entire infile at once? There is some optimization for this , in addition to which writing the text file should only take a few seconds since it's a strict out stream write. Obviously this would increase performance of the client which dumps the text file, and also give an intermediary level of preventing data loss, if the import didn't go for some unpredictable reason, the file could still be imported prior to restarting the application. Has anyone used this sort of method, does it pose any issues I haven't considered? I also realized I am running 4.0.10-gamma, precompiled for FreeBSD packages. I will be compiling 4.0.13 with linuxthreads to gain any benefits there as well. Thanks, -Shane p.s. I always find a last question. Off topic, compiled properly for each machine, would MySQL run better on a quad ppro 200 (IBM PC704), or a similarily stocked 2.5ghz P4 single processor system? Curious for expected results on a new development server versus production server. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: RE: FAQ hosting site (was Re: An Idea) (fwd)
sql,query,queries,smallint On Thu, 2 Jan 2003, Peter Lovatt wrote: I was looking for a reasonably heavyweight php application, there are some lightweight ones and some half finished ones and some perl ones, but none that were what I was looking for. Any suggestions would be appreciated, no point in reinventing the wheel. I prefer FAQ-O-Matic. http://faqomatic.sourceforge.net/faq.pl Good Luck, -- Boyd Gerber [EMAIL PROTECTED] ZENEZ1042 East Fort Union #135, Midvale Utah 84047 - 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: FAQ hosting site (was Re: An Idea)
Yes, you need to specify the IP address that you plan on using for this process instead of the computer name. If you use Windows, chances are your using MYODBC or some other similar driver. Case #1: You setup a DSN in the ODBC area of the OS Case #2 You setup a DSN-less connection to your db. Case #2 has actually worked much faster for me. You can just put the IP in your connection code and off you go. Either way, you need to do this because the OS cannot resolve how you want it done. Just to make sure it is two NIC's that is causing your problem, disable one in the IP configuration area and give it a try. If you still cannot connect to your db, then something else may also be wrong. Bruce - Original Message - From: Peter Lovatt [EMAIL PROTECTED] To: mnbv [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 6:25 PM Subject: RE: FAQ hosting site (was Re: An Idea) Hi Is '111' the IP it is trying to connect on? If so it is an invalid IP. If the IP is valid how are you trying to connect? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: mnbv [mailto:[EMAIL PROTECTED]] Sent: 02 January 2003 00:23 To: Peter Lovatt; Stefan Hinz, iConnect (Berlin); David T-G; mysql users Subject: RE: FAQ hosting site (was Re: An Idea) I really need your help, I installed MySQL and I can connect to it through localhost but when trying to access it from outside I get: ERROR 2003: Can't connect to MySQL server on 'IP' (111) Any suggestions? Someone suggested that the problem is because the server has 2 nics (2 ips set up). Does anyone know a solution for this? --- Peter Lovatt [EMAIL PROTECTED] wrote: Hi Like the look of the way its taking shape. I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) we could use, or if someone can do a better job :) but I have a content management system written, together with a lot of the search functionality needed for the faq. It can mix database stored content with static content, so it would probably do the job with a little work. It also does the membership authorisation/management. I'd be happy to build the software, if that helps. Let me know Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 01 January 2003 21:26 To: David T-G; mysql users Subject: Re: FAQ hosting site (was Re: An Idea) David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer
Re: FAQ hosting site (was Re: An Idea)
Why not try Tek-Tips? Maybe they will sponsor something for free. They may have everything you need. Just a thought. [EMAIL PROTECTED] [EMAIL PROTECTED] Bruce - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Peter Lovatt [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; David T-G [EMAIL PROTECTED]; mysql users [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 6:36 PM Subject: Re: FAQ hosting site (was Re: An Idea) On Wed, Jan 01, 2003 at 11:08:58PM -, Peter Lovatt wrote: I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) Really? That's a wheel I've seen re-invented many times. I know there's stuff out there. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 17 days, processed 617,666,871 queries (401/sec. avg) - 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 - 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: An Idea
R. Hannes Niedner wrote: Isn't that funny: if I have a mysql related question and search google I end up in the mysql online documentation in 90% of cases. I find if I just use the word 'mysql' in my query on Google, I get fairly appropriate results too. Not using the word mysql often gives me generic SQL responses regarding many products (often MS SQL Server, since they decided to use the lone word 'sql' in its name). -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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: An Idea
David, Oh, to be sure. And maybe we could even get the mysql.com folks to prominently list a pointer to the off-site FAQ if they don't want to maintain it or give out accounts to maintain it. I just wouldn't want to see it dropped if they don't jump on it at the start. I agree. Will you set it up at http://justpickone.org/? (BTW, I like your website, especially the PIX :-) Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: David T-G [EMAIL PROTECTED] To: mysql users [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 1:35 AM Subject: Re: An Idea -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % regarding the MySQL FAQ: % % Why should it have to be there? Let anyone with a site set it up and ... % % MySQL.com would be the natural place for the FAQ. Any other place % wouldn't be half as good. Oh, to be sure. And maybe we could even get the mysql.com folks to prominently list a pointer to the off-site FAQ if they don't want to maintain it or give out accounts to maintain it. I just wouldn't want to see it dropped if they don't jump on it at the start. HAND Happy New Year mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EjfnGb7uCXufRwARAvWNAJ9GWPaZm2tjJh4pdQNNG7EV9cdxLACdGWpV tC44gsIMkjgUkNtZlkpZ+Y0= =XS30 -END PGP SIGNATURE- - 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: An Idea
James, something that can be based upon pages of htm and emails that exists, and that can sit under a few web pages using Htdig or alkaline or something... Do these tools work better that the search tool (Mnogo search) at http://lists.mysql.com/php/search.php? This thing sucks - I was looking for mysql_fix_privilege_tables, and it found nothing! Guten Rutsch Danke, Dir auch! Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: JamesD [EMAIL PROTECTED] To: David T-G [EMAIL PROTECTED]; mysql users [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 5:11 AM Subject: RE: An Idea we find people just like to ask questions, and no matter how good our FAQ's and help are, many people have circumstances that make it more efficient to push the question into the queue, and wait for an answer to pop back later. lists work, and faq's work, some like to call...etc. personally, I'd prefer a search engine style... like google, but only for mySQL topics, and with a visible list of most popular search terms. something that can be based upon pages of htm and emails that exists, and that can sit under a few web pages using Htdig or alkaline or something... Guten Rutsch Jim -Original Message- From: David T-G [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 4:36 PM To: mysql users Cc: Stefan Hinz, iConnect (Berlin) Subject: Re: An Idea -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % regarding the MySQL FAQ: % % Why should it have to be there? Let anyone with a site set it up and ... % % MySQL.com would be the natural place for the FAQ. Any other place % wouldn't be half as good. Oh, to be sure. And maybe we could even get the mysql.com folks to prominently list a pointer to the off-site FAQ if they don't want to maintain it or give out accounts to maintain it. I just wouldn't want to see it dropped if they don't jump on it at the start. HAND Happy New Year mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EjfnGb7uCXufRwARAvWNAJ9GWPaZm2tjJh4pdQNNG7EV9cdxLACdGWpV tC44gsIMkjgUkNtZlkpZ+Y0= =XS30 -END PGP SIGNATURE- - 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 - 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 - 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: FAQ hosting site (was Re: An Idea)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % see it dropped if they don't jump on it at the start. % % I agree. Will you set it up at http://justpickone.org/? (BTW, I like Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp (I wish we could sftp without then also having ssh; darn) and, meanwhile, it seems like this should be the sort of thing where we could either use CVS or a web update form or the like... Maybe a wiki will do for now, but I don't like only being able to get at it from the web :-) Anyone have any thoughts? % your website, especially the PIX :-) Thanks! :-) It needs an overhaul, but it gets the job done. % % Regards, % -- % Stefan Hinz [EMAIL PROTECTED] % Geschäftsführer / CEO iConnect GmbH http://iConnect.de % Heesestr. 6, 12169 Berlin (Germany) % Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 HTH HAND HNY :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EwVbGb7uCXufRwARAmHWAJ9j2Zd/syBro07AQ5hj0n7lAeeFMACfYch+ QFYwxXNLMvUSbTYxxp2JQOE= =g9Q2 -END PGP SIGNATURE- - 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: An Idea
alkaline has been around awhile. the model is similiar to mysql in that they have a commercial version that sustains them, and a free version that sustains the rest of us. there is not a doubt that its better than the php script you refer to below... http://alkaline.vestris.com/docs/alkaline-faq/af-general.html#AF-GEN-WHY its claim is very high speed searching, partial word searching, multiple remote site indexing and spidering etc. good for high speed results on a document set of 500,000 pages or so. with a list of mysql urls to spider and index, it can be setup and live, fast. Jim -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 01, 2003 5:31 AM To: JamesD; David T-G; mysql users Subject: Re: An Idea James, something that can be based upon pages of htm and emails that exists, and that can sit under a few web pages using Htdig or alkaline or something... Do these tools work better that the search tool (Mnogo search) at http://lists.mysql.com/php/search.php? This thing sucks - I was looking for mysql_fix_privilege_tables, and it found nothing! Guten Rutsch Danke, Dir auch! Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: JamesD [EMAIL PROTECTED] To: David T-G [EMAIL PROTECTED]; mysql users [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 5:11 AM Subject: RE: An Idea we find people just like to ask questions, and no matter how good our FAQ's and help are, many people have circumstances that make it more efficient to push the question into the queue, and wait for an answer to pop back later. lists work, and faq's work, some like to call...etc. personally, I'd prefer a search engine style... like google, but only for mySQL topics, and with a visible list of most popular search terms. something that can be based upon pages of htm and emails that exists, and that can sit under a few web pages using Htdig or alkaline or something... Guten Rutsch Jim -Original Message- From: David T-G [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 4:36 PM To: mysql users Cc: Stefan Hinz, iConnect (Berlin) Subject: Re: An Idea -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % regarding the MySQL FAQ: % % Why should it have to be there? Let anyone with a site set it up and ... % % MySQL.com would be the natural place for the FAQ. Any other place % wouldn't be half as good. Oh, to be sure. And maybe we could even get the mysql.com folks to prominently list a pointer to the off-site FAQ if they don't want to maintain it or give out accounts to maintain it. I just wouldn't want to see it dropped if they don't jump on it at the start. HAND Happy New Year mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EjfnGb7uCXufRwARAvWNAJ9GWPaZm2tjJh4pdQNNG7EV9cdxLACdGWpV tC44gsIMkjgUkNtZlkpZ+Y0= =XS30 -END PGP SIGNATURE- - 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 - 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 - 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 - 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
Re: FAQ hosting site (was Re: An Idea)
David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer to in a mailing list, and easier to click. Maybe we can set up Alkaline on those html files, as an alternative search for the database search. 3. Authors should be instructed to first search via the end user interface before inserting a new entry. If they do want to insert something new, they should simply select category, difficulty, paste the question, type (or paste) the answer. 4. The author login should be extremely convenient, with a persistent cookie, so an author will not actually have to login more than once (from the same browser/machine). 5. An author should be able to insert new content and to update his / her own content, nothing else. - What I said about database design applies to the frontend, too. We can make it more complex later on, when the need arises. We can have user contributed notes, fine grained search criteria, etc. In the beginning, I would suggest to follow the KISS principle (keep it simple stupid). I send this to the list, because a) maybe someone has written exactly what we want, or can give a URL to where to find it, b) maybe someone has better ideas or comments on this. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Great. We should discuss everything else via this list, then. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: David T-G [EMAIL PROTECTED] To: mysql users [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 4:12 PM Subject: Re: FAQ hosting site (was Re: An Idea) -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % see it dropped if they don't jump on it at the start. % % I agree. Will you set it up at http://justpickone.org/? (BTW, I like Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp (I wish we could sftp without then also having ssh; darn) and, meanwhile, it seems like this should be the sort of thing where we could either use CVS or a web update form or the like... Maybe a wiki will do for now, but I don't like only being able to get at it from the web :-) Anyone have any thoughts? % your website, especially the PIX :-) Thanks! :-) It needs an overhaul, but it gets the job done. % % Regards, % -- % Stefan Hinz [EMAIL PROTECTED] % Geschäftsführer / CEO iConnect GmbH http://iConnect.de % Heesestr. 6, 12169 Berlin (Germany) % Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 HTH HAND HNY :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur
RE: FAQ hosting site (was Re: An Idea)
I'm not following this threath.. but.. Use PHP to fetch mail from a mailbox, insert all questions into a database. Create a searchtool to search the database. No need to have way to many ppl as author. If you want you could have some ppl maintaining a list of keywords per question or remove a question from the database.. If you really persist to create something of your own you shouldn't create catagories. Most ppl don't really understand under which catagory their question could be found. Those who do will probably find an answer much quicker using google. --B. -Oorspronkelijk bericht- Van: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Verzonden: woensdag 1 januari 2003 22:26 Aan: David T-G; mysql users Onderwerp: Re: FAQ hosting site (was Re: An Idea) David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer to in a mailing list, and easier to click. Maybe we can set up Alkaline on those html files, as an alternative search for the database search. 3. Authors should be instructed to first search via the end user interface before inserting a new entry. If they do want to insert something new, they should simply select category, difficulty, paste the question, type (or paste) the answer. 4. The author login should be extremely convenient, with a persistent cookie, so an author will not actually have to login more than once (from the same browser/machine). 5. An author should be able to insert new content and to update his / her own content, nothing else. - What I said about database design applies to the frontend, too. We can make it more complex later on, when the need arises. We can have user contributed notes, fine grained search criteria, etc. In the beginning, I would suggest to follow the KISS principle (keep it simple stupid). I send this to the list, because a) maybe someone has written exactly what we want, or can give a URL to where to find it, b) maybe someone has better ideas or comments on this. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Great. We should discuss everything else via this list, then. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: David T-G [EMAIL PROTECTED] To: mysql users [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 4:12 PM Subject: Re: FAQ hosting site (was Re: An Idea) -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % see it dropped if they don't jump on it at the start. % % I agree. Will you set it up at http://justpickone.org/? (BTW, I like Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp (I wish we could sftp without then also having ssh; darn) and, meanwhile, it seems like this should be the sort
RE: FAQ hosting site (was Re: An Idea)
Hi Like the look of the way its taking shape. I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) we could use, or if someone can do a better job :) but I have a content management system written, together with a lot of the search functionality needed for the faq. It can mix database stored content with static content, so it would probably do the job with a little work. It also does the membership authorisation/management. I'd be happy to build the software, if that helps. Let me know Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 01 January 2003 21:26 To: David T-G; mysql users Subject: Re: FAQ hosting site (was Re: An Idea) David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer to in a mailing list, and easier to click. Maybe we can set up Alkaline on those html files, as an alternative search for the database search. 3. Authors should be instructed to first search via the end user interface before inserting a new entry. If they do want to insert something new, they should simply select category, difficulty, paste the question, type (or paste) the answer. 4. The author login should be extremely convenient, with a persistent cookie, so an author will not actually have to login more than once (from the same browser/machine). 5. An author should be able to insert new content and to update his / her own content, nothing else. - What I said about database design applies to the frontend, too. We can make it more complex later on, when the need arises. We can have user contributed notes, fine grained search criteria, etc. In the beginning, I would suggest to follow the KISS principle (keep it simple stupid). I send this to the list, because a) maybe someone has written exactly what we want, or can give a URL to where to find it, b) maybe someone has better ideas or comments on this. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Great. We should discuss everything else via this list, then. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: David T-G [EMAIL PROTECTED] To: mysql users [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 4:12 PM Subject: Re: FAQ hosting site (was Re: An Idea) -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % see it dropped if they don't jump on it at the start. % % I agree. Will you set it up at http://justpickone.org/? (BTW, I like Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Now
RE: FAQ hosting site (was Re: An Idea)
I really need your help, I installed MySQL and I can connect to it through localhost but when trying to access it from outside I get: ERROR 2003: Can't connect to MySQL server on 'IP' (111) Any suggestions? Someone suggested that the problem is because the server has 2 nics (2 ips set up). Does anyone know a solution for this? --- Peter Lovatt [EMAIL PROTECTED] wrote: Hi Like the look of the way its taking shape. I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) we could use, or if someone can do a better job :) but I have a content management system written, together with a lot of the search functionality needed for the faq. It can mix database stored content with static content, so it would probably do the job with a little work. It also does the membership authorisation/management. I'd be happy to build the software, if that helps. Let me know Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 01 January 2003 21:26 To: David T-G; mysql users Subject: Re: FAQ hosting site (was Re: An Idea) David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer to in a mailing list, and easier to click. Maybe we can set up Alkaline on those html files, as an alternative search for the database search. 3. Authors should be instructed to first search via the end user interface before inserting a new entry. If they do want to insert something new, they should simply select category, difficulty, paste the question, type (or paste) the answer. 4. The author login should be extremely convenient, with a persistent cookie, so an author will not actually have to login more than once (from the same browser/machine). 5. An author should be able to insert new content and to update his / her own content, nothing else. - What I said about database design applies to the frontend, too. We can make it more complex later on, when the need arises. We can have user contributed notes, fine grained search criteria, etc. In the beginning, I would suggest to follow the KISS principle (keep it simple stupid). I send this to the list, because a) maybe someone has written exactly what we want, or can give a URL to where to find it, b) maybe someone has better ideas or comments on this. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Great. We should discuss everything else via this list, then. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: David T-G [EMAIL PROTECTED] To: mysql users [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED
RE: FAQ hosting site (was Re: An Idea)
Hi Is '111' the IP it is trying to connect on? If so it is an invalid IP. If the IP is valid how are you trying to connect? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: mnbv [mailto:[EMAIL PROTECTED]] Sent: 02 January 2003 00:23 To: Peter Lovatt; Stefan Hinz, iConnect (Berlin); David T-G; mysql users Subject: RE: FAQ hosting site (was Re: An Idea) I really need your help, I installed MySQL and I can connect to it through localhost but when trying to access it from outside I get: ERROR 2003: Can't connect to MySQL server on 'IP' (111) Any suggestions? Someone suggested that the problem is because the server has 2 nics (2 ips set up). Does anyone know a solution for this? --- Peter Lovatt [EMAIL PROTECTED] wrote: Hi Like the look of the way its taking shape. I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) we could use, or if someone can do a better job :) but I have a content management system written, together with a lot of the search functionality needed for the faq. It can mix database stored content with static content, so it would probably do the job with a little work. It also does the membership authorisation/management. I'd be happy to build the software, if that helps. Let me know Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 01 January 2003 21:26 To: David T-G; mysql users Subject: Re: FAQ hosting site (was Re: An Idea) David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer to in a mailing list, and easier to click. Maybe we can set up Alkaline on those html files, as an alternative search for the database search. 3. Authors should be instructed to first search via the end user interface before inserting a new entry. If they do want to insert something new, they should simply select category, difficulty, paste the question, type (or paste) the answer. 4. The author login should be extremely convenient, with a persistent cookie, so an author will not actually have to login more than once (from the same browser/machine). 5. An author should be able to insert new content and to update his / her own content, nothing else. - What I said about database design applies to the frontend, too. We can make it more complex later on, when the need arises. We can have user contributed notes, fine grained search criteria, etc. In the beginning, I would suggest to follow the KISS principle (keep it simple stupid). I send this to the list, because a) maybe someone has written exactly what we want
Re: FAQ hosting site (was Re: An Idea)
On Wed, Jan 01, 2003 at 11:08:58PM -, Peter Lovatt wrote: I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) Really? That's a wheel I've seen re-invented many times. I know there's stuff out there. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 17 days, processed 617,666,871 queries (401/sec. avg) - 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: FAQ hosting site (was Re: An Idea)
Hi I was looking for a reasonably heavyweight php application, there are some lightweight ones and some half finished ones and some perl ones, but none that were what I was looking for. Any suggestions would be appreciated, no point in reinventing the wheel. Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: 02 January 2003 00:37 To: Peter Lovatt Cc: Stefan Hinz, iConnect (Berlin); David T-G; mysql users Subject: Re: FAQ hosting site (was Re: An Idea) On Wed, Jan 01, 2003 at 11:08:58PM -, Peter Lovatt wrote: I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) Really? That's a wheel I've seen re-invented many times. I know there's stuff out there. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 17 days, processed 617,666,871 queries (401/sec. avg) - 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: FAQ hosting site (was Re: An Idea)
The 111 is the error code that MySQL generates. Check if your computer has a firewall, and make sure to enable port 3306 from external IPs e.g. on redhat using ipchains-based firewall, add: -A input -s 0/0 -d 0/0 3306 -p tcp -y -j ACCEPT to your /etc/sysconfig/ipchains file (or however the box is configured for the firewall). You'll also want to replace -s 0/0 with something a little more restrictive. cheers.. Dan On Thu, 2 Jan 2003, Peter Lovatt wrote: Hi Is '111' the IP it is trying to connect on? If so it is an invalid IP. If the IP is valid how are you trying to connect? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: mnbv [mailto:[EMAIL PROTECTED]] Sent: 02 January 2003 00:23 To: Peter Lovatt; Stefan Hinz, iConnect (Berlin); David T-G; mysql users Subject: RE: FAQ hosting site (was Re: An Idea) I really need your help, I installed MySQL and I can connect to it through localhost but when trying to access it from outside I get: ERROR 2003: Can't connect to MySQL server on 'IP' (111) Any suggestions? Someone suggested that the problem is because the server has 2 nics (2 ips set up). Does anyone know a solution for this? --- Peter Lovatt [EMAIL PROTECTED] wrote: Hi Like the look of the way its taking shape. I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) we could use, or if someone can do a better job :) but I have a content management system written, together with a lot of the search functionality needed for the faq. It can mix database stored content with static content, so it would probably do the job with a little work. It also does the membership authorisation/management. I'd be happy to build the software, if that helps. Let me know Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 01 January 2003 21:26 To: David T-G; mysql users Subject: Re: FAQ hosting site (was Re: An Idea) David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer to in a mailing list, and easier to click. Maybe we can set up Alkaline on those html files, as an alternative search for the database search. 3. Authors should be instructed to first search via the end user interface before inserting a new entry. If they do want to insert something new, they should simply select category, difficulty, paste the question, type (or paste) the answer. 4. The author login should
Re: An Idea
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz, iConnect (Berlin) said... % % So (taking a deep breath !) I would be prepared to lay the foundations ... % % Thanks, I appreciate that. I've been waiting a moment before answering, % waiting for others to take a deep breath and say yes, too, but it % seems you are the only one. I'd love to contribute, but not only am I very busy but also very new. I could probably contribute a lot of *questions*, but this FAQ is probably meant to also have *answers* :-) % % [James: ] $44.99 SRP - a low cost compared to the 'deep breath below % :-) % % I know there are good books, and I especially like Paul's books on % MySQL. There are good books by German authors on MySQL, too. I'm happy to hear of it; I may have to go out and pick it up! % % But, then again, refering to books will bring up the same sort of % answers people on this list are complaing about (hey, stupid, go buy % book xyz and read it before asking silly questions). With a FAQ, this Well, it would be nice to have a listing of readers' favorite and most helpful books so that newbies know *what* to go and pick out, for one thing; I don't think that book references are all bad! % could be You will find the answer for your question at % www.mysql.com/faq/answer_xyz.html. Yes; that's very good. % % So, any thoughts? Where do we go from here? % % Nowhere, I suppose :( Wait; quite on the contrary! I think that good work can start (granted, it would probably start faster if I jumped in to contribute more, but...) right now! % % Maybe some of the folks at MySQL AB will read this and come up with a % database structure for the FAQ on MySQL.com and user accounts for you % and me (and maybe others, once this thing has started). Why should it have to be there? Let anyone with a site set it up and get it going and see if readers will even care about it, and *then* perhaps have it move to mysql.com later... % % Regards, % -- % Stefan Hinz [EMAIL PROTECTED] % Geschäftsführer / CEO iConnect GmbH http://iConnect.de % Heesestr. 6, 12169 Berlin (Germany) % Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 HTH HAND Happy Holidays mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EXu2Gb7uCXufRwARAq2QAJ49JlM22lxrMndZLWf9BFzRvlrWQgCfU/LP M/PviclU9pDOmcKXOgmSPp8= =1os1 -END PGP SIGNATURE- - 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: An Idea
Hi A faq without questions would be pretty empty! While you have the questions why not keep a note (or send them to me) Once we have some momentum we can put some answers and tutorials together. I thought I would email MySql to see if they like the idea, if not then I will build it. Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: David T-G [mailto:[EMAIL PROTECTED]] Sent: 31 December 2002 11:13 To: mysql users Cc: Stefan Hinz, iConnect (Berlin) Subject: Re: An Idea -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz, iConnect (Berlin) said... % % So (taking a deep breath !) I would be prepared to lay the foundations ... % % Thanks, I appreciate that. I've been waiting a moment before answering, % waiting for others to take a deep breath and say yes, too, but it % seems you are the only one. I'd love to contribute, but not only am I very busy but also very new. I could probably contribute a lot of *questions*, but this FAQ is probably meant to also have *answers* :-) % % [James: ] $44.99 SRP - a low cost compared to the 'deep breath below % :-) % % I know there are good books, and I especially like Paul's books on % MySQL. There are good books by German authors on MySQL, too. I'm happy to hear of it; I may have to go out and pick it up! % % But, then again, refering to books will bring up the same sort of % answers people on this list are complaing about (hey, stupid, go buy % book xyz and read it before asking silly questions). With a FAQ, this Well, it would be nice to have a listing of readers' favorite and most helpful books so that newbies know *what* to go and pick out, for one thing; I don't think that book references are all bad! % could be You will find the answer for your question at % www.mysql.com/faq/answer_xyz.html. Yes; that's very good. % % So, any thoughts? Where do we go from here? % % Nowhere, I suppose :( Wait; quite on the contrary! I think that good work can start (granted, it would probably start faster if I jumped in to contribute more, but...) right now! % % Maybe some of the folks at MySQL AB will read this and come up with a % database structure for the FAQ on MySQL.com and user accounts for you % and me (and maybe others, once this thing has started). Why should it have to be there? Let anyone with a site set it up and get it going and see if readers will even care about it, and *then* perhaps have it move to mysql.com later... % % Regards, % -- % Stefan Hinz [EMAIL PROTECTED] % Geschäftsführer / CEO iConnect GmbH http://iConnect.de % Heesestr. 6, 12169 Berlin (Germany) % Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 HTH HAND Happy Holidays mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EXu2Gb7uCXufRwARAq2QAJ49JlM22lxrMndZLWf9BFzRvlrWQgCfU/LP M/PviclU9pDOmcKXOgmSPp8= =1os1 -END PGP SIGNATURE- - 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 - 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: An Idea
David, regarding the MySQL FAQ: Why should it have to be there? Let anyone with a site set it up and get it going and see if readers will even care about it, and *then* perhaps have it move to mysql.com later... MySQL.com would be the natural place for the FAQ. Any other place wouldn't be half as good. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - 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: An Idea
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % regarding the MySQL FAQ: % % Why should it have to be there? Let anyone with a site set it up and ... % % MySQL.com would be the natural place for the FAQ. Any other place % wouldn't be half as good. Oh, to be sure. And maybe we could even get the mysql.com folks to prominently list a pointer to the off-site FAQ if they don't want to maintain it or give out accounts to maintain it. I just wouldn't want to see it dropped if they don't jump on it at the start. HAND Happy New Year mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EjfnGb7uCXufRwARAvWNAJ9GWPaZm2tjJh4pdQNNG7EV9cdxLACdGWpV tC44gsIMkjgUkNtZlkpZ+Y0= =XS30 -END PGP SIGNATURE- - 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: An Idea
we find people just like to ask questions, and no matter how good our FAQ's and help are, many people have circumstances that make it more efficient to push the question into the queue, and wait for an answer to pop back later. lists work, and faq's work, some like to call...etc. personally, I'd prefer a search engine style... like google, but only for mySQL topics, and with a visible list of most popular search terms. something that can be based upon pages of htm and emails that exists, and that can sit under a few web pages using Htdig or alkaline or something... Guten Rutsch Jim -Original Message- From: David T-G [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 4:36 PM To: mysql users Cc: Stefan Hinz, iConnect (Berlin) Subject: Re: An Idea -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % regarding the MySQL FAQ: % % Why should it have to be there? Let anyone with a site set it up and ... % % MySQL.com would be the natural place for the FAQ. Any other place % wouldn't be half as good. Oh, to be sure. And maybe we could even get the mysql.com folks to prominently list a pointer to the off-site FAQ if they don't want to maintain it or give out accounts to maintain it. I just wouldn't want to see it dropped if they don't jump on it at the start. HAND Happy New Year mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EjfnGb7uCXufRwARAvWNAJ9GWPaZm2tjJh4pdQNNG7EV9cdxLACdGWpV tC44gsIMkjgUkNtZlkpZ+Y0= =XS30 -END PGP SIGNATURE- - 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 - 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: An Idea
On 12/31/02 8:11 PM, JamesD [EMAIL PROTECTED] wrote: lists work, and faq's work, some like to call...etc. personally, I'd prefer a search engine style... like google, but only for mySQL topics, and with a visible list of most popular search terms. something that can be based upon pages of htm and emails that exists, and that can sit under a few web pages using Htdig or alkaline or something... Guten Rutsch Jim Isn't that funny: if I have a mysql related question and search google I end up in the mysql online documentation in 90% of cases. JM2Cs /h - 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: An Idea
Peter, So (taking a deep breath !) I would be prepared to lay the foundations for a faq / knowledge base aimed specifically at this type of questions and to manage it. Thanks, I appreciate that. I've been waiting a moment before answering, waiting for others to take a deep breath and say yes, too, but it seems you are the only one. [James: ] $44.99 SRP - a low cost compared to the 'deep breath below :-) I know there are good books, and I especially like Paul's books on MySQL. There are good books by German authors on MySQL, too. But, then again, refering to books will bring up the same sort of answers people on this list are complaing about (hey, stupid, go buy book xyz and read it before asking silly questions). With a FAQ, this could be You will find the answer for your question at www.mysql.com/faq/answer_xyz.html. So, any thoughts? Where do we go from here? Nowhere, I suppose :( Maybe some of the folks at MySQL AB will read this and come up with a database structure for the FAQ on MySQL.com and user accounts for you and me (and maybe others, once this thing has started). Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Peter Lovatt [EMAIL PROTECTED] To: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; Cal Evans [EMAIL PROTECTED]; Paul DuBois [EMAIL PROTECTED]; Adam Wi´ckowski [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, December 30, 2002 1:18 AM Subject: RE: An Idea Hi My first thought was that the docs on mysql.com should do the job, but, although they answer most technical questions, often more down to earth stuff like 'How do I store images' or 'how do I get started with SQL' isn't there, or it is difficult to find. The other problem is that the documentation is often technical to point that it is difficult to understand, even as a reasonably competent database programmer. I think newbies (and not so newbies) could feel totally overwhelmed by much of it. So (taking a deep breath !) I would be prepared to lay the foundations for a faq / knowledge base aimed specifically at this type of questions and to manage it. So, any thoughts? Where do we go from here? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 29 December 2002 22:01 To: Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED] Subject: Re: An Idea Cal, Paul, dear list, thank you, Cal, for your wise words ... Here's the FAQ we developed so you don't have to waste our time asking questions that have already been answered. Go to MySQL.com and type FAQ in the search box. This will provide 71 results, some of them with valuable FAQ-like information, but no real FAQ. Instead, we have this in every list mail: Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) I would keep this shorter, saying Believe in God and do not sin ;-) But seriously: Anybody here interested in setting up a FAQ on MySQL.com / MySQL.de, - with silly common questions from this list, - and with answers in small tutorial format (something like http://www.mysql.com/articles/dotnet/index.html), - well organized (one person to collect / insert the silly questions), - easy to search (only search term + search by category), - easy to maintain (e. g. with user comments, like the English manual), - even easier to use as a referer than the MySQL manual when answering questions? Flame me if there _is_ a FAQ like this. At least I didn't find it at MySQL.com, which is most probably the first place a new MySQL user would look for it. I am the German translator of the official MySQL manual, so I could offer to translate as much as I can from the FAQ into German. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Cal Evans [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED]; Adam Wi´ckowski [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, December 29, 2002 6:00 PM Subject: RE: An Idea Because that's the way that (FoxPro, Access, Paradox, insert name of favorite desktop RDBMS here) did it and I can't make the jump to a real server based RDBMS! Why do you ask? :) Seriously, I find this type of issue (not your question Paul, the original question) one of the most troubling things about this list. We
Re: An Idea
Hello. On Sun 2002-12-29 at 11:26:01 +0100, [EMAIL PROTECTED] wrote: Hello, I had a problem few days ago. I'm doing my questbook, and I were thinking what would hapen if I delete some row. Now I know, nothing. I had one column ID (auto_increment) in my table. I wanted it to be one by one even after deleting, so I changed it by myself. But then (after deleting the last ID was 17, and before 32), next ID was 33, not 18. Is there any function, which can change it? If not, mayby you'll try to do something like that. It's right, I can do it by myself not using auto_increment, and giving the ID number MAX(ID)+1, but if there is such function it would be realy fine. What you describe was the behaviour in older MySQL versions and it has been changed because primary keys should never be reused. Never. If you need it to have no holes, you are abusing the primary key for something which it is not intended for (visible entry numbering?). So, yes, you have to either implement it yourself, or, what I would recommend, have a seperate column for it or calculate it in your application, whatever makes most sense for your use. HTH, Benjamin. PS: AFAIK, InnoDB still has the old behaviour. Anyhow, it will change soon enough. -- [EMAIL PROTECTED] - 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: An Idea
On Sunday 29 December 2002 12:26, Adam Wiêckowski wrote: I had a problem few days ago. I'm doing my questbook, and I were thinking what would hapen if I delete some row. Now I know, nothing. I had one column ID (auto_increment) in my table. I wanted it to be one by one even after deleting, so I changed it by myself. But then (after deleting the last ID was 17, and before 32), next ID was 33, not 18. Is there any function, which can change it? Nope. It's expected behaviour for MyISAM and InnoDB tables. If not, mayby you'll try to do something like that. It's right, I can do it by myself not using auto_increment, and giving the ID number MAX(ID)+1, but if there is such function it would be realy fine. Sure, you can do it, but you should lock table, retrieve max id value, insert max+1 value, unlock table. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: An Idea
At 11:26 +0100 12/29/02, Adam Wi´ckowski wrote: Hello, I had a problem few days ago. I'm doing my questbook, and I were thinking what would hapen if I delete some row. Now I know, nothing. I had one column ID (auto_increment) in my table. I wanted it to be one by one Why? even after deleting, so I changed it by myself. But then (after deleting the last ID was 17, and before 32), next ID was 33, not 18. Is there any function, which can change it? If not, mayby you'll try to do something like that. It's right, I can do it by myself not using auto_increment, and giving the ID number MAX(ID)+1, but if there is such function it would be realy fine. Greatings, MySQL user Adam Wi´ckowski GG# :1257924 - 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: An Idea
At 11:26 AM 12/29/2002 +0100, =?iso-8859-2?Q?Adam_Wi=EAckowski?= wrote: Hello, I had a problem few days ago. I'm doing my questbook, and I were thinking what would hapen if I delete some row. Now I know, nothing. I had one column ID (auto_increment) in my table. I wanted it to be one by one even after deleting, so I changed it by myself. Don't use the PK for numbering. Instead, in PHP, ASP, etc, just use a counter when looping through your guestbook entries and label them 1, 2, 3, etc. BTW, does MySQL have a RowNumber function? -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.com/ - 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: An Idea
Because that's the way that (FoxPro, Access, Paradox, insert name of favorite desktop RDBMS here) did it and I can't make the jump to a real server based RDBMS! Why do you ask? :) Seriously, I find this type of issue (not your question Paul, the original question) one of the most troubling things about this list. We as a community of SQL developers (regardless of dialect) need to make a more concentrated effort to explain the differences between desktop databases and real database engines. We need to educate people making the changeover before releasing them into the wild. (Maybe the link to download MySql could ask a few basic questions to prove you know what you are doing before being allowed to download!) :) I cut my teeth on FoxPro. The first SQL I wrote was in the FoxPro (2.5/6?) dialect. I know from whence I speak because I asked these same questions many years ago. Luckily, I found people who kindly but firmly pointed me in the right direction. (You DON'T need gapless sequences for PK's. You DON'T store images in the actual database without permission from God. Here's the FAQ we developed so you don't have to waste our time asking questions that have already been answered. Thank you, come again.) They showed me the light and occasionally I try to share what little I know with others. I guess what I'm trying to say is to those who know something (even if you are like me and are constantly amazed at what you DON'T know) share kindly and willingly. To those seeking enlightenment...RTFM you mook! Check the !*#^ archives and use Google, this issue has been beat to death! Humbly, =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 10:02 AM To: Adam Wi´ckowski; [EMAIL PROTECTED] Subject: Re: An Idea Why? - 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: An Idea
On Sun, Dec 29, 2002 at 11:43:35AM -0500, Michael She wrote: BTW, does MySQL have a RowNumber function? You can use variables: select @a := 0; select id, more, fields, @a:= @a + 1 as rownumber from whatever; But you cannot use that number in the where part. Good luck. (sql, etc) -- The Moon is Waning Crescent (21% of Full) nieuw.nl - 2dehands.nl: 58038 - 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: An Idea
Cal, Paul, dear list, thank you, Cal, for your wise words ... Here's the FAQ we developed so you don't have to waste our time asking questions that have already been answered. Go to MySQL.com and type FAQ in the search box. This will provide 71 results, some of them with valuable FAQ-like information, but no real FAQ. Instead, we have this in every list mail: Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) I would keep this shorter, saying Believe in God and do not sin ;-) But seriously: Anybody here interested in setting up a FAQ on MySQL.com / MySQL.de, - with silly common questions from this list, - and with answers in small tutorial format (something like http://www.mysql.com/articles/dotnet/index.html), - well organized (one person to collect / insert the silly questions), - easy to search (only search term + search by category), - easy to maintain (e. g. with user comments, like the English manual), - even easier to use as a referer than the MySQL manual when answering questions? Flame me if there _is_ a FAQ like this. At least I didn't find it at MySQL.com, which is most probably the first place a new MySQL user would look for it. I am the German translator of the official MySQL manual, so I could offer to translate as much as I can from the FAQ into German. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Cal Evans [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED]; Adam Wi´ckowski [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, December 29, 2002 6:00 PM Subject: RE: An Idea Because that's the way that (FoxPro, Access, Paradox, insert name of favorite desktop RDBMS here) did it and I can't make the jump to a real server based RDBMS! Why do you ask? :) Seriously, I find this type of issue (not your question Paul, the original question) one of the most troubling things about this list. We as a community of SQL developers (regardless of dialect) need to make a more concentrated effort to explain the differences between desktop databases and real database engines. We need to educate people making the changeover before releasing them into the wild. (Maybe the link to download MySql could ask a few basic questions to prove you know what you are doing before being allowed to download!) :) I cut my teeth on FoxPro. The first SQL I wrote was in the FoxPro (2.5/6?) dialect. I know from whence I speak because I asked these same questions many years ago. Luckily, I found people who kindly but firmly pointed me in the right direction. (You DON'T need gapless sequences for PK's. You DON'T store images in the actual database without permission from God. Here's the FAQ we developed so you don't have to waste our time asking questions that have already been answered. Thank you, come again.) They showed me the light and occasionally I try to share what little I know with others. I guess what I'm trying to say is to those who know something (even if you are like me and are constantly amazed at what you DON'T know) share kindly and willingly. To those seeking enlightenment...RTFM you mook! Check the !*#^ archives and use Google, this issue has been beat to death! Humbly, =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 10:02 AM To: Adam Wi´ckowski; [EMAIL PROTECTED] Subject: Re: An Idea Why? - 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 - 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: An Idea
Hi My first thought was that the docs on mysql.com should do the job, but, although they answer most technical questions, often more down to earth stuff like 'How do I store images' or 'how do I get started with SQL' isn't there, or it is difficult to find. The other problem is that the documentation is often technical to point that it is difficult to understand, even as a reasonably competent database programmer. I think newbies (and not so newbies) could feel totally overwhelmed by much of it. So (taking a deep breath !) I would be prepared to lay the foundations for a faq / knowledge base aimed specifically at this type of questions and to manage it. So, any thoughts? Where do we go from here? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 29 December 2002 22:01 To: Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED] Subject: Re: An Idea Cal, Paul, dear list, thank you, Cal, for your wise words ... Here's the FAQ we developed so you don't have to waste our time asking questions that have already been answered. Go to MySQL.com and type FAQ in the search box. This will provide 71 results, some of them with valuable FAQ-like information, but no real FAQ. Instead, we have this in every list mail: Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) I would keep this shorter, saying Believe in God and do not sin ;-) But seriously: Anybody here interested in setting up a FAQ on MySQL.com / MySQL.de, - with silly common questions from this list, - and with answers in small tutorial format (something like http://www.mysql.com/articles/dotnet/index.html), - well organized (one person to collect / insert the silly questions), - easy to search (only search term + search by category), - easy to maintain (e. g. with user comments, like the English manual), - even easier to use as a referer than the MySQL manual when answering questions? Flame me if there _is_ a FAQ like this. At least I didn't find it at MySQL.com, which is most probably the first place a new MySQL user would look for it. I am the German translator of the official MySQL manual, so I could offer to translate as much as I can from the FAQ into German. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Cal Evans [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED]; Adam Wi´ckowski [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, December 29, 2002 6:00 PM Subject: RE: An Idea Because that's the way that (FoxPro, Access, Paradox, insert name of favorite desktop RDBMS here) did it and I can't make the jump to a real server based RDBMS! Why do you ask? :) Seriously, I find this type of issue (not your question Paul, the original question) one of the most troubling things about this list. We as a community of SQL developers (regardless of dialect) need to make a more concentrated effort to explain the differences between desktop databases and real database engines. We need to educate people making the changeover before releasing them into the wild. (Maybe the link to download MySql could ask a few basic questions to prove you know what you are doing before being allowed to download!) :) I cut my teeth on FoxPro. The first SQL I wrote was in the FoxPro (2.5/6?) dialect. I know from whence I speak because I asked these same questions many years ago. Luckily, I found people who kindly but firmly pointed me in the right direction. (You DON'T need gapless sequences for PK's. You DON'T store images in the actual database without permission from God. Here's the FAQ we developed so you don't have to waste our time asking questions that have already been answered. Thank you, come again.) They showed me the light and occasionally I try to share what little I know with others. I guess what I'm trying to say is to those who know something (even if you are like me and are constantly amazed at what you DON'T know) share kindly and willingly. To those seeking enlightenment...RTFM you mook! Check the !*#^ archives and use Google, this issue has been beat to death! Humbly, =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 10:02 AM To: Adam Wi´ckowski; [EMAIL PROTECTED] Subject: Re: An Idea Why? - Before posting, please check
RE: An Idea
while Paul probably wouldnt say it, I would: his book: MySql and Perl for the Web ISBN 0-7357-1054-6 New Riders Publishing answers the questions you are getting at below, and IMHO the book is excellent as a how do i get started... and more... $44.99 SRP - a low cost compared to the 'deep breath below :-) like any book, to drive through it all the way, inch by inch, and learn, takes some time and focus. James Danforth,COO Neovi Data Corp www.qchex.com -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 4:18 PM To: Stefan Hinz, iConnect (Berlin); Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED] Subject: RE: An Idea Hi My first thought was that the docs on mysql.com should do the job, but, although they answer most technical questions, often more down to earth stuff like 'How do I store images' or 'how do I get started with SQL' isn't there, or it is difficult to find. The other problem is that the documentation is often technical to point that it is difficult to understand, even as a reasonably competent database programmer. I think newbies (and not so newbies) could feel totally overwhelmed by much of it. So (taking a deep breath !) I would be prepared to lay the foundations for a faq / knowledge base aimed specifically at this type of questions and to manage it. So, any thoughts? Where do we go from here? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 29 December 2002 22:01 To: Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED] Subject: Re: An Idea Cal, Paul, dear list, thank you, Cal, for your wise words ... Here's the FAQ we developed so you don't have to waste our time asking questions that have already been answered. Go to MySQL.com and type FAQ in the search box. This will provide 71 results, some of them with valuable FAQ-like information, but no real FAQ. Instead, we have this in every list mail: Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) I would keep this shorter, saying Believe in God and do not sin ;-) But seriously: Anybody here interested in setting up a FAQ on MySQL.com / MySQL.de, - with silly common questions from this list, - and with answers in small tutorial format (something like http://www.mysql.com/articles/dotnet/index.html), - well organized (one person to collect / insert the silly questions), - easy to search (only search term + search by category), - easy to maintain (e. g. with user comments, like the English manual), - even easier to use as a referer than the MySQL manual when answering questions? Flame me if there _is_ a FAQ like this. At least I didn't find it at MySQL.com, which is most probably the first place a new MySQL user would look for it. I am the German translator of the official MySQL manual, so I could offer to translate as much as I can from the FAQ into German. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Cal Evans [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED]; Adam Wi´ckowski [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, December 29, 2002 6:00 PM Subject: RE: An Idea Because that's the way that (FoxPro, Access, Paradox, insert name of favorite desktop RDBMS here) did it and I can't make the jump to a real server based RDBMS! Why do you ask? :) Seriously, I find this type of issue (not your question Paul, the original question) one of the most troubling things about this list. We as a community of SQL developers (regardless of dialect) need to make a more concentrated effort to explain the differences between desktop databases and real database engines. We need to educate people making the changeover before releasing them into the wild. (Maybe the link to download MySql could ask a few basic questions to prove you know what you are doing before being allowed to download!) :) I cut my teeth on FoxPro. The first SQL I wrote was in the FoxPro (2.5/6?) dialect. I know from whence I speak because I asked these same questions many years ago. Luckily, I found people who kindly but firmly pointed me in the right direction. (You DON'T need gapless sequences for PK's. You DON'T store images in the actual database without permission from God. Here's the FAQ we developed so you don't have to waste our time asking questions that have already been answered. Thank you, come again.) They showed me the light and occasionally I try to share
RE: An Idea
Hi I think the two would serve different purposes. Paul's book is a best friend but. It may take 2-3 days to get a copy (unless you live in a good technical bookshop) and often people want an answer now. Although it's good value, not everyone (casual users, students, newbies making their first steps) will be able or want to pay over $40 for a book (though I agree it is good value if you do) Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: JamesD [mailto:[EMAIL PROTECTED]] Sent: 30 December 2002 01:35 To: Peter Lovatt; [EMAIL PROTECTED] Subject: RE: An Idea while Paul probably wouldnt say it, I would: his book: MySql and Perl for the Web ISBN 0-7357-1054-6 New Riders Publishing answers the questions you are getting at below, and IMHO the book is excellent as a how do i get started... and more... $44.99 SRP - a low cost compared to the 'deep breath below :-) like any book, to drive through it all the way, inch by inch, and learn, takes some time and focus. James Danforth,COO Neovi Data Corp www.qchex.com -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 4:18 PM To: Stefan Hinz, iConnect (Berlin); Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED] Subject: RE: An Idea Hi My first thought was that the docs on mysql.com should do the job, but, although they answer most technical questions, often more down to earth stuff like 'How do I store images' or 'how do I get started with SQL' isn't there, or it is difficult to find. The other problem is that the documentation is often technical to point that it is difficult to understand, even as a reasonably competent database programmer. I think newbies (and not so newbies) could feel totally overwhelmed by much of it. So (taking a deep breath !) I would be prepared to lay the foundations for a faq / knowledge base aimed specifically at this type of questions and to manage it. So, any thoughts? Where do we go from here? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 29 December 2002 22:01 To: Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED] Subject: Re: An Idea Cal, Paul, dear list, thank you, Cal, for your wise words ... Here's the FAQ we developed so you don't have to waste our time asking questions that have already been answered. Go to MySQL.com and type FAQ in the search box. This will provide 71 results, some of them with valuable FAQ-like information, but no real FAQ. Instead, we have this in every list mail: Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) I would keep this shorter, saying Believe in God and do not sin ;-) But seriously: Anybody here interested in setting up a FAQ on MySQL.com / MySQL.de, - with silly common questions from this list, - and with answers in small tutorial format (something like http://www.mysql.com/articles/dotnet/index.html), - well organized (one person to collect / insert the silly questions), - easy to search (only search term + search by category), - easy to maintain (e. g. with user comments, like the English manual), - even easier to use as a referer than the MySQL manual when answering questions? Flame me if there _is_ a FAQ like this. At least I didn't find it at MySQL.com, which is most probably the first place a new MySQL user would look for it. I am the German translator of the official MySQL manual, so I could offer to translate as much as I can from the FAQ into German. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Cal Evans [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED]; Adam Wi´ckowski [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, December 29, 2002 6:00 PM Subject: RE: An Idea Because that's the way that (FoxPro, Access, Paradox, insert name of favorite desktop RDBMS here) did it and I can't make the jump to a real server based RDBMS! Why do you ask? :) Seriously, I find this type of issue (not your question Paul, the original question) one of the most troubling things about this list. We as a community of SQL developers (regardless of dialect) need to make a more concentrated effort to explain the differences
RE: An Idea
Paul's book is an excellent one. I also recommend (to anyone who asks): http://froogle.google.com/froogle?q=%22SQL+For+Dummies%22btnG=Froogle+Searc h and http://froogle.google.com/froogle?q=%22SQL+For+Smarties%22btnG=Froogle+Sear ch 2 more excellent resources. * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: JamesD [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 7:35 PM To: Peter Lovatt; [EMAIL PROTECTED] Subject: RE: An Idea while Paul probably wouldnt say it, I would: his book: MySql and Perl for the Web ISBN 0-7357-1054-6 New Riders Publishing answers the questions you are getting at below, and IMHO the book is excellent as a how do i get started... and more... $44.99 SRP - a low cost compared to the 'deep breath below :-) like any book, to drive through it all the way, inch by inch, and learn, takes some time and focus. James Danforth,COO Neovi Data Corp www.qchex.com -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 4:18 PM To: Stefan Hinz, iConnect (Berlin); Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED] Subject: RE: An Idea Hi My first thought was that the docs on mysql.com should do the job, but, although they answer most technical questions, often more down to earth stuff like 'How do I store images' or 'how do I get started with SQL' isn't there, or it is difficult to find. The other problem is that the documentation is often technical to point that it is difficult to understand, even as a reasonably competent database programmer. I think newbies (and not so newbies) could feel totally overwhelmed by much of it. So (taking a deep breath !) I would be prepared to lay the foundations for a faq / knowledge base aimed specifically at this type of questions and to manage it. So, any thoughts? Where do we go from here? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 29 December 2002 22:01 To: Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED] Subject: Re: An Idea Cal, Paul, dear list, thank you, Cal, for your wise words ... Here's the FAQ we developed so you don't have to waste our time asking questions that have already been answered. Go to MySQL.com and type FAQ in the search box. This will provide 71 results, some of them with valuable FAQ-like information, but no real FAQ. Instead, we have this in every list mail: Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) I would keep this shorter, saying Believe in God and do not sin ;-) But seriously: Anybody here interested in setting up a FAQ on MySQL.com / MySQL.de, - with silly common questions from this list, - and with answers in small tutorial format (something like http://www.mysql.com/articles/dotnet/index.html), - well organized (one person to collect / insert the silly questions), - easy to search (only search term + search by category), - easy to maintain (e. g. with user comments, like the English manual), - even easier to use as a referer than the MySQL manual when answering questions? Flame me if there _is_ a FAQ like this. At least I didn't find it at MySQL.com, which is most probably the first place a new MySQL user would look for it. I am the German translator of the official MySQL manual, so I could offer to translate as much as I can from the FAQ into German. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Cal Evans [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED]; Adam Wi´ckowski [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, December 29, 2002 6:00 PM Subject: RE: An Idea Because that's the way that (FoxPro, Access, Paradox, insert name of favorite desktop RDBMS here) did it and I can't make the jump to a real server based RDBMS! Why do you ask? :) Seriously, I find this type of issue (not your question Paul, the original question) one of the most troubling things about this list. We as a community of SQL developers (regardless of dialect) need to make a more concentrated effort to explain the differences between desktop databases and real database engines. We need to educate people making the changeover before releasing them into the wild. (Maybe the link to download MySql could ask a few basic questions to prove you know what you are doing before being allowed to download!) :) I cut my teeth on FoxPro. The first SQL I wrote was in the FoxPro (2.5/6
RE: An Idea (really: MySQL and Perl for the Web)
we are all in sales, 24/7. :-) Jim -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 9:24 PM To: JamesD; Peter Lovatt; [EMAIL PROTECTED] Subject: RE: An Idea (really: MySQL and Perl for the Web) At 17:35 -0800 12/29/02, JamesD wrote: while Paul probably wouldnt say it, I would: Well, I *have* been known to make shameless plugs from time to time, but of course it's better if readers make them for me. :-) So, thanks, I appreciate it. his book: MySql and Perl for the Web ISBN 0-7357-1054-6 New Riders Publishing answers the questions you are getting at below, and IMHO the book is excellent as a how do i get started... and more... $44.99 SRP - a low cost compared to the 'deep breath below :-) I of course appreciate it when people purchase a copy of the book, but for those who prefer to take a look at part of it first, I will point out that there is a sample chapter available online at: http://www.kitebird.com/mysql-perl/ It's a 78-page PDF, and it deals with a number of questions that probably would come up in a FAQ, but in more detail. For example, it answers the oft-posed questions: how do I store images in MySQL? and how do I retrieve images from MySQL for display in a Web page? The sample code that implements the answers to these questions is also available at the URL above, as are some sample applications. (One of which is an e-card thing that demonstrates image retrieval and display.) I guess that's enough shameless plugging for now. :-) like any book, to drive through it all the way, inch by inch, and learn, takes some time and focus. James Danforth,COO Neovi Data Corp www.qchex.com -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 4:18 PM To: Stefan Hinz, iConnect (Berlin); Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED] Subject: RE: An Idea Hi My first thought was that the docs on mysql.com should do the job, but, although they answer most technical questions, often more down to earth stuff like 'How do I store images' or 'how do I get started with SQL' isn't there, or it is difficult to find. The other problem is that the documentation is often technical to point that it is difficult to understand, even as a reasonably competent database programmer. I think newbies (and not so newbies) could feel totally overwhelmed by much of it. So (taking a deep breath !) I would be prepared to lay the foundations for a faq / knowledge base aimed specifically at this type of questions and to manage it. So, any thoughts? Where do we go from here? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- - 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: An Idea (really: MySQL and Perl for the Web)
At 17:35 -0800 12/29/02, JamesD wrote: while Paul probably wouldnt say it, I would: Well, I *have* been known to make shameless plugs from time to time, but of course it's better if readers make them for me. :-) So, thanks, I appreciate it. his book: MySql and Perl for the Web ISBN 0-7357-1054-6 New Riders Publishing answers the questions you are getting at below, and IMHO the book is excellent as a how do i get started... and more... $44.99 SRP - a low cost compared to the 'deep breath below :-) I of course appreciate it when people purchase a copy of the book, but for those who prefer to take a look at part of it first, I will point out that there is a sample chapter available online at: http://www.kitebird.com/mysql-perl/ It's a 78-page PDF, and it deals with a number of questions that probably would come up in a FAQ, but in more detail. For example, it answers the oft-posed questions: how do I store images in MySQL? and how do I retrieve images from MySQL for display in a Web page? The sample code that implements the answers to these questions is also available at the URL above, as are some sample applications. (One of which is an e-card thing that demonstrates image retrieval and display.) I guess that's enough shameless plugging for now. :-) like any book, to drive through it all the way, inch by inch, and learn, takes some time and focus. James Danforth,COO Neovi Data Corp www.qchex.com -Original Message- From: Peter Lovatt [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 29, 2002 4:18 PM To: Stefan Hinz, iConnect (Berlin); Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED] Subject: RE: An Idea Hi My first thought was that the docs on mysql.com should do the job, but, although they answer most technical questions, often more down to earth stuff like 'How do I store images' or 'how do I get started with SQL' isn't there, or it is difficult to find. The other problem is that the documentation is often technical to point that it is difficult to understand, even as a reasonably competent database programmer. I think newbies (and not so newbies) could feel totally overwhelmed by much of it. So (taking a deep breath !) I would be prepared to lay the foundations for a faq / knowledge base aimed specifically at this type of questions and to manage it. So, any thoughts? Where do we go from here? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- - 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: Re: Feature idea inspired by bug report
Hi! Ken == Ken Menzel [EMAIL PROTECTED] writes: Ken Hi Monty and Sasha, Ken Just a quick not to say that's such a great idea that Monty even Ken thought of it before! Monty and I discussed this last September, I Ken hope we could get something like this in 4.1 Ken Just a vote! I have added this to our worklog and this should be added to 4.1 Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - 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: Feature idea inspired by bug report
Hi Monty and Sasha, Just a quick not to say that's such a great idea that Monty even thought of it before! Monty and I discussed this last September, I hope we could get something like this in 4.1 Just a vote! Thanks Ken - Original Message - From: Sasha Pachev [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 8:42 PM Subject: Re: Feature idea inspired by bug report On Wednesday 06 March 2002 04:35 am, Michael Widenius wrote: Instead of disabling disk based temp tables, we could instead restrict the size of them which should be equally good. ?(By setting the disk size to 0 you would be able to disable them, but we should not recommend this setting). That's even better! -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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 - 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: Feature idea inspired by bug report
On Wednesday 06 March 2002 04:35 am, Michael Widenius wrote: Instead of disabling disk based temp tables, we could instead restrict the size of them which should be equally good. ?(By setting the disk size to 0 you would be able to disable them, but we should not recommend this setting). That's even better! -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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: Feature idea inspired by bug report
On Mon, Mar 04, 2002 at 07:12:32PM -0700, Sasha Pachev wrote: On Monday 04 March 2002 02:41 pm, Vladimir V. Kolpakov wrote: -- P.S. so far, it's helpful bug: I use it as catch for poor queries!:) This actually gives me an idea for a feature. --disable-disk-temp-tables - fail all queries that need a disk temp table, and --restrict-disk-temp-tables - allow creation of a temporary disk table only if the user has set SQL_BIG_RESULT. I think our users would love it, especially the ISP's with lots of users running all kinds of problem queries that they do not have much control over. That could be very useful! I like it. :-) -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 25 days, processed 863,827,926 queries (389/sec. avg) - 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