SQL to ActionScript Converter

About SQL to ActionScript Converter

Convert SQL database dumps (CREATE TABLE and INSERT statements) to ActionScript 3.0 code for use in Flash, Flex, and Adobe AIR applications. This tool generates properly typed ActionScript code with Arrays, Vectors, and Objects, making it easy to work with database data in your ActionScript projects.

Key Features

• Multiple Output Formats: Array of Arrays, Vector (strongly typed), or Array of Objects
• Automatic Type Detection: Detects int, Number, Boolean, and String types
• Strong Typing Support: Option to use ActionScript 3.0 strong typing
• Vector Support: Generate Vector.<*> for better performance
• Object Format: Create Array of Objects with named properties
• Smart Parsing: Extracts column names and data from SQL dumps
• Usage Examples: Includes code examples for accessing data
• File Download: Save as .as file

How to Use

1. Input SQL Data: Paste your SQL CREATE TABLE and INSERT statements or upload a .sql file
2. Choose Format: Select Array, Vector, or Object format
3. Configure Options: Enable type detection and strong typing as needed
4. Copy or Download: Use the Copy or Download button to save your ActionScript code

Output Formats

Array of Arrays:

• Simple 2D array structure
• Lightweight and fast
• Access data by index: data[row][column]
• Separate array for column names

Vector (Strongly Typed):

• ActionScript 3.0 Vector type for better performance
• Type-safe and memory efficient
• Faster than Array for large datasets
• Recommended for production applications

Array of Objects:

• Each row is an Object with named properties
• Easy to read and maintain
• Access data by property name: data[0].columnName
• Perfect for data binding and iteration

Example Conversion

SQL Input:

CREATE TABLE products (
  id INT,
  name VARCHAR(100),
  price DECIMAL(10,2),
  inStock BOOLEAN
);

INSERT INTO products VALUES (1, 'Laptop', 999.99, true);
INSERT INTO products VALUES (2, 'Mouse', 24.99, true);

ActionScript Output (Array):

// products data as Array
var productsData:Array = [
	[1, "Laptop", 999.99, true],
	[2, "Mouse", 24.99, true]
];

// Column names
var productsColumns:Array = ["id", "name", "price", "inStock"];

ActionScript Output (Object):

// products data as Array of Objects
var productsData:Array = [
	{
		id: 1,
		name: "Laptop",
		price: 999.99,
		inStock: true
	},
	{
		id: 2,
		name: "Mouse",
		price: 24.99,
		inStock: true
	}
];

Type Detection

When type detection is enabled, the converter automatically determines the appropriate ActionScript type:

• int: For integer values (whole numbers)
• Number: For decimal values (floating-point)
• Boolean: For true/false values
• String: For text values (default)
• null: For NULL or empty values

Common Use Cases

• Flash Games: Load game data from database exports
• AIR Applications: Import database data into desktop apps
• Flex Applications: Populate DataGrids and Lists
• Data Visualization: Create charts and graphs from database data
• Testing: Generate test data for ActionScript unit tests
• Migration: Convert database data to ActionScript format

ActionScript 3.0 Best Practices

• Use Vector for Performance: Vector is faster than Array for typed data
• Enable Strong Typing: Catch errors at compile time instead of runtime
• Choose Object Format for Readability: Named properties are easier to understand
• Use Array for Flexibility: When you need dynamic typing

Supported SQL Syntax

• CREATE TABLE: Extracts column names for property names
• INSERT INTO: Parses data values from INSERT statements
• Data Types: Handles all SQL data types (VARCHAR, INT, DECIMAL, BOOLEAN, etc.)
• Quoted Strings: Handles single and double quotes with proper escaping
• NULL Values: Converts to ActionScript null

Privacy & Security

All conversions happen locally in your browser. Your SQL data is never uploaded to any server, ensuring complete privacy and security.

FAQ

• Which ActionScript version is targeted? The generated code is designed for ActionScript 3.0 and works in Flash, Flex, and AIR environments that support AS3.
• When should I use Arrays vs Vectors vs Objects? Arrays are flexible and simple, Vectors offer better performance and type safety, and Arrays of Objects are easiest to read and bind in UI components.
• How are SQL NULL values handled? NULL or empty values are converted to ActionScript null, so you can check for missing data using standard AS3 null checks.
• Does the converter preserve numeric and boolean types? Yes. It attempts to map integers, decimals, and booleans to appropriate AS3 types (int, Number, Boolean) instead of plain strings whenever possible.
• Can I modify the generated variable names? Absolutely. The variable and property names are just suggestions; you can rename them in your codebase as long as you keep the data structure consistent.