Skip to content

README.md

Latest commit

 

History

History
86 lines (50 loc) · 3.45 KB

README.md

File metadata and controls

86 lines (50 loc) · 3.45 KB

ZenDB - Your Database Companion

ZenDB Logo

ZenDB is an all-in-one database toolkit designed to simplify and enhance database management tasks. Whether you're a seasoned database administrator or a beginner, ZenDB provides a comprehensive set of tools and resources to optimize your database skills.

🌐 Live Demo

Features 🛠️

  1. Type Optimizer 🧬: Select the most efficient data types for your columns. This tool provides recommendations to optimize storage and query speed based on your dataset.

  2. Schema Visualizer 🔍: Get a comprehensive overview of your entire database schema. This tool helps you visualize the relationships between tables, fields, and keys to ensure optimal structure and design.

  3. Query Estimator ⏱️: Get an instant estimate of your query's complexity. This tool helps predict performance and suggests optimizations for faster query execution.

  4. Normalization 🧹: Simplify the process of normalizing your database. This tool assists in organizing your data into efficient structures while eliminating redundancy and ensuring consistency.

  5. Index Analyzer 📊: Evaluate and improve the performance of your database indexes. This tool helps you discover bottlenecks and suggests ways to streamline your indexing strategy.

  6. ERD Generator 🗺️: Quickly generate ER diagrams using either a Prisma schema or simple text-based schema. Visualize your database structure and relationships with ease.

  7. Character Bit Size 📏: Ensure your database fields are using optimal character lengths. This tool helps you identify and adjust field lengths to save space and improve performance.

  8. Blogs and Resources 📚: Access daily updated blogs and curated learning resources to stay on top of database trends and best practices.

  9. Community-Driven Tips 💡: Access a wealth of knowledge shared by our vibrant community of database professionals.

  10. Daily Updated Blogs 📝: Stay informed with our regularly updated blog posts on database trends and best practices.

  11. Learning Resources 🎓: Enhance your skills with our curated collection of educational materials.

Installation 💻

To get started with ZenDB, follow these steps:

  1. Clone the repository:

    git clone https://github.com/devrabbani/zendb.git

  2. Navigate to the project directory:

    cd zendb

  3. Install dependencies (pnpm):

    pnpm install

  4. Set up environment variables: Create a .env.local file in the root directory and add necessary environment variables.

  5. Run the development server:

    pnpm dev

  6. Open http://localhost:3000 in your browser to see the application.

Contributing 🤝

We welcome contributions from the community! If you'd like to contribute to ZenDB, please follow these steps:

  1. Fork the repository.
  2. Create a new branch for your feature or bug fix.
  3. Make your changes and commit them with descriptive commit messages.
  4. Push your changes to your fork.
  5. Submit a pull request to the main repository.

License 📄

ZenDB is released under the MIT License.

Support 🆘

If you encounter any issues or have questions, please file an issue on our GitHub issue tracker.

ZenDB - Empowering database professionals and enthusiasts to achieve database zen. 🧘‍♂️💻