- Development - lists.drupal.org

Re: InnoDB and accesslog/ watchdog
by Ken Rickard 16 Aug '06

16 Aug '06

Gerhard- >It would also be helpful if anybody could compare the use of InnoDB vs >my patch. Showing my ignorance. Is there a posted standard for Drupal performance testing? The last time I did some tests, I just used apache benchmark (copying something I had seen Killes do previously). Simpletest and the wget method (http://drupal.org/node/11521) don't seem to cover overall performance. - Ken Rickard

5 4

Facebook Login Module (checking interest)
by Corey Bordelon 15 Aug '06

15 Aug '06

I think I'm a day late, but I just noticed that Facebook<http://facebook.com/>now has an API available <http://developers.facebook.com/>. I am wondering if anyone would be interested in seeing a Drupal module using the API to (at least) allow a user to login into a site using their Facebook ID. * I'm sure other interesting things can come of it once the basics are done, but I want to start simple. So what do you think? Good Idea or just one more usless module? Any feedback is appreciated. -- Corey Bordelon * Note: even though I am proposing this, it doesn't mean that I will be able to write said module in a timely manner.

2 1

[User experience feature] Access Control enhancement - add role name to link hover text
by inactivist 15 Aug '06

15 Aug '06

Issue status update for http://drupal.org/node/78773 Post a follow up: http://drupal.org/project/comments/add/78773 Project: User experience Version: <none> Component: usability Category: feature requests Priority: normal Assigned to: Anonymous Reported by: inactivist Updated by: inactivist Status: patch (code needs review) Attachment: http://drupal.org/files/issues/drupal-access-control-with-new-hover.patch.t… (1.67 KB) One of the things that frustrates me when using drupal is the access control feature. I think the basic idea is fine; it's just that the UI for the access control panel (a grid of checkboxes) can be cumbersome to work with when you have multiple non-standard roles defined. My straightforward solution is to prepend the text *"allow [role name] to " *the tooltip text for the checkbox. For background and details, see my write-up on twogrunts.com [1]. /*Note:* this is my first attempt at submitting a patch to anything in the drupal project, core or otherwise. I'm a newbie (to drupal and PHP), so please, let me know if I'm taking the wrong approach here, or if there's an easier way to do this. In particular, I wasn't sure what project and component to assign this to./ [1] http://www.twogrunts.com/node/3 inactivist

3 5

Import / Export API ready for beta testing
by Jeremy Epstein 15 Aug '06

15 Aug '06

Hi all, My Summer of Code project, the Drupal Import / Export API, has finally reached what I would consider to be 'beta quality'. The module currently supports import and export of all entities in Drupal core (e.g. users, nodes, comments, terms/vocabs), as well as CCK nodes / fields / node types. All supported entities can be imported or exported in XML or CSV format. The Summer of Code officially finishes next Monday (21st Aug). I would appreciate it very much if anyone who has the time (and the curiosity!) could help out with testing my work. The module is compatible with Drupal 4.7 stable (although it has no 4.7 branch, only a HEAD branch), and it can be downloaded here: http://drupal.org/project/importexportapi How to install and test it: 1. Extract and copy the package into your site's '/modules' dir. 2. Enable both the 'importexportapi' and the 'importexportui' modules at 'admin/modules'. 3. Perform exports at 'admin/export'. Currently, exported data is simply outputted in a themed page. 4. Perform imports at 'admin/import'. Files for importing can be found (and played around with) in the '/testdata' dir of the package, and all valid files in this dir are listed for import in the UI. Needless to say, imports should be conducted in a test environment ONLY - there are bound to still be bugs, so don't do this on a production site. Docs, notes, etc. can be found on the wiki: http://basement.greenash.net.au/soc2006/ Discussion can be found on the group: http://groups.drupal.org/soc-import-export-api Please submit all bugs to the issue queue: http://drupal.org/node/add/project_issue/importexportapi Many thanks, Jaza.

1 0

Where to find free icons?
by Darrel 15 Aug '06

15 Aug '06

I'm working on a bunch of file specific stuff, and I've been trying to do some little things to spruce up the file forms. One thing I've done is add a filetype icon... I borrowed some from PHP File Navigator (http://pfn.sourceforge.net) I'm not sure if their licensing allows me to use them, and I want to avoid any possible license conflicts... Can anyone recommend a place to find freeware icons for filetypes... preferably as images... all I keep finding are .ico's.... .darrel.

11 17

Re: InnoDB and accesslog/ watchdog
by Ken Rickard 15 Aug '06

15 Aug '06

Dries asked: > Why those? How did you determine the set of tables? You should > focus on the tables where there is lock contention ... and where > concurrency matters. Now remember that I'm not a db guru, but we have a few on staff. One of our guys did an analysis of the query logs to see which tables got hit the most to see if he could improve db performance. According to his tests, changing these tables to InnoDB helped optimize db usage, though I don't have the numbers to back that up here. There may be other tables that would benefit (in fact, there may be others that have been converted, I just did a quick check). >On 14 Aug 2006, at 18:46, Ken Rickard wrote: >> For the record, we made the following tables InnoDB in Savannah: > >> accesslog >> cache > sessions >> watchdog

1 0

The perfect weblog system – and other ideas for a content management platform
by Konstantin Käfer 15 Aug '06

15 Aug '06

Hi, I just discovered Anne van Kesteren's post "The perfect weblog system" ( http://annevankesteren.nl/2004/08/weblog-system) in my bookmarks and thought that I could share it. I just read it again and there are lots of good ideas. Konstantin

1 0

Re: [development] Core scripts cleanup
by Adam Cooper 15 Aug '06

15 Aug '06

Gerhard wrote: >I think a cli interface is a very nifty thing to have. If we get a >graphical installer for the masses, we shouldn't forget to cater for the >advanced users, too. Hear Hear. +1 from me. Thanks Adam ----------------------------------------------------------------- This message may contain confidential or privileged information, and is intended only for the addressee or other persons entitled to access the information. If you are not the intended or authorised recipient of this message please notify the sender by return and then delete it from your mailbox. Any dissemination, distribution, copying or use of this communication without prior permission is prohibited. Internet communications are not secure and may be susceptible to data corruption, interception and unauthorised amendment for which Pall Europe Limited does not accept liability. Whilst we have taken all reasonable precautions to ensure that this e-mail and any attachments have been swept for viruses, Pall Europe Limited does not accept liability for losses sustained as a result of software viruses. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Pall Europe Limited unless otherwise specifically stated. Registered Office and Corporate Headquarters: Pall Europe Limited, Europa House, Havant Street, Portsmouth, PO1 -----------------------------------------------------------------

1 0

Wordpress post page
by Dries Buytaert 14 Aug '06

14 Aug '06

http://avalonstar.com/2006/08/09/wordpress-ywmc-the-post-screen/ There might be lots of valuable information embedded for us as well. -- Dries Buytaert :: http://www.buytaert.net/

2 1

Re: InnoDB and accesslog/ watchdog
by Ken Rickard 14 Aug '06

14 Aug '06

Gerhard, I may be a little late, but want to answer this. > Is there anybody who prefers innodb for > logging tables and would prefer to not change them to myisam? Yes. At a large-scale site, InnoDB is much preferred. Our MySQL admin is working on a patchfile for database.4.1.mysql that installs log tables as InnoDB by default for our installations. I'm not sure this alters the conversation, but wanted to go on record. - Ken Rickard agentrickard

4 3