The best thing about it was all the functions that existed for string manipulation, since every data record was just a big string with demarcations for columns (and values and subvalues, making it technically a 4D database). You could use it to consume nearly any data format and throw together a quick-and-dirty parser in minutes. Really good for rapid proof-of-concepts, but occasionally challenging to maintain data integrity when you have all the rope in the world to hang yourself with.
I miss working with it, compared to SQL which is stupidly rigid and obnoxiously fragile in comparison.
The best thing about it was all the functions that existed for string manipulation, since every data record was just a big string with demarcations for columns (and values and subvalues, making it technically a 4D database). You could use it to consume nearly any data format and throw together a quick-and-dirty parser in minutes. Really good for rapid proof-of-concepts, but occasionally challenging to maintain data integrity when you have all the rope in the world to hang yourself with.
I miss working with it, compared to SQL which is stupidly rigid and obnoxiously fragile in comparison.