Appwrite 1.4.0 — Release Notes & Engineering Impact

## What's Changed ### Features - **Command Center** - Smoother navigation with AI, search and keyboard shortcuts. - **Functions** - Templates, revised syntax, dedicated logging, custom domains, and Git deployment. - **Migrations** - One-click project migration from Firebase, Supabase, NHost, and Appwrite to Appwrite. - **Email Templates** - Customizable, multi-language system emails. ### Pull Requests * GraphQL Support in Appwrite by @christyjacob4 in https://github.com/appwrite/appwrite/pull/944 * Feat db pools eldad by @eldadfux in https://github.com/appwrite/appwrite/pull/4330 * Fix usage on DB Pools by @lohanidamodar in https://github.com/appwrite/appwrite/pull/4545 * Revert "Fix usage on DB Pools" by @christyjacob4 in https://github.com/appwrite/appwrite/pull/4582 * latest cli version by @lohanidamodar in https://github.com/appwrite/appwrite/pull/4597 * Sync 1.2.x by @christyjacob4 in https://github.com/appwrite/appwrite/pull/4621 * Feat fixes for pools by @eldadfux in https://github.com/appwrite/appwrite/pull/4607 * feat: mysql support by @christyjacob4 in https://github.com/appwrite/appwrite/pull/4284 * Feat: Decouple executor by @Meldiron in https://github.com/appwrite/appwrite/pull/4650 * Feat refactor tasks only using platform library by @lohanidamodar in https://github.com/appwrite/appwrite/pull/4665 * feat: move project endpoint to another service by @christyjacob4 in https://github.com/appwrite/appwrite/pull/4672 * Feat realtime dbpools by @abnegate in https://github.com/appwrite/appwrite/pull/4673 * Improve schedule accuracy + simplify by @Meldiron in https://github.com/appwrite/appwrite/pull/4668 * Simplify pool sizing by @abnegate in https://github.com/appwrite/appwrite/pull/4679 * Refactor functions worker by @shimonewman in https://github.com/appwrite/appwrite/pull/4659 * Refactor scheduler by @shimonewman in https://github.com/appwrite/appwrite/pull/4641 * Deleted functions by @shimonewman in https://github.com/appwrite/appwrite/pull/4691 * fix: return types by @christyjacob4 in https://github.com/appwrite/appwrite/pull/4695 * Add retry logic to CLI by @Meldiron in https://github.com/appwrite/appwrite/pull/4694 * feat: add support for the new DSN class by @christyjacob4 in https://github.com/appwrite/appwrite/pull/4578 * feat: disable auth on console project by @christyjacob4 in https://github.com/appwrite/appwrite/pull/4705 * Feat add console by @christyjacob4 in https://github.com/appwrite/appwrite/pull/4707 * Fix env vars by @abnegate in https://github.com/appwrite/appwrite/pull/4716 * Fix: Failing errors by @Meldiron in https://github.com/appwrite/appwrite/pull/4697 * fix: volume sync by @christyjacob4 in https://github.com/appwrite/appwrite/pull/4720 * Feat: add executor vars by @Meldiron in https://github.com/appwrite/appwrite/pull/4738 * Fix: db pool sharing by @Meldiron in https://github.com/appwrite/appwrite/pull/4748 * Fix: Db pools QA by @Meldiron in https://github.com/appwrite/appwrite/pull/4752 * Feat usage refactor for db pools by @lohanidamodar in https://github.com/appwrite/appwrite/pull/4616 * fix project Id issues by @lohanidamodar in https://github.com/appwrite/appwrite/pull/4764 * fix hourly stats by @lohanidamodar in https://github.com/appwrite/appwrite/pull/4765 * Improve: Executor error handler by @Meldiron in https://github.com/appwrite/appwrite/pull/4766 * Fix: unsaved changes in team invitation by @Meldiron in https://github.com/appwrite/appwrite/pull/4776 * Updated the error descriptions for better SEO. by @gewenyu99 in https://github.com/appwrite/appwrite/pull/4740 * Get default region param from env by @abnegate in https://github.com/appwrite/appwrite/pull/4780 * Update examples for Swift, Kotlin, Web, Android and Apple by @gewenyu99 in https://github.com/appwrite/appwrite/pull/4756 * Sync 1.2.x by @abnegate in https://github.com/appwrite/appwrite/pull/4736 * Fix event-triggered executions syntax error by @Meldiron in https://github.com/appwrite/appwrite/pull/4837 * feat (projects): auth session limit by @lohanidamodar in https://github.com/appwrite/appwrite/pull/4831 * Fix: expired session, schedule deletes by @Meldiron in https://github.com/appwrite/appwrite/pull/4860 * Fix: mimetype size by @Meldiron in https://github.com/appwrite/appwrite/pull/4814 * Fixed README documentation by @keul in https://github.com/appwrite/appwrite/pull/4537 * workflows: Update codeql-action to v3 by @sarthakroy2002 in https://github.com/appwrite/appwrite/pull/4534 * update zh-tw translation by @vrabe in https://github.com/appwrite/appwrite/pull/4285 * Remove invalid link by @kalpeshT101 in https://github.com/appwrite/appwrite/pull/4298 * Update add-translations.md by @tusharxoxoxo in https://github.com/appwrite/appwrite/pull/4317 * workflows: Update actions/checkout to v3 by @Sushrut1101 in https://github.com/appwrite/appwrite/pull/4332 * Fix User not found exception by @karniv00l in https://github.com/appwrite/appwrite/pull/4506 * fix: empty payload returned as list by @geisterfurz007 in https://github.com/appwrite/appwrite/pull/4050 * docs: update windows powershell commands by @vimode in https://github.com/appwrite/appwrite/pull/4533 * fix: correctly handle `=` in .env by @megatank58 in https://github.com/appwrite/appwrite/pull/4341 * Feat: Build output size by @Meldiron in https://github.com/appwrite/appwrite/pull/4844 * Fix : translation french "emails.recovery.body" by @pomarec in https://github.com/appwrite/appwrite/pull/4783 * Fix max session method by @abnegate in https://github.com/appwrite/appwrite/pull/4896 * Feat graphql support by @christyjacob4 in https://github.com/appwrite/appwrite/pull/974 * Feat: 1.2.x release preps by @Meldiron in https://github.com/appwrite/appwrite/pull/4909 * Feat: 1.2.x migrations by @Meldiron in https://github.com/appwrite/appwrite/pull/4911 * Fix: 1.2.x merge conflicts by @Meldiron in https://github.com/appwrite/appwrite/pull/4910 * Upgrade console by @Meldiron in https://github.com/appwrite/appwrite/pull/4913 * Feat: console upgrade 2.1.1 by @Meldiron in https://github.com/appwrite/appwrite/pull/4914 * Fix: 1.2.x migration by @Meldiron in https://github.com/appwrite/appwrite/pull/4915 * Fix: auth session limit model by @Meldiron in https://github.com/appwrite/appwrite/pull/4912 * Update descriptions for create session endpoints about session limits by @gewenyu99 in https://github.com/appwrite/appwrite/pull/4916 * Fix: 1.2.x deps version by @Meldiron in https://github.com/appwrite/appwrite/pull/4917 * 1.2.x by @abnegate in https://github.com/appwrite/appwrite/pull/4891 * Fix: nested escaping by @Meldiron in https://github.com/appwrite/appwrite/pull/4918 * Fix: SDK changelogs by @Meldiron in https://github.com/appwrite/appwrite/pull/4919 * Feat: Upgrade SDK generator by @Meldiron in https://github.com/appwrite/appwrite/pull/4920 * Fix:getting started docs by @Meldiron in https://github.com/appwrite/appwrite/pull/4922 * Fix missing env var category by @Meldiron in https://github.com/appwrite/appwrite/pull/4923 * Fix graphql examples to include _ for internal attributes by @stnguyen90 in https://github.com/appwrite/appwrite/pull/4925 * Update README.md by @eldadfux in https://github.com/appwrite/appwrite/pull/4926 * Update graphql examples to recursively show nested fields by @stnguyen90 in https://github.com/appwrite/appwrite/pull/4928 * Updates readme and contributing guide according to suggestions from editing agency by @gewenyu99 in https://github.com/appwrite/appwrite/pull/4934 * Bump utopia-php/storage by @stnguyen90 in https://github.com/appwrite/appwrite/pull/4964 * Update contributing guide to include submodule update command by @stnguyen90 in https://github.com/appwrite/appwrite/pull/4741 * feat: add code to account creation endpoint by @christyjacob4 in https://github.com/appwrite/appwrite/pull/4977 * refactor: make mails event and worker general by @lohanidamodar in https://github.com/appwrite/appwrite/pull/4859 * Function default timeout example fix by @gewenyu99 in https://github.com/appwrite/appwrite/pull/4991 * Fix null warnings by @PineappleIOnic in https://github.com/appwrite/appwrite/pull/4654 * Revert "Feat: Build output size" by @christyjacob4 in https://github.com/appwrite/appwrite/pull/4885 * feat: update account codes by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5019 * Update Dockerfile by @PineappleIOnic in https://github.com/appwrite/appwrite/pull/5020 * updated timestamp format to ISO string in realtime payload by @Akshay-Rana-Gujjar in https://github.com/appwrite/appwrite/pull/4515 * Update PR Template by @stnguyen90 in https://github.com/appwrite/appwrite/pull/4754 * Update create-team-membership.md by @gewenyu99 in https://github.com/appwrite/appwrite/pull/5014 * feat: use constants in switch case by @christyjacob4 in https://github.com/appwrite/appwrite/pull/4795 * Convert _APP_STORAGE_DEVICE env var to lowercase by @stnguyen90 in https://github.com/appwrite/appwrite/pull/4988 * Fix typo in Model/Locale.php by @eltociear in https://github.com/appwrite/appwrite/pull/4669 * Replace Appwrite Validators with backported Utopia ones by @PineappleIOnic in https://github.com/appwrite/appwrite/pull/5004 * feat: aggregate stats by @christyjacob4 in https://github.com/appwrite/appwrite/pull/4889 * feat: add hamster script by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5044 * Feat aggregate stats by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5045 * feat: add hamster script by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5047 * Update DBIP Database by @PineappleIOnic in https://github.com/appwrite/appwrite/pull/5049 * Fix deletes worker not deleting project database tables by @abnegate in https://github.com/appwrite/appwrite/pull/4984 * Fix deletes worker not deleting database collections by @abnegate in https://github.com/appwrite/appwrite/pull/4983 * add restart policy for worker-messaging container by @aayushbisen in https://github.com/appwrite/appwrite/pull/4994 * Add flutter-web as a platform type by @stnguyen90 in https://github.com/appwrite/appwrite/pull/4992 * Update add-storage-adapter.md by @tusharxoxoxo in https://github.com/appwrite/appwrite/pull/4316 * Update add-runtime.md by @tusharxoxoxo in https://github.com/appwrite/appwrite/pull/4315 * Update add-route.md by @tusharxoxoxo in https://github.com/appwrite/appwrite/pull/4314 * docs: Removed unnecessary $ symbol and spaced correctly. by @motasimmakki in https://github.com/appwrite/appwrite/pull/4556 * Update permission and ID param descriptions for grammar and clarity. by @gewenyu99 in https://github.com/appwrite/appwrite/pull/4890 * Update CONTRIBUTING.md by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5056 * fix(readme): tests badge by @TorstenDittmann in https://github.com/appwrite/appwrite/pull/5071 * feat: automate hamster by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5084 * feat: add hamster background task by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5085 * feat: clear mail attachments by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5092 * Update messaging + SDK generator by @abnegate in https://github.com/appwrite/appwrite/pull/5091 * Sync 1.2.x by @abnegate in https://github.com/appwrite/appwrite/pull/5090 * Fix validating origin for apple platforms by @abnegate in https://github.com/appwrite/appwrite/pull/5089 * Refactor internal id collections db pools by @shimonewman in https://github.com/appwrite/appwrite/pull/4907 * Feature slow test by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5109 * Expose Growth Env Var by @PineappleIOnic in https://github.com/appwrite/appwrite/pull/5111 * Update Dockerfile by @PineappleIOnic in https://github.com/appwrite/appwrite/pull/5118 * Release 1.2.1 by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5119 * feat: bump console to 2.2.0 by @TorstenDittmann in https://github.com/appwrite/appwrite/pull/5123 * Feat technical debt 2 for database changes by @fogelito in https://github.com/appwrite/appwrite/pull/4864 * build using appwrite base docker image by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5106 * Update master with 1.2.1 by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5125 * Feat new usage stats by @eldadfux in https://github.com/appwrite/appwrite/pull/4770 * Update tests CI to cache docker layers by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5115 * Update Chinese Document by @BoynChan in https://github.com/appwrite/appwrite/pull/5107 * Oauth2 check if provider is enabled by @lohanidamodar in https://github.com/appwrite/appwrite/pull/4974 * Team Invite Improvements by @lohanidamodar in https://github.com/appwrite/appwrite/pull/4973 * Include response of 5xx status codes for function executions by @ks129 in https://github.com/appwrite/appwrite/pull/4610 * password dictionary by @lohanidamodar in https://github.com/appwrite/appwrite/pull/4906 * feat: check password history by @lohanidamodar in https://github.com/appwrite/appwrite/pull/4866 * Feat db pools master sync by @lohanidamodar in https://github.com/appwrite/appwrite/pull/4995 * Feat cache labels by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5099 * Update the github workflows to cancel if PR is modified by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5151 * Fix 4982 email session expire string formattz by @munyoudoum in https://github.com/appwrite/appwrite/pull/4985 * Adding missing audits.userId to routes by @singhbhaskar in https://github.com/appwrite/appwrite/pull/5083 * Feat 13x master sync by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5142 * feat: add console sdk by @TorstenDittmann in https://github.com/appwrite/appwrite/pull/5002 * Add offline support labels on mock endpoint for sdk generator tests by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5160 * feat: console sdk generation by @TorstenDittmann in https://github.com/appwrite/appwrite/pull/5172 * chore: 1.3.x console sdk by @TorstenDittmann in https://github.com/appwrite/appwrite/pull/5173 * Remove indexed attribute query requirement by @abnegate in https://github.com/appwrite/appwrite/pull/5145 * Feat: Appwrite Router by @Meldiron in https://github.com/appwrite/appwrite/pull/5096 * Update Update Document API to check X-Appwrite-Timestamp header by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5024 * switch SDK response model from account to user by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5126 * Feat executor v3 sync by @Meldiron in https://github.com/appwrite/appwrite/pull/5230 * feat: upgrade hamster script by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5244 * feat: use env vars for the hamster time by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5252 * feat: update hamster scrpipt by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5253 * feat: update docker image by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5254 * Fix schedules functions by @shimonewman in https://github.com/appwrite/appwrite/pull/5206 * Fix XML reading issue by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5228 * For SDK release by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5131 * Update GETTING_STARTED.md by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5235 * Update migration V18.php by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5243 * Prevent cache from being flushed on start by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5202 * Updated the error to 501 error code for custom domain when _APP_DOMAIN and _APP_DOMAIN_TARGET is setup incorrectly by @singhbhaskar in https://github.com/appwrite/appwrite/pull/5188 * Usage bug fix (usage worker) by @shimonewman in https://github.com/appwrite/appwrite/pull/5265 * feat: add new stats by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5264 * Fix: scheduler env variables by @Meldiron in https://github.com/appwrite/appwrite/pull/5247 * Feat relations updates by @abnegate in https://github.com/appwrite/appwrite/pull/5266 * feat: fix hamster script by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5267 * feat: update appwrite image by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5268 * feat: database update attribute endpoints by @TorstenDittmann in https://github.com/appwrite/appwrite/pull/5164 * Feat relations updates by @abnegate in https://github.com/appwrite/appwrite/pull/5271 * Fix scheduler bugs by @Meldiron in https://github.com/appwrite/appwrite/pull/5224 * Remove count, limit and offset limitations for queries by @abnegate in https://github.com/appwrite/appwrite/pull/5143 * feat: team preferences by @TorstenDittmann in https://github.com/appwrite/appwrite/pull/5196 * Feat db pools sync by @Meldiron in https://github.com/appwrite/appwrite/pull/5223 * Bump base docker image to fix missing rsync by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5270 * feat: update readme by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5274 * Fix yasd so that the debugger works by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5210 * Update abuse by @abnegate in https://github.com/appwrite/appwrite/pull/5311 * tests: add tests for cache on updating attributes by @TorstenDittmann in https://github.com/appwrite/appwrite/pull/5312 * Feat db pools master sync by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5304 * Prevent cache from being flushed on start by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5203 * feat: console service by @TorstenDittmann in https://github.com/appwrite/appwrite/pull/5313 * Fix email-base.tpl path in certificates worker by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5325 * Updates links for query page by @gewenyu99 in https://github.com/appwrite/appwrite/pull/5301 * Feat relations 2 by @fogelito in https://github.com/appwrite/appwrite/pull/5238 * Link to InputFile Docs by @gewenyu99 in https://github.com/appwrite/appwrite/pull/5330 * feat: upgrade CLI to 1.2.1 by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5154 * Fix user model response for SDKs by @abnegate in https://github.com/appwrite/appwrite/pull/5333 * Update auth doc links for 1.3 by @gewenyu99 in https://github.com/appwrite/appwrite/pull/5300 * fix: deletes worker deleting projects with console team by @TorstenDittmann in https://github.com/appwrite/appwrite/pull/5335 * Sync master by @abnegate in https://github.com/appwrite/appwrite/pull/5337 * Update SDK generator for 1.3.x support by @abnegate in https://github.com/appwrite/appwrite/pull/5338 * Feat db update migrations by @abnegate in https://github.com/appwrite/appwrite/pull/5334 * Add versioned specs and examples by @abnegate in https://github.com/appwrite/appwrite/pull/5339 * Add options key to attributes by @abnegate in https://github.com/appwrite/appwrite/pull/5341 * Feat review fixes by @abnegate in https://github.com/appwrite/appwrite/pull/5342 * feat: update readme by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5344 * feat: update console version by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5345 * fix: console server duplicate key by @TorstenDittmann in https://github.com/appwrite/appwrite/pull/5346 * 1.3.x by @abnegate in https://github.com/appwrite/appwrite/pull/5336 * Bring 1.2.x to master by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5259 * Skip validation for mock file upload by @abnegate in https://github.com/appwrite/appwrite/pull/5347 * Update versions by @abnegate in https://github.com/appwrite/appwrite/pull/5351 * Feat review fixes by @abnegate in https://github.com/appwrite/appwrite/pull/5352 * 1.3.x by @abnegate in https://github.com/appwrite/appwrite/pull/5350 * Fix: Update Appwrite 1.3 blog link in Readme by @adityaoberai in https://github.com/appwrite/appwrite/pull/5353 * fix: migration for 1.3.x by @TorstenDittmann in https://github.com/appwrite/appwrite/pull/5356 * chore: prepare 1.3.1 release by @TorstenDittmann in https://github.com/appwrite/appwrite/pull/5357 * Fix link in Learn more about relationship attributes by @gewenyu99 in https://github.com/appwrite/appwrite/pull/5355 * 1.3.x sync by @TorstenDittmann in https://github.com/appwrite/appwrite/pull/5358 * Ensure empty team prefs returns as JSON object rather array by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5361 * Fix auto-setting custom ID on nested documents by @abnegate in https://github.com/appwrite/appwrite/pull/5363 * Update description for _APP_FUNCTIONS_INACTIVE_THRESHOLD by @gewenyu99 in https://github.com/appwrite/appwrite/pull/5377 * ci: release action by @TorstenDittmann in https://github.com/appwrite/appwrite/pull/5405 * feat: upgrade hamster script by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5414 * Fix: event multi-execution by @Meldiron in https://github.com/appwrite/appwrite/pull/3696 * Fix missing var after upgrade by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5382 * fix-models-attributeDatetime-object-example by @rinkuhasija in https://github.com/appwrite/appwrite/pull/5285 * fix error description for duplicate user by @yatharth1706 in https://github.com/appwrite/appwrite/pull/5163 * feat: update cli version by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5362 * Fix typo in Apple Getting Started by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5426 * chore: sync 1.3.x with master by @TorstenDittmann in https://github.com/appwrite/appwrite/pull/5432 * Fix relationship filtering by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5395 * Update CONTRIBUTING.md to fix specs command by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5314 * Feat bump abuse audit database by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5444 * fix: project deletion leftovers by @TorstenDittmann in https://github.com/appwrite/appwrite/pull/5442 * Merge 1.3.x to Master by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5443 * Bump sdk-generator and specs by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5448 * Update docs for beta by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5453 * Prevent migration from overriding existing data by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5455 * Sync master with 1.3.x by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5456 * Feat: Console OAuth & Cards by @Meldiron in https://github.com/appwrite/appwrite/pull/5436 * Move reference to env-var to self-hosted docs. by @gewenyu99 in https://github.com/appwrite/appwrite/pull/5394 * feat: update paths by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5461 * feat: update dockerfile to include public directory by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5464 * Update README.md by @eldadfux in https://github.com/appwrite/appwrite/pull/5473 * Fix: Card 2 by @TGlide in https://github.com/appwrite/appwrite/pull/5474 * Fix OG cards by @Meldiron in https://github.com/appwrite/appwrite/pull/5475 * Fix double slashes by @Meldiron in https://github.com/appwrite/appwrite/pull/5477 * Update cards emails by @Meldiron in https://github.com/appwrite/appwrite/pull/5479 * Fix bugs with cards by @Meldiron in https://github.com/appwrite/appwrite/pull/5487 * Feat: Card cache busting by @Meldiron in https://github.com/appwrite/appwrite/pull/5465 * Update README.md by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5484 * fix : wrong links for getting started for web by @Atsurak in https://github.com/appwrite/appwrite/pull/5360 * Fix update document merging existing data after pre-processing by @abnegate in https://github.com/appwrite/appwrite/pull/5492 * Fix: Updated error when _APP_USAGE_STATS is disabled by @singhbhaskar in https://github.com/appwrite/appwrite/pull/5246 * Fix the release github action by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5457 * Sync 1.3.x with Master by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5502 * Fix bucket permissions by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5497 * Sync master with 1.3.x by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5503 * bucketInternalId attribute to files collection by @shimonewman in https://github.com/appwrite/appwrite/pull/5515 * set correct value for logging drivers by @lucasctd in https://github.com/appwrite/appwrite/pull/5166 * Update CHANGES.md to include team prefs fix by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5446 * Update install.php to not specify docker-compose.yml file by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5469 * Fix- Original File Hash by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5513 * method to update project team by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5483 * [FEAT] Enable/Disable all services by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5257 * feat: add checks for domain by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5530 * feature to pause events by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5431 * migration bucketInternalId by @shimonewman in https://github.com/appwrite/appwrite/pull/5532 * Fix: OAuth error copy by @Meldiron in https://github.com/appwrite/appwrite/pull/5519 * fix: throw correct exception when project ID already exists by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5460 * Update the Update Account Status API to clear the cookie by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5561 * Feat dotnet sdk by @abnegate in https://github.com/appwrite/appwrite/pull/5538 * Feat calc users by @shimonewman in https://github.com/appwrite/appwrite/pull/5578 * Feat: Improve logs by @Meldiron in https://github.com/appwrite/appwrite/pull/5577 * Fix delete account by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5573 * Feat update project creation by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5572 * Feat: Add enable param in Database and Collection by @2002Bishwajeet in https://github.com/appwrite/appwrite/pull/5553 * Set min length to 0 for default value for string attributes by @abnegate in https://github.com/appwrite/appwrite/pull/5602 * Set min length to 0 for default value when creating or updating a str… by @abnegate in https://github.com/appwrite/appwrite/pull/5606 * Update framework to fix route mismatches by @abnegate in https://github.com/appwrite/appwrite/pull/5603 * Update framework to fix route mismatches by @abnegate in https://github.com/appwrite/appwrite/pull/5605 * Chore prepare release by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5610 * 1.3.x by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5611 * Feat calc tier stats by @shimonewman in https://github.com/appwrite/appwrite/pull/5608 * Feat: Improve logging by @Meldiron in https://github.com/appwrite/appwrite/pull/5590 * fix: trailing wildcards by @TorstenDittmann in https://github.com/appwrite/appwrite/pull/5633 * Fix system performance by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5620 * Update file name by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5624 * release: 1 3 6 new by @TorstenDittmann in https://github.com/appwrite/appwrite/pull/5636 * sync 1.3.x by @TorstenDittmann in https://github.com/appwrite/appwrite/pull/5637 * Allow Updating email and phone without password by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5621 * Fix the routing for the default OAuth2 pages by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5640 * Fix the routing for the default OAuth2 pages by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5643 * chore: update utopia-php/framework by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5647 * Updates for 1.3.7 by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5648 * Sync master with 1.3.x by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5649 * cache perm fix by @shimonewman in https://github.com/appwrite/appwrite/pull/5638 * Extract db from list while backing by @shimonewman in https://github.com/appwrite/appwrite/pull/5630 * ci: create CI script to build cloud images by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5666 * refactored email template by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5665 * fix: missing import by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5672 * Update 1.4.x from Master by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5683 * Update document missing params error message by @abnegate in https://github.com/appwrite/appwrite/pull/5671 * cache deletion bug fix by @shimonewman in https://github.com/appwrite/appwrite/pull/5695 * fix delete cache file to dbp-master by @shimonewman in https://github.com/appwrite/appwrite/pull/5699 * Feat: Add database to log by @Meldiron in https://github.com/appwrite/appwrite/pull/5711 * delete unnecessary project collections task by @shimonewman in https://github.com/appwrite/appwrite/pull/5705 * feat: update tests by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5712 * refactor collections config by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5709 * feat: update database config by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5708 * Fix calc tier by @shimonewman in https://github.com/appwrite/appwrite/pull/5727 * fix: missing collection error by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5728 * fixed incorrect audity activity on document create by @faisalill in https://github.com/appwrite/appwrite/pull/5718 * Calc tier addition by @shimonewman in https://github.com/appwrite/appwrite/pull/5730 * V19 migration by @fogelito in https://github.com/appwrite/appwrite/pull/5668 * Feat database upgrade by @abnegate in https://github.com/appwrite/appwrite/pull/5710 * feat : Add error attribute to Collection Indexes and Attributes by @everly-gif in https://github.com/appwrite/appwrite/pull/4575 * Queries validator transfer to Utopia by @fogelito in https://github.com/appwrite/appwrite/pull/5439 * remove password required for project deletion by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5580 * fixed relationship update bug in two way type by @fanatic75 in https://github.com/appwrite/appwrite/pull/5788 * doc: Update getting started examples for .NET SDK by @adityaoberai in https://github.com/appwrite/appwrite/pull/5785 * feat: update python version by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5795 * doc: Add .NET SDK docs examples by @adityaoberai in https://github.com/appwrite/appwrite/pull/5796 * feat: update error in Exception constructor by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5793 * fix: cloud redirect by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5798 * 1.3.x by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5797 * fix: add headers to console by @christyjacob4 in https://github.com/appwrite/appwrite/pull/4758 * usage collections fix by @shimonewman in https://github.com/appwrite/appwrite/pull/5807 * Feat db pools db pools master sync by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5792 * Fix default project by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5639 * Update Flutter GETTING_STARTED.md by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5565 * content-range end should be 1 less than file size by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5402 * fix: delete schedule document if project is deleted as well by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5839 * Add a new labels attribute to the Users collection by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5587 * Restrict characters for project ID by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5743 * fix: expire format in magic url sessions by @fanatic75 in https://github.com/appwrite/appwrite/pull/5566 * fix: expire format for get session api by @fanatic75 in https://github.com/appwrite/appwrite/pull/5568 * fixed expire format for phone session, anonymous session, oauth session by @fanatic75 in https://github.com/appwrite/appwrite/pull/5567 * fixed team creation response if teamId already exists by @jaivix in https://github.com/appwrite/appwrite/pull/5808 * Fix anonymous user by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5739 * Fix phone verification secret in events & payload by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5740 * fix expire field in list account sessions api by @fanatic75 in https://github.com/appwrite/appwrite/pull/5562 * fixed null $name error for anonymous user by @vaibhavagarwal220 in https://github.com/appwrite/appwrite/pull/5745 * fix: trigger account subscription event on email verification by @Pranav2612000 in https://github.com/appwrite/appwrite/pull/5211 * Sync with Master and 1.3.x by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5845 * [FEAT] Custom SMTP and Template support by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5199 * Fix np TLD validation by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5847 * Akamai setup in readme by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5854 * Ensure deletes worker deletes resources using internal id by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5833 * Track a user's last activity by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5781 * Ensure deletes worker iterates over all schedules by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5842 * Fix audit user internal by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5853 * Add a generic OIDC OAuth2 provider by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5449 * Update Project providers to also include the provider key by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5857 * Update description for User and Key accesedAt by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5855 * feat: X domain console cookie by @loks0n in https://github.com/appwrite/appwrite/pull/5859 * upgrade dependencies by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5866 * fix: X domain console cookie ENV var by @loks0n in https://github.com/appwrite/appwrite/pull/5873 * change to use find instead of iterating index array in Get Index route by @fanatic75 in https://github.com/appwrite/appwrite/pull/5846 * Fix small typo in docs by @mendelgordon in https://github.com/appwrite/appwrite/pull/5755 * Update delete session description to be actually correct by @gewenyu99 in https://github.com/appwrite/appwrite/pull/5707 * Merge master into 1.4.x by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5886 * Make 1.4.x compatible with latest db release 0.39.0 by @fanatic75 in https://github.com/appwrite/appwrite/pull/5890 * Remove the OAuth2 Callback endpoints from api group by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5884 * Delete project when deleting org by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5898 * Update DSN to support special chars for user and password by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5916 * fix: error in initialising the Exception constructor in api.php by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5924 * Delete duplicate users endpoint by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5918 * Improve OAuth2 error handling by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5895 * Style Appwrite Error Page by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5922 * Update the docs for the _APP_SMS_PROVIDER env var by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5917 * test updated docker-base version by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5867 * Add VCS assets by @vermakhushboo in https://github.com/appwrite/appwrite/pull/5935 * Added missing word to portuguese email template by @Miguelii in https://github.com/appwrite/appwrite/pull/5694 * Fixed bug where memberships remained after a team is deleted by @safwanyp in https://github.com/appwrite/appwrite/pull/5928 * Validate value of x-appwrite-id header by @Suven-p in https://github.com/appwrite/appwrite/pull/5550 * fix: abuse label for creating phone session by @TorstenDittmann in https://github.com/appwrite/appwrite/pull/5715 * audio/aac mime type added by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5875 * Feat appwrite assistant by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5934 * Sync with master by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5929 * Disallow personal data by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5371 * Sync 1.4.x by @christyjacob4 in https://github.com/appwrite/appwrite/pull/5961 * Separate OAuth2 info from Sessions into Identities by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5921 * Remove VCS assets by @vermakhushboo in https://github.com/appwrite/appwrite/pull/5964 * Add a secrets attribute to the identities collection by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5966 * Separate OAuth2 info from Sessions into Identities by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5953 * Implement Migrations by @PineappleIOnic in https://github.com/appwrite/appwrite/pull/5938 * Feat: Move oauth secret to identity by @Meldiron in https://github.com/appwrite/appwrite/pull/5968 * fixes debugger usage by @fanatic75 in https://github.com/appwrite/appwrite/pull/5970 * Feat query support in list attributes & list indexes endpoint by @fanatic75 in https://github.com/appwrite/appwrite/pull/5885 * V19 migration - uid varchar by @fogelito in https://github.com/appwrite/appwrite/pull/5923 * feat: add encrypt param to string attribute by @2002Bishwajeet in https://github.com/appwrite/appwrite/pull/5604 * Feat: Whitelist enums by @2002Bishwajeet in https://github.com/appwrite/appwrite/pull/5726 * Fix cache delete bug master by @shimonewman in https://github.com/appwrite/appwrite/pull/5698 * Fix 5404 update document without relation permission by @fanatic75 in https://github.com/appwrite/appwrite/pull/5887 * Update method name for `updateMembershipRoles` by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5800 * Fix Migrations Stability by @PineappleIOnic in https://github.com/appwrite/appwrite/pull/5998 * Chore 1.4.x upgrade by @abnegate in https://github.com/appwrite/appwrite/pull/6010 * Merge 1.4.x into cl-1.4.x by @abnegate in https://github.com/appwrite/appwrite/pull/6015 * Rollback to old usage by @shimonewman in https://github.com/appwrite/appwrite/pull/6022 * Fix collection disabled mode checks by @abnegate in https://github.com/appwrite/appwrite/pull/5900 * Fix missing description for function create build endpoint by @gewenyu99 in https://github.com/appwrite/appwrite/pull/5915 * Update Akamai integration further according to their latest rebrand by @gewenyu99 in https://github.com/appwrite/appwrite/pull/5879 * Revert some migrations by @abnegate in https://github.com/appwrite/appwrite/pull/6011 * Fix colliding ID overrides by @abnegate in https://github.com/appwrite/appwrite/pull/6029 * Create 1.4 response filter by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5988 * Create 1.4 request filters by @stnguyen90 in https://github.com/appwrite/appwrite/pull/5972 * update framework by @lohanidamodar in https://github.com/appwrite/appwrite/pull/5909 * Update V19 Update Migrations for 1.4.x by @stnguyen90 in https://github.com/appwrite/appwrite/pull/6001 * Improve 1.4 copy by @gewenyu99 in https://github.com/appwrite/appwrite/pull/6024 * Added Documentation change on static files by @pranjalg13 in https://github.com/appwrite/appwrite/pull/5327 * Feat SMTP Template Simplification by @PineappleIOnic in https://github.com/appwrite/appwrite/pull/6047 * updates appwrite assistant docker image version by @fanatic75 in https://github.com/appwrite/appwrite/pull/6048 * update assistant version by @fanatic75 in https://github.com/appwrite/appwrite/pull/6050 * Fix: SMTP behaviour by @Meldiron in https://github.com/appwrite/appwrite/pull/6052 * Disable swoole curl hook by @abnegate in https://github.com/appwrite/appwrite/pull/6053 * cl-1.4.x -> 1.4.x by @abnegate in https://github.com/appwrite/appwrite/pull/6057 * Feat: Functions G4 by @Meldiron in https://github.com/appwrite/appwrite/pull/5725 * master -> 1.4.x by @abnegate in https://github.com/appwrite/appwrite/pull/6058 * Check if host is public domain before requesting by @abnegate in https://github.com/appwrite/appwrite/pull/6060 * chore: release 1.4.x by @TorstenDittmann in https://github.com/appwrite/appwrite/pull/6065 * Fix smtp by @abnegate in https://github.com/appwrite/appwrite/pull/6059 ## New Contributors * @keul made their first contribution in https://github.com/appwrite/appwrite/pull/4537 * @sarthakroy2002 made their first contribution in https://github.com/appwrite/appwrite/pull/4534 * @vrabe made their first contribution in https://github.com/appwrite/appwrite/pull/4285 * @kalpeshT101 made their first contribution in https://github.com/appwrite/appwrite/pull/4298 * @Sushrut1101 made their first contribution in https://github.com/appwrite/appwrite/pull/4332 * @karniv00l made their first contribution in https://github.com/appwrite/appwrite/pull/4506 * @vimode made their first contribution in https://github.com/appwrite/appwrite/pull/4533 * @megatank58 made their first contribution in https://github.com/appwrite/appwrite/pull/4341 * @pomarec made their first contribution in https://github.com/appwrite/appwrite/pull/4783 * @aayushbisen made their first contribution in https://github.com/appwrite/appwrite/pull/4994 * @motasimmakki made their first contribution in https://github.com/appwrite/appwrite/pull/4556 * @BoynChan made their first contribution in https://github.com/appwrite/appwrite/pull/5107 * @ks129 made their first contribution in https://github.com/appwrite/appwrite/pull/4610 * @munyoudoum made their first contribution in https://github.com/appwrite/appwrite/pull/4985 * @singhbhaskar made their first contribution in https://github.com/appwrite/appwrite/pull/5083 * @rinkuhasija made their first contribution in https://github.com/appwrite/appwrite/pull/5285 * @yatharth1706 made their first contribution in https://github.com/appwrite/appwrite/pull/5163 * @TGlide made their first contribution in https://github.com/appwrite/appwrite/pull/5474 * @Atsurak made their first contribution in https://github.com/appwrite/appwrite/pull/5360 * @lucasctd made their first contribution in https://github.com/appwrite/appwrite/pull/5166 * @faisalill made their first contribution in https://github.com/appwrite/appwrite/pull/5718 * @fanatic75 made their first contribution in https://github.com/appwrite/appwrite/pull/5788 * @jaivix made their first contribution in https://github.com/appwrite/appwrite/pull/5808 * @vaibhavagarwal220 made their first contribution in https://github.com/appwrite/appwrite/pull/5745 * @Pranav2612000 made their first contribution in https://github.com/appwrite/appwrite/pull/5211 * @loks0n made their first contribution in https://github.com/appwrite/appwrite/pull/5859 * @mendelgordon made their first contribution in https://github.com/appwrite/appwrite/pull/5755 * @Miguelii made their first contribution in https://github.com/appwrite/appwrite/pull/5694 * @safwanyp made their first contribution in https://github.com/appwrite/appwrite/pull/5928 * @Suven-p made their first contribution in https://github.com/appwrite/appwrite/pull/5550 * @pranjalg13 made their first contribution in https://github.com/appwrite/appwrite/pull/5327 **Full Changelog**: https://github.com/appwrite/appwrite/compare/1.1.2...1.4.0