Pye-SQL
(
I/ID/IDOPEREL/Pye-SQL-1.000001.tar.gz, IDOPEREL, 2015;
MetaCPAN
)
h Pye into MySQL, PostgreSQL or SQLite
use warnings;
use strict;
use Carp;
use DBI;
use JSON::MaybeXS qw/JSON/;
use Role::Tiny::With;
our $VERSION = "1.000001";
$VERSION = eval $VERSION;
with 'Pye
ation.
=head2 PostgreSQL
It is recommended to use PostgreSQL version 9.3 and up, supporting JSON or JSONB
columns. When creating a table for logs, use something like this:
CREATE TABLE logs (
se
TIME ZONE NOT NULL,
text TEXT NOT NULL,
data JSON
);
CREATE INDEX ON logs (session_id);
If using v9.4 or up, C<data> might better be a C<JSONB> column. As with MySQL,
use your own judgment fo