SQLite has FTT. Could it be a viable alternative database backend for PW?

[pwFoo]

SQLite would be nice, but not really needed. If possible and changes to database abstraction is needed a move to PDO would make it possible.

At the moment it would be interesting because of a small private php project which should run on cheap webhostings without extra features. So sqlite would reduce the requirements *g*
With a small private projects I would try to keep hosting cost low...

But web hostings with mysql isn't expensive today...

 

[WillyC]

Quote

eeded. If possible and changes to database abstraction is needed a move to PDO would make it possi

pw alreduy.usus PDO

[pwFoo]

@WillyC Haven't checked it... Assumed it because of much work to implement sqlite. So it sounds like compatibility and testing part because pdo sqlite would be possible?

PW db / selectors are awesome and complex. So I' think it isn't an easy part with very low priority...

 

 

[LostKobrakai]

There are two parts to this. Connection to a database and SQL features/parity in results. Connection to the db is abstracted through PDO and most things in processwire use the PDO powered database connection. In old code you might still find things calling to the old mysqli powered processwire class. 

The part about sql features and their parity in implementation/results is another topic, which requires a good amount of knowledge of both databases. Actually PWs query engine isn't really using many fancy sql features, most stuff is just many joins + conditions, but I don't know sqlite well enough to evaluate if everything will be working there as well.

[jonatan]

+1

The easy portability for smaller sites sounds pretty good to me too ?

[waheed]

I would love to see SQLite support in PW. It would allow me to make my PW dev environment portable. I use my perosnal laptop and work PC for development and carry projects in USB Disk. All of my Nodejs and python projects are portable because they all use portable database files (not the database server instance, the actual data files). I know MySQL allows to specify a --datadir when starting, but this is not very portable (at least not for me). I've tried containerizing php and mysql for PW developement, but didn't work out the way I wanted. It just  doesn't allow me to get started immediately.

If sqlite support is implemented we can use a lightweight portable db in development and migrate to MySQL in production.

 

[taotoo]

I'm currently looking at Grav/Kirby/Statamic etc. for certain simple sites where MySql doesn't make sense, but I'd much rather use PW with SQLite.

[bernhard]

@ryan now that NativePHP reached v1 we could build native mobile and desktop apps with ProcessWire if it supported SQLite 🤯🚀 How cool would that be???

[d'Hinnisdaël]

SQLite support would be especially great to signal that ProcessWire prioritizes ease of installation. It's a sane, pragmatic default that avoids the hassle of networked databases. I would assume 80% of new sites to just use that over MySQL if it was available. That said, the selector engine and quite a few third-party modules probably do rely a lot on the strongly typed columns of MariaDB, so I'm not sure how feasible this really is. Types in SQLite are very unintuitive, coming from the MySQL world.