Re: [PHP] storing searching docs

2012-12-15 Thread tamouse mailing lists
On Dec 13, 2012 4:50 PM, Jim Giner jim.gi...@albanyhandball.com wrote: Thanks for all the posts. After reading and googling all afternoon, I think the best approach for me is: Create two macros in Word (done!) to export each of my .doc files to .txt and .pdf formats. Create a sql table to

Re: [PHP] storing searching docs

2012-12-15 Thread tamouse mailing lists
On Dec 13, 2012 4:50 PM, Jim Giner jim.gi...@albanyhandball.com wrote: Thanks for all the posts. After reading and googling all afternoon, I think the best approach for me is: Create two macros in Word (done!) to export each of my .doc files to .txt and .pdf formats. Create a sql table to

Re: [PHP] storing searching docs

2012-12-15 Thread tamouse mailing lists
On Dec 15, 2012 7:29 AM, tamouse mailing lists tamouse.li...@gmail.com wrote: On Dec 13, 2012 4:50 PM, Jim Giner jim.gi...@albanyhandball.com wrote: Thanks for all the posts. After reading and googling all afternoon, I think the best approach for me is: Create two macros in Word

Re: [PHP] storing searching docs

2012-12-15 Thread Jim Giner
On 12/15/2012 8:26 AM, tamouse mailing lists wrote: On Dec 13, 2012 4:50 PM, Jim Giner jim.gi...@albanyhandball.com wrote: Thanks for all the posts. After reading and googling all afternoon, I think the best approach for me is: Create two macros in Word (done!) to export each of my .doc

Re: [PHP] storing searching docs

2012-12-15 Thread Jim Giner
On 12/15/2012 8:29 AM, tamouse mailing lists wrote: On Dec 13, 2012 4:50 PM, Jim Giner jim.gi...@albanyhandball.com wrote: Thanks for all the posts. After reading and googling all afternoon, I think the best approach for me is: Create two macros in Word (done!) to export each of my .doc

Re: [PHP] storing searching docs

2012-12-15 Thread Ashley Sheridan
On Sat, 2012-12-15 at 12:21 -0500, Jim Giner wrote: On 12/15/2012 8:26 AM, tamouse mailing lists wrote: On Dec 13, 2012 4:50 PM, Jim Giner jim.gi...@albanyhandball.com wrote: Thanks for all the posts. After reading and googling all afternoon, I think the best approach for me is:

Re: [PHP] storing searching docs

2012-12-15 Thread tamouse mailing lists
On Sat, Dec 15, 2012 at 11:21 AM, Jim Giner jim.gi...@albanyhandball.com wrote: On 12/15/2012 8:26 AM, tamouse mailing lists wrote: On Dec 13, 2012 4:50 PM, Jim Giner jim.gi...@albanyhandball.com wrote: Thanks for all the posts. After reading and googling all afternoon, I think the best

Re: [PHP] storing searching docs

2012-12-15 Thread tamouse mailing lists
On Sat, Dec 15, 2012 at 11:22 AM, Jim Giner jim.gi...@albanyhandball.com wrote: On 12/15/2012 8:29 AM, tamouse mailing lists wrote: On Dec 13, 2012 4:50 PM, Jim Giner jim.gi...@albanyhandball.com wrote: Thanks for all the posts. After reading and googling all afternoon, I think the best

Re: [PHP] storing searching docs

2012-12-15 Thread Jim Giner
I think im good with a text for the db and search capability and the pdf for pure display jg On Dec 15, 2012, at 5:31 PM, tamouse mailing lists tamouse.li...@gmail.com wrote: On Sat, Dec 15, 2012 at 11:22 AM, Jim Giner jim.gi...@albanyhandball.com wrote: On 12/15/2012 8:29 AM, tamouse

Re: [PHP] storing searching docs

2012-12-13 Thread Jim Giner
Thanks for the input gentlemen. Two opposing viewpoints! I understand the concept of using files for the docs and a table to locate them and id them. But I am of the opinion that modern dbs are capable of handling very large objects (of which these docs are NOT!) much easier than years ago,

Re: [PHP] storing searching docs

2012-12-13 Thread Matijn Woudt
On Thu, Dec 13, 2012 at 3:10 PM, Jim Giner jim.gi...@albanyhandball.comwrote: Thanks for the input gentlemen. Two opposing viewpoints! I understand the concept of using files for the docs and a table to locate them and id them. But I am of the opinion that modern dbs are capable of

Re: [PHP] storing searching docs

2012-12-13 Thread Jim Giner
On 12/13/2012 9:19 AM, Matijn Woudt wrote: On Thu, Dec 13, 2012 at 3:10 PM, Jim Giner jim.gi...@albanyhandball.comwrote: I'm not sure if there's much difference between large text fields and blobs, but I had a database (MySQL) with rows that had one blob each of 5-10 mb. At around 200-300

Re: [PHP] storing searching docs

