Previous Topic Next Topic

Android app, SQL database, and QR Codes

Closed
BrianGreen
Posts
1010
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
 - Aug 6, 2018 at 05:15 PM
Ambucias
Posts
47366
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
 - Aug 7, 2018 at 05:43 PM
Ok - a new project in an area have never played with before.

I am trying to build an android app where the user scans a QR code (or a bar code) and then is presented with details about the item scanned from an SQL database that has been pre-prepared. The user should not have any way to change the database. Everything I have seen on google gives users the ability to change the database.

Background about me - I have a little HTML and PHP and minimal SQL experience but nothing about programing an app.

Any ideas of what websites I can go toto help me build this app would be appreciated.
Related:

3 replies

Answer 1 / 3
Blocked Profile
Aug 6, 2018 at 05:21 PM
Set the Back end TO QUERY the DB, not write to it. The SQL statement does this. Use a SELECT statement.

If the platform you are using allows for account control, set the APP to a USER that only has READ ONLY access. Never allow the APP to connect on an account that has full.

Now, if the account is set to read, all the user can do is scrape the data out, and never can alter it.

What platform are you using already?

1
BrianGreen
Posts
1010
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
 145
Aug 6, 2018 at 05:43 PM
Thanks ac3mark,

Im not using anything just yet - this will be my first android app attempt, so I really have no idea what Im doing - in fact I dont even know what language I will be using to build it.
0
Blocked Profile
Aug 6, 2018 at 05:53 PM
OK, well to start off, the APP will just RUN stored procedures, and return the product of those procedures to the device. So, you will need something that will allow STORED procedures. Then you will not have to worry abut the user, as NO STORED procedure will ever WRITE!

SO, so far, you will need a client device (app), and a server to handle web request. The web server will serve the client, and send commands to the DB server. The DB server will run a stored procedure, and send the product (listing) back to the Webserver, who will send it to the client. There is a 10K foot view of the wireframe!
Have FUN!
0
Answer 2 / 3
Ambucias
Posts
47366
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
 11,313
Aug 6, 2018 at 06:11 PM
With all due respect, I suggest that the easiest way to create the app would be to use Android Studio for any type of Android devices.
1
BrianGreen
Posts
1010
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
 145
Updated on Aug 7, 2018 at 09:40 AM
Just took a quick look at that and it looks like its just what I need. I will take a closer look tomorrow and see where it takes me. Hopefully a new plethera of apps will soon be on the market!

I think you get todays beer, but ac3mark also gets one as well. Thank you both fo your help.
0
Ambucias
Posts
47366
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
 11,313 > BrianGreen
Posts
1010
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
Aug 7, 2018 at 05:43 PM
As they pipe and say in the Royal Navy: "Up spirits!"
0
Answer 3 / 3
Ambucias
Posts
47366
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
 11,313
Aug 6, 2018 at 05:38 PM
Greetings Brian

Who would be the potential users and for what purpose ? What kind of business is it? You should give more details, as you explain it, you make it mysterious. Will you app be published on Android ?

How did you manage to inherit this new challenging project for which you have little or no knowledge ?
0
BrianGreen
Posts
1010
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
 145
Aug 6, 2018 at 06:07 PM
Hi Ambucias,

I have recently joined a slimming club and just want a quick way of scanning a barcode when in the shop and seeing how many points the slimming club thinks it has. I know there are hundreds of products out there, but I am hoping the idea might get a little help from some trusted helpers who will be able to advise on food items. It will be destributed for free to the club members.

Currently there is a book which members use to look up the foods they buy, but this requires a lot of pre-shopping planning. This app has the advantage that on the days that you just get in late and need something to eat you can scan what you have in the fridge and count the points easily.

If this works it could be multi-club compatible, but Im starting small and just want this for me at the moment - using the foods I already have in the fridge.
0