MySQL database size

freddiel

Joined: 2009-11-19
Posts: 2

Posted: Thu, 2009-11-19 22:20

I am planning to setup a photo gallery for the family.
I am just planning the install and have noticed I have a 100mb MySQL size limit, so I am wondering if the images are stored inside the MySQL database or just links to the pictures. If they are stored in the database then I will not be able to upload many pictures of reasonable resolution.

Any help appreciated as I would prefer to make the install once and make it properly.

Thank you.

alecmyers

Joined: 2006-08-01
Posts: 4338

Posted: Thu, 2009-11-19 22:59

Pictures aren't stored in the db, so you should be fine.

nivekiam

Joined: 2002-12-10
Posts: 16503

Posted: Thu, 2009-11-19 23:10

No binary data (photos and such) are NEVER stored in the DB. Doing so is just plain dumb.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

nivekiam

Joined: 2002-12-10
Posts: 16503

Posted: Thu, 2009-11-19 23:32

should've refreshed before posting. that's what I get for opening a thread, going off to do something else and coming back to answer 30 minutes later
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

alecmyers

Joined: 2006-08-01
Posts: 4338

Posted: Thu, 2009-11-19 23:50

Doctor: I'm sorry, you have 6 months to live.
Patient: really? I want a second opinion!
Doctor: OK ... that dress doesn't suit you.

It's nice to have a second concurring opinion sometimes!

freddiel

Joined: 2009-11-19
Posts: 2

Posted: Fri, 2009-11-20 09:50

Thank you for the information.
I do appreciate it would be not a good practice to store the photos in the database, but without offending the developer it would not have been the first time I have seen bad practice....
My motto after 20 years as an IT Consultant is; Better to ask a "stupid question" and get it confirmed then proceed without asking and look stupid afterwards....
I insist on my clients asking stupid questions too, as it often prevents bigger problems..

Anyway I am looking forward to get some pictures on the WEB and show the family in time for Xmas

Thank you again for help and indeed the software..

freddiel Joined: 2009-11-19 Posts: 2	Posted: Thu, 2009-11-19 22:20
	I am planning to setup a photo gallery for the family. I am just planning the install and have noticed I have a 100mb MySQL size limit, so I am wondering if the images are stored inside the MySQL database or just links to the pictures. If they are stored in the database then I will not be able to upload many pictures of reasonable resolution. Any help appreciated as I would prefer to make the install once and make it properly. Thank you.
	XUser login Username: * Password: * Create new account Request new password
alecmyers Joined: 2006-08-01 Posts: 4338	Posted: Thu, 2009-11-19 22:59
	Pictures aren't stored in the db, so you should be fine.

nivekiam Joined: 2002-12-10 Posts: 16503	Posted: Thu, 2009-11-19 23:10
	No binary data (photos and such) are NEVER stored in the DB. Doing so is just plain dumb. ____________________________________________ Like Gallery? Like the support? Donate now!!! See G2 live here

nivekiam Joined: 2002-12-10 Posts: 16503	Posted: Thu, 2009-11-19 23:32
	should've refreshed before posting. that's what I get for opening a thread, going off to do something else and coming back to answer 30 minutes later ____________________________________________ Like Gallery? Like the support? Donate now!!! See G2 live here

alecmyers Joined: 2006-08-01 Posts: 4338	Posted: Thu, 2009-11-19 23:50
	Doctor: I'm sorry, you have 6 months to live. Patient: really? I want a second opinion! Doctor: OK ... that dress doesn't suit you. It's nice to have a second concurring opinion sometimes!

freddiel Joined: 2009-11-19 Posts: 2	Posted: Fri, 2009-11-20 09:50
	Thank you for the information. I do appreciate it would be not a good practice to store the photos in the database, but without offending the developer it would not have been the first time I have seen bad practice.... My motto after 20 years as an IT Consultant is; Better to ask a "stupid question" and get it confirmed then proceed without asking and look stupid afterwards.... I insist on my clients asking stupid questions too, as it often prevents bigger problems.. Anyway I am looking forward to get some pictures on the WEB and show the family in time for Xmas Thank you again for help and indeed the software..

MySQL database size

XUser login