Board Thread:The Last Sovereign Discussion/@comment-25881556-20171217124902/@comment-29984007-20180208183606

DukeLeto7 wrote: OK, as I was saying, a single unary CSV file is easy to maintain, but it doesn't do a very good job of representing complex data with many to many or one to many relationships   In the case of DropItems, it looks like RPG Maker limits you to 3 per enemy, but there are an arbitrary number of status and element resistances and weaknesses for each enemy, which might pose a problem for more complex bosses if we are limiting ourselves to a few columns of csv. Same with the enemy action collection.

Here's a copy of the data I've pulled out of RPGMaker for you to peruse so you can see how much info I'm trying to mash. (it's in pipe delimited instead of comma delimited text files, for reasons.)

http://s000.tinyupload.com/index.php?file_id=96090363293297140107

a csv can be the size you needed. (i handled not a long time ago a 45 column * 350000 rows, yes four zeros)

and my idea wasn't a single csv for all the table, but one csv for one table. if you don't need extra dimension any 2D data can be stored in a csv.

if you want implement some advance feature the file can be import in nearly any DB program effortless.