B
@asuffield said:I do not think that you desire a relational database, so it puzzles me as to why you are thinking about using one. If there is genuinely no reason for it, as there appears not to be, then it would be a WTF.It's hard to guess without knowing what you're really doing, but this smells like an attempt to simulate a flat file using a relational database. That's just nuts.The MySQL database is already being used to drive the rest of the website, so it seemed reasonable to store the data there. The alternative was to create a directory somewhere containing thousands of files named 1.dat, 2.dat, etc, and then 1) query the database to find what file to open and 2) open the file.@death said:Why don't you store WHOLE tabular data coming from
Jade in Mysql and serve as needed? I see it so: Jade generates the
data, Insets it into MySQL in Lapis, and Lapis takes care of the
presentation? Nice, clean and pornfree... The MySQL database is not remotely accessible, and the servers are in two entirely separate locations connected only by the public internet. I'm encrypting the data using GnuPG, and don't know enough about MySQL's encryption to trust it.@robbak said:Go Back. Back to before the data becomes "text
"[1,2,3,4],[5,6,7,8]" " Then you will find data in a nice, not WTFery
way. Store that. If not, then parse that text back into the nice
integers and store them. A table with 5 array(int)[4]s perhaps. It does
depend on what those numbers represent, and how they are used.The bracket encoding is just for transmission between the servers, and because it can be easily parsed by the server. There's no guarantee that the data will all be the same size - there might be cases where it has 20 tuples of 2 values each, or 1 tuple of 200 values. I also don't understand what you mean by "array(int)[4]" - can't MySQL only store single values?