Discussion Forums  >  Self Hosted Control Panels

Replies: 9    Views: 155

teqbean
Code is Art
Profile
Posts: 119
Reg: Jan 01, 2012
Atlanta, GA
3,340
03/13/12 10:23 PM (13 years ago)

Database Records

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?
 
David @ buzztouch
buzztouch Evangelist
Profile
Posts: 6866
Reg: Jan 01, 2010
Monterey, CA
78,840
like
03/13/12 10:28 PM (13 years ago)
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.
 
teqbean
Code is Art
Profile
Posts: 119
Reg: Jan 01, 2012
Atlanta, GA
3,340
like
03/13/12 11:16 PM (13 years ago)
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?
 
David @ buzztouch
buzztouch Evangelist
Profile
Posts: 6866
Reg: Jan 01, 2010
Monterey, CA
78,840
like
03/13/12 11:32 PM (13 years ago)
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!
 
teqbean
Code is Art
Profile
Posts: 119
Reg: Jan 01, 2012
Atlanta, GA
3,340
like
03/13/12 11:47 PM (13 years ago)
Oh I see much fun in the future with this amazing tool!
 
teqbean
Code is Art
Profile
Posts: 119
Reg: Jan 01, 2012
Atlanta, GA
3,340
like
03/13/12 11:59 PM (13 years ago)
Already cleaned up DB and scripted adding one hundred screens. I love it!
 
David @ buzztouch
buzztouch Evangelist
Profile
Posts: 6866
Reg: Jan 01, 2010
Monterey, CA
78,840
like
03/14/12 12:06 AM (13 years ago)
Whoo hoo. Done for the night, plane for Los Angeles leaves in 5 hours - yikes!
 
Marko
buzztouch Evangelist
Profile
Posts: 558
Reg: May 04, 2011
UK, Alcester
8,880
like
03/14/12 03:50 AM (13 years ago)
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
 
teqbean
Code is Art
Profile
Posts: 119
Reg: Jan 01, 2012
Atlanta, GA
3,340
like
03/17/12 10:51 AM (13 years ago)
After a bit of playing, I am now adding all of my screens directly in the DB. ;-) Thank you!
 
mrDavid
BTMods.com
Profile
Posts: 3936
Reg: May 21, 2011
San Diego, CA
51,910
like
06/23/12 10:18 AM (13 years ago)
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
 

Login + Screen Name Required to Post

pointerLogin to participate so you can start earning points. Once you're logged in (and have a screen name entered in your profile), you can subscribe to topics, follow users, and start learning how to make apps like the pros.