dartapi_db 0.0.2

A light weight Database helper wrapper for dartapi.

DartAPI DB

DartAPI DB is a lightweight and flexible database abstraction package for Dart that provides structured SQL database support using a unified API interface. It is designed to support multiple database drivers (currently PostgreSQL and MySQL) while maintaining clean architecture and SOLID principles.

✨ Features

• ✅ Common interface for all SQL databases
• ✅ Easily extendable to support more databases
• ✅ Clean structure following SOLID principles
• ✅ Lightweight and fast
• ✅ No ORM overhead

📦 Installation

Add the following to your pubspec.yaml:

dependencies:
  dartapi_db: ^0.0.1

🔧 Supported Drivers

• PostgreSQL (postgres)
• MySQL (mysql_client_plus)

🚀 Getting Started

Example usage:

import 'package:dartapi_db/dartapi_db.dart';

void main() async {
  final db = await DatabaseFactory.create(
    DbConfig(
      type: DbType.postgres,
      host: 'localhost',
      port: 5432,
      database: 'mydb',
      username: 'postgres',
      password: 'password',
    ),
  );

  final result = await db.select('users', where: {'id': 1});
  print(result.first);
}

🧪 Testing

To run the tests:

dart test

📁 Structure

• core/: Base interface and result classes
• drivers/: Implementations for PostgreSQL and MySQL
• types/: Configuration and enums
• factory/: Driver resolver

📄 License

This package is open-source and licensed under the BSD-3-Clause License.