Skip Menu |

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the KiokuDB-Backend-DBI CPAN distribution.

Report information
The Basics
Id: 48230
Status: resolved
Priority: 0/
Queue: KiokuDB-Backend-DBI

People
Owner: Nobody in particular
Requestors: ddascalescu+perl [...] gmail.com
Cc:
AdminCc:

Bug Information
Severity: Wishlist
Broken in: (no value)
Fixed in: (no value)



Subject: [Enhancement] store entries.data as TEXT instead of BLOB in SQLite at least
I'm not sure if this is feasible at all, but it would help with inspecting what KiokuDB does behind the scenes if the 'data' column of the 'entries' table were of type TEXT. Right now it's a BLOB and some SQLite exploration tools won't display BLOBs in any fashion. Since the data is JSON anyway, I thought storing it as TEXT might work. If MySQL barfs, maybe this could done only for SQLite.
Unfortunately this will break if Storable is used, so as discussed on IRC we will try to find an alternate solution
This can now be done by providing your own L<DBIx::Class::Schema::KiokuDB> subclass and modifying the result sources. Not very elegant, but does the job.