I am developing an application (with Cocoa, on Mac OS X, but that's not important), and I have a few questions.
I need to embed a database into my application, and was referred to SQLite. I narrowed down my options to it and PostgreSQL (which I am not completely sure I can embed into an app). One thing that I need to be able to do is regular expression searching, something that PostgreSQL can do, but I don't think SQLite can. What is the best way to work around this?
The only solution that I can see is to keep all of my data in memory. (I expect I'll have upwards of 10,000 records, 1K each on average.) I can do regexp searches there, and use the database for saving the data and simple searches. Although, if the records are already in memory, I might as well search there. But that's more coding for me.
Alternatively, if PostgreSQL can be embedded, it might be a better solution since all searches can be performed by the database.
Has anyone else run into this?
Thanks for your help!
Cheers,
Demitri
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
