Skip to content

Release v0.2.0

Choose a tag to compare

@Edwardvaneechoud Edwardvaneechoud released this 13 Apr 17:01
· 687 commits to main since this release

This release introduces database connectivity features, allowing you to connect to external databases for both reading and writing data directly within your workflows.

🎉 Highlights

Database Integration

  • Database Reader Node: Import data using SQL queries or table selection
  • Database Writer Node: Export processed data to database tables
  • Connection Management: Create and reuse database connections across workflows
  • PostgreSQL Support: Full integration with PostgreSQL databases
image

Secret Management

  • Secure Credential Storage: System for managing database passwords and sensitive information
  • Encrypted Storage: All credentials are securely encrypted
  • User-Scoped Secrets: Isolated secret storage for each user

UI Enhancements

Database Connection Manager: Dedicated interface for managing connections
image

Secret Manager: UI for storing and retrieving credentials
image

  • Reference Mode: Option to use stored connections or define inline connections

Technical Improvements

  • Platform-agnostic password encryption
  • SQLAlchemy integration for database connection handling
  • Networkx integration for fast reads
  • Polars integration for database read/write operations
  • Support for both inline and referenced connection modes

Coming Soon

  • Support for additional database types (MySQL, SQLite, SQL Server)
  • Instructions for usage

What's Changed

Full Changelog: v0.1.5...v0.2.0