Databases & data
Create databases, write parameterized queries, and plan durable storage and recovery.
010203
Create and connect databases
Cloudgate workflows can use managed SQLite data and supported remote SQL connections. Start by choosing the database engine and the sandbox and production resources your workflows should reach.
2 min readSQL and parameters
Write SQL with fixed statement structure and pass changing values as parameters. This keeps request data separate from executable SQL and makes queries easier to test.
2 min readBack up and recover application data
Workflow versions preserve behavior; database backups preserve data. Plan both so a code rollback does not leave you without a way to recover records or schema changes.
2 min read