ProcessWire 3.0.274 – Core updates

[ryan]

ProcessWire adds SQLite and PostgreSQL support. This week on the dev branch (3.0.274) you can now install and run ProcessWire on SQLite or PostgreSQL, in addition to MySQL. Read more in this blog post:

https://processwire.com/blog/posts/sqlite-and-postgresql

 

[adrian]

Thanks for merging all this so quickly @ryan - I feel like folks might also be interested in this benchmark table:
https://github.com/processwire/processwire/pull/372#issuecomment-5841901625

 

[Kiwi Chris]

Thanks for all the work on this. This could be an absolute game changer, and extends the ProcessWire philosophy of letting you choose how you want to do things rather than forcing a particular way on you.

The benchmarks are interesting, and I think support for all three flavours of SQL is a good idea, as each may have their ideal use cases.

Down the track, I'd be interested to know what the benchmarks would be like if there were no translation layer, but already the gains in performance are significant, and any losses are small, so the translation code must be pretty efficient already.

 

[Tiberium]

If I read table correctly, that PostgreSQL is the overall better choice for performance. When it losed a metric to SQLite, it is not as bad as MySQL. 🤔

[Tiberium]

And also my favorite, that also got a side note in the blog post: The new ProcessExportProfile version, who final seems to allow role export:

Quote

Allow profiles to export permissions, roles, users, passwords, and associated file assets while preserving the authentication salt and saved export choices

It exports the roles in the past, but not set up with the right permission. So I read that commit, that is now an optional choice. Yeah!

[zilli]

Well done @ryan and @adrian! This is amazing!

Now next stop, Nginx official support 😉

 

[wbmnfktr]

I tried to use the Site Builder, yet... no chance.
I thought I messed something up during the installation, tried again on a clean installation.
And another one. And again.

No luck for now - at least for me.

Tried Deepseek API, OpenCode Go, CommandCode, Z.AI Coding Plan... some of them won't even connect.
Errors were: 404, model unknown, no endpoint

I'd love to see and have a more detailed log about what was tried, what didn't work out, and why the error was thrown.

 

On the positive side:

DeepSeek V4.1 Flash (super cheap and super fast) runs now on quite some projects - in AgentTools and CLI - and nails almost every task in ProcessWire. Those AGENTS.md files all around... [chefskiss-emoji.gif]

[wbmnfktr]

Additional note:

The provider, model, API that works in the installer, does not always work in the AgentTools and vice versa.

Same provider (Anthropic/OpenAI Compatible), endpoint, model, API key works in AgentTools, but not in the installer. Something seems off.

[wbmnfktr]

Issues added #2349 and #2350

[maximus]

I started adding PostgreSQL and SQLite compatibility to my modules

[csaggo.com]

This is awesome. I will try the sqlite feature asap as a couple of rather small sites are planned. sqlite is a nice gift for those. PostgreSQL should be quite an improvement on really large or complex-query-heavy sites.

Great news!

[Jonathan Lahijani]

On 9/26/2026 at 5:14 AM, zilli said:

Well done @ryan and @adrian! This is amazing!

Now next stop, Nginx official support 😉

 

Looks like this was JUST added:
https://github.com/processwire/processwire/commit/e20c821da70c1b892fb54a711ca816907210cd1b

@ryan Can we pretty please get support for Caddy as well?

[eelkenet]

2 hours ago, Jonathan Lahijani said:

Looks like this was JUST added:
https://github.com/processwire/processwire/commit/e20c821da70c1b892fb54a711ca816907210cd1b

@ryan Can we pretty please get support for Caddy as well?

Amazing! 

[Ivan Gretsky]

11 hours ago, Jonathan Lahijani said:

Can we pretty please get support for Caddy as well?

+1 for Caddy! 

And I just want to say that the heat just ain't cooling down!)

[zilli]

Here we go @Jonathan Lahijani https://github.com/processwire/processwire/commit/521d3346bd18f1bcaf06240867ebebe976cfa01e

[Jonathan Lahijani]

13 hours ago, Ivan Gretsky said:

+1 for Caddy! 

And I just want to say that the heat just ain't cooling down!)

Indeed.  Here's my running list of the major additions to ProcessWire in the last few months:

+ MAJOR FIXES
  + delete speed
  + subselectors
  + deadlocks
/
+ CLI Modules
+ CLI Installer
+ WireTests
+ Agent Tools module
  + Migrations
+ Skills
  all the new markdown files
+ Database Abstraction
  Sqlite and Postgres
+ Web Servers
  Nginx and Caddy

I'm utilizing all of them (well not the DB and web server stuff yet, but soon).  My queue module will fit in nicely... but hey, if there were a native, standard queue module that would be fantastic too.

Truly amazing.

[Jonathan Lahijani]

@ryan Any chance we can fast-track pagination for repeaters?  It was discussed in this blog post from 2016:

https://processwire.com/blog/posts/fieldtype-pagination/

 

[adrian]

Agree with @Jonathan Lahijani - pagination for Repeaters is something I really need as well.

[taotoo]

Very excited by the new sqlite option! I wonder if converting an existing site to sqlite is doable.

[adrian]

@Jonathan Lahijani - do you have any thoughts about dragging/dropping items when paginated? Do we assume it's not needed beyond a certain number of items that triggers pagination, or do we just allow ordering within the current page?

[Gideon So]

On 10/2/2026 at 7:09 AM, taotoo said:

Very excited by the new sqlite option! I wonder if converting an existing site to sqlite is doable.

If I read the commit log right, it is doable.

Gideon

[taotoo]

8 hours ago, Gideon So said:

If I read the commit log right, it is doable.

Gideon

Ah - I was so excited I forgot to click the link 🙂

[adrian]

Just an FYI that the latest version of TracyDebugger includes support for SQLite and Postgres in AdminNeo.