database

database copied to clipboard

WIP POC for better perf with encode/decode/castings

1

Add single-pass document processor for faster reads by combining decode and casting into one pass instead of two, reducing overhead when reading documents. Enabled via DB_SINGLE_PASS_PROCESSOR env var with fallbacks...

ItzNotABug

WIP POC for better perf.

1

Optimize relationship writes with bulk operations. Adds bulk insert/update methods to avoid N+1 queries when creating relationships. Junction table links now use batch inserts, and one-to-many/many-to-one relationships use `SQL UPDATE`...

ItzNotABug

Added new internal attributes $createdBy and$ updatedBy

1

Added new internal attributes $createdBy and$ updatedBy ## Summary by CodeRabbit * **New Features** * Track and expose creator/updater metadata (createdBy, updatedBy) across create/read/update/upsert/bulk and increment operations; new getters return...

ArnabChatterjee20k

Upsert primary key

1

## Summary by CodeRabbit - Bug Fixes - Corrects record ID handling during updates to preserve existing histories and references. - Ensures tenant association is reliably retained during upserts in...

fogelito

Internal attributes defaults

1

## Summary by CodeRabbit - **Bug Fixes** - Internal metadata fields are now consistently included in query results with a new prefixed naming convention. - Permission checks and timestamp formatting...

fogelito

This PR will be a breaking change for Appwrite.

fogelito

Primary attribute integer representation

1

## Summary by CodeRabbit * **New Features** * Added support for a new ID attribute type accommodating both integer and string formats. * Enhanced validation for ID and sequence attributes...

fogelito

Default boolean

1

Test the boolean default value. ## Summary by CodeRabbit * **Tests** * Enhanced document update tests to include a boolean attribute, ensuring its correct handling during batch updates.

fogelito

cursor before logic

1

## Summary by CodeRabbit * **Refactor** * Simplified pagination and ordering logic for database queries by removing cursor direction handling. * Improved consistency in how order types are set and...

fogelito

Pin connections during transactions

1

## Summary by CodeRabbit - **New Features** - Improved transaction handling to ensure all operations within a transaction use the same database connection. - **Refactor** - Enhanced internal logic for...

abnegate