SQLite Support in 2.4 / 3.0 - libSQL ?

⭐ Alex ⭐

⭐ Alex ⭐

Well-known member
Licensed customer
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?

docs.turso.tech

libSQL - Turso

libSQL is a production-ready fork of SQLite, maintained by Turso.
docs.turso.tech docs.turso.tech
 
Solution
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.
Sort by date Sort by votes
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 :)
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Solution
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.
 
Upvote 0 Downvote
Back
Top Bottom