2012-12-13 Thread Matijn Woudt
On Thu, Dec 13, 2012 at 3:32 PM, Jim Giner jim.gi...@albanyhandball.comwrote: On 12/13/2012 9:19 AM, Matijn Woudt wrote: On Thu, Dec 13, 2012 at 3:10 PM, Jim Giner jim.gi...@albanyhandball.com **wrote: I'm not sure if there's much difference between large text fields and blobs, but I

Re: [PHP] storing searching docs

2012-12-13 Thread Bastien
Bastien Koert On 2012-12-13, at 9:10 AM, Jim Giner jim.gi...@albanyhandball.com wrote: Thanks for the input gentlemen. Two opposing viewpoints! I understand the concept of using files for the docs and a table to locate them and id them. But I am of the opinion that modern dbs are

Re: [PHP] storing searching docs

2012-12-13 Thread Jim Giner
On 12/13/2012 10:56 AM, Bastien wrote: Bastien Koert On 2012-12-13, at 9:10 AM, Jim Giner jim.gi...@albanyhandball.com wrote: Thanks for the input gentlemen. Two opposing viewpoints! I understand the concept of using files for the docs and a table to locate them and id them. But I am of

Re: [PHP] storing searching docs

2012-12-13 Thread Matijn Woudt
On Thu, Dec 13, 2012 at 5:13 PM, Jim Giner jim.gi...@albanyhandball.comwrote: On 12/13/2012 10:56 AM, Bastien wrote: Bastien Koert On 2012-12-13, at 9:10 AM, Jim Giner jim.gi...@albanyhandball.com wrote: Thanks for the input gentlemen. Two opposing viewpoints! I understand the

Re: [PHP] storing searching docs

2012-12-13 Thread Ashley Sheridan
On Thu, 2012-12-13 at 18:41 +0100, Matijn Woudt wrote: On Thu, Dec 13, 2012 at 5:13 PM, Jim Giner jim.gi...@albanyhandball.comwrote: On 12/13/2012 10:56 AM, Bastien wrote: Bastien Koert On 2012-12-13, at 9:10 AM, Jim Giner jim.gi...@albanyhandball.com wrote: Thanks for

Re: [PHP] storing searching docs

2012-12-13 Thread Bastien Koert
On Thu, Dec 13, 2012 at 12:41 PM, Matijn Woudt tijn...@gmail.com wrote: On Thu, Dec 13, 2012 at 5:13 PM, Jim Giner jim.gi...@albanyhandball.comwrote: On 12/13/2012 10:56 AM, Bastien wrote: Bastien Koert On 2012-12-13, at 9:10 AM, Jim Giner jim.gi...@albanyhandball.com wrote: Thanks

Re: [PHP] storing searching docs

2012-12-13 Thread Jim Giner
On 12/13/2012 2:40 PM, Bastien Koert wrote: On Thu, Dec 13, 2012 at 12:41 PM, Matijn Woudt tijn...@gmail.com wrote: On Thu, Dec 13, 2012 at 5:13 PM, Jim Giner jim.gi...@albanyhandball.comwrote: On 12/13/2012 10:56 AM, Bastien wrote: Bastien Koert On 2012-12-13, at 9:10 AM, Jim Giner

Re: [PHP] storing searching docs

2012-12-13 Thread Jim Giner
Thanks for all the posts. After reading and googling all afternoon, I think the best approach for me is: Create two macros in Word (done!) to export each of my .doc files to .txt and .pdf formats. Create a sql table to hold the .txt contents of my .doc files, along with a reference to the

Re: [PHP] storing searching docs

2012-12-13 Thread Jim Lucas
On 12/13/2012 02:49 PM, Jim Giner wrote: Thanks for all the posts. After reading and googling all afternoon, I think the best approach for me is: Create two macros in Word (done!) to export each of my .doc files to .txt and .pdf formats. Create a sql table to hold the .txt contents of my .doc

[PHP] storing searching docs

2012-12-12 Thread Jim Giner
Slightly off-topic perhaps but I'm looking for general input here. New idea for a project - save the minutes of my firehouse meetings into a mysql table and build a ui to search them for words and such. The docs are written in Word currently. My simplistic idea is to perhaps convert them to

Re: [PHP] storing searching docs

2012-12-12 Thread Paul M Foster
On Wed, Dec 12, 2012 at 01:00:41PM -0500, Jim Giner wrote: Slightly off-topic perhaps but I'm looking for general input here. New idea for a project - save the minutes of my firehouse meetings into a mysql table and build a ui to search them for words and such. The docs are written in Word

Re: [PHP] storing searching docs

2012-12-12 Thread Maciek Sokolewicz
On 12-12-2012 21:03, Paul M Foster wrote: Second, you've hit on one of my pet peeves. Never never store huge blocks of text in SQL files. It slows them down and there's no real reason for it. There's no reason to force a DBMS to schlep around massive clumps of text or binary data. That's what

Re: [PHP] storing searching docs

2012-12-12 Thread Maciek Sokolewicz
On 12-12-2012 21:40, Maciek Sokolewicz wrote: On 12-12-2012 21:03, Paul M Foster wrote: Second, you've hit on one of my pet peeves. Never never store huge blocks of text in SQL files. It slows them down and there's no real reason for it. There's no reason to force a DBMS to schlep around