view release on metacpan or  search on metacpan

worktrees/audit-fixes-master/lib/DBIx/QuickORM/Manual/Features.pm  view on Meta::CPAN

Compose a schema with the DSL. See L<DBIx::QuickORM::Manual::Schema> and the
DSL reference in L<DBIx::QuickORM>.

=item Automatic schema (introspection)

Populate the schema from the live database with C<autofill>; the database is
canonical. See L<DBIx::QuickORM::Manual::Schema>.

=item Automatic row classes

Generate per-table row classes with C<autorow>. See
L<DBIx::QuickORM::Manual::Schema>.

=item Tables in their own files / custom row methods

See L<DBIx::QuickORM::Manual::Schema>.

=item Variants

Define MySQL/PostgreSQL/etc. variants of the same schema or database with
C<alt>. See L<DBIx::QuickORM::Manual::Recipes>.

=item Multiple databases and servers

Compose several databases, servers, and ORMs together. See
L<DBIx::QuickORM::Manual::Schema>.

=item Plugins

Extend the builder. See L<DBIx::QuickORM/plugin> and L<DBIx::QuickORM::Plugin>.

=back

=head1 WORKING WITH ROWS

=over 4

=item Querying

Fetch, create, update, and delete rows with handles (where/order/limit/
iterators). See L<DBIx::QuickORM::Manual::Querying>.

=item Handle as a subquery source

Use a query handle as the source of another query; it is spliced in as a
derived table, aliased with C<subquery_alias>. See
L<DBIx::QuickORM::Handle/subquery_alias>.

=item Compare and set

Update a row only while a set of guard values still match, for safe concurrent
writes. See C<cas> in L<DBIx::QuickORM::Manual::Querying>.

=item Relations

Define links (foreign keys) and follow them between rows, plus joins. See
L<DBIx::QuickORM::Manual::Relations>.

=item Transactions

Transactions, nested transactions / savepoints, callbacks, and auto-retry.
See L<DBIx::QuickORM::Manual::Transactions>.

=item Async, aside, and forked queries

Run queries asynchronously, on a side connection, or in a forked child. See
L<DBIx::QuickORM::Manual::Async>.

=item Caching / row identity

One in-memory copy of each row per connection. See
L<DBIx::QuickORM::Manual::Caching>.

=back

=head1 DATA TYPES

=over 4

=item Inflate/deflate types

Built-in JSON, UUID, and DateTime types, automatic application with
C<autotype>, and writing your own. See L<DBIx::QuickORM::Manual::Types>.

=item Affinities

How column values are treated (string/numeric/binary/boolean). See
L<DBIx::QuickORM::Manual::Concepts>.

=item Literal SQL sources

Query against a raw SQL fragment. See L<DBIx::QuickORM::LiteralSource>.

=back

=head1 DATABASE SUPPORT

=over 4

=item Dialects

SQLite, PostgreSQL, DuckDB, and MySQL (including MariaDB, Percona, and
Community). See L<DBIx::QuickORM::Manual::Concepts>.

=back

=head1 SOURCE

The source code repository for DBIx-QuickORM can be found at
L<https://github.com/exodist/DBIx-QuickORM/>.

=head1 MAINTAINERS

=over 4

=item Chad Granum E<lt>exodist7@gmail.comE<gt>

=back

=head1 AUTHORS