Forums

Unfortunately no one can be told what FluxBB is - you have to see it for yourself.

You are not logged in.

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

Franz
Lead developer
From: Germany
Registered: 2008-05-13
Posts: 6,590
Website

SQLite3 support

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


fluxbb.de | develoPHP

"As code is more often read than written it's really important to write clean code."

Online

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

CRLin
Member
From: Taiwan
Registered: 2011-02-17
Posts: 65
Website

Re: SQLite3 support

Great!

Offline

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

kierownik
Member
From: Tilburg, Netherlands
Registered: 2008-05-10
Posts: 335

Re: SQLite3 support

That would be cool smile


My GitHub Profile

Offline

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

Studio384
Developer
From: Belgium
Registered: 2012-04-11
Posts: 681
Website

Re: SQLite3 support

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

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

Offline

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

Franz
Lead developer
From: Germany
Registered: 2008-05-13
Posts: 6,590
Website

Re: SQLite3 support

Cool. I want more positive votes, though. smile

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


fluxbb.de | develoPHP

"As code is more often read than written it's really important to write clean code."

Online

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

kierownik
Member
From: Tilburg, Netherlands
Registered: 2008-05-10
Posts: 335

Re: SQLite3 support

+50 votes from me then wink


My GitHub Profile

Offline

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

Nowasky
Member
From: Brazil
Registered: 2011-08-22
Posts: 14

Re: SQLite3 support

It would be great

Offline

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

korui
Member
From: Guangdong,China
Registered: 2010-02-01
Posts: 16

Re: SQLite3 support

Awesome!!!

Offline

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

Franz
Lead developer
From: Germany
Registered: 2008-05-13
Posts: 6,590
Website

Re: SQLite3 support


fluxbb.de | develoPHP

"As code is more often read than written it's really important to write clean code."

Online

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

isok
New member
Registered: 2013-12-18
Posts: 2

Re: SQLite3 support

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)

Offline

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

Franz
Lead developer
From: Germany
Registered: 2008-05-13
Posts: 6,590
Website

Re: SQLite3 support

Hey there. smile

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.


fluxbb.de | develoPHP

"As code is more often read than written it's really important to write clean code."

Online

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

isok
New member
Registered: 2013-12-18
Posts: 2

Re: SQLite3 support

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)

Offline

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

Franz
Lead developer
From: Germany
Registered: 2008-05-13
Posts: 6,590
Website

Re: SQLite3 support

Yeah, that is pretty much how we implemented it.


fluxbb.de | develoPHP

"As code is more often read than written it's really important to write clean code."

Online

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

Alberto5
New member
Registered: 2014-04-23
Posts: 1

Re: SQLite3 support

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)

Offline

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

Franz
Lead developer
From: Germany
Registered: 2008-05-13
Posts: 6,590
Website

Re: SQLite3 support

We're trying...


fluxbb.de | develoPHP

"As code is more often read than written it's really important to write clean code."

Online

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

w8diz
Member
Registered: 2014-08-10
Posts: 7

Re: SQLite3 support

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.

Offline

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

Studio384
Developer
From: Belgium
Registered: 2012-04-11
Posts: 681
Website

Re: SQLite3 support

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.

Offline

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

w8diz
Member
Registered: 2014-08-10
Posts: 7

Re: SQLite3 support

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

Offline

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

w8diz
Member
Registered: 2014-08-10
Posts: 7

Re: SQLite3 support

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

Offline

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

adaur
Developer
From: France
Registered: 2010-01-07
Posts: 842
Website

Re: SQLite3 support

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)


FeatherBB - A simple and lightweight new generation forum system
Based on FluxBB, written in PHP, using Slim Framework for a proper OOP-MVC architecture.

Offline

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

w8diz
Member
Registered: 2014-08-10
Posts: 7

Re: SQLite3 support

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)

Offline

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

GWR
Member
From: Germany
Registered: 2010-08-06
Posts: 194

Re: SQLite3 support

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

Offline

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

w8diz
Member
Registered: 2014-08-10
Posts: 7

Re: SQLite3 support

I give up sad
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

Offline

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

adaur
Developer
From: France
Registered: 2010-01-07
Posts: 842
Website

Re: SQLite3 support

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

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


FeatherBB - A simple and lightweight new generation forum system
Based on FluxBB, written in PHP, using Slim Framework for a proper OOP-MVC architecture.

Offline

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

w8diz
Member
Registered: 2014-08-10
Posts: 7

Re: SQLite3 support

adaur wrote:

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

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 smile - Diz, W8DIZ

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

Offline

Board footer

Powered by FluxBB