joer80

Good to know! Should not be any problems there!

So taking the newspaper example, images would probably be stored in day folders. domainname.com/content/uploads/pictures/2014/05/image.jpg So you would never run into a directory limit because that would be a lot of photos in one day. How does process wire do the default image save path? (I think wordpress does a day based path based on the page upload date?)

My current project brought this question up, but I don't think it is going to be too bad, so I guess it's more of a hypothetical question so I know how to structure future projects! Maybe a newspaper would be a good example? To move to a new cms, they would need to import pages by the hundreds of thousands I would imagine?

Also, if I go the non api route and pass in a url query string, is there a process wire way to escape it?

I am planning out a project that will contain a lot of data imported from a csv file, but each row will need its own page. I want to be able to use the api if I can and not go an extra custom table route. My top level is going to be very small, just some of my categories may be large. Is there a total number of pages that you can hit that makes adding custom tables for the data a better option than importing the content as new pages? Thanks!

Thanks for all of this information!

Does using ProcessWire's API to access the db make the query injection safe?

I am new to process wire and am planning on setting up my next few projects on it, but I have a few questions! On a clean install that has nothing but a homepage with a title and description, about how many sql queries are we already looking at? Also, if I want to query a database without using the api selectors, is there a way to piggyback on an open connection? Or do I need to open a new one? (If so, is there a process wire way to do it?) Thanks!