| Port details |
- p5-Mojo-SQL Safely generate and compose SQL statements
- 0.02 databases
=0 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
 - 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.
¦ ¦ ¦ ¦ 
- Manual pages:
- FreshPorts has no man page information for this port.
- pkg-plist: as obtained via:
make generate-plist - 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:
-
- p5-Mojolicious>=9.41 : www/p5-Mojolicious
- perl5>=5.42.r<5.43 : lang/perl5.42
- perl5>=5.42.r<5.43 : lang/perl5.42
- Runtime dependencies:
-
- p5-Mojolicious>=9.41 : www/p5-Mojolicious
- perl5>=5.42.r<5.43 : lang/perl5.42
- This port is required by:
- for Build
-
- databases/p5-Mojo-Pg
- for Run
-
- 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:
|
Number of commits found: 1
| Commit History - (may be incomplete: for full details, see links to repositories near top of page) |
| Commit | Credits | Log message |
0.02 13 May 2026 20:17:49
    |
Po-Chuan Hsieh (sunpoet)  |
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
|