Kodular and Database

[Andre_Silva1 (André Silva)]

Guys,

I need to create an application where it already has information in it, with rows and columns and then the user just performs several filters to find a desired row, how can I do this in Kodular offline? I don’t want the user to enter 450 lines, he should already install this database with the app.

Thank´s

[Rogerio_Rios (Professional Support)]

With Sqlite

[Rogerio_Rios (Professional Support)]

Maybe this

Update Sqlite Database in my app

hi i am developing an app and i use sqlite. My application requires to work without internet, that is why I have it locally and then when there is internet I send the database to a google drive. When I start the application I verify connection and download the database, this database must be joined with the existing one (It may contain different data). I tried to import the downloaded database into a sqlite2 and rename the tables and then import them into the sqlite1, but Importing…

Or Sqlite Extension PAID…

Or import from Mysql …

Or …

How to insert a list in SQlite database

Output list to csv, then

And…Maybe one This Extensions

Four working examples SQLite Extension

Four working examples SQLite Extension [Four working examples SQLite Extension] https://puravidaapps.com/sqlite.php SQLite_Taifun.apk (4.9 MB) [SQLite_Taifun_blocks] SQLite_Bennedum.aia (78.6 KB) SQLite_Bennedum.apk (5.0 MB) [SQLite_Bennedum_blocks] SQLite_Pedroza.aia (30.3 KB) SQLite_Pedroza.apk (4.9 MB) [SQLite_Pedroza_blocks] SQLite_Kodular.aia (9.4 KB) SQLite_Kodular.apk (4.9 MB) [SQLite_Kodular_blocks] [SQLite]

[Andre_Silva1 (André Silva)]

Thank´s @Rogerio_Rios

But how can I enter the data all at once at app build time, would you have an example?

I don’t want to install multiple apps on cell phones and enter the 450 pieces of information every time.

[sherif (Sherif Hassan)]

@Rogerio_Rios
First of all, thank you
@Rogerio_Rios for your great efforts and thanks for all kodular team for their cooperation and efforts .
After I confirmed by experience that the firebase database will cost our apps a lot of money after users started using my apps and after searching in the kodular community and reading your suggestions for using SQL as a database I did the research And I learned how to use it. But since I used it I can’t extract apk file from my project I always get this error message
NOTE : I am using deephost extension Mysql database

Kodular is unable to compile this project.
The compiler error output was

AAPT time: 1.012 seconds

DX time: 12.937 seconds
________Invoking ApkBuilder
com.android.sdklib.build.ApkCreationException: Failed to add /tmp/1641586233301_0.5654811647941806-0/youngandroidproject/…/build/tmp/classes3.dex
YAIL compiler - ApkBuilder failed.
.

[Taifun]

@Andre_Silva1

But how can I enter the data all at once at app build time, would you have an example?

Just import your initial database from the assets on first run of the app.
You will need a sqlite extension, which offers an import method… for example this one App Inventor Extensions: SQlite | Pura Vida Apps

Taifun