In BT 2.0 Server, I have a screen that I have deleted, can I delete The record in BT_Items to cleanup my database? Is there anything else related to a single screen?

Ah, good question. No, you'll be fine. It's a pretty tidy / simple database on purpose. The records are darned near independent of any other table so you should be OK to remove them. Keep on thing in mind: Some BT items may have childItems. Example: Menus have childItems for menu choices, buttons do to. Maps have locations. The relationship is like this: Screen: The screen itself (the map for example) is considered the Parent Item. Child Item: Child items (map locations in this example) have the parentItemGuid (I think thats the column, not looking so don't rely on exact name) from the parent screen. This design allows all of the assets for an app to kept in one list. Just know that if you delete an item that has childItem then those items will become orphaned.

Thank you, that's what I thought from my investigation but wanted to confirm. So I could use the reverse logic to also insert screens into the DB as well I presume?

Totally! There are a few folks using a totally different method to create apps. Think of it this way.. You could implement whatever logic you need to insert the records..like for example an HTML form on your site could populate a menu of options in your app, whatever. Skies the limit. You could also customize the logic you use to call the buzztouch.com API to package your apps. In other words, the control panel isn't necessary to do this kind of thing. For most folks these concepts are out of reach but for some it's super fun to try to extend on the idea. In essence, you could load the API URL in the address bar of your browser (with the credentials included in the URL) and the API would return to you the URL for the app's iOS or Android package. We'll eventually get all the available API calls documented. Some day!

Oh I see much fun in the future with this amazing tool!

Already cleaned up DB and scripted adding one hundred screens. I love it!

Whoo hoo. Done for the night, plane for Los Angeles leaves in 5 hours - yikes!

Divert to the UK and enjoy rain and a starbucks via a unhappy worker. Coffee's on me. Who need the beautiful sun and bodies of LA when you can have rain and surley service in the UK

After a bit of playing, I am now adding all of my screens directly in the DB. ;-) Thank you!

teq, be sure to back up your database if your doing heavy modding. I just made a one click tool that makes it easy to backup your self hosted server. :) http://www.buzztouch.com/forum/thread.php?tid=6C3F7BE489E3A4E3AE7834E Cheers! David buzztouchmods.com