- Development - lists.drupal.org

[drupal-devel] Ahahahaha... Let's Listen To Our Users!
by Morbus Iff 18 Oct '05

18 Oct '05

http://drupal.org/node/34492 http://drupal.org/node/33948 -- Morbus Iff ( you are nothing without your robot car, NOTHING! ) Culture: http://www.disobey.com/ and http://www.gamegrene.com/ O'Reilly Author, Weblog, Cook: http://www.oreillynet.com/pub/au/779 icq: 2927491 / aim: akaMorbus / yahoo: morbus_iff / jabber.org: morbus

1 0

Re: [drupal-devel] LOCK vs. SELECT FOR UPDATE
by Khalid B 18 Oct '05

18 Oct '05

Here is a workaround that someone cooked up to get over the fact that his host does not allow for LOCK TABLE privilege. http://drupal.org/node/34455 Is this something we can go by?

2 1

RE: [drupal-devel] RFC: Forms API Reference Draft
by Apartment Lines 18 Oct '05

18 Oct '05

many of your questions are addressed in the following forms API quickstart guide: http://cvs.drupal.org/viewcvs/*checkout*/drupal/contributions/docs/developer /topics/forms_api.html?content-type=text%2Fhtml ...and we're working on full documentation right now :) chad -----Original Message----- From: Kieran Lal [mailto:kieran@civicspacelabs.org] Sent: Tuesday, October 18, 2005 02:43 To: Chad Phillips; Angie Byron Subject: Fwd: [drupal-devel] RFC: Forms API Reference Draft Please point out the other supporting documentation. Kieran Begin forwarded message: From: David Carrington <david.carrington(a)gmail.com> Date: October 18, 2005 1:27:41 AM PDT To: drupal-devel(a)drupal.org Subject: Re: [drupal-devel] RFC: Forms API Reference Draft Reply-To: drupal-devel(a)drupal.org On 18/10/05, Angie Byron <drupal-devel(a)webchick.net> wrote: If you guys could have a look and throw me your 2 cents on this document overall that would be awesome. Should the same document cover a few fundamentals first? For example, after reading it, I still have no idea how to create a simple form and do anything with it. Some example things I still don't know for certain: * Do I create the $form array myself, or is there something which initialises it for me? * How important is the array key "preview", and what does it relate to? * " $fields[$category][$field->name]" - it is not clear where this fits in with everything else (or any other nested part of a $form) * How do I put controls into a block? * Can I put controls into a table? I know I could answer all these questions myself by looking at examples, I'm just curious if they should be part of the same documentation. -- David Carrington

1 0

[drupal-devel] I do not care about PHP 5
by Karoly Negyesi 18 Oct '05

18 Oct '05

Hi! PHP 5.0.5 broke Drupal 4.6 (reference is now an error). Reading http://shiflett.org/archive/150 this, I can not care less and I am not likely to put any efforts into making Drupal PHP5 compatible. If my code is PHP5 compatible, fine, but I will not bother myself. (This does not mean slopy code, $_POST['op'] which results in notices is acceptable) I think I'll wait another year before looking again. Opinions, please. Regards NK

9 26

[drupal-devel] Re: MySQL ENUM vs. TINYINT (possible, > performance boost?)
by David Norman 17 Oct '05

17 Oct '05

