Discussion Forums  >  Plugins, Customizing, Source Code

Replies: 6    Views: 146

Going-Viral
Apple Fan
Profile
Posts: 120
Reg: Jun 13, 2011
Doncaster
1,200
02/03/13 05:53 AM (12 years ago)

SQLite Integration?

I wonder if anyone knows if it is possible to incorporate a SQLite database with BT, possible the inclusion of a search form that could query the database and produce a list of results that when clicking and individual results would open up a dynamic screen with maybe an image and various content from populated database fields? Also a link back to the previous results or redefine query. Any help and advice on this would be much appreciated :-)
 
Niraj
buzztouch Evangelist
Profile
Posts: 2943
Reg: Jul 11, 2012
Cerritos
37,930
like
02/03/13 11:46 AM (12 years ago)
Yes, it is possible, with coding expertise to make your own Plugin. Alternatively, try to "get by" by using the built-in Menu and Search plugins for BuzzTouch. Also, try the Blog plugin, it has a Search box that may span the Title and sub-Title fields. Ask PSMDanny for more insight and look at Black White's apps for real-life examples. https://www.buzztouch.com/plugins/plugin.php?pid=EF1AA98408AA4E656C3F7BD https://www.buzztouch.com/black%20white (Click on Published Apps in left-menu) Here is one of his apps, don't fret if you don't understand Vietnamese. It's about baby food recipes. https://itunes.apple.com/us/app/thuc-on-cho-be/id588207103?mt=8
 
Going-Viral
Apple Fan
Profile
Posts: 120
Reg: Jun 13, 2011
Doncaster
1,200
like
02/04/13 04:31 AM (12 years ago)
I need to add about 90 products and really need a search form with database driven drop down fields to allow users to dynamically reduce their results. Preferably a child update routine, so the first drop down updates the results available for the second dropdown and the second selection updates the third to improve user experience. I would like to know if theyre is any way to use say a blank screen to call other screens generated in xcode external to the BT framework and if somebody could please provide a basic example.
 
ATRAIN53
Code is Art
Profile
Posts: 1755
Reg: Nov 17, 2011
Chicago
26,450
like
02/04/13 08:39 AM (12 years ago)
You don't really 'incorporate' a SQL database into a BT app. Generally you access your SQL data using a script to query and pull data from it. You would then create some type of webpage to display the results. OR You *could* build a customviewcontroller that would parse the results and display them in something like a table or a text view. but you need to build a back end that spits out the results you want and can handle building conditional forms. I'd def use a joomla backend with a mobile optimized/responsive webpage to do this myself. It's a few steps.
 
Going-Viral
Apple Fan
Profile
Posts: 120
Reg: Jun 13, 2011
Doncaster
1,200
like
02/04/13 08:47 AM (12 years ago)
I really need the app to be self contained, as the app will be used in remote rural areas. I actually need to store the users registration details in the app when no cellular or wifi signal is detected and then publish to the web on access to Internet connection.
 
Patuba
Lost but trying
Profile
Posts: 13
Reg: Apr 14, 2013
Lincoln
5,330
like
04/26/13 01:56 PM (12 years ago)
Going-Viral, Did you ever figure out your database/mobile app issue? I am looking at making an App that is really just an information database. Some content will hardly ever get updated, some content will get updated daily. Just curious to how you implemented your database so I can get some ideas.
 
Niraj
buzztouch Evangelist
Profile
Posts: 2943
Reg: Jul 11, 2012
Cerritos
37,930
like
04/26/13 03:06 PM (12 years ago)
A tip for the coder inside you: Do a search for "loadScreenObject" For Google, use site:BuzzTouch.com/forum loadScreenObject That approach will require a server component that will send back a JSON stream in response to URL query from the mobile app. Then the mobile app loads the JSON data into a screen. -- Niraj
 

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.