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

Owner: Nobody in particular
Requestors: ddascalescu+perl [...]

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

Subject: [Enhancement] store as TEXT instead of BLOB in SQLite at least
Download (untitled) / with headers
text/plain 393b
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.
Download (untitled) / with headers
text/plain 116b
Unfortunately this will break if Storable is used, so as discussed on IRC we will try to find an alternate solution
Download (untitled) / with headers
text/plain 154b
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.

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to