I would bet enum is faster (and no I don't have proof). The analyze function in phpMyAdmin even recommends enums in places it recognizes boolean values. Just because mysql would use enum, wouldn't mean pgsql would have to use bool - it could stay as an integer. If it makes you feel better to leave tinyints alone, I read this to say tinyint should stay for boolean values: http://dev.mysql.com/doc/refman/4.1/en/other-vendor-column-types.html drupal-devel-request(a)drupal.org wrote: > Message: 3 > Date: Sun, 16 Oct 2005 12:44:35 +0200 > From: piotrwww(a)krukowiecki.net > Subject: Re: [drupal-devel] MySQL ENUM vs. TINYINT (possible > performance boost?) > To: drupal-devel(a)drupal.org > Message-ID: <20051016104435.GA31899(a)mallorn.ii.uj.edu.pl> > Content-Type: text/plain; charset=us-ascii > > On Sat, Oct 15, 2005 at 11:26:15PM +0100, Robert Douglass wrote: >> Angie Byron wrote: >>> However, we do have a lot of TINYINT fields that are only ever going to >>> store either 0 or 1, which could be changed to ENUM('0','1') NOT NULL as >>> the analyzer recommends. >>> >>> Any MySQL gurus who could shed some more light on this? Is it worth >>> doing? Would we gain any performance benefit from this or would it be >>> too negligible to notice? >> And the other, bigger, question is; where does this leave PostgreSQL >> support? > > PostgreSQL of course does not have ENUMs ;) > It does have bool data type that can accept '1' and '0' as values. > Unfortunatelly on SELECTs it returns 't' and 'f' for true and false > falues, so I don't think it can be used as a substitute for ENUM, unless > you use ENUM('t', 'f') for mysql. > There would be other differences, like mysql allowing incorrect values > etc... > > I don't believe (without any proofs) that ENUMs would provide any/significant > speed increase... > >

3 2

[drupal-devel] Multi-Configs and User Pictures?
by Morbus Iff 16 Oct '05

16 Oct '05

I'm fixing to launch a multi-config/single-codebase site (ie., multiple domains pointing to the same Drupal installation, with differing sites/ configuration pointing to different databases), and I'm a little worried about how user account pictures are going to be handled. Currently, pictures are saved as just files/pictures/4.jpg for uid 4. But, what happens when uid 4 from BOTH sites tries to upload their pictures? -- Morbus Iff ( my name is legion, for we are many... ) Technical: http://www.oreillynet.com/pub/au/779 Culture: http://www.disobey.com/ and http://www.gamegrene.com/ icq: 2927491 / aim: akaMorbus / yahoo: morbus_iff / jabber.org: morbus

3 3

[drupal-devel] Bugbite hours
by Gerhard Killesreiter 16 Oct '05

16 Oct '05

hi there! I've added a book page for the bugbite sessions. Please add your favourite bugs in comments. Please check for duplicates. I will add the bugs to the list and delete the comments. Cheers, Gerhard

2 1

[drupal-devel] MySQL ENUM vs. TINYINT (possible performance boost?)
by Angie Byron 16 Oct '05

16 Oct '05

I was dinking around in PHPMyAdmin today and noticed this thing called "Propose table structure" which runs: SELECT * FROM `tablename` PROCEDURE ANALYSE ( ) ...and attempts to discover the most optimal fieldtype for each field, based on the data it's currently storing. You'll notice there are ENUMs just about everywhere. And a lot of its output is largely irrelevant. For example, in the watchdog table it recommends as the hostname field: ENUM('127.0.0.1') NOT NULL Which obviously would not be good. :P However, we do have a lot of TINYINT fields that are only ever going to store either 0 or 1, which could be changed to ENUM('0','1') NOT NULL as the analyzer recommends. Any MySQL gurus who could shed some more light on this? Is it worth doing? Would we gain any performance benefit from this or would it be too negligible to notice?

3 2

[drupal-devel] bug in xmlrpc_value_calculate_type() for empty arrays
by Axel Kollmorgen 16 Oct '05

16 Oct '05

while trying to post to Drupal via blogapi/ecto 1.8.2, i discovered a bug in xmlrpc_value_calculate_type() that makes posting impossible. it happens here: case 'array': return range(0, count($xmlrpc_value->data) - 1) === array_keys($xmlrpc_value->data) ? 'array' : 'struct'; for empty arrays, this returns 'struct' while it should return 'array'. because: $xmlrpc_value->data: array () range(0, count($xmlrpc_value->data) - 1): array (0, -1) array_keys($xmlrpc_value->data): array () latter 2 apparently aren't identical. i'm a little uninspired at the moment, especially regarding this range() construct, and thought i post this here before i post a bug report and give it a try myself. maybe someone else (who wrote this? :)) is faster than me. a nice weekend everyone! -- ax [Maris's gardener Yoshi passed away] Dr. Niles Crane: He had a heart attack when he was out trimming Maris's elaborate hedge maze. The paramedics never had a chance.

2 3

[drupal-devel] PHP 101: isset() does not check for zero length (empty) strings
by Steve Dondley 15 Oct '05

15 Oct '05

I literally spent hours trying to track this down (running Drupal 4.6.3). Please take a moment to review my findings. I was having a problem with the bug at http://drupal.org/node/20795 (I beg to differ that it is fixed as reported, by the way) on a couple of different feeds. The problem went away when I changed the following line in node_invoke_nodeapi() from: else if (isset($result)) { to this: else if (isset($result) && $result != '') { The problem, of course, was is that isset() returns true on an empty string. This caused an undesirable result in this particular instance. I've seen this bug elsewhere in Drupal's code. Should we be going through Drupal's code and fixing this problem which is probably pretty common? -- Dondley Communications http://www.dondleycommunications.com Communicate or Die: American Labor Unions and the Internet http://www.communicateordie.com

7 13