Welcome back to the September Product Update. This month, we have some serious Database upgrades with a new set of queries and features. Also, get ready for one more exciting hackathon news.
So, here’s what to expect:
- New set of queries
- Appwrite Docs MCP server
- API for Spatial columns
- Hacktoberfest Hackathon
- And more!
Let’s dive in!
Appwrite's Hacktoberfest Hackathon
It's that time of year again—Hacktoberfest has started! It's the biggest celebration of open-source technology, and we're excited to be back with yet another month-long hackathon. We invite you to join the fun and build something amazing and open-source.
New set of queries
Appwrite Databases now have smarter queries. We recently added two sets of new queries that let you handle time-based filtering and exclusions directly in your queries.
createdBefore, createdAfter, updatedBefore, updatedAfter
notSearch, notContains, notBetween, notStartsWith, notEndsWith
Together, these new queries make your code cleaner, reduce the need for workarounds, and give you more control over your data.
Appwrite Docs MCP server
We also launched a dedicated MCP server for Appwrite docs that enables AI assistants to access and search through Appwrite's documentation directly.
That means, AI assistants can now:
- Search through Appwrite documentation
- Retrieve specific guides and references
- Generate code snippets using the latest APIs
- Provide contextual help for Appwrite features
API for Spatial columns
You can now build scalable geo workflows right out of the box. With this new API, you can store points, lines, and polygons, add spatial indexes, and run geo queries all natively in Appwrite.
What’s new:
- Point column
- Line column
- Polygon column
- Spatial index
- 12 new operators
With these new capabilities, it’s simple to model and query location-based data.
Read the announcement to learn more
Turbopack support for Appwrite Sites
Appwrite Sites now supports Next.js applications built with Turbopack, with faster builds and better compatibility for your deployments.
With native support, your builds run without modification, deploy faster, and stay consistent between local and production. This update strengthens compatibility between Appwrite Sites and the modern Next.js toolchain.
Read the announcement to learn more
Performance improvements for Functions and static sites
We've shipped significant performance improvements across functions and static sites.
Function cold starts are now 58% faster in the Frankfurt (FRA) region with more consistent start times across executions.
Static sites are now served directly through our edge proxies, eliminating the need for dedicated runtimes.
This means:
- No more cold starts for static sites
- Automatic caching for all static site assets
- Over 99% of requests served locally from 120+ global PoPs
Community recognitions
We’re excited to feature MediaKit in our Monthly Community recognitions this month.
MediaKit is a privacy-first, browser-based toolkit launched with a powerful Image Compressor. Appwrite handled the entire auth flow, including sign-ups, email verification, password recovery, and secure login.
A big shout-out to Gurjeet.
If you'd like to participate in next month's Community Recognitions, join our Discord server to showcase your project.
Engineering resources
Read
- Make the best use of Appwrite’s MCP server
- Setting up “Sign in with Google” in your app
- Client vs Server Components in React
- Implementing Google OAuth with Expo Router
- Comparing the best vibe coding tools
- Build a “delivery store locator” using Spatial Columns in Appwrite Databases
- How Radar scaled media curation while saving $1M with Appwrite Cloud
Watch
- We made relationship queries flexible
- We launched an MCP server for our documentation
- Collect payments using Stripe
- Build a store locator using Spatial Columns in Appwrite Database
What’s to come
That’s a wrap. This month, we have a lot more exciting news! If you're a big fan of self-hosting, or vibe coding...well, it's going to be a great few weeks for you!
Plus, we have more database and region updates pending:
- New databases partner
- Multiple database features
- Brand new cloud region
Follow us on X and check our Changelog regularly, as we will release more information in the coming weeks.
