Thread

I’ve started to get into learning SQL to get at the data in EE and it’s amazing what can be done (I’m easily impressed obviously!)

Now I wonder if anyone uses SQL to build their sites in as far as field groups, custom fields, status groups, categories, template groups, templates (not the html content) and weblogs go?

I haven’t tried it yet but I have a crazy idea of just using an Excel spreadsheet to plan the site structure then chucking it into phpMyAdmin (Field, Category and Status Groups first).

Is this feasable/dangerous/impossible?

Now I wonder if anyone uses SQL to build their sites in as far as field groups, custom fields, status groups, categories, template groups, templates (not the html content) and weblogs go?

Well, it’s easy to get carried away there. Really, EE does the same things, internally, so if you can make do with EE tags you probably should. For everything else, yes, a raw SQL query every now and then has saved my day more than once 😊

Ah I don’t want to start coding in pure SQL! I was just thinking in terms of reducing the number of clicks when starting a fresh install of EE. You know, when you create weblogs and template groups etc.

The SQL I did on the mentioned site was to replace some crappy nested relationships. Couldn’t have done it without SQL!

Ah, right. Well, EE 2 will change things there quite a bit, but for now, perhaps this article helps?