Project
Swordfish Sample Apps
Realistic legacy apps built to break the way real migrations break — a fixed target to test Swordfish against, with answer keys.
- Status
- beta
Swordfish Sample Apps are realistic legacy applications, built to break in the ways real database migrations actually break — a fixed, repeatable target for evaluating Swordfish before you point it at anything you care about. Nine purpose-built apps cover five source databases (Oracle, MySQL, SQL Server, Sybase ASE, IBM DB2) alongside frozen clones of real open-source projects.
Every app compiles and runs, and every app embeds migration gotchas across ten categories — proprietary SQL, stored-procedure dialects, types with no clean PostgreSQL equivalent, locking and isolation behavior, collation and date/time quirks, the security model, driver and ORM patterns, and bulk-load operations. Every gotcha is written down in a per-app answer key, so after a scan you can grade exactly what the tool caught and what it missed.
The Swordfish per-database tutorials use these apps as their worked examples. Every piece of Goldfish content tagged project: swordfish-sample-apps shows up below.
From this project
Codes
-
mega-app — Oracle multi-language order management
A Java · Go · Python · PHP multi-language order management on Oracle, built to break the way real migrations do. A Swordfish Sample App for testing the Oracle→PostgreSQL assessment.
-
ecommerce-php — MySQL e-commerce storefront
A PHP 8 e-commerce storefront on MySQL, built to break the way real migrations do. A Swordfish Sample App for testing the MySQL→PostgreSQL assessment.
-
api-node — MySQL mobile & social REST API
A Node.js · Express mobile & social REST API on MySQL, built to break the way real migrations do. A Swordfish Sample App for testing the MySQL→PostgreSQL assessment.
-
hr-dotnet — SQL Server HR & payroll
A C# · .NET 8 HR & payroll on SQL Server, built to break the way real migrations do. A Swordfish Sample App for testing the SQL Server→PostgreSQL assessment.
-
etl-python — SQL Server data-warehouse ETL
A Python · pyodbc data-warehouse ETL on SQL Server, built to break the way real migrations do. A Swordfish Sample App for testing the SQL Server→PostgreSQL assessment.
-
claims-java — IBM DB2 insurance claims
A Java · JDBC insurance claims on IBM DB2, built to break the way real migrations do. A Swordfish Sample App for testing the IBM DB2→PostgreSQL assessment.
-
actuarial-python — IBM DB2 actuarial analytics
A Python · ibm_db actuarial analytics on IBM DB2, built to break the way real migrations do. A Swordfish Sample App for testing the IBM DB2→PostgreSQL assessment.
-
trading-java — Sybase ASE trading & settlement
A Java · JDBC trading & settlement on Sybase ASE, built to break the way real migrations do. A Swordfish Sample App for testing the Sybase ASE→PostgreSQL assessment.
-
risk-python — Sybase ASE risk reporting
A Python risk reporting on Sybase ASE, built to break the way real migrations do. A Swordfish Sample App for testing the Sybase ASE→PostgreSQL assessment.
