UBB.Developers Forums UBB.classic V6.4 - 6.7 Modifications V6 Mod Ideas Hack for MySQL database

What about a hack to use MySQL instead of flat file db?

Up..

ive thought about this one, but its very very doubtfull ill do it - even though they made it a bit easier in 6.1.0 by making all file writes called from generic subs...

Charles can probably give you a few hints... he's said there are a few routines that should make it much easier.

&OpenTopic, &WriteTopic, &OpenProfile, &WriteMemberProfile.

Nuff said.

i really like this idea, seein how my server just gave me the option for MySQL, it woud be nice to be able to run on it if u want to. i mean ALOT of my members are "use vb it has MySQL" and of coures i will not go to vb

[ August 15, 2001: Message edited by: Anime-loo ]

Why is it very very doubtful?

This would make a good UBB 6.2 feature, the ability to pick from MSQL or file database.

UBB will never natively use an RDBMS. (Natively meaning stock, out of the box, without modification of any sort)

80% of the work (the profiles and topics) can be done in 20% of the time... the other 20% of the work will take 80% of the time due to the sheer ammount of crap that has to be altered.

[ August 17, 2001: Message edited by: Charles Capps ]

the big question is will this effect hacks? if your ubb went mySQL would it kill all your hacks or not ? O.o (im stupid at these kinda things heh)

if i couldent get it to run on mySQL any other ways to make it speed up a bit? im hella fast as it is but i would still like better speed..

I'm working on a database management system i call "iUBB", in essence its a REAL version of iB's iDatabase system. Where it connects to the SQL database, stores, receives and prints data to it.
basically we'll do a call to:
use DBI; # <--run the DBI module
use iUBB::SQL; # <--custom build module::sql section
use iUBB::ubbcgi; #<--certain parts only need loading for certain files.

The iUBB system will allow CP connection of mySQL/mSQL or PostgresSQL databases, a conversion section, MAINTAINING AND UPDATING the database when a new version is released (ie,. nothing will ever be lost) and easy upgrading.

Its not a fake SQL.

Its iUBB, Interdatabased UBB System.

Its a bast to write.
Its 45% done.
It works about 15% of the way.

Its lost on a disk.

That sounds cool mastermind. Cant wait to see it.

Maybe it could be released alongside version 7.0?

MasterMind: LOL well i hope u can get it out soon, id really love to try it.

[ August 18, 2001: Message edited by: Anime-loo ]

would make sense to me for infopop to just offer a flat file version and a mysql version

we pay that much for the software, some more options would be nice.

[ August 26, 2001: Message edited by: CtrlAltDel ]

MySQL conversion is a huge undertaking; frankly I don't think it's really worth the time

qasic

RIGHT ON!!!

a SQL addon would be great!! I mean, this would be PERFECT for big sites which UBB puts a big load on... for example, 411hype, they were GODLY in my eyes when they had their UBB, but it put too much strain on the server so they switched to mySQL powered vBulletin, and look at it now, it sucks!!

[EDIT]You might wish to pick your choice of words more wisely next time. Language like that is not acceptable here.[/EDIT]

[EDIT]: oh sorry, i forgot this place was an exception to the 1st amendment... my bad...

[ August 26, 2001: Message edited by: Matt Jacob ] *cough*communist*cough*

[ August 29, 2001: Message edited by: psychopathic ]