gitpan / dbix-export Goto Github PK
View Code? Open in Web Editor NEWRead-only release history for DBIx-Export
Home Page: http://metacpan.org/release/DBIx-Export
License: Other
Read-only release history for DBIx-Export
Home Page: http://metacpan.org/release/DBIx-Export
License: Other
NAME DBIx::Export - Export data from DBI as a SQLite database SYNOPSIS my $export = DBIx::Export->new( file => 'publish.sqlite', source => DBI->connect($dsn, $user, $pass), ); $export->table( 'table1', 'select * from foo where this < 10', ); $export->finish; DESCRIPTION THIS MODULE IS EXPERIMENTAL This is an experimental module that automates the exporting of data from arbitrary DBI handles to a SQLite file suitable for publishing online for others to download. It takes a set of queries, analyses the data returned by the query, then creates a table in the output SQLite database. In the process, it also ensures all the optimal pragmas are set, an index is places on every column in every table, and the database is fully vacuumed. As a result, you should be able to connect to any arbitrary datasource using any arbitrary DBI driver and then map an arbitrary series of SQL queries like views into the published SQLite database. SUPPORT Bugs should be reported via the CPAN bug tracker at <http://rt.cpan.org/NoAuth/ReportBug.html?Queue=DBIx-Export> For other issues, contact the author. AUTHOR Adam Kennedy <[email protected]> SEE ALSO DBI COPYRIGHT Copyright 2009 Adam Kennedy. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The full text of the license can be found in the LICENSE file included with this module.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.