Hey @christyjacob4 , I would like to contribute to this issue .

@AlgyJr, thanks for your interest! 🙏 Happy hacking! 🎃

Sorry @stnguyen90 , you can unssign this issue to give oportunity to others, I've already completed my hacktoberfest contributions target. I've tried to close this issue, but found it a lot things to do, and didn't have good examples related to NoSQL DB adapters. Thanks for the opportunity.

Is there any update on this issue? I really want this feature to work as soon as possible. It can solve a lot of overhead of maintaining and managing database servers!!

Thank you everyone for celebrating Hacktoberfest 22 with us! This issue will now be closed as we're getting ready to celebrate Hacktoberfest 23.

We are accepting submissions for this issue once again for Hacktoberfest 2023

Hey @christyjacob4 - would love to work on this, please assign - thanks!

Hey @christyjacob4 - would love to work on this, please assign - thanks!

Hi @ajwad-shaikh have assigned the issue to you! Thank you for showing interest in contributing to Appwrite! Happy Hacktoberfest 🎃

Notes:

1. Please update us with your progress every 3 days, so that we know that you are working on it.
2. Join us on Discord - https://appwrite.io/discord to chat about Hacktoberfest and Appwrite!

Updates on this project -

1. Added a dynamodb-local service to docker compose so that we can run the tests on DynamoDB - image is the official AWS image for dynamodb
   • Running on port 8012 arbitrary since I wanted to keep the default 8000 port available for any other use-case
2. Added the official PHP SDK for AWS as a dependency to interact with the service
3. Created the skeleton for DynamoDB adapter
4. Created the skeleton for DynamoDBTest
5. Added createCollections support following Postgres and MariaDB` adapter for now, MongoDB Adapter seemed somewhat different.
6. Working branch - https://github.com/ajwad-shaikh/utopia-php-database/tree/feat-328-dynamodb-support

Some concerns -

1. I was following the MongoDB adapter initially but I realised the collections and indexes are created different from the SQL based adapters viz. MariaDB or Postgres.

• MongoDB does not create a _perms collection separately for each collection - understandable but not intuitive.
• There are no indexes on _createdAt and _updatedAt like in SQL based adapters - may be a miss.
• If there is a guideline specification for how we are planning to integrate NoSQL based database services into the framework, it would be helpful as I might make wrong assumptions based on my understanding which might differ from specs.
• Tagging @abnegate as I see they have contributed to the MongoDB support for any context
• I will be documenting my assumptions for the DynamoDB adapter in the coming days under this thread.

Updates for Oct 8 -

1. Added a dynamodb-admin GUI interface to composer for debuggability as adminer doesn't support dynamodb-local
2. Following Mongo Adapter closely. Removed code to create a separate table for _perms
3. Added support for deleteCollection
4. Added support for deleteAttribute and renameAttribute
5. Declared no support for relationships
6. Added suport for getDocument

Tests passing: 89 / 216

Updates for Oct 9 -

1. Added support for createDocument and updateDocument
2. Fixed handling on datetime fields createdAt and updatedAt
3. Changed _id data type to string since DynamoDB has no auto-increment primary key - hence self-generating UUID
4. Added reasonable limits for index, string and integer types in dynamodb

Updates for Oct 9 -

1. Added support for createDocument and updateDocument
2. Fixed handling on datetime fields createdAt and updatedAt
3. Changed _id data type to string since DynamoDB has no auto-increment primary key - hence self-generating UUID
4. Added reasonable limits for index, string and integer types in dynamodb

Thanks for the update. Let us know when your PR is ready for review

Hi @ajwad-shaikh is there an update on your PR?

Hey @Haimantika

It's taking longer than expected, I have to implement the find method for the new adapter and it is very complex.

The whole PR might stretch beyond the scope of Hacktober but I'm positive to deliver on it.

Would appreciate some early feedback from the maintainers on my PR if possible.

Thanks!

@ajwad-shaikh Can I get an update on this if you are still working on it? If not, I need to close the issue. Let me know, since hacktoberfest is now over.

Hey @tessamero,

I could not work on this in the past week, but I am looking to complete this over the next few weeks.

Thanks, happy hacktober!

@ajwad-shaikh sounds good, ill remove the hacktoberfest tag for now