Re^2: Comparing large files

[Herbert37]

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

[erix]

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 ;-)

[wjw]

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...