boxlang-database-access

Write parameterized BoxLang database queries with queryExecute and bx:query.

16|78|Updated Nov 28, 2014

Search Tags:#database #transactions #datasource #jdbc #parameterized-queries #boxlang #queryexecute

Ready to run

npx skills add https://github.com/ortus-docs/coldbox-docs --skill boxlang-database-access

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: boxlang-database-access
Source: https://github.com/ortus-docs/coldbox-docs/tree/main/.agents/skills/boxlang-database-access
Command: npx skills add https://github.com/ortus-docs/coldbox-docs --skill boxlang-database-access

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

BoxLang developers need reliable, safe, and efficient access to relational databases from BoxLang code, including executing parameterized queries, managing datasources, and handling transactions.

Core Features & Use Cases

Supports queryExecute (script) and bx:query (tag) with parameterization to prevent SQL injection.
Datasource configuration in boxlang.json or Application.bx, transaction support, and stored procedures for complex data workflows.
Use Case: Build data access layers for multi-datasource applications with robust error handling and QoQ capabilities.

Quick Start

Configure your main datasource and execute a simple parameterized query to retrieve sample data.

Frequently Asked Questions about boxlang-database-access

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I prevent SQL injection in BoxLang database queries?▼

You prevent SQL injection in BoxLang by using parameterized queries with queryExecute or bx:query, ensuring user input is safely separated from SQL statements.

What's the best way to configure multiple datasources in a BoxLang application?▼

Configure multiple datasources in BoxLang by defining them within boxlang.json or Application.bx, enabling your application to connect to and manage several distinct relational databases simultaneously.

How do I handle database transactions across multiple datasources in BoxLang?▼

Handle database transactions across multiple datasources in BoxLang using its built-in transaction management features, ensuring data integrity during complex multi-database data workflows.

Does BoxLang support stored procedures and Query of Queries?▼

Yes, BoxLang supports executing stored procedures for complex data workflows and provides Query of Queries (QoQ) capabilities for filtering and querying in-memory result sets.

Can I use both script and tag syntax for BoxLang database access?▼

Yes, you can write BoxLang database access code using either the script-based queryExecute function or the bx:query tag, both supporting parameterized queries to prevent SQL injection.