Previous Thread
Next Thread
Print Thread
Rate Thread
#104779 05/19/2003 7:10 PM
Joined: May 2003
Posts: 2
mo2
Offline
Junior Member
Junior Member
Offline
Joined: May 2003
Posts: 2
Heyo,

I was a previous UBB user/owner in a past life up till 6.03 - one thing that always bugged me was the flat file database used - I switched over to another php / mysql based and could not be happier - but I have the urge to go back to ubb but was wondering what the current state of the database schema used was / or if there have been any hacks where we can store the complete info in mysql ( and I dont want to simply switch to ubbthread ... )

Thanks!

Sponsored Links
#104780 05/19/2003 7:58 PM
Joined: Jan 2000
Posts: 5,073
Admin Emeritus
Admin Emeritus
Joined: Jan 2000
Posts: 5,073
There's no way to make UBB.classic use MySQL... plain and simple. Doing it would require a major rewrite of pretty much everything.

Using UBB.threads would be your best bet if you MUST use MySQL.


UBB.classic: Love it or hate it, it was mine.
#104781 05/20/2003 1:54 AM
Joined: Jun 2001
Posts: 729
Coder
Coder
Offline
Joined: Jun 2001
Posts: 729
Then again maybe not tipsy

...Steven
Hostboard.com
Running UBB v6.1.0.4
Doing what NO other UBB in the world is doing.
The first & only production UBB powered by MySQL.

#104782 05/20/2003 2:34 AM
Joined: Mar 2001
Posts: 7,394
LK Offline
Admin / Code Breaker
Admin / Code Breaker
Offline
Joined: Mar 2001
Posts: 7,394
If you pay lots of time and money to jordo you might get a mysql port of UBB tipsy

#104783 05/20/2003 5:48 AM
Joined: Oct 2000
Posts: 2,667
Veteran
Veteran
Offline
Joined: Oct 2000
Posts: 2,667
or you could group up with some users in order to finance the publication of a modification smile but Jordo would still be your man smile


Do you believe in love at first sight,
or should I walk by again?
Sponsored Links
#104784 05/20/2003 10:01 AM
Joined: Jun 2001
Posts: 729
Coder
Coder
Offline
Joined: Jun 2001
Posts: 729
The reasoning behind having a MySQL backend is for extremely large or active systems only.

The base UBB system is designed around small to medium sized systems where the flat file system do not exceed 20,000 in their respective groupings (i.e. members <= 20,000 files : Topics <= 20,000 files) CC has done an amazing job at coding UBB for this market segment and I am sure has alot of surprises for the future.

The 20,000 is seemingly a magic number as Linux has problems with directories that exceed this number of files. It will still work but try listing them. You can get around this by recompiling the Kernal if really necessary.

What you can do if you are really still wanting this is make it a hybrid system. Database the users and topics but leave the flat file system in tact for the rest.

Is it worth the effort? Honestly nope. Why did we do it? As an already established system running with v5.47 it was my familiarity with UBB, users familiarity with UBB in terms of look and feel. Plus I like to be different laugh Also realize if you ever did database your UBB you will never be able to upgrade to a newer version. Anything going forward will have to be custom coded.

You really should take a look at UBBThreads if your set on a database system. The amount of support is equal to UBBDev over at ThreadsDev. I think you will be pleasently surprised.

And as a large UBB system CC will tell you flat out that Hostboard does not count :rolleyes:

BTW, you should really consider upgrading. There have been tremendous strides since the version you are running in performance, features, etc smile

...Steven
Hostboard.com
Running UBB v6.1.0.4
Doing what NO other UBB in the world is doing.
The first & only production UBB powered by MySQL.

#104785 05/20/2003 2:35 PM
Joined: May 2003
Posts: 2
mo2
Offline
Junior Member
Junior Member
Offline
Joined: May 2003
Posts: 2
Thanks for the comments guys

I have been checking out the lastest improvements on ubb - this is why I wanted to know if a mysql based option had become available - as I did hope before infopop brought the threads version they would make a mysql option based ubb classic version but it seems I may have to stick to my current db system - as before my host was complaing about cpu resource usages because of the strain the ubb was putting on the server althou every system has there good / bad points - I wanted an option to seperate the db stuff from the classic scripts and see what improvements there maybe ... maybe in the near future

smile

#104786 06/13/2003 3:43 AM
Joined: Feb 1999
Posts: 1,379
cal Offline
Programmer
Programmer
Offline
Joined: Feb 1999
Posts: 1,379
Quote
quote:
Originally posted by 1QuickSI:
Doing what NO other UBB in the world is doing.
The first & only production UBB powered by MySQL.
That claim is not actually true. I ran a production ubb 5.47 on mysql a number of years ago smirk

#104787 06/13/2003 9:21 AM
Joined: Jun 2001
Posts: 729
Coder
Coder
Offline
Joined: Jun 2001
Posts: 729
Hostboard started pre 5.47 and was running a MySQL backend then although it was never released in to production.

There is/was also another 5.47 system that is running a MySQL backend I believe.

And I still beleive we are Doing what no other UBB in the world is doing.


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
JAISP
JAISP
PA
Posts: 449
Joined: February 2008
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)