‹ Reports
The Dispatch

OSS Report: drawdb-io/drawdb


Licensing Concerns Pose Potential Barrier to drawDB's Commercial Adoption

drawDB, an online database design tool, continues its active development with a focus on expanding features and improving code quality. However, recent discussions around the AGPL license (#190) highlight potential challenges for commercial adoption.

Recent Activity

Recent issues and pull requests indicate a strong emphasis on enhancing user experience and expanding functionality. Notable issues include feature requests for BaseTable tools (#217) and visual indicators for field configurations (#215), alongside critical bug reports like PostgreSQL import failures (#198). The licensing issue (#190) remains a critical concern, with ongoing discussions about its implications for commercial use.

Development Team and Recent Activity

  1. 1ilit

    • Fixed comment import issues, updated dependencies (axios, braces, vite), merged language translation PRs.
  2. Kavya Kunder (kavyakunder)

    • Resolved comment importation bug across SQL files.
  3. Dependabot[bot]

    • Automated dependency updates for axios, braces, and vite.
  4. Pankaj Kumar (Pankaj2612)

    • Added Odia locale support.
  5. Gihun Ham (progh2)

    • Contributed Korean translation files.
  6. Davide Presti (davevad93)

    • Added Italian translation files.
  7. Tasnim Tantawi (tasnim0tantawi)

    • Worked on RTL support and UI adjustments; added export mermaid feature.
  8. Herat Patel (patelherat)

    • Added Gujarati locale support.
  9. Malachi (nktfh100)

    • Fixed multi-line field comments in SQL export.
  10. AbdurRahman2004

    • Added Tamil language support.
  11. Tamás Balog (picimako)

    • Contributed Hungarian translation; fixed ESLint errors.
  12. Rakesh Kumar Singh (rakeshkumar1019)

    • Added Telugu locale support.
  13. Thxrhmn

    • Contributed Indonesian locale support.
  14. Peter Dave Hello (PeterDaveHello)

    • Added Traditional Chinese translation; fixed i18n issues.
  15. Omri Beladev (beladevo)

    • Added Hebrew localization.
  16. Cooj (nowo)

    • Fixed Simplified Chinese translation error.
  17. Kartik Buttan (kartik1112)

    • Addressed exporting size bugs; added French and Punjabi locales.
  18. Aymen Abdelouahab (AymenStudios)

    • Added Arabic translation.
  19. Volkan KOÇ (volkankoc)

    • Contributed Turkish language support.
  20. Amey Chopde (Ameychopde)

    • Added Marathi translation support.
  21. Mohit Pardeshi (TheMohit2003)

    • Updated external link handling for user routing.
  22. Ikko Eltociear Ashimine (eltociear)

    • Fixed a typo in a template file.

Of Note

Quantified Reports

Quantify Issues



Recent GitHub Issues Activity

Timespan Opened Closed Comments Labeled Milestones
7 Days 0 0 0 0 0
30 Days 24 19 59 22 1
90 Days 41 29 85 34 1
All Time 101 56 - - -

Like all software activity quantification, these numbers are imperfect but sometimes useful. Comments, Labels, and Milestones refer to those issues opened in the timespan in question.

Quantify commits



Quantified Commit Activity Over 30 Days

Developer Avatar Branches PRs Commits Files Changes
1ilit 1 0/0/0 26 39 1317
Kartik Buttan 1 2/2/0 4 4 463
dependabot[bot] 1 3/3/0 3 2 428
Tamás Balog 1 2/2/0 4 3 254
Peter Dave Hello 1 2/2/0 2 2 250
Davide Presti 1 1/1/0 1 2 249
Omri Beladev 1 1/1/0 2 2 246
Aymen Abdelouahab 1 1/1/0 2 2 244
Volkan KOÇ 1 2/1/1 2 2 239
thxrhmn 1 1/1/0 1 2 236
Gihun Ham 1 1/1/0 1 2 234
AbdurRahman2004 1 1/1/0 1 2 231
Pankaj Kumar 1 1/1/0 1 2 229
Herat Patel 1 1/1/0 1 2 223
Rakesh Kumar Singh 1 1/1/0 2 2 223
Amey 1 1/1/0 1 2 222
Tasnim Tantawi 1 3/2/1 3 9 140
Malachi 1 1/1/0 1 6 41
Kavya Kunder 1 1/1/0 1 5 10
Mohit Pardeshi 1 1/1/0 2 1 6
cooj 1 1/1/0 1 1 2
Ikko Eltociear Ashimine 1 1/1/0 1 1 2
Nicat Muzaffarli (Glockx) 0 1/0/0 0 0 0
Huy Bui (huyjs9) 0 1/0/0 0 0 0
Elvis Liao (l123wx) 0 0/0/1 0 0 0
Aditya (Kingpin98k) 0 1/0/0 0 0 0
Porom Kamal (PoromKamal) 0 1/0/1 0 0 0
Mazin Yahia (alphazee09) 0 1/0/1 0 0 0
JustACoder (TheUser5050) 0 1/0/1 0 0 0
Joao Zanutto (joao-zanutto) 0 0/1/0 0 0 0
Arpit Pathak (Thepathakarpit) 0 1/0/1 0 0 0
Tejas Benibagde (tejasbenibagde) 0 1/0/0 0 0 0

PRs: created by that dev and opened/merged/closed-unmerged during the period

Detailed Reports

Report On: Fetch issues



Recent Activity Analysis

Recent GitHub issue activity for the drawDB project shows a mix of feature requests, bug reports, and discussions around licensing and usability. The issues range from requests for new features like BaseTable tools (#217) and visual indicators for field nullability (#215), to bug reports such as PostgreSQL import failures (#198) and licensing concerns (#190). Notably, there are ongoing discussions about the implications of the AGPL license on commercial use, highlighting a potential barrier for some users.

Several issues demonstrate common themes: enhancing user experience with better visual cues and customization options, improving import/export functionalities, and addressing performance concerns with large datasets. The licensing issue (#190) is particularly significant as it could affect the project's adoption in commercial environments. Additionally, there are multiple requests for collaboration features (#183), indicating a demand for real-time teamwork capabilities.

Issue Details

  • #217: [FEATURE] add BaseTable tool for convenience

    • Priority: Medium
    • Status: Open
    • Created: 9 days ago
  • #215: [FEATURE] Explicit visual indicators for field nullability, comments, and other key configurations

    • Priority: Medium
    • Status: Open
    • Created: 12 days ago
  • #205: Lack of DDL import capability

    • Priority: High
    • Status: Open
    • Created: 21 days ago
    • Updated: 14 days ago
  • #198: PostgreSQL import failed with named column constraint

    • Priority: High
    • Status: Open
    • Created: 23 days ago
    • Updated: 3 days ago
  • #190: Licensing issue

    • Priority: Critical
    • Status: Open
    • Created: 24 days ago
    • Updated: 2 days ago
  • #188: [Feature] Resizable table

    • Priority: Medium
    • Status: Open
    • Created: 24 days ago
    • Updated: 10 days ago
  • #182: Usage as a library/in another app

    • Priority: Medium
    • Status: Open
    • Created: 25 days ago
    • Updated: 2 days ago

Report On: Fetch pull requests



Overview

The drawDB project is an actively developed online database design tool with a significant number of open pull requests (PRs) and community involvement. The PRs cover a wide range of features, bug fixes, and enhancements, reflecting the project's rapid growth and popularity.

Summary of Pull Requests

  1. #214: Refactoring for better code readability by moving the router to a separate folder.
  2. #192: Added support for exporting SQL as OracleDB SQL, with ongoing discussions about import functionality.
  3. #181: Introduced Azerbaijan language localization.
  4. #175: Enhanced relationship editing with highlighting and fixed duplicated relationships.
  5. #155: Simplified theme options by introducing a dark theme switch.
  6. #152: Added offline PWA support, building on previous efforts to enhance mobile compatibility.
  7. #124: Refactored modal component structure for better management and usability.
  8. #82: Initial effort to add PWA support, later expanded in #152.
  9. #42: Added functionality to convert JSON schema to Django models, addressing several review comments.

Analysis of Pull Requests

The drawDB project is experiencing active development with a focus on both feature expansion and codebase improvements. A recurring theme in the PRs is the enhancement of user experience through localization (#181), UI improvements (#175), and new export functionalities (#192). The addition of languages like Azerbaijani and features such as OracleDB SQL export indicate a commitment to broadening the tool's accessibility and utility.

Several PRs focus on code refactoring and structural improvements, such as #214 and #124, which aim to enhance code readability and maintainability. These efforts suggest an emphasis on long-term sustainability and ease of contribution from the community.

The introduction of offline PWA support (#152) highlights an effort to improve accessibility for mobile users, aligning with modern web application standards. This feature complements recent enhancements in mobile support, indicating a strategic direction towards making drawDB more versatile across different devices.

Notably, some PRs like #42 have been open for an extended period, indicating potential challenges in reaching consensus or resolving technical complexities. This could point to areas where additional resources or clearer guidelines might be beneficial.

Overall, the drawDB project demonstrates a healthy balance between adding new features, improving existing functionalities, and maintaining code quality. The active community engagement through PR discussions reflects a collaborative approach to development, although there may be opportunities to streamline processes for quicker resolution of older PRs.

Report On: Fetch commits



Development Team and Recent Activity

Team Members and Their Activities

  1. 1ilit

    • Engaged in various bug fixes and feature enhancements, including fixing comment import issues, zoom shortcuts, and UI updates.
    • Worked on dependency updates, such as axios, braces, and vite.
    • Collaborated with multiple contributors by merging pull requests for language translations and other features.
  2. Kavya Kunder (kavyakunder)

    • Addressed a bug related to comment importation across multiple SQL files.
  3. Dependabot[bot]

    • Automated updates for dependencies like axios, braces, and vite.
  4. Pankaj Kumar (Pankaj2612)

    • Added Odia locale support.
  5. Gihun Ham (progh2)

    • Contributed Korean translation files.
  6. Davide Presti (davevad93)

    • Added Italian translation files.
  7. Tasnim Tantawi (tasnim0tantawi)

    • Worked on RTL language support and UI adjustments.
    • Added export mermaid feature.
  8. Herat Patel (patelherat)

    • Added Gujarati locale support.
  9. Malachi (nktfh100)

    • Fixed multi-line field comments in SQL export.
  10. AbdurRahman2004

    • Added Tamil language support.
  11. Tamás Balog (picimako)

    • Contributed Hungarian translation and fixed typos in English translations.
    • Addressed ESLint errors.
  12. Rakesh Kumar Singh (rakeshkumar1019)

    • Added Telugu locale support.
  13. Thxrhmn

    • Contributed Indonesian locale support.
  14. Peter Dave Hello (PeterDaveHello)

    • Added Traditional Chinese translation.
    • Fixed i18n issues.
  15. Omri Beladev (beladevo)

    • Added Hebrew localization.
  16. Cooj (nowo)

    • Fixed a translation error in Simplified Chinese.
  17. Kartik Buttan (kartik1112)

    • Worked on exporting size bug fixes and added French and Punjabi locales.
  18. Aymen Abdelouahab (AymenStudios)

    • Added Arabic translation.
  19. Volkan KOÇ (volkankoc)

    • Contributed Turkish language support.
  20. Amey Chopde (Ameychopde)

    • Added Marathi translation support.
  21. Mohit Pardeshi (TheMohit2003)

    • Updated external link handling for user routing in the application.
  22. Ikko Eltociear Ashimine (eltociear)

    • Fixed a typo in a template file.

Patterns, Themes, and Conclusions

  • The development team is actively engaged in both feature development and bug fixing, indicating a balanced focus on enhancing functionality while maintaining stability.
  • There is significant collaboration among team members through pull requests, especially for adding new language translations, which suggests a strong emphasis on internationalization.
  • Automated tools like Dependabot are utilized for dependency management, ensuring that the project stays up-to-date with minimal manual intervention.
  • The project has a diverse group of contributors from different regions, contributing to its rapid growth and popularity.
  • The recent activities reflect an active development cycle with frequent updates and community involvement, as evidenced by numerous merged pull requests and ongoing enhancements to the tool's features and usability.