Re^2: Comparing large files

Ah, in too much of a hurry...

Turns out I am trying to replace a Postgresql database that already sort of does what I want to do (I created it myself), but I believe that Perl is a far more flexible and powerful tool.

I can store my hashes, I believe, and once I have done that, I can do whatever I want... in my vague ideation.

Any feelings about that? And thanks once again for great help

Comment on Re^2: Comparing large files

Replies are listed 'Best First'.
Re^3: Comparing large files by erix (Prior) on Feb 12, 2014 at 20:54 UTC
I don't really see what you are trying to do but if you mention PostgreSQL: perhaps the hstore data type can help? It's a hash-like data type that is indexable (for read-mostly data use the GIN index). Of course, perl hashes will be much faster if memory serves ;-)	[reply]
Re^3: Comparing large files by wjw (Priest) on Feb 13, 2014 at 09:33 UTC
If your words are in your data base already along with your pronunciations, then your job just got much easier. I am just guessing here, as I don't know the db schema you have... The approach remains the same whether you decide to use the DB or not. A database view will give you a long term solution. Combine that with Perl and you can do anything you want very quickly... Based on your last post, you have found what you were looking for which is what counts! Have a good one... ...the majority is always wrong, and always the last to know about it... Insanity: Doing the same thing over and over again and expecting different results.	[reply]