UBB.Developers Forums UBB.classic V6.4 - 6.7 Modifications V6 Mod Ideas Flat file to SQL database mod...

Would anyone else rather update UBB.clasic to use a database instead of changing over to UBB.threads?

We may start work on this if anyone would be interested... would like to hear your ideas.

It's been done a couple times but it locks you into whatever version of UBB you convert since upgrades would be a complete rebuild. I would love it in theory but I upgrade a lot.

hmm, I don't see a huge problem making changes with upgrades... once the basic database system was built updates to it shouldn't be that hard unless there was a major rewrite... shouldn’t be too different from most other hacks… let me know if I am wrong.

This is just the reason I posted this, to see what kind of problems there would be that I hadn’t thought of.

edit: Could someone point me in the right direction for a thread or page about someone doing this before? I had searched the forums and couldn't find anything

hmmm, I've seen it done on 2 sites, but no-one's shared the code

www.hostboard.com is the most widely-known one.

Wow...78 thousand + registered. Wow...

If I had enough activity to require the database solution I would opt for another product. I can't say that it would be Threads because I don't consider it to be UBB.

We all know that we're here because we love our flat file based UBBs, and I tried to leave this community but failed...

This is NOT a project for the faint of heart. Almost any modifications after the basic system will also have to be re-written as well.

TheX is right for the most part that it will lock you to what ever version you decide to port as upgrading will become nightmarish. Just think about every call to a file that has to be changed. Then think of how much CC adds and how calls get added and how you will have to track them down each time a new version comes out.

But on the flip side Hostboard's code also has kept pace with the most current UBB version but again at the price of having to code it all from scratch.

Due to Hostboard's size I had to make a choice either to move away from UBB and find another product which would also have required a major coding project or stay with UBB and do the unusual. Guess you can figure out what was chosen

Hostboard:
78k+ registered users
83k+ threads
725k+ posts
2k+ message boards

Hostboard is unlike any UBB in the world or any message board software package available. Best way to explain is a smaller version of EZBoard.

All I need is 77k more registered users and I'm in contention.

Very nice work Quick.

Dare I say it, but doing yet another project like this is absolutely futile. While one could easily splice in SQL statements in place of file opens, that doesn't get the job done and is horribly ineffecient. Doing it the right way would require signifigant rewriting of signifigant portions of the code. In the end, the effort wouldn't be worth it. You'd be better off starting with Threads and modifying it to suit your needs / be more UBB-like in terms of appearance.