SQLite3 support

Franz · 2013-09-14 20:45:58

Would you be happy about FluxBB 1.5.x supporting SQLite 3? Creating an additional driver should be fairly easy...

CRLin · 2013-09-14 23:04:22

Great!

kierownik · 2013-09-15 01:20:23

That would be cool

Studio384 · 2013-09-15 11:48:19

Yes, why not. Actualy, it's about time.

Last edited by Studio384 (2013-09-15 11:48:30)

Franz · 2013-09-15 15:50:11

Cool. I want more positive votes, though.

And who would be willing to thoroughly test-drive FluxBB with SQLite3 once it's ready?

kierownik · 2013-09-15 17:23:51

+50 votes from me then

Nowasky · 2013-09-16 13:06:18

It would be great

korui · 2013-10-01 13:07:27

Awesome!!!

Franz · 2013-10-02 15:50:01

Here you go then: https://fluxbb.org/development/core/tickets/906/.

isok · 2013-12-18 21:47:09

Hey guys, I've just registered to get some news about Sqlite 3 support in FluxBB. Any progress? If you ask me, I was pretty happy with version 2 (it was almost ideal for small projects), but as soon as PHP decided to drop it and move to Sqlite 3, I'd like to move on as well.

Last edited by isok (2013-12-18 21:47:49)

Franz · 2013-12-18 22:04:53

Hey there.

The problem is that SQLite3 does not support a num_rows()-like method. That's how we do tons of things in the source code, though.

We have a workaround in place, they will need some tests, though. If we get it working, SQLite3 support will be in the next update.

isok · 2013-12-19 04:05:57

Franz wrote:

If we get it working, SQLite3 support will be in the next update.

Great news. Thanks and good luck with this!
Have you already seen this discussion?

webdeveloper.com/forum/showthread.php?244098-RESOLVED-mysql_num_rows-equivalent-for-sqlite3/page2&s=7725dac43565ac8971d1e607431c37ed

... SQLite and SQLite3 have different APIs. SQLite3 doesn't implement buffered results so the total number of results isn't available. This is down to the fact that libsqlite really doesn't implement it either and its emulated by the old SQLite extension.

Last edited by isok (2013-12-19 04:06:09)

Franz · 2013-12-19 09:45:48

Yeah, that is pretty much how we implemented it.

Alberto5 · 2014-04-23 11:09:16

Hello!

I have only sqlite3 available on my host and use at the moment punbb, but I want to switch to fluxbb.
What must I do to be able to run FluxBB with sqlite3 support on my host?

Will the next stable release of FluxBB run with sqlite3?

Last edited by Alberto5 (2014-04-23 11:09:54)

Franz · 2014-04-23 22:41:44

We're trying...

w8diz · 2014-08-10 10:18:49

Hello All,
I've been running FluxBB 1.2.20 for many years. Now I'm moving to a new server PHP5.4.31 and do not find an upgrade path.
Is there any positive news about an SQLite3 driver? I would be happy to keep the old version 1.2 as long as I have php sqlite3 support.
If the answer is no, does anyone have a suggestion for moving fluxbb version 1.2 to another BB or is my current BB destined for the graveyard?
Sorry for the negativity but I've searched all over the web and find no solutions.
And I would be happy to test any work done on an sqlite3 driver.

Studio384 · 2014-08-10 10:31:32

FluxBB 1.2 doesn't support SQLite 3, unless you added that yourself. If so, adding those changes to the current FluxBB 1.5.6 core should work most of the times. Anyway, I would suggest you to update to at least FluxBB 1.2.24 if you are going to stay in the 1.2 branch. Otherwise, Franz is currently working on SQLite 3 support for FluxBB 1.5.7, so stay tuned on that.

w8diz · 2014-08-10 12:57:20

Studio384 wrote:

FluxBB 1.2 doesn't support SQLite 3, unless you added that yourself. If so, adding those changes to the current FluxBB 1.5.6 core should work most of the times. Anyway, I would suggest you to update to at least FluxBB 1.2.24 if you are going to stay in the 1.2 branch. Otherwise, Franz is currently working on SQLite 3 support for FluxBB 1.5.7, so stay tuned on that.

Hi Studio384,
You misunderstood my post...My new server does not support SQlite2 and without it my fluxbb is dead in the water.
Thanks for the reply - Diz, W8DIZ

w8diz · 2014-08-10 14:50:32

OK...I'll bite...I will attempt to create an SQlite3 version of the DB interface for FluxBB.
Anyone that has done any roadwork and is willing to help me, the more the better.
-Diz, W8DIZ

adaur · 2014-08-10 16:15:19

Hello,

If you own the server, why don't you install the latest MariaDB? It provides excellent performances and is fully compatible with FluxBB.

Otherwise, you can try thoses changes:

https://github.com/fluxbb/fluxbb/commit … afde859aa8
https://github.com/fluxbb/fluxbb/commit … 8fd5774ba4
https://github.com/fluxbb/fluxbb/commit … 4524a90959

Plus this if it doesn't work
https://github.com/Koos10/fluxbb/blob/m … qlite3.php

Last edited by adaur (2014-08-10 16:17:02)

w8diz · 2014-08-10 18:04:26

Hello Adaur,

Thank you for the reply.

I am a very big fan of the single file sqlite database concept; very easy to manage.
I will review the links you gave me above and see what happens, and will report back my results, right here.

Thanks, Diz, W8DIZ (and excuse my poor English, I'm an American)

GWR · 2014-08-12 19:11:57

The move from SQLite2 to SQLite3 mostly means moving to PDO as some hosts do not install the necessary modules for an "Sqlite3"-based access.

This means you will have to replace all queries, as they now run over the PDO-oo-interface, or just use the non-oo-wrapper functions.

Another Option is to replace all queries with custom wrappers (you wrote) ... so then just prefix the commands with yours (such as "mynick_mysql_query") which then routes everything to the appropriate database. Take care of replacing everything. Things like "mysql_affected_rows" might not be valid with sqlite (eg. only on changed rows, not on "tried to change" rows).

bye
Ron

w8diz · 2014-08-12 19:37:58

I give up
I've been running FluxBB 1.2.20 with SQlite2 nad my new server only has SQlite3 (SQlite2 not available anymore)
Looks like I need to use a different database like mySQL
Will I be able to convert my SQlite FluxBB1.2.20 to the latest 1.5.x FluxBB using mySQL?
Is there a 2 step solution to upgrade and then switch databases or vice versa?
I know this is traitor talk but I'm looking at myBB as a possible solution.
-Diz, W8DIZ

adaur · 2014-08-12 19:57:38

Test the files I've sent to you with the latest FluxBB!

To update from 1.2 to 1.5 branch, simply paste the new files over the old ones and go to your forum.

w8diz · 2014-08-13 17:50:06

adaur wrote:

Test the files I've sent to you with the latest FluxBB!
To update from 1.2 to 1.5 branch, simply paste the new files over the old ones and go to your forum.

OK...made all changes...getting this error and warning: missing file ==> fluxbb/include/utf8/utf8.php
fixed that...my error ...file permission error; now fluxBB is running sqlite.php and not sqlite3.php
error --> "This PHP environment doesn't have SQLite support built in."
looking for that...

OK, I overwrite version 1.2.20 with 1.5.6, then made all the edits per instructions.
Also converted my fluxbb.sqlite2 file to fluxbb.sqlite3

So why is the program still looking at fluxbb.sqlite2?
The common.php script has the $db_name as fluxbb.sqlite3

maybe I need a bigger shotgun to fix this - Diz, W8DIZ

Last edited by w8diz (2014-08-14 00:04:53)

Forums

#1 2013-09-14 20:45:58

SQLite3 support

#2 2013-09-14 23:04:22

Re: SQLite3 support

#3 2013-09-15 01:20:23

Re: SQLite3 support

#4 2013-09-15 11:48:19

Re: SQLite3 support

#5 2013-09-15 15:50:11

Re: SQLite3 support

#6 2013-09-15 17:23:51

Re: SQLite3 support

#7 2013-09-16 13:06:18

Re: SQLite3 support

#8 2013-10-01 13:07:27

Re: SQLite3 support

#9 2013-10-02 15:50:01

Re: SQLite3 support

#10 2013-12-18 21:47:09

Re: SQLite3 support

#11 2013-12-18 22:04:53

Re: SQLite3 support

#12 2013-12-19 04:05:57

Re: SQLite3 support

#13 2013-12-19 09:45:48

Re: SQLite3 support

#14 2014-04-23 11:09:16

Re: SQLite3 support

#15 2014-04-23 22:41:44

Re: SQLite3 support

#16 2014-08-10 10:18:49

Re: SQLite3 support

#17 2014-08-10 10:31:32

Re: SQLite3 support

#18 2014-08-10 12:57:20

Re: SQLite3 support

#19 2014-08-10 14:50:32

Re: SQLite3 support

#20 2014-08-10 16:15:19

Re: SQLite3 support

#21 2014-08-10 18:04:26

Re: SQLite3 support

#22 2014-08-12 19:11:57

Re: SQLite3 support

#23 2014-08-12 19:37:58

Re: SQLite3 support

#24 2014-08-12 19:57:38

Re: SQLite3 support

#25 2014-08-13 17:50:06

Re: SQLite3 support

Board footer