Barcode and Database

[esad18 (m.esad)]

@Boban

Well, If you had mentioned this from the beginning that it will be 25000, 50000, 100000 then I would advise you to do it in a different way…

I didnt know about this anything sorry @Boban So i cant change this DB when i use like that. So i need to add other rows with that.

@Boban

Perhaps using SQLite component, you might want to search the community about SQLite

Most of the people advice to me. So i will try with that. But i need to use that app with like that database now. So i need to increase DB size. Can u help me about it.

@Boban

P.S. Putting 100.000 rows instantly in list/db might overwhelm any device, thereby either read mutiple files or from the big file read 5000 lines at a time…

@esad18

-Also my .csv file is seperate with semicolon(; ) Because my database have comma(,) so i need to seperate with semicolon(; ) How can i do i dont know its not basically.

Can u help me about these? I didnt find anything.

[Rogerio_Rios (Professional Support)]

You need to export your data to an SQL database.

[esad18 (m.esad)]

I will do it still. I need to time for doing SQL. How can i integrate SQL to the project? Because The project is very usefull.

[Rogerio_Rios (Professional Support)]

SQL is the language. Sqlite and Mysql are Relational databases that use SQL. Locally you will use Sqlite. On the web you will use MySQL. In the community there are 2 examples without extension. These examples use PHP Scripts + Kodular Blocks.

MySQLi. PHP. GET. POST. Insert. Update. Delete. Segur SQL Inject

Hello friends, I have published a basic tutorial on MySQLi and PHP in the App Inventor Community, I think it is better to put a link in this forum so as not to repeat the same thing. The tutorial deals with 3 examples: 1.- MySQLi + PHP + GET 2.- MySQLi + PHP + POST 3.- MySQLi + PHP + Web page In these examples I use the 000webhost server. The forum link is: I have also put it in Spanish: App inventor. App inventor y MySQLi. PHP. GET. POST. Página web. Base de datos [mysqlwebhost9] …

https://puravidaapps.com/mysql.php

And there is a paid extension.

MySQL Extension - Call Sql Operations Without Script [PAID]

MySQL Extension This extension allows you to call Sql operations without using any script. This can connect to the MySQL Database with it’s url,username and password. It would connect to the server directly with JDBC, there won’t be any kind of third party interfering in the connection, the connection is directly between Your Application And The MySQL Server. [jdbc] Image From : JDBC Tutorial There is one more specialty of this extension, It supports prepared statement block to prevent Sql …

[esad18 (m.esad)]

Thanks @Rogerio_Rios

I created my .db file. I learn something. I need to how to import and read this without any price So can you help me for this. I didnt understand nothing at the forum topics.

Can someone say me this;
If u have a .db file how can u import this file in kodular and how can u read, search with id this data.

[esad18 (m.esad)]

Hey @Boban when i try to make new app can u help me for ur created project with .csv
I just want to ask that; If my file like that

barcode | text1 | text2 | number1 | number2 | number3
987654321987 | first text | second text | 25,88 | 25,21 | 23,65
987654321986 | first text1 | second text1 | 55,54 | 65,47 | 73,77
987654321985 | first text | second text | 25,32 | 25,61 | 63,25
123456 | first text1 | second text1 | 55,45 | 75,96 | 63,33
…
.
.

How can i seperate csv commas and commas of my file?
I save .csv with ;

Also Can you say me how to increase 5000 rows than more.
Can you help me for this?

[esad18 (m.esad)]

Hey @Boban

First of all thanks for your all supports. I have really good project thanks to you.
But i have some problems. Also u know im new here.
I’m really waiting a reply from you. If you dont want to continue to help please say me this.
I wont wait anymore.
I’m looking here everyday almost 10 times or more. If i can do it. I didnt say these to you. But i didnt anything the problems.
Please say me.

Thanks for all.