v0.2.3 Multi-statement Migrations 🐛

🐛 Fix

• Support for multi-statement migrations
  Fixed an issue where applying migrations with multiple SQL statements would fail. The client now splits the script and executes each statement individually, allowing complex migrations to work as expected.

📝 Docs

• Updated Docker example
  The docker-compose command in the README has been updated to use modern syntax with named volumes.

✅ Tests

• Migration test added
  Added a test to ensure that migrations containing multiple SQL statements are applied correctly.

Full Changelog: v0.2.2...v0.2.3

v0.2.2 Optional PostgreSQL Support

This update introduces the ability to optionally install SQLift with PostgreSQL support.

Key Feature

• Optional PostgreSQL Support: By default, SQLift is installed without PostgreSQL support. You can optionally install it with PostgreSQL support.

Installation

You can install SQLift using pip:

pip install SQLift

By default, SQLift uses SQLite. If you want to use PostgreSQL, you can install SQLift with PostgreSQL support using the following command:

pip install SQLift[postgres]

Feel free to use and provide feedback!

Full Changelog: v0.2.1...v0.2.2

v0.2.1 Now with Custom Migrations Folder Path

This update introduces the ability to specify a custom folder for your migrations.

Key Feature

• Custom Migrations Folder: Use the --path or -P option to specify a custom folder for your migrations.
  • sqlift up --path <migrations_folder>
  • sqlift down --path <migrations_folder>

Feel free to use and provide feedback!

Full Changelog: v0.1.3...v0.2.1

v0.1.3

The first release of SQLift - a simple CLI tool for SQL database migrations. This version introduces basic features for managing migrations for SQLite and PostgreSQL databases.

Key Features

• Installation: Install via pip install SQLift.
• Migrations: Create and manage SQL migrations using up and down commands.
  • sqlift up: Applies all pending migrations.
  • sqlift up <migration_name>: Applies migrations up to the specified version.
  • sqlift down: Reverts all migrations.
  • sqlift down <migration_name>: Reverts migrations down to the specified version.
• Configuration: Set up database connection using the DB_URL environment variable.

Feel free to use and provide feedback!