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.
|
|
|
|
|
![]() |
||
General database questions
|
||
| Notices |
![]() |
|
|
LinkBack | Thread Tools |
|
#1
|
|||
|
|||
|
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. |
|
|
|
#2
|
|||
|
|||
|
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 |
|
#3
|
||||
|
||||
|
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.
|
![]() |
| Tags |
| blob, database, integration, user |
| Thread Tools | |
|
|
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 |