Geek Answers Handbook

Umbraco Database - Adding Custom Tables

I am working on a website managed by Umbraco. I need to store image and client data. I do not think that I can store this data in existing tables.

Is there any reason why I should not add the tables that I need for the Umbraco database, and not create a separate database? I like Umbraco, but the documentation is a bit thin and I have not found any suggestions anyway.

TIA

+6
database umbraco
source share
2 answers

I built the site using Umbraco, with a separate application with a database of vehicles. I used the same database as Umbraco and prefixed all of my custom application tables with a few letters to make them easy to distinguish (ex: vehicles_xxx)

I had no problems with this agreement, and I do not think that there is a big risk. Of course, you need to take care to update Umbraco (never update the environment live to full testing and, preferably, do it locally), but it is unlikely that the script update will ever change or delete any tables, to know.

There heaps of doco are available for umbraco now - much more than when I started .. however, such a question is always better for forums. :)

all the best greg

+13
source share

You can use the Umbraco API to store and retrieve your data and enjoy the ease of not having to worry about tables and more. Or you create your own tables. Do as Gregorius says - with umbraco db, everything is fine.

Your choice depends on:

  • Do you have a lot of data?
  • Do you have a great relationship model?

If not, then go with the Umbraco API

The remaining answers can be found at http://our.umbraco.org

/ Jesper Ordrup

+5
source share

More articles:


All Articles