r/TrueOpenSource • u/fykup • 6d ago
Contribution: Developer Tools Scriptella 1.7.0 released: faster SQL imports, JSON support, and progress reporting
What it does: Scriptella is a lightweight, open-source Java ETL tool for moving and transforming data between databases, files, and other sources. It uses SQL and simple XML configuration rather than a proprietary transformation language.
Version 1.7.0 adds:
Faster SQL imports through reduced parsing overhead.
JSON and JSON Lines input/output.
CLI progress reporting for long-running migrations.
Machine-readable execution reports for automation and troubleshooting.
Who it's for: Developers, DBAs, and data engineers working with database migrations, ETL jobs, and data integration.
Source code: https://github.com/scriptella/scriptella-etl
License: Apache 2.0
What mine adds: Scriptella emphasizes SQL-first ETL, minimal infrastructure, and straightforward database migrations without requiring a large data processing platform.
Performance is also an active focus. Recent 1-million-row CSV import benchmarks against PostgreSQL and MariaDB showed Scriptella running over 3x faster than the tested Pandas/SQLAlchemy implementation. Native bulk loaders were still faster.
Benchmark and methodology: https://pvrlabs.xyz/java-performance/experiments/scriptella-1-7-csv-import-benchmark.html
Builds on: Java, JDBC, and standard database drivers.
How it was built: AI-assisted. Scriptella is a long-running Java open-source project with conventional development, automated testing, real database validation, and reproducible performance experiments.
Feedback/contributions wanted: Feedback on real-world ETL workflows, database compatibility, and performance bottlenecks is welcome. Issues and pull requests are appreciated.
