NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
Go modules, #19 by repository stars
Latest stable
v0.40.6
Last release 27 days ago
26 Oct 2026
Ships on a steady schedule
a new release about every 2 weeks
Nearly every release is documented
notes for 60 of the last 60 stable releases
Nothing withdrawn
no release was ever pulled
4 years old
568 releases · first in 2022
Drag across the ruler to compare, or tap a release to open it.
Nothing published for this version
Bumped the min Go GitHub action version to 1.27.3 as it includes a security fix related to the recent eMudhra CA compromise. _I didn't rush a fix 2 da…
To update the prebuilt executable you can run
./pocketbase update.
Replaced the GitHub update command with update from the new host in relation to #7841.
⚠️ Note that this will be most likely the last release here on GitHub. The next time when you run update, new releases will be fetched from https://ganigeorgiev.com (there is nothing there yet).
Additional fileblob bucket escape checks for just in case if the filesystem abstraction is used as standalone without the PocketBase validations.
Added a global restriction for the max WxH pixels size when generating a thumb to reduce the risk of excessive memory usage.
The issue was initially privately reported by @reload3d but it is treated as regular public issue since it is a known Go caveat.
The default limit is pretty generous and currently set to max 250<<20 (262144000) pixels and can be changed with the env PB_THUMBS_MAX_SOURCE_PIXELS.
The workaround is not bulletproof and thumbs generation remains one of the main culprit for potential OOMs in PocketBase, so better solutions will have to be investigated in the future, including eventually switching to libvips or other similar library once there is better CGO portability (if you have better suggestions, please open a discussion).
Bumped the min Go GitHub action version to 1.27.3 as it includes a security fix related to the recent eMudhra CA compromise.
I didn't rush a fix 2 days ago as the impact for most PocketBase servers is not that serious and requires to already have a MiTM, but nonetheless it is recommended to update. Please make sure to also check for OS/Docker image updates to ensure that you have the latest ca-certificates bundle.
Bumped golang.org/x/ dependencies (#7865).
Bumped goja and its related dependencies (string allocations optimization, Date.getYear/setYear support and other minor correctness fixes).
Minor UI fixes - superuser IPs description grammar fix, rotating btn loader icon alignment fix, slight dark background correction in attempt to minimize the color profile differences between Chrome and Firefox, etc.
Your coding agent can read these notes before it upgrades. Set up the MCP server →
Bumped the min Go GitHub action version to 1.27.2 as it includes several `net/http` security fixes. _One of the fixes is for a DoS that could potentia…
To update the prebuilt executable you can run
./pocketbase update.
Minor improvements for the JSVM migration error handling:
routine.SafeWrap in the returned error (max 2KB).up/down JSVM migration arguments in routine.SafeWrap so that in case of panic we can still print the failed js migration filename.Updated modernc.org/sqlite to 1.60.1 (minor performance improvements for queries with large text fields and/or many params).
Bumped the min Go GitHub action version to 1.27.2 as it includes several net/http security fixes.
One of the fixes is for a DoS that could potentially affect PocketBase applications and it is advised to update.
Other minor fixes (godoc typos, normalized negative jsvm pool size, extra CORS wildcard subdomain checks to prevent misuse, support Promise as autocomplete suggestions return, autoexpand textarea scrollbar-gutter fix, etc.).
Nothing published for this version
Nothing published for this version
app.ResetBootstrapState() was soft-deprecated in favour of app.ClearBootstrap(). _Additionally a new app.OnBootstrapClear() hook was added to allow cl…
To update the prebuilt executable you can run
./pocketbase update.
Fixed migration deadlock if a logs db write happens to run while the migration is still executing (#7836).
app.ResetBootstrapState() was soft-deprecated in favour of app.ClearBootstrap().
Additionally a new app.OnBootstrapClear() hook was added to allow clearing custom allocated OnBootstrap resources in case the app uses a non-standard initialization (e.g. doesn't call Start() or intentionally skip the OnTerminate hook).
Bumped golang.org/x/* dependencies.
> _To update the prebuilt executable you can run ./pocketbase update._
To update the prebuilt executable you can run
./pocketbase update.
Write the status header for JSON responses only if the fields picker succeed or has acceptable fallback. This is to allow custom response status code for failed json writes.
Fixes for various minor bugs spammed by 2 LLM users (bots?):
Fixed collection index validator to allow expressions with parenthesis in the optional WHERE clause.
Clamped arccosine to [-1,1] in the Harvesine formula for the geoDistance() filter function to workaround edge case related to float rounding errors for some coordinates.
Prevent unnecessary body chunk read if we already known that we are beyond the allowed limit.
Updated the json field validator to check the encoding/json/v2 semantics and allow duplicated keys on record marshalize for compliance with old jsonv1 data.
Fixed nested cascade delete of self-referenced relation records.
Minor UI fixes (updated dark primary btn color contrast, force reload the records list if the deleted record has self-referenced cascade relation field, etc.).
Changed JSVM $app variable definition from TS type to interface (#7834).
Bumped golang.org/x/* dependencies to silence security scanners (#7829).
To update the prebuilt executable you can run ./pocketbase update .
To update the prebuilt executable you can run
./pocketbase update.
Return an error when filter params fallback fails to json serialize and optimized params replacement to execute in a single pass.
Fixed collection index parsing error for indexes with missing name.
Minor UI autocomplete optimizations (prefix match, autocomplete debounce, etc.).
Fixed linter warnings and comment typos.
Bumped goja and its related dependencies (regex unescaped dash error fix and base64 optimizations).
Bumped the min Go GitHub action version to 1.27.1 as it includes some minor database/sql and enconding/json/v2 bug fixes.
To update the prebuilt executable you can run ./pocketbase update .
_⚠️ Note that this could be a slight breaking change in case you are chaining PocketBase commands and relied on the previous 0 exit status for Command…
To update the prebuilt executable you can run
./pocketbase update.
Propagate console command errors and recovered panics to app.Start() so that the program can exit with non-zero code while still ensuring that app.OnTerminate hook was triggered (responsible for the app graceful shutdown handling).
⚠️ Note that this could be a slight breaking change in case you are chaining PocketBase commands and relied on the previous 0 exit status for Command.RunE returned errors.
Or in other words, if you have ./pocketbase invalid && someothercommand and previously relied that someothercommand will be always executed then this is no longer the case and you'll have to adjust it or replace && with ;.
Added quotes around the default Content-Disposition serving filename in case custom name with special characters is provided.
Added Cross-Origin-Opener-Policy:same-origin to the default security response headers.
This is an extra precaution to prevent tab-nabbing in case custom UI plugins use target="_blank" without rel="noopener".
Added Record.GetInt64(field) helper (note that the serializable max safe integer of the number field is ~2^53-1).
Added Store.Keys() method that returns a slice with all of the store keys.
Added new DELETE /api/logs endpoint and UI control to delete all logs without changing the maxDays retention setting.
Added new log settings option to limit the max Log.Data size that will be saved in the database (default to ~16KB).
This is an extra precaution for the cases when logging user supplied data without validating it beforehand.
If the resulting Log.Data json is above the limit, it is truncated to the last valid decoded character and an extra "__pb_truncated__":true log data entry will be added.`
Additionally, for just in case the log message is also truncated at max 8k characters.
Added new filesystem low-level helper methods:
filesystem.NewWriter(key, opts) to allow direct file create from an io.Reader value.filesystem.OnNewWriter() hook to allow listening for new/to-be-created files (it is not exposed in core.App instance for now to avoid introducing breaking changes).filesystem.OnDelete() hook to allow listening for deleted files (it is not exposed in core.App instance for now to avoid introducing breaking changes).Optimized backups to no longer transaction lock the database during backup generation (#7799).
Updated modernc.org/sqlite to 1.57.0 and registered by default the new _defensive=1 DSN query parameter to enable SQLite's defensive mode.
Bumped the min Go version to 1.27.0 and migrated to the new encoding/json/v2 package.
⚠️ Please note that Go 1.27.0 retrofitted encoding/json to use the v2 package under the hood but unfortunately is not fully backward compatible.
I recommend to not push blindly an update on production and to test your PocketBase application first locally to see if everything works correctly.
Nothing published for this version
Nothing published for this version
Nothing published for this version
Bumped golang.org/x/* deps and the min Go GitHub action version to 1.26.6 because it comes with some minor bug and security fixes.
To update the prebuilt executable you can run
./pocketbase update.
Other minor UI improvements (fixed sortable dragend event handling, allow ESC to workaround TAB trap for the rule fields, allow new duplicated collection to edit the collection of relation fields, updated shablon, updated npm dev dependencies, etc.).
Bumped golang.org/x/* deps and the min Go GitHub action version to 1.26.6 because it comes with some minor bug and security fixes.
Nothing published for this version
Nothing published for this version
Nothing published for this version
> _To update the prebuilt executable you can run ./pocketbase update._
To update the prebuilt executable you can run
./pocketbase update.
Reverted the auto panic recover handling for the cli commands to preserve the old behavior and allow panic to force exit with non-zero code (#7781). Proper command non-zero exit support will be available with the next v0.40/v0.41 release.
Minor UI improvements (added placeholder loader for the logs chart, npm dev deps update, etc.).
Updated modernc.org/sqlite to v1.55.0 (DSN query params compatibility and doc changes).
> _To update the prebuilt executable you can run ./pocketbase update._
To update the prebuilt executable you can run
./pocketbase update.
Fixed Shift + Click range bulk selection not working in Firefox (#7771)
Updated goja and its related dependencies (fixes for TypedArray and regexp2 dep regression for the reported empty string match with lookahead patterns).
Minor filter (fexpr) improvements (optimization for large string literals and fix for control characters handling).
Bumped golang.org/x/* indirect dependencies as there are some minor security fixes.
To update the prebuilt executable you can run
./pocketbase update.
Properly reset JSVM global $app overwrite so that pooled executors always get a clean state.
Minor UI improvements:
onchange)Shift + Click range bulk selection (#7759)Bumped golang.org/x/* indirect dependencies as there are some minor security fixes.
Updated modernc.org/sqlite to v1.54.0 (SQLite 3.53.3).
> This release includes a security fix related to #7762.
To update the prebuilt executable you can run
./pocketbase update.
[!IMPORTANT] This release includes a security fix related to #7762.
Replaced github.com/go-ozzo/ozzo-validation with the fork github.com/pocketbase/ozzo-validation since the original library has recently changed ownership and the new maintainer cannot be trusted.
There are plans to create eventually a new validation library from scratch more suited for our needs in PocketBase because ozzo-validation is known to have some minor performance and obscure regex issues, but until then we'll stick with the fork (and if you use ozzo-validation in your own Go code, I'd suggest to swap the imports with the fork).
Fixed missing import collection fields property access (#7760).
Fixed View collection * validator and added more friendly error messages (#7761).
⚠️ Security fix for unhandled panic in internal worker goroutines (#7762).
To prevent this from showing again, all existing internal worker functions were wrapped with routine.SafeWrap(f) (auto recovers and returns any eventual panic as regular error).
Nothing published for this version
Nothing published for this version
Bumped the min Go GitHub action version to 1.26.5 as it includes some minor security fixes.
To update the prebuilt executable you can run
./pocketbase update.
Added Cc and Bcc recipients to the dev sendmail command for consistency with the SMTP mailer.
Added extra hardening options to the Microsoft OAuth2 provider allowing developers to specify the preferred safe email extraction method (#7756).
Updated goja and the related golang.org/x/* dependencies (WeakMap regression fixes).
Bumped the min Go GitHub action version to 1.26.5 as it includes some minor security fixes.
Nothing published for this version
Nothing published for this version
> _To update the prebuilt executable you can run ./pocketbase update._
To update the prebuilt executable you can run
./pocketbase update.
Limit with ellipsis long url field values.
Readded the "fullscreen" editor field option and preloaded the TinyMCE component for slightly faster initial rendering (#7746).
Updated goja (TypedArray fixes).
Nothing published for this version
> _To update the prebuilt executable you can run ./pocketbase update._
To update the prebuilt executable you can run
./pocketbase update.
Removed redirectURL required validator from the code->token exchange endpoint (aka. authWithOAuth2Code()) (#7734).
Note that OAuth2 providers have their own validations and whether it is allowed to be empty or not could depend on the configured OAuth2 app (in most cases it is required and the redirect address must match with the initial value submitted with the authorization request).
Enabled sorting by the first implicit presentable relation field (#7735).
Other minor UI fixes (tooltip clear on hovered element removal, optional before element sortable fix, etc.).
Updated goja and the related golang.org/x/* dependencies (regex support improvements).
> _To update the prebuilt executable you can run ./pocketbase update._
To update the prebuilt executable you can run
./pocketbase update.
Fixed JS error on file settings maxSelect change (#7731).
Apply the Ctrl+S record panel save shortcut only if it is the current top open modal.
Fixed number settings validator to not ignore 0 max value.
Normalized field settings validation error messages and tooltips.
> _To update the prebuilt executable you can run ./pocketbase update._
To update the prebuilt executable you can run
./pocketbase update.
Fixed records list UI sorting (#7724).
Don't clear the date input on invalid value while still typing (#7726).
Return filepath.SkipDir in the pb_hooks dirs watcher to avoid unnecessary iterating over node_modules and .* prefixed hidden dirs (.DS_Store, .git, etc.).
Show the "Affected rows" SQL console message only if non-empty to avoid ambiguity with drivers that don't support returning the affected rows count.
Updated modernc.org/sqlite to v1.52.0 (SQLite 3.53.2).
Bumped the min Go GitHub action version to 1.26.4 as it includes some minor security fixes.
To update the prebuilt executable you can run
./pocketbase update.
Fixed multiple select options wrapping (#7720).
Return the hidden record data fields for superusers realtime subscribers (#7721).
Added default panic-recover handling for the cron jobs to avoid terminating the server on panic.
Bumped the min Go GitHub action version to 1.26.4 as it includes some minor security fixes.
> _To update the prebuilt executable you can run ./pocketbase update._
To update the prebuilt executable you can run
./pocketbase update.
Added new "SQL console" section under Settings > Debug allowing executing any raw SQL query from the UI (#2236; #7638).
Note that this is intended for one-off analytic queries, the occasional VACUUM/PRAGMA optimize or debug purposes and not as the primary interface for interacting with your PocketBase data because it can break your application if not used with proper care!
Send system email alerts to superusers in case of an error with the automated backups (#7698).
Various minor improvements and fixes:
oidc2 and oidc3 option fieldsmodernc.org/sqlite to v1.51.0Nothing published for this version
Updated all golang.org/x/ packages to cover the recent security fixes _(none of them should be a critical issue in PocketBase but nonetheless it is ad…
To update the prebuilt executable you can run
./pocketbase update.
Added RealtimeConnectRequestEvent.MaxTimeout field to specify the absolute max duration a realtime connection can remain open (default to 30mins).
This is in addition to the IdeTimeout of 5mins in order to prevent misuse and to allow the GC to run more regularly.
Added extra checks for the connected user IP in the realtime APIs to prevent bruteforce guest subscription update attempts and to serve as an extra protection for the "all-in-one" OAuth2 realtime handler.
Don't reset the records list pagination on record update (#7694).
Updated all golang.org/x/ packages to cover the recent security fixes (none of them should be a critical issue in PocketBase but nonetheless it is advised to update).
Nothing published for this version
> _To update the prebuilt executable you can run ./pocketbase update._
To update the prebuilt executable you can run
./pocketbase update.
Silenced the superuser IPs confirmation if there is no change.
Updated the experimental UI extensions APIs to allow top-level await in the initialization script.
Force unset the auth state of existing realtime connections on user password, collection secret, etc. changes. This is not strictly necessary because the realtime connections have short-lived idle timeout by design but nonetheless it was implemented to minimize the attack vectors.
Added error marker for each collection tab and fixed the styles of the raw errors tooltip.
Fixed indexes collection update error (#7689).
⚠️ The fix comes with a system migration that resaves all collections with indexes to ensure that all indexes are normalized and available in the Collection.Indexes field (it will also include indexes created manually via the sqlite3 cli or other external tool).
If you are using a test pb_data for your Go automation tests you may want to apply the migration to it too so that it runs only once and not for each execution of your tests, aka. you could run once go run main.go migrate up --dir="/path/to/test_pb_data".
Updated modernc.org/sqlite to v1.50.1 (SQLite 3.53.1).
Other minor fixes (updated API preview examples, fixed code comment typos, etc.).
Bumped min Go GitHub action version to 1.26.3 because it comes with some minor bug and security fixes.
To update the prebuilt executable you can run
./pocketbase update.
Fixed UI logs pagination when no custom range is specified.
Fixed default CSP not allowing audio/video previews (#7677).
Serve fixed Content-Type for .xlsx, .docx and .pptx files to allow previews on iOS (#7467).
Changed settings app URL input to type="text" for compatibility with earlier versions (#7681).
Added an internal watcher to sync various runtime states between multiple PocketBase processes (e.g. memory store) using the same pb_data.
This is helpful in case for example a separate PocketBase console command change the collections or application settings while the server is still running.
The watcher is debounced and implemented by watching the special pb_data/.notify dir as a workaround to avoid depending on OS and SQLite driver specific APIs.
Added new Superuser IPs/CIDR subnets whitelist setting.
The optional setting can be changed from the UI under Dasboard > Settings > Application > Superuser IPs.
To avoid lockout in case your superuser IP change, the ips whitelist can be updated also via the superuser ips console command:
# note: --dir is optional and defaults to pb_data next to the executable
# clear whitelisted IPs
./pocketbase superuser ips --dir=/custom/path/to/pb_data
# OR change the whitelisted IPs to 127.0.0.1 and 10.0.0.0 (replace with your real IP(s))
./pocketbase superuser ips 127.0.0.1 10.0.0.0 --dir=/custom/path/to/pb_data
Added rate limit option to exclude IPs/CIDR subnets (#6410).
Bumped min Go GitHub action version to 1.26.3 because it comes with some minor bug and security fixes.
> _To update the prebuilt executable you can run ./pocketbase update._
To update the prebuilt executable you can run
./pocketbase update.
Fixed password fields not being detected as changed (#7670).
Added the local time zone name next to the date field label.
Reload trusted proxy info UI after settings save.
Other minor improvements (skips the duplicated record ids from the IN expand list, reordered confirm-email-change error checks to minimize enumeration attacks, etc.).
Nothing published for this version
> This release include a security fix related to #7662.
To update the prebuilt executable you can run
./pocketbase update.
[!IMPORTANT] This release include a security fix related to #7662.
Added backups list scroll container (#7655).
Optimized record upsert and preview modals data loading to minimize layout jumps.
Fixed SMTP IPv6 network address format (#7659).
Fixed autocomplete selection not properly updating the underlying input value (#7664).
Added ghupdate.BaseURL config option (#7665).
Added dummy bcrypt password check for the failure auth path to minimize enumeration timing attacks when registrations are disabled.
Adjusted Bitbucket, GitHub, GitLab and Gitea/Forgejo OAuth2 providers to better reflect recent API updates and doc references. In case the userinfo data is not sufficient, some of the providers now send a separate list emails request in order to minimize eventual linking security issues caused by custom onpremise setups (e.g. Gitea/Forgejo allows skipping the email verification if an ENV variable is configured).
⚠️ Fixed a pre-hijacking OAuth2 linking vulnerability (#7662; thanks @Alardiians for reporting it privately).
Bumped Go and npm dependencies.
> _To update the prebuilt executable you can run ./pocketbase update._
To update the prebuilt executable you can run
./pocketbase update.
Fixed total count load on page back/forward navigation.
Fixed editor floating dialogs position when scrolling (#7653).
Enabled text wrapping for the API rule fields.
Added view query sample loading indicator.
Other minor light UI contrast and styles improvements.
> _To update the prebuilt executable you can run ./pocketbase update._
To update the prebuilt executable you can run
./pocketbase update.
> _To update the prebuilt executable you can run ./pocketbase update._
To update the prebuilt executable you can run
./pocketbase update.
number field input values normalization (#7646).> _To update the prebuilt executable you can run ./pocketbase update._
To update the prebuilt executable you can run
./pocketbase update.
New UI rewritten from scratch and with support for external customization in mind.
Note that as explained in #7612 the new UI kit and extensions APIs will intentionally remain undocumented until "Stage 2" completion (there no ETAs).
The new UI also introduced several other small improvements:
listAuthMethods() (aka. /api/collection/{col}/auth-methods) now returns the OAuth2 provider logo for each provider as inlined SVG string in its response data.
⚠️ Note that if your app for whatever reason rely on the dashboard OAuth2 logos available under /_/images/oauth2/* they are still available for now but will be removed in future versions and it is recommended to use the new inline SVGs!Added optional no_ui build tag to exclude the UI from bundling with the executable (#7548).
go build -tags no_ui
Exported the internal JSVM bind functions (#7600).
jsvm.BindCore(vm)
jsvm.BindDbx(vm)
jsvm.BindSecurity(vm)
jsvm.BindOS(vm)
jsvm.BindFilepath(vm)
jsvm.BindHTTP(vm)
jsvm.BindFilesystem(vm)
jsvm.BindForms(vm)
jsvm.BindMails(vm)
jsvm.BindApis(vm)
Updated modernc.org/sqlite to v1.49.1 (SQLite 3.53.0).
Added extra OAuth2 checks when downloading the avatar URL to prevent internal network probing requests in case of a malicious/vulnerable vendor.
To update the prebuilt executable you can run
./pocketbase update.
Updated the Discord AuthUser.Name field to use global_name (#7603; thanks @HansHans135).
Fixed settings SMTP password clear persistence.
Added extra OAuth2 checks when downloading the avatar URL to prevent internal network probing requests in case of a malicious/vulnerable vendor.
Updated modernc.org/sqlite to v1.48.2 (vfs and other error path related fixes).
Updated min Go GitHub action version to 1.26.2 because it comes with some minor security fixes.
Other small improvements (updated $apis.static JSVM documentation, fixed comment typos, added missing file close on seek error, etc.).
Bumped all Go and npm deps. _This should also silence recent spam reports and security scanners regarding CVE-2026-33809 (it is not an issue in Pocket…
To update the prebuilt executable you can run
./pocketbase update.
Fixed OAuth2 client secret reset when serializing a cached collection model.
Bumped all Go and npm deps. This should also silence recent spam reports and security scanners regarding CVE-2026-33809 (it is not an issue in PocketBase because we don't support TIFF thumbs).
> _To update the prebuilt executable you can run ./pocketbase update._
To update the prebuilt executable you can run
./pocketbase update.
Fixed high memory usage with large file uploads (#7572).
Updated the rate limiter reset rules to follow a more traditional fixed window strategy (aka. to be more close to how it is presented in the UI - allow max X user requests under Ys) since several users complained that the older algorithm was not intuitive and not suitable for large intervals. Approximated sliding window strategy was also suggested as a better compromise option to help minimize traffic spikes right after reset but the additional tracking could introduce some overhead and for now it is left aside until we have more tests.
Updated modernc.org/sqlite to v1.46.2 and SQLite 3.51.3.
⚠️ SQLite 3.51.3 fixed a database corruption bug that is very unlikely to happen (with PocketBase even more so because we queue on app level all writes and explicit transactions through a single db connection), but still it is advised to upgrade.
Updated other minor Go and npm deps. The min Go version in the go.mod of the package was also bumped to Go 1.25.0 because some of the newer deps require it.
> This is a prerelease to validate a fix for high memory usage when uploading large files ([#7572](https://github.com/pocketbase/pocketbase/discussion
[!CAUTION] This is a prerelease to validate a fix for high memory usage when uploading large files (#7572).
Bumped min Go GitHub action version to 1.26.1 because it comes with some minor bug and security fixes.
To update the prebuilt executable you can run
./pocketbase update.
Set NumberField.OnlyInt:true for the generated View collection schema fields when a view column expression is known to return int-only values (#7538).
Documented the unmarshal JSVM helper (#7543).
Added extra read check after the Store.GetOrSet write lock to prevent races overwriting an already existing value.
Added empty records check for the additional client-side filter's ListRule constraint that was introduced in v0.32.0 (presentator#206).
Set a fixed routine.FireAndForget() debug stack trace limit to 2KB.
Bumped min Go GitHub action version to 1.26.1 because it comes with some minor bug and security fixes.
Typos and other minor doc fixes.
Nothing published for this version
> _To update the prebuilt executable you can run ./pocketbase update._
To update the prebuilt executable you can run
./pocketbase update.
Disabled collection and fields name normalization while in IME mode (#7532; thanks @miaopan607).
Updated modernc.org/sqlite to v1.46.1 (resets connection state on Tx.Commit failure).
> _To update the prebuilt executable you can run ./pocketbase update._
Nothing published for this version
> _To update the prebuilt executable you can run ./pocketbase update._
To update the prebuilt executable you can run
./pocketbase update.
Added Accept-Encoding: identity to the S3 requests per the suggestion in #7523.
This should help fixing the 0-bytes file response when S3 API compression is enabled.
Bumped min Go GitHub action version to 1.26.0 (it comes with minor GC performance improvements).
Other minor fixes (updated modernc.org/sqlite to v1.45.0, updated goja_nodejs adding Buffer.concat, updated the arguments of app.DeleteTable(...), app.DeleteView(...) and other similar methods to make it more clear that they are dangerous and shouldn't be used with untrusted input, etc.).
> _To update the prebuilt executable you can run ./pocketbase update._
To update the prebuilt executable you can run
./pocketbase update.
Updated modernc.org/sqlite to v1.44.3 (race check fix), goja (circular references fix) and other go deps.
Other minor fixes (updated tests to silence some of the race detector errors, updated FindFirstRecordByData with more clear error message when missing or invalid key is used, etc.).
> _To update the prebuilt executable you can run ./pocketbase update._
To update the prebuilt executable you can run
./pocketbase update.
Reverted the DISTINCT with GROUP BY replacement optimization from v0.36.0 as it was reported to negatively impact the indexes utilization for some queries and the minor performance boost that you may get when used on large records is not enough to justify the more common use (#7461).
A better generic deduplication optimization for large records (aka. records with large text/json fields or many small ones) will be researched but there are no ETAs.
Updated modernc.org/sqlite to v1.44.2 (SQLite 3.51.2).
Fixed code comment typos.
Bumped min Go GitHub action version to 1.25.6 because it comes with some minor security fixes.
To update the prebuilt executable you can run
./pocketbase update.
List query and API rules optimizations:
relation field.DISTINCT with GROUP BY id when rows deduplication is needed and when deemed safe.
This should help with having a more stable and predictable performance even if the collection records are on the larger side.For some queries and data sets the above 2 optimizations have shown significant improvements but if you notice a performance degradation after upgrading, please open a Q&A discussion with export of your collections structure and the problematic request so that it can be analyzed.
Added strftime(format, timevalue, modifiers...) date formatting filter and API rules function.
It works similarly to the SQLite strftime builtin function with the main difference that NULL results will be normalized for consistency with the non-nullable PocketBase text and date fields.
Multi-match expressions are also supported and works the same as if the collection field is referenced, for example:
// requires ANY/AT-LEAST-ONE-OF multiRel records to have "created" date matching the formatted string "2026-01"
strftime('%Y-%m', multiRel.created) ?= '2026-01'
// requires ALL multiRel records to have "created" date matching the formatted string "2026-01"
strftime('%Y-%m', multiRel.created) = '2026-01'
⚠️ Minor changes to the search.ResolverResult struct (mostly used internally):
NoCoalesce field with the more explicit NullFallback (NullFallbackDisabled is the same as NoCoalesce:true).MultiMatchSubQuery field with the concrete struct type search.MultiMatchSubquery to avoid excessive type assertions and allow direct mutations of the field.Updated modernc.org/sqlite to v1.44.1 (SQLite 3.51.1).
Bumped min Go GitHub action version to 1.25.6 because it comes with some minor security fixes.
> This is a prerelease for test purposes only!
[!CAUTION] This is a prerelease for test purposes only!
It contains 2 minor list query optimizations related to https://github.com/pocketbase/pocketbase/discussions/7444 that haven't been fully tested and verified yet.
> _To update the prebuilt executable you can run ./pocketbase update._
To update the prebuilt executable you can run
./pocketbase update.
Updated modernc.org/sqlite to v1.43.0 (query cancellation race fix).
Minor UI fixes (normalized relations picker selection and confirmation message when maxSelect=0/1, updated node deps).
One column per quarter.