baijianpeng
Karma: 4
|
Stupid idea of saving files in database by default - 2006/11/19 13:24
I was suprised to see there is such a very stupid idea in Remository: it will keep the files we uploaded at backend in the databased intead of in the folder we created for saving files, called /downloads or something similar.
Why you set it to save files in database by default ?
This will eat up database space quickly !!! Of course when users want to backup the database, the size become unconveniently big.
In our country, database space is always very small compared with the web space. So it is better to save fiels in a folder than in DB. A folder is also easy to manage than DB.
I can't imagin who had set such a idiot like setting. Do you have too large database and want to use it completely?
Hope you can correct this error.
http://www.joomlagate.com
Chinese Joomla! Users' Portal |
|
|
| | Sorry, you do not currently have permission to write here. |
vibez
Karma: -1
|
Re:Stupid idea of saving files in database by defa - 2006/11/20 11:25
I fail to see what has made you so angry. remository offers the ability to use either the database or the filesystem.
There are several advantage of using the database compared to the file system. Martin has documented these advantages/disadvantges many time on this site.
Ok by default it is set to use the database, but seriously, why is it such a problem for you to review the configuration screen and make the appropriate changes you think would best serve your site.
There always has to be a default configuration and it will not suit everyone. So calm down and think before you post such nonsense next time.
|
|
|
| | Sorry, you do not currently have permission to write here. |
baijianpeng
Karma: 4
|
Re:Stupid idea of saving files in database by defa - 2006/11/20 12:42
Yes, I was angry. Now I still think it should be set to off by default. Not all users are so familiar as we are. A default setting should reflect the habit of common users NOT experienced users.
There is also another thing very annoying. If I set the option to No at backend, then add a new file, I found that the new file will be saved in the database intead of the folder. That is to say, the setting is for Container, not for File. Once the container was set to be saved in DB, later setting of disabling it will not take effect on newer files in this same container. You should delete the container and add a new one to make later files be saved in a folder.
Now you see, if the user had uploaded 10 files before he realised that he had not set this setting to NO which we really wanted to, then he had only one option: delete the container and build a new one, then add all those 10 files manually again !
Shouldn't he be so angry ?
Yes, maybe saving files in DB has some advantage, but you should measure that if MOST users want to do this ? What is more, you also should better make this option for Files instead of for Container.
Do you agree ?
Post edited by: baijianpeng, at: 2006/11/20 07:43
http://www.joomlagate.com
Chinese Joomla! Users' Portal |
|
|
| | Sorry, you do not currently have permission to write here. |
vibez
Karma: -1
|
Re:Stupid idea of saving files in database by defa - 2006/11/20 13:27
I agree it can be a little confusing when changing from database to filesystem storage. I'm not sure how it could be simplified though, maybe a little FAQ in the readme would help people understand the way in which remository handles files.
I think Martin decided to use the database as default as you get far less issues with file/folder permissions as well as better security.
Post edited by: vibez, at: 2006/11/20 08:35
|
|
|
| | Sorry, you do not currently have permission to write here. |
baijianpeng
Karma: 4
|
Re:Stupid idea of saving files in database by defa - 2006/11/20 15:17
Yes, I believe that saving files in DB can offer high level of security guarantee. But not all users want so high security, many files to be downloaded are not so confidential. Maybe the anti-leech method is enough for these files.
For those special files, I think zipped and encrypted before uploading to the server to provide as downloading material is a good idea. You can send the decrypt code to user by e-mail or something more secured.
Now, I want to say another confused thing by this default setting.
I did not notice this until I uploaded two files to the Remository. Then I know I want to save files in folder. So I deleted the container and also deleted the entries in jos_downloads_files table. Next, I set the option to NO and built a new container, uploaded new files. Ok, they are in folder now.
However, my problem is, now the database seems too big. one of the tables named jos_downloads_blob is nearly 1MB size. But I don't dare to empty it since I don't know the structure. In fact, I have contact with Remository component less than one week.
So this is another disadvantage. If user disable the option, the component can't prune the tables automatically even after user deleted the whole container.
I think the authors should think it over before make new improvements. As I know, many users around me choose DocMan as their favorite component for downloading area. But in my opnion, Remository is better than DocMan.
Remository can be even better if they can improve it according to users' preferences, especially the very common users'.
http://www.joomlagate.com
Chinese Joomla! Users' Portal |
|
|
| | Sorry, you do not currently have permission to write here. |
vibez
Karma: -1
|
Re:Stupid idea of saving files in database by defa - 2006/11/20 15:57
The jos_downloads_blob table is where remository stores the chunks of each file you have in your conatiners. So if you are no longer using the database to store your files, it is safe to empty this table.
The reason this table is not already empty id due to the way you deleted your files. You should of used the remository control panel to delete these files. That way the blob table would of been pruned automatically and jos_downloads_files table updated correctly.
If you are using 3.40. There would of been an even quicker way. For example, I have over 4gb of files stored in my database. I decided that I wanted to move them all into the file system.
No problem, just change the "store in database" to 'no', then add an absolute path to each of your new containers. Remository then copies all your files out of the database into the specified folder automagically.
So as you can see, even if you don't like the default settings, changing them only takes a few clicks
|
|
|
| | Sorry, you do not currently have permission to write here. |
|
Forum
