On Sunday, May 7, 2017 at 11:16:32 AM UTC-7, Matt Bockman wrote: > > How big is your application/user base? >
At the moment, 1. > Is sqlite not sufficient? > sqlite works quite well for me. But there are applications where it won't scale, mainly because of the locking mechanism. I would rather not be under the pressure of a deadline when I learn some of the Grownup App techniques. > I unwittingly thought sqlite was kind of a toy until I did a little more > research to find out that it is actually very capable and used in a lot of > applications. Based on this: > > https://www.sqlite.org/whentouse.html > > Seems like pretty much any application I see myself writing will work well > in sqlite. > > That being said, the web2py upload field type seems to be very useful, as > it automagically renames the file and stores it into the upload folder, and > stores the path to that file in the database. Also, by some more magic, > when you download the file, it retains the original file name. Pretty neat. > Read more here: > > > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#More-on-uploads > > I use that feature in several apps. This one is different in that I am NOT uploading files; they have their own life on the file system, and I can be adding a couple hundred at a time. > Cheers, > Matt > > Cheerio! Dave /dps > On Wednesday, April 5, 2017 at 12:44:47 AM UTC-7, Dave S wrote: >> >> I have a bunch of pix that I want to display, which are not in the >> uploads directory of the application. My options appear to be: >> >> - copy them to the static folder (or a subfolder) and have URL() work for >> them >> - set up streamio on each so I can read them from an arbitrary filesystem >> location >> - store them as a blob in the database >> >> Is there another option? >> >> If there was just a handful, relatively stable over time, the static >> option would seem a good idea (because it would be simple to do). But I >> took more than 20 shots yesterday (starting with spring hillsides, and then >> trying to capture birds in flight), and that was just one outing (limited >> by the memory card). Taking down those pictures before putting up the next >> set also seems "un-static". >> >> The blob option might be good, but not until I set up a real DB engine >> (I'm not a DB admin) or use mlabs. Meanwhile, I'm still on sqlite. >> >> Also, I might want to look into how to cache the images (not because >> there will be heavy use, but because this might be a good application to >> use for the learning experience). >> >> Suggestions? >> >> /dps >> >> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
