notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photos
All times are UTC
Ukraine
The recently imposed "must be logged in" restriction is a response to increased bot traffic on the site. This affects search, commits, and vuxml pages.
Search engines are not blocked. Try using "site:www.freshports.org" and your search terms.
Port details
p5-Mojo-SQL Safely generate and compose SQL statements
0.02 databasesnew! on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout Package not present on quarterly.This port was created during this quarter. It will be in the next quarterly branch but not the current one.
Maintainer: sunpoet@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2026-05-13 20:21:04
Last Update: 2026-05-13 20:17:49
Commit Hash: 17ccc86
Also Listed In: perl5
License: MIT
WWW:
https://metacpan.org/dist/Mojo-SQL
Description:
Mojo::SQL safely generates and composes SQL statements. To prevent SQL injection attacks, every ? in the input becomes a placeholder in the generated query, with the corresponding value bound to it. Partial statements can be composed recursively to build more complex queries. Literal question marks can be escaped with ??. Make partial statements optional to dynamically generate WHERE clauses. If you need a little more control over the generated SQL query, you can also bypass safety features with "sql_unsafe". But make sure to handle unsafe values yourself with appropriate escaping functions for your database. For PostgreSQL there are "escape_literal" and "escape_identifier" functions included with this module. For databases that do not support numbered placeholders like $1 and $2, you can set a custom character with the placeholder option.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (10 items)
Collapse this list.
  1. /usr/local/share/licenses/p5-Mojo-SQL-0.02/catalog.mk
  2. /usr/local/share/licenses/p5-Mojo-SQL-0.02/LICENSE
  3. /usr/local/share/licenses/p5-Mojo-SQL-0.02/MIT
  4. lib/perl5/site_perl/Mojo/SQL.pm
  5. lib/perl5/site_perl/Mojo/SQL/Statement.pm
  6. lib/perl5/site_perl/man/man3/Mojo::SQL.3.gz
  7. lib/perl5/site_perl/man/man3/Mojo::SQL::Statement.3.gz
  8. @owner
  9. @group
  10. @mode
Collapse this list.
USE_RC_SUBR (Service Scripts)
  • no SUBR information found for this port
Dependency lines:
  • p5-Mojo-SQL>0:databases/p5-Mojo-SQL
To install the port:
cd /usr/ports/databases/p5-Mojo-SQL/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/p5-Mojo-SQL
  • pkg install p5-Mojo-SQL
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: p5-Mojo-SQL
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1778677890 SHA256 (Mojo-SQL-0.02.tar.gz) = 17a5312f0731ff8866f24415020a52e6763ebad84088ec906c0d62147ef3ae00 SIZE (Mojo-SQL-0.02.tar.gz) = 7378

No package information for this port in our database
Sometimes this happens. Not all ports have packages. This is doubly so for new ports, like this one.
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. p5-Mojolicious>=9.41 : www/p5-Mojolicious
  2. perl5>=5.42.r<5.43 : lang/perl5.42
  3. perl5>=5.42.r<5.43 : lang/perl5.42
Runtime dependencies:
  1. p5-Mojolicious>=9.41 : www/p5-Mojolicious
  2. perl5>=5.42.r<5.43 : lang/perl5.42
This port is required by:
for Build
  1. databases/p5-Mojo-Pg
for Run
  1. databases/p5-Mojo-Pg

Configuration Options:
No options to configure
Options name:
databases_p5-Mojo-SQL
USES:
perl5
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (12 items)
Collapse this list.
  1. ftp://ftp.auckland.ac.nz/pub/perl/CPAN/authors/id/S/SR/SRI/
  2. ftp://ftp.cpan.org/pub/CPAN/authors/id/S/SR/SRI/
  3. ftp://ftp.cpan.org/pub/CPAN/modules/by-module/Mojo/
  4. ftp://ftp.funet.fi/pub/languages/perl/CPAN/authors/id/S/SR/SRI/
  5. ftp://ftp.mirrorservice.org/sites/cpan.perl.org/CPAN/authors/id/S/SR/SRI/
  6. http://backpan.perl.org/authors/id/S/SR/SRI/
  7. http://ftp.jaist.ac.jp/pub/CPAN/authors/id/S/SR/SRI/
  8. http://ftp.twaren.net/Unix/Lang/CPAN/authors/id/S/SR/SRI/
  9. https://cpan.metacpan.org/authors/id/S/SR/SRI/
  10. https://cpan.metacpan.org/modules/by-module/Mojo/
  11. https://www.cpan.org/authors/id/S/SR/SRI/
Collapse this list.

Number of commits found: 1

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
0.02
13 May 2026 20:17:49
commit hash: 17ccc863e3e876a6c575bcebf7ab5437d26ee84bcommit hash: 17ccc863e3e876a6c575bcebf7ab5437d26ee84bcommit hash: 17ccc863e3e876a6c575bcebf7ab5437d26ee84bcommit hash: 17ccc863e3e876a6c575bcebf7ab5437d26ee84b files touched by this commit
Po-Chuan Hsieh (sunpoet) search for other commits by this committer
databases/p5-Mojo-SQL: Add p5-Mojo-SQL 0.02

Mojo::SQL safely generates and composes SQL statements. To prevent SQL injection
attacks, every ? in the input becomes a placeholder in the generated query, with
the corresponding value bound to it. Partial statements can be composed
recursively to build more complex queries.

Literal question marks can be escaped with ??.

Make partial statements optional to dynamically generate WHERE clauses.

If you need a little more control over the generated SQL query, you can also
bypass safety features with "sql_unsafe". But make sure to handle unsafe values
yourself with appropriate escaping functions for your database. For PostgreSQL
there are "escape_literal" and "escape_identifier" functions included with this
module.

For databases that do not support numbered placeholders like $1 and $2, you can
set a custom character with the placeholder option.

Number of commits found: 1