SQLite Support in 2.4 / 3.0 - libSQL ?

[⭐ Alex ⭐]

A question about the upcoming sqlite support, will you be making use of the libSQL driver to support both local and remote sqlite databases? Will it be Turso compatible?

libSQL - Turso

libSQL is a production-ready fork of SQLite, maintained by Turso.

docs.turso.tech

 

[⭐ Alex ⭐]

Turso's newest PHP driver claims to support PDO.

Announcing Laravel Support and PHP PDO Interface

turso.tech

 

[Chris D]

Yeah sounds like you'd just use their PDO driver. 2.4 will be all-in on PDO. I'll try to give it some testing prior to release just in case there's any wrinkles

 

[Chris D]

Okay I had an initial look at it. I'd somewhat describe that link as being "misleading".

There isn't actually a PDO driver. You'd have to use their turso/libsql package which is a native PHP extension using FFI/Rust which means it likely needs additional compilation/configuration in PHP. It also requires the use of their Database class which means it would require a separate XenForo adapter which we're not planning at this time.

 

[MySiteGuy]

While database engine independence is good, my concern is PDO tends to benchmark about 5% to 6% slower with prepared statements using MySQL. I'd be interested in seeing how this translates to real world impact on Xenforo.