General database questions

This is a discussion on "General database questions" within the Databases section. This forum, and the thread "General database questions are both part of the Program Your Website category.


 Subscribe in a reader

Go Back   Webforumz.com > Main Forums > Program Your Website > Databases

Notices




Reply
 
LinkBack Thread Tools
  #1  
Old Dec 9th, 2006, 05:13
New Member
Join Date: Dec 2006
Location: usa
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
General database questions

Hello. As someone might have seen already from my post in the PHP forum, I'm kind of new to dynamic web design. I have some questions regarding MySQL, mostly general ones:

I am in the process of using an IPB forum as the user database for my site. I would like to know how this process is done, and if there are any tips to follow so that I can take advantage of the groups system, as well as add new fields by myself.

Also, I want to know what is the best way to store files in a website, for backup, restoration, and download processes. I've read a little about the blob data type in a MySQL database, and it appears to be generic binary storage. Can I use this to store the files directly in the database? is it a good practice? will it work with files as big as 50Mb?

Thanks in advance.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

  #2  
Old Dec 9th, 2006, 22:30
Up'n'Coming Member
Join Date: Jun 2006
Location: Rochester, NY
Posts: 67
Thanks: 0
Thanked 0 Times in 0 Posts
Re: General database questions

ive never stored files in my database, so i dont know about the second part.
I often organize my files by name and link in my database, but i keep them on an ftp. Not in the database.

As for the user and groups system, my website devfile.com has my scripts in paralell to the forum scripts(phpbb) i didnt want to try and edit the phpbb talbles so i made my own and all the data that is shared i enter into both, then take from either one depending on if your using the main website or the forums.
this is probably bad practice, but i didnt want to mess up phpbb and i figured it would only be a minor setback.
__________________
www.MonsterCoding.com - Website Programming and Development Services
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3  
Old Dec 13th, 2006, 00:35
Ryan Fait's Avatar
Elite Veteran
Join Date: May 2006
Location: Las Vegas
Posts: 3,787
Thanks: 0
Thanked 0 Times in 0 Posts
Re: General database questions

It's not a good idea to put large files in a database. I don't even put small ones in.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
blob, database, integration, user

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
General Mac Problems gribble Webforumz Cafe 29 Aug 29th, 2007 22:31
General Error(!) Daniel Databases 8 Aug 21st, 2007 09:57
General Help needed davor2000 Web Page Design 4 Jun 12th, 2007 15:03
JavaScript/DHTML newbie -- general questions sergiu JavaScript Forum 7 Jun 21st, 2006 22:22
graphics in general ivyholly Graphics and 3D 5 Oct 5th, 2005 11:55


All times are GMT. The time now is 12:34.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42