Re: [Dbix-class] DBIx::Class and caching

This is how i cache resultset search results in memcache: There 2 modules in attach. 1) To use memcaching for some object you need to set ResultSetMemcached as its resultset class (or resultset which derives from it). 2) Code in ResultSource.pm must be in your base resultsource class. 3) You

Re: [Dbix-class] DBIx::Class and caching

These approach caches ready objects, not just a data from database, so it quite fast, and lets you to cache any data with object, even not from DB. ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN:

Re: [Dbix-class] Recursive update_or_create - RFC

On Mon, Jun 23, 2008 at 7:17 PM, Zbigniew Lukasiak [EMAIL PROTECTED] wrote: On Mon, Jun 23, 2008 at 7:49 PM, luke saunders [EMAIL PROTECTED] wrote: On Mon, Jun 23, 2008 at 9:57 AM, Zbigniew Lukasiak [EMAIL PROTECTED] wrote: On Mon, Jun 23, 2008 at 12:23 AM, luke saunders [EMAIL PROTECTED]

[Dbix-class] Avoid DB hit with many_to_many rel

Hi, I have a table 'categories' which has a many_to_many relationship to itself using a table 'map_categories'. I found out that prefetching the many_to_many rel does not work. So I prefetched the has_many rel to 'map_categories' (parents) and prefetch the belongs_to rel (parent) from

[Dbix-class] DBIx::Class subclass and multiple tables

This topic might have been previously covered but i don't seem to be able to find the solution, so apologies in advance if it's a repeated post. Is it possible with DBIx::Class to have a class (sub-class) which properties are associated with two or more DB tables. A generic example would be:

Re: AW: [Dbix-class] Avoid DB hit with many_to_many rel

Am 25.06.2008 um 16:23 schrieb Hartmaier Alexander: Hi! many_to_many is no relationship but a relationship helper, so it can't be prefetched. You can of course prefetch the two relationships it consists of. Hi, thanks. But I found that out already. As I wrote I already prefetch the

[Dbix-class] DBIx::Class::SingletonRows

I got permission from my boss, and DBIx::Class::SingletonRows is now wending its merry way through the PAUSE and out to CPAN mirrors. Unlike the earlier versions, this one is a proper component and is only slightly magical. -- David Cantrell | Hero of the Information Age On the bright side,

Re: [Dbix-class] DBIx::Class subclass and multiple tables

In such cases i use this tactics: 1) store all the data in single table using DBIx::Class::FrozenColumns (it allows you to store dynamic number of column in one BLOB column) and these columns will be for you just if they were normal columns (i.e. $obj-some_frozen_column,