Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Using YAML to replace smaller SQL tables?

Symfony has turned me on to the power of YAML. It used to be default for me to use MySQL to make tables for an ecommerce site of say supported_countries,units_of_measure or sku_conditions. But now, I might prefer using YAML to create a config/countries.yml, config/units.yml or config/skuConditions.yml. So I'm curious -- in situations like this are there an significant performance factors to consider when deciding to parse and analyzing a YAML file ~ vs ~ Querying and Analyzing SQL data?

countries.yml

US:
    code: US
    name: United States
CA: 
    code: CA
    name: Canada 

skuConditions.yml

default-unit: new
units
    new:
        short: new
        long: brand spanking new
        description: never been used.
    open-box:
        short: open
        long: pretty much new
        description: the box has been opened but never used.
like image 850
JustinP Avatar asked Dec 09 '25 06:12

JustinP


1 Answers

I think YAML is very suitable for configuration files, that's the way Symfony uses it, but if your data is changing a lot, you need a database. If you are worried about performance think using a NoSQL database like MongoDB.

like image 173
m4t1t0 Avatar answered Dec 10 '25 21:12

m4t1t0



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!