How to implement in Android (in Java) work with data on a product in a supermarket?

Question

Java

New to Java. Please advise on the best way to do the following. For example, you need to create a program for Android where it will get access to a file with prices, barcodes, product names, etc. etc. to all data uploaded to the supermarket checkout.

Next, you need to be able to scan the barcode from the product in the store and find all the necessary information about the product, which is in the file.

Actually a question. Prompt the algorithm of the program:

- I get access through the Internet to the file. For example, Pos.spr with such an entry (484; 4600851007447; Mayonnaise Moscow Provence Classic 750ml; Mayonnaise Moscow Provence Classic 75; 85.00; 326.000;; 0; 2; 0; 51;; 0; 1; 0; 263; 1;; 0)

- is it worth loading the data into a SQL database for example? Or can work directly with the file?

I do not quite understand how to implement getting data from a file every time when scanning. so that the price and other information on the product immediately appear on the smartphone. There is a lot of information, it is not only the price and name, but also a bunch of other fields.
You can suggest the whole algorithm for processing this information.
Thank you in advance.

Answer 1

I think SQLite will be the best solution developer.alexanderklimov.ru/android/sqlite
To work with codes, you need to study what is better to take for recognition: https://developers.google.com/vision/android/barco... or something else.
To begin with, debug reading the codes and displaying the form with the fields and the code read. And then screw the base.

Answer 2

The database should be used if you are in a warehouse and your mobile phone does not catch, in all other cases it is better to use the api of your system. On mobile you just access the rest api