What's Changed

With this release, the SQLite backend support is officially out of beta, on par with our PostgreSQL backend, and fully supported!

New Features 🎉

• Implement aggregate for SQLite by @chilagrow in #3256
• Implement collStats for SQLite by @chilagrow in #3295
• Implement createIndexes for SQLite by @rumyantseva in #3304
• Implement dbStats for SQLite by @chilagrow in #3270
• Implement distinct for SQLite by @chilagrow in #3265
• Implement dropIndexes for SQLite by @rumyantseva in #3329
• Implement explain command for SQLite by @noisersup in #3264
• Implement findAndModify for SQLite by @chilagrow in #3302
• Implement getLog for SQLite by @rumyantseva in #3279
• Implement listDatabases for SQLite by @rumyantseva in #3269
• Implement listIndexes for SQLite by @rumyantseva in #3301
• Implement renameCollection for SQLite by @chilagrow in #3321
• Implement serverStatus and dataSize commands for SQLite by @chilagrow in #3316
• Support _id implicit filter for ObjectID in SQLite by @chilagrow in #3330
• Support $bit bitwise update operator by @adetunjii in #3266
• Support ordered inserts for SQLite by @AlekSi in #3223

Enhancements 🛠

• Make deletes atomic for SQLite by @AlekSi in #3291
• Make updates atomic for SQLite by @AlekSi in #3296
• Do not change search_path parameter by @AlekSi in #3299

Documentation 📄

• Cleanup $bit update operator by @chilagrow in #3315
• Document how to test for compatibility by @b1ron in #3268
• Update blog writing guide documentation by @chilagrow in #3209
• Update category links in writing guide by @Fashander in #3323
• Update deb.md - minor grammar correction by @athkishore in #3289
• Update the writing guide by @Fashander in #3311

Other Changes 🤖

• Add ability to freeze *types.Document and *types.Array by @KrishnaSindhur in #3253
• Add backend decorators and OpLog stub by @AlekSi in #3303
• Add backend interface for collStats by @chilagrow in #3294
• Add backend interface for dbStats by @chilagrow in #3267
• Add more tests by @chilagrow in #3336
• Add new PostgreSQL backend stub by @AlekSi in #3319
• Add tests for accessing aggregation variable $$ROOT field by @chilagrow in #3254
• Add tests for validation bug by @AlekSi in #3286
• Add transactions to fsql by @AlekSi in #3278
• Bump deps by @AlekSi in #3284
• Clean-up *types.Timestamp a bit by @AlekSi in #3305
• Do not ConsumeValues in the $group aggregation stage by @adetunjii in #3344
• Expand architecture docs, add comments by @AlekSi in #3288
• Fix params handling for dropIndexes implementation for SQLite by @rumyantseva in #3350
• Make registry return full collection info by @AlekSi in #3292
• Remove Database.Close by @AlekSi in #3327
• Remove duplicated $expr tests by @chilagrow in #3255
• Return correct response if unique index violation happened on SQLite backend by @rumyantseva in #3353
• Simplify and deprecate commonerrors.WriteErrors by @AlekSi in #3258
• Skip tests for enable setFreeMonitoring for MongoDB by @chilagrow in #3318
• Tweak MongoDB initialization process by @AlekSi in #3307
• Update TODO comments by @noisersup in #3262
• Use pkgsite instead of godoc by @AlekSi in #3326
• Use Go 1.21 by @AlekSi in #3324

New Contributors

• @athkishore made their first contribution in #3289

All closed issues and pull requests.
All commits.