2012-05-21, 23:37:30
glennmaples Wrote:shawn_a Wrote:N00dles, Matrix plugin should be able to do this. Its still alpha release.
... wait
"up to 50k lines"
sql scripts that are 50k lines?
Is this per record ?
Seems like you need something more powerful than a non db web app if that's the case.
really -- 50 K lines of create, select into, create select... I kid you not, but most are 2K lines or shorter. I was looking at code repository tools, but could not find a great match. Thank you all for the suggestions; I will check them out. Really, I don't need to use XML -- but need the ability to store text, search the text, create own meta data schema and be able to search it. I just thought XML was the most obvious way. Thanks again, everyone!!!!!
Any query that does that much stuff or is that large should be a stored procedure in your database anyway.
I would give the matrix plugin a try at least,
You could use it to simply store a filename as key with any other meta data, and keep your snippets in your own files. Then just do whatever you want with the files externally.