DBIx-ThinSQL
view release on metacpan or search on metacpan
DBIx::ThinSQL gives you unfettered access to the power and
flexibility of your underlying database. It aims to be a tool for
programmers who want their databases to work just as hard as their
Perl scripts.
DBIx::ThinSQL gives you access to aggregate expressions, joins,
nested selects, unions and database-side operator invocations.
Transactional support is provided via DBIx::Connector. Security
conscious coders will be pleased to know that all user-supplied
values are bound properly using DBI "bind_param()". Binding binary
data is handled transparently across different database types.
DBIx::ThinSQL offers a couple of very simple Create, Retrieve,
Update and Delete (CRUD) action methods. These are designed to get
you up and running quickly when your query data is already inside a
hashref. The methods are abstractions of the real API, but should
still read as much as possible like SQL.
Although rows can be retrieved from the database as simple objects,
DBIx::ThinSQL does not attempt to be an Object-Relational-Mapper
(ORM). There are no auto-inflating columns or automatic joins and
lib/DBIx/ThinSQL.pm view on Meta::CPAN
to results. With an API that lets you easily write almost-raw SQL,
DBIx::ThinSQL gives you unfettered access to the power and flexibility
of your underlying database. It aims to be a tool for programmers who
want their databases to work just as hard as their Perl scripts.
DBIx::ThinSQL gives you access to aggregate expressions, joins, nested
selects, unions and database-side operator invocations. Transactional
support is provided via L<DBIx::Connector>. Security conscious coders
will be pleased to know that all user-supplied values are bound
properly using L<DBI> "bind_param()". Binding binary data is handled
transparently across different database types.
DBIx::ThinSQL offers a couple of very simple Create, Retrieve, Update
and Delete (CRUD) action methods. These are designed to get you up and
running quickly when your query data is already inside a hashref. The
methods are abstractions of the real API, but should still read as much
as possible like SQL.
Although rows can be retrieved from the database as simple objects,
DBIx::ThinSQL does not attempt to be an Object-Relational-Mapper (ORM).
There are no auto-inflating columns or automatic joins and the code
( run in 0.319 second using v1.01-cache-2.11-cpan-0a6323c29d9 )