Database Design | PHP-Mysql | JSON

[rajpri...@gmail.com]

Hi,

I am developing an application using F3 in which report generation is a sub-app.
Now i have the reports in the form of json data which will be large.

Problem is that, JSON data is in multiple levels and difficult to define schema for it.

Now, any suggestion on how i should store the JSON, as file? or in mysql database as blob or text?

Note: I would JSON data only to generate report (PDF, Excel etc) . I never modify it.

I know that this is very slightly related to F3, but i'm really in a dilema. Please help.

Thank you,
Sash.

[Jerry Stuckle]

If you want to use a database, define the appropriate schema for it.
It's always the best way to go. You may not have plans to do anything
with it NOW - but those plans change. I've seen it happen too many
times (and every one of them had said "No, we'll never want to ...").

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstu...@attglobal.net
==================

[rajpri...@gmail.com]

@jerry

Thank you.

I think you are right.

Is there any tool you know of that can suggest database schema basing on json structure?

[Jerry Stuckle]

No, and if there were you almost certainly wouldn't get the correct
results. It would be virtually impossible for a program to properly
normalize a database just from data.

Database design isn't that hard once you've done it a few times. Study
up on database normalization and try it